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/CommonToolsCore/AutoMapperConfigs.cs | 3 zhengcaioa/DTO/ProjectfasongxiaoxiDTO.cs | 24 zhengcaioa/Services/ProjectService.cs | 20 zhengcaioa/IServices/IProjectService.cs | 1 zhengcaioa/CommonToolsCore/SMSHelper.cs | 17 zhengcaioa/Model/Projectfasongxiaoxi.cs | 20 zhengcaioa/zhengcaioa/Controllers/LiaotianController.cs | 18 zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs | 2836 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ zhengcaioa/Model/zhengcaioaContext.cs | 36 9 files changed, 2,962 insertions(+), 13 deletions(-) diff --git a/zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs b/zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs index e3d5674..9e149f3 100644 --- a/zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs +++ b/zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs @@ -61,6 +61,9 @@ CreateMap<IntentionCustomerDTO, CooperatecustomCustomerDTO>(); CreateMap<CooperatecustomCustomerDTO, IntentionCustomerDTO>(); + CreateMap<IntentionCustomer, CooperatecustomCustomer>(); + CreateMap<CooperatecustomCustomer, IntentionCustomer>(); + CreateMap<CooperOrder, CooperOrderDTO>(); CreateMap<CooperOrderDTO, CooperOrder>(); diff --git a/zhengcaioa/CommonToolsCore/SMSHelper.cs b/zhengcaioa/CommonToolsCore/SMSHelper.cs index a3dfe62..a0b2b3a 100644 --- a/zhengcaioa/CommonToolsCore/SMSHelper.cs +++ b/zhengcaioa/CommonToolsCore/SMSHelper.cs @@ -115,5 +115,22 @@ string ssss = HttpClientRequest.HttpClientPostGB2312(url, "POST", data); return ssss; } + + + + /// <summary> + /// 鐭俊瀹炰緥 + /// </summary> + /// <param name="phone"></param> + /// <param name="date"></param> + /// <returns></returns> + public static string PushApp(string conment) + { + + string url = "http://yjdl.51zhengcai.com/pushms"; + string data = conment; + string ssss = HttpClientRequest.HttpClientPost(url, "POST", data); + return ssss; + } } } diff --git a/zhengcaioa/DTO/ProjectfasongxiaoxiDTO.cs b/zhengcaioa/DTO/ProjectfasongxiaoxiDTO.cs new file mode 100644 index 0000000..143f27d --- /dev/null +++ b/zhengcaioa/DTO/ProjectfasongxiaoxiDTO.cs @@ -0,0 +1,24 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Text; + +namespace DTO +{ + public class ProjectfasongxiaoxiDTO + { + public string Id { get; set; } + public string ProjectId { get; set; } + public string ProjectmingxiId { get; set; } + public string Xiaoxileixing { get; set; } + public string Xiaoxizhonglei { get; set; } + public string RecStatus { get; set; } + public DateTime? Createtime { get; set; } + public string Gyszl { get; set; } + public string Khname { get; set; } + public string Tel { get; set; } + public string Ywjl { get; set; } + public string KhId { get; set; } + public string HuiyuanId { get; set; } + public string Projectname { get; set; } + } +} diff --git a/zhengcaioa/IServices/IProjectService.cs b/zhengcaioa/IServices/IProjectService.cs index 33aafb7..cf26498 100644 --- a/zhengcaioa/IServices/IProjectService.cs +++ b/zhengcaioa/IServices/IProjectService.cs @@ -59,5 +59,6 @@ ResultEntity GetZhengfuProjectDTOByPageurl(string Pageurl,string Id); ResultEntity GetZhengfuProjectDTOByTitle(string Title, string Id,DateTime? NoticeTime); + ResultEntity saveProjectfasongxiaoxi(Projectfasongxiaoxi project); } } diff --git a/zhengcaioa/Model/Projectfasongxiaoxi.cs b/zhengcaioa/Model/Projectfasongxiaoxi.cs new file mode 100644 index 0000000..a01bdbc --- /dev/null +++ b/zhengcaioa/Model/Projectfasongxiaoxi.cs @@ -0,0 +1,20 @@ +锘縰sing System; +using System.Collections.Generic; + +#nullable disable + +namespace zhengcaioa.Models +{ + public partial class Projectfasongxiaoxi + { + public string Id { get; set; } + public string ProjectId { get; set; } + public string ProjectmingxiId { get; set; } + public string Xiaoxileixing { get; set; } + public string Xiaoxizhonglei { get; set; } + public string RecStatus { get; set; } + public DateTime? Createtime { get; set; } + public string Gyszl { get; set; } + public string Khname { get; set; } + } +} diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 9b1addc..ef8cb43 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -106,6 +106,7 @@ public virtual DbSet<Projectreason> Projectreasons { get; set; } public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; } public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; } + public virtual DbSet<Projectfasongxiaoxi> Projectfasongxiaoxis { get; set; } public virtual DbSet<SysAttachment> SysAttachments { get; set; } public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; } public virtual DbSet<SysCode> SysCodes { get; set; } @@ -5907,6 +5908,41 @@ .HasColumnName("zb_zhiyistatus"); }); + modelBuilder.Entity<Projectfasongxiaoxi>(entity => + { + entity.ToTable("Projectfasongxiaoxi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime"); + + entity.Property(e => e.ProjectId).HasMaxLength(50); + + entity.Property(e => e.ProjectmingxiId).HasMaxLength(50); + + entity.Property(e => e.RecStatus) + .HasMaxLength(1) + .HasColumnName("rec_status"); + + entity.Property(e => e.Xiaoxileixing) + .HasMaxLength(50) + .HasColumnName("xiaoxileixing"); + + entity.Property(e => e.Xiaoxizhonglei) + .HasMaxLength(50) + .HasColumnName("xiaoxizhonglei"); + + entity.Property(e => e.Gyszl) + .HasMaxLength(50) + .HasColumnName("gyszl"); + + entity.Property(e => e.Khname) + .HasMaxLength(50) + .HasColumnName("khname"); + }); + modelBuilder.Entity<SysAttachment>(entity => { entity.ToTable("sys_attachment"); diff --git a/zhengcaioa/Services/ProjectService.cs b/zhengcaioa/Services/ProjectService.cs index 3653cb2..089febc 100644 --- a/zhengcaioa/Services/ProjectService.cs +++ b/zhengcaioa/Services/ProjectService.cs @@ -1423,5 +1423,25 @@ } + public ResultEntity saveProjectfasongxiaoxi(Projectfasongxiaoxi project) + { + ResultEntity resultEntity = new ResultEntity(); + try + { + + project.Id = Guid.NewGuid().ToString(); + _context.Projectfasongxiaoxis.Add(project); + _context.SaveChanges(); + resultEntity.ReturnID = project.Id; + resultEntity.Result = true; + } + catch (Exception ex) + { + resultEntity.Result = false; + resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠$悊鍛�"; + + } + return resultEntity; + } } } diff --git a/zhengcaioa/zhengcaioa/Controllers/LiaotianController.cs b/zhengcaioa/zhengcaioa/Controllers/LiaotianController.cs index 0b53eac..2ca906d 100644 --- a/zhengcaioa/zhengcaioa/Controllers/LiaotianController.cs +++ b/zhengcaioa/zhengcaioa/Controllers/LiaotianController.cs @@ -183,13 +183,15 @@ ResultEntity resultEntity = new ResultEntity(); resultEntity.Result = false; - List <LiaotianDTO> liaotianDTOs =_liaotianService.SearchForPrint(new LiaotianDTOSearch()).Where(x=>x.Clientid =="A").ToList(); - + List <LiaotianDTO> liaotianDTOs =_liaotianService.SearchForPrint(new LiaotianDTOSearch()).ToList();//.Where(x=>x.Clientid =="A") + try { + int i = 0; foreach (var liaotianDTO in liaotianDTOs) { + i = i + 1; string api_domain = _configuration.GetSection("Elasticsearchurl").Value; string url = $"{api_domain}/liaotian/_doc/" + liaotianDTO.Id; @@ -356,6 +358,11 @@ } data.Modifier = curentuser.Id; data.Modifytime = DateTime.Now; + + + + resultEntity = _liaotianService.saveLiaotian(data); + if (!string.IsNullOrEmpty(data.Id)) { @@ -395,11 +402,8 @@ } } - - resultEntity = _liaotianService.saveLiaotian(data); - //string api_domain = _configuration.GetSection("Elasticsearchurl").Value; @@ -432,7 +436,7 @@ // } // Newtonsoft.Json.Linq.JObject jobject = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(result); - + // if (jobject["error"]==null&& jobject["_shards"]["successful"].ToString() == "1") // { // resultEntity.Result = true; @@ -448,7 +452,7 @@ // resultEntity.Result = false; // throw e; - + //} 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