/// <summary> /// 添加安全监督检查整改明细信息 /// </summary> /// <param name="CheckRectifyItem"></param> public static void UpdateCheckRectifyItem(Model.Check_CheckRectifyItem CheckRectifyItem) { Model.SUBHSSEDB db = Funs.DB; var newCheckRectifyItem = db.Check_CheckRectifyItem.FirstOrDefault(x => x.CheckRectifyItemId == CheckRectifyItem.CheckRectifyItemId); if (newCheckRectifyItem != null) { newCheckRectifyItem.OrderEndPerson = CheckRectifyItem.OrderEndPerson; newCheckRectifyItem.RealEndDate = CheckRectifyItem.RealEndDate; newCheckRectifyItem.Verification = CheckRectifyItem.Verification; 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(); } } } } } } } }