using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL
{
    /// <summary>
    /// ITP清单
    /// </summary>
    public static class ITPListService
    {
        /// <summary>
        /// 根据主键获取ITP清单
        /// </summary>
        /// <param name="itpListId"></param>
        /// <returns></returns>
        public static Model.CQMS_Foreign_ITPList GetITPListById(string itpListId)
        {
            return Funs.DB.CQMS_Foreign_ITPList.FirstOrDefault(e => e.ITPListId == itpListId);
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="itpList"></param>
        public static void AddITPList(Model.CQMS_Foreign_ITPList itpList)
        {
            Model.CQMS_Foreign_ITPList newITPList = new Model.CQMS_Foreign_ITPList();
            newITPList.ITPListId = itpList.ITPListId;
            newITPList.ITPName = itpList.ITPName;
            newITPList.CompileMan = itpList.CompileMan;
            newITPList.CompileDate = itpList.CompileDate;
            Funs.DB.CQMS_Foreign_ITPList.InsertOnSubmit(newITPList);
            Funs.DB.SubmitChanges();
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="itpList"></param>
        public static void UpdateITPList(Model.CQMS_Foreign_ITPList itpList)
        {
            Model.CQMS_Foreign_ITPList newITPList = Funs.DB.CQMS_Foreign_ITPList.FirstOrDefault(e => e.ITPListId == itpList.ITPListId);
            if (newITPList!=null)
            {
                newITPList.ITPName = itpList.ITPName;
                newITPList.CompileMan = itpList.CompileMan;
                newITPList.CompileDate = itpList.CompileDate;
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据主键删除ITP清单
        /// </summary>
        /// <param name="itpListId"></param>
        public static void DeleteITPListById(string itpListId)
        {
            Model.CQMS_Foreign_ITPList itpList = Funs.DB.CQMS_Foreign_ITPList.FirstOrDefault(e => e.ITPListId == itpListId);
            if (itpList != null)
            {
                Funs.DB.CQMS_Foreign_ITPList.DeleteOnSubmit(itpList);
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 判断名称是否存在
        /// </summary>
        /// <param name="iTPListId"></param>
        /// <param name="name"></param>
        /// <returns></returns>
        public static bool IsExistITPName(string iTPListId, string name)
        {
            bool isExist = false;
            var q = Funs.DB.CQMS_Foreign_ITPList.FirstOrDefault(e => e.ITPName == name && e.ITPListId != iTPListId);
            if (q != null)
            {
                isExist = true;
            }
            return isExist;
        }
    }
}