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 zhengcaioaContext _context;
|
private readonly IMapper _mapper;
|
public TimerGetShopUsersService(ILogger<TimerGetShopUsersService> logger, IServiceScopeFactory factory)
|
{
|
_logger = logger;
|
_configuration = factory.CreateScope().ServiceProvider.GetRequiredService<IConfiguration>();
|
_liaotianService = factory.CreateScope().ServiceProvider.GetRequiredService<ILiaotianService>();
|
_clientFactory = factory.CreateScope().ServiceProvider.GetRequiredService<IHttpClientFactory>();
|
_cooperatecustomCustomerService = factory.CreateScope().ServiceProvider.GetRequiredService<ICooperatecustomCustomerService>();
|
_context = factory.CreateScope().ServiceProvider.GetRequiredService<zhengcaioaContext>();
|
_mapper = factory.CreateScope().ServiceProvider.GetRequiredService<IMapper>(); ;
|
}
|
|
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
|
{
|
_logger.LogInformation("TimerGetShopUsersService is starting.");
|
|
//stoppingToken.Register(() => File.Create($"E:\\dotnetCore\\Practice\\Practice\\{DateTime.Now.Millisecond}.txt"));
|
|
DateTime datenow = DateTime.Now;
|
while (!stoppingToken.IsCancellationRequested)
|
{
|
_logger.LogInformation("TimerGetShopUsersService 开始执行");
|
_logger.LogInformation(datenow.ToString("yyyy-MM-dd HH:mm:ss"));
|
if (DateTime.Now.Hour == 6)
|
{
|
this.fasongxiaoxi();
|
}
|
|
//每个小时计算一次
|
if (datenow.Hour == DateTime.Now.Hour)
|
//if (true)
|
{
|
|
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()
|
{
|
var startdate = DateTime.Now.AddMonths(-3);
|
|
var projects =_context.Projects.Where(x => x.RecStatus == "A" && x.StartTime >= startdate).ToList();
|
var projiectid = new List<string>();
|
foreach(var project in projects)
|
{
|
projiectid.Add(project.Id);
|
}
|
var projectzhongbiaos = _context.Projectzhongbiaos.Where(x => projiectid.Contains(x.ProjectId)).ToList();
|
|
var projectreasons = _context.Projectreasons.Where(x => projiectid.Contains(x.ProjectId)).ToList();
|
|
var projectyouxiaos = _context.Projectyouxiaos.Where(x => projiectid.Contains(x.ProjectId)).ToList();
|
|
//业务经理 400-028-8080
|
var Ywjl = _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" && x.IsYwjl == "A").ToList();
|
|
//是否发送了消息
|
var projectfasongxiaoxis = _context.Projectfasongxiaoxis.Where(x => projiectid.Contains(x.ProjectId)).ToList();
|
|
|
var intentionCustomers = _context.IntentionCustomers.Where(x => x.RecStatus == "A").ToList();
|
|
var cooperatecustomCustomers = _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A").ToList();
|
|
//StringBuilder number = new StringBuilder(); ;
|
//if (result != null && result.Count > 0)
|
//{
|
// for (int i = 0; i < result.Count; i++)
|
// {
|
// number.Append(result[i].Lianxidianhua);
|
// customename += result[i].Xingming + ",";
|
// if (i != result.Count - 1)
|
// {
|
// number.Append(",");
|
// }
|
// }
|
//}
|
//else
|
//{
|
// resultEntity.Result = false;
|
// resultEntity.Message = "无联系人";
|
//}
|
//string sss = SMSHelper.PushWToUserMES(number.ToString(), neirong);
|
//if (int.Parse(sss) <= 0)
|
//{
|
// resultEntity.Result = false;
|
// resultEntity.Message = "短信发送失败";
|
// return new JsonResult(resultEntity);
|
//}
|
|
//_logger.LogInformation(curentuser.UserName + "发送短信给客户" + customename);
|
|
#region 没有通过资格审查和符合审查：
|
//政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，
|
//杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询： 。
|
|
try
|
{
|
|
var fbprojects = projects.Where(x => x.Fblx != null).ToList();
|
var fbprojiectid = new List<string>();
|
foreach (var project in fbprojects)
|
{
|
fbprojiectid.Add(project.Id);
|
}
|
var fbprojectzhongbiaos = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
var fbprojectreasons = _context.Projectreasons.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
var fbprojectyouxiaos = _context.Projectyouxiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
|
var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();
|
|
var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();
|
|
|
foreach (var project1 in fbprojects)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
|
var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiappDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
foreach (var project1 in fbprojectzhongbiaos)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "1";
|
projectfasongxiaoxiDTO.Khname = project1.Names;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
|
var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "1";
|
projectfasongxiaoxiDTO.Khname = project1.Names;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
foreach (var project1 in fbprojectyouxiaos)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "4";
|
projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "4";
|
projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
foreach (var project1 in fbprojectreasons)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "5";
|
projectfasongxiaoxiDTO.Khname = project1.Reasonname;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "1" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "1";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "5";
|
projectfasongxiaoxiDTO.Khname = project1.Reasonname;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = fbprojects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
//查询需要发送短信的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
//查询需要发送App消息的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
|
//推送App
|
foreach (var ywjl in Ywjl)
|
{
|
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司的“标书预评审”服务\","
|
+ "\"content\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：" + ywjl.Phone + " \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：" + ywjl.Phone + " \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
|
}
|
|
|
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司的“标书预评审”服务\","
|
+ "\"content\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：400-028-8080 \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：400-028-8080 \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation("无业务经理推送app给客户" + customename);
|
}
|
|
|
|
}
|
|
|
|
//发送短信
|
foreach (var ywjl in Ywjl)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j*1000<= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if(countt> projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i+j-1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：" + ywjl.Phone);
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
|
}
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司的“标书预评审”服务，由3位退休资深评审专家在开标前按照评标流程为您交叉检查标书，杜绝废标 、帮助您得到全部综合评审得分，经政采咨询公司检查过的标书，不可能被废标，详情请咨询：400-028-8080");
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation("无客户经理发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
}
|
}
|
|
|
|
|
}
|
catch (Exception ex)
|
{
|
_logger.LogInformation(ex.ToString());
|
}
|
|
#endregion
|
|
|
|
#region 第2名、第3名与第一名分差3分以内，推送给第2名和第3名：
|
//APP
|
//政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，
|
//如果您在参加“ 项目名称 ”投标前找政采咨询检查标书，至少提升评审得分5 - 8分，也许中标的就是贵公司。了解详情请咨询： 。
|
//短信
|
//政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，
|
//至少为您提升评审得分5 - 8分，您最近未中的标都可以中！了解详情请咨询：
|
|
try
|
{
|
|
var fbprojects = projects.Where(x=>x.DrhxDefen !=null && x.DshxDefen !=null).ToList();
|
var fbprojiectid = new List<string>();
|
foreach (var project in fbprojects)
|
{
|
fbprojiectid.Add(project.Id);
|
}
|
var fbprojectzhongbiaos = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
|
var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();
|
|
var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();
|
|
|
foreach (var project1 in fbprojects)
|
{
|
if (project1.DrhxDefen.HasValue)
|
{
|
var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DrhxDefen <= 3).FirstOrDefault();
|
if (projectzhongbiaos1 != null)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "2";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiappDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "2";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
|
}
|
}
|
|
|
|
|
if (project1.DshxDefen.HasValue)
|
{
|
var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DshxDefen <= 3).FirstOrDefault();
|
if (projectzhongbiaos1 != null)
|
{
|
var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "2";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
|
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "2" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "2";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
}
|
|
}
|
|
//查询需要发送短信的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
//查询需要发送App消息的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
|
//推送App
|
foreach (var ywjl in Ywjl)
|
{
|
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
|
|
for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++)
|
{
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
|
+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：" + ywjl.Phone + " \","
|
+ "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\","
|
+ "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：" + ywjl.Phone + " \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
|
if (isOK.IndexOf(projectfasongxiaoxisywjl[i].Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
_logger.LogInformation(ywjl.UserName + "推送app给客户" + projectfasongxiaoxisywjl[i].Khname);
|
|
}
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
|
for (int i = 0; i < projectfasongxiaoxisywjl.Count; i++)
|
{
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
|
+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：400-028-8080 \","
|
+ "\"getui_alias\": \"" + projectfasongxiaoxisywjl[i].Tel + "\","
|
+ "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，如果您在参加“" + projectfasongxiaoxisywjl[i].Projectname + "”投标前找政采咨询检查标书，至少提升评审得分5-8分，也许中标的就是贵公司。了解详情请咨询：400-028-8080 \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
|
if (isOK.IndexOf(projectfasongxiaoxisywjl[i].Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoxisywjl[i].ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoxisywjl[i].Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoxisywjl[i].Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoxisywjl[i].Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoxisywjl[i].Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
_logger.LogInformation( "无业务经理推送app给客户" + projectfasongxiaoxisywjl[i].Khname);
|
|
}
|
|
}
|
|
|
|
//发送短信
|
foreach (var ywjl in Ywjl)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少为您提升评审得分5-8分，您最近未中的标都可以中！了解详情请咨询：" + ywjl.Phone);
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
|
}
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少为您提升评审得分5-8分，您最近未中的标都可以中！了解详情请咨询：400-028-8080");
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation("无客户经理发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
}
|
}
|
|
}
|
catch (Exception ex)
|
{
|
_logger.LogInformation(ex.ToString());
|
}
|
|
#endregion
|
|
|
#region 第2名与第一名分差5分以内，推送给第2名：
|
//政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，
|
//让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：
|
|
try
|
{
|
|
var fbprojects = projects.Where(x => x.DrhxDefen != null).ToList();
|
var fbprojiectid = new List<string>();
|
foreach (var project in fbprojects)
|
{
|
fbprojiectid.Add(project.Id);
|
}
|
var fbprojectzhongbiaos = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
|
var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();
|
|
var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();
|
|
|
foreach (var project1 in fbprojects)
|
{
|
if (project1.DrhxDefen.HasValue)
|
{
|
var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DrhxDefen >3 && x.Defen - project1.DrhxDefen <= 5).FirstOrDefault();
|
if (projectzhongbiaos1 != null)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "3" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "3";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "3" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiappDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "3";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
|
}
|
}
|
|
|
|
|
|
}
|
|
//查询需要发送短信的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
//查询需要发送App消息的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
|
//推送App
|
foreach (var ywjl in Ywjl)
|
{
|
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
|
+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：" + ywjl.Phone + " \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：" + ywjl.Phone + " \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
|
}
|
|
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
|
+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：400-028-8080 \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：400-028-8080 \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation( "无业务经理推送app给客户" + customename);
|
}
|
|
}
|
|
|
|
//发送短信
|
foreach (var ywjl in Ywjl)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：" + ywjl.Phone);
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
|
}
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让评审专家找不出主观方案扣分理由，至少助您提升综合评审得分5-10分。了解详情请咨询：400-028-8080");
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation("无客户经理发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
}
|
}
|
|
}
|
catch (Exception ex)
|
{
|
_logger.LogInformation(ex.ToString());
|
}
|
|
|
#endregion
|
#region 第2名与第一名分差10分以内，推送给第2名：
|
//政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，
|
//让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询： 。
|
try
|
{
|
|
var fbprojects = projects.Where(x => x.DrhxDefen != null).ToList();
|
var fbprojiectid = new List<string>();
|
foreach (var project in fbprojects)
|
{
|
fbprojiectid.Add(project.Id);
|
}
|
var fbprojectzhongbiaos = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
|
var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();
|
|
var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();
|
|
|
foreach (var project1 in fbprojects)
|
{
|
if (project1.DrhxDefen.HasValue)
|
{
|
var projectzhongbiaos1 = fbprojectzhongbiaos.Where(x => x.ProjectId == project1.Id && x.Defen != null && x.Defen - project1.DrhxDefen > 5 && x.Defen - project1.DrhxDefen <= 10).FirstOrDefault();
|
if (projectzhongbiaos1 != null)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "4" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "4";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "4" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiappDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "4";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
|
}
|
}
|
}
|
|
//查询需要发送短信的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
//查询需要发送App消息的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
|
//推送App
|
foreach (var ywjl in Ywjl)
|
{
|
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
|
+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：" + ywjl.Phone + " \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：" + ywjl.Phone + " \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
|
}
|
|
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业“标书检查”、“标书指导”\","
|
+ "\"content\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：400-028-8080 \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：400-028-8080 \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation("无业务经理推送app给客户" + customename);
|
}
|
|
}
|
|
|
|
//发送短信
|
foreach (var ywjl in Ywjl)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：" + ywjl.Phone);
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
|
}
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业“标书检查”、“标书指导”，退休资深评审专家在开标前按照评标流程为您交叉检查、指导标书，让您得齐全部客观分和主观分，从此不再为标书制作操心。了解详情请咨询：400-028-8080");
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation("无客户经理发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
}
|
}
|
|
}
|
catch (Exception ex)
|
{
|
_logger.LogInformation(ex.ToString());
|
}
|
#endregion
|
|
#region 质疑投诉未或支持：
|
//政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，
|
//花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：
|
|
try
|
{
|
|
var fbprojectsDehxZhiyichengli = projects.Where(x => x.DehxZhiyichengli == "D").ToList();
|
var fbprojectsDehxTousuchengli = projects.Where(x => x.DehxTousuchengli == "D").ToList();
|
|
var fbprojectsDshxZhiyichengli = projects.Where(x => x.DshxZhiyichengli == "D").ToList();
|
var fbprojectsDshxTousuchengli = projects.Where(x => x.DshxTousuchengli == "D").ToList();
|
|
|
|
var fbprojiectid = new List<string>();
|
foreach (var project in projects)
|
{
|
fbprojiectid.Add(project.Id);
|
}
|
var fbprojectzhongbiaos = _context.Projectzhongbiaos.Where(x => fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
|
|
var fbprojectzhongbiaosZbZhiyichengli = _context.Projectzhongbiaos.Where(x => x.ZbZhiyichengli == "D" && fbprojiectid.Contains(x.ProjectId) ).ToList();
|
var fbprojectzhongbiaosZbTousuchengli = _context.Projectzhongbiaos.Where(x => x.ZbTousuchengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
var fbprojectreasonsWxZhiyichengli = _context.Projectreasons.Where(x => x.WxZhiyichengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList();
|
var fbprojectreasonsWxTousuchengli = _context.Projectreasons.Where(x => x.WxTousuchengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
var fbprojectyouxiaosYxZhiyichengli = _context.Projectyouxiaos.Where(x => x.YxZhiyichengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList();
|
var fbprojectyouxiaosYxTousuchengli = _context.Projectyouxiaos.Where(x => x.YxTousuchengli == "D" && fbprojiectid.Contains(x.ProjectId)).ToList();
|
|
var projectfasongxiaoxiDTOsduanxin = new List<ProjectfasongxiaoxiDTO>();
|
|
var projectfasongxiaoxiDTOsapp = new List<ProjectfasongxiaoxiDTO>();
|
|
|
foreach (var project1 in fbprojectsDehxZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiappDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
foreach (var project1 in fbprojectsDehxTousuchengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
var projectfasongxiaoxiappDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Drhx && x.Gyszl == "2").FirstOrDefault();
|
if (projectfasongxiaoxiappDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "2";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
foreach (var project1 in fbprojectsDshxZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
foreach (var project1 in fbprojectsDshxZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = project1.Drhx;
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.Id && x.ProjectmingxiId == null && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Dshx && x.Gyszl == "3").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.Id;
|
projectfasongxiaoxiDTO.ProjectmingxiId = null;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "3";
|
projectfasongxiaoxiDTO.Khname = project1.Drhx;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
projectfasongxiaoxiDTO.Projectname = project1.Name;
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
foreach (var project1 in fbprojectzhongbiaosZbZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "1";
|
projectfasongxiaoxiDTO.Khname = project1.Names;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "1";
|
projectfasongxiaoxiDTO.Khname = project1.Names;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
foreach (var project1 in fbprojectzhongbiaosZbZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "1";
|
projectfasongxiaoxiDTO.Khname = project1.Names;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ZhongbiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Names && x.Gyszl == "1").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ZhongbiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "1";
|
projectfasongxiaoxiDTO.Khname = project1.Names;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
|
|
|
|
|
|
|
|
foreach (var project1 in fbprojectyouxiaosYxZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "4";
|
projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "4";
|
projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
foreach (var project1 in fbprojectyouxiaosYxTousuchengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "4";
|
projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.YouxiaoId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Namesyouxiao && x.Gyszl == "4").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.YouxiaoId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "4";
|
projectfasongxiaoxiDTO.Khname = project1.Namesyouxiao;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
|
foreach (var project1 in fbprojectreasonsWxZhiyichengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "5";
|
projectfasongxiaoxiDTO.Khname = project1.Reasonname;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "5" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "5";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "5";
|
projectfasongxiaoxiDTO.Khname = project1.Reasonname;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
foreach (var project1 in fbprojectreasonsWxTousuchengli)
|
{
|
var projectfasongxiaoxiduanxinDrhx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "duanxin" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
|
if (projectfasongxiaoxiduanxinDrhx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "duanxin";
|
projectfasongxiaoxiDTO.Gyszl = "5";
|
projectfasongxiaoxiDTO.Khname = project1.Reasonname;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsduanxin.Add(projectfasongxiaoxiDTO);
|
}
|
|
var projectfasongxiaoxiappDshx = projectfasongxiaoxis.Where(x => x.ProjectId == project1.ProjectId && x.ProjectmingxiId == project1.ReasonId && x.Xiaoxileixing == "6" && x.Xiaoxizhonglei == "app" && x.Khname == project1.Reasonname && x.Gyszl == "5").FirstOrDefault();
|
if (projectfasongxiaoxiappDshx == null)
|
{
|
var projectfasongxiaoxiDTO = new ProjectfasongxiaoxiDTO();
|
projectfasongxiaoxiDTO.ProjectId = project1.ProjectId;
|
projectfasongxiaoxiDTO.ProjectmingxiId = project1.ReasonId;
|
projectfasongxiaoxiDTO.Xiaoxileixing = "6";
|
projectfasongxiaoxiDTO.Xiaoxizhonglei = "app";
|
projectfasongxiaoxiDTO.Gyszl = "5";
|
projectfasongxiaoxiDTO.Khname = project1.Reasonname;
|
projectfasongxiaoxiDTO.RecStatus = "A";
|
projectfasongxiaoxiDTO.Createtime = DateTime.Now;
|
var project = projects.Where(x => x.Id == project1.ProjectId).FirstOrDefault();
|
if (project != null)
|
{
|
projectfasongxiaoxiDTO.Projectname = project.Name;
|
}
|
projectfasongxiaoxiDTOsapp.Add(projectfasongxiaoxiDTO);
|
}
|
}
|
|
//查询需要发送短信的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsduanxin)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
//查询需要发送App消息的客户
|
foreach (var projectfasongxiaoxiDTO1 in projectfasongxiaoxiDTOsapp)
|
{
|
var intentionCustomer = intentionCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
if (intentionCustomer == null)
|
{
|
var cooperatecustomCustomer = cooperatecustomCustomers.Where(x => x.RecStatus == "A" && x.Name == projectfasongxiaoxiDTO1.Khname).FirstOrDefault();
|
|
if (cooperatecustomCustomer != null)
|
{
|
if (!String.IsNullOrWhiteSpace(cooperatecustomCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = cooperatecustomCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = cooperatecustomCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = cooperatecustomCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = cooperatecustomCustomer.HuiyuanId;
|
|
}
|
}
|
else
|
{
|
if (!String.IsNullOrWhiteSpace(intentionCustomer.Phone))
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Phone;
|
}
|
else
|
{
|
projectfasongxiaoxiDTO1.Tel = intentionCustomer.Tel;
|
}
|
projectfasongxiaoxiDTO1.Ywjl = intentionCustomer.Ywjl;
|
projectfasongxiaoxiDTO1.KhId = intentionCustomer.Id;
|
projectfasongxiaoxiDTO1.HuiyuanId = intentionCustomer.HuiyuanId;
|
}
|
}
|
|
|
//推送App
|
foreach (var ywjl in Ywjl)
|
{
|
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书\","
|
+ "\"content\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：" + ywjl.Phone + " \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：" + ywjl.Phone + " \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation(ywjl.UserName + "推送app给客户" + customename);
|
}
|
|
|
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsapp.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += "\"" + projectfasongxiaoxisywjl[i + j - 1].Tel + "\",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
string conment = "{"
|
+ "\"title\": \"政采咨询公司专业为供应商代拟质疑函、投诉书\","
|
+ "\"content\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：400-028-8080 \","
|
+ "\"getui_alias\": [" + numberstring + "],"
|
+ "\"payload\": {\"text\": \"政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：400-028-8080 \"},"
|
+ "\"force_notification\": true"
|
+ "}";
|
|
string result2 = SMSHelper.PushApp(conment);
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
var isOK = jobjectresult["isOK"].ToString();
|
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
if (isOK.IndexOf(projectfasongxiaoDTO.Tel) >= 0)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
}
|
_context.SaveChanges();
|
}
|
|
|
|
_logger.LogInformation("无业务经理推送app给客户" + customename);
|
}
|
|
|
|
}
|
|
|
|
//发送短信
|
foreach (var ywjl in Ywjl)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == ywjl.Id && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：" + ywjl.Phone);
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation(ywjl.UserName + "发送短信给客户" + customename);
|
}
|
}
|
|
|
|
|
|
}
|
|
}
|
//业务经理为空
|
if (true)
|
{
|
var projectfasongxiaoxisywjl = projectfasongxiaoxiDTOsduanxin.Where(x => x.Ywjl == null && x.Tel != null && x.Tel.StartsWith("1")).ToList();
|
if (projectfasongxiaoxisywjl.Count >= 100)
|
{
|
int j = 0;
|
while (j * 1000 <= projectfasongxiaoxisywjl.Count)
|
{
|
j = j + 1;
|
string numberstring = "";
|
string customename = "";
|
if (projectfasongxiaoxisywjl != null && projectfasongxiaoxisywjl.Count > 0)
|
{
|
int countt = (j * 1000);
|
if (countt > projectfasongxiaoxisywjl.Count)
|
{
|
countt = projectfasongxiaoxisywjl.Count;
|
}
|
for (int i = 0; i < countt; i++)
|
{
|
if (numberstring.IndexOf(projectfasongxiaoxisywjl[i + j - 1].Tel) >= 0)
|
{
|
continue;
|
}
|
numberstring += projectfasongxiaoxisywjl[i + j - 1].Tel + ",";
|
customename += projectfasongxiaoxisywjl[i + j - 1].Khname + ",";
|
|
}
|
}
|
if (numberstring.EndsWith(","))
|
{
|
numberstring = numberstring.Substring(0, numberstring.Length - 1);
|
}
|
|
if (numberstring.Split(',').Length >= 100)
|
{
|
string sss = SMSHelper.PushWToUserMES(numberstring, "政采咨询公司专业为供应商代拟质疑函、投诉书，资深政府采购法律专家、3000多件质疑投诉成功案例，找政采咨询，花钱更少、胜算更高，接受推风险代理，质疑投诉成功再收费。了解详情请咨询：400-028-8080");
|
if (int.Parse(sss) >= 0)
|
{
|
foreach (var projectfasongxiaoDTO in projectfasongxiaoxisywjl)
|
{
|
var projectfasongxiaoxi = new Projectfasongxiaoxi();
|
projectfasongxiaoxi.Id = Guid.NewGuid().ToString();
|
projectfasongxiaoxi.ProjectId = projectfasongxiaoDTO.ProjectId;
|
projectfasongxiaoxi.ProjectmingxiId = projectfasongxiaoDTO.ProjectmingxiId;
|
projectfasongxiaoxi.Xiaoxileixing = projectfasongxiaoDTO.Xiaoxileixing;
|
projectfasongxiaoxi.Xiaoxizhonglei = projectfasongxiaoDTO.Xiaoxizhonglei;
|
projectfasongxiaoxi.Gyszl = projectfasongxiaoDTO.Gyszl;
|
projectfasongxiaoxi.Khname = projectfasongxiaoDTO.Khname;
|
projectfasongxiaoxi.RecStatus = "A";
|
projectfasongxiaoxi.Createtime = DateTime.Now;
|
_context.Projectfasongxiaoxis.Add(projectfasongxiaoxi);
|
}
|
_context.SaveChanges();
|
}
|
_logger.LogInformation("无客户经理发送短信给客户" + customename);
|
}
|
}
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
_logger.LogInformation(ex.ToString());
|
}
|
#endregion
|
|
|
}
|
|
public async Task huoquhuiyuanAsync()
|
{
|
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);
|
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);
|
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);
|
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);
|
if (!resultEntity.Result)
|
{
|
throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错！");
|
}
|
}
|
else
|
{
|
cooperatecustomCustomerDTO.HuiyuanId = hit["ID"].ToString();
|
resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO);
|
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();
|
//}
|
|
|
|
|
|
|
|
}
|
}
|
}
|
