/// <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);
}
}
