/// <summary>
/// 根据主键删除安全监督检查整改
/// </summary>
/// <param name="UpCheckReportId"></param>
public static void DeleteUpCheckReportById(string UpCheckReportId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Supervise_UpCheckReport upCheckReport = db.Supervise_UpCheckReport.FirstOrDefault(e => e.UpCheckReportId == UpCheckReportId);
if (upCheckReport != null)
{
db.Supervise_UpCheckReport.DeleteOnSubmit(upCheckReport);
db.SubmitChanges();
}
}
/// <summary>
/// 修改安全监督检查整改
/// </summary>
/// <param name="UpCheckReport"></param>
public static void UpdateUpCheckReport(Model.Supervise_UpCheckReport UpCheckReport)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Supervise_UpCheckReport newUpCheckReport = db.Supervise_UpCheckReport.FirstOrDefault(e => e.UpCheckReportId == UpCheckReport.UpCheckReportId);
if (newUpCheckReport != null)
{
newUpCheckReport.UnitId = UpCheckReport.UnitId;
newUpCheckReport.CheckStartTime = UpCheckReport.CheckStartTime;
newUpCheckReport.CheckEndTime = UpCheckReport.CheckEndTime;
newUpCheckReport.Values1 = UpCheckReport.Values1;
newUpCheckReport.Values2 = UpCheckReport.Values2;
newUpCheckReport.Values3 = UpCheckReport.Values3;
newUpCheckReport.Values4 = UpCheckReport.Values4;
newUpCheckReport.Values5 = UpCheckReport.Values5;
newUpCheckReport.Values6 = UpCheckReport.Values6;
newUpCheckReport.Values7 = UpCheckReport.Values7;
newUpCheckReport.CompileDate = UpCheckReport.CompileDate;
newUpCheckReport.AuditDate = UpCheckReport.AuditDate;
newUpCheckReport.UpState = UpCheckReport.UpState;
newUpCheckReport.UpDateTime = UpCheckReport.UpDateTime;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全监督检查整改
/// </summary>
/// <param name="UpCheckReport"></param>
public static void AddUpCheckReport(Model.Supervise_UpCheckReport UpCheckReport)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Supervise_UpCheckReport newUpCheckReport = new Model.Supervise_UpCheckReport
{
UpCheckReportId = UpCheckReport.UpCheckReportId,
UnitId = UpCheckReport.UnitId,
CheckStartTime = UpCheckReport.CheckStartTime,
CheckEndTime = UpCheckReport.CheckEndTime,
Values1 = UpCheckReport.Values1,
Values2 = UpCheckReport.Values2,
Values3 = UpCheckReport.Values3,
Values4 = UpCheckReport.Values4,
Values5 = UpCheckReport.Values5,
Values6 = UpCheckReport.Values6,
Values7 = UpCheckReport.Values7,
CompileDate = UpCheckReport.CompileDate,
AuditDate = UpCheckReport.AuditDate,
UpState = UpCheckReport.UpState,
UpDateTime = UpCheckReport.UpDateTime
};
db.Supervise_UpCheckReport.InsertOnSubmit(newUpCheckReport);
db.SubmitChanges();
}
