80 lines
2.8 KiB
C#
80 lines
2.8 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 RoadMapService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取开车安全线路图
|
|
/// </summary>
|
|
/// <param name="roadMapId"></param>
|
|
/// <returns></returns>
|
|
public static Model.DriverHse_RoadMap GetRoadMapById(string roadMapId)
|
|
{
|
|
return Funs.DB.DriverHse_RoadMap.FirstOrDefault(e => e.RoadMapId == roadMapId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加开车安全线路图
|
|
/// </summary>
|
|
/// <param name="roadMap"></param>
|
|
public static void AddRoadMap(Model.DriverHse_RoadMap roadMap)
|
|
{
|
|
Model.DriverHse_RoadMap newRoadMap = new Model.DriverHse_RoadMap();
|
|
newRoadMap.RoadMapId = roadMap.RoadMapId;
|
|
newRoadMap.ProjectId = roadMap.ProjectId;
|
|
newRoadMap.Code = roadMap.Code;
|
|
newRoadMap.UnitWorkId = roadMap.UnitWorkId;
|
|
newRoadMap.CarArea = roadMap.CarArea;
|
|
newRoadMap.AttachUrl = roadMap.AttachUrl;
|
|
newRoadMap.Remark = roadMap.Remark;
|
|
Funs.DB.DriverHse_RoadMap.InsertOnSubmit(newRoadMap);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改开车安全线路图
|
|
/// </summary>
|
|
/// <param name="roadMap"></param>
|
|
public static void UpdateRoadMap(Model.DriverHse_RoadMap roadMap)
|
|
{
|
|
Model.DriverHse_RoadMap newRoadMap = Funs.DB.DriverHse_RoadMap.FirstOrDefault(e => e.RoadMapId == roadMap.RoadMapId);
|
|
if (newRoadMap != null)
|
|
{
|
|
newRoadMap.ProjectId = roadMap.ProjectId;
|
|
newRoadMap.Code = roadMap.Code;
|
|
newRoadMap.UnitWorkId = roadMap.UnitWorkId;
|
|
newRoadMap.CarArea = roadMap.CarArea;
|
|
newRoadMap.AttachUrl = roadMap.AttachUrl;
|
|
newRoadMap.Remark = roadMap.Remark;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除开车安全线路图
|
|
/// </summary>
|
|
/// <param name="roadMapId"></param>
|
|
public static void DeleteRoadMapById(string roadMapId)
|
|
{
|
|
Model.DriverHse_RoadMap newRoadMap = Funs.DB.DriverHse_RoadMap.FirstOrDefault(e => e.RoadMapId == roadMapId);
|
|
if (newRoadMap != null)
|
|
{
|
|
if (!string.IsNullOrEmpty(newRoadMap.AttachUrl))
|
|
{
|
|
UploadAttachmentService.DeleteFile(Funs.RootPath, newRoadMap.AttachUrl);
|
|
}
|
|
Funs.DB.DriverHse_RoadMap.DeleteOnSubmit(newRoadMap);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
}
|