public bool DelQualityInfo(string checkCode, int AccountID, QualityInfo entity, ref string ErrMsg)
{
if (!CheckingCheckCode(checkCode, AccountID, ref ErrMsg))
return false;
if (entity == null)
{
ErrMsg = "品质信息为空";
return false;
}
QualityInfo _tmp = entities.QualityInfoes.FirstOrDefault(p => p.ID == entity.ID);
if (_tmp == null)
{
ErrMsg = "该品质信息不存在或已删除";
return false;
}
try
{
entities.QualityInfoes.Remove(_tmp);
if (entities.SaveChanges() <= 0)
{
ErrMsg = "删除失败";
return false;
}
return true;
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return false;
}
}
public bool AddQualityInfo(string checkCode, int AccountID, QualityInfo entity, ref string ErrMsg)
{
if (!CheckingCheckCode(checkCode, AccountID, ref ErrMsg))
return false;
if (entity == null)
{
ErrMsg = "品质信息为空！";
return false;
}
if (string.IsNullOrWhiteSpace(entity.Name))
{
ErrMsg = "品质信息为空";
return false;
}
//if (entities.QualityInfoes.Any(p => p.Name == entity.Name))
//{
// ErrMsg = "当前品质名已在该工序下存在";
// return false;
//}
// entity.CreateDt = DateTime.Now;
try
{
entities.QualityInfoes.Add(entity);
if (entities.SaveChanges() <= 0)
{
ErrMsg = "添加失败";
return false;
}
return true;
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return false;
}
}
public bool ModifyQualityInfo(string checkCode, int AccountID, QualityInfo entity, ref string ErrMsg)
{
if (!CheckingCheckCode(checkCode, AccountID, ref ErrMsg))
return false;
if (entity == null)
{
ErrMsg = "品质信息为空";
return false;
}
if (!entities.QualityInfoes.Any(p => p.ID == entity.ID))
{
ErrMsg = "该品质信息不存在或已删除";
return false;
}
if (string.IsNullOrEmpty(entity.Name))
{
ErrMsg = "品质信息不能为空";
return false;
}
// entity.ModifyDt = DateTime.Now;
try
{
var entry = entities.Entry<QualityInfo>(entity);
if (entry.State == EntityState.Detached)
{
entities.Set<QualityInfo>().Attach(entity);
entry.State = EntityState.Modified;
}
if (entities.SaveChanges() <= 0)
{
ErrMsg = "修改失败";
return false;
}
return true;
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return false;
}
}