using AutoMapper; using CommonToolsCore; using DTO; using IServices; using Microsoft.EntityFrameworkCore; using Microsoft.Extensions.Configuration; using Microsoft.Extensions.DependencyInjection; using Microsoft.Extensions.Hosting; using Microsoft.Extensions.Logging; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.IO; 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; using zhengcaioa.IService; using zhengcaioa.Models; namespace zhengcaioa.Timer { public class TimerGetShopUsersService : BackgroundService { private readonly ILogger _logger; private readonly IConfiguration _configuration; private readonly ILiaotianService _liaotianService; private readonly IHttpClientFactory _clientFactory; private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService; private readonly IIntentionCustomerService _intentionCustomerService; private readonly zhengcaioaContext _context; private readonly IMapper _mapper; private readonly zcUserInfoN_dbContext _zcUserInfoN_DbContext; public TimerGetShopUsersService(ILogger logger, IServiceScopeFactory factory) { _logger = logger; _configuration = factory.CreateScope().ServiceProvider.GetRequiredService(); _liaotianService = factory.CreateScope().ServiceProvider.GetRequiredService(); _clientFactory = factory.CreateScope().ServiceProvider.GetRequiredService(); _cooperatecustomCustomerService = factory.CreateScope().ServiceProvider.GetRequiredService(); _intentionCustomerService = factory.CreateScope().ServiceProvider.GetRequiredService(); _context = factory.CreateScope().ServiceProvider.GetRequiredService(); _mapper = factory.CreateScope().ServiceProvider.GetRequiredService(); _zcUserInfoN_DbContext = factory.CreateScope().ServiceProvider.GetRequiredService(); } protected override async Task ExecuteAsync(CancellationToken stoppingToken) { _logger.LogInformation("TimerGetShopUsersService is starting."); //stoppingToken.Register(() => File.Create($"E:\\dotnetCore\\Practice\\Practice\\{DateTime.Now.Millisecond}.txt")); DateTime datenow = DateTime.Now; DateTime datenowfasongxiaoxi = DateTime.Now.Date; while (!stoppingToken.IsCancellationRequested) { _logger.LogInformation("TimerGetShopUsersService 开始执行"); _logger.LogInformation(datenow.ToString("yyyy-MM-dd HH:mm:ss")); _logger.LogInformation("datenowfasongxiaoxi.Day:" + datenowfasongxiaoxi.ToString("yyyy-MM-dd HH:mm:ss")); _logger.LogInformation("DateTime.Now.Hour:" + DateTime.Now.Hour); if (datenowfasongxiaoxi <= DateTime.Now.Date && DateTime.Now.Hour == 12) //if (true) { _logger.LogInformation("datenowfasongxiaoxi.Day" + datenowfasongxiaoxi.ToString("yyyy-MM-dd HH:mm:ss")); try { datenowfasongxiaoxi = DateTime.Now.Date.AddDays(1); this.fasongxiaoxi(); } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } } //每个小时计算一次 if (datenow.Hour == DateTime.Now.Hour) //if (true) { try { await this.huoquhuiyuanAsync(); } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } datenow = DateTime.Now.AddHours(1); } await Task.Delay(TimeSpan.FromMinutes(10), stoppingToken); _logger.LogInformation("TimerGetShopUsersService 继续执行"); } _logger.LogInformation("TimerGetShopUsersService background task is stopping."); } public override void Dispose() { base.Dispose(); } //查询并且发送短信和app消息给客户 public void fasongxiaoxi() { string appkey = "BC-3ed0636563ff4f0f96d6fab0c150e940"; string huawei = "IM"; string oppo = "IM"; string xiaomi = "IM"; string vivo = "1"; var startdate = DateTime.Now.AddMonths(-3); var projects =_context.Projects.Where(x => x.RecStatus == "A" && x.StartTime >= startdate).ToList(); var projiectid = new List(); 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(); //关联表 var customerGuanlianhuiyuans = _context.CustomerGuanlianhuiyuans.Where(x => x.RecStatus == "A").ToList(); //会员表 var frameworkUsers = _zcUserInfoN_DbContext.FrameworkUsers.Where(x => x.IsValid == true).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(); foreach (var project in fbprojects) { fbprojiectid.Add(project.Id); } var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); var fbprojectreasons = projectreasons.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); var fbprojectyouxiaos = projectyouxiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); var projectfasongxiaoxiDTOsduanxin = new List(); var projectfasongxiaoxiDTOsapp = new List(); 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); } } var projectfasongxiaoxiDTOsduanxinzuizhong = new List(); //查询需要发送短信的客户 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id && x.Huiyuanid != cooperatecustomCustomer.HuiyuanId).ToList(); if(customerGuanlianhuiyuansqita!=null&& customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x=> huiyuanids.Contains(x.Id)).ToList(); if(frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower() ; projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id && x.Huiyuanid != intentionCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } var projectfasongxiaoxiDTOsappzuizhong = new List(); //查询需要发送App消息的客户 foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp) { var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (intentionCustomer == null) { var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (cooperatecustomCustomer != null) { if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone)) { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone; } else { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel; } projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl; projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id; projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id ).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id ).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } //发送短信 foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.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 = projectfasongxiaoxiDTOsduanxinzuizhong.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); } } } } //推送App foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == ywjl.Id).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"" + ywjl.UserSn + "\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \""+ ywjl.UserName + "\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司的“标书预评审”服务,由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书,杜绝废标 、帮助您得到全部综合评审得分,经政采咨询公司检查过的标书,不可能被废标,详情请咨询:" + ywjl.Phone + " \"," + "\"notification\": { \"title\": \"政采咨询公司的“标书预评审”服务 \",\"body\": \"政采咨询公司的“标书预评审”服务 \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":"+ vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司的“标书预评审”服务\"," // + "\"content\": \"政采咨询公司的“标书预评审”服务,由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书,杜绝废标 、帮助您得到全部综合评审得分,经政采咨询公司检查过的标书,不可能被废标,详情请咨询:" + ywjl.Phone + " \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司的“标书预评审”服务,由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书,杜绝废标 、帮助您得到全部综合评审得分,经政采咨询公司检查过的标书,不可能被废标,详情请咨询:" + ywjl.Phone + " \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename); //} } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == null).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"kehujingli\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"客户经理\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司的“标书预评审”服务,由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书,杜绝废标 、帮助您得到全部综合评审得分,经政采咨询公司检查过的标书,不可能被废标,详情请咨询:400-028-8080 \"," + "\"notification\": { \"title\": \"政采咨询公司的“标书预评审”服务 \",\"body\": \"政采咨询公司的“标书预评审”服务 \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation("无业务经理推送app给客户推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司的“标书预评审”服务\"," // + "\"content\": \"政采咨询公司的“标书预评审”服务,由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书,杜绝废标 、帮助您得到全部综合评审得分,经政采咨询公司检查过的标书,不可能被废标,详情请咨询:400-028-8080 \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司的“标书预评审”服务,由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书,杜绝废标 、帮助您得到全部综合评审得分,经政采咨询公司检查过的标书,不可能被废标,详情请咨询:400-028-8080 \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation("无业务经理推送app给客户" + customename); //} } } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } #endregion #region 第2名、第3名与第一名分差3分以内,推送给第2名和第3名: //APP //政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由, //如果您在参加“ 项目名称 ”投标前找政采咨询检查标书,至少提升评审得分5 - 8分,也许中标的就是贵公司。了解详情请咨询: 。 //短信 //政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由, //至少为您提升评审得分5 - 8分,您最近未中的标都可以中!了解详情请咨询: try { var fbprojects = projects.Where(x=>x.DrhxDefen !=null && x.DshxDefen !=null).ToList(); var fbprojiectid = new List(); foreach (var project in fbprojects) { fbprojiectid.Add(project.Id); } var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); var projectfasongxiaoxiDTOsduanxin = new List(); var projectfasongxiaoxiDTOsapp = new List(); 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 = "A"; 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.Dshx; projectfasongxiaoxiDTO.RecStatus = "A"; 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.Dshx; projectfasongxiaoxiDTO.RecStatus = "A"; projectfasongxiaoxiDTO.Createtime = DateTime.Now; projectfasongxiaoxiDTO.Projectname = project1.Name; projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO); } } } } var projectfasongxiaoxiDTOsduanxinzuizhong = new List(); //查询需要发送短信的客户 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id && x.Huiyuanid != cooperatecustomCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id && x.Huiyuanid != intentionCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } var projectfasongxiaoxiDTOsappzuizhong = new List(); //查询需要发送App消息的客户 foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp) { var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (intentionCustomer == null) { var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (cooperatecustomCustomer != null) { if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone)) { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone; } else { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel; } projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl; projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id; projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } //发送短信 foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少为您提升评审得分5-8分,您最近未中的标都可以中!了解详情请咨询:" + ywjl.Phone); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename); } } } } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少为您提升评审得分5-8分,您最近未中的标都可以中!了解详情请咨询:400-028-8080"); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation("无客户经理发送短信给客户" + customename); } } } } //推送App foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == ywjl.Id).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"" + ywjl.UserSn + "\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"" + ywjl.UserName + "\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书,至少提升评审得分5-8分,也许中标的就是贵公司。了解详情请咨询:" + ywjl.Phone + " \"," + "\"notification\": { \"title\": \"政采咨询公司专业“标书检查”、“标书指导” \",\"body\": \"政采咨询公司专业“标书检查”、“标书指导” \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList(); //for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) //{ // string conment = "{" //+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\"," //+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书,至少提升评审得分5-8分,也许中标的就是贵公司。了解详情请咨询:" + ywjl.Phone + " \"," // + "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\"," // + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书,至少提升评审得分5-8分,也许中标的就是贵公司。了解详情请咨询:" + ywjl.Phone + " \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // if (isOK.IndexOf(projectfasongxiaoxisywjl[i].Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname); //} } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == null).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"kehujingli\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"客户经理\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书,至少提升评审得分5-8分,也许中标的就是贵公司。了解详情请咨询:400-028-8080 \"," + "\"notification\": { \"title\": \"政采咨询公司专业“标书检查”、“标书指导” \",\"body\": \"政采咨询公司专业“标书检查”、“标书指导” \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation("无业务经理推送app给客户推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList(); // for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) // { // string conment = "{" // + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\"," // + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书,至少提升评审得分5-8分,也许中标的就是贵公司。了解详情请咨询:400-028-8080 \"," // + "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\"," // + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书,至少提升评审得分5-8分,也许中标的就是贵公司。了解详情请咨询:400-028-8080 \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // if (isOK.IndexOf(projectfasongxiaoxisywjl[i].Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // _logger.LogInformation( "无业务经理推送app给客户" + projectfasongxiaoxisywjl[i].Khname); // } } } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } #endregion #region 第2名与第一名分差5分以内,推送给第2名: //政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书, //让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询: try { var fbprojects = projects.Where(x => x.DrhxDefen != null).ToList(); var fbprojiectid = new List(); foreach (var project in fbprojects) { fbprojiectid.Add(project.Id); } var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); var projectfasongxiaoxiDTOsduanxin = new List(); var projectfasongxiaoxiDTOsapp = new List(); 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); } } } } var projectfasongxiaoxiDTOsduanxinzuizhong = new List(); //查询需要发送短信的客户 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id && x.Huiyuanid != cooperatecustomCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id && x.Huiyuanid != intentionCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } var projectfasongxiaoxiDTOsappzuizhong = new List(); //查询需要发送App消息的客户 foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp) { var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (intentionCustomer == null) { var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (cooperatecustomCustomer != null) { if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone)) { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone; } else { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel; } projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl; projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id; projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } //发送短信 foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:" + ywjl.Phone); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename); } } } } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:400-028-8080"); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation("无客户经理发送短信给客户" + customename); } } } } //推送App foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == ywjl.Id).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"" + ywjl.UserSn + "\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"" + ywjl.UserName + "\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:" + ywjl.Phone + " \"," + "\"notification\": { \"title\": \"政采咨询公司专业“标书检查”、“标书指导” \",\"body\": \"政采咨询公司专业“标书检查”、“标书指导” \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\"," // + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:" + ywjl.Phone + " \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:" + ywjl.Phone + " \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename); //} } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == null).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"kehujingli\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"客户经理\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:400-028-8080 \"," + "\"notification\": { \"title\": \"政采咨询公司专业“标书检查”、“标书指导” \",\"body\": \"政采咨询公司专业“标书检查”、“标书指导” \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation("无业务经理推送app给客户推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\"," // + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:400-028-8080 \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让评审专家找不出主观方案扣分理由,至少助您提升综合评审得分5-10分。了解详情请咨询:400-028-8080 \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation( "无业务经理推送app给客户" + customename); //} } } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } #endregion #region 第2名与第一名分差10分以内,推送给第2名: //政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书, //让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询: 。 try { var fbprojects = projects.Where(x => x.DrhxDefen != null).ToList(); var fbprojiectid = new List(); foreach (var project in fbprojects) { fbprojiectid.Add(project.Id); } var fbprojectzhongbiaos = projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList(); var projectfasongxiaoxiDTOsduanxin = new List(); var projectfasongxiaoxiDTOsapp = new List(); 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); } } } } var projectfasongxiaoxiDTOsduanxinzuizhong = new List(); //查询需要发送短信的客户 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id && x.Huiyuanid != cooperatecustomCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id && x.Huiyuanid != intentionCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } var projectfasongxiaoxiDTOsappzuizhong = new List(); //查询需要发送App消息的客户 foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp) { var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (intentionCustomer == null) { var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (cooperatecustomCustomer != null) { if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone)) { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone; } else { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel; } projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl; projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id; projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } //发送短信 foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:" + ywjl.Phone); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename); } } } } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:400-028-8080"); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation("无客户经理发送短信给客户" + customename); } } } } //推送App foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == ywjl.Id).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"" + ywjl.UserSn + "\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"" + ywjl.UserName + "\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:" + ywjl.Phone + " \"," + "\"notification\": { \"title\": \"政采咨询公司专业“标书检查”、“标书指导 \",\"body\": \"政采咨询公司专业“标书检查”、“标书指导 \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\"," // + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:" + ywjl.Phone + " \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:" + ywjl.Phone + " \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename); //} } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == null).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"kehujingli\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"客户经理\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:400-028-8080 \"," + "\"notification\": { \"title\": \"政采咨询公司专业“标书检查”、“标书指导”\",\"body\": \"政采咨询公司专业“标书检查”、“标书指导”\"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation("无业务经理推送app给客户推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\"," // + "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:400-028-8080 \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”,退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书,让您得齐全部客观分和主观分,从此不再为标书制作操心。了解详情请咨询:400-028-8080 \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation("无业务经理推送app给客户" + customename); //} } } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } #endregion #region 质疑投诉未或支持: //政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询, //花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询: try { var fbprojectsDehxZhiyichengli = projects.Where(x => x.DehxZhiyichengli == "D").ToList(); var fbprojectsDehxTousuchengli = projects.Where(x => x.DehxTousuchengli == "D").ToList(); var fbprojectsDshxZhiyichengli = projects.Where(x => x.DshxZhiyichengli == "D").ToList(); var fbprojectsDshxTousuchengli = projects.Where(x => x.DshxTousuchengli == "D").ToList(); var fbprojectzhongbiaosZbZhiyichengli = projectzhongbiaos.Where(x => x.ZbZhiyichengli == "D" ).ToList(); var fbprojectzhongbiaosZbTousuchengli = projectzhongbiaos.Where(x => x.ZbTousuchengli == "D" ).ToList(); var fbprojectreasonsWxZhiyichengli = projectreasons.Where(x => x.WxZhiyichengli == "D" ).ToList(); var fbprojectreasonsWxTousuchengli = projectreasons.Where(x => x.WxTousuchengli == "D" ).ToList(); var fbprojectyouxiaosYxZhiyichengli = projectyouxiaos.Where(x => x.YxZhiyichengli == "D" ).ToList(); var fbprojectyouxiaosYxTousuchengli = projectyouxiaos.Where(x => x.YxTousuchengli == "D" ).ToList(); var projectfasongxiaoxiDTOsduanxin = new List(); var projectfasongxiaoxiDTOsapp = new List(); 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); } } var projectfasongxiaoxiDTOsduanxinzuizhong = new List(); //查询需要发送短信的客户 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id && x.Huiyuanid != cooperatecustomCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id && x.Huiyuanid != intentionCustomer.HuiyuanId).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsduanxinzuizhong.Add(projectfasongxiaoxiDTO); } } } } } var projectfasongxiaoxiDTOsappzuizhong = new List(); //查询需要发送App消息的客户 foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp) { var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (intentionCustomer == null) { var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault(); if (cooperatecustomCustomer != null) { if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone)) { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone; } else { projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel; } projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl; projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id; projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == cooperatecustomCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } 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; //projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO1); //查询该企业下的其他人员 var customerGuanlianhuiyuansqita = customerGuanlianhuiyuans.Where(x => x.Customerid == intentionCustomer.Id).ToList(); if (customerGuanlianhuiyuansqita != null && customerGuanlianhuiyuansqita.Count > 0) { var huiyuanids = new List(); foreach (var customerGuanlianhuiyuan in customerGuanlianhuiyuansqita) { huiyuanids.Add(Guid.Parse(customerGuanlianhuiyuan.Huiyuanid)); } var frameworkUsers1 = frameworkUsers.Where(x => huiyuanids.Contains(x.Id)).ToList(); if (frameworkUsers1 != null && frameworkUsers1.Count > 0) { foreach (var frameworkUser in frameworkUsers1) { var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO(); projectfasongxiaoxiDTO.ProjectId = projectfasongxiaoxiDTO1.ProjectId; projectfasongxiaoxiDTO.ProjectmingxiId = projectfasongxiaoxiDTO1.ProjectmingxiId; projectfasongxiaoxiDTO.Xiaoxileixing = projectfasongxiaoxiDTO1.Xiaoxileixing; projectfasongxiaoxiDTO.Xiaoxizhonglei = projectfasongxiaoxiDTO1.Xiaoxizhonglei; projectfasongxiaoxiDTO.RecStatus = projectfasongxiaoxiDTO1.RecStatus; projectfasongxiaoxiDTO.Createtime = projectfasongxiaoxiDTO1.Createtime; projectfasongxiaoxiDTO.Gyszl = projectfasongxiaoxiDTO1.Gyszl; projectfasongxiaoxiDTO.Khname = projectfasongxiaoxiDTO1.Khname; projectfasongxiaoxiDTO.Tel = frameworkUser.Itcode; projectfasongxiaoxiDTO.Ywjl = projectfasongxiaoxiDTO1.Ywjl; projectfasongxiaoxiDTO.KhId = projectfasongxiaoxiDTO1.KhId; projectfasongxiaoxiDTO.HuiyuanId = frameworkUser.Id.ToString().ToLower(); projectfasongxiaoxiDTO.Projectname = projectfasongxiaoxiDTO1.Projectname; projectfasongxiaoxiDTOsappzuizhong.Add(projectfasongxiaoxiDTO); } } } } } //发送短信 foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:" + ywjl.Phone); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename); } } } } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxinzuizhong.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList(); if (projectfasongxiaoxisywjl.Count >= 100) { int j = 0; while (j * 1000 <= projectfasongxiaoxisywjl.Count) { j = j + 1; string numberstring = ""; string customename = ""; if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0) { int countt = (j * 1000); if (countt > projectfasongxiaoxisywjl.Count) { countt = projectfasongxiaoxisywjl.Count; } for (int i = 0; i < countt; i++) { if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0) { continue; } numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ","; customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ","; } } if (numberstring.EndsWith(",")) { numberstring = numberstring.Substring(0, numberstring.Length - 1); } if (numberstring.Split(',').Length >= 100) { string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:400-028-8080"); if (int.Parse(sss) >= 0) { foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); } _logger.LogInformation("无客户经理发送短信给客户" + customename); } } } } //推送App foreach (var ywjl in Ywjl) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == ywjl.Id).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"" + ywjl.UserSn + "\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"" + ywjl.UserName + "\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:" + ywjl.Phone + " \"," + "\"notification\": { \"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书 \",\"body\": \"政采咨询公司专业为供应商代拟质疑函、投诉书 \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书\"," // + "\"content\": \"政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:" + ywjl.Phone + " \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:" + ywjl.Phone + " \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation(ywjl.UserName + "推送app给客户" + customename); //} } //业务经理为空 if (true) { var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.Where(x => x.Ywjl == null).ToList(); for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++) { string conment = "{" + "\"appkey\": \"" + appkey + "\"," + "\"senderId\": \"kehujingli\"," + "\"senderData\": { \"avatar\": \"\",\"name\": \"客户经理\"}," + "\"to\": { \"type\": \"private\",\"id\": \"" + projectfasongxiaoxisywjl[i].HuiyuanId + "\",\"data\": { \"avatar\": \"\",\"name\": \"\"}}," + "\"type\": \"text\"," + "\"payload\": \"政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:400-028-8080 \"," + "\"notification\": { \"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书 \",\"body\": \"政采咨询公司专业为供应商代拟质疑函、投诉书 \"," + "\"vendorOptions\": {\"huawei\": {\"category\": \"" + huawei + "\"},\"oppo\": {\"channel_id\": \"" + oppo + "\"},\"xiaomi\": {\"channel_id\": \"" + xiaomi + "\"},\"vivo\": {\"classification\":" + vivo + "}}" + "}" + "}"; string result2 = SMSHelper.PushAppduandu(conment); _logger.LogInformation("result2:" + result2); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "200") { var projectfasongxiaoxi = new Projectfasongxiaoxi(); projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); projectfasongxiaoxi.ProjectId = projectfasongxiaoxisywjl[i].ProjectId; projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId; projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing; projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei; projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl; projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname; projectfasongxiaoxi.RecStatus = "A"; projectfasongxiaoxi.Createtime = DateTime.Now; _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); } _context.SaveChanges(); _logger.LogInformation("无业务经理推送app给客户推送app给客户" + projectfasongxiaoxisywjl[i].Khname); } //var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsappzuizhong.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); // } // if (string.IsNullOrEmpty(numberstring)) // { // continue; // } // string conment = "{" // + "\"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书\"," // + "\"content\": \"政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:400-028-8080 \"," // + "\"getui_alias\": [" + numberstring + "]," // + "\"payload\": {\"text\": \"政采咨询公司专业为供应商代拟质疑函、投诉书,资深政府采购法律专家、3000多件质疑投诉成功案例,找政采咨询,花钱更少、胜算更高,接受推风险代理,质疑投诉成功再收费。了解详情请咨询:400-028-8080 \"}," // + "\"force_notification\": true" // + "}"; // string result2 = SMSHelper.PushApp(conment); // _logger.LogInformation("result2:" + result2); // JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); // if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") // { // var isOK = jobjectresult["isOK"].ToString(); // foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl) // { // if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0) // { // var projectfasongxiaoxi = new Projectfasongxiaoxi(); // projectfasongxiaoxi.Id = Guid.NewGuid().ToString(); // projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId; // projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing; // projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei; // projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl; // projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname; // projectfasongxiaoxi.RecStatus = "A"; // projectfasongxiaoxi.Createtime = DateTime.Now; // _context.Projectfasongxiaoxis.Add(projectfasongxiaoxi); // } // } // _context.SaveChanges(); // } // _logger.LogInformation("无业务经理推送app给客户" + customename); //} } } catch (Exception ex) { _logger.LogInformation(ex.ToString()); } #endregion } public async Task huoquhuiyuanAsync() { string Shuchengurl = _configuration.GetSection("Shuchengurl").Value; string GetShopUsers = _configuration.GetSection("GetShopUsers").Value; string huiyuanurl = _configuration.GetSection("huiyuanurl").Value; string GetDateFirstOrderUser = _configuration.GetSection("GetDateFirstOrderUser").Value; string GetUserinfoAndRule = _configuration.GetSection("GetUserinfoAndRule").Value; ResultEntity resultEntity = new ResultEntity(); resultEntity.Result = false; // new TransactionScope(TransactionScopeOption.Required, // new TransactionOptions // { // IsolationLevel = IsolationLevel.ReadCommitted, // Timeout = TransactionManager.MaximumTimeout // } //) //using (TransactionScope scope = new TransactionScope()) //{ //获取最后更新时间 DateTime start = DateTime.Now.AddYears(-10); DateTime end = DateTime.Now; var ssss = _liaotianService.GetSysUpdatetime("getCustomers"); if (ssss != null) { start = ssss.Updatetime; } _logger.LogInformation("start:" + start); _logger.LogInformation("end:" + end); //获取客户并且保存到合作客户 #region 书城 string result = string.Empty; Uri getUrl = new Uri(Shuchengurl + GetShopUsers + "?start="+ start.ToString("yyyy-MM-dd HH:mm:ss") + "&end="+ end.ToString("yyyy-MM-dd HH:mm:ss")); var httpClient = _clientFactory.CreateClient(); httpClient.Timeout = new TimeSpan(0, 0, 10); var Result = await httpClient.GetAsync(getUrl); result = Result.Content.ReadAsStringAsync().Result; _logger.LogInformation("result:" + result); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") { if(jobjectresult["returnObj"] != null && jobjectresult["returnObj"].ToString() != "") { JArray hits = (JArray)jobjectresult["returnObj"]; foreach (var hit in hits) { string id = hit["id"].ToString().ToLower(); CooperatecustomCustomerDTO cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList(id).FirstOrDefault(); //如果不存在关联客户 if (cooperatecustomCustomerDTO == null) { string result2 = string.Empty; Uri postUrl2 = new Uri(huiyuanurl + GetUserinfoAndRule); JObject questions2 = new JObject(); questions2.Add("UserID", id); string requestJson2 = questions2.ToString(); using (HttpContent httpContent = new StringContent(requestJson2)) { httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var httpClient2 = _clientFactory.CreateClient(); httpClient2.Timeout = new TimeSpan(0, 0, 10); var Result2 = await httpClient2.PostAsync(postUrl2, httpContent); result2 = Result2.Content.ReadAsStringAsync().Result; } _logger.LogInformation("result2:" + result2); JObject jobjectresult2 = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult2["code"] == null || jobjectresult2["code"].ToString() != "1") { throw new Exception(jobjectresult2["msg"].ToString()); } JObject jobjectkehu = (JObject)jobjectresult2["data"]; if (jobjectkehu == null || jobjectkehu["Name"] == null || jobjectkehu["Name"].ToString() == "") { throw new Exception("未找到对应的会员!"); } cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList("", jobjectkehu["Name"].ToString()).FirstOrDefault(); //如果不存在当前名字的客户 if (cooperatecustomCustomerDTO == null) { cooperatecustomCustomerDTO = new CooperatecustomCustomerDTO(); cooperatecustomCustomerDTO.Name = jobjectkehu["Name"].ToString(); cooperatecustomCustomerDTO.Tel = jobjectkehu["phonecode"].ToString(); cooperatecustomCustomerDTO.Phone = jobjectkehu["phonecode"].ToString(); cooperatecustomCustomerDTO.HuiyuanId = id; //cooperatecustomCustomerDTO.Remark = hit["personal"].ToString() + "下单时间" + hit["Firsttime"].ToString(); cooperatecustomCustomerDTO.Khly = "01"; cooperatecustomCustomerDTO.Creater = "1"; cooperatecustomCustomerDTO.Createtime = DateTime.Now; cooperatecustomCustomerDTO.Modifier = cooperatecustomCustomerDTO.Creater; cooperatecustomCustomerDTO.Modifytime = cooperatecustomCustomerDTO.Createtime; cooperatecustomCustomerDTO.ShrName = hit["accept_name"].ToString(); cooperatecustomCustomerDTO.ShrTel = hit["mobile"].ToString(); cooperatecustomCustomerDTO.ShrAddress = hit["area"].ToString() + hit["address"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); //2023-03-23 添加在职企业 var customerGuanlianhuiyuan1 = _context.CustomerGuanlianhuiyuans.Where(x => x.Huiyuanid == cooperatecustomCustomerDTO.HuiyuanId && x.Customerid == cooperatecustomCustomerDTO.Id).FirstOrDefault(); if (customerGuanlianhuiyuan1 == null) { CustomerGuanlianhuiyuan customerGuanlianhuiyuan = new CustomerGuanlianhuiyuan(); customerGuanlianhuiyuan.Id = Guid.NewGuid().ToString(); customerGuanlianhuiyuan.Huiyuanid = cooperatecustomCustomerDTO.HuiyuanId; customerGuanlianhuiyuan.Customerid = cooperatecustomCustomerDTO.Id; customerGuanlianhuiyuan.Customertype = "合作客户"; _context.CustomerGuanlianhuiyuans.Add(customerGuanlianhuiyuan); _context.SaveChanges(); } if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } else { cooperatecustomCustomerDTO.HuiyuanId = id; cooperatecustomCustomerDTO.ShrName = hit["accept_name"].ToString(); cooperatecustomCustomerDTO.ShrTel = hit["mobile"].ToString(); cooperatecustomCustomerDTO.ShrAddress = hit["area"].ToString() + hit["address"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); //2023-03-23 添加在职企业 var customerGuanlianhuiyuan1 = _context.CustomerGuanlianhuiyuans.Where(x => x.Huiyuanid == cooperatecustomCustomerDTO.HuiyuanId && x.Customerid == cooperatecustomCustomerDTO.Id).FirstOrDefault(); if (customerGuanlianhuiyuan1 == null) { CustomerGuanlianhuiyuan customerGuanlianhuiyuan = new CustomerGuanlianhuiyuan(); customerGuanlianhuiyuan.Id = Guid.NewGuid().ToString(); customerGuanlianhuiyuan.Huiyuanid = cooperatecustomCustomerDTO.HuiyuanId; customerGuanlianhuiyuan.Customerid = cooperatecustomCustomerDTO.Id; customerGuanlianhuiyuan.Customertype = "合作客户"; _context.CustomerGuanlianhuiyuans.Add(customerGuanlianhuiyuan); _context.SaveChanges(); } if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } } else { cooperatecustomCustomerDTO.HuiyuanId = id; cooperatecustomCustomerDTO.ShrName = hit["accept_name"].ToString(); cooperatecustomCustomerDTO.ShrTel = hit["mobile"].ToString(); cooperatecustomCustomerDTO.ShrAddress = hit["area"].ToString() + hit["address"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); //2023-03-23 添加在职企业 var customerGuanlianhuiyuan1 = _context.CustomerGuanlianhuiyuans.Where(x => x.Huiyuanid == cooperatecustomCustomerDTO.HuiyuanId && x.Customerid == cooperatecustomCustomerDTO.Id).FirstOrDefault(); if (customerGuanlianhuiyuan1 == null) { CustomerGuanlianhuiyuan customerGuanlianhuiyuan = new CustomerGuanlianhuiyuan(); customerGuanlianhuiyuan.Id = Guid.NewGuid().ToString(); customerGuanlianhuiyuan.Huiyuanid = cooperatecustomCustomerDTO.HuiyuanId; customerGuanlianhuiyuan.Customerid = cooperatecustomCustomerDTO.Id; customerGuanlianhuiyuan.Customertype = "合作客户"; _context.CustomerGuanlianhuiyuans.Add(customerGuanlianhuiyuan); _context.SaveChanges(); } if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } } } } else { throw new Exception(jobjectresult["error"].ToString()); } #endregion #region 会员 string result1 = string.Empty; Uri postUrl = new Uri(huiyuanurl + GetDateFirstOrderUser); JObject questions = new JObject(); questions.Add("start", start.ToString("yyyy-MM-dd HH:mm:ss")); questions.Add("end", end.ToString("yyyy-MM-dd HH:mm:ss")); string requestJson = questions.ToString(); using (HttpContent httpContent = new StringContent(requestJson)) { httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var httpClient1 = _clientFactory.CreateClient(); httpClient1.Timeout = new TimeSpan(0, 0, 10); var Result1 = await httpClient1.PostAsync(postUrl, httpContent); result1 = Result1.Content.ReadAsStringAsync().Result; } _logger.LogInformation("result1:" + result1); JObject jobject = (JObject)JsonConvert.DeserializeObject(result1); if (jobject["code"] != null && jobject["code"].ToString() == "1") { if (jobject["data"] != null && jobject["data"].ToString() != "") { JArray hits = (JArray)jobject["data"]; foreach (var hit in hits) { CooperatecustomCustomerDTO cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList(hit["ID"].ToString()).FirstOrDefault(); //如果不存在关联客户 if (cooperatecustomCustomerDTO == null) { cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList("", hit["Name"].ToString()).FirstOrDefault(); //如果不存在当前名字的客户 if (cooperatecustomCustomerDTO == null) { cooperatecustomCustomerDTO = new CooperatecustomCustomerDTO(); cooperatecustomCustomerDTO.Name = hit["Name"].ToString(); cooperatecustomCustomerDTO.Tel = hit["PhoneCode"].ToString(); cooperatecustomCustomerDTO.Phone = hit["PhoneCode"].ToString(); cooperatecustomCustomerDTO.HuiyuanId = hit["ID"].ToString(); cooperatecustomCustomerDTO.Remark = hit["personal"].ToString() + "下单时间" + hit["Firsttime"].ToString(); cooperatecustomCustomerDTO.Khly = "01"; cooperatecustomCustomerDTO.Creater = "1"; cooperatecustomCustomerDTO.Createtime = DateTime.Now; cooperatecustomCustomerDTO.Modifier = cooperatecustomCustomerDTO.Creater; cooperatecustomCustomerDTO.Modifytime = cooperatecustomCustomerDTO.Createtime; resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); //2023-03-23 添加在职企业 var customerGuanlianhuiyuan1 = _context.CustomerGuanlianhuiyuans.Where(x => x.Huiyuanid == cooperatecustomCustomerDTO.HuiyuanId && x.Customerid == cooperatecustomCustomerDTO.Id).FirstOrDefault(); if (customerGuanlianhuiyuan1 == null) { CustomerGuanlianhuiyuan customerGuanlianhuiyuan = new CustomerGuanlianhuiyuan(); customerGuanlianhuiyuan.Id = Guid.NewGuid().ToString(); customerGuanlianhuiyuan.Huiyuanid = cooperatecustomCustomerDTO.HuiyuanId; customerGuanlianhuiyuan.Customerid = cooperatecustomCustomerDTO.Id; customerGuanlianhuiyuan.Customertype = "合作客户"; _context.CustomerGuanlianhuiyuans.Add(customerGuanlianhuiyuan); _context.SaveChanges(); } if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } else { cooperatecustomCustomerDTO.HuiyuanId = hit["ID"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); //2023-03-23 添加在职企业 var customerGuanlianhuiyuan1 = _context.CustomerGuanlianhuiyuans.Where(x => x.Huiyuanid == cooperatecustomCustomerDTO.HuiyuanId && x.Customerid == cooperatecustomCustomerDTO.Id).FirstOrDefault(); if (customerGuanlianhuiyuan1 == null) { CustomerGuanlianhuiyuan customerGuanlianhuiyuan = new CustomerGuanlianhuiyuan(); customerGuanlianhuiyuan.Id = Guid.NewGuid().ToString(); customerGuanlianhuiyuan.Huiyuanid = cooperatecustomCustomerDTO.HuiyuanId; customerGuanlianhuiyuan.Customerid = cooperatecustomCustomerDTO.Id; customerGuanlianhuiyuan.Customertype = "合作客户"; _context.CustomerGuanlianhuiyuans.Add(customerGuanlianhuiyuan); _context.SaveChanges(); } if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } } } } } else { throw new Exception(jobject["msg"].ToString()); } #endregion //保存最后更新时间 if (ssss != null) { ssss.Updatetime = end; } else { ssss = new SysUpdatetime(); ssss.Updatetime = end; ssss.Updatename = "getCustomers"; } resultEntity = _liaotianService.saveSysUpdatetime(ssss); if (!resultEntity.Result) { throw new Exception("保存更新时间出错!"); } // scope.Complete(); //} } } }