最新代码

username@email.com

2023-10-17 3f4013e9283d1fe29ef40cc8b4d7ee7a590a1590

 DocumentServiceAPI.Application/ProjectInfo/Services/ProjectInfoService.cs

@@ -24,8 +24,10 @@
using SqlSugar.Extensions;
using System;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics.Metrics;
using System.Linq;
using System.Reflection.Emit;
using System.Reflection.Metadata;
using System.Runtime.Intrinsics.Arm;
using System.Runtime.Intrinsics.X86;
@@ -613,8 +615,8 @@
            //page.ToEmployeeId = a.EID;
            int total = 0;
            PageResult<DocumentProjectInfoDTO> result = new PageResult<DocumentProjectInfoDTO>();
             

             //var document_OtherCompanyTenderInfos  =  _db.Queryable<Document_OtherCompanyTenderInfo>().Where(x => x.TenantID == aaa.TEID).ToList();

            result.Items = _db.Queryable<Document_ProjectInfo, Document_ProjectExpand, Document_ProjectOppugnInfo, Document_ProjectComplainInfo, Document_ProjectReviewInfo, Document_ProjectLitigationInfo, Document_AdviseInfo, Document_ProjectComplainInfo, Document_ProjectOppugnInfo, Document_ProjectLitigationInfo, Document_ProjectReviewInfo, Document_WinInfo>((a, d, e,f,g,h,i,j,k,l,m,n) =>
              new JoinQueryInfos
@@ -664,11 +666,11 @@
                     .WhereIF(page.ddlSignUp > 0 && page.ddlSignUp == 1, (a, d, e, f, g, h, i, j, k, l, m, n) => (d.IsSignup == 0 || d.IsSignup == null))
                      .WhereIF(page.ddlSignUp > 0 && page.ddlSignUp != 1, (a, d, e, f, g, h, i, j, k, l, m, n) => d.IsSignup == 1 )
                       //保证金状态
                       .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 12, (a, d, e, f, g, h, i, j, k, l, m, n) => d.TenderDepositStatus == null)
                       .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 12, (a, d, e, f, g, h, i, j, k, l, m, n) => a.TenderDeposit != null && a.TenderDeposit > 0 && d.TenderDepositStatus == null)
                        .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 36, (a, d, e, f, g, h, i, j, k, l, m, n) => a.TenderTime < DateTime.Now.AddDays(15) && d.TenderDepositStatus == 13 )
                      .WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit != 12 && page.ddlTenderDeposit != 36, (a, d, e, f, g, h, i, j, k, l, m, n) => d.TenderDepositStatus == page.ddlTenderDeposit)
              //履约金状态
              .WhereIF(page.ddlBidbond > 0 && page.ddlBidbond == 32, (a, d, e, f, g, h, i, j, k, l, m, n) => (d.BidbondStatus == null))
              .WhereIF(page.ddlBidbond > 0 && page.ddlBidbond == 32, (a, d, e, f, g, h, i, j, k, l, m, n) => (a.Bidbond!=null && a.Bidbond >0 && d.BidbondStatus == null))
                      .WhereIF(page.ddlBidbond > 0 && page.ddlBidbond != 32, (a, d, e, f, g, h, i, j, k, l, m, n) => d.BidbondStatus == page.ddlBidbond )
               //标书状态
               .WhereIF(page.ddlDocumentStatus > 0 && page.ddlDocumentStatus == 15, (a, d, e, f, g, h, i, j, k, l, m, n) => (d.DocumentStatus == null || d.DocumentStatus == 0 || d.DocumentStatus == 15))
@@ -691,6 +693,9 @@
               //诉讼情况
               .WhereIF(page.ddlLitigationStatus > 0 && page.ddlLitigationStatus == 1, (a, d, e, f, g, h, i, j, k, l, m, n) => (h.FilePath == null || h.FilePath == ""))
                      .WhereIF(page.ddlLitigationStatus > 0 && page.ddlLitigationStatus != 1, (a, d, e, f, g, h, i, j, k, l, m, n) => (h.FilePath != null && h.FilePath != ""))

               .WhereIF(!string.IsNullOrEmpty(page.txtCompanyName), (a, d, e, f, g, h, i, j, k, l, m, n) => (n.FirstWinCompany.Contains(page.txtCompanyName) || n.SecondWinCompany.Contains(page.txtCompanyName) || n.ThirdCompany.Contains(page.txtCompanyName) || SqlFunc.Subqueryable<Document_OtherCompanyTenderInfo>().Where(s => s.TenantID == a.TenantID && s.ProjectId == a.ProjectId && s.CompanyName.Contains(page.txtCompanyName)).Any()))

             .Select((a, d, e, f, g, h, i, j, k, l, m, n) => new DocumentProjectInfoDTO
             {
                 ProjectId = a.ProjectId,
@@ -718,7 +723,9 @@
                 NoticeTypeName = "招标公告",
                 NoticeType = a.NoticeType,
                 PurchaseMethod = a.PurchaseMethod,
                 DocumentStatus = d.DocumentStatus
                 DocumentStatus = d.DocumentStatus,
                 SignupMethod = a.SignupMethod,
                  
             }
              )
             .OrderByDescending(a => a.ProjectId).ToPageList(page.PageIndex, page.PageSize, ref total);
@@ -745,7 +752,7 @@
                        documentProjectInfoDTO.xmqy = documentProjectInfoDTO.City+ documentProjectInfoDTO.County;
                    }

                    if(documentProjectInfoDTO.IsSignup == 1)
                    if(documentProjectInfoDTO.IsSignup == 1 || documentProjectInfoDTO.SignupMethod == 9   )
                    {
                        documentProjectInfoDTO.bm = "√";
                    }
@@ -818,11 +825,11 @@

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

                    if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathzy))
@@ -870,7 +877,18 @@
                            documentProjectInfoDTO.PurchaseMethodName = document_Dictionary.Name;
                        }
                    }
                   

                    var sss = _db.Queryable<Document_ZhaobiaoFile>().Count(x => x.ProjectId == documentProjectInfoDTO.ProjectId && x.UnitId == page.UnitId);
                    if (sss > 0)
                    {
                        documentProjectInfoDTO.zbwj = "√";
                    }
                    else
                    {
                        documentProjectInfoDTO.zbwj = "招标文件";
                    }


                }
            }

@@ -957,7 +975,117 @@

        public Document_WinInfo GetDocument_WinInfo(int ID, int UnitId)
        {
            var aaa = GetJwtInfo();
            var ret = _db.Queryable<Document_WinInfo>().Where(x => x.ProjectId == ID && x.UnitId == UnitId ).First();
            if (ret == null || string.IsNullOrEmpty(ret.FirstWinCompany))
            {
              
               var projectInfo  = _db.Queryable<Document_ProjectInfo>().Where(x => x.ProjectId == ID && x.TenantID == aaa.TEID).First();
                if (projectInfo != null)
                {
                    _db.AsTenant().ChangeDatabase("zhengcaioa");
                    var sss = _db.Ado.GetDataTable("select [Id]     ,[start_time]     ,[sheng]      ,[city]      ,[area_id]      ,[cgfs]      ,[number]      ,[name] from Project where number=@number", new { number = projectInfo.ProjectCode });
                    if(sss!=null && sss.Rows.Count > 0)
                    {
                        ret = new Document_WinInfo();
                        ret.ProjectId = ID;
                        ret.UnitId = UnitId;
                        ret.IsWin = 0;
                        foreach (DataRow row  in sss.Rows)
                        {
                            var aaaaaaaa = _db.Ado.GetDataTable("select [zhongbiaoId]     ,[ProjectId]      ,[names]      ,[price]      ,[defen]     ,[zb_zhiyistatus]     ,[zb_zhiyishijian]      ,[zb_zhiyichengli]      ,[zb_tousustatus]      ,[zb_tousushijian]      ,[zb_tousuchengli] from Projectzhongbiao where ProjectId=@ProjectId", new { ProjectId = Convert.ToString(row["Id"]).Trim() });
                            if (aaaaaaaa != null && aaaaaaaa.Rows.Count > 0)
                            {
                                int i = 0;
                                foreach (DataRow row0 in aaaaaaaa.Rows)
                                {

                                    if (i == 0)
                                    {
                                        
                                        ret.FirstWinCompany = Convert.ToString(row0["names"]).Trim();
                                        if(row0["price"]!=null && !string.IsNullOrEmpty(row0["price"].ToString()))
                                        {
                                            string price = row0["price"].ToString().Trim().Replace("元", "").Replace("万", "");
                                            decimal priceprice = 0;

                                           if(decimal.TryParse(price,out priceprice))
                                            {
                                                ret.FirstPrice = priceprice;
                                            }
                                        }
                                        ret.FirstWinDefen = Convert.ToString(row0["defen"]).Trim();
                                    }
                                    if (i == 1)
                                    {
                                        ret.SecondWinCompany = Convert.ToString(row0["names"]).Trim();
                                        if (row0["price"] != null && !string.IsNullOrEmpty(row0["price"].ToString()))
                                        {
                                            string price = row0["price"].ToString().Trim().Replace("元", "").Replace("万", "");
                                            decimal priceprice = 0;

                                            if (decimal.TryParse(price, out priceprice))
                                            {
                                                ret.SecondPrice = priceprice;
                                            }
                                        }
                                        ret.SecondWinDefen = Convert.ToString(row0["defen"]).Trim();
                                    }
                                    if (i == 2)
                                    {
                                        ret.ThirdCompany = Convert.ToString(row0["names"]).Trim();
                                        if (row0["price"] != null && !string.IsNullOrEmpty(row0["price"].ToString()))
                                        {
                                            string price = row0["price"].ToString().Trim().Replace("元", "").Replace("万", "");
                                            decimal priceprice = 0;

                                            if (decimal.TryParse(price, out priceprice))
                                            {
                                                ret.ThirdPrice = priceprice;
                                            }
                                        }
                                        ret.ThirdWinDefen = Convert.ToString(row0["defen"]).Trim();
                                    }

                                    i += 1;
                                }


                              



                                    //if (aaaaaaaa.Rows.Count > 0)
                                    //{
                                    //    DataRow row0 = aaaaaaaa.Rows[0];
                                    //    ret.FirstWinCompany = Convert.ToString(row0.ItemArray[2]).Trim();
                                    //    ret.FirstPrice = Convert.ToDecimal(row0.ItemArray[3]);
                                    //    ret.FirstWinDefen = Convert.ToString(row0.ItemArray[4]).Trim();
                                    //}
                                    //if (aaaaaaaa.Rows.Count > 1)
                                    //{
                                    //    DataRow row1 = aaaaaaaa.Rows[1];
                                    //    ret.SecondWinCompany = Convert.ToString(row1.ItemArray[2]).Trim();
                                    //    ret.SecondPrice = Convert.ToDecimal(row1.ItemArray[3]);
                                    //    ret.SecondWinDefen = Convert.ToString(row1.ItemArray[4]).Trim();
                                    //}
                                    //if (aaaaaaaa.Rows.Count > 2)
                                    //{
                                    //    DataRow row2 = aaaaaaaa.Rows[2];
                                    //    ret.ThirdCompany = Convert.ToString(row2.ItemArray[2]).Trim();
                                    //    ret.ThirdPrice = Convert.ToDecimal(row2.ItemArray[3]);
                                    //    ret.ThirdWinDefen = Convert.ToString(row2.ItemArray[4]).Trim();
                                    //}

                                    break;
                            }
                        }
                    } 
                }
             
            }


            return ret;
        }

@@ -993,7 +1121,52 @@

        public List<Document_OtherCompanyTenderInfo> GetOtherCompanyTenderInfoList(int ID, int TenantID)
        {
            var aaa = GetJwtInfo();

            var ret = _db.Queryable<Document_OtherCompanyTenderInfo>().Where(x => x.ProjectId == ID && x.TenantID == TenantID).ToList();
            if (ret == null || ret.Count==0)
            {

                var projectInfo = _db.Queryable<Document_ProjectInfo>().Where(x => x.ProjectId == ID && x.TenantID == TenantID).First();
                if (projectInfo != null)
                {
                    
                    _db.AsTenant().ChangeDatabase("zhengcaioa");
                    var sss = _db.Ado.GetDataTable("select [Id]     ,[start_time]     ,[sheng]      ,[city]      ,[area_id]      ,[cgfs]      ,[number]      ,[name] from Project where number=@number", new { number = projectInfo.ProjectCode });
                    if (sss != null && sss.Rows.Count > 0)
                    {
                        ret = new List<Document_OtherCompanyTenderInfo>();
                        foreach (DataRow row in sss.Rows)
                        {
                            var aaaaaaaa = _db.Ado.GetDataTable("select [youxiaoId]   ,[ProjectId]     ,[namesyouxiao]     ,[priceyouxiao]     ,[yx_zhiyistatus]     ,[yx_zhiyishijian]      ,[yx_zhiyichengli]    ,[yx_tousustatus]     ,[yx_tousushijian]      ,[yx_tousuchengli] from Projectyouxiao where ProjectId=@ProjectId", new { ProjectId = Convert.ToString(row["Id"]).Trim() });
                            if (aaaaaaaa != null && aaaaaaaa.Rows.Count > 0)
                            {
                                foreach (DataRow row0 in aaaaaaaa.Rows)
                                {
                                    Document_OtherCompanyTenderInfo document_OtherCompanyTenderInfo = new Document_OtherCompanyTenderInfo();
                                    document_OtherCompanyTenderInfo.ProjectId = ID;
                                    document_OtherCompanyTenderInfo.CompanyName = Convert.ToString(row0["namesyouxiao"]).Trim();
                                    if (row0["priceyouxiao"] != null && !string.IsNullOrEmpty(row0["priceyouxiao"].ToString()))
                                    {
                                        string price = row0["priceyouxiao"].ToString().Trim().Replace("元", "").Replace("万", "");
                                        decimal priceprice = 0;

                                        if (decimal.TryParse(price, out priceprice))
                                        {
                                            document_OtherCompanyTenderInfo.TenderPrice = priceprice;
                                        }
                                    }
                                  
                                        document_OtherCompanyTenderInfo.TenantID = TenantID;
                                    ret.Add(document_OtherCompanyTenderInfo);
                                }
                                break;
                            }
                        }
                    }
                }

            }
            return ret;
        }
        public Document_OtherCompanyTenderInfo GetOtherCompanyTenderInfo(int ID, string companyName)
@@ -1109,9 +1282,54 @@
        public List<Document_AptitudeInfo> GetAptitudeInfoByUnitId(int UnitId)
        { 

                var result = _db.Queryable<Document_AptitudeInfo>().Where( x=> x.UnitId == UnitId).ToList() ;//执行查询
                var result = _db.Queryable<Doc_Info>().Where( x=>x.is_del == false && x.org_id == UnitId).ToList() ;//执行查询

            return result;
            var ids = result.Select(x => x.id).ToArray();
            var file = _db.Queryable<File_Info>().Where(x => ids.Contains(x.doc_id)).ToList();//执行查询
            var document_AptitudeInfos = new List<Document_AptitudeInfo>();

            foreach (var doc_Info  in result)
            {
                var document_AptitudeInfo = new Document_AptitudeInfo();
                var filesss = file.Where(x => x.doc_id == doc_Info.id).ToList();

                if(filesss!=null && filesss.Count > 0)
                {
                    document_AptitudeInfo.FilePath = "";
                    document_AptitudeInfo.FileName = "";
                    document_AptitudeInfo.FileSize =  0;
                    for (int i=0;i< filesss.Count; i++)
                    {
                        document_AptitudeInfo.FilePath += filesss[i].filepath;
                        document_AptitudeInfo.FileName += filesss[i].filenewname;
                        document_AptitudeInfo.FileSize += filesss[i].filesize; ;
                        if (i!= filesss.Count - 1)
                        {
                            document_AptitudeInfo.FilePath += ";";
                            document_AptitudeInfo.FileName += ";";
                        }
                    }
                }

                document_AptitudeInfo.AptitudeId = doc_Info.id;
                document_AptitudeInfo.AptitudeName = doc_Info.doc_name;
                document_AptitudeInfo.AptitudeType = doc_Info.classification_id;
                document_AptitudeInfo.IsUsed = doc_Info.status;
               
                
                document_AptitudeInfo.FileVersionNo = "";
                document_AptitudeInfo.SendTime = doc_Info.add_time.ToShortDateString();
                document_AptitudeInfo.UnitId = doc_Info.org_id.HasValue ? doc_Info.org_id.Value : 0; ;
                document_AptitudeInfo.LastUpdateTime = doc_Info.add_time;
                document_AptitudeInfo.LastUpdateName = "";
                document_AptitudeInfo.AdviseFlag = 1;
                document_AptitudeInfo.UserId = doc_Info.tenant_code;

                document_AptitudeInfos.Add(document_AptitudeInfo);
            }


            return document_AptitudeInfos;
        }


@@ -1231,5 +1449,665 @@

            return true;
        }


        public Document_DelegatePersonInfo GetDelegatePersonInfo(int ID)
        {
            var ret = _db.Queryable<Document_DelegatePersonInfo>().Where(x => x.DelegateId == ID).First();
            return ret;
        }

        public bool SaveDocumentProjectOppugnInfo(Document_ProjectOppugnInfo dp)
        {
            if (dp.ID > 0)
            {
                _db.Updateable<Document_ProjectOppugnInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_ProjectOppugnInfo>(dp).ExecuteCommand();
            }

            return true;
        }

        public List<Document_DelegatePersonInfo> GetAllDelegatePerson()
        {
            var a = GetJwtInfo();

            var result = _db.Queryable<Document_DelegatePersonInfo>().Where(x => x.IsUse == 1 && x.TenantID == a.TEID ).ToList();//执行查询
            return result;

        }

        public bool SaveDocumentProjectComplainInfo(Document_ProjectComplainInfo dp)
        {
            if (dp.ID > 0)
            {
                _db.Updateable<Document_ProjectComplainInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_ProjectComplainInfo>(dp).ExecuteCommand();
            }

            return true;
        }

        public bool SaveDocumentProjectReviewInfo(Document_ProjectReviewInfo dp)
        {
            if (dp.ID > 0)
            {
                _db.Updateable<Document_ProjectReviewInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_ProjectReviewInfo>(dp).ExecuteCommand();
            }

            return true;
        }

        public string GetPreUnit(string childName)
        {

            string preUnit = "";
            Sys_CitySite preModel = null;
            var m_Sys_CitySite = _db.Queryable<Sys_CitySite>().Where(x => x.Name == childName).First();//执行查询
            if (m_Sys_CitySite != null)
            {
                if (m_Sys_CitySite.CityLevel == 3)
                {
                    preModel = _db.Queryable<Sys_CitySite>().Where(x=>x.Keyid == m_Sys_CitySite.CityId).First();
                }
                else if (m_Sys_CitySite.CityLevel == 2)
                {
                    preModel = _db.Queryable<Sys_CitySite>().Where(x => x.Keyid == m_Sys_CitySite.ProvinceId).First();
                }
                else
                {
                    preModel = m_Sys_CitySite;
                }
            }
            if (preModel != null)
            {
                preUnit = preModel.Name;
            }

            return preUnit;
        }


        public bool SaveDocumentProjectLitigationInfo(Document_ProjectLitigationInfo dp)
        {
            if (dp.ID > 0)
            {
                _db.Updateable<Document_ProjectLitigationInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_ProjectLitigationInfo>(dp).ExecuteCommand();
            }

            return true;
        }


        public bool SaveDocumentAdviseInfo(Document_AdviseInfo dp)
        {
            {
                if (dp.Id > 0)
                {
                    _db.Updateable<Document_AdviseInfo>(dp).ExecuteCommand();
                }
                else
                {
                    _db.Insertable<Document_AdviseInfo>(dp).ExecuteCommand();
                }

                return true;
            }
        }

        public Document_DocumentTempletInfo GetTempletModel(int templetId)
        {
            var ret = _db.Queryable<Document_DocumentTempletInfo>().Where(x => x.TempletId == templetId).First();
            return ret;
        }

        public List<Document_DocumentTempletInfo> GetDocumentTempletList()
        {
            var result = _db.Queryable<Document_DocumentTempletInfo>().Where(x => x.IsUsed == 1).ToList();//执行查询
            return result;
        }




        public PageResult<Document_ZhaobiaoFile> postDocumentZhaobiaoFileList(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_ZhaobiaoFile> result = new PageResult<Document_ZhaobiaoFile>();



            result.Items = _db.Queryable<Document_ZhaobiaoFile>()
                .Where(a => a.UnitId == page.UnitId && a.ProjectId == page.ProjectId)
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.FileName), a=>a.FileName.Contains(page.FileName))

             .Select(a => new Document_ZhaobiaoFile
             {
                 Id = a.Id,
                 FileName = a.FileName,
                 FilePath = a.FilePath,
                 FileVersionNo = a.FileVersionNo,
                 FileSize = a.FileSize,
                 UnitId = a.UnitId,
                 LastUpdateTime = a.LastUpdateTime,
                 LastUpdateName = a.LastUpdateName,
                 AdviseFlag = a.AdviseFlag,
                 UserId = a.UserId,

             }
              )
             .OrderByDescending(a => a.LastUpdateTime).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 Document_ZhaobiaoFile GetDocumentZhaobiaoFileInfo(int ID)
        {
            var result = _db.Queryable<Document_ZhaobiaoFile>().Where(x => x.Id == ID).First();//执行查询
            return result;
        }


        public bool GetDeleteDocumentZhaobiaoFile(int ID)
        {
            _db.Deleteable<Document_ZhaobiaoFile>().Where(x => x.Id == ID).ExecuteCommand();

            return true;
        }

        public bool SaveDocumentZhaobiaoFileInfo(Document_ZhaobiaoFile dp)
        {
            if (dp.Id > 0)
            {
                _db.Updateable<Document_ZhaobiaoFile>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_ZhaobiaoFile>(dp).ExecuteCommand();
            }

            return true;
        }



        public PageResult<DocumentTBXYFileDTO> postDocumentTBXYFileList(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<DocumentTBXYFileDTO> result = new PageResult<DocumentTBXYFileDTO>();



            result.Items = _db.Queryable<Document_TBXYFile>()
                .Where(a => a.UnitId == page.UnitId && a.ProjectId == page.ProjectId)
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.FileName), a => a.FileName.Contains(page.FileName))
                .WhereIF(page.Classification>0, a => a.Classification == page.Classification)
                   .WhereIF(!string.IsNullOrEmpty(page.FilePath), a => ( a.FilePath !=null && a.FilePath != ""))

             .Select(a => new DocumentTBXYFileDTO
             {
                 Id = a.Id,
                 FileName = a.FileName,
                 FilePath = a.FilePath,
                 FileVersionNo = a.FileVersionNo,
                 FileSize = a.FileSize,
                 UnitId = a.UnitId,
                 LastUpdateTime = a.LastUpdateTime,
                 LastUpdateName = a.LastUpdateName,
                 AdviseFlag = a.AdviseFlag,
                 UserId = a.UserId,
                 Sort = a.Sort,
                 Classification = a.Classification,
             }
              )
             .OrderBy(a => a.Sort).ToPageList(page.PageIndex, page.PageSize, ref total);


            if(result.Items !=null&& result.Items.Count > 0)
            {
                var doc_Classifications = _db.Queryable<Doc_Classification>().Where(x => x.parent_code == "003").ToList();//执行查询
                foreach (var item in result.Items)
                {
                    var doc_Classification = doc_Classifications.Where(x => x.id == item.Classification).FirstOrDefault();
                    if (doc_Classification != null)
                    {
                        item.ClassificationName = doc_Classification.doc_classification;
                    }
                }
            }

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



            return result;
        }


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


        public bool GetDeleteDocumentTBXYFile(int ID)
        {

            _db.Deleteable<Document_TBXYFile>().Where(x => x.Id == ID).ExecuteCommand();

            return true;
        }

        public bool SaveDocumentTBXYFileInfo(Document_TBXYFile dp)
        {



            var result = _db.Queryable<Document_ProjectDocumentInfo>().Where(x => x.ProjectId == dp.ProjectId && x.UnitId == dp.UnitId).First();//执行查询
            if (result != null)
            {
                result.LastUpdateTime = dp.LastUpdateTime;
                _db.Updateable<Document_ProjectDocumentInfo>(result).ExecuteCommand();
            }
            if (dp.Id > 0)
            {
                _db.Updateable<Document_TBXYFile>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_TBXYFile>(dp).ExecuteCommand();
            }

            return true;
        }


        public List<Document_TBXYFile> GetDocumentTBXYFileList(int projectId, int unitId)
        {
            var ret = _db.Queryable<Document_TBXYFile>()
                .Where(x => x.ProjectId == projectId && x.UnitId == unitId)
                .Select(a => new Document_TBXYFile
            {
                Id = a.Id,
                FileName = a.FileName,
                FilePath = a.FilePath,
                FileVersionNo = a.FileVersionNo,
                FileSize = a.FileSize,
                UnitId = a.UnitId,
                LastUpdateTime = a.LastUpdateTime,
                LastUpdateName = a.LastUpdateName,
                AdviseFlag = a.AdviseFlag,
                UserId = a.UserId,
                Sort = a.Sort,
                    SaveFlag = a.SaveFlag,
                    Classification  = a.Classification,
                }).OrderBy(a => a.Sort).ToList();
            return ret;
        }

        public Document_TBXYFile GetDocumentTBXYFileByFileName(int projectId, int unitId, string FileName)
        {
            var ret = _db.Queryable<Document_TBXYFile>().Where(x => x.ProjectId == projectId && x.UnitId == unitId && x.FileName == FileName ).First();
            return ret;
        }


        public int SaveDocInfo(Doc_Info dp)
        {
            if (dp.id > 0)
            {
                _db.Updateable<Doc_Info>(dp).ExecuteCommand();
            }
            else
            {
                dp.id = _db.Insertable<Doc_Info>(dp).ExecuteReturnIdentity();
            }

            return dp.id;
        }

        public bool SaveFileInfo(File_Info dp)
        {
            if (dp.id > 0)
            {
                _db.Updateable<File_Info>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<File_Info>(dp).ExecuteCommand();
            }

            return true;
        }


        public List<Doc_Classification> GetDocClassificationList()
        {
            var ret = _db.Queryable<Doc_Classification>().Where(x => x.parent_code =="003"  && x.is_system == true).ToList();
            return ret;
        }

        public bool SaveDocumentTBXYFileInfoNotRep(Document_TBXYFile dp)
        {

            if (dp.Id > 0)
            {
                _db.Updateable<Document_TBXYFile>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_TBXYFile>(dp).ExecuteCommand();
            }

            return true;
        }







        public PageResult<DocClassificationDTO> postDocClassificationList(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<DocClassificationDTO> result = new PageResult<DocClassificationDTO>();



            result.Items = _db.Queryable<Doc_Classification, Doc_ClassDel>((a, b) =>
              new JoinQueryInfos
              (
             JoinType.Left, a.id == b.doc_classification_id && b.tenant_code == page.TenantID
                  ))
                .Where((a, b) => ( a.tenant_code == page.TenantID || a.is_system == true) )
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.FileName), (a, b) => a.doc_classification.Contains(page.FileName))
               .WhereIF(!string.IsNullOrEmpty(page.parentcode), (a, b) => a.parent_code == page.parentcode )
                  .WhereIF(page.Status.HasValue, (a, b) => (a.is_system == false && a.status == page.Status.Value ) || (page.Status.Value == 1 && a.is_system == true && b.tenant_code == null ) || (page.Status.Value == 0 && a.is_system == true && b.tenant_code != null))

             .Select((a, b) => new DocClassificationDTO
             {
                 id = a.id,
                 doc_classification_code = a.doc_classification_code,
                 doc_classification = a.doc_classification,
                 parent_code = a.parent_code,
                 is_system = a.is_system,
                 sort_id = a.sort_id,
                 tenant_code = a.tenant_code,
                 add_time = a.add_time,
                 status = a.status,
                 
             }
              )
             .OrderBy(a => a.sort_id).ToPageList(page.PageIndex, page.PageSize, ref total);


            if (result.Items != null && result.Items.Count > 0)
            {
                
                foreach (var item in result.Items)
                {
                    if (item.is_system)
                    {
                        var doc_ClassDel = _db.Queryable<Doc_ClassDel>().Where(x => x.doc_classification_id == item.id && x.tenant_code == page.TenantID ).First();//执行查询

                        if (doc_ClassDel != null)
                        {
                            item.status = 0;
                            item.statusName = "停用";
                        }
                        else
                        {
                            item.statusName = "启用";
                        }
                    }
                    else
                    {
                        if(item.status == 1)
                        {
                            item.statusName = "启用";
                        }
                        else
                        {
                            item.statusName = "停用";
                        }
                       
                    }
                   
                }
            }

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



            return result;
        }


        public Doc_Classification GetDocClassificationInfo(int ID)
        {
            var aaa = GetJwtInfo();
            var result = _db.Queryable<Doc_Classification>().Where(x => x.id == ID).First();//执行查询
            if (result!=null && result.is_system)
            {
                var doc_ClassDel = _db.Queryable<Doc_ClassDel>().Where(x => x.doc_classification_id == result.id && x.tenant_code == aaa.TEID).First();//执行查询

                if (doc_ClassDel != null)
                {
                    result.status = 0;
                }
                else
                {
                    result.status = 1;
                }
            }


            return result;
        }


        public bool GetDeleteDocClassDel(int ID , int tenantId)
        {

            _db.Deleteable<Doc_ClassDel>().Where(x => x.doc_classification_id == ID &&  x.tenant_code == tenantId ).ExecuteCommand();

            return true;
        }


        public bool GetDeleteDocClassification(int ID )
        {
            var result = _db.Queryable<Doc_Classification>().Where(x => x.id == ID).First();//执行查询
            if (result != null)
            {
                _db.Deleteable<Doc_Classification>().Where(x => x.parent_code == result.doc_classification_code).ExecuteCommand();
            }

            _db.Deleteable<Doc_Classification>().Where(x => x.id == ID ).ExecuteCommand();

            return true;
        }

        public bool SaveDocClassificationInfo(Doc_Classification dp)
        {



          
           
            if (dp.id > 0)
            {
                _db.Updateable<Doc_Classification>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Doc_Classification>(dp).ExecuteCommand();
            }

            return true;
        }

        public bool SaveDocClassDelInfo(Doc_ClassDel dp)
        {

            if (dp.id > 0)
            {
                _db.Updateable<Doc_ClassDel>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Doc_ClassDel>(dp).ExecuteCommand();
            }
            return true;
        }


        public List<Doc_Classification> GetDocClassificationList(int tenantId)
        {
            var ret = _db.Queryable<Doc_Classification>()
                .Where(x => ((x.tenant_code == tenantId && x.status == 1) || x.is_system == true) && x.parent_code == "00" )
                //.Select(a => new Document_TBXYFile
                //{
                //    Id = a.Id,
                //    FileName = a.FileName,
                //    FilePath = a.FilePath,
                //    FileVersionNo = a.FileVersionNo,
                //    FileSize = a.FileSize,
                //    UnitId = a.UnitId,
                //    LastUpdateTime = a.LastUpdateTime,
                //    LastUpdateName = a.LastUpdateName,
                //    AdviseFlag = a.AdviseFlag,
                //    UserId = a.UserId,
                //    Sort = a.Sort,
                //    SaveFlag = a.SaveFlag,
                //    Classification = a.Classification,
                //})
                .OrderBy(a => a.sort_id).ToList();


            if (ret != null && ret.Count > 0)
            {

                foreach (var item in ret)
                {
                    if (item.is_system)
                    {
                        var doc_ClassDel = _db.Queryable<Doc_ClassDel>().Where(x => x.doc_classification_id == item.id && x.tenant_code == tenantId).First();//执行查询

                        if (doc_ClassDel != null)
                        {
                            item.status = 0;
                           
                        }
                        
                    }
                  
                }
            }

            ret = ret.Where(x => x.status == 1).ToList();

            return ret;
        }

        public Doc_Classification GetDocClassificationByFileName(int tenantId , string FileName, string parent_code)
        {
            var ret = _db.Queryable<Doc_Classification>().Where(x => ( x.tenant_code == tenantId || x.is_system == true  ) && x.doc_classification == FileName && x.parent_code ==  parent_code).First();
            return ret;
        }


        public Doc_Classification GetDocClassificationcode(int tenantId,string parent_code)
        {
            var ret = _db.Queryable<Doc_Classification>().Where(x => (x.tenant_code == tenantId || x.is_system == true)  && x.parent_code == parent_code).OrderByDescending(x=>x.doc_classification_code).First();
            string doc_classification_code = (int.Parse(ret.doc_classification_code) + 1).ToString().PadLeft(3, '0');
            Doc_Classification doc_Classification = new Doc_Classification();
            doc_Classification.doc_classification_code = doc_classification_code;
            return doc_Classification;
        }

        public Doc_Classification GetDocClassificationInfoMaxSortId(int tenantId ,string docclassificationcode)
        {
            var ret = _db.Queryable<Doc_Classification>()
                .Where(x => (x.tenant_code == tenantId || x.is_system == true))
                .WhereIF(!string.IsNullOrEmpty(docclassificationcode), x => x.parent_code == docclassificationcode)
                .Where(x => x.sort_id <= 99999)
                .Max(x => x.sort_id);
               
            Doc_Classification doc_Classification = new Doc_Classification();
            doc_Classification.sort_id = ret;
            return doc_Classification;
        }

        public Doc_Classification GetDocumentInfoMaxSortId(int unitId, string doccode)
        {
            var ret = _db.Queryable<Doc_Info>()
                .Where(x => x.org_id == unitId )
                .WhereIF(!string.IsNullOrEmpty(doccode), x => x.doc_code == doccode)
                .Max(x => x.sort);

            Doc_Classification doc_Classification = new Doc_Classification();
            doc_Classification.sort_id = ret??0;
            return doc_Classification;
        }

        public Doc_Classification GetAchievementInfoMaxSortId(int unitId)
        {
            var ret = _db.Queryable<Doc_Achievement>()
              .Where(x => x.tenant_code == unitId)
            //.WhereIF(!string.IsNullOrEmpty(doccode), x => x.doc_code == doccode)
            .Max(x => x.sort);

            Doc_Classification doc_Classification = new Doc_Classification();
            doc_Classification.sort_id = ret ?? 0;
            return doc_Classification;
        }
    }
}