/// <summary>
/// 修改安全监督检查整改
/// </summary>
/// <param name="superviseCheckRectify"></param>
public static void UpdateSuperviseCheckRectify(Model.Supervise_SuperviseCheckRectify superviseCheckRectify)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Supervise_SuperviseCheckRectify newSuperviseCheckRectify = db.Supervise_SuperviseCheckRectify.FirstOrDefault(e => e.SuperviseCheckRectifyId == superviseCheckRectify.SuperviseCheckRectifyId);
if (newSuperviseCheckRectify != null)
{
newSuperviseCheckRectify.SuperviseCheckRectifyCode = superviseCheckRectify.SuperviseCheckRectifyCode;
newSuperviseCheckRectify.ProjectId = superviseCheckRectify.ProjectId;
newSuperviseCheckRectify.UnitId = superviseCheckRectify.UnitId;
newSuperviseCheckRectify.CheckDate = superviseCheckRectify.CheckDate;
newSuperviseCheckRectify.IssueMan = superviseCheckRectify.IssueMan;
newSuperviseCheckRectify.IssueDate = superviseCheckRectify.IssueDate;
newSuperviseCheckRectify.SuperviseCheckReportId = superviseCheckRectify.SuperviseCheckReportId;
newSuperviseCheckRectify.HandleState = superviseCheckRectify.HandleState;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全监督检查整改
/// </summary>
/// <param name="SuperviseCheckRectify"></param>
public static void AddSuperviseCheckRectify(Model.Supervise_SuperviseCheckRectify superviseCheckRectify)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Supervise_SuperviseCheckRectify newSuperviseCheckRectify = new Model.Supervise_SuperviseCheckRectify
{
SuperviseCheckRectifyId = superviseCheckRectify.SuperviseCheckRectifyId,
SuperviseCheckRectifyCode = superviseCheckRectify.SuperviseCheckRectifyCode,
ProjectId = superviseCheckRectify.ProjectId,
UnitId = superviseCheckRectify.UnitId,
CheckDate = superviseCheckRectify.CheckDate,
IssueMan = superviseCheckRectify.IssueMan,
IssueDate = superviseCheckRectify.IssueDate,
SuperviseCheckReportId = superviseCheckRectify.SuperviseCheckReportId,
HandleState = superviseCheckRectify.HandleState
};
db.Supervise_SuperviseCheckRectify.InsertOnSubmit(newSuperviseCheckRectify);
db.SubmitChanges();
}
/// <summary>
/// 根据主键删除安全监督检查整改
/// </summary>
/// <param name="superviseCheckRectifyId"></param>
public static void DeleteSuperviseCheckRectifyById(string superviseCheckRectifyId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Supervise_SuperviseCheckRectify superviseCheckRectify = db.Supervise_SuperviseCheckRectify.FirstOrDefault(e => e.SuperviseCheckRectifyId == superviseCheckRectifyId);
if (superviseCheckRectify != null)
{
var superviseCheckRectifys = from x in db.Supervise_SuperviseCheckRectify where x.SuperviseCheckReportId == superviseCheckRectify.SuperviseCheckReportId select x;
if (superviseCheckRectifys.Count() == 1)
{
var report = BLL.SuperviseCheckReportService.GetSuperviseCheckReportById(superviseCheckRectify.SuperviseCheckReportId);
if (report != null)
{
report.IsIssued = null; //已下发
BLL.SuperviseCheckReportService.UpdateSuperviseCheckReport(report);
}
}
db.Supervise_SuperviseCheckRectify.DeleteOnSubmit(superviseCheckRectify);
db.SubmitChanges();
}
}