public JsonResult GetAppGradeInfo(int apptype, int appgradeno)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.appgrade model = Models.AppGradeDal.Instance.GetGradeInfo(PubConn, apptype, appgradeno);
if (model == null)
{
return(Json(new { code = -1, msg = "不存在此等级信息。" }));
}
return(Json(new { code = 1, response = model }));
}
}
public int UpdateGrade(XXF.Db.DbConn PubConn, Models.DbModels.appgrade model)
{
model.appgradedesc = model.appgradedesc ?? "";
string sql = "update appgrade set appgradename=@appgradename,appgradedesc=@appgradedesc where apptype=@apptype and appgradeno=@appgradeno";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@appgradeno", model.appgradeno);
para.Add("@appgradename", model.appgradename);
para.Add("@appgradedesc", model.appgradedesc);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
/// <summary>
/// 添加或修改 如果appgradeno >0 ，则为修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult Edit(Models.DbModels.appgrade model)
{
if (string.IsNullOrEmpty(model.appgradename))
{
return(Json(new { code = -1, msg = "分类名称不能为空" }));
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
try
{
if (model.appgradeno < 1)//添加
{
int r = Models.AppGradeDal.Instance.AddGrade(PubConn, model);
if (r > 0)
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "新增失败，原因不明" }));
}
}
else//修改
{
int r = Models.AppGradeDal.Instance.UpdateGrade(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 AddGrade(XXF.Db.DbConn PubConn, Models.DbModels.appgrade model)
{
model.appgradedesc = model.appgradedesc ?? "";
string getcatid = "select isnull(max(appgradeno),0)+1 from appgrade where apptype=" + model.apptype;
model.appgradeno = Convert.ToInt32(PubConn.ExecuteScalar(getcatid, null));
string addsql = "insert into appgrade(apptype,appgradeno,appgradename,appgradedesc) values(@apptype,@appgradeno,@appgradename,@appgradedesc)";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@appgradeno", model.appgradeno);
para.Add("@appgradename", model.appgradename);
para.Add("@appgradedesc", model.appgradedesc);
int r = PubConn.ExecuteSql(addsql, para.ToParameters());
return(r);
}
