using DocumentServiceAPI.Application.ProjectInfo.Services.Interfaces;
using DocumentServiceAPI.Application.ProjectInfo.ViewMode;
using DocumentServiceAPI.Application.Repository;
using DocumentServiceAPI.Model.cyDocumentModel;
using DocumentServiceAPI.Model.Permissions;
using DocumentServiceAPI.Model.UserInfoModel;
using DocumentServiceAPI.Utility;
using MapsterMapper;
using Microsoft.AspNetCore.Mvc.RazorPages;
using NetTaste;
using SqlSugar.Extensions;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Runtime.Intrinsics.Arm;
using System.Security.Claims;
using System.Text;
using System.Threading.Tasks;

namespace DocumentServiceAPI.Application.ProjectInfo.Services
{
    public class SheZhiService : ISheZhiService, IScoped
    {

        private ISqlSugarClient _db { get; set; }
        private ProjectInfoRepository _projectInfoRepository { get; set; }
        private IMapper _mapper { get; set; }
        public SheZhiService(ISqlSugarClient db, ProjectInfoRepository projectInfoRepository, IMapper mapper)
        {
            _db = db;
            _projectInfoRepository = projectInfoRepository;
            _mapper = mapper;
        }

        public PageResult<Document_DelegatePersonInfo> postDelegatePersonList(DocumentProjectInfoPageSearch page)
        {
            var aaa = GetJwtInfo();

            SqlSugar.PageModel pg = new SqlSugar.PageModel();
            pg.PageSize = page.PageSize;
            pg.PageIndex = page.PageIndex;
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<Document_DelegatePersonInfo> result = new PageResult<Document_DelegatePersonInfo>();



            result.Items = _db.Queryable<Document_DelegatePersonInfo>()
                .Where(a => a.TenantID == aaa.TEID)
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.delegateName), a => a.DelegateName.Contains(page.delegateName))
              .WhereIF(page.isUse > 0, a => a.IsUse == page.isUse)


             .OrderByDescending(a => a.DelegateId).ToPageList(page.PageIndex, page.PageSize, ref total);


            result.TotalCount = total;
            result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;



            return result;
        }


        public bool GetDelDocumentDelegatePersonInfo(int ID)
        {
            _db.Deleteable<Document_DelegatePersonInfo>().Where(x => x.DelegateId == ID).ExecuteCommand();

            return true;
        }

        public bool SaveDocumentDelegatePersonInfo(Document_DelegatePersonInfo dp)
        {
            if (dp.DelegateId > 0)
            {
                _db.Updateable<Document_DelegatePersonInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_DelegatePersonInfo>(dp).ExecuteCommand();
            }

            return true;
        }

        public Document_DelegatePersonInfo GetDocumentDelegatePersonInfo(int ID)
        {
            var result = _db.Queryable<Document_DelegatePersonInfo>().Where(x => x.DelegateId == ID).First();//执行查询
            return result;
        }





        public PageResult<Document_TenderUnit> postDocumentTenderUnitList(DocumentProjectInfoPageSearch page)
        {
            var aaa = GetJwtInfo();

            SqlSugar.PageModel pg = new SqlSugar.PageModel();
            pg.PageSize = page.PageSize;
            pg.PageIndex = page.PageIndex;
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<Document_TenderUnit> result = new PageResult<Document_TenderUnit>();



            result.Items = _db.Queryable<Document_TenderUnit>()
                .Where(a => a.TenantId == aaa.TEID)
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.delegateName), a => a.UnitName.Contains(page.delegateName))
              .WhereIF(page.isUse > 0, a => a.IsUsed == page.isUse)


             .OrderByDescending(a => a.UnitId).ToPageList(page.PageIndex, page.PageSize, ref total);


            result.TotalCount = total;
            result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;



            return result;
        }


       

        public bool SaveDocumentTenderUnitInfo(Document_TenderUnit dp)
        {
            if (dp.UnitId > 0)
            {
                _db.Updateable<Document_TenderUnit>(dp).ExecuteCommand();
            }
            else
            {
                var aaa = GetJwtInfo();
                var tenantPermissions = _db.Queryable<TenantPermissions>().Where(x => x.IsDel == false && x.IsEn == true && x.TenantId == aaa.TEID.Value && x.PermissionsType == TenantPermissionsType.Manage).First();
                if (tenantPermissions != null)
                {
                    var times = _db.Queryable<Document_TenderUnit>().Count(x => x.IsDeled == false && x.IsEn == true && x.TenantId == aaa.TEID.Value);
                    if (tenantPermissions.UnitMaxCount > 0 && tenantPermissions.UnitMaxCount <= times)
                    {
                        throw new Exception("投标单位数量超出最大值！无法新增");
                    }
                }
                dp.IsEn = true;
                dp.IsDeled = false;
                _db.Insertable<Document_TenderUnit>(dp).ExecuteCommand();
            }

            return true;
        }

        public Document_TenderUnit GetDocumentTenderUnitInfo(int ID)
        {
            var result = _db.Queryable<Document_TenderUnit>().Where(x => x.UnitId == ID).First();//执行查询
            return result;
        }



        public PageResult<DocumentEmployeeInfoDTO> postDocumentEmployeeInfoList(DocumentProjectInfoPageSearch page)
        {
            var aaa = GetJwtInfo();

            SqlSugar.PageModel pg = new SqlSugar.PageModel();
            pg.PageSize = page.PageSize;
            pg.PageIndex = page.PageIndex;
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<DocumentEmployeeInfoDTO> result = new PageResult<DocumentEmployeeInfoDTO>();



            var document_EmployeeInfos = _db.Queryable<Document_EmployeeInfo, EmployeeAtTenant>((a, b) =>
              new JoinQueryInfos
              (
             JoinType.Inner, a.EmployeeId == b.EmployeeID && b.TenantID == aaa.TEID

                  )
              )
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.txtName), (a, b) => a.EmployeeName.Contains(page.txtName))


             .OrderByDescending((a, b) => a.EmployeeId).ToPageList(page.PageIndex, page.PageSize, ref total);

 



            var documentEmployeeInfoDTOs = _mapper.Map<List<DocumentEmployeeInfoDTO>>(document_EmployeeInfos);



            if (documentEmployeeInfoDTOs != null && documentEmployeeInfoDTOs.Count > 0)
            {
                var ret = _db.Queryable<Document_EmployeeRole>().ToList();
                foreach (var documentEmployeeInfoDTO in documentEmployeeInfoDTOs)
                {
                    if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value>0)
                    {
                        documentEmployeeInfoDTO.IsWorkName = "在职";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.IsWorkName = "离职";
                    }

                    if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value == 1)
                    {
                        documentEmployeeInfoDTO.LeaveTimeName = "";
                    }
                    else
                    {
                        if (documentEmployeeInfoDTO.LeaveTime.HasValue)
                        {
                            documentEmployeeInfoDTO.LeaveTimeName = documentEmployeeInfoDTO.LeaveTime.Value.ToString("yyyy-MM-dd");
                        }
                        else
                        {
                            documentEmployeeInfoDTO.LeaveTimeName = "";
                        }
                    }

                 var  document_EmployeeRole =   ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 1).FirstOrDefault();
                    if(document_EmployeeRole != null)
                    {
                        documentEmployeeInfoDTO.BMRID = "是";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.BMRID = "否";
                    }

                    var document_EmployeeRole1 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 2).FirstOrDefault();
                    if (document_EmployeeRole1 != null)
                    {
                        documentEmployeeInfoDTO.BSZZRID = "是";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.BSZZRID = "否";
                    }

                    var document_EmployeeRole2 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 3).FirstOrDefault();
                    if (document_EmployeeRole2 != null)
                    {
                        documentEmployeeInfoDTO.TBRID = "是";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.TBRID = "否";
                    }


                }
            }

            result.Items = documentEmployeeInfoDTOs;
            result.TotalCount = total;
            result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;


            return result;
        }

        public bool GetDelDocumentEmployeeInfoInfo(int ID)
        {
            _db.Deleteable<EmployeeAtTenant>().Where(x => x.EmployeeID == ID).ExecuteCommand();
            _db.Deleteable<Document_EmployeeRole>().Where(x => x.EmployeeId == ID).ExecuteCommand();
            _db.Deleteable<Document_EmployeeInfo>().Where(x => x.EmployeeId == ID).ExecuteCommand();
           
           

            return true;
        }

        public bool SaveDocumentEmployeeInfoInfo(DocumentEmployeeInfoDTO dp)
        {
            var document_EmployeeInfo = _mapper.Map<Document_EmployeeInfo>(dp);
            
            if (dp.EmployeeId > 0)
            {
                _db.Updateable<Document_EmployeeInfo>(document_EmployeeInfo).ExecuteCommand();

            }
            else
            {
                var aaa = GetJwtInfo();

              var tenantPermissions =  _db.Queryable<TenantPermissions>().Where(x => x.IsDel == false && x.IsEn == true && x.TenantId == aaa.TEID.Value && x.PermissionsType == TenantPermissionsType.Manage).First();
                if (tenantPermissions != null)
                {
                  var times  =  _db.Queryable<EmployeeAtTenant>().Count(x => x.IsDel == false && x.IsEn == true && x.TenantID == aaa.TEID.Value );
                    if(tenantPermissions.EmployeeMaxCount>0 && tenantPermissions.EmployeeMaxCount<= times)
                    {
                        throw new Exception("员工数量超出最大值！无法新增");
                    }
                }

                dp.EmployeeId =  _db.Insertable<Document_EmployeeInfo>(document_EmployeeInfo).ExecuteReturnIdentity();

                EmployeeAtTenant employeeAtTenant = new EmployeeAtTenant();
                employeeAtTenant.EmployeeID = dp.EmployeeId;
                employeeAtTenant.TenantID = aaa.TEID.Value;
                _db.Insertable<EmployeeAtTenant>(employeeAtTenant).ExecuteCommand();
            }


            if (!string.IsNullOrEmpty(dp.BMRID) && !string.IsNullOrEmpty(dp.BSZZRID) && !string.IsNullOrEmpty(dp.TBRID))
            {
                _db.Deleteable<Document_EmployeeRole>().Where(x => x.EmployeeId == dp.EmployeeId).ExecuteCommand();
                if (dp.BMRID == "是")
                {
                    Document_EmployeeRole document_EmployeeRole = new Document_EmployeeRole();
                    document_EmployeeRole.EmployeeId = dp.EmployeeId;
                    document_EmployeeRole.RoleType = 1;
                    _db.Insertable<Document_EmployeeRole>(document_EmployeeRole).ExecuteCommand();
                }
                if (dp.BSZZRID == "是")
                {
                    Document_EmployeeRole document_EmployeeRole = new Document_EmployeeRole();
                    document_EmployeeRole.EmployeeId = dp.EmployeeId;
                    document_EmployeeRole.RoleType = 2;
                    _db.Insertable<Document_EmployeeRole>(document_EmployeeRole).ExecuteCommand();
                }
                if (dp.TBRID == "是")
                {
                    Document_EmployeeRole document_EmployeeRole = new Document_EmployeeRole();
                    document_EmployeeRole.EmployeeId = dp.EmployeeId;
                    document_EmployeeRole.RoleType = 3;
                    _db.Insertable<Document_EmployeeRole>(document_EmployeeRole).ExecuteCommand();
                }
            }

            return true;
        }

        public DocumentEmployeeInfoDTO GetDocumentEmployeeInfoInfo(int ID)
        {
            var result = _db.Queryable<Document_EmployeeInfo>().Where(x => x.EmployeeId == ID).First();//执行查询

            var documentEmployeeInfoDTO = _mapper.Map<DocumentEmployeeInfoDTO>(result);



            if (documentEmployeeInfoDTO != null )
            {
                var ret = _db.Queryable<Document_EmployeeRole>().ToList();
 
                    if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value > 0)
                    {
                        documentEmployeeInfoDTO.IsWorkName = "在职";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.IsWorkName = "离职";
                    }

                    if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value == 1)
                    {
                        documentEmployeeInfoDTO.LeaveTimeName = "";
                    }
                    else
                    {
                        if (documentEmployeeInfoDTO.LeaveTime.HasValue)
                        {
                            documentEmployeeInfoDTO.LeaveTimeName = documentEmployeeInfoDTO.LeaveTime.Value.ToString("yyyy-MM-dd");
                        }
                        else
                        {
                            documentEmployeeInfoDTO.LeaveTimeName = "";
                        }
                    }

                    var document_EmployeeRole = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 1).FirstOrDefault();
                    if (document_EmployeeRole != null)
                    {
                        documentEmployeeInfoDTO.BMRID = "是";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.BMRID = "否";
                    }

                    var document_EmployeeRole1 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 2).FirstOrDefault();
                    if (document_EmployeeRole1 != null)
                    {
                        documentEmployeeInfoDTO.BSZZRID = "是";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.BSZZRID = "否";
                    }

                    var document_EmployeeRole2 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 3).FirstOrDefault();
                    if (document_EmployeeRole2 != null)
                    {
                        documentEmployeeInfoDTO.TBRID = "是";
                    }
                    else
                    {
                        documentEmployeeInfoDTO.TBRID = "否";
                    }


                
            }

            return documentEmployeeInfoDTO;
        }

        public Document_EmployeeInfo GetDocumentEmployeeInfoByName(string EmployeeName)
        {
            var aaa = GetJwtInfo();
            var documentEmployeeInfoDTO = _db.Queryable<Document_EmployeeInfo, EmployeeAtTenant>((a, b) =>
             new JoinQueryInfos
             (
            JoinType.Inner, a.EmployeeId == b.EmployeeID && b.TenantID == aaa.TEID
            )
            )
            //文件名称
            .Where((a, b) => a.EmployeeName == EmployeeName).First();

            
           


            return documentEmployeeInfoDTO;
        }


        public Document_EmployeeInfo GetDocumentEmployeeInfoByLoginName(string textUserName)
        {
            var aaa = GetJwtInfo();
            var documentEmployeeInfoDTO = _db.Queryable<Document_EmployeeInfo, EmployeeAtTenant>((a, b) =>
             new JoinQueryInfos
             (
            JoinType.Inner, a.EmployeeId == b.EmployeeID && b.TenantID == aaa.TEID
            )
            )
            //文件名称
            .Where((a, b) => a.UserName == textUserName).First();





            return documentEmployeeInfoDTO;
        }


        public PageResult<Document_PerformanceInfo> GetDocumentPerformanceInfoListByPaper(DocumentProjectInfoPageSearch page)
        {
            var aaa = GetJwtInfo();
            List<Document_PerformanceInfo> m_Document_PerformanceInfoList = new List<Document_PerformanceInfo>();
            SqlSugar.PageModel pg = new SqlSugar.PageModel();
            pg.PageSize = page.PageSize;
            pg.PageIndex = page.PageIndex;
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<Document_PerformanceInfo> result = new PageResult<Document_PerformanceInfo>();

            DateTime txtWorkStartTime = string.IsNullOrEmpty(page.txtWorkStartTime) ? DateTime.MinValue :  DateTime.Parse(page.txtWorkStartTime);
            DateTime txtWorkEndTime = string.IsNullOrEmpty(page.txtWorkEndTime) ? DateTime.MaxValue : DateTime.Parse(page.txtWorkEndTime);

            var dt_Signup = _db.Queryable<Document_ProjectExpand, Document_ProjectInfo>((a, b) =>
              new JoinQueryInfos
              (
             JoinType.Inner, a.ProjectId == b.ProjectId && b.TenantID == aaa.TEID

                  )
              )
                .Where((a, b) => a.IsSignup == 1)
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.txtWorkStartTime), (a, b) => a.SignupTime >= txtWorkStartTime)
             .WhereIF(!string.IsNullOrEmpty(page.txtWorkEndTime), (a, b) => a.SignupTime <= txtWorkEndTime)
             .WhereIF(!string.IsNullOrEmpty(page.txtEmployeeId) && page.txtEmployeeId != "请选择" , (a, b) => a.SignupPerson == page.txtEmployeeId)
             .WhereIF(!string.IsNullOrEmpty(page.projectName), (a, b) => b.ProjectName.Contains(page.projectName))
              .WhereIF(!string.IsNullOrEmpty(page.txtWorkItem), (a, b) => "报名" == page.txtWorkItem)
              .Select((a, b) =>new Document_PerformanceInfo
              {
                  WorkTime = a.SignupTime,
                  EmployeeName = a.SignupPerson,
                  Price = a.SignupAllowance,
                  ProjectName = b.ProjectName,
                  WorkItem = "报名",
              }).ToList()
             ;


            var dt_Document = _db.Queryable<Document_ProjectExpand, Document_ProjectInfo, Document_ProjectDocumentInfo>((a, b,c) =>
             new JoinQueryInfos
             (
            JoinType.Inner, a.ProjectId == b.ProjectId && b.TenantID == aaa.TEID,
            JoinType.Left, a.ProjectId == c.ProjectId
                 )
             )
               .Where((a, b, c) => a.DocumentStatus == 17)
            //文件名称
            .WhereIF(!string.IsNullOrEmpty(page.txtWorkStartTime), (a, b, c) => c.LastUpdateTime >= txtWorkStartTime)
            .WhereIF(!string.IsNullOrEmpty(page.txtWorkEndTime), (a, b, c) => c.LastUpdateTime <= txtWorkEndTime)
            .WhereIF(!string.IsNullOrEmpty(page.txtEmployeeId) && page.txtEmployeeId != "请选择", (a, b) => a.DocumentManager == page.txtEmployeeId)
            .WhereIF(!string.IsNullOrEmpty(page.projectName), (a, b, c) => b.ProjectName.Contains(page.projectName))
             .WhereIF(!string.IsNullOrEmpty(page.txtWorkItem), (a, b, c) => "标书制作" == page.txtWorkItem)
             .Select((a, b, c) => new Document_PerformanceInfo
             {
                 WorkTime = c.LastUpdateTime,
                 EmployeeName = a.DocumentManager,
                 Price = a.DocumentPrice,
                 ProjectName = b.ProjectName,
                 WorkItem = "标书制作",
             }).ToList()
            ;

            var dt_Tender = _db.Queryable<Document_ProjectExpand, Document_ProjectInfo>((a, b) =>
            new JoinQueryInfos
            (
           JoinType.Inner, a.ProjectId == b.ProjectId && b.TenantID == aaa.TEID
                )
            )
              .Where((a, b) => a.TenderStatus == 1)
           //文件名称
           .WhereIF(!string.IsNullOrEmpty(page.txtWorkStartTime), (a, b) => b.TenderTime >= txtWorkStartTime)
           .WhereIF(!string.IsNullOrEmpty(page.txtWorkEndTime), (a, b) => b.TenderTime <= txtWorkEndTime)
           .WhereIF(!string.IsNullOrEmpty(page.txtEmployeeId) && page.txtEmployeeId != "请选择", (a, b) => a.TenderPerson == page.txtEmployeeId)
           .WhereIF(!string.IsNullOrEmpty(page.projectName), (a, b) => b.ProjectName.Contains(page.projectName))
            .WhereIF(!string.IsNullOrEmpty(page.txtWorkItem), (a, b) => "投标" == page.txtWorkItem)
            .Select((a, b) => new Document_PerformanceInfo
            {
                WorkTime = b.TenderTime,
                EmployeeName = a.DocumentManager,
                Price = a.DocumentPrice,
                ProjectName = b.ProjectName,
                WorkItem = "投标",
            }).ToList();
            var newDataTable = new List<Document_PerformanceInfo>();
            object[] obj = new object[newDataTable.Count];

            for (int i = 0; i < dt_Signup.Count; i++)
            {

                newDataTable.Add(dt_Signup[i]);
            }
            for (int i = 0; i < dt_Document.Count; i++)
            {

                newDataTable.Add(dt_Document[i]);
            }

            for (int i = 0; i < dt_Tender.Count; i++)
            {
              
                newDataTable.Add(dt_Tender[i]);
            }

            for (int i = 0; i < newDataTable.Count; i++)
            {
                Document_PerformanceInfo m_Document_PerformanceInfo = new Document_PerformanceInfo();
                m_Document_PerformanceInfo.EmployeeId = 0;
                m_Document_PerformanceInfo.Id = 0;
                m_Document_PerformanceInfo.ProjectName = newDataTable[i].ProjectName;
                m_Document_PerformanceInfo.WorkItem = newDataTable[i].WorkItem;
                if (newDataTable[i].Price.HasValue)
                {
                    m_Document_PerformanceInfo.Price = newDataTable[i].Price;
                }
                else
                {
                    m_Document_PerformanceInfo.Price = 0;
                }
                m_Document_PerformanceInfo.EmployeeName = newDataTable[i].EmployeeName;
                m_Document_PerformanceInfo.WorkTime = newDataTable[i].WorkTime;



                if (m_Document_PerformanceInfo.Price.HasValue && m_Document_PerformanceInfo.Price.Value>0)
                {
                    m_Document_PerformanceInfoList.Add(m_Document_PerformanceInfo);
                    result.AllPageMoney += m_Document_PerformanceInfo.Price.Value;
                }
            }
           ;



           



            //.ToPageList(page.PageIndex, page.PageSize, ref total);




          var  document_PerformanceInfos  =  m_Document_PerformanceInfoList.Skip(page.PageIndex - 1).Take(page.PageSize).ToList();

            foreach (var item in document_PerformanceInfos)
            {
                result.NowPageMoney += item.Price.Value;
            }
           

            result.Items = document_PerformanceInfos;
            result.TotalCount = total;
            result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;


            return result;
        }

        /// <summary>
        /// 获取Jwt相关信息
        /// </summary>
        public Model.JwtInfo GetJwtInfo()
        {
            Model.JwtInfo jwtInfo = new Model.JwtInfo();
            jwtInfo.LogInSource = (Model.LogInFrom)(App.User?.FindFirstValue("loginfrom")?.ObjToInt() ?? 0);
            jwtInfo.EID = App.User?.FindFirstValue("eid")?.ObjToInt();
            jwtInfo.UID = App.User?.FindFirstValue("uid")?.ObjToInt();
            jwtInfo.TEID = App.User?.FindFirstValue("teid")?.ObjToInt();
            var guid = App.User?.FindFirstValue("jid");
            jwtInfo.JID = string.IsNullOrEmpty(guid) ? null : new Guid(guid);
            return jwtInfo;
        }


        public PageResult<DocumentProjectInfoDTO> postGetFinancialList(DocumentProjectInfoPageSearch page)
        {
            var aaa = GetJwtInfo();

            SqlSugar.PageModel pg = new SqlSugar.PageModel();
            pg.PageSize = page.PageSize;
            pg.PageIndex = page.PageIndex;
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<DocumentProjectInfoDTO> result = new PageResult<DocumentProjectInfoDTO>();



            result.Items = _db.Queryable<Document_ProjectInfo, Document_ProjectExpand>((a, d) =>
              new JoinQueryInfos
              (
             JoinType.Left, a.ProjectId == d.ProjectId && d.UnitId == page.UnitId
                
                  ))
                .Where((a, d) => a.TenantID == aaa.TEID)
                //省
                .WhereIF(!string.IsNullOrEmpty(page.Province) && page.Province != "请选择", (a, d) => (a.Province == page.Province))
                //市
                .WhereIF(!string.IsNullOrEmpty(page.City) && page.City != "请选择", (a, d) => (a.City == page.City))
                //区县
                .WhereIF(!string.IsNullOrEmpty(page.County) && page.County != "请选择", (a, d) => (a.County == page.County))
            //报名时间
                .WhereIF(!string.IsNullOrEmpty(page.ddlSignupStartTime), (a, d) => a.SignupStartTime >= DateTime.Parse(page.ddlSignupStartTime))
                //报名时间
                .WhereIF(!string.IsNullOrEmpty(page.ddlSignupEndTime), (a, d) => a.SignupEndTime <= DateTime.Parse(page.ddlSignupEndTime))
            //开标时间
            .WhereIF(!string.IsNullOrEmpty(page.ddlTenderStartTime), (a, d) => a.TenderTime >= DateTime.Parse(page.ddlTenderStartTime))
            //开标时间
            .WhereIF(!string.IsNullOrEmpty(page.ddlTenderEndTime), (a, d) => a.TenderTime <= DateTime.Parse(page.ddlTenderEndTime))
             //采购方式
             .WhereIF(page.ddlPurchaseMethod > 0, (a, d) => a.PurchaseMethod == page.ddlPurchaseMethod)
             //项目名称
             .WhereIF(!string.IsNullOrEmpty(page.txtProjectName), (a, d) => a.ProjectName.Contains(page.txtProjectName))
              //项目编号
              .WhereIF(!string.IsNullOrEmpty(page.txtProjectCode), (a, d) => a.ProjectCode.Contains(page.txtProjectCode))
                //采购单位
                .WhereIF(!string.IsNullOrEmpty(page.txtPurchaseUnit), (a, d) => a.PurchaseUnit.Contains(page.txtPurchaseUnit))
                 //代理机构
                 .WhereIF(!string.IsNullOrEmpty(page.txtAgencyUnit), (a, d) => a.AgencyUnit.Contains(page.txtAgencyUnit))
                   ////投标人
                   //.WhereIF(!string.IsNullOrEmpty(page.txtTenderPerson), (a, d) => d.TenderPerson.Contains(page.txtTenderPerson))
                   // //专家
                   // .WhereIF(!string.IsNullOrEmpty(page.Experts), (a, d) => d.Experts.Contains(page.Experts))
                   //  //报名状态
                   //  .WhereIF(page.ddlSignUp > 0 && page.ddlSignUp == 1, (a, d) => (d.IsSignup == 0 || d.IsSignup == null))
                   //   .WhereIF(page.ddlSignUp > 0 && page.ddlSignUp != 1, (a, d) => d.IsSignup == 1)
                       //保证金状态
                       .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 12, (a, d) => d.TenderDepositStatus == null)
                        .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 36, (a, d) => a.TenderTime < DateTime.Now.AddDays(15) && d.TenderDepositStatus == 13)
                      .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit != 12 && page.ddlTenderDeposit != 36, (a, d) => d.TenderDepositStatus == page.ddlTenderDeposit)
              //履约金状态
              .WhereIF(page.ddlBidbond > 0 && page.ddlBidbond == 32, (a, d) => (d.BidbondStatus == null))
                      .WhereIF(page.ddlBidbond > 0 && page.ddlBidbond != 32, (a, d) => d.BidbondStatus == page.ddlBidbond)
              // //标书状态
              // .WhereIF(page.ddlDocumentStatus > 0 && page.ddlDocumentStatus == 15, (a, d) => (d.DocumentStatus == null || d.DocumentStatus == 0 || d.DocumentStatus == 15))
              //        .WhereIF(page.ddlDocumentStatus > 0 && page.ddlDocumentStatus != 15, (a, d) => d.DocumentStatus == page.ddlDocumentStatus)
              //       //投标状态
              //       .WhereIF(page.ddlTenderStatus > 0 && page.ddlTenderStatus == 1, (a, d) => (d.TenderStatus == null || d.TenderStatus == 0))
              //        .WhereIF(page.ddlTenderStatus > 0 && page.ddlTenderStatus != 1, (a, d) => d.TenderStatus == 1)
              ////中标情况
              //.WhereIF(page.ddlWinStatus > 0 && page.ddlWinStatus == 1, (a, d) => n.IsWin == null)
              //        .WhereIF(page.ddlWinStatus > 0 && page.ddlWinStatus != 1, (a, d) => n.IsWin == (page.ddlWinStatus - 1))
              ////质疑情况
              //.WhereIF(page.ddlOppugnStatus > 0 && page.ddlOppugnStatus == 1, (a, d) => (e.FilePath == null || e.FilePath == ""))
              //        .WhereIF(page.ddlOppugnStatus > 0 && page.ddlOppugnStatus != 1, (a, d) => (e.FilePath != null && e.FilePath != ""))
              ////投诉情况
              //.WhereIF(page.ddlComplainStatus > 0 && page.ddlComplainStatus == 1, (a, d) => (f.FilePath == null || f.FilePath == ""))
              //        .WhereIF(page.ddlComplainStatus > 0 && page.ddlComplainStatus != 1, (a, d) => (f.FilePath != null && f.FilePath != ""))
              //             //复议情况
              //             .WhereIF(page.ddlReviewStatus > 0 && page.ddlReviewStatus == 1, (a, d) => (g.FilePath == null || g.FilePath == ""))
              //        .WhereIF(page.ddlReviewStatus > 0 && page.ddlReviewStatus != 1, (a, d) => (g.FilePath != null && g.FilePath != ""))
              // //诉讼情况
              // .WhereIF(page.ddlLitigationStatus > 0 && page.ddlLitigationStatus == 1, (a, d) => (h.FilePath == null || h.FilePath == ""))
              //        .WhereIF(page.ddlLitigationStatus > 0 && page.ddlLitigationStatus != 1, (a, d) => (h.FilePath != null && h.FilePath != ""))
             .Select((a, d) => new DocumentProjectInfoDTO
             {
                 ProjectId = a.ProjectId,
                 SignupStartTime = a.SignupStartTime,
                 Province = a.Province,
                 City = a.City,
                 County = a.County,
                 ProjectName = a.ProjectName,
                 PurchaseUnit = a.PurchaseUnit,
                 AgencyUnit = a.AgencyUnit,
                 TenderTime = a.TenderTime,
                 TenderPerson = d.TenderPerson,
                 IsSignup = d.IsSignup,
                 TenderDepositStatus = d.TenderDepositStatus,
                 BidbondStatus = d.BidbondStatus,
                 TenderStatus = d.TenderStatus,
                 tbqk = "投标情况",
                 wj = "",
                 NoticeTypeName = "招标公告",
                 NoticeType = a.NoticeType,
                 PurchaseMethod = a.PurchaseMethod,
                 DocumentStatus = d.DocumentStatus,
                 TenderDepositStartTime = d.TenderDepositStartTime,
                 TenderDeposit = a.TenderDeposit,
                 TenderDepositEndTime = d.TenderDepositEndTime,
                 BidbondStartTime = d.BidbondStartTime,
                 BidbondEndTime = d.BidbondEndTime,
                 Bidbond = a.Bidbond,
             }
              )
             .OrderByDescending(a => a.ProjectId).ToPageList(page.PageIndex, page.PageSize, ref total);


            result.TotalCount = total;
            result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;

            if (result.Items != null && result.Items.Count > 0)
            {
                var ret = _db.Queryable<Document_Dictionary>().ToList();
                foreach (var documentProjectInfoDTO in result.Items)
                {
                    if (documentProjectInfoDTO.City == "请选择" && documentProjectInfoDTO.County == "请选择")
                    {
                        documentProjectInfoDTO.xmqy = documentProjectInfoDTO.Province;
                    }
                    else if (documentProjectInfoDTO.City == "请选择" && documentProjectInfoDTO.County == "其他")
                    {
                        documentProjectInfoDTO.xmqy = documentProjectInfoDTO.City;
                    }
                    else
                    {
                        documentProjectInfoDTO.xmqy = documentProjectInfoDTO.City + documentProjectInfoDTO.County;
                    }

                    //if (documentProjectInfoDTO.IsSignup == 1)
                    //{
                    //    documentProjectInfoDTO.bm = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.bm = "报名";
                    //}

                    if (!documentProjectInfoDTO.TenderDepositStatus.HasValue || documentProjectInfoDTO.TenderDepositStatus == 0)
                    {
                        documentProjectInfoDTO.bzj = "缴费";
                    }
                    else if (documentProjectInfoDTO.TenderDepositStatus == 13)
                    {
                        documentProjectInfoDTO.bzj = "退款";
                    }
                    else
                    {
                        documentProjectInfoDTO.bzj = "√";
                    }

                    if (!documentProjectInfoDTO.BidbondStatus.HasValue || documentProjectInfoDTO.BidbondStatus == 0)
                    {
                        documentProjectInfoDTO.lybzj = "缴费";
                    }
                    else if (documentProjectInfoDTO.BidbondStatus == 33)
                    {
                        documentProjectInfoDTO.lybzj = "退款";
                    }
                    else
                    {
                        documentProjectInfoDTO.lybzj = "√";
                    }

                    //if (documentProjectInfoDTO.TenderStatus == 1)
                    //{
                    //    documentProjectInfoDTO.tb = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.tb = "投标";
                    //}

                    //if (documentProjectInfoDTO.DocumentStatus == 17)
                    //{
                    //    documentProjectInfoDTO.bs = "√";
                    //}
                    //else if (documentProjectInfoDTO.DocumentStatus == 16)
                    //{
                    //    documentProjectInfoDTO.bs = "制作中";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.bs = "未制作";
                    //}


                    //if (!documentProjectInfoDTO.IsWin.HasValue || documentProjectInfoDTO.IsWin <= 0)
                    //{
                    //    documentProjectInfoDTO.zb = "中标";
                    //}
                    //else if (documentProjectInfoDTO.IsWin == 2)
                    //{
                    //    documentProjectInfoDTO.zb = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.zb = "×";
                    //}

                    //if (documentProjectInfoDTO.IsAdvise == 1)
                    //{
                    //    documentProjectInfoDTO.Advise = "方案保存";// "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.Advise = "方案保存";
                    //}

                    //if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathzy))
                    //{
                    //    documentProjectInfoDTO.zy = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.zy = "";
                    //}

                    //if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathts))
                    //{
                    //    documentProjectInfoDTO.ts = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.ts = "";
                    //}


                    //if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathfy))
                    //{
                    //    documentProjectInfoDTO.fy = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.fy = "";
                    //}


                    //if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathss))
                    //{
                    //    documentProjectInfoDTO.ss = "√";
                    //}
                    //else
                    //{
                    //    documentProjectInfoDTO.ss = "";
                    //}
                    //if (documentProjectInfoDTO.PurchaseMethod.HasValue && documentProjectInfoDTO.PurchaseMethod.Value > 0)
                    //{
                    //    var document_Dictionary = ret.Where(x => x.Id == documentProjectInfoDTO.PurchaseMethod).FirstOrDefault();
                    //    if (document_Dictionary != null)
                    //    {
                    //        documentProjectInfoDTO.PurchaseMethodName = document_Dictionary.Name;
                    //    }
                    //}

                }
            }

            return result;
        }



        public PageResult<Document_LayInfo> postDocumentLayInfoList(DocumentProjectInfoPageSearch page)
        {
            var aaa = GetJwtInfo();

            SqlSugar.PageModel pg = new SqlSugar.PageModel();
            pg.PageSize = page.PageSize;
            pg.PageIndex = page.PageIndex;
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<Document_LayInfo> result = new PageResult<Document_LayInfo>();



            result.Items = _db.Queryable<Document_LayInfo>()
                .Where(a => (a.TenantID == aaa.TEID || a.IsSys == 1))
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.LayName), a => a.LayName == page.LayName)
              .WhereIF(!string.IsNullOrEmpty(page.LayType) && page.LayType != "请选择", a => a.LayType == page.LayType)
                .WhereIF(!string.IsNullOrEmpty(page.LayProvince), a => a.LayProvince == page.LayProvince)

             .OrderByDescending(a => a.LayId).ToPageList(page.PageIndex, page.PageSize, ref total);


            result.TotalCount = total;
            result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;



            return result;
        }

        public bool GetDelDocumentLayInfo(int ID)
        {
            _db.Deleteable<Document_LayInfo>().Where(x => x.LayId == ID).ExecuteCommand();



            return true;
        }

        public bool SaveDocumentLayInfo(Document_LayInfo dp)
        {
            if (dp.LayId > 0)
            {
                _db.Updateable<Document_LayInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_LayInfo>(dp).ExecuteCommand();
            }
            return true;
        }

        public Document_LayInfo GetDocumentLayInfo(int ID)
        {
            var result = _db.Queryable<Document_LayInfo>().Where(x => x.LayId == ID).First();//执行查询
            return result;
        }

        public Document_LayInfo GetDocumentLayInfoByName(string LayName)
        {
            var aaa = GetJwtInfo();
            var result = _db.Queryable<Document_LayInfo>().Where(x => x.LayName == LayName && x.TenantID == aaa.EID).First();//执行查询
            return result;
        }
    }
}