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();
            }
        }
    }
}