using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace BLL { /// /// 开车作业票管理 /// public static class HseLicenseService { /// /// 根据主键获取开车作业票管理 /// /// /// public static Model.DriverHse_HseLicense GetHseLicenseById(string hseLicenseId) { return Funs.DB.DriverHse_HseLicense.FirstOrDefault(e => e.HseLicenseId == hseLicenseId); } /// /// 添加开车作业票管理 /// /// public static void AddHseLicense(Model.DriverHse_HseLicense hseLicense) { Model.DriverHse_HseLicense newHseLicense = new Model.DriverHse_HseLicense(); newHseLicense.HseLicenseId = hseLicense.HseLicenseId; newHseLicense.ProjectId = hseLicense.ProjectId; newHseLicense.Code = hseLicense.Code; newHseLicense.UnitWorkId = hseLicense.UnitWorkId; newHseLicense.WorkArea = hseLicense.WorkArea; newHseLicense.WorkContents = hseLicense.WorkContents; newHseLicense.WorkDate = hseLicense.WorkDate; newHseLicense.UnitHead = hseLicense.UnitHead; newHseLicense.ApplyMan = hseLicense.ApplyMan; newHseLicense.ApplyUnit = hseLicense.ApplyUnit; newHseLicense.WorkTicket = hseLicense.WorkTicket; newHseLicense.WorkTicketCode = hseLicense.WorkTicketCode; newHseLicense.Detection = hseLicense.Detection; newHseLicense.Guardian = hseLicense.Guardian; newHseLicense.WorkEnd = hseLicense.WorkEnd; newHseLicense.Remark = hseLicense.Remark; Funs.DB.DriverHse_HseLicense.InsertOnSubmit(newHseLicense); Funs.DB.SubmitChanges(); } /// /// 修改开车作业票管理 /// /// public static void UpdateHseLicense(Model.DriverHse_HseLicense hseLicense) { Model.DriverHse_HseLicense newHseLicense = Funs.DB.DriverHse_HseLicense.FirstOrDefault(e => e.HseLicenseId == hseLicense.HseLicenseId); if (newHseLicense != null) { newHseLicense.ProjectId = hseLicense.ProjectId; newHseLicense.Code = hseLicense.Code; newHseLicense.UnitWorkId = hseLicense.UnitWorkId; newHseLicense.WorkArea = hseLicense.WorkArea; newHseLicense.WorkContents = hseLicense.WorkContents; newHseLicense.WorkDate = hseLicense.WorkDate; newHseLicense.UnitHead = hseLicense.UnitHead; newHseLicense.ApplyMan = hseLicense.ApplyMan; newHseLicense.ApplyUnit = hseLicense.ApplyUnit; newHseLicense.WorkTicket = hseLicense.WorkTicket; newHseLicense.WorkTicketCode = hseLicense.WorkTicketCode; newHseLicense.Detection = hseLicense.Detection; newHseLicense.Guardian = hseLicense.Guardian; newHseLicense.WorkEnd = hseLicense.WorkEnd; newHseLicense.Remark = hseLicense.Remark; Funs.DB.SubmitChanges(); } } /// /// 根据主键删除开车作业票管理 /// /// public static void DeleteHseLicenseById(string hseLicenseId) { Model.DriverHse_HseLicense newHseLicense = Funs.DB.DriverHse_HseLicense.FirstOrDefault(e => e.HseLicenseId == hseLicenseId); if (newHseLicense != null) { Funs.DB.DriverHse_HseLicense.DeleteOnSubmit(newHseLicense); Funs.DB.SubmitChanges(); } } } }