94 lines
3.9 KiB
C#
94 lines
3.9 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 开车作业票管理
|
|
/// </summary>
|
|
public static class HseLicenseService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取开车作业票管理
|
|
/// </summary>
|
|
/// <param name="hseLicenseId"></param>
|
|
/// <returns></returns>
|
|
public static Model.DriverHse_HseLicense GetHseLicenseById(string hseLicenseId)
|
|
{
|
|
return Funs.DB.DriverHse_HseLicense.FirstOrDefault(e => e.HseLicenseId == hseLicenseId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加开车作业票管理
|
|
/// </summary>
|
|
/// <param name="hseLicense"></param>
|
|
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();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改开车作业票管理
|
|
/// </summary>
|
|
/// <param name="hseLicense"></param>
|
|
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();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除开车作业票管理
|
|
/// </summary>
|
|
/// <param name="hseLicenseId"></param>
|
|
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();
|
|
}
|
|
}
|
|
}
|
|
}
|