xinjiang/SGGL/BLL/CQMS/Foreign/ITPListProjectService.cs

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

namespace BLL
{
    /// <summary>
    /// 现场ITP清单
    /// </summary>
    public static class ITPListProjectService
    {
        /// <summary>
        /// 根据主键获取ITP信息
        /// </summary>
        /// <param name="iTPListId"></param>
        /// <returns></returns>
        public static Model.CQMS_Foreign_ITPListProject GetITPListProjectById(string iTPListId)
        {
            return Funs.DB.CQMS_Foreign_ITPListProject.FirstOrDefault(e => e.ITPListId == iTPListId);
        }

        /// <summary>
        /// 添加ITP信息
        /// </summary>
        /// <param name="iTP"></param>
        public static void AddITPListProject(Model.CQMS_Foreign_ITPListProject iTP)
        {
            Model.CQMS_Foreign_ITPListProject newITP = new Model.CQMS_Foreign_ITPListProject();
            newITP.ITPListId = iTP.ITPListId;
            newITP.ProjectId = iTP.ProjectId;
            newITP.Name = iTP.Name;
            newITP.CompileMan = iTP.CompileMan;
            newITP.CompileDate = iTP.CompileDate;
            newITP.AttachUrl = iTP.AttachUrl;
            newITP.UnitId = iTP.UnitId;
            newITP.InstallationId = iTP.InstallationId;
            newITP.CNProfessionalCode = iTP.CNProfessionalCode;
            newITP.DocCode = iTP.DocCode;
            newITP.CheckLevel = iTP.CheckLevel;
            newITP.CheckContent = iTP.CheckContent;
            newITP.CheckDate = iTP.CheckDate;
            newITP.FileType = iTP.FileType;
            newITP.Memo = iTP.Memo;
            newITP.UnitWorkId = iTP.UnitWorkId;
           
                      
            Funs.DB.CQMS_Foreign_ITPListProject.InsertOnSubmit(newITP);
            Funs.DB.SubmitChanges();
        }

        /// <summary>
        /// 修改ITP信息
        /// </summary>
        /// <param name="iTP"></param>
        public static void UpdateITPListProject(Model.CQMS_Foreign_ITPListProject iTP)
        {
            Model.CQMS_Foreign_ITPListProject newITP = Funs.DB.CQMS_Foreign_ITPListProject.FirstOrDefault(e => e.ITPListId == iTP.ITPListId);
            if (newITP != null)
            {
                newITP.Name = iTP.Name;
                newITP.CompileMan = iTP.CompileMan;
                newITP.CompileDate = iTP.CompileDate;
                newITP.AttachUrl = iTP.AttachUrl;
                newITP.UnitId = iTP.UnitId;
                newITP.InstallationId = iTP.InstallationId;
                newITP.CNProfessionalCode = iTP.CNProfessionalCode;
                newITP.DocCode = iTP.DocCode;
                newITP.CheckLevel = iTP.CheckLevel;
                newITP.CheckContent = iTP.CheckContent;
                newITP.CheckDate = iTP.CheckDate;
                newITP.FileType = iTP.FileType;
                newITP.Memo = iTP.Memo;
                newITP.UnitWorkId = iTP.UnitWorkId;
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据主键删除ITP信息
        /// </summary>
        /// <param name="iTPListId"></param>
        public static void DeleteITPListProjectById(string iTPListId)
        {
            Model.CQMS_Foreign_ITPListProject newITP = Funs.DB.CQMS_Foreign_ITPListProject.FirstOrDefault(e => e.ITPListId == iTPListId);
            if (newITP != null)
            {
                if (!string.IsNullOrEmpty(newITP.AttachUrl))
                {
                    UploadAttachmentService.DeleteFile(Funs.RootPath, newITP.AttachUrl);
                }
                Funs.DB.CQMS_Foreign_ITPListProject.DeleteOnSubmit(newITP);
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据项目删除ITP信息
        /// </summary>
        /// <param name="iTPListId"></param>
        public static void DeleteITPListProjectByProjectId(string projectId)
        {
            var newITP = from x in Funs.DB.CQMS_Foreign_ITPListProject where x.ProjectId == projectId select x;
            if (newITP != null)
            {
                Funs.DB.CQMS_Foreign_ITPListProject.DeleteAllOnSubmit(newITP);
                Funs.DB.SubmitChanges();
            }
        }
    }
}