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 = "保存失败"
});
}
}
