xinjiang/SGGL/BLL/TestRun/DriverSub/DriverSubService.cs

81 lines
3.0 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 DriverSubService
{
/// <summary>
/// 根据主键获取开车分包管理信息
/// </summary>
/// <param name="DriverSubId"></param>
/// <returns></returns>
public static Model.DriverSub_DriverSub GetDriverSubById(string DriverSubId)
{
return Funs.DB.DriverSub_DriverSub.FirstOrDefault(e => e.DriverSubId == DriverSubId);
}
/// <summary>
/// 添加开车分包管理信息
/// </summary>
/// <param name="DriverSub"></param>
public static void AddDriverSub(Model.DriverSub_DriverSub DriverSub)
{
Model.DriverSub_DriverSub newDriverSub = new Model.DriverSub_DriverSub();
newDriverSub.DriverSubId = DriverSub.DriverSubId;
newDriverSub.ProjectId = DriverSub.ProjectId;
newDriverSub.Code = DriverSub.Code;
newDriverSub.SubUnitId = DriverSub.SubUnitId;
newDriverSub.Implement = DriverSub.Implement;
newDriverSub.Instruction = DriverSub.Instruction;
newDriverSub.AttachUrl = DriverSub.AttachUrl;
newDriverSub.Remark = DriverSub.Remark;
Funs.DB.DriverSub_DriverSub.InsertOnSubmit(newDriverSub);
Funs.DB.SubmitChanges();
}
/// <summary>
/// 修改开车分包管理
/// </summary>
/// <param name="DriverSub"></param>
public static void UpdateDriverSub(Model.DriverSub_DriverSub DriverSub)
{
Model.DriverSub_DriverSub newDriverSub = Funs.DB.DriverSub_DriverSub.FirstOrDefault(e => e.DriverSubId == DriverSub.DriverSubId);
if (newDriverSub != null)
{
newDriverSub.Code = DriverSub.Code;
newDriverSub.SubUnitId = DriverSub.SubUnitId;
newDriverSub.Implement = DriverSub.Implement;
newDriverSub.Instruction = DriverSub.Instruction;
newDriverSub.AttachUrl = DriverSub.AttachUrl;
newDriverSub.Remark = DriverSub.Remark;
Funs.DB.SubmitChanges();
}
}
/// <summary>
/// 根据主键删除开车分包管理
/// </summary>
/// <param name="DriverSubId"></param>
public static void DeleteDriverSub(string DriverSubId)
{
Model.DriverSub_DriverSub DriverSub = Funs.DB.DriverSub_DriverSub.FirstOrDefault(e => e.DriverSubId == DriverSubId);
if (DriverSub != null)
{
if (!string.IsNullOrEmpty(DriverSub.AttachUrl))
{
BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, DriverSub.AttachUrl);//删除附件
}
Funs.DB.DriverSub_DriverSub.DeleteOnSubmit(DriverSub);
Funs.DB.SubmitChanges();
}
}
}
}