public IActionResult AddorUpdate(sys_code_catgory model)
{
//实例化基础数据分类接口
var Catgory = this.GetInstance <ISys_Code_Catgory>();
//查询基础数据分类列表
var result = Catgory.AddorUpdate(model)?.Result;
return(Json(result));
}
/// <summary>
/// 新增或者修改基础数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Task <ResponseModel> AddorUpdate(sys_code_catgory model)
{
return(Task.FromResult(this.Logic.AddorUpdate(model)));
}
/// <summary>
/// 新增或者修改基础数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ResponseModel AddorUpdate(sys_code_catgory model)
{
//待返回对象
var result = new ResponseModel(ResponseCode.Error, "保存基础数据分类失败!");
var msg = "";
var row = 0;
try
{
using (var db = new DbContext())
{
//判断分类名称是否存在
var dataList = db.Select("sys_code_catgory").Columns("id").Where("name", model.name).GetModelList <sys_code_catgory>();
//验证动态表名是否存在
var dataList2 = new List <sys_code_catgory>();
if (!string.IsNullOrEmpty(model.ref_table))
{
dataList2 = db.Select("sys_code_catgory").Columns("id").Where("ref_table", model.ref_table).GetModelList <sys_code_catgory>();
}
if (model.id.IsNullOrEmpty())
{
var guid = Guid.NewGuid().ToString();
model.id = guid;
if (dataList != null && dataList.Any())
{
msg = "分类名称重复,";
}
if (dataList2 != null && dataList2.Any())
{
msg += "动态表名重复,";
}
if (!string.IsNullOrEmpty(msg))
{
msg = msg.Substring(0, msg.Length - 1);
result.msg = msg;
return(result);
}
row = db.Insert("sys_code_catgory").Column("id", model.id).Column("parent_id", model.parent_id).Column("name", model.name).Column("describe", model.describe).Column("ref_table", model.ref_table).Column("stdd_code", model.stdd_code).Column("stdd_source", model.stdd_source).Column("status", model.status).Column("update_time", DateTime.Now).Execute();
}
else
{
//判断分类名称是否存在
if (dataList != null && dataList.Any(d => d.id != model.id))
{
msg = "分类名称重复,";
}
if (dataList2 != null && dataList2.Any(d => d.id != model.id))
{
msg += "动态表名重复,";
}
if (!string.IsNullOrEmpty(msg))
{
msg = msg.Substring(0, msg.Length - 1);
result.msg = msg;
return(result);
}
row = db.Update("sys_code_catgory").Column("parent_id", model.parent_id).Column("name", model.name).Column("describe", model.describe).Column("ref_table", model.ref_table).Column("stdd_code", model.stdd_code).Column("stdd_source", model.stdd_source).Column("status", model.status).Column("update_time", DateTime.Now).Where("id", model.id).Execute();
}
if (row == 1)
{
result.msg = "保存成功";
result.code = (int)ResponseCode.Success;
return(result);
}
}
}
catch (Exception ex)
{
Logger.Instance.Error("保存基础数据分类失败", ex);
result.msg = "服务器内部异常";
}
return(result);
}
