From 688b1ea208da068bfd5911eacc4d2be023219a7c Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 24 二月 2023 13:51:21 +0800 Subject: [PATCH] 1、APP和短信同时推送,没有加APP的只推短信。 2、有归属的客户就留客户经理的电话,没有归属的客户留公司400电话。 --- zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs | 2836 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 2,830 insertions(+), 6 deletions(-) diff --git a/zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs b/zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs index ae5d141..b38cc0b 100644 --- a/zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs +++ b/zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs @@ -1,4 +1,6 @@ -锘縰sing DTO; +锘縰sing 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,2823 @@ { 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 = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); + + var fbprojectreasons = _context.Projectreasons.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); + + var fbprojectyouxiaos = _context.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; + } + } + + //鏌ヨ闇�瑕佸彂閫丄pp娑堟伅鐨勫鎴� + 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; + } + } + + + //鎺ㄩ�丄pp + 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 + "鎺ㄩ�乤pp缁欏鎴�" + 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("鏃犱笟鍔$粡鐞嗘帹閫乤pp缁欏鎴�" + 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 + //鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛� + //濡傛灉鎮ㄥ湪鍙傚姞鈥� 椤圭洰鍚嶇О 鈥濇姇鏍囧墠鎵炬斂閲囧挩璇㈡鏌ユ爣涔︼紝鑷冲皯鎻愬崌璇勫寰楀垎5 - 8鍒嗭紝涔熻涓爣鐨勫氨鏄吹鍏徃銆備簡瑙h鎯呰鍜ㄨ锛� 銆� + //鐭俊 + //鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛� + //鑷冲皯涓烘偍鎻愬崌璇勫寰楀垎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 = _context.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; + } + } + + //鏌ヨ闇�瑕佸彂閫丄pp娑堟伅鐨勫鎴� + 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; + } + } + + + //鎺ㄩ�丄pp + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛屽鏋滄偍鍦ㄥ弬鍔犫��" + projectfasongxiaoxisywjl[i].Projectname + "鈥濇姇鏍囧墠鎵炬斂閲囧挩璇㈡鏌ユ爣涔︼紝鑷冲皯鎻愬崌璇勫寰楀垎5-8鍒嗭紝涔熻涓爣鐨勫氨鏄吹鍏徃銆備簡瑙h鎯呰鍜ㄨ锛�" + ywjl.Phone + " \"," + + "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\"," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛屽鏋滄偍鍦ㄥ弬鍔犫��" + projectfasongxiaoxisywjl[i].Projectname + "鈥濇姇鏍囧墠鎵炬斂閲囧挩璇㈡鏌ユ爣涔︼紝鑷冲皯鎻愬崌璇勫寰楀垎5-8鍒嗭紝涔熻涓爣鐨勫氨鏄吹鍏徃銆備簡瑙h鎯呰鍜ㄨ锛�" + 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 + "鎺ㄩ�乤pp缁欏鎴�" + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛屽鏋滄偍鍦ㄥ弬鍔犫��" + projectfasongxiaoxisywjl[i].Projectname + "鈥濇姇鏍囧墠鎵炬斂閲囧挩璇㈡鏌ユ爣涔︼紝鑷冲皯鎻愬崌璇勫寰楀垎5-8鍒嗭紝涔熻涓爣鐨勫氨鏄吹鍏徃銆備簡瑙h鎯呰鍜ㄨ锛�400-028-8080 \"," + + "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\"," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛屽鏋滄偍鍦ㄥ弬鍔犫��" + projectfasongxiaoxisywjl[i].Projectname + "鈥濇姇鏍囧墠鎵炬斂閲囧挩璇㈡鏌ユ爣涔︼紝鑷冲皯鎻愬崌璇勫寰楀垎5-8鍒嗭紝涔熻涓爣鐨勫氨鏄吹鍏徃銆備簡瑙h鎯呰鍜ㄨ锛�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( "鏃犱笟鍔$粡鐞嗘帹閫乤pp缁欏鎴�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戜负鎮ㄦ彁鍗囪瘎瀹″緱鍒�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, "鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戜负鎮ㄦ彁鍗囪瘎瀹″緱鍒�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鍚嶏細 + //鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝 + //璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛� + + 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 = _context.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; + } + } + + //鏌ヨ闇�瑕佸彂閫丄pp娑堟伅鐨勫鎴� + 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; + } + } + + + //鎺ㄩ�丄pp + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛�" + ywjl.Phone + " \"," + + "\"getui_alias\": [" + numberstring + "]," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛�" + 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 + "鎺ㄩ�乤pp缁欏鎴�" + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛�400-028-8080 \"," + + "\"getui_alias\": [" + numberstring + "]," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛�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( "鏃犱笟鍔$粡鐞嗘帹閫乤pp缁欏鎴�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╄瘎瀹′笓瀹舵壘涓嶅嚭涓昏鏂规鎵e垎鐞嗙敱锛岃嚦灏戝姪鎮ㄦ彁鍗囩患鍚堣瘎瀹″緱鍒�5-10鍒嗐�備簡瑙h鎯呰鍜ㄨ锛�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鍚嶏細 + //鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝 + //璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛� 銆� + 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 = _context.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; + } + } + + //鏌ヨ闇�瑕佸彂閫丄pp娑堟伅鐨勫鎴� + 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; + } + } + + + //鎺ㄩ�丄pp + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛�" + ywjl.Phone + " \"," + + "\"getui_alias\": [" + numberstring + "]," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛�" + 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 + "鎺ㄩ�乤pp缁欏鎴�" + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛�400-028-8080 \"," + + "\"getui_alias\": [" + numberstring + "]," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛�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("鏃犱笟鍔$粡鐞嗘帹閫乤pp缁欏鎴�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟鈥滄爣涔︽鏌モ�濄�佲�滄爣涔︽寚瀵尖�濓紝閫�浼戣祫娣辫瘎瀹′笓瀹跺湪寮�鏍囧墠鎸夌収璇勬爣娴佺▼涓烘偍浜ゅ弶妫�鏌ャ�佹寚瀵兼爣涔︼紝璁╂偍寰楅綈鍏ㄩ儴瀹㈣鍒嗗拰涓昏鍒嗭紝浠庢涓嶅啀涓烘爣涔﹀埗浣滄搷蹇冦�備簡瑙h鎯呰鍜ㄨ锛�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 璐ㄧ枒鎶曡瘔鏈垨鏀寔锛� + //鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛� + //鑺遍挶鏇村皯銆佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛� + + 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 fbprojiectid = new List<string>(); + foreach (var project in projects) + { + fbprojiectid.Add(project.Id); + } + var fbprojectzhongbiaos = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); + + + + var fbprojectzhongbiaosZbZhiyichengli = _context.Projectzhongbiaos.Where(x => x.ZbZhiyichengli == "D" && fbprojiectid.Contains(x.ProjectId) ).ToList(); + var fbprojectzhongbiaosZbTousuchengli = _context.Projectzhongbiaos.Where(x => x.ZbTousuchengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList(); + + var fbprojectreasonsWxZhiyichengli = _context.Projectreasons.Where(x => x.WxZhiyichengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList(); + var fbprojectreasonsWxTousuchengli = _context.Projectreasons.Where(x => x.WxTousuchengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList(); + + var fbprojectyouxiaosYxZhiyichengli = _context.Projectyouxiaos.Where(x => x.YxZhiyichengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList(); + var fbprojectyouxiaosYxTousuchengli = _context.Projectyouxiaos.Where(x => x.YxTousuchengli == "D" && fbprojiectid.Contains(x.ProjectId)).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; + } + } + + //鏌ヨ闇�瑕佸彂閫丄pp娑堟伅鐨勫鎴� + 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; + } + } + + + //鎺ㄩ�丄pp + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功\"," + + "\"content\": \"鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛岃姳閽辨洿灏戙�佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛�" + ywjl.Phone + " \"," + + "\"getui_alias\": [" + numberstring + "]," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛岃姳閽辨洿灏戙�佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛�" + 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 + "鎺ㄩ�乤pp缁欏鎴�" + 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\": \"鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功\"," + + "\"content\": \"鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛岃姳閽辨洿灏戙�佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛�400-028-8080 \"," + + "\"getui_alias\": [" + numberstring + "]," + + "\"payload\": {\"text\": \"鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛岃姳閽辨洿灏戙�佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛�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("鏃犱笟鍔$粡鐞嗘帹閫乤pp缁欏鎴�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛岃姳閽辨洿灏戙�佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛�" + 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, "鏀块噰鍜ㄨ鍏徃涓撲笟涓轰緵搴斿晢浠f嫙璐ㄧ枒鍑姐�佹姇璇変功锛岃祫娣辨斂搴滈噰璐硶寰嬩笓瀹躲��3000澶氫欢璐ㄧ枒鎶曡瘔鎴愬姛妗堜緥锛屾壘鏀块噰鍜ㄨ锛岃姳閽辨洿灏戙�佽儨绠楁洿楂橈紝鎺ュ彈鎺ㄩ闄╀唬鐞嗭紝璐ㄧ枒鎶曡瘔鎴愬姛鍐嶆敹璐广�備簡瑙h鎯呰鍜ㄨ锛�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() { -- Gitblit v1.9.1