using System.Linq;
using System;

namespace BLL
{
    public class SSRService
    {
        public static Model.SSR GetSSRById(string ssrId)
        {
            return Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssrId);
        }

        public static Model.SSR GetSSRBySESNo(string sesNo)
        {
            return Funs.DB.SSR.FirstOrDefault(e => e.SES_No == sesNo);
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="ssr"></param>
        public static void AddSSR(Model.SSR ssr)
        {
            Model.SSR newSSR = new Model.SSR();
            newSSR.SSRId = ssr.SSRId;
            newSSR.SES_No = ssr.SES_No;
            newSSR.WorkOrder = ssr.WorkOrder;
            newSSR.Op = ssr.Op;
            newSSR.Network = ssr.Network;
            newSSR.Nop = ssr.Nop;
            newSSR.RequisitionerId = ssr.RequisitionerId;
            newSSR.RequisitionerName = ssr.RequisitionerName;
            newSSR.DepartmentId = ssr.DepartmentId;
            newSSR.DepartmentName = ssr.DepartmentName;
            newSSR.SubmmisionDate = ssr.SubmmisionDate;
            newSSR.CompletionDate = ssr.CompletionDate;
            newSSR.ContractNo = ssr.ContractNo;
            newSSR.Address = ssr.Address;
            newSSR.Remark = ssr.Remark;
            newSSR.InputDate = ssr.InputDate;
            newSSR.RetrunDuration = ssr.RetrunDuration;
            newSSR.NotRetrunDuration = ssr.NotRetrunDuration;
            newSSR.ContractAdmin = ssr.ContractAdmin;
            newSSR.ReturnDate = ssr.ReturnDate;
            Funs.DB.SSR.InsertOnSubmit(newSSR);
            Funs.DB.SubmitChanges();
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="ssr"></param>
        public static void UpdateSSR(Model.SSR ssr)
        {
            Model.SSR newSSR = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssr.SSRId);
            if (newSSR != null)
            {
                newSSR.SES_No = ssr.SES_No;
                newSSR.WorkOrder = ssr.WorkOrder;
                newSSR.Op = ssr.Op;
                newSSR.Network = ssr.Network;
                newSSR.Nop = ssr.Nop;
                newSSR.RequisitionerId = ssr.RequisitionerId;
                newSSR.RequisitionerName = ssr.RequisitionerName;
                newSSR.DepartmentId = ssr.DepartmentId;
                newSSR.DepartmentName = ssr.DepartmentName;
                newSSR.SubmmisionDate = ssr.SubmmisionDate;
                newSSR.CompletionDate = ssr.CompletionDate;
                newSSR.ContractNo = ssr.ContractNo;
                newSSR.Address = ssr.Address;
                newSSR.Remark = ssr.Remark;
                newSSR.InputDate = ssr.InputDate;
                newSSR.RetrunDuration = ssr.RetrunDuration;
                newSSR.NotRetrunDuration = ssr.NotRetrunDuration;
                newSSR.ContractAdmin = ssr.ContractAdmin;
                newSSR.ReturnDate = ssr.ReturnDate;
                Funs.DB.SubmitChanges();
            }
        }

        public static void UpdateSSR_SubmmisionDate(string sSRId, DateTime? SubmmisionDate)
        {
            Model.SSR newSSR = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == sSRId);
            if (newSSR != null)
            {
                newSSR.SubmmisionDate = SubmmisionDate;
                Funs.DB.SubmitChanges();
            }
        }
        /// <summary>
        /// 更新取回日期
        /// </summary>
        /// <param name="ssr"></param>
        public static void UpdateSSRRetrunDate(Model.SSR ssr)
        {
            Model.SSR newSSR = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssr.SSRId);
            if (newSSR != null)
            {
                newSSR.ReturnDate = ssr.ReturnDate;
                newSSR.IsRetruned = ssr.IsRetruned;
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据主键删除
        /// </summary>
        /// <param name="ssr"></param>
        public static void DeleteSSRById(string ssrId)
        {
            Model.SSR ssr = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssrId);
            if (ssr != null)
            {
                Funs.DB.SSR.DeleteOnSubmit(ssr);
                Funs.DB.SubmitChanges();
            }
        }
    }
}