提交

username@email.com

2024-12-26 90858c80d9921b555119f41060c1f883f6e6ffc5

 DocumentServiceAPI.Application/ProjectInfo/Services/ProjectInfoService.cs

@@ -1,5 +1,6 @@
using AngleSharp.Dom;
using AngleSharp.Html.Parser;
using DocumentServiceAPI.Application.DocManage.Dtos;
using DocumentServiceAPI.Application.ProjectInfo.Services.Interfaces;
using DocumentServiceAPI.Application.ProjectInfo.ViewMode;
using DocumentServiceAPI.Application.Repository;
@@ -24,8 +25,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;
@@ -115,7 +118,7 @@
            document_ProjectInfo.ProjectUrl = dp.ProjectUrl;
            var parser = new HtmlParser();
            var list11 = new List<AngleSharp.Dom.IElement>();
            if (url.StartsWith("http://www.ccgp.gov.cn"))
            if (url.StartsWith("http://www.ccgp.gov.cn")|| url.StartsWith("https://www.ccgp.gov.cn"))
            {
                using (HttpClient client = new HttpClient())
                {
@@ -141,29 +144,49 @@
                        }
                    }
                    document_ProjectInfo.PurchaseMethod = 0;
                    if (document_ProjectInfo.ProjectName.IndexOf("公开招标")>=0)
                    if (document_ProjectInfo.ProjectName.IndexOf("公开招标") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 3;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("公开招标", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("竞争性谈判") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 4;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性谈判", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("单一来源") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 5;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("单一来源", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("询价") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 6;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("询价", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("邀请") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 31;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("邀请招标", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("竞争性磋商") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 37;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性磋商", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("框架协议") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 38;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("框架协议", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("比选") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 39;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("比选", "").Replace("公告", "");
                    }


                    


                    var vF_detail_content = document.All.Where(m => m.ClassName == "vF_detail_content").FirstOrDefault();
                    var td = vF_detail_content.QuerySelectorAll("p");
@@ -335,9 +358,35 @@
                    if (DateTime.TryParse(TenderTimes, out b))
                    {
                        document_ProjectInfo.TenderTime = b;
                        document_ProjectInfo.SignupStartTime = b;
                        document_ProjectInfo.SignupEndTime = b;
                      
                    }


                    var jiezhishijian = document.All.Where(m => m.HasAttribute("id") &&
                                      m.GetAttribute("id").StartsWith("_notice_content_noticePurchaseTime-noticePurchaseTime")).FirstOrDefault();

                    var jiezhishijians = jiezhishijian.QuerySelectorAll("span");
                    if (jiezhishijians != null && jiezhishijians.Length > 0)
                    {
                        //for (int i = 0; i < jiezhishijians.Length; i++)
                        //{
                        //    if (jiezhishijians[i].TextContent.IndexOf("年") >= 0 && jiezhishijians[i].TextContent.IndexOf("、") < 0)
                        //    {

                        //    }
                        //}
                        if (DateTime.TryParse(jiezhishijians[0].TextContent.Trim(), out b))
                        {
                            document_ProjectInfo.SignupStartTime = b;
                            
                        }

                        if (DateTime.TryParse(jiezhishijians[1].TextContent.Trim(), out b))
                        {
                            document_ProjectInfo.SignupEndTime = b;
                        }
                    }
                       



@@ -345,25 +394,43 @@
                    if (document_ProjectInfo.ProjectName.IndexOf("公开招标") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 3;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("公开招标", "").Replace("公告","");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("竞争性谈判") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 4;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性谈判", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("单一来源") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 5;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("单一来源", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("询价") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 6;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("询价", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("邀请") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 31;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("邀请招标", "").Replace("公告", "");
                    }


                    else if (document_ProjectInfo.ProjectName.IndexOf("竞争性磋商") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 37;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性磋商", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("框架协议") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 38;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("框架协议", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("比选") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 39;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("比选", "").Replace("公告", "");
                    }


                    var vF_detail_content = document.All.Where(m => m.LocalName == "div" &&
@@ -386,9 +453,77 @@


                            }
        

                            if (td[i].TextContent.IndexOf("项目名称：") >= 0 && td[i].TextContent.IndexOf("、") < 0)
                            {
                                if (string.IsNullOrEmpty(document_ProjectInfo.ProjectName))
                                {
                                    document_ProjectInfo.ProjectName = td[i].TextContent.Replace("项目名称：", "").Replace("1．", "").Replace("/", "").Trim();
                                }



                            }

                            if (td[i].TextContent.IndexOf("采购方式：") >= 0 && td[i].TextContent.IndexOf("、") < 0)
                            {
                                if (td[i].TextContent.IndexOf("公开招标") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 3;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("公开招标", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("竞争性谈判") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 4;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性谈判", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("单一来源") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 5;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("单一来源", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("询价") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 6;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("询价", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("邀请") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 31;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("邀请招标", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("竞争性磋商") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 37;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性磋商", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("框架协议") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 38;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("框架协议", "").Replace("公告", "");
                                }
                                else if (td[i].TextContent.IndexOf("比选") >= 0)
                                {
                                    document_ProjectInfo.PurchaseMethod = 39;
                                    document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("比选", "").Replace("公告", "");
                                }



                            }

                        }
                    }

                    var txtAgencyManager = document.All.Where(m => m.LocalName == "span" &&
                                     m.HasAttribute("id") &&
                                     m.GetAttribute("id").StartsWith("_notice_content_projectContact-managerName")).FirstOrDefault();
                    if (txtAgencyManager != null)
                    {
                        document_ProjectInfo.AgencyManager = txtAgencyManager.TextContent;
                    }
                     

                    var lianxiren = document.All.Where(m => m.LocalName == "div" && m.ClassName == "innercontent").ToList();
                    foreach (var element  in lianxiren)
                    {
@@ -473,22 +608,42 @@
                    if (document_ProjectInfo.ProjectName.IndexOf("公开招标") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 3;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("公开招标", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("竞争性谈判") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 4;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性谈判", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("单一来源") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 5;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("单一来源", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("询价") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 6;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("询价", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("邀请") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 31;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("邀请招标", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("竞争性磋商") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 37;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("竞争性磋商", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("框架协议") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 38;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("框架协议", "").Replace("公告", "");
                    }
                    else if (document_ProjectInfo.ProjectName.IndexOf("比选") >= 0)
                    {
                        document_ProjectInfo.PurchaseMethod = 39;
                        document_ProjectInfo.ProjectName = document_ProjectInfo.ProjectName.Replace("比选", "").Replace("公告", "");
                    }


@@ -613,8 +768,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 +819,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 +846,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 +876,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 +905,7 @@
                        documentProjectInfoDTO.xmqy = documentProjectInfoDTO.City+ documentProjectInfoDTO.County;
                    }

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

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

                    if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathzy))
@@ -870,7 +1030,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 +1128,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 +1274,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 +1435,220 @@
        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 && x.zige_code > 0).OrderBy(x=>x.doc_code).OrderBy(x=>x.sort).ToList() ;//执行查询

            return result;
            var ids = result.Select(x => x.id).ToArray();
            var file = _db.Queryable<File_Info>().Where(x => ids.Contains(x.doc_id) && x.status ==1 ).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).OrderBy(x => x.sort).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 = doc_Info.zige_code; ;
                document_AptitudeInfo.UserId = doc_Info.tenant_code;

                document_AptitudeInfos.Add(document_AptitudeInfo);
            }

            //var resultAchievement = _db.Queryable<Doc_Achievement>().Where(x => x.status == 1 && x.tenant_code == UnitId).OrderBy(x=>x.sort).ToList();//执行查询


            //foreach (var achievement in resultAchievement)
            //{
            //    var document_AptitudeInfo = new Document_AptitudeInfo();
            //    document_AptitudeInfo.FilePath = "";
            //    document_AptitudeInfo.FileName = "";
            //    document_AptitudeInfo.FileSize = 0;
            //    if (!string.IsNullOrEmpty(achievement.zbtzs_url))
            //    {
            //        document_AptitudeInfo.FilePath += achievement.zbtzs_url;
            //        document_AptitudeInfo.FileName += "中标通知书";
            //        document_AptitudeInfo.FileSize += 0 ;
            //        document_AptitudeInfo.FilePath += ";";
            //        document_AptitudeInfo.FileName += ";";
            //    }
            //    if (!string.IsNullOrEmpty(achievement.ht_url))
            //    {
            //        document_AptitudeInfo.FilePath += achievement.ht_url;
            //        document_AptitudeInfo.FileName += "合同";
            //        document_AptitudeInfo.FileSize += 0;
            //        document_AptitudeInfo.FilePath += ";";
            //        document_AptitudeInfo.FileName += ";";
            //    }
            //    if (!string.IsNullOrEmpty(achievement.ysbg_url))
            //    {
            //        document_AptitudeInfo.FilePath += achievement.ysbg_url;
            //        document_AptitudeInfo.FileName += "验收报告";
            //        document_AptitudeInfo.FileSize += 0;
            //        document_AptitudeInfo.FilePath += ";";
            //        document_AptitudeInfo.FileName += ";";
            //    }
            //    if (!string.IsNullOrEmpty(achievement.fkpz_url))
            //    {
            //        document_AptitudeInfo.FilePath += achievement.fkpz_url;
            //        document_AptitudeInfo.FileName += "付款凭证";
            //        document_AptitudeInfo.FileSize += 0;
            //        document_AptitudeInfo.FilePath += ";";
            //        document_AptitudeInfo.FileName += ";";
            //    }
            //    if (!string.IsNullOrEmpty(achievement.yhpj_url))
            //    {
            //        document_AptitudeInfo.FilePath += achievement.yhpj_url;
            //        document_AptitudeInfo.FileName += "用户评价";
            //        document_AptitudeInfo.FileSize += 0;
            //        document_AptitudeInfo.FilePath += ";";
            //        document_AptitudeInfo.FileName += ";";
            //    }
            //    if (!string.IsNullOrEmpty(achievement.hjzs_url))
            //    {
            //        document_AptitudeInfo.FilePath += achievement.hjzs_url;
            //        document_AptitudeInfo.FileName += "获奖证书";
            //        document_AptitudeInfo.FileSize += 0;
            //        document_AptitudeInfo.FilePath += ";";
            //        document_AptitudeInfo.FileName += ";";
            //    }

            //    if (document_AptitudeInfo.FilePath.EndsWith(";"))
            //    {
            //        document_AptitudeInfo.FilePath = document_AptitudeInfo.FilePath.Substring(0, document_AptitudeInfo.FilePath.Length - 1);
            //    }

            //    if (document_AptitudeInfo.FileName.EndsWith(";"))
            //    {
            //        document_AptitudeInfo.FileName = document_AptitudeInfo.FileName.Substring(0, document_AptitudeInfo.FileName.Length - 1);
            //    }


            //    document_AptitudeInfo.AptitudeId = achievement.id;
            //    document_AptitudeInfo.AptitudeName = achievement.achievement_name;
            //    document_AptitudeInfo.AptitudeType = achievement.classification_id;
            //    document_AptitudeInfo.IsUsed = achievement.status;


            //    document_AptitudeInfo.FileVersionNo = "";
            //    document_AptitudeInfo.SendTime = achievement.add_time.ToShortDateString();
            //    document_AptitudeInfo.UnitId = achievement.tenant_code ;
            //    document_AptitudeInfo.LastUpdateTime = achievement.add_time;
            //    document_AptitudeInfo.LastUpdateName = "";
            //    document_AptitudeInfo.AdviseFlag = 1;
            //    document_AptitudeInfo.UserId = achievement.tenant_code;

            //    document_AptitudeInfos.Add(document_AptitudeInfo);
            //}


            var resultShebeinengli = _db.Queryable<Doc_Shebeinengli>().Where(x => x.status == 1 && x.tenant_code == UnitId && (x.sbzp_zige > 0 || x.gmht_zige > 0 || x.fp_zige > 0 || x.fkpz_zige > 0 || x.csmp_zige > 0)).OrderBy(x => x.sort).ToList();//执行查询


            foreach (var achievement in resultShebeinengli)
            {
                var document_AptitudeInfo = new Document_AptitudeInfo();
                document_AptitudeInfo.FilePath = "";
                document_AptitudeInfo.FileName = "";
                document_AptitudeInfo.FileSize = 0;
                if (!string.IsNullOrEmpty(achievement.sbzp_url) && achievement.sbzp_zige > 0)
                {
                    document_AptitudeInfo.FilePath += achievement.sbzp_url;
                    document_AptitudeInfo.FileName += "设备照片";
                    document_AptitudeInfo.FileSize += 0;
                    document_AptitudeInfo.FilePath += ";";
                    document_AptitudeInfo.FileName += ";";
                }
                if (!string.IsNullOrEmpty(achievement.gmht_url) && achievement.gmht_zige > 0)
                {
                    document_AptitudeInfo.FilePath += achievement.gmht_url;
                    document_AptitudeInfo.FileName += "购买合同";
                    document_AptitudeInfo.FileSize += 0;
                    document_AptitudeInfo.FilePath += ";";
                    document_AptitudeInfo.FileName += ";";
                }
                if (!string.IsNullOrEmpty(achievement.fp_url) && achievement.fp_zige > 0)
                {
                    document_AptitudeInfo.FilePath += achievement.fp_url;
                    document_AptitudeInfo.FileName += "发票";
                    document_AptitudeInfo.FileSize += 0;
                    document_AptitudeInfo.FilePath += ";";
                    document_AptitudeInfo.FileName += ";";
                }
                if (!string.IsNullOrEmpty(achievement.fkpz_url) && achievement.fkpz_zige > 0)
                {
                    document_AptitudeInfo.FilePath += achievement.fkpz_url;
                    document_AptitudeInfo.FileName += "付款凭证";
                    document_AptitudeInfo.FileSize += 0;
                    document_AptitudeInfo.FilePath += ";";
                    document_AptitudeInfo.FileName += ";";
                }
                if (!string.IsNullOrEmpty(achievement.csmp_url) && achievement.csmp_zige > 0)
                {
                    document_AptitudeInfo.FilePath += achievement.csmp_url;
                    document_AptitudeInfo.FileName += "参数（铭牌）";
                    document_AptitudeInfo.FileSize += 0;
                    document_AptitudeInfo.FilePath += ";";
                    document_AptitudeInfo.FileName += ";";
                }
                

                if (document_AptitudeInfo.FilePath.EndsWith(";"))
                {
                    document_AptitudeInfo.FilePath = document_AptitudeInfo.FilePath.Substring(0, document_AptitudeInfo.FilePath.Length - 1);
                }

                if (document_AptitudeInfo.FileName.EndsWith(";"))
                {
                    document_AptitudeInfo.FileName = document_AptitudeInfo.FileName.Substring(0, document_AptitudeInfo.FileName.Length - 1);
                }


                document_AptitudeInfo.AptitudeId = achievement.id;
                document_AptitudeInfo.AptitudeName = achievement.shebeinengli_name;
                document_AptitudeInfo.AptitudeType = achievement.classification_id;
                document_AptitudeInfo.IsUsed = achievement.status;


                document_AptitudeInfo.FileVersionNo = "";
                document_AptitudeInfo.SendTime = achievement.add_time.ToShortDateString();
                document_AptitudeInfo.UnitId = achievement.tenant_code;
                document_AptitudeInfo.LastUpdateTime = achievement.add_time;
                document_AptitudeInfo.LastUpdateName = "";
                document_AptitudeInfo.AdviseFlag = achievement.zige_code;
                document_AptitudeInfo.UserId = achievement.tenant_code;

                document_AptitudeInfos.Add(document_AptitudeInfo);
            }


            return document_AptitudeInfos;
        }


@@ -1231,5 +1768,770 @@

            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 aaa = GetJwtInfo();
            var result = _db.Queryable<Document_DocumentTempletInfo>().Where(x => x.IsUsed == 1 && x.UnitId == aaa.UID).OrderByDescending(x=>x.LastUpdateTime).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 == "000").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 =="000"  && 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;
        }


        public Doc_Classification GetShebeinengliInfoMaxSortId(int unitId)
        {
            var ret = _db.Queryable<Doc_Shebeinengli>()
              .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;
        }


        public PageResult<Document_DocumentTempletInfoDTO> postDocumentTempletList(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_DocumentTempletInfoDTO> result = new PageResult<Document_DocumentTempletInfoDTO>();



            var document_DocumentTempletInfos = _db.Queryable<Document_DocumentTempletInfo> ()
             .Where(x=>x.UnitId == aaa.UID)
             //文件名称
             .WhereIF(!string.IsNullOrEmpty(page.templetName), a => a.TempletName.Contains(page.templetName))
               .WhereIF(page.purchaseMethod !=0, a => a.PurchaseMethod == page.purchaseMethod)
                  .WhereIF(page.IsUsed>0, a => (page.IsUsed == 1 &&  a.IsUsed == 1  ) || (page.IsUsed != 1 && a.IsUsed == 2))

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


            result.Items = _mapper.Map<List<Document_DocumentTempletInfoDTO>>(document_DocumentTempletInfos);

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

                foreach (var item in result.Items)
                {
                    if (item.IsUsed == 1)
                    {
                        
                        
                          
                            item.isUseName = "启用";

                        item.isUseOp = "停用";

                    }
                    else
                    { 
                            item.isUseName = "停用";
                        item.isUseOp = "启用";
                    }

                }
            }

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



            return result;
        }


        public bool GetDeleteDocumentTempletInfo(int ID)
        {
            _db.Deleteable<Document_DocumentTempletInfo>().Where(x => x.TempletId == ID ).ExecuteCommand();

            return true;
        }


        public bool SaveDocumentTempletInfo(Document_DocumentTempletInfo dp)
        {
            if (dp.TempletId > 0)
            {
                _db.Updateable<Document_DocumentTempletInfo>(dp).ExecuteCommand();
            }
            else
            {
                _db.Insertable<Document_DocumentTempletInfo>(dp).ExecuteCommand();
            }
            return true;
        }


        public Document_DocumentTempletInfo GetTempletModelByProjectId(int projiectid)
        {

            var aaa = GetJwtInfo();
            var ret = _db.Queryable<Document_DocumentTempletInfo>().Where(x => x.ProjectId == projiectid && x.UnitId == aaa.UID ).First();
            return ret;
        }
    }
}