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