public IHttpActionResult Update(InputSysTypeModel model)
{
try
{
if (string.IsNullOrWhiteSpace(model.Name))
{
//返回错误
return(JsonResultHelper.JsonResult(1000, "名称不能为空"));
}
else
{
var info = dbContext.BA_SysEnType.FirstOrDefault(p => p.Id == model.Id);
if (info == null)
{
LogHelper.WriteLog("该类型已不存在,请刷新！");
return(JsonResultHelper.JsonResult(1000, "该类型已不存在,请刷新！"));
}
else
{
//首先删除中间表中这个类型数据
//var confirm = dbContext.KS_Confirm.Where(p => model.Id == p.TypeId);
//dbContext.KS_Confirm.RemoveRange(confirm);
//dbContext.SaveChanges();
LogHelper.WriteLog("父类");
decimal par = 1;
if (model.IdParent != 0)
{
par = model.IdParent;
}
string sql = $"DELETE FROM KS_Confirm WHERE TypeId={model.Id}";
dbContext.Database.ExecuteSqlCommand(sql);
LogHelper.WriteLog("父类2");
info.IdParent = par;
info.Memo = model.Memo;
info.Name = model.Name;
dbContext.SaveChanges();
//新增类型人员维护
if (model.PersonList != null)
{
foreach (var item in model.PersonList)
{
dbContext.KS_Confirm.Add(new KS_Confirm
{
IdPerson = item,
TypeId = info.Id
});
dbContext.SaveChanges();
}
}
LogHelper.WriteLog("父类3");
return(JsonResultHelper.JsonResult(0, "修改成功"));
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.Message);
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult Add(InputSysTypeModel model)
{
try
{
if (string.IsNullOrWhiteSpace(model.Name))
{
//返回错误
return(JsonResultHelper.JsonResult(1000, "名字必填"));
}
else
{
if (dbContext.BA_SysEnType.Any(p => p.Name == model.Name))
{
return(JsonResultHelper.JsonResult(1000, "该类型已存在"));
LogHelper.WriteLog("该类型已存在");
}
else
{
//LogHelper.WriteLog("父级Id："+model.IdParent);
decimal par = 1;
if (model.IdParent != 0)
{
par = model.IdParent;
}
string sql = string.Format("INSERT dbo.BA_SysEnType(IdParent, Name, Memo )VALUES ({0},'{1}','{2}')", par, model.Name, model.Memo);
LogHelper.WriteLog("到底啥原因");
dbContext.Database.ExecuteSqlCommand(sql);
var info = dbContext.BA_SysEnType.FirstOrDefault(p => p.Name == model.Name);
//新增类型人员维护
if (model.PersonList != null)
{
foreach (var item in model.PersonList)
{
dbContext.KS_Confirm.Add(new KS_Confirm
{
IdPerson = item,
TypeId = info.Id
});
dbContext.SaveChanges();
}
}
return(JsonResultHelper.JsonResult(0, "添加成功"));
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
return(JsonResultHelper.JsonResult(1000, ex.Message, ex));
}
}
