public JsonResult Save(Wjgz model) { ReturnModel returnModel; if (model.ID.Equals(0)) { returnModel = wjgzService.Insert(model); return(Json(returnModel, JsonRequestBehavior.AllowGet)); } returnModel = wjgzService.Update(model); return(Json(returnModel, JsonRequestBehavior.AllowGet)); }
public JsonResult AddOrEdit(int id = 0) { try { Wjgz gz = new Wjgz(); if (id > 0) { gz = wjgzService.GetEntity(id); } return(Json(new ReturnModel { Code = 200, Msg = "Success", Result = gz })); } catch (Exception e) { return(Json(new ReturnModel { Code = 201, Msg = "获取标签失败" })); } }
/// <summary> /// 修改 /// </summary> /// <returns></returns> public ReturnModel Update(Wjgz model) { try { if (string.IsNullOrWhiteSpace(model.GZMC)) { return(new ReturnModel { Code = 201, Msg = "规则名称不能为空" }); } StringBuilder sbSql = new StringBuilder(); using (IDbConnection conn = new DapperConnection().DbConnection) { var transaction = conn.BeginTransaction(); try { //判断标签存在 sbSql.Append("SELECT * FROM WJ_GZ WHERE ID=@ID AND SFQY=1"); Wjgz existModel = conn.QueryFirstOrDefault <Wjgz>(sbSql.ToString(), new { ID = model.ID }, transaction); if (existModel == null) { return(new ReturnModel { Code = 201, Msg = "规则不存在" }); } //判断重名 sbSql.Clear(); sbSql.Append("SELECT * FROM WJ_GZ WHERE ID<>@ID AND GZMC=@GZMC AND SFQY=1"); Wjgz sameName = conn.QueryFirstOrDefault <Wjgz>(sbSql.ToString(), model, transaction); if (sameName != null) { return(new ReturnModel { Code = 201, Msg = "存在相同名称的规则" }); } //保存更新 sbSql.Clear(); sbSql.Append("UPDATE WJ_GZ SET GZMC = @GZMC, ZXNL = @ZXNL, ZDNL = @ZDNL, XB=@XB WHERE ID = @ID;"); sbSql.Append("DELETE FROM WJ_GZMX WHERE GZID = @ID;"); conn.Execute(sbSql.ToString(), model, transaction); if (!string.IsNullOrWhiteSpace(model.XZBQ)) { List <string> lstBq = model.XZBQ.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList(); foreach (var item in lstBq) { sbSql.Clear(); sbSql.Append("INSERT INTO WJ_GZMX(GZID, BQID) VALUES(@GZID, @BQID)"); conn.Execute(sbSql.ToString(), new { GZID = model.ID, BQID = item }, transaction); } } transaction.Commit(); return(new ReturnModel { Code = 200, Msg = "保存成功" }); } catch (Exception e) { transaction.Rollback(); Log.WriteLog(e.Message); return(new ReturnModel { Code = 201, Msg = "保存失败" }); } } } catch (Exception e) { Log.WriteLog(e.Message); return(new ReturnModel { Code = 201, Msg = "保存失败" }); } }
/// <summary> /// 插入 /// </summary> /// <param name="model"></param> /// <returns></returns> public ReturnModel Insert(Wjgz model) { try { //验证参数 if (string.IsNullOrWhiteSpace(model.GZMC)) { return(new ReturnModel { Code = 201, Msg = "规则名称不能为空" }); } //保存 StringBuilder sbSql = new StringBuilder(); using (IDbConnection conn = new DapperConnection().DbConnection) { var transaction = conn.BeginTransaction(); try { //判断重名 sbSql.Append("SELECT * FROM WJ_GZ WHERE GZMC=@GZMC and SFQY=1"); Wjgz sameName = conn.QueryFirstOrDefault <Wjgz>(sbSql.ToString(), model, transaction); if (sameName != null) { return(new ReturnModel { Code = 201, Msg = "存在相同名称的规则" }); } sbSql.Clear(); model.SFQY = 1; sbSql.Append("INSERT INTO WJ_GZ(GZMC, ZXNL, ZDNL, SFQY, XB) VALUES (@GZMC, @ZXNL, @ZDNL, @SFQY, @XB);select @@IDENTITY"); int gzid = Convert.ToInt32(conn.ExecuteScalar(sbSql.ToString(), model, transaction)); if (!string.IsNullOrWhiteSpace(model.XZBQ)) { List <string> lstBq = model.XZBQ.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList(); foreach (var item in lstBq) { sbSql.Clear(); sbSql.Append("INSERT INTO WJ_GZMX(GZID, BQID) VALUES(@GZID, @BQID)"); conn.Execute(sbSql.ToString(), new { GZID = gzid, BQID = item }, transaction); } } transaction.Commit(); return(new ReturnModel { Code = 200, Msg = "保存成功" }); } catch (Exception e) { transaction.Rollback(); Log.WriteLog(e.Message); return(new ReturnModel { Code = 201, Msg = "保存失败" }); } } } catch (Exception e) { Log.WriteLog(e.Message); return(new ReturnModel { Code = 201, Msg = "保存失败" }); } }