/// <summary> /// 根据主键删除安全监督检查报告 /// </summary> /// <param name="superviseCheckReportId"></param> public static void DeleteSuperviseCheckReportById(string superviseCheckReportId) { Model.SUBHSSEDB db = Funs.DB; Model.Supervise_SuperviseCheckReport superviseCheckReport = db.Supervise_SuperviseCheckReport.FirstOrDefault(e => e.SuperviseCheckReportId == superviseCheckReportId); if (superviseCheckReport != null) { if (!string.IsNullOrEmpty(superviseCheckReport.AttachUrl)) { BLL.UploadFileService.DeleteFile(Funs.RootPath, superviseCheckReport.AttachUrl);//删除附件 } db.Supervise_SuperviseCheckReport.DeleteOnSubmit(superviseCheckReport); db.SubmitChanges(); } }
/// <summary> /// 修改安全监督检查报告 /// </summary> /// <param name="superviseCheckReport"></param> public static void UpdateSuperviseCheckReport(Model.Supervise_SuperviseCheckReport superviseCheckReport) { Model.SUBHSSEDB db = Funs.DB; Model.Supervise_SuperviseCheckReport newSuperviseCheckReport = db.Supervise_SuperviseCheckReport.FirstOrDefault(e => e.SuperviseCheckReportId == superviseCheckReport.SuperviseCheckReportId); if (newSuperviseCheckReport != null) { newSuperviseCheckReport.SuperviseCheckReportCode = superviseCheckReport.SuperviseCheckReportCode; newSuperviseCheckReport.CheckDate = superviseCheckReport.CheckDate; newSuperviseCheckReport.ProjectId = superviseCheckReport.ProjectId; newSuperviseCheckReport.UnitId = superviseCheckReport.UnitId; newSuperviseCheckReport.CheckTeam = superviseCheckReport.CheckTeam; newSuperviseCheckReport.EvaluationResult = superviseCheckReport.EvaluationResult; newSuperviseCheckReport.AttachUrl = superviseCheckReport.AttachUrl; newSuperviseCheckReport.IsIssued = superviseCheckReport.IsIssued; db.SubmitChanges(); } }
/// <summary> /// 添加安全监督检查报告 /// </summary> /// <param name="superviseCheckReport"></param> public static void AddSuperviseCheckReport(Model.Supervise_SuperviseCheckReport superviseCheckReport) { Model.SUBHSSEDB db = Funs.DB; Model.Supervise_SuperviseCheckReport newSuperviseCheckReport = new Model.Supervise_SuperviseCheckReport { SuperviseCheckReportId = superviseCheckReport.SuperviseCheckReportId, SuperviseCheckReportCode = superviseCheckReport.SuperviseCheckReportCode, CheckDate = superviseCheckReport.CheckDate, ProjectId = superviseCheckReport.ProjectId, UnitId = superviseCheckReport.UnitId, CheckTeam = superviseCheckReport.CheckTeam, EvaluationResult = superviseCheckReport.EvaluationResult, AttachUrl = superviseCheckReport.AttachUrl, IsIssued = superviseCheckReport.IsIssued }; db.Supervise_SuperviseCheckReport.InsertOnSubmit(newSuperviseCheckReport); db.SubmitChanges(); }