/// <summary>
/// 修改安全隐患通知单
/// </summary>
/// <param name="rectifyNotice"></param>
public static void UpdateRectifyNotice(Model.Check_RectifyNotice rectifyNotice)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_RectifyNotice newRectifyNotice = db.Check_RectifyNotice.FirstOrDefault(e => e.RectifyNoticeId == rectifyNotice.RectifyNoticeId);
if (newRectifyNotice != null)
{
newRectifyNotice.UnitId = rectifyNotice.UnitId;
newRectifyNotice.CheckArea = rectifyNotice.CheckArea;
newRectifyNotice.CheckedTime = rectifyNotice.CheckedTime;
newRectifyNotice.WrongContent = rectifyNotice.WrongContent;
newRectifyNotice.SignPerson = rectifyNotice.SignPerson;
newRectifyNotice.RectifyLimit = rectifyNotice.RectifyLimit;
newRectifyNotice.CompleteStatus = rectifyNotice.CompleteStatus;
newRectifyNotice.DutyPerson = rectifyNotice.DutyPerson;
newRectifyNotice.CompleteDate = rectifyNotice.CompleteDate;
newRectifyNotice.IsRectify = rectifyNotice.IsRectify;
newRectifyNotice.CheckPerson = rectifyNotice.CheckPerson;
newRectifyNotice.AttachUrl1 = rectifyNotice.AttachUrl1;
newRectifyNotice.AttachUrl2 = rectifyNotice.AttachUrl2;
newRectifyNotice.AttachUrl3 = rectifyNotice.AttachUrl3;
newRectifyNotice.ChangeContent = rectifyNotice.ChangeContent;
newRectifyNotice.HSEManager = rectifyNotice.HSEManager;
newRectifyNotice.ChangeDate = rectifyNotice.ChangeDate;
newRectifyNotice.CheckDate = rectifyNotice.CheckDate;
newRectifyNotice.CheckStation = rectifyNotice.CheckStation;
newRectifyNotice.States = rectifyNotice.States;
newRectifyNotice.RectifyType = rectifyNotice.RectifyType;
newRectifyNotice.RectifyState = rectifyNotice.RectifyState;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全隐患通知单
/// </summary>
/// <param name="rectifyNotice"></param>
public static void AddRectifyNotice(Model.Check_RectifyNotice rectifyNotice)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_RectifyNotice newRectifyNotice = new Model.Check_RectifyNotice
{
RectifyNoticeId = rectifyNotice.RectifyNoticeId,
RectifyNoticeCode = rectifyNotice.RectifyNoticeCode,
ProjectId = rectifyNotice.ProjectId,
UnitId = rectifyNotice.UnitId,
CheckArea = rectifyNotice.CheckArea,
CheckedTime = rectifyNotice.CheckedTime,
WrongContent = rectifyNotice.WrongContent,
SignPerson = rectifyNotice.SignPerson,
RectifyLimit = rectifyNotice.RectifyLimit,
CompleteStatus = rectifyNotice.CompleteStatus,
DutyPerson = rectifyNotice.DutyPerson,
CompleteDate = rectifyNotice.CompleteDate,
IsRectify = rectifyNotice.IsRectify,
CheckPerson = rectifyNotice.CheckPerson,
AttachUrl1 = rectifyNotice.AttachUrl1,
AttachUrl2 = rectifyNotice.AttachUrl2,
AttachUrl3 = rectifyNotice.AttachUrl3,
ChangeContent = rectifyNotice.ChangeContent,
HSEManager = rectifyNotice.HSEManager,
ChangeDate = rectifyNotice.ChangeDate,
CheckDate = rectifyNotice.CheckDate,
CheckStation = rectifyNotice.CheckStation,
States = rectifyNotice.States,
CompileMan = rectifyNotice.CompileMan,
RectifyType = rectifyNotice.RectifyType,
RectifyState = rectifyNotice.RectifyState
};
db.Check_RectifyNotice.InsertOnSubmit(newRectifyNotice);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectRectifyNoticeMenuId, rectifyNotice.ProjectId, null, rectifyNotice.RectifyNoticeId, rectifyNotice.CheckedTime);
}
/// <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);
}
}
