/// <summary> /// 修改安全监督检查整改 /// </summary> /// <param name="checkRectify"></param> public static void UpdateCheckRectify(Model.Check_CheckRectify checkRectify) { Model.SUBHSSEDB db = Funs.DB; Model.Check_CheckRectify newCheckRectify = db.Check_CheckRectify.FirstOrDefault(e => e.CheckRectifyId == checkRectify.CheckRectifyId); if (newCheckRectify != null) { newCheckRectify.CheckRectifyCode = checkRectify.CheckRectifyCode; newCheckRectify.ProjectId = checkRectify.ProjectId; newCheckRectify.UnitId = checkRectify.UnitId; newCheckRectify.CheckDate = checkRectify.CheckDate; newCheckRectify.IssueMan = checkRectify.IssueMan; newCheckRectify.IssueDate = checkRectify.IssueDate; newCheckRectify.HandleState = checkRectify.HandleState; db.SubmitChanges(); } }
/// <summary> /// 添加安全监督检查整改 /// </summary> /// <param name="checkRectify"></param> public static void AddCheckRectify(Model.Check_CheckRectify checkRectify) { Model.SUBHSSEDB db = Funs.DB; Model.Check_CheckRectify newCheckRectify = new Model.Check_CheckRectify { CheckRectifyId = checkRectify.CheckRectifyId, CheckRectifyCode = checkRectify.CheckRectifyCode, ProjectId = checkRectify.ProjectId, UnitId = checkRectify.UnitId, CheckDate = checkRectify.CheckDate, IssueMan = checkRectify.IssueMan, IssueDate = checkRectify.IssueDate, HandleState = checkRectify.HandleState }; db.Check_CheckRectify.InsertOnSubmit(newCheckRectify); db.SubmitChanges(); }
/// <summary> /// 安全监督检查整改从集团公司提取 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private static void poxy_GetCheck_CheckRectifyListToSUBCompleted(object sender, HSSEService.GetCheck_CheckRectifyListToSUBCompletedEventArgs e) { int count = 0; if (e.Error == null && e.Result != null) { List <string> ids = new List <string>(); var items = e.Result; if (items.Count() > 0) { count = items.Count(); foreach (var item in items) { if (!ids.Contains(item.CheckRectifyId)) { var newRectify = BLL.CheckRectifyService.GetCheckRectifyByCheckRectifyId(item.CheckRectifyId); if (newRectify == null) { ids.Add(item.CheckRectifyId); Model.Check_CheckRectify newCheckRectify = new Model.Check_CheckRectify { CheckRectifyId = item.CheckRectifyId, CheckRectifyCode = item.CheckRectifyCode, ProjectId = item.ProjectId, UnitId = item.UnitId, CheckDate = item.CheckDate, IssueMan = item.IssueMan, IssueDate = item.IssueDate, HandleState = item.HandleState }; Funs.DB.Check_CheckRectify.InsertOnSubmit(newCheckRectify); Funs.DB.SubmitChanges(); //获取对应主表主键的明细集合 var table5Items = items.Where(x => x.CheckRectifyId == item.CheckRectifyId); foreach (var newItem in table5Items) { var oldItem5 = Funs.DB.Check_CheckInfo_Table5Item.FirstOrDefault(x => x.ID == newItem.Table5ItemId); if (oldItem5 == null) { Model.Check_CheckInfo_Table5Item newCheckRectifyItem = new Model.Check_CheckInfo_Table5Item { ID = newItem.Table5ItemId, SortIndex = newItem.SortIndex, WorkType = newItem.WorkType, DangerPoint = newItem.DangerPoint, RiskExists = newItem.RiskExists, IsProject = newItem.IsProject, CheckMan = newItem.CheckMan, SubjectUnitMan = newItem.SubjectUnitMan }; Funs.DB.Check_CheckInfo_Table5Item.InsertOnSubmit(newCheckRectifyItem); Funs.DB.SubmitChanges(); ////上传附件 if (!string.IsNullOrEmpty(newItem.AttachFileId)) { BLL.FileInsertService.InsertAttachFile(newItem.AttachFileId, newItem.Table5ItemId, newItem.AttachSource, newItem.AttachUrl, newItem.FileContext); } } var oldItem = BLL.CheckRectifyItemService.GetCheckRectifyItemByCheckRectifyItemId(newItem.CheckRectifyItemId); if (oldItem == null) { Model.Check_CheckRectifyItem newCheckRectifyItem = new Model.Check_CheckRectifyItem { CheckRectifyItemId = newItem.CheckRectifyItemId, CheckRectifyId = newItem.CheckRectifyId, Table5ItemId = newItem.Table5ItemId, ConfirmMan = newItem.ConfirmMan, ConfirmDate = newItem.ConfirmDate, OrderEndDate = newItem.OrderEndDate, OrderEndPerson = newItem.OrderEndPerson, RealEndDate = newItem.RealEndDate }; Funs.DB.Check_CheckRectifyItem.InsertOnSubmit(newCheckRectifyItem); Funs.DB.SubmitChanges(); } } } } } } } }