using System.Linq; namespace BLL { /// /// 开车报告 /// public static class DriverReportService { /// /// 根据主键获取开车报告信息 /// /// /// public static Model.Driver_DriverReport GetDriverReportById(string driverReportId) { return Funs.DB.Driver_DriverReport.FirstOrDefault(e => e.DriverReportId == driverReportId); } /// /// 添加开车报告信息 /// /// public static void AddDriverReport(Model.Driver_DriverReport driverReport) { Model.Driver_DriverReport newDriverReport = new Model.Driver_DriverReport(); newDriverReport.DriverReportId = driverReport.DriverReportId; newDriverReport.ProjectId = driverReport.ProjectId; newDriverReport.DriverReportCode = driverReport.DriverReportCode; newDriverReport.UnitWorkId = driverReport.UnitWorkId; newDriverReport.DriverReporName = driverReport.DriverReporName; newDriverReport.CompilePerson = driverReport.CompilePerson; newDriverReport.SubmitDate = driverReport.SubmitDate; newDriverReport.ReportType = driverReport.ReportType; newDriverReport.Number = driverReport.Number; newDriverReport.AttachUrl = driverReport.AttachUrl; newDriverReport.Remark = driverReport.Remark; Funs.DB.Driver_DriverReport.InsertOnSubmit(newDriverReport); Funs.DB.SubmitChanges(); } /// /// 修改开车报告信息 /// /// public static void UpdateDriverReport(Model.Driver_DriverReport driverReport) { Model.Driver_DriverReport newDriverReport = Funs.DB.Driver_DriverReport.FirstOrDefault(e => e.DriverReportId == driverReport.DriverReportId); if (newDriverReport != null) { //newDriverReport.ProjectId = driverReport.ProjectId; newDriverReport.DriverReportCode = driverReport.DriverReportCode; newDriverReport.UnitWorkId = driverReport.UnitWorkId; newDriverReport.DriverReporName = driverReport.DriverReporName; newDriverReport.CompilePerson = driverReport.CompilePerson; newDriverReport.SubmitDate = driverReport.SubmitDate; //newDriverReport.ReportType = driverReport.ReportType; newDriverReport.Number = driverReport.Number; newDriverReport.AttachUrl = driverReport.AttachUrl; newDriverReport.Remark = driverReport.Remark; Funs.DB.SubmitChanges(); } } /// /// 根据主键删除开车报告信息 /// /// public static void DeleteDriverReport(string driverReportId) { Model.Driver_DriverReport driverReport = Funs.DB.Driver_DriverReport.FirstOrDefault(e => e.DriverReportId == driverReportId); if (driverReport != null) { if (!string.IsNullOrEmpty(driverReport.AttachUrl)) { BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, driverReport.AttachUrl);//删除附件 } Funs.DB.Driver_DriverReport.DeleteOnSubmit(driverReport); Funs.DB.SubmitChanges(); } } } }