public int UpdateCategory(XXF.Db.DbConn PubConn, Models.DbModels.appcategory model)
{
model.categorydesc = model.categorydesc ?? "";
string sql = "update appcategory set categorytitle=@categorytitle,categorydesc=@categorydesc where apptype=@apptype and categoryid=@categoryid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@categoryid", model.categoryid);
para.Add("@categorytitle", model.categorytitle);
para.Add("@categorydesc", model.categorydesc);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
public JsonResult Edit(Models.DbModels.appcategory model)
{
if (string.IsNullOrEmpty(model.categorytitle))
{
return(Json(new { code = -1, msg = "分类名称不能为空" }));
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
try
{
if (model.categoryid < 1)//添加
{
int r = Models.AppcategoryDal.Instance.Addcategory(PubConn, model);
if (r > 0)
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "新增失败，原因不明" }));
}
}
else//修改
{
int r = Models.AppcategoryDal.Instance.UpdateCategory(PubConn, model);
if (r > 0)
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "修改失败，原因不明" }));
}
}
}
catch (Exception ex)
{
return(Json(new { code = -1, msg = ex.Message }));
}
finally
{
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "修改应用分类";
Models.CertCenterLogDal.Instance.Add(PubConn, log);
}
}
}
public int Addcategory(XXF.Db.DbConn PubConn, Models.DbModels.appcategory model)
{
model.categorydesc = model.categorydesc ?? "";
string getcatid = "select isnull(max(categoryid),0)+1 from appcategory where apptype=" + model.apptype;
model.categoryid = Convert.ToInt32(PubConn.ExecuteScalar(getcatid, null));
string addsql = "insert into appcategory(apptype,categoryid,categorytitle,categorydesc) values(@apptype,@categoryid,@categorytitle,@categorydesc)";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@categoryid", model.categoryid);
para.Add("@categorytitle", model.categorytitle);
para.Add("@categorydesc", model.categorydesc);
int r = PubConn.ExecuteSql(addsql, para.ToParameters());
return(r);
}
public JsonResult GetApiCategoryInfo(int apptype, int categoryid)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.appcategory model = Models.AppcategoryDal.Instance.GetCategoryInfo(PubConn, apptype, categoryid);
if (model == null)
{
return(Json(new CertComm.ServerResult()
{
code = -1, msg = "无查项"
}));
}
return(Json(new CertComm.ServerResult()
{
code = 1, msg = "", response = model
}));
}
}