提交

username@email.com

2023-02-24 e8fc5d92457143ea8744e8f8b2bed45a0a651f18

 zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs

@@ -1,4 +1,6 @@
using DTO;
using AutoMapper;
using CommonToolsCore;
using DTO;
using IServices;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
@@ -13,6 +15,7 @@
using System.Linq;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Transactions;
@@ -28,8 +31,8 @@
        private readonly ILiaotianService _liaotianService;
        private readonly IHttpClientFactory _clientFactory;
        private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService;


        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public TimerGetShopUsersService(ILogger<TimerGetShopUsersService> logger, IServiceScopeFactory factory)
        {
            _logger = logger;
@@ -37,8 +40,8 @@
            _liaotianService = factory.CreateScope().ServiceProvider.GetRequiredService<ILiaotianService>();
            _clientFactory = factory.CreateScope().ServiceProvider.GetRequiredService<IHttpClientFactory>();
            _cooperatecustomCustomerService = factory.CreateScope().ServiceProvider.GetRequiredService<ICooperatecustomCustomerService>();


            _context = factory.CreateScope().ServiceProvider.GetRequiredService<zhengcaioaContext>();
            _mapper = factory.CreateScope().ServiceProvider.GetRequiredService<IMapper>(); ;
        }

        protected override async Task ExecuteAsync(CancellationToken stoppingToken)
@@ -52,6 +55,11 @@
            {
                _logger.LogInformation("TimerGetShopUsersService 开始执行");
                _logger.LogInformation(datenow.ToString("yyyy-MM-dd HH:mm:ss"));
                if (DateTime.Now.Hour == 6)
                {
                    this.fasongxiaoxi();
                }

                //每个小时计算一次
                if (datenow.Hour == DateTime.Now.Hour)
                //if (true)
@@ -84,7 +92,2812 @@
        {
            base.Dispose();
        }
      

        //查询并且发送短信和app消息给客户
        public void fasongxiaoxi()
        {
            var startdate = DateTime.Now.AddMonths(-3);

            var projects   =_context.Projects.Where(x => x.RecStatus == "A" && x.StartTime >= startdate).ToList();
            var projiectid = new List<string>();
            foreach(var project in projects)
            {
                projiectid.Add(project.Id);
            }
            var projectzhongbiaos    = _context.Projectzhongbiaos.Where(x => projiectid.Contains(x.ProjectId)).ToList();

            var projectreasons = _context.Projectreasons.Where(x => projiectid.Contains(x.ProjectId)).ToList();

            var projectyouxiaos = _context.Projectyouxiaos.Where(x => projiectid.Contains(x.ProjectId)).ToList();

            //业务经理      400-028-8080
            var Ywjl = _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" && x.IsYwjl == "A").ToList();

            //是否发送了消息
            var projectfasongxiaoxis = _context.Projectfasongxiaoxis.Where(x => projiectid.Contains(x.ProjectId)).ToList();


            var intentionCustomers = _context.IntentionCustomers.Where(x => x.RecStatus == "A").ToList();

            var cooperatecustomCustomers = _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A").ToList();

            //StringBuilder number = new StringBuilder(); ;
            //if (result != null && result.Count > 0)
            //{
            //    for (int i = 0; i < result.Count; i++)
            //    {
            //        number.Append(result[i].Lianxidianhua);
            //        customename += result[i].Xingming + ",";
            //        if (i != result.Count - 1)
            //        {
            //            number.Append(",");
            //        }
            //    }
            //}
            //else
            //{
            //    resultEntity.Result = false;
            //    resultEntity.Message = "无联系人";
            //}
            //string sss = SMSHelper.PushWToUserMES(number.ToString(), neirong);
            //if (int.Parse(sss) <= 0)
            //{
            //    resultEntity.Result = false;
            //    resultEntity.Message = "短信发送失败";
            //    return new JsonResult(resultEntity);
            //}

            //_logger.LogInformation(curentuser.UserName + "发送短信给客户" + customename);

            #region 没有通过资格审查和符合审查：
            //政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，
            //杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：        。

            try
            {

                var fbprojects = projects.Where(x => x.Fblx != null).ToList();
                var fbprojiectid = new List<string>();
                foreach (var project in fbprojects)
                {
                    fbprojiectid.Add(project.Id);
                }
                var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();

                var fbprojectreasons = projectreasons.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();

                var fbprojectyouxiaos = projectyouxiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();


                var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();

                var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();


                foreach (var project1 in fbprojects)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "2";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "3";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }


                    var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                    if (projectfasongxiaoxiappDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "2";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "3";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }
                foreach (var project1 in fbprojectzhongbiaos)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "1";
                        projectfasongxiaoxiDTO.Khname = project1.Names;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;

                       var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "1";
                        projectfasongxiaoxiDTO.Khname = project1.Names;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }
                foreach (var project1 in fbprojectyouxiaos)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "4";
                        projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "4";
                        projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }
                foreach (var project1 in fbprojectreasons)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "5";
                        projectfasongxiaoxiDTO.Khname = project1.Reasonname;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "1";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "5";
                        projectfasongxiaoxiDTO.Khname = project1.Reasonname;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                //查询需要发送短信的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }

                //查询需要发送App消息的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }


                //推送App
                foreach (var ywjl in Ywjl)
                {

                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }

                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司的“标书预评审”服务\","
                            + "\"content\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：" + ywjl.Phone + " \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：" + ywjl.Phone + " \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
                    }




                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }
                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司的“标书预评审”服务\","
                            + "\"content\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：400-028-8080 \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：400-028-8080 \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation("无业务经理推送app给客户" + customename);
                    }



                }



                //发送短信
                foreach (var ywjl in Ywjl)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j*1000<= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if(countt> projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }

                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i+j-1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：" + ywjl.Phone);
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
                            }
                        }

                       



                    }

                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }
                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：400-028-8080");
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation("无客户经理发送短信给客户" + customename);
                            }
                        }


                           

                    }
                }


                

            }
            catch (Exception ex)
            {
                _logger.LogInformation(ex.ToString());
            }

            #endregion



            #region 第2名、第3名与第一名分差3分以内，推送给第2名和第3名：
            //APP
            //政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，
            //如果您在参加“    项目名称     ”投标前找政采咨询检查标书，至少提升评审得分5 - 8分，也许中标的就是贵公司。了解详情请咨询：      。
            //短信
            //政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，
            //至少为您提升评审得分5 - 8分，您最近未中的标都可以中！了解详情请咨询：  

            try
            {

                var fbprojects = projects.Where(x=>x.DrhxDefen !=null && x.DshxDefen !=null).ToList();
                var fbprojiectid = new List<string>();
                foreach (var project in fbprojects)
                {
                    fbprojiectid.Add(project.Id);
                }
                var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
 

                var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();

                var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();


                foreach (var project1 in fbprojects)
                {
                    if (project1.DrhxDefen.HasValue)
                    {
                        var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DrhxDefen <= 3).FirstOrDefault();
                        if (projectzhongbiaos1 != null)
                        {
                            var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                            if (projectfasongxiaoxiduanxinDrhx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "2";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                                projectfasongxiaoxiDTO.Gyszl = "2";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                            }

                            var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                            if (projectfasongxiaoxiappDrhx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "2";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                                projectfasongxiaoxiDTO.Gyszl = "2";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                            }

                        }
                    }




                    if (project1.DshxDefen.HasValue)
                    {
                        var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DshxDefen <= 3).FirstOrDefault();
                        if (projectzhongbiaos1 != null)
                        {
                            var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                            if (projectfasongxiaoxiduanxinDshx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "2";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                                projectfasongxiaoxiDTO.Gyszl = "3";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                            }




                            var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                            if (projectfasongxiaoxiappDshx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "2";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                                projectfasongxiaoxiDTO.Gyszl = "3";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = "A";
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                            }
                        }

                    }

                }

                //查询需要发送短信的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }

                //查询需要发送App消息的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }


                //推送App
                foreach (var ywjl in Ywjl)
                {

                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();


                    for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++)
                    {
                        string conment = "{"
                    + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
                    + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：" + ywjl.Phone + " \","
                      + "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\","
                        + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：" + ywjl.Phone + " \"},"
                            + "\"force_notification\": true"
                            + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();


                            if (isOK.IndexOf(projectfasongxiaoxisywjl[i].Tel) >= 0)
                            {
                                var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId;
                                projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing;
                                projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei;
                                projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl;
                                projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname;
                                projectfasongxiaoxi.RecStatus = "A";
                                projectfasongxiaoxi.Createtime = DateTime.Now;
                                _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                            }
                        }
                        _context.SaveChanges();
                        _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname);

                    }
                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();

                        for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++)
                        {
                            string conment = "{"
                        + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
                        + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：400-028-8080 \","
                          + "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\","
                            + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：400-028-8080 \"},"
                                + "\"force_notification\": true"
                                + "}";

                            string result2 = SMSHelper.PushApp(conment);
                            _logger.LogInformation("result2:" + result2);
                            JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                            if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                            {
                                var isOK = jobjectresult["isOK"].ToString();


                                if (isOK.IndexOf(projectfasongxiaoxisywjl[i].Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                            _logger.LogInformation(  "无业务经理推送app给客户" + projectfasongxiaoxisywjl[i].Khname);

                        }

                }



                //发送短信
                foreach (var ywjl in Ywjl)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }

                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少为您提升评审得分5-8分，您最近未中的标都可以中！了解详情请咨询：" + ywjl.Phone);
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
                            }
                        }





                    }

                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }
                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少为您提升评审得分5-8分，您最近未中的标都可以中！了解详情请咨询：400-028-8080");
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation("无客户经理发送短信给客户" + customename);
                            }
                        }




                    }
                }

            }
            catch (Exception ex)
            {
                _logger.LogInformation(ex.ToString());
            }

            #endregion


            #region  第2名与第一名分差5分以内，推送给第2名：
            //政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，
            //让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：   

            try
            {

                var fbprojects = projects.Where(x => x.DrhxDefen != null).ToList();
                var fbprojiectid = new List<string>();
                foreach (var project in fbprojects)
                {
                    fbprojiectid.Add(project.Id);
                }
                var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();


                var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();

                var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();


                foreach (var project1 in fbprojects)
                {
                    if (project1.DrhxDefen.HasValue)
                    {
                        var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DrhxDefen >3 && x.Defen - project1.DrhxDefen <= 5).FirstOrDefault();
                        if (projectzhongbiaos1 != null)
                        {
                            var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "3" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                            if (projectfasongxiaoxiduanxinDrhx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "3";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                                projectfasongxiaoxiDTO.Gyszl = "2";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                            }

                            var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "3" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                            if (projectfasongxiaoxiappDrhx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "3";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                                projectfasongxiaoxiDTO.Gyszl = "2";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                            }

                        }
                    }



 

                }

                //查询需要发送短信的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }

                //查询需要发送App消息的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }


                //推送App
                foreach (var ywjl in Ywjl)
                {

                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }

                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
                            + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：" + ywjl.Phone + " \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：" + ywjl.Phone + " \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
                    }


                 
                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }

                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
                            + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：400-028-8080 \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：400-028-8080 \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation( "无业务经理推送app给客户" + customename);
                    }

                }



                //发送短信
                foreach (var ywjl in Ywjl)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }

                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：" + ywjl.Phone);
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
                            }
                        }





                    }

                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }
                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：400-028-8080");
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation("无客户经理发送短信给客户" + customename);
                            }
                        }




                    }
                }

            }
            catch (Exception ex)
            {
                _logger.LogInformation(ex.ToString());
            }


            #endregion
            #region  第2名与第一名分差10分以内，推送给第2名：
            //政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，
            //让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：        。
            try
            {

                var fbprojects = projects.Where(x => x.DrhxDefen != null).ToList();
                var fbprojiectid = new List<string>();
                foreach (var project in fbprojects)
                {
                    fbprojiectid.Add(project.Id);
                }
                var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();


                var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();

                var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();


                foreach (var project1 in fbprojects)
                {
                    if (project1.DrhxDefen.HasValue)
                    {
                        var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DrhxDefen > 5 && x.Defen - project1.DrhxDefen <= 10).FirstOrDefault();
                        if (projectzhongbiaos1 != null)
                        {
                            var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "4" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                            if (projectfasongxiaoxiduanxinDrhx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "4";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                                projectfasongxiaoxiDTO.Gyszl = "2";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                            }

                            var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "4" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                            if (projectfasongxiaoxiappDrhx == null)
                            {
                                var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                                projectfasongxiaoxiDTO.ProjectId = project1.Id;
                                projectfasongxiaoxiDTO.ProjectmingxiId = null;
                                projectfasongxiaoxiDTO.Xiaoxileixing = "4";
                                projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                                projectfasongxiaoxiDTO.Gyszl = "2";
                                projectfasongxiaoxiDTO.Khname = project1.Drhx;
                                projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                                projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                                projectfasongxiaoxiDTO.Projectname = project1.Name;
                                projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                            }

                        }
                    }
                }

                //查询需要发送短信的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }

                //查询需要发送App消息的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }


                //推送App
                foreach (var ywjl in Ywjl)
                {

                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }

                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
                            + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：" + ywjl.Phone + " \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：" + ywjl.Phone + " \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
                    }



                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }

                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
                            + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：400-028-8080 \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：400-028-8080 \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation("无业务经理推送app给客户" + customename);
                    }

                }



                //发送短信
                foreach (var ywjl in Ywjl)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }

                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：" + ywjl.Phone);
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
                            }
                        }





                    }

                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }
                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：400-028-8080");
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation("无客户经理发送短信给客户" + customename);
                            }
                        }




                    }
                }

            }
            catch (Exception ex)
            {
                _logger.LogInformation(ex.ToString());
            }
            #endregion

            #region  质疑投诉未或支持：
            //政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，
            //花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：  

            try
            {

                var fbprojectsDehxZhiyichengli = projects.Where(x => x.DehxZhiyichengli == "D").ToList();
                var fbprojectsDehxTousuchengli = projects.Where(x => x.DehxTousuchengli == "D").ToList();

                var fbprojectsDshxZhiyichengli = projects.Where(x => x.DshxZhiyichengli == "D").ToList();
                var fbprojectsDshxTousuchengli = projects.Where(x => x.DshxTousuchengli == "D").ToList();

                var fbprojectzhongbiaosZbZhiyichengli = projectzhongbiaos.Where(x =>  x.ZbZhiyichengli == "D" ).ToList();
                var fbprojectzhongbiaosZbTousuchengli = projectzhongbiaos.Where(x => x.ZbTousuchengli == "D" ).ToList();

                var fbprojectreasonsWxZhiyichengli = projectreasons.Where(x => x.WxZhiyichengli == "D" ).ToList();
                var fbprojectreasonsWxTousuchengli = projectreasons.Where(x => x.WxTousuchengli == "D" ).ToList();

                var fbprojectyouxiaosYxZhiyichengli = projectyouxiaos.Where(x => x.YxZhiyichengli == "D" ).ToList();
                var fbprojectyouxiaosYxTousuchengli = projectyouxiaos.Where(x => x.YxTousuchengli == "D" ).ToList();

                var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();

                var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();


                foreach (var project1 in fbprojectsDehxZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "2";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }
                    var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                    if (projectfasongxiaoxiappDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "2";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }   
                }
                foreach (var project1 in fbprojectsDehxTousuchengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "2";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }
                    var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
                    if (projectfasongxiaoxiappDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "2";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                foreach (var project1 in fbprojectsDshxZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "3";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }


                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "3";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }
                foreach (var project1 in fbprojectsDshxZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "3";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }


                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.Id;
                        projectfasongxiaoxiDTO.ProjectmingxiId = null;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "3";
                        projectfasongxiaoxiDTO.Khname = project1.Drhx;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        projectfasongxiaoxiDTO.Projectname = project1.Name;
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                foreach (var project1 in fbprojectzhongbiaosZbZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "1";
                        projectfasongxiaoxiDTO.Khname = project1.Names;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;

                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }

                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "1";
                        projectfasongxiaoxiDTO.Khname = project1.Names;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                foreach (var project1 in fbprojectzhongbiaosZbZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "1";
                        projectfasongxiaoxiDTO.Khname = project1.Names;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;

                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }

                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "1";
                        projectfasongxiaoxiDTO.Khname = project1.Names;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }









                foreach (var project1 in fbprojectyouxiaosYxZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "4";
                        projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "4";
                        projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                foreach (var project1 in fbprojectyouxiaosYxTousuchengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "4";
                        projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "4";
                        projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }


                foreach (var project1 in fbprojectreasonsWxZhiyichengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "5";
                        projectfasongxiaoxiDTO.Khname = project1.Reasonname;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "5";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "5";
                        projectfasongxiaoxiDTO.Khname = project1.Reasonname;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                foreach (var project1 in fbprojectreasonsWxTousuchengli)
                {
                    var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
                    if (projectfasongxiaoxiduanxinDrhx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
                        projectfasongxiaoxiDTO.Gyszl = "5";
                        projectfasongxiaoxiDTO.Khname = project1.Reasonname;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
                    }

                    var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
                    if (projectfasongxiaoxiappDshx == null)
                    {
                        var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
                        projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
                        projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
                        projectfasongxiaoxiDTO.Xiaoxileixing = "6";
                        projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
                        projectfasongxiaoxiDTO.Gyszl = "5";
                        projectfasongxiaoxiDTO.Khname = project1.Reasonname;
                        projectfasongxiaoxiDTO.RecStatus = "A";
                        projectfasongxiaoxiDTO.Createtime = DateTime.Now;
                        var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
                        if (project != null)
                        {
                            projectfasongxiaoxiDTO.Projectname = project.Name;
                        }
                        projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
                    }
                }

                //查询需要发送短信的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }

                //查询需要发送App消息的客户
                foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
                {
                    var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
                    if (intentionCustomer == null)
                    {
                        var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();

                        if (cooperatecustomCustomer != null)
                        {
                            if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
                            }
                            else
                            {
                                projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
                            }
                            projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
                            projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
                            projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;

                        }
                    }
                    else
                    {
                        if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
                        }
                        else
                        {
                            projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
                        }
                        projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
                        projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
                        projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
                    }
                }


                //推送App
                foreach (var ywjl in Ywjl)
                {

                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }

                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书\","
                            + "\"content\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：" + ywjl.Phone + " \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：" + ywjl.Phone + " \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
                    }




                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    int j = 0;
                    while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                    {
                        j = j + 1;
                        string numberstring = "";
                        string customename = "";
                        if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                        {
                            int countt = (j * 1000);
                            if (countt > projectfasongxiaoxisywjl.Count)
                            {
                                countt = projectfasongxiaoxisywjl.Count;
                            }
                            for (int i = 0; i < countt; i++)
                            {
                                if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                {
                                    continue;
                                }
                                numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
                                customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                            }
                        }

                        if (numberstring.EndsWith(","))
                        {
                            numberstring = numberstring.Substring(0, numberstring.Length - 1);
                        }
                        string conment = "{"
                            + "\"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书\","
                            + "\"content\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：400-028-8080 \","
                              + "\"getui_alias\": [" + numberstring + "],"
                                + "\"payload\": {\"text\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：400-028-8080 \"},"
                                    + "\"force_notification\": true"
                                    + "}";

                        string result2 = SMSHelper.PushApp(conment);
                        _logger.LogInformation("result2:" + result2);
                        JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);

                        if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
                        {
                            var isOK = jobjectresult["isOK"].ToString();

                            foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                            {
                                if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
                                {
                                    var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                    projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                    projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                    projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                    projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                    projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                    projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                    projectfasongxiaoxi.RecStatus = "A";
                                    projectfasongxiaoxi.Createtime = DateTime.Now;
                                    _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                }
                            }
                            _context.SaveChanges();
                        }



                        _logger.LogInformation("无业务经理推送app给客户" + customename);
                    }



                }



                //发送短信
                foreach (var ywjl in Ywjl)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }

                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

                                }
                            }

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：" + ywjl.Phone);
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
                            }
                        }





                    }

                }
                //业务经理为空
                if (true)
                {
                    var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
                    if (projectfasongxiaoxisywjl.Count >= 100)
                    {
                        int j = 0;
                        while (j * 1000 <= projectfasongxiaoxisywjl.Count)
                        {
                            j = j + 1;
                            string numberstring = "";
                            string customename = "";
                            if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
                            {
                                int countt = (j * 1000);
                                if (countt > projectfasongxiaoxisywjl.Count)
                                {
                                    countt = projectfasongxiaoxisywjl.Count;
                                }
                                for (int i = 0; i < countt; i++)
                                {
                                    if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
                                    {
                                        continue;
                                    }
                                    numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
                                    customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";

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

                            if (numberstring.Split(',').Length >= 100)
                            {
                                string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：400-028-8080");
                                if (int.Parse(sss) >= 0)
                                {
                                    foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
                                    {
                                        var projectfasongxiaoxi = new Projectfasongxiaoxi();
                                        projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
                                        projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
                                        projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
                                        projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
                                        projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
                                        projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
                                        projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
                                        projectfasongxiaoxi.RecStatus = "A";
                                        projectfasongxiaoxi.Createtime = DateTime.Now;
                                        _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
                                    }
                                    _context.SaveChanges();
                                }
                                _logger.LogInformation("无客户经理发送短信给客户" + customename);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                _logger.LogInformation(ex.ToString());
            }
            #endregion


        }

        public async Task huoquhuiyuanAsync()
        {