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