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); }