/// <summary> /// 修改隐患通知单明细信息 /// </summary> /// <param name="RectifyNoticeDetail"></param> public static void UpdateRectifyNoticeDetail(Model.Check_RectifyNoticeDetail RectifyNoticeDetail) { Model.SUBHSSEDB db = Funs.DB; var newRectifyNoticeDetail = db.Check_RectifyNoticeDetail.FirstOrDefault(x => x.RectifyNoticeDetailId == RectifyNoticeDetail.RectifyNoticeDetailId); if (newRectifyNoticeDetail != null) { newRectifyNoticeDetail.Unqualified = RectifyNoticeDetail.Unqualified; newRectifyNoticeDetail.CheckArea = RectifyNoticeDetail.CheckArea; newRectifyNoticeDetail.UnitId = RectifyNoticeDetail.UnitId; newRectifyNoticeDetail.Suggestions = RectifyNoticeDetail.Suggestions; db.SubmitChanges(); } }
/// <summary> /// 增加隐患通知单明细信息 /// </summary> /// <param name="RectifyNoticeDetail"></param> public static void AddRectifyNoticeDetail(Model.Check_RectifyNoticeDetail RectifyNoticeDetail) { Model.SUBHSSEDB db = Funs.DB; Model.Check_RectifyNoticeDetail newRectifyNoticeDetail = new Model.Check_RectifyNoticeDetail { RectifyNoticeDetailId = RectifyNoticeDetail.RectifyNoticeDetailId, RectifyNoticeId = RectifyNoticeDetail.RectifyNoticeId, CheckItem = RectifyNoticeDetail.CheckItem, CheckItemType = RectifyNoticeDetail.CheckItemType, Unqualified = RectifyNoticeDetail.Unqualified, CheckArea = RectifyNoticeDetail.CheckArea, UnitId = RectifyNoticeDetail.UnitId, Suggestions = RectifyNoticeDetail.Suggestions, CheckContent = RectifyNoticeDetail.CheckContent }; db.Check_RectifyNoticeDetail.InsertOnSubmit(newRectifyNoticeDetail); db.SubmitChanges(); }
/// <summary> /// 生成隐患整改通知单按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnCreateRectifyNotice_Click(object sender, EventArgs e) { if (this.Grid1.Rows.Count == 0) { Alert.ShowInTop("请先增加检查记录!", MessageBoxIcon.Warning); return; } int n = 0; for (int i = 0; i < this.Grid1.Rows.Count; i++) { if (this.Grid1.Rows[i].Values[7].ToString() == "隐患整改通知单") { n++; break; } } if (n == 0) { Alert.ShowInTop("没有需要生成隐患整改通知单的检查项!", MessageBoxIcon.Warning); return; } string unitIds = string.Empty; string rectifyNoticeAndUnitIds = string.Empty; string rectifyNoticeCode = string.Empty; for (int i = 0; i < this.Grid1.Rows.Count; i++) { if (this.Grid1.Rows[i].Values[7].ToString() == "隐患整改通知单") { Model.Check_CheckColligationDetail detail = BLL.Check_CheckColligationDetailService.GetCheckColligationDetailByCheckColligationDetailId(this.Grid1.Rows[i].DataKeys[0].ToString()); if (string.IsNullOrEmpty(detail.RectifyNoticeId)) { string unitId = this.Grid1.Rows[i].Values[10].ToString(); if (!unitIds.Contains(unitId)) { Model.Check_RectifyNotice rectifyNotice = new Model.Check_RectifyNotice { RectifyNoticeId = SQLHelper.GetNewID(typeof(Model.Check_RectifyNotice)), ProjectId = this.CurrUser.LoginProjectId, UnitId = unitId, RectifyNoticeCode = BLL.CodeRecordsService.ReturnCodeByMenuIdProjectId(BLL.Const.ProjectRectifyNoticeMenuId, this.CurrUser.LoginProjectId, unitId) }; rectifyNotice.CheckArea += this.Grid1.Rows[i].Values[11].ToString(); BLL.Check_RectifyNoticeService.AddRectifyNotice(rectifyNotice); Model.Check_RectifyNoticeDetail d = new Model.Check_RectifyNoticeDetail { RectifyNoticeDetailId = detail.CheckColligationDetailId, RectifyNoticeId = rectifyNotice.RectifyNoticeId, CheckItem = detail.CheckItem, CheckItemType = detail.CheckItemType, Unqualified = detail.Unqualified, CheckArea = detail.CheckArea, UnitId = detail.UnitId, Suggestions = detail.Suggestions, CheckContent = detail.CheckContent }; BLL.Check_RectifyNoticeDetailService.AddRectifyNoticeDetail(d); unitIds += unitId + ","; rectifyNoticeAndUnitIds += rectifyNotice.RectifyNoticeId + "," + unitId + "|"; detail.RectifyNoticeId = rectifyNotice.RectifyNoticeId; BLL.Check_CheckColligationDetailService.UpdateCheckColligationDetail(detail); if (string.IsNullOrEmpty(rectifyNoticeCode)) { rectifyNoticeCode += rectifyNotice.RectifyNoticeCode; } else { rectifyNoticeCode += "," + rectifyNotice.RectifyNoticeCode; } } else { string[] list = rectifyNoticeAndUnitIds.Split('|'); foreach (var item in list) { if (item.Contains(unitId)) { string rectifyNoticeId = item.Split(',')[0]; Model.Check_RectifyNotice rectifyNotice = BLL.Check_RectifyNoticeService.GetRectifyNoticeByRectifyNoticeId(rectifyNoticeId); if (!rectifyNotice.CheckArea.Contains(this.Grid1.Rows[i].Values[11].ToString())) { rectifyNotice.CheckArea += "," + this.Grid1.Rows[i].Values[11].ToString(); } BLL.Check_RectifyNoticeService.UpdateRectifyNotice(rectifyNotice); Model.Check_RectifyNoticeDetail d = new Model.Check_RectifyNoticeDetail { RectifyNoticeDetailId = detail.CheckColligationDetailId, RectifyNoticeId = rectifyNoticeId, CheckItem = detail.CheckItem, CheckItemType = detail.CheckItemType, Unqualified = detail.Unqualified, CheckArea = detail.CheckArea, UnitId = detail.UnitId, Suggestions = detail.Suggestions, CheckContent = detail.CheckContent }; BLL.Check_RectifyNoticeDetailService.AddRectifyNoticeDetail(d); detail.RectifyNoticeId = rectifyNoticeId; BLL.Check_CheckColligationDetailService.UpdateCheckColligationDetail(detail); } } } } } } if (!string.IsNullOrEmpty(rectifyNoticeCode)) { Alert.ShowInTop("已生成隐患整改通知单:" + rectifyNoticeCode + "!", MessageBoxIcon.Success); } else { Alert.ShowInTop("隐患整改通知单已存在,请到对应模块进行处理!", MessageBoxIcon.Warning); } }