/// <summary> /// 更新工具状态 /// </summary> /// <param name="tools"></param> private void ToolArrange(List <ToolsEntity> tools) { var ids = tools.Select(c => c.Id).Distinct().ToArray(); var InItems = toolContext.Tools.Where(c => ids.Contains(c.Id) && c.Status == 1 && !c.IsDelete).ToList(); var OutItems = toolContext.Tools.Where(c => !ids.Contains(c.Id) && c.Status == 0 && !c.IsDelete).ToList(); var logItems = new List <ToolLogEntity>(); foreach (var item in InItems) { item.Status = 0; item.BroDate = DateTime.Now; } foreach (var item in OutItems) { item.Status = 1; item.BroDate = DateTime.Now; item.BroTimes += 1; ToolLogEntity temp = new ToolLogEntity { ToolId = item.Id, Status = 1 }; logItems.Add(temp); } toolContext.Tools.AddOrUpdate(InItems.Concat(OutItems).ToArray()); if (logItems.Any()) { toolContext.ToolLog.AddOrUpdate(logItems.ToArray()); } }
private void simpleButton5_Click(object sender, EventArgs e) { bindingTool.IsDelete = true; bindingTool.BroDate = DateTime.Now; bindingTool.Status = 2; ToolLogEntity tool = new ToolLogEntity { Status = 2, ToolId = bindingTool.Id, }; toolContext.Tools.AddOrUpdate(bindingTool); toolContext.ToolLog.AddOrUpdate(tool); toolContext.SaveChanges(); }