using System.Collections.Generic; using System.Linq; using System.Text; using AutoMapper; using AngleSharp.Html.Parser; using DTO; using IServices; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Microsoft.Bot.Builder.Integration.AspNet.Core; using Microsoft.Extensions.Logging; using Newtonsoft.Json; using System.Net.Http; using System.Threading.Tasks; using zhengcaioa.Models; using zhengcaioa.IService; using CommonToolsCore; using Services; using System.IO; using Microsoft.AspNetCore.Hosting; using Grpc.Core; using System; using System.Transactions; using Microsoft.Extensions.Configuration; using Newtonsoft.Json.Linq; using System.Net.Http.Headers; namespace zhengcaioa.Controllers.Finance { [CheckLogin] public class TongjiBaoBiaoController : Controller { private readonly ILogger _logger; private readonly IAdmAttendanceRuleService _attendanceRuleService; private readonly IUserService _userService; private readonly IAdmSigninService _signinService; private readonly IAdmAttendanceService _admAttendanceService; private readonly IAdmAttendanceDtlService _admAttendanceDtlService; private readonly IHrSalaryService _hrSalaryService; private readonly IHrJibengongziService _JibengongziService; private readonly ISimService _simService; private readonly IDailyManagementService _DailyManageService; private readonly IAdmBreakPrecedentService _admBreakPrecedentService; private readonly IHrJixiaotichengService _hrJixiaotichengService; private readonly IFiPiecerateService _fiPiecerateService; private readonly IAdmPieceCheckService _admPieceCheckService; private readonly ICooperOrderService _cooperOrderService; private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService; private readonly IGroupTopicService _groupTopicService; private readonly ICooperVisitService _cooperVisitService; private readonly IIntentionCustomerService _intentionCustomerService; private readonly IIntentionVisitService _intentionVisitService; private readonly IDtChannelArticleNewsService _dtChannelArticleNewsService; private readonly IProjectService _projectService; private readonly ICusFangwenjiluService _cusFangwenjiluService; private readonly ILiaotianService _liaotianService; private readonly IConfiguration _configuration; private readonly IHttpClientFactory _clientFactory; private readonly IHrPositionService _hrPositionService; private readonly IHrDeptService _hrDeptService; private readonly IAdmSigninService _admSigninService; private readonly IExpertService _expertService; public TongjiBaoBiaoController(ILogger logger , IAdmAttendanceRuleService attendanceRuleService , IUserService userService , IAdmSigninService signinService , IAdmAttendanceService admAttendanceService , IAdmAttendanceDtlService admAttendanceDtlService , IHrSalaryService hrSalaryService , IHrJibengongziService JibengongziService , ISimService simService , IDailyManagementService DailyManageService , IAdmBreakPrecedentService admBreakPrecedentService , IHrJixiaotichengService hrJixiaotichengService , IFiPiecerateService fiPiecerateService , IAdmPieceCheckService admPieceCheckService , ICooperOrderService cooperOrderService , ICooperatecustomCustomerService cooperatecustomCustomerService , IGroupTopicService groupTopicService , ICooperVisitService cooperVisitService , IIntentionCustomerService intentionCustomerService , IIntentionVisitService intentionVisitService , IDtChannelArticleNewsService dtChannelArticleNewsService , IProjectService projectService , ICusFangwenjiluService cusFangwenjiluService , ILiaotianService liaotianService , IConfiguration configuration , IHttpClientFactory clientFactory , IHrPositionService hrPositionService , IHrDeptService hrDeptService , IAdmSigninService admSigninService , IExpertService expertService ) { _logger = logger; _attendanceRuleService = attendanceRuleService; _userService = userService; _signinService = signinService; _admAttendanceService = admAttendanceService; _admAttendanceDtlService = admAttendanceDtlService; _hrSalaryService = hrSalaryService; _JibengongziService = JibengongziService; _simService = simService; _DailyManageService = DailyManageService; _admBreakPrecedentService = admBreakPrecedentService; _hrJixiaotichengService = hrJixiaotichengService; _fiPiecerateService = fiPiecerateService; _admPieceCheckService = admPieceCheckService; _cooperOrderService = cooperOrderService; _cooperatecustomCustomerService = cooperatecustomCustomerService; _groupTopicService = groupTopicService; _cooperVisitService = cooperVisitService; _intentionCustomerService = intentionCustomerService; _intentionVisitService = intentionVisitService; _dtChannelArticleNewsService = dtChannelArticleNewsService; _projectService = projectService; _cusFangwenjiluService = cusFangwenjiluService; _liaotianService = liaotianService; _configuration = configuration; _clientFactory = clientFactory; _hrPositionService = hrPositionService; _hrDeptService = hrDeptService; _admSigninService = admSigninService; _expertService = expertService; } public async Task IndexAsync(string Tongjitime="") { var curentuser = JsonConvert.DeserializeObject(HttpContext.Session.GetString("User")); ViewData["curentuser"] = curentuser; DateTime chauxnshijian = DateTime.Now; if (!string.IsNullOrEmpty(Tongjitime)) { DateTime.TryParse(Tongjitime,out chauxnshijian); } DateTime dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1); int Yingchuqin = 0; int Offdays = 0; //是否上班日期 AdmAttendanceRuleDTO admAttendanceRuleDTO = _attendanceRuleService.Get(""); var admAttendanceRulesDtlDTOs = _attendanceRuleService.GetDtlList(""); var jiejiari = admAttendanceRulesDtlDTOs.Where(x => x.Name == "jiejiari").ToList(); var tiaoxiuri = admAttendanceRulesDtlDTOs.Where(x => x.Name == "tiaoxiuri").ToList(); List fiPiecerateDTOs = _fiPiecerateService.GetList(); List hrJixiaotichengDTOs = _hrJixiaotichengService.GetList().Where(x => x.Effecttime < datemaxkaoqin).ToList(); var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == curentuser.HrPosition).ToList(); //计算每月工作日 while (dateminkaoqin < datemaxkaoqin) { _logger.LogInformation("dateminkaoqin " + dateminkaoqin); //bool iswork = false; if ((int)dateminkaoqin.DayOfWeek >= admAttendanceRuleDTO.WeekStart && (int)dateminkaoqin.DayOfWeek <= admAttendanceRuleDTO.WeekEnd) { //是否节假日 if (jiejiari.Exists(x => x.ValueStart <= dateminkaoqin && x.ValueEnd >= dateminkaoqin)) { Offdays += 1; } else { Yingchuqin += 1; //iswork = true; } } else { //是否调休日 调休日需要上班 if (tiaoxiuri.Exists(x => x.ValueStart <= dateminkaoqin.Date && x.ValueEnd >= dateminkaoqin.Date)) { Yingchuqin += 1; //iswork = true; } else { Offdays += 1; } } dateminkaoqin = dateminkaoqin.AddDays(1); } dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); List tuiguangDTOs = new List(); #region 采购项目录入 TongjiBaoBiaoDTO xiangmuDTO = new TongjiBaoBiaoDTO(); xiangmuDTO.gongzuo = "采购项目录入"; //本月数量 var projectDTOsyue = _projectService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString(); //本日数量 var projectDTOsri = projectDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); xiangmuDTO.benrishuliang = projectDTOsri.Count.ToString(); var jijianixiangmu = fiPiecerateDTOs.Where(x => x.Project == "采购项目录入").FirstOrDefault(); if (jijianixiangmu != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangmu.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 xiangmuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 xiangmuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = projectDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xiangmuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 xiangmuDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if(projectDTOsyue.Count > 0 || projectDTOsri.Count > 0 ) tuiguangDTOs.Add(xiangmuDTO); #endregion #region 采购公告录入 TongjiBaoBiaoDTO caigougonggaoDTO = new TongjiBaoBiaoDTO(); caigougonggaoDTO.gongzuo = "采购公告录入"; //本月数量 var caigougonggaoDTOsyue = _projectService.GetcaigougonggaoListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); caigougonggaoDTO.benyueshuliang = caigougonggaoDTOsyue.Count.ToString(); //本日数量 var caigougonggaoDTOsri = caigougonggaoDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); caigougonggaoDTO.benrishuliang = caigougonggaoDTOsri.Count.ToString(); var jijianicaigougonggao = fiPiecerateDTOs.Where(x => x.Project == "采购公告录入").FirstOrDefault(); if (jijianicaigougonggao != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianicaigougonggao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 caigougonggaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 caigougonggaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = caigougonggaoDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { caigougonggaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 caigougonggaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (caigougonggaoDTOsyue.Count > 0 || caigougonggaoDTOsri.Count > 0) tuiguangDTOs.Add(caigougonggaoDTO); #endregion #region 客户资料录入 TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO(); kehuluruDTO.gongzuo = "客户资料录入"; //本月数量 var intentionCustomerDTOsyue = _intentionCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); kehuluruDTO.benyueshuliang = intentionCustomerDTOsyue.Count .ToString(); //本日数量 var intentionCustomerDTOsri = intentionCustomerDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); kehuluruDTO.benrishuliang = intentionCustomerDTOsri.Count.ToString(); var jijianikehuluru = fiPiecerateDTOs.Where(x => x.Project == "客户资料录入").FirstOrDefault(); if (jijianikehuluru != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianikehuluru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { kehuluruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); kehuluruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionCustomerDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { kehuluruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { kehuluruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (intentionCustomerDTOsyue.Count > 0 || intentionCustomerDTOsri.Count > 0) tuiguangDTOs.Add(kehuluruDTO); #endregion #region 新加群组 TongjiBaoBiaoDTO qunzuDTO = new TongjiBaoBiaoDTO(); qunzuDTO.gongzuo = "新加群组"; //本月数量 var groupTopicDTOsyue = _groupTopicService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); qunzuDTO.benyueshuliang = groupTopicDTOsyue.Count.ToString(); //本日数量 var groupTopicDTOsri = groupTopicDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); qunzuDTO.benrishuliang = groupTopicDTOsri.Count.ToString(); var jijianixianggroupTopic = fiPiecerateDTOs.Where(x => x.Project == "新加群组").FirstOrDefault(); if (jijianixianggroupTopic != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixianggroupTopic.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 qunzuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 qunzuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { qunzuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 qunzuDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (groupTopicDTOsyue.Count > 0 || groupTopicDTOsri.Count > 0) tuiguangDTOs.Add(qunzuDTO); #endregion #region 电话推广 TongjiBaoBiaoDTO dianhuatuiguangDTO = new TongjiBaoBiaoDTO(); dianhuatuiguangDTO.gongzuo = "电话推广"; //本月数量 var intentionVisitDTOsyue = _intentionVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "01").ToList(); dianhuatuiguangDTO.benyueshuliang = intentionVisitDTOsyue.Count.ToString(); //本日数量 var intentionVisitDTOsri = intentionVisitDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList(); dianhuatuiguangDTO.benrishuliang = intentionVisitDTOsri.Count.ToString(); var jijianixiangdianhuatuiguang = fiPiecerateDTOs.Where(x => x.Project == "电话推广").FirstOrDefault(); if (jijianixiangdianhuatuiguang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangdianhuatuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 dianhuatuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 dianhuatuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { dianhuatuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 dianhuatuiguangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (intentionVisitDTOsyue.Count > 0 || intentionVisitDTOsri.Count > 0) tuiguangDTOs.Add(dianhuatuiguangDTO); #endregion #region 添加微信客户 TongjiBaoBiaoDTO weixnDTO = new TongjiBaoBiaoDTO(); weixnDTO.gongzuo = "添加微信客户"; //本月数量 var cooperweixinDTOsyue = _cooperatecustomCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin); var intentionweixinDTOsyue = _intentionCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin); weixnDTO.benyueshuliang = (cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count).ToString(); //本日数量 var cooperweixinDTOsri = cooperweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList(); var intentionweixinDTOsri = intentionweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList(); weixnDTO.benrishuliang = (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count).ToString(); var jijianiweixn = fiPiecerateDTOs.Where(x => x.Project == "添加微信客户").FirstOrDefault(); if (jijianiweixn != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiweixn.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { weixnDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); weixnDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsyue.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { weixnDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { weixnDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if ((cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count) > 0 || (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count) > 0) tuiguangDTOs.Add(weixnDTO); #endregion #region 群发短信 TongjiBaoBiaoDTO duanxinDTO = new TongjiBaoBiaoDTO(); duanxinDTO.gongzuo = "群发短信"; //本月数量 var duanxinsyue = _cusFangwenjiluService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "01").ToList(); duanxinDTO.benyueshuliang = duanxinsyue.Count.ToString(); //本日数量 var duanxinsri = duanxinsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); duanxinDTO.benrishuliang = duanxinsri.Count.ToString(); var jijianiduanxin = fiPiecerateDTOs.Where(x => x.Project == "群发短信").FirstOrDefault(); if (jijianiduanxin != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiduanxin.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { duanxinDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); duanxinDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = duanxinsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { duanxinDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { duanxinDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (duanxinsyue.Count > 0 || duanxinsri.Count > 0) tuiguangDTOs.Add(duanxinDTO); #endregion #region 商业信函推广 TongjiBaoBiaoDTO xinhanDTO = new TongjiBaoBiaoDTO(); xinhanDTO.gongzuo = "商业信函推广"; var jijianixinhan = fiPiecerateDTOs.Where(x => x.Project == "商业信函推广").FirstOrDefault(); if (jijianixinhan != null) { //本月数量 var xinhansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianixinhan.Id).ToList(); xinhanDTO.benyueshuliang =(xinhansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var xinhansri = xinhansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); xinhanDTO.benrishuliang = (xinhansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); xinhanDTO.dangrijixiao = (xinhansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinhan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinhanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinhanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (xinhansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // xinhanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { xinhanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xinhanDTO.benyueshuliang) > 0 || decimal.Parse(xinhanDTO.benrishuliang) > 0) tuiguangDTOs.Add(xinhanDTO); #endregion #region 群发邮件 TongjiBaoBiaoDTO youjianDTO = new TongjiBaoBiaoDTO(); youjianDTO.gongzuo = "群发邮件"; //本月数量 var youjiansyue = _cusFangwenjiluService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "02").ToList(); youjianDTO.benyueshuliang = youjiansyue.Count.ToString(); //本日数量 var youjiansri = youjiansyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); youjianDTO.benrishuliang = youjiansri.Count.ToString(); var jijianiyoujian = fiPiecerateDTOs.Where(x => x.Project == "群发邮件").FirstOrDefault(); if (jijianiyoujian != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyoujian.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { youjianDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); youjianDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = youjiansri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { youjianDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { youjianDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(youjianDTO.benyueshuliang) > 0 || decimal.Parse(youjianDTO.benrishuliang) > 0) tuiguangDTOs.Add(youjianDTO); #endregion #region 群组推广 TongjiBaoBiaoDTO qunzutuiguangDTO = new TongjiBaoBiaoDTO(); qunzutuiguangDTO.gongzuo = "群组推广"; var jijianiqunzutuiguang = fiPiecerateDTOs.Where(x => x.Project == "群组推广").FirstOrDefault(); if (jijianiqunzutuiguang != null) { //本月数量 var qunzutuiguangsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiqunzutuiguang.Id).ToList(); qunzutuiguangDTO.benyueshuliang = (qunzutuiguangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var qunzutuiguangsri = qunzutuiguangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); qunzutuiguangDTO.benrishuliang = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); qunzutuiguangDTO.dangrijixiao = (qunzutuiguangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqunzutuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { qunzutuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); qunzutuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // qunzutuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { qunzutuiguangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(qunzutuiguangDTO.benyueshuliang) > 0 || decimal.Parse(qunzutuiguangDTO.benrishuliang) > 0) tuiguangDTOs.Add(qunzutuiguangDTO); #endregion #region 朋友圈转发 TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO(); pengyouquanDTO.gongzuo = "朋友圈转发"; var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈转发").FirstOrDefault(); if (jijianipengyouquan != null) { //本月数量 var pengyouquansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianipengyouquan.Id).ToList(); pengyouquanDTO.benyueshuliang = (pengyouquansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var pengyouquansri = pengyouquansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); pengyouquanDTO.benrishuliang = (pengyouquansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); pengyouquanDTO.dangrijixiao = (pengyouquansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianipengyouquan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { pengyouquanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); pengyouquanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (pengyouquansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // pengyouquanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { pengyouquanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } else if (jixiaotichengfangan.Renwustandard == "05") { //本月规定 pengyouquanDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##"); } } } if (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0) tuiguangDTOs.Add(pengyouquanDTO); #endregion #region 论坛推广 TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO(); luntanfatieDTO.gongzuo = "论坛推广"; var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛推广").FirstOrDefault(); if (jijianiluntanfatie != null) { //本月数量 var luntanfatiesyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiluntanfatie.Id).ToList(); luntanfatieDTO.benyueshuliang = (luntanfatiesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var luntanfatiesri = luntanfatiesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); luntanfatieDTO.benrishuliang = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); luntanfatieDTO.dangrijixiao = (luntanfatiesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiluntanfatie.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { luntanfatieDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); luntanfatieDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // luntanfatieDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { luntanfatieDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(luntanfatieDTO.benyueshuliang) > 0 || decimal.Parse(luntanfatieDTO.benrishuliang) > 0) tuiguangDTOs.Add(luntanfatieDTO); #endregion #region 贴吧推广 TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO(); gentiepinglunDTO.gongzuo = "贴吧推广"; var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "贴吧推广").FirstOrDefault(); if (jijianigentiepinglun != null) { //本月数量 var gentiepinglunsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigentiepinglun.Id).ToList(); gentiepinglunDTO.benyueshuliang = (gentiepinglunsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var gentiepinglunsri = gentiepinglunsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); gentiepinglunDTO.benrishuliang = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); gentiepinglunDTO.dangrijixiao = (gentiepinglunsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigentiepinglun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { gentiepinglunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); gentiepinglunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // gentiepinglunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { gentiepinglunDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(gentiepinglunDTO.benyueshuliang) > 0 || decimal.Parse(gentiepinglunDTO.benrishuliang) > 0) tuiguangDTOs.Add(gentiepinglunDTO); #endregion #region 转发微信微博 TongjiBaoBiaoDTO zhuanfaDTO = new TongjiBaoBiaoDTO(); zhuanfaDTO.gongzuo = "转发微信微博"; var jijianizhuanfa = fiPiecerateDTOs.Where(x => x.Project == "转发微信微博").FirstOrDefault(); if (jijianizhuanfa != null) { //本月数量 var zhuanfasyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhuanfa.Id).ToList(); zhuanfaDTO.benyueshuliang = (zhuanfasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhuanfasri = zhuanfasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); zhuanfaDTO.benrishuliang = (zhuanfasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhuanfaDTO.dangrijixiao = (zhuanfasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanfa.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhuanfaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhuanfaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhuanfasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhuanfaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhuanfaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhuanfaDTO.benyueshuliang) > 0 || decimal.Parse(zhuanfaDTO.benrishuliang) > 0) tuiguangDTOs.Add(zhuanfaDTO); #endregion #region 新增意向客户(订单) TongjiBaoBiaoDTO yixiangDTO = new TongjiBaoBiaoDTO(); yixiangDTO.gongzuo = "新增意向客户(订单)"; //本月数量 var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(curentuser.Id, dateminkaoqin, datemaxkaoqin).ToList(); yixiangDTO.benyueshuliang = yixiangsyue.Count.ToString(); //本日数量 var yixiangsri = yixiangsyue.Where(x => x.Yixiangtime >= chauxnshijian.Date && x.Yixiangtime < chauxnshijian.Date.AddDays(1)).ToList(); yixiangDTO.benrishuliang = yixiangsri.Count.ToString(); var jijianiyixiang = fiPiecerateDTOs.Where(x => x.Project == "新增意向客户(订单)").FirstOrDefault(); if (jijianiyixiang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyixiang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { yixiangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); yixiangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = yixiangsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { yixiangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { yixiangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(yixiangDTO.benyueshuliang) > 0 || decimal.Parse(yixiangDTO.benrishuliang) > 0) tuiguangDTOs.Add(yixiangDTO); #endregion #region 新增注册会员 TongjiBaoBiaoDTO zhucehuiyuanDTO = new TongjiBaoBiaoDTO(); zhucehuiyuanDTO.gongzuo = "新增注册会员"; var jijianizhucehuiyuan = fiPiecerateDTOs.Where(x => x.Project == "新增注册会员").FirstOrDefault(); if (jijianizhucehuiyuan != null) { //本月数量 List zhucehuiyuansyue = new List(); try { //var pltUserDTO = _userService.GetPltUserEntity(curentuser.Id); string huiyuanurl = _configuration.GetSection("huiyuanurl").Value; string GetYGYaoQingYonghu = _configuration.GetSection("GetYGYaoQingYonghu").Value; Uri postUrl2 = new Uri(huiyuanurl + GetYGYaoQingYonghu); JObject questions2 = new JObject(); questions2.Add("UserID", curentuser.Id); questions2.Add("StartTime", dateminkaoqin.ToString("yyyy-MM-dd HH:mm:ss")); questions2.Add("EndTime", datemaxkaoqin.ToString("yyyy-MM-dd HH:mm:ss")); string requestJson2 = questions2.ToString(); string result2 = string.Empty; 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 jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") { zhucehuiyuanDTO.benyueshuliang = jobjectresult["count"].ToString(); zhucehuiyuansyue = JsonConvert.DeserializeObject>(jobjectresult["data"].ToString()); } else { zhucehuiyuanDTO.benyueshuliang = "0"; } } catch (Exception ex) { zhucehuiyuanDTO.benyueshuliang = "0"; } //var zhucehuiyuansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhucehuiyuan.Id).ToList(); //zhucehuiyuanDTO.benyueshuliang = (zhucehuiyuansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.CreatTime >= chauxnshijian.Date && x.CreatTime < chauxnshijian.Date.AddDays(1)).ToList(); zhucehuiyuanDTO.benrishuliang = zhucehuiyuansri.Count.ToString(); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhucehuiyuan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhucehuiyuansri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhucehuiyuanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhucehuiyuanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = qianyueDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhucehuiyuanDTO.benyueshuliang) > 0 || decimal.Parse(zhucehuiyuanDTO.benrishuliang) > 0) tuiguangDTOs.Add(zhucehuiyuanDTO); #endregion #region 新增签约客户 TongjiBaoBiaoDTO qianyueDTO = new TongjiBaoBiaoDTO(); qianyueDTO.gongzuo = "新增签约客户"; //本月数量 var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); qianyueDTO.benyueshuliang = qianyueDTOsyue.Count.ToString(); //本日数量 var qianyueDTOsri = qianyueDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); qianyueDTO.benrishuliang = qianyueDTOsri.Count .ToString(); var jijianiqianyue = fiPiecerateDTOs.Where(x => x.Project == "新增签约客户").FirstOrDefault(); if (jijianiqianyue != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqianyue.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { qianyueDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); qianyueDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = qianyueDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { qianyueDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { qianyueDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = qianyueDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0) tuiguangDTOs.Add(qianyueDTO); #endregion #region 专家录入 TongjiBaoBiaoDTO zhuanjialuruDTO = new TongjiBaoBiaoDTO(); zhuanjialuruDTO.gongzuo = "专家录入"; //本月数量 var zhuanjialuruDTOsyue = _expertService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); zhuanjialuruDTO.benyueshuliang = zhuanjialuruDTOsyue.Count.ToString(); //本日数量 var zhuanjialuruDTOsri = zhuanjialuruDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); zhuanjialuruDTO.benrishuliang = zhuanjialuruDTOsri.Count.ToString(); var jijianizhuanjialuru = fiPiecerateDTOs.Where(x => x.Project == "专家录入").FirstOrDefault(); if (jijianizhuanjialuru != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanjialuru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhuanjialuruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhuanjialuruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhuanjialuruDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhuanjialuruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhuanjialuruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (zhuanjialuruDTOsyue.Count > 0 || zhuanjialuruDTOsri.Count > 0) tuiguangDTOs.Add(zhuanjialuruDTO); #endregion List baifangkehuDTOs = new List(); #region 上门拜访客户 TongjiBaoBiaoDTO shangmenbanfangDTO = new TongjiBaoBiaoDTO(); shangmenbanfangDTO.gongzuo = "上门拜访客户"; //本月数量 var shangmenbanfangDTOsyue = _intentionVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); var shangmenbanfangcooperDTOsyue = _cooperVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); shangmenbanfangDTO.benyueshuliang = (shangmenbanfangcooperDTOsyue.Count + shangmenbanfangDTOsyue.Count).ToString(); //本日数量 var shangmenbanfangDTOsri = shangmenbanfangDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList(); var shangmenbanfangcooperDTOsri = shangmenbanfangcooperDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList(); shangmenbanfangDTO.benrishuliang = (shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count).ToString(); var jijianixiangshangmenbanfang = fiPiecerateDTOs.Where(x => x.Project == "上门拜访客户").FirstOrDefault(); if (jijianixiangshangmenbanfang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangshangmenbanfang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 shangmenbanfangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 shangmenbanfangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { shangmenbanfangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 shangmenbanfangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } else if (jixiaotichengfangan.Renwustandard == "05") { //本月规定 shangmenbanfangDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##"); } } } if (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0) baifangkehuDTOs.Add(shangmenbanfangDTO); #endregion #region 录入客户咨询 TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO(); jiedailaifangDTO.gongzuo = "录入客户咨询"; var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "录入客户咨询").FirstOrDefault(); if (jijianijiedailaifang != null) { //本月数量 var jiedailaifangsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianijiedailaifang.Id).ToList(); jiedailaifangDTO.benyueshuliang = (jiedailaifangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var jiedailaifangsri = jiedailaifangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); jiedailaifangDTO.benrishuliang = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); jiedailaifangDTO.dangrijixiao = (jiedailaifangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianijiedailaifang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { jiedailaifangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); jiedailaifangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // jiedailaifangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { jiedailaifangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(jiedailaifangDTO.benyueshuliang) > 0 || decimal.Parse(jiedailaifangDTO.benrishuliang) > 0) baifangkehuDTOs.Add(jiedailaifangDTO); #endregion List dingdanDTOs = new List(); #region 新增订单 //本月数量 var dingdanDTOsyue = _cooperOrderService.GetListtongji(curentuser.Id, dateminkaoqin, datemaxkaoqin); var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0; //本日数量 var dingdanDTOsri = dingdanDTOsyue.Where(x =>( x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)) || (x.Wangongtime >= chauxnshijian.Date && x.Wangongtime < chauxnshijian.Date.AddDays(1)) ).ToList(); foreach (var cooperOrderDTO in dingdanDTOsri) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); dingdanDTO.dingdanbianhao = cooperOrderDTO.OrderNo; dingdanDTO.dingdanmingcheng = cooperOrderDTO.OrderTypeName+"-"+ cooperOrderDTO.OrderType1Name + (string.IsNullOrEmpty(cooperOrderDTO.OrderType2)?"":"-"+ cooperOrderDTO.OrderType2); dingdanDTO.danjia = cooperOrderDTO.Price.Value.ToString("0.##"); dingdanDTO.shuliang = cooperOrderDTO.OrderNum.Value.ToString("0.##"); dingdanDTO.jine = cooperOrderDTO.Money.Value.ToString("0.##"); dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); dingdanDTOs.Add(dingdanDTO); } int dingdanDTOsCount = 1; if (dingdanDTOs.Count == 0 && benyuezonge == 0) { dingdanDTOsCount = 0; } if (dingdanDTOs.Count == 0) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); dingdanDTOs.Add(dingdanDTO); } #endregion List ziliaoweihuDTOs = new List(); #region 新闻资讯 TongjiBaoBiaoDTO xinwenzixunDTO = new TongjiBaoBiaoDTO(); xinwenzixunDTO.gongzuo = "新闻资讯"; //本月数量 DtChannelArticleNewsDTOSearch searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = curentuser.UserSn; searchEntity.CategoryId = 3; var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity); xinwenzixunDTO.benyueshuliang = dtChannelArticleNewsDTOs.Count.ToString(); //本日数量 var xinwenzixunsri = dtChannelArticleNewsDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList(); xinwenzixunDTO.benrishuliang = xinwenzixunsri.Count.ToString(); var jijianixinwenzixun = fiPiecerateDTOs.Where(x => x.Project == "新闻资讯").FirstOrDefault(); if (jijianixinwenzixun != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinwenzixun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinwenzixunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinwenzixunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinwenzixunsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xinwenzixunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { xinwenzixunDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xinwenzixunDTO.benyueshuliang) > 0 || decimal.Parse(xinwenzixunDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(xinwenzixunDTO); #endregion #region 典型案例 TongjiBaoBiaoDTO dianxinanliDTO = new TongjiBaoBiaoDTO(); dianxinanliDTO.gongzuo = "典型案例"; //本月数量 searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = curentuser.UserSn; searchEntity.CategoryId = 85; var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity); dianxinanliDTO.benyueshuliang = dianxinanDTOs.Count.ToString(); //本日数量 var dianxinanlisri = dianxinanDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList(); dianxinanliDTO.benrishuliang = dianxinanlisri.Count.ToString(); var jijianidianxinanli = fiPiecerateDTOs.Where(x => x.Project == "典型案例").FirstOrDefault(); if (jijianidianxinanli != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidianxinanli.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { dianxinanliDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); dianxinanliDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dianxinanlisri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { dianxinanliDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { dianxinanliDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(dianxinanliDTO.benyueshuliang) > 0 || decimal.Parse(dianxinanliDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(dianxinanliDTO); #endregion #region 政采知识 TongjiBaoBiaoDTO zhengcaizhishiDTO = new TongjiBaoBiaoDTO(); zhengcaizhishiDTO.gongzuo = "政采知识"; //本月数量 searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = curentuser.UserSn; searchEntity.CategoryId = 73; var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity); zhengcaizhishiDTO.benyueshuliang = zhengcaizhishiDTOs.Count.ToString(); //本日数量 var zhengcaizhishisri = zhengcaizhishiDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList(); zhengcaizhishiDTO.benrishuliang = zhengcaizhishisri.Count.ToString(); var jijianizhengcaizhishi = fiPiecerateDTOs.Where(x => x.Project == "政采知识").FirstOrDefault(); if (jijianizhengcaizhishi != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhengcaizhishi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhengcaizhishiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhengcaizhishiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhengcaizhishisri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhengcaizhishiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhengcaizhishiDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhengcaizhishiDTO.benyueshuliang) > 0 || decimal.Parse(zhengcaizhishiDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(zhengcaizhishiDTO); #endregion #region 微信微博公众号新增粉丝 TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO(); gongzhonghaoDTO.gongzuo = "微信微博公众号新增粉丝"; var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "微信微博公众号新增粉丝").FirstOrDefault(); if (jijianigongzhonghao != null) { //本月数量 var gongzhonghaosyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigongzhonghao.Id).ToList(); gongzhonghaoDTO.benyueshuliang = (gongzhonghaosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var gongzhonghaosri = gongzhonghaosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); gongzhonghaoDTO.benrishuliang = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); gongzhonghaoDTO.dangrijixiao = (gongzhonghaosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigongzhonghao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { gongzhonghaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); gongzhonghaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // gongzhonghaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { gongzhonghaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(gongzhonghaoDTO.benyueshuliang) > 0 || decimal.Parse(gongzhonghaoDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(gongzhonghaoDTO); #endregion #region 网页制作 TongjiBaoBiaoDTO wangyeDTO = new TongjiBaoBiaoDTO(); wangyeDTO.gongzuo = "网页制作"; var jijianiwangye = fiPiecerateDTOs.Where(x => x.Project == "网页制作").FirstOrDefault(); if (jijianiwangye != null) { //本月数量 var wangyesyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiwangye.Id).ToList(); wangyeDTO.benyueshuliang = (wangyesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var wangyesri = wangyesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); wangyeDTO.benrishuliang = (wangyesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); wangyeDTO.dangrijixiao = (wangyesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiwangye.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { wangyeDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); wangyeDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (wangyesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // wangyeDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { wangyeDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(wangyeDTO.benyueshuliang) > 0 || decimal.Parse(wangyeDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(wangyeDTO); #endregion #region 新增小采问题 TongjiBaoBiaoDTO xinzengwendaDTO = new TongjiBaoBiaoDTO(); xinzengwendaDTO.gongzuo = "新增小采问题"; //本月数量 var xinzengwendaDTOsyue = _liaotianService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); xinzengwendaDTO.benyueshuliang = xinzengwendaDTOsyue.Count.ToString(); //本日数量 var xinzengwendaDTOsri = xinzengwendaDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); xinzengwendaDTO.benrishuliang = xinzengwendaDTOsri.Count.ToString(); var jijianixinzengwenda = fiPiecerateDTOs.Where(x => x.Project == "新增小采问题").FirstOrDefault(); if (jijianixinzengwenda != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinzengwenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinzengwendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinzengwendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinzengwendaDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xinzengwendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { xinzengwendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = xinzengwendaDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xinzengwendaDTO.benyueshuliang) > 0 || decimal.Parse(xinzengwendaDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(xinzengwendaDTO); #endregion #region 审核小采答问 TongjiBaoBiaoDTO shenhewendaDTO = new TongjiBaoBiaoDTO(); shenhewendaDTO.gongzuo = "审核小采答问"; //本月数量 var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(curentuser.Id, dateminkaoqin, datemaxkaoqin); shenhewendaDTO.benyueshuliang = shenhewendaDTOsyue.Count.ToString(); //本日数量 var shenhewendaDTOsri = shenhewendaDTOsyue.Where(x => x.Shenhetime >= chauxnshijian.Date && x.Shenhetime < chauxnshijian.Date.AddDays(1)).ToList(); shenhewendaDTO.benrishuliang = shenhewendaDTOsri.Count.ToString(); var jijianishenhewenda = fiPiecerateDTOs.Where(x => x.Project == "审核小采答问").FirstOrDefault(); if (jijianishenhewenda != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianishenhewenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { shenhewendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); shenhewendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shenhewendaDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { shenhewendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { shenhewendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = shenhewendaDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(shenhewendaDTO.benyueshuliang) > 0 || decimal.Parse(shenhewendaDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(shenhewendaDTO); #endregion List xiangmushishiDTOs = new List(); #region 标书制作 TongjiBaoBiaoDTO biaoshuzhizuoDTO = new TongjiBaoBiaoDTO(); biaoshuzhizuoDTO.gongzuo = "标书制作"; var jijianibiaoshuzhizuo = fiPiecerateDTOs.Where(x => x.Project == "标书制作").FirstOrDefault(); if (jijianibiaoshuzhizuo != null) { //本月数量 var biaoshuzhizuosyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshuzhizuo.Id).ToList(); biaoshuzhizuoDTO.benyueshuliang = (biaoshuzhizuosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var biaoshuzhizuosri = biaoshuzhizuosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); biaoshuzhizuoDTO.benrishuliang = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); biaoshuzhizuoDTO.dangrijixiao = (biaoshuzhizuosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshuzhizuo.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { biaoshuzhizuoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); biaoshuzhizuoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // biaoshuzhizuoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { biaoshuzhizuoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(biaoshuzhizuoDTO.benyueshuliang) > 0 || decimal.Parse(biaoshuzhizuoDTO.benrishuliang) > 0) xiangmushishiDTOs.Add(biaoshuzhizuoDTO); #endregion #region 标书检查 TongjiBaoBiaoDTO biaoshujianchaDTO = new TongjiBaoBiaoDTO(); biaoshujianchaDTO.gongzuo = "标书检查"; var jijianibiaoshujiancha = fiPiecerateDTOs.Where(x => x.Project == "标书检查").FirstOrDefault(); if (jijianibiaoshujiancha != null) { //本月数量 var biaoshujianchasyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshujiancha.Id).ToList(); biaoshujianchaDTO.benyueshuliang = (biaoshujianchasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var biaoshujianchasri = biaoshujianchasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); biaoshujianchaDTO.benrishuliang = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); biaoshujianchaDTO.dangrijixiao = (biaoshujianchasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshujiancha.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { biaoshujianchaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); biaoshujianchaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // biaoshujianchaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { biaoshujianchaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(biaoshujianchaDTO.benyueshuliang) > 0 || decimal.Parse(biaoshujianchaDTO.benrishuliang) > 0) xiangmushishiDTOs.Add(biaoshujianchaDTO); #endregion #region 起草质疑投诉 TongjiBaoBiaoDTO zhiyiDTO = new TongjiBaoBiaoDTO(); zhiyiDTO.gongzuo = "起草质疑投诉书"; var jijianizhiyi = fiPiecerateDTOs.Where(x => x.Project == "起草质疑投诉书").FirstOrDefault(); if (jijianizhiyi != null) { //本月数量 var zhiyisyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhiyi.Id).ToList(); zhiyiDTO.benyueshuliang = (zhiyisyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhiyisri = zhiyisyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); zhiyiDTO.benrishuliang = (zhiyisri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhiyiDTO.dangrijixiao = (zhiyisri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhiyi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhiyiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhiyiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhiyisri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhiyiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhiyiDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhiyiDTO.benyueshuliang) > 0 || decimal.Parse(zhiyiDTO.benrishuliang) > 0) xiangmushishiDTOs.Add(zhiyiDTO); #endregion ViewBag.tuiguangDTOs = tuiguangDTOs; ViewBag.baifangkehuDTOs = baifangkehuDTOs; ViewBag.dingdanDTOs = dingdanDTOs; ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs; ViewBag.xiangmushishiDTOs = xiangmushishiDTOs; ViewBag.dingdanDTOsCount = dingdanDTOsCount; ViewBag.UserName = curentuser.UserName; ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd"); return View(); } public async Task IndexSuoyouAsync(string Tongjitime = "",string userid = "") { var curentuser = JsonConvert.DeserializeObject(HttpContext.Session.GetString("User")); ViewData["curentuser"] = curentuser; DateTime chauxnshijian = DateTime.Now.Date; if (!string.IsNullOrEmpty(Tongjitime)) { DateTime.TryParse(Tongjitime, out chauxnshijian); } var userDTOs = _userService.GetList(); string[] Userids = null; if (!string.IsNullOrEmpty(userid) && userid!= "null") { Userids = userDTOs.Where(x=> userid.Split(',').Contains(x.Id)).OrderBy(x => x.DeptId).ThenBy(x => x.HrPosition).Select(x => x.Id).ToArray(); } else { Userids = userDTOs.OrderBy(x => x.DeptId).ThenBy(x=>x.HrPosition).Select(x => x.Id).ToArray(); } List tongjibaobiaobaobiaoDTOs = new List(); if (Userids!=null&& Userids.Length > 0) { DateTime dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1); int Yingchuqin = 0; int Offdays = 0; //是否上班日期 AdmAttendanceRuleDTO admAttendanceRuleDTO = _attendanceRuleService.Get(""); var admAttendanceRulesDtlDTOs = _attendanceRuleService.GetDtlList(""); var jiejiari = admAttendanceRulesDtlDTOs.Where(x => x.Name == "jiejiari").ToList(); var tiaoxiuri = admAttendanceRulesDtlDTOs.Where(x => x.Name == "tiaoxiuri").ToList(); List fiPiecerateDTOs = _fiPiecerateService.GetList(); List hrJixiaotichengDTOs = _hrJixiaotichengService.GetList().Where(x => x.Effecttime < datemaxkaoqin).ToList(); //计算每月工作日 while (dateminkaoqin < datemaxkaoqin) { _logger.LogInformation("dateminkaoqin " + dateminkaoqin); //bool iswork = false; if ((int)dateminkaoqin.DayOfWeek >= admAttendanceRuleDTO.WeekStart && (int)dateminkaoqin.DayOfWeek <= admAttendanceRuleDTO.WeekEnd) { //是否节假日 if (jiejiari.Exists(x => x.ValueStart <= dateminkaoqin && x.ValueEnd >= dateminkaoqin)) { Offdays += 1; } else { Yingchuqin += 1; //iswork = true; } } else { //是否调休日 调休日需要上班 if (tiaoxiuri.Exists(x => x.ValueStart <= dateminkaoqin.Date && x.ValueEnd >= dateminkaoqin.Date)) { Yingchuqin += 1; //iswork = true; } else { Offdays += 1; } } dateminkaoqin = dateminkaoqin.AddDays(1); } dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); foreach (var Userid in Userids) { var userDTO = userDTOs.Where(x=>x.Id == Userid).FirstOrDefault(); string position = userDTO.HrPosition; var hrPositionDTO = _hrPositionService.Get(userDTO.HrPosition); var deptDTO = _hrDeptService.Get(userDTO.DeptId); var admSignInDTO = _admSigninService.GetByUserAndDate(Userid, chauxnshijian); var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == position).ToList(); List tuiguangDTOs = new List(); #region 采购项目录入 TongjiBaoBiaoDTO xiangmuDTO = new TongjiBaoBiaoDTO(); xiangmuDTO.gongzuo = "采购项目录入"; //本月数量 var projectDTOsyue = _projectService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin); xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString(); //本日数量 var projectDTOsri = projectDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); xiangmuDTO.benrishuliang = projectDTOsri.Count.ToString(); var jijianixiangmu = fiPiecerateDTOs.Where(x => x.Project == "采购项目录入").FirstOrDefault(); if (jijianixiangmu != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangmu.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 xiangmuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 xiangmuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = projectDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xiangmuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 xiangmuDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xiangmuDTO.benyueshuliang) > 0 || decimal.Parse(xiangmuDTO.benrishuliang) > 0) tuiguangDTOs.Add(xiangmuDTO); #endregion #region 采购公告录入 TongjiBaoBiaoDTO caigougonggaoDTO = new TongjiBaoBiaoDTO(); caigougonggaoDTO.gongzuo = "采购公告录入"; //本月数量 var caigougonggaoDTOsyue = _projectService.GetcaigougonggaoListsalary(Userid, dateminkaoqin, datemaxkaoqin); caigougonggaoDTO.benyueshuliang = caigougonggaoDTOsyue.Count.ToString(); //本日数量 var caigougonggaoDTOsri = caigougonggaoDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); caigougonggaoDTO.benrishuliang = caigougonggaoDTOsri.Count.ToString(); var jijianicaigougonggao = fiPiecerateDTOs.Where(x => x.Project == "采购公告录入").FirstOrDefault(); if (jijianicaigougonggao != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianicaigougonggao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 caigougonggaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 caigougonggaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = caigougonggaoDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { caigougonggaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 caigougonggaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (caigougonggaoDTOsyue.Count > 0 || caigougonggaoDTOsri.Count > 0) tuiguangDTOs.Add(caigougonggaoDTO); #endregion #region 客户资料录入 TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO(); kehuluruDTO.gongzuo = "客户资料录入"; //本月数量 var intentionCustomerDTOsyue = _intentionCustomerService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin); kehuluruDTO.benyueshuliang = intentionCustomerDTOsyue.Count.ToString(); //本日数量 var intentionCustomerDTOsri = intentionCustomerDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); kehuluruDTO.benrishuliang = intentionCustomerDTOsri.Count.ToString(); var jijianikehuluru = fiPiecerateDTOs.Where(x => x.Project == "客户资料录入").FirstOrDefault(); if (jijianikehuluru != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianikehuluru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { kehuluruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); kehuluruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionCustomerDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { kehuluruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { kehuluruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(kehuluruDTO.benyueshuliang) > 0 || decimal.Parse(kehuluruDTO.benrishuliang) > 0) tuiguangDTOs.Add(kehuluruDTO); #endregion #region 新加群组 TongjiBaoBiaoDTO qunzuDTO = new TongjiBaoBiaoDTO(); qunzuDTO.gongzuo = "新加群组"; //本月数量 var groupTopicDTOsyue = _groupTopicService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin); qunzuDTO.benyueshuliang = groupTopicDTOsyue.Count.ToString(); //本日数量 var groupTopicDTOsri = groupTopicDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); qunzuDTO.benrishuliang = groupTopicDTOsri.Count.ToString(); var jijianixianggroupTopic = fiPiecerateDTOs.Where(x => x.Project == "新加群组").FirstOrDefault(); if (jijianixianggroupTopic != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixianggroupTopic.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 qunzuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 qunzuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { qunzuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 qunzuDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(qunzuDTO.benyueshuliang) > 0 || decimal.Parse(qunzuDTO.benrishuliang) > 0) tuiguangDTOs.Add(qunzuDTO); #endregion #region 电话推广 TongjiBaoBiaoDTO dianhuatuiguangDTO = new TongjiBaoBiaoDTO(); dianhuatuiguangDTO.gongzuo = "电话推广"; //本月数量 var intentionVisitDTOsyue = _intentionVisitService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "01").ToList(); dianhuatuiguangDTO.benyueshuliang = intentionVisitDTOsyue.Count.ToString(); //本日数量 var intentionVisitDTOsri = intentionVisitDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList(); dianhuatuiguangDTO.benrishuliang = intentionVisitDTOsri.Count.ToString(); var jijianixiangdianhuatuiguang = fiPiecerateDTOs.Where(x => x.Project == "电话推广").FirstOrDefault(); if (jijianixiangdianhuatuiguang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangdianhuatuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 dianhuatuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 dianhuatuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { dianhuatuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 dianhuatuiguangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(dianhuatuiguangDTO.benyueshuliang) > 0 || decimal.Parse(dianhuatuiguangDTO.benrishuliang) > 0) tuiguangDTOs.Add(dianhuatuiguangDTO); #endregion #region 添加微信客户 TongjiBaoBiaoDTO weixnDTO = new TongjiBaoBiaoDTO(); weixnDTO.gongzuo = "添加微信客户"; //本月数量 var cooperweixinDTOsyue = _cooperatecustomCustomerService.GetListsalaryweixin(Userid, dateminkaoqin, datemaxkaoqin); var intentionweixinDTOsyue = _intentionCustomerService.GetListsalaryweixin(Userid, dateminkaoqin, datemaxkaoqin); weixnDTO.benyueshuliang = (cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count).ToString(); //本日数量 var cooperweixinDTOsri = cooperweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList(); var intentionweixinDTOsri = intentionweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList(); weixnDTO.benrishuliang = (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count).ToString(); var jijianiweixn = fiPiecerateDTOs.Where(x => x.Project == "添加微信客户").FirstOrDefault(); if (jijianiweixn != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiweixn.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { weixnDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); weixnDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { weixnDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { weixnDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(weixnDTO.benyueshuliang) > 0 || decimal.Parse(weixnDTO.benrishuliang) > 0) tuiguangDTOs.Add(weixnDTO); #endregion #region 群发短信 TongjiBaoBiaoDTO duanxinDTO = new TongjiBaoBiaoDTO(); duanxinDTO.gongzuo = "群发短信"; //本月数量 var duanxinsyue = _cusFangwenjiluService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "01").ToList(); duanxinDTO.benyueshuliang = duanxinsyue.Count.ToString(); //本日数量 var duanxinsri = duanxinsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); duanxinDTO.benrishuliang = duanxinsri.Count.ToString(); var jijianiduanxin = fiPiecerateDTOs.Where(x => x.Project == "群发短信").FirstOrDefault(); if (jijianiduanxin != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiduanxin.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { duanxinDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); duanxinDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = duanxinsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { duanxinDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { duanxinDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(duanxinDTO.benyueshuliang) > 0 || decimal.Parse(duanxinDTO.benrishuliang) > 0) tuiguangDTOs.Add(duanxinDTO); #endregion #region 商业信函推广 TongjiBaoBiaoDTO xinhanDTO = new TongjiBaoBiaoDTO(); xinhanDTO.gongzuo = "商业信函推广"; var jijianixinhan = fiPiecerateDTOs.Where(x => x.Project == "商业信函推广").FirstOrDefault(); if (jijianixinhan != null) { //本月数量 var xinhansyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianixinhan.Id).ToList(); xinhanDTO.benyueshuliang = (xinhansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var xinhansri = xinhansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); xinhanDTO.benrishuliang = (xinhansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); xinhanDTO.dangrijixiao = (xinhansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinhan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinhanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinhanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (xinhansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // xinhanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { xinhanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xinhanDTO.benyueshuliang) > 0 || decimal.Parse(xinhanDTO.benrishuliang) > 0) tuiguangDTOs.Add(xinhanDTO); #endregion #region 群发邮件 TongjiBaoBiaoDTO youjianDTO = new TongjiBaoBiaoDTO(); youjianDTO.gongzuo = "群发邮件"; //本月数量 var youjiansyue = _cusFangwenjiluService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "02").ToList(); youjianDTO.benyueshuliang = youjiansyue.Count.ToString(); //本日数量 var youjiansri = youjiansyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); youjianDTO.benrishuliang = youjiansri.Count.ToString(); var jijianiyoujian = fiPiecerateDTOs.Where(x => x.Project == "群发邮件").FirstOrDefault(); if (jijianiyoujian != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyoujian.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { youjianDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); youjianDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = youjiansri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { youjianDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { youjianDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(youjianDTO.benyueshuliang) > 0 || decimal.Parse(youjianDTO.benrishuliang) > 0) tuiguangDTOs.Add(youjianDTO); #endregion #region 群组推广 TongjiBaoBiaoDTO qunzutuiguangDTO = new TongjiBaoBiaoDTO(); qunzutuiguangDTO.gongzuo = "群组推广"; var jijianiqunzutuiguang = fiPiecerateDTOs.Where(x => x.Project == "群组推广").FirstOrDefault(); if (jijianiqunzutuiguang != null) { //本月数量 var qunzutuiguangsyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiqunzutuiguang.Id).ToList(); qunzutuiguangDTO.benyueshuliang = (qunzutuiguangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var qunzutuiguangsri = qunzutuiguangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); qunzutuiguangDTO.benrishuliang = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); qunzutuiguangDTO.dangrijixiao = (qunzutuiguangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqunzutuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { qunzutuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); qunzutuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // qunzutuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { qunzutuiguangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(qunzutuiguangDTO.benyueshuliang) > 0 || decimal.Parse(qunzutuiguangDTO.benrishuliang) > 0) tuiguangDTOs.Add(qunzutuiguangDTO); #endregion #region 朋友圈转发 TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO(); pengyouquanDTO.gongzuo = "朋友圈转发"; var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈转发").FirstOrDefault(); if (jijianipengyouquan != null) { //本月数量 var pengyouquansyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianipengyouquan.Id).ToList(); pengyouquanDTO.benyueshuliang = (pengyouquansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var pengyouquansri = pengyouquansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); pengyouquanDTO.benrishuliang = (pengyouquansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); pengyouquanDTO.dangrijixiao = (pengyouquansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianipengyouquan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { pengyouquanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); pengyouquanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (pengyouquansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // pengyouquanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { pengyouquanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } else if (jixiaotichengfangan.Renwustandard == "05") { //本月规定 pengyouquanDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##"); } } } if (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0) tuiguangDTOs.Add(pengyouquanDTO); #endregion #region 论坛推广 TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO(); luntanfatieDTO.gongzuo = "论坛推广"; var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛推广").FirstOrDefault(); if (jijianiluntanfatie != null) { //本月数量 var luntanfatiesyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiluntanfatie.Id).ToList(); luntanfatieDTO.benyueshuliang = (luntanfatiesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var luntanfatiesri = luntanfatiesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); luntanfatieDTO.benrishuliang = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); luntanfatieDTO.dangrijixiao = (luntanfatiesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiluntanfatie.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { luntanfatieDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); luntanfatieDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // luntanfatieDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { luntanfatieDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(luntanfatieDTO.benyueshuliang) > 0 || decimal.Parse(luntanfatieDTO.benrishuliang) > 0) tuiguangDTOs.Add(luntanfatieDTO); #endregion #region 贴吧推广 TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO(); gentiepinglunDTO.gongzuo = "贴吧推广"; var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "贴吧推广").FirstOrDefault(); if (jijianigentiepinglun != null) { //本月数量 var gentiepinglunsyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigentiepinglun.Id).ToList(); gentiepinglunDTO.benyueshuliang = (gentiepinglunsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var gentiepinglunsri = gentiepinglunsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); gentiepinglunDTO.benrishuliang = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); gentiepinglunDTO.dangrijixiao = (gentiepinglunsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigentiepinglun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { gentiepinglunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); gentiepinglunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // gentiepinglunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { gentiepinglunDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(gentiepinglunDTO.benyueshuliang) > 0 || decimal.Parse(gentiepinglunDTO.benrishuliang) > 0) tuiguangDTOs.Add(gentiepinglunDTO); #endregion #region 转发微信微博 TongjiBaoBiaoDTO zhuanfaDTO = new TongjiBaoBiaoDTO(); zhuanfaDTO.gongzuo = "转发微信微博"; var jijianizhuanfa = fiPiecerateDTOs.Where(x => x.Project == "转发微信微博").FirstOrDefault(); if (jijianizhuanfa != null) { //本月数量 var zhuanfasyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhuanfa.Id).ToList(); zhuanfaDTO.benyueshuliang = (zhuanfasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhuanfasri = zhuanfasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); zhuanfaDTO.benrishuliang = (zhuanfasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhuanfaDTO.dangrijixiao = (zhuanfasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanfa.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhuanfaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhuanfaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhuanfasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhuanfaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhuanfaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhuanfaDTO.benyueshuliang) > 0 || decimal.Parse(zhuanfaDTO.benrishuliang) > 0) tuiguangDTOs.Add(zhuanfaDTO); #endregion #region 新增意向客户(订单) TongjiBaoBiaoDTO yixiangDTO = new TongjiBaoBiaoDTO(); yixiangDTO.gongzuo = "新增意向客户(订单)"; //本月数量 var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(Userid, dateminkaoqin, datemaxkaoqin).ToList(); yixiangDTO.benyueshuliang = yixiangsyue.Count.ToString(); //本日数量 var yixiangsri = yixiangsyue.Where(x => x.Yixiangtime >= chauxnshijian.Date && x.Yixiangtime < chauxnshijian.Date.AddDays(1)).ToList(); yixiangDTO.benrishuliang = yixiangsri.Count.ToString(); var jijianiyixiang = fiPiecerateDTOs.Where(x => x.Project == "新增意向客户(订单)").FirstOrDefault(); if (jijianiyixiang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyixiang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { yixiangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); yixiangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = yixiangsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { yixiangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { yixiangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(yixiangDTO.benyueshuliang) > 0 || decimal.Parse(yixiangDTO.benrishuliang) > 0) tuiguangDTOs.Add(yixiangDTO); #endregion #region 新增注册会员 TongjiBaoBiaoDTO zhucehuiyuanDTO = new TongjiBaoBiaoDTO(); zhucehuiyuanDTO.gongzuo = "新增注册会员"; var jijianizhucehuiyuan = fiPiecerateDTOs.Where(x => x.Project == "新增注册会员").FirstOrDefault(); if (jijianizhucehuiyuan != null) { //本月数量 List zhucehuiyuansyue = new List(); try { //var pltUserDTO = _userService.GetPltUserEntity(Userid); string huiyuanurl = _configuration.GetSection("huiyuanurl").Value; string GetYGYaoQingYonghu = _configuration.GetSection("GetYGYaoQingYonghu").Value; Uri postUrl2 = new Uri(huiyuanurl + GetYGYaoQingYonghu); JObject questions2 = new JObject(); questions2.Add("UserID", Userid); questions2.Add("StartTime", dateminkaoqin.ToString("yyyy-MM-dd HH:mm:ss")); questions2.Add("EndTime", datemaxkaoqin.ToString("yyyy-MM-dd HH:mm:ss")); string requestJson2 = questions2.ToString(); string result2 = string.Empty; 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 jobjectresult = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") { zhucehuiyuanDTO.benyueshuliang = jobjectresult["count"].ToString(); zhucehuiyuansyue = JsonConvert.DeserializeObject>(jobjectresult["data"].ToString()); } else { zhucehuiyuanDTO.benyueshuliang = "0"; } } catch (Exception ex) { zhucehuiyuanDTO.benyueshuliang = "0"; } //var zhucehuiyuansyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhucehuiyuan.Id).ToList(); //zhucehuiyuanDTO.benyueshuliang = (zhucehuiyuansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.CreatTime >= chauxnshijian.Date && x.CreatTime < chauxnshijian.Date.AddDays(1)).ToList(); zhucehuiyuanDTO.benrishuliang = zhucehuiyuansri.Count.ToString(); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhucehuiyuan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhucehuiyuansri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhucehuiyuanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhucehuiyuanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = qianyueDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhucehuiyuanDTO.benyueshuliang) > 0 || decimal.Parse(zhucehuiyuanDTO.benrishuliang) > 0) tuiguangDTOs.Add(zhucehuiyuanDTO); #endregion #region 新增签约客户 TongjiBaoBiaoDTO qianyueDTO = new TongjiBaoBiaoDTO(); qianyueDTO.gongzuo = "新增签约客户"; //本月数量 var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin); qianyueDTO.benyueshuliang = qianyueDTOsyue.Count.ToString(); //本日数量 var qianyueDTOsri = qianyueDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); qianyueDTO.benrishuliang = qianyueDTOsri.Count.ToString(); var jijianiqianyue = fiPiecerateDTOs.Where(x => x.Project == "新增签约客户").FirstOrDefault(); if (jijianiqianyue != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqianyue.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { qianyueDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); qianyueDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = qianyueDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { qianyueDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { qianyueDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = qianyueDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0) tuiguangDTOs.Add(qianyueDTO); #endregion #region 专家录入 TongjiBaoBiaoDTO zhuanjialuruDTO = new TongjiBaoBiaoDTO(); zhuanjialuruDTO.gongzuo = "专家录入"; //本月数量 var zhuanjialuruDTOsyue = _expertService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin); zhuanjialuruDTO.benyueshuliang = zhuanjialuruDTOsyue.Count.ToString(); //本日数量 var zhuanjialuruDTOsri = zhuanjialuruDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); zhuanjialuruDTO.benrishuliang = zhuanjialuruDTOsri.Count.ToString(); var jijianizhuanjialuru = fiPiecerateDTOs.Where(x => x.Project == "专家录入").FirstOrDefault(); if (jijianizhuanjialuru != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanjialuru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhuanjialuruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhuanjialuruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhuanjialuruDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhuanjialuruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhuanjialuruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (zhuanjialuruDTOsyue.Count > 0 || zhuanjialuruDTOsri.Count > 0) tuiguangDTOs.Add(zhuanjialuruDTO); #endregion List baifangkehuDTOs = new List(); #region 上门拜访客户 TongjiBaoBiaoDTO shangmenbanfangDTO = new TongjiBaoBiaoDTO(); shangmenbanfangDTO.gongzuo = "上门拜访客户"; //本月数量 var shangmenbanfangDTOsyue = _intentionVisitService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); var shangmenbanfangcooperDTOsyue = _cooperVisitService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); shangmenbanfangDTO.benyueshuliang = (shangmenbanfangcooperDTOsyue.Count + shangmenbanfangDTOsyue.Count).ToString(); //本日数量 var shangmenbanfangDTOsri = shangmenbanfangDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList(); var shangmenbanfangcooperDTOsri = shangmenbanfangcooperDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList(); shangmenbanfangDTO.benrishuliang = (shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count).ToString(); var jijianixiangshangmenbanfang = fiPiecerateDTOs.Where(x => x.Project == "上门拜访客户").FirstOrDefault(); if (jijianixiangshangmenbanfang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangshangmenbanfang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 shangmenbanfangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 shangmenbanfangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { shangmenbanfangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 shangmenbanfangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } else if (jixiaotichengfangan.Renwustandard == "05") { //本月规定 shangmenbanfangDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##"); } } } if (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0) baifangkehuDTOs.Add(shangmenbanfangDTO); #endregion #region 录入客户咨询 TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO(); jiedailaifangDTO.gongzuo = "录入客户咨询"; var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "录入客户咨询").FirstOrDefault(); if (jijianijiedailaifang != null) { //本月数量 var jiedailaifangsyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianijiedailaifang.Id).ToList(); jiedailaifangDTO.benyueshuliang = (jiedailaifangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var jiedailaifangsri = jiedailaifangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); jiedailaifangDTO.benrishuliang = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); jiedailaifangDTO.dangrijixiao = (jiedailaifangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianijiedailaifang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { jiedailaifangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); jiedailaifangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // jiedailaifangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { jiedailaifangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(jiedailaifangDTO.benyueshuliang) > 0 || decimal.Parse(jiedailaifangDTO.benrishuliang) > 0) baifangkehuDTOs.Add(jiedailaifangDTO); #endregion List dingdanDTOs = new List(); #region 新增订单 //本月数量 var dingdanDTOsyue = _cooperOrderService.GetListtongji(Userid, dateminkaoqin, datemaxkaoqin); var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0; //本日数量 var dingdanDTOsri = dingdanDTOsyue.Where(x => (x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)) || (x.Wangongtime >= chauxnshijian.Date && x.Wangongtime < chauxnshijian.Date.AddDays(1))).ToList(); foreach (var cooperOrderDTO in dingdanDTOsri) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); dingdanDTO.dingdanbianhao = cooperOrderDTO.OrderNo; dingdanDTO.dingdanmingcheng = cooperOrderDTO.OrderTypeName + "-" + cooperOrderDTO.OrderType1Name + (string.IsNullOrEmpty(cooperOrderDTO.OrderType2) ? "" : "-" + cooperOrderDTO.OrderType2); dingdanDTO.danjia = cooperOrderDTO.Price.Value.ToString("0.##"); dingdanDTO.shuliang = cooperOrderDTO.OrderNum.Value.ToString("0.##"); dingdanDTO.jine = cooperOrderDTO.Money.Value.ToString("0.##"); dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); dingdanDTOs.Add(dingdanDTO); } int dingdanDTOsCount = 1; if (dingdanDTOs.Count == 0 && benyuezonge == 0) { dingdanDTOsCount = 0; } if (dingdanDTOs.Count == 0) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); dingdanDTOs.Add(dingdanDTO); } #endregion List ziliaoweihuDTOs = new List(); #region 新闻资讯 TongjiBaoBiaoDTO xinwenzixunDTO = new TongjiBaoBiaoDTO(); xinwenzixunDTO.gongzuo = "新闻资讯"; //本月数量 DtChannelArticleNewsDTOSearch searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = userDTO.UserSn; searchEntity.CategoryId = 3; var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity); xinwenzixunDTO.benyueshuliang = dtChannelArticleNewsDTOs.Count.ToString(); //本日数量 var xinwenzixunsri = dtChannelArticleNewsDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList(); xinwenzixunDTO.benrishuliang = xinwenzixunsri.Count.ToString(); var jijianixinwenzixun = fiPiecerateDTOs.Where(x => x.Project == "新闻资讯").FirstOrDefault(); if (jijianixinwenzixun != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinwenzixun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinwenzixunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinwenzixunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinwenzixunsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xinwenzixunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { xinwenzixunDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xinwenzixunDTO.benyueshuliang) > 0 || decimal.Parse(xinwenzixunDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(xinwenzixunDTO); #endregion #region 典型案例 TongjiBaoBiaoDTO dianxinanliDTO = new TongjiBaoBiaoDTO(); dianxinanliDTO.gongzuo = "典型案例"; //本月数量 searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = userDTO.UserSn; searchEntity.CategoryId = 85; var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity); dianxinanliDTO.benyueshuliang = dianxinanDTOs.Count.ToString(); //本日数量 var dianxinanlisri = dianxinanDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList(); dianxinanliDTO.benrishuliang = dianxinanlisri.Count.ToString(); var jijianidianxinanli = fiPiecerateDTOs.Where(x => x.Project == "典型案例").FirstOrDefault(); if (jijianidianxinanli != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidianxinanli.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { dianxinanliDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); dianxinanliDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dianxinanlisri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { dianxinanliDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { dianxinanliDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(dianxinanliDTO.benyueshuliang) > 0 || decimal.Parse(dianxinanliDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(dianxinanliDTO); #endregion #region 政采知识 TongjiBaoBiaoDTO zhengcaizhishiDTO = new TongjiBaoBiaoDTO(); zhengcaizhishiDTO.gongzuo = "政采知识"; //本月数量 searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = userDTO.UserSn; searchEntity.CategoryId = 73; var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity); zhengcaizhishiDTO.benyueshuliang = zhengcaizhishiDTOs.Count.ToString(); //本日数量 var zhengcaizhishisri = zhengcaizhishiDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList(); zhengcaizhishiDTO.benrishuliang = zhengcaizhishisri.Count.ToString(); var jijianizhengcaizhishi = fiPiecerateDTOs.Where(x => x.Project == "政采知识").FirstOrDefault(); if (jijianizhengcaizhishi != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhengcaizhishi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhengcaizhishiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhengcaizhishiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhengcaizhishisri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhengcaizhishiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhengcaizhishiDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhengcaizhishiDTO.benyueshuliang) > 0 || decimal.Parse(zhengcaizhishiDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(zhengcaizhishiDTO); #endregion #region 微信微博公众号新增粉丝 TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO(); gongzhonghaoDTO.gongzuo = "微信微博公众号新增粉丝"; var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "微信微博公众号新增粉丝").FirstOrDefault(); if (jijianigongzhonghao != null) { //本月数量 var gongzhonghaosyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigongzhonghao.Id).ToList(); gongzhonghaoDTO.benyueshuliang = (gongzhonghaosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var gongzhonghaosri = gongzhonghaosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); gongzhonghaoDTO.benrishuliang = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); gongzhonghaoDTO.dangrijixiao = (gongzhonghaosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigongzhonghao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { gongzhonghaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); gongzhonghaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // gongzhonghaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { gongzhonghaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(gongzhonghaoDTO.benyueshuliang) > 0 || decimal.Parse(gongzhonghaoDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(gongzhonghaoDTO); #endregion #region 网页制作 TongjiBaoBiaoDTO wangyeDTO = new TongjiBaoBiaoDTO(); wangyeDTO.gongzuo = "网页制作"; var jijianiwangye = fiPiecerateDTOs.Where(x => x.Project == "网页制作").FirstOrDefault(); if (jijianiwangye != null) { //本月数量 var wangyesyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiwangye.Id).ToList(); wangyeDTO.benyueshuliang = (wangyesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var wangyesri = wangyesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); wangyeDTO.benrishuliang = (wangyesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); wangyeDTO.dangrijixiao = (wangyesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiwangye.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { wangyeDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); wangyeDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (wangyesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // wangyeDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { wangyeDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(wangyeDTO.benyueshuliang) > 0 || decimal.Parse(wangyeDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(wangyeDTO); #endregion #region 新增小采问题 TongjiBaoBiaoDTO xinzengwendaDTO = new TongjiBaoBiaoDTO(); xinzengwendaDTO.gongzuo = "新增小采问题"; //本月数量 var xinzengwendaDTOsyue = _liaotianService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin); xinzengwendaDTO.benyueshuliang = xinzengwendaDTOsyue.Count.ToString(); //本日数量 var xinzengwendaDTOsri = xinzengwendaDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); xinzengwendaDTO.benrishuliang = xinzengwendaDTOsri.Count.ToString(); var jijianixinzengwenda = fiPiecerateDTOs.Where(x => x.Project == "新增小采问题").FirstOrDefault(); if (jijianixinzengwenda != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinzengwenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinzengwendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinzengwendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinzengwendaDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xinzengwendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { xinzengwendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = xinzengwendaDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(xinzengwendaDTO.benyueshuliang) > 0 || decimal.Parse(xinzengwendaDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(xinzengwendaDTO); #endregion #region 审核小采答问 TongjiBaoBiaoDTO shenhewendaDTO = new TongjiBaoBiaoDTO(); shenhewendaDTO.gongzuo = "审核小采答问"; //本月数量 var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(Userid, dateminkaoqin, datemaxkaoqin); shenhewendaDTO.benyueshuliang = shenhewendaDTOsyue.Count.ToString(); //本日数量 var shenhewendaDTOsri = shenhewendaDTOsyue.Where(x => x.Shenhetime >= chauxnshijian.Date && x.Shenhetime < chauxnshijian.Date.AddDays(1)).ToList(); shenhewendaDTO.benrishuliang = shenhewendaDTOsri.Count.ToString(); var jijianishenhewenda = fiPiecerateDTOs.Where(x => x.Project == "审核小采答问").FirstOrDefault(); if (jijianishenhewenda != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianishenhewenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { shenhewendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); shenhewendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shenhewendaDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { shenhewendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { shenhewendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = shenhewendaDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(shenhewendaDTO.benyueshuliang) > 0 || decimal.Parse(shenhewendaDTO.benrishuliang) > 0) ziliaoweihuDTOs.Add(shenhewendaDTO); #endregion List xiangmushishiDTOs = new List(); #region 标书制作 TongjiBaoBiaoDTO biaoshuzhizuoDTO = new TongjiBaoBiaoDTO(); biaoshuzhizuoDTO.gongzuo = "标书制作"; var jijianibiaoshuzhizuo = fiPiecerateDTOs.Where(x => x.Project == "标书制作").FirstOrDefault(); if (jijianibiaoshuzhizuo != null) { //本月数量 var biaoshuzhizuosyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshuzhizuo.Id).ToList(); biaoshuzhizuoDTO.benyueshuliang = (biaoshuzhizuosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var biaoshuzhizuosri = biaoshuzhizuosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); biaoshuzhizuoDTO.benrishuliang = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); biaoshuzhizuoDTO.dangrijixiao = (biaoshuzhizuosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshuzhizuo.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { biaoshuzhizuoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); biaoshuzhizuoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // biaoshuzhizuoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { biaoshuzhizuoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(biaoshuzhizuoDTO.benyueshuliang) > 0 || decimal.Parse(biaoshuzhizuoDTO.benrishuliang) > 0) xiangmushishiDTOs.Add(biaoshuzhizuoDTO); #endregion #region 标书检查 TongjiBaoBiaoDTO biaoshujianchaDTO = new TongjiBaoBiaoDTO(); biaoshujianchaDTO.gongzuo = "标书检查"; var jijianibiaoshujiancha = fiPiecerateDTOs.Where(x => x.Project == "标书检查").FirstOrDefault(); if (jijianibiaoshujiancha != null) { //本月数量 var biaoshujianchasyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshujiancha.Id).ToList(); biaoshujianchaDTO.benyueshuliang = (biaoshujianchasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var biaoshujianchasri = biaoshujianchasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); biaoshujianchaDTO.benrishuliang = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); biaoshujianchaDTO.dangrijixiao = (biaoshujianchasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshujiancha.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { biaoshujianchaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); biaoshujianchaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // biaoshujianchaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { biaoshujianchaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(biaoshujianchaDTO.benyueshuliang) > 0 || decimal.Parse(biaoshujianchaDTO.benrishuliang) > 0) xiangmushishiDTOs.Add(biaoshujianchaDTO); #endregion #region 起草质疑投诉 TongjiBaoBiaoDTO zhiyiDTO = new TongjiBaoBiaoDTO(); zhiyiDTO.gongzuo = "起草质疑投诉书"; var jijianizhiyi = fiPiecerateDTOs.Where(x => x.Project == "起草质疑投诉书").FirstOrDefault(); if (jijianizhiyi != null) { //本月数量 var zhiyisyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhiyi.Id).ToList(); zhiyiDTO.benyueshuliang = (zhiyisyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhiyisri = zhiyisyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); zhiyiDTO.benrishuliang = (zhiyisri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhiyiDTO.dangrijixiao = (zhiyisri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhiyi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhiyiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhiyiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhiyisri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhiyiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhiyiDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } if (decimal.Parse(zhiyiDTO.benyueshuliang) > 0 || decimal.Parse(zhiyiDTO.benrishuliang) > 0) xiangmushishiDTOs.Add(zhiyiDTO); #endregion TongjibaobiaobaobiaoDTO tongjibaobiaobaobiaoDTO = new TongjibaobiaobaobiaoDTO(); tongjibaobiaobaobiaoDTO.tuiguangDTOs = tuiguangDTOs; tongjibaobiaobaobiaoDTO.baifangkehuDTOs = baifangkehuDTOs; tongjibaobiaobaobiaoDTO.dingdanDTOs = dingdanDTOs; tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs = ziliaoweihuDTOs; tongjibaobiaobaobiaoDTO.xiangmushishiDTOs = xiangmushishiDTOs; tongjibaobiaobaobiaoDTO.dingdanDTOsCount = dingdanDTOsCount; tongjibaobiaobaobiaoDTO.UserName = ""; if (deptDTO != null) { tongjibaobiaobaobiaoDTO.UserName += "部门:" + deptDTO.DeptName + "    "; } tongjibaobiaobaobiaoDTO.UserName += "姓名:" + userDTO.UserName + "    "; tongjibaobiaobaobiaoDTO.UserDaka = ""; if (hrPositionDTO != null) { tongjibaobiaobaobiaoDTO.UserDaka += "职务:" + hrPositionDTO.PostName + "    "; } if (admSignInDTO != null) { tongjibaobiaobaobiaoDTO.UserDaka += " 打卡时间:上午 " + (admSignInDTO.MorningIn.HasValue? admSignInDTO.MorningIn.Value.ToString("HH:mm:ss"):"") + "-" + (admSignInDTO.MorningOut.HasValue ? admSignInDTO.MorningOut.Value.ToString("HH:mm:ss") : "") + "    下午 " + (admSignInDTO.AfternoonIn.HasValue ? admSignInDTO.AfternoonIn.Value.ToString("HH:mm:ss") : "") + "-" + (admSignInDTO.AfternoonOut.HasValue ? admSignInDTO.AfternoonOut.Value.ToString("HH:mm:ss") : "") + (admSignInDTO.OvertimeIn.HasValue ? " 加班 " + admSignInDTO.OvertimeIn.Value.ToString("HH:mm:ss") + "-" : "") + (admSignInDTO.OvertimeOut.HasValue ? admSignInDTO.OvertimeOut.Value.ToString("HH:mm:ss") : ""); } tongjibaobiaobaobiaoDTOs.Add(tongjibaobiaobaobiaoDTO); } } ViewBag.tongjibaobiaobaobiaoDTOs = tongjibaobiaobaobiaoDTOs; ViewBag.Userid = Userids; ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd"); ViewData["UserIds"] = userDTOs; return View(); } } }