public ToolCategoryDao()
{
Db = ContextFactory.GetContext();
}
public ToolStateDao()
{
Db = ContextFactory.GetContext();
}
public Result <bool> EditTool(Tool tool)
{
Result <bool> rlt = new Result <bool>();
using (ToolMgtEntities Db = ContextFactory.GetContext())
{
try
{
var old = Db.Tools.FirstOrDefault(p => p.Barcode == tool.Barcode && p.Id != tool.Id);
if (old != null)
{
rlt.HasError = true;
rlt.Msg = "工具条码重复！";
return(rlt);
}
if (!string.IsNullOrEmpty(tool.RFID))
{
old = Db.Tools.FirstOrDefault(p => p.RFID == tool.RFID && p.Id != tool.Id);
if (old != null)
{
rlt.HasError = true;
rlt.Msg = "工具RFID重复！";
return(rlt);
}
}
#region 处理工具包
if (tool.IsPkg)
{
//判断重复使用的子工具
if (tool.PkgItems != null && tool.PkgItems.Count > 0)
{
foreach (var chld in tool.PkgItems)
{
var exist = Db.ToolPkgItems.FirstOrDefault(p => p.ChildrenId == chld.ChildrenId);
if (exist != null && exist.ParentId != tool.Id)
{
rlt.HasError = true;
rlt.Msg = $"Id为【{ chld.ChildrenId }】的工具，已被其他工具包使用！";
return(rlt);
}
}
}
}
Db.ToolPkgItems.RemoveRange(Db.ToolPkgItems.Where(p => p.ParentId == tool.Id)); //删除旧的子工具
if (tool.PkgItems != null && tool.PkgItems.Count > 0) //重新加入子工具
{
Db.ToolPkgItems.AddRange(tool.PkgItems);
}
#endregion
tool.ToolState = Db.ToolStates.FirstOrDefault(p => p.Id == tool.StateId);
tool.ToolCategory = Db.ToolCategories.FirstOrDefault(p => p.Id == tool.CategoryId);
var oldEntity = Db.Entry(tool);
oldEntity.State = System.Data.Entity.EntityState.Modified;
Db.SaveChanges();
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
rlt.HasError = true;
rlt.Msg = ex.Message;
}
}
return(rlt);
}
public ToolPkgItemDao()
{
Db = ContextFactory.GetContext();
}
public Result <bool> AddTool(Tool tool)
{
Result <bool> rlt = new Result <bool>();
using (ToolMgtEntities Db = ContextFactory.GetContext())
{
try
{
var old = Db.Tools.FirstOrDefault(p => p.Barcode == tool.Barcode);
if (old != null)
{
rlt.HasError = true;
rlt.Msg = "工具条码重复！";
return(rlt);
}
if (!string.IsNullOrEmpty(tool.RFID))
{
old = Db.Tools.FirstOrDefault(p => p.RFID == tool.RFID);
if (old != null)
{
rlt.HasError = true;
rlt.Msg = "工具RFID重复！";
return(rlt);
}
}
if (tool.IsPkg)
{
//判断重复使用的子工具
if (tool.PkgItems != null && tool.PkgItems.Count > 0)
{
foreach (var chld in tool.PkgItems)
{
var exist = Db.ToolPkgItems.FirstOrDefault(p => p.ChildrenId == chld.ChildrenId);
if (exist != null)
{
rlt.HasError = true;
rlt.Msg = $"Id为【{ chld.ChildrenId }】的工具，已被其他工具包使用！";
return(rlt);
}
}
}
}
Db.Tools.Add(tool);
Db.SaveChanges();//保存后才会得到工具包Id
if (tool.PkgItems != null && tool.PkgItems.Count > 0)
{
tool.PkgItems.ForEach(p => p.ParentId = tool.Id);//设置工具包Id
Db.ToolPkgItems.AddRange(tool.PkgItems);
Db.SaveChanges();
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
rlt.HasError = true;
rlt.Msg = ex.Message;
}
}
return(rlt);
}
public ToolRepairDao()
{
Db = ContextFactory.GetContext();
}
public RoleDao()
{
Db = ContextFactory.GetContext();
}
public ToolPurchaseDao()
{
Db = ContextFactory.GetContext();
}
public UserDao()
{
Db = ContextFactory.GetContext();
}
