| | |
| | | _liaotianService = liaotianService; |
| | | } |
| | | |
| | | public IActionResult Index() |
| | | public IActionResult Index(string Tongjitime="") |
| | | { |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | ViewData["curentuser"] = curentuser; |
| | | |
| | | |
| | | DateTime chauxnshijian = DateTime.Now; |
| | | if (!string.IsNullOrEmpty(Tongjitime)) |
| | | { |
| | | DateTime.TryParse(Tongjitime,out chauxnshijian); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | DateTime dateminkaoqin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); |
| | | DateTime dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); |
| | | DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1); |
| | | int Yingchuqin = 0; |
| | | int Offdays = 0; |
| | |
| | | } |
| | | dateminkaoqin = dateminkaoqin.AddDays(1); |
| | | } |
| | | dateminkaoqin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); |
| | | dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); |
| | | |
| | | List<TongjiBaoBiaoDTO> tuiguangDTOs = new List<TongjiBaoBiaoDTO>(); |
| | | |
| | |
| | | var projectDTOsyue = _projectService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString(); |
| | | //本日数量 |
| | | var projectDTOsri = projectDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(xiangmuDTO); |
| | | if(projectDTOsyue.Count > 0 || projectDTOsri.Count > 0 ) |
| | | tuiguangDTOs.Add(xiangmuDTO); |
| | | #endregion |
| | | |
| | | |
| | |
| | | var intentionCustomerDTOsyue = _intentionCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | kehuluruDTO.benyueshuliang = intentionCustomerDTOsyue.Count .ToString(); |
| | | //本日数量 |
| | | var intentionCustomerDTOsri = intentionCustomerDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(kehuluruDTO); |
| | | if (intentionCustomerDTOsyue.Count > 0 || intentionCustomerDTOsri.Count > 0) |
| | | tuiguangDTOs.Add(kehuluruDTO); |
| | | #endregion |
| | | |
| | | #region 新加群组 |
| | |
| | | var groupTopicDTOsyue = _groupTopicService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | qunzuDTO.benyueshuliang = groupTopicDTOsyue.Count.ToString(); |
| | | //本日数量 |
| | | var groupTopicDTOsri = groupTopicDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(qunzuDTO); |
| | | if (groupTopicDTOsyue.Count > 0 || groupTopicDTOsri.Count > 0) |
| | | tuiguangDTOs.Add(qunzuDTO); |
| | | #endregion |
| | | |
| | | #region 电话推广 |
| | |
| | | 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 >= DateTime.Now.Date && x.Vistime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(dianhuatuiguangDTO); |
| | | if (intentionVisitDTOsyue.Count > 0 || intentionVisitDTOsri.Count > 0) |
| | | tuiguangDTOs.Add(dianhuatuiguangDTO); |
| | | #endregion |
| | | |
| | | #region 添加微信客户 |
| | |
| | | var intentionweixinDTOsyue = _intentionCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | weixnDTO.benyueshuliang = (cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count).ToString(); |
| | | //本日数量 |
| | | var cooperweixinDTOsri = cooperweixinDTOsyue.Where(x => x.Weixintime >= DateTime.Now.Date && x.Weixintime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | var intentionweixinDTOsri = intentionweixinDTOsyue.Where(x => x.Weixintime >= DateTime.Now.Date && x.Weixintime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(weixnDTO); |
| | | if ((cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count) > 0 || (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count) > 0) |
| | | tuiguangDTOs.Add(weixnDTO); |
| | | #endregion |
| | | |
| | | #region 群发短信 |
| | |
| | | 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 >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(duanxinDTO); |
| | | if (duanxinsyue.Count > 0 || duanxinsri.Count > 0) |
| | | tuiguangDTOs.Add(duanxinDTO); |
| | | #endregion |
| | | |
| | | |
| | |
| | | |
| | | xinhanDTO.benyueshuliang =(xinhansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var xinhansri = xinhansyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(xinhanDTO); |
| | | if (decimal.Parse(xinhanDTO.benyueshuliang) > 0 || decimal.Parse(xinhanDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(xinhanDTO); |
| | | #endregion |
| | | |
| | | #region 群发邮件 |
| | |
| | | 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 >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(youjianDTO); |
| | | if (decimal.Parse(youjianDTO.benyueshuliang) > 0 || decimal.Parse(youjianDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(youjianDTO); |
| | | #endregion |
| | | |
| | | #region 群组推广 |
| | |
| | | |
| | | qunzutuiguangDTO.benyueshuliang = (qunzutuiguangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var qunzutuiguangsri = qunzutuiguangsyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(qunzutuiguangDTO); |
| | | if (decimal.Parse(qunzutuiguangDTO.benyueshuliang) > 0 || decimal.Parse(qunzutuiguangDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(qunzutuiguangDTO); |
| | | #endregion |
| | | |
| | | #region 朋友圈原创 |
| | |
| | | |
| | | pengyouquanDTO.benyueshuliang = (pengyouquansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var pengyouquansri = pengyouquansyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(pengyouquanDTO); |
| | | if (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(pengyouquanDTO); |
| | | #endregion |
| | | |
| | | #region 论坛发帖 |
| | |
| | | |
| | | luntanfatieDTO.benyueshuliang = (luntanfatiesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var luntanfatiesri = luntanfatiesyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(luntanfatieDTO); |
| | | if (decimal.Parse(luntanfatieDTO.benyueshuliang) > 0 || decimal.Parse(luntanfatieDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(luntanfatieDTO); |
| | | #endregion |
| | | |
| | | #region 跟帖评论 |
| | |
| | | |
| | | gentiepinglunDTO.benyueshuliang = (gentiepinglunsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var gentiepinglunsri = gentiepinglunsyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(gentiepinglunDTO); |
| | | if (decimal.Parse(gentiepinglunDTO.benyueshuliang) > 0 || decimal.Parse(gentiepinglunDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(gentiepinglunDTO); |
| | | #endregion |
| | | |
| | | #region 转发微信微博 |
| | |
| | | |
| | | zhuanfaDTO.benyueshuliang = (zhuanfasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var zhuanfasri = zhuanfasyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(zhuanfaDTO); |
| | | if (decimal.Parse(zhuanfaDTO.benyueshuliang) > 0 || decimal.Parse(zhuanfaDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(zhuanfaDTO); |
| | | #endregion |
| | | |
| | | #region 新增意向客户(订单) |
| | |
| | | var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(curentuser.Id, dateminkaoqin, datemaxkaoqin).ToList(); |
| | | yixiangDTO.benyueshuliang = yixiangsyue.Count.ToString(); |
| | | //本日数量 |
| | | var yixiangsri = yixiangsyue.Where(x => x.Yixiangtime >= DateTime.Now.Date && x.Yixiangtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(yixiangDTO); |
| | | if (decimal.Parse(yixiangDTO.benyueshuliang) > 0 || decimal.Parse(yixiangDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(yixiangDTO); |
| | | #endregion |
| | | |
| | | #region 新增注册会员 |
| | |
| | | |
| | | zhucehuiyuanDTO.benyueshuliang = (zhucehuiyuansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); |
| | | zhucehuiyuanDTO.benrishuliang = (zhucehuiyuansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | zhucehuiyuanDTO.dangrijixiao = (zhucehuiyuansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(zhucehuiyuanDTO); |
| | | if (decimal.Parse(zhucehuiyuanDTO.benyueshuliang) > 0 || decimal.Parse(zhucehuiyuanDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(zhucehuiyuanDTO); |
| | | #endregion |
| | | |
| | | #region 新增签约客户 |
| | |
| | | var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | qianyueDTO.benyueshuliang = qianyueDTOsyue.Count.ToString(); |
| | | //本日数量 |
| | | var qianyueDTOsri = qianyueDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | tuiguangDTOs.Add(qianyueDTO); |
| | | if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0) |
| | | tuiguangDTOs.Add(qianyueDTO); |
| | | #endregion |
| | | |
| | | |
| | |
| | | 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 >= DateTime.Now.Date && x.Vistime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | var shangmenbanfangcooperDTOsri = shangmenbanfangcooperDTOsyue.Where(x => x.Vistime >= DateTime.Now.Date && x.Vistime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | baifangkehuDTOs.Add(shangmenbanfangDTO); |
| | | if (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0) |
| | | baifangkehuDTOs.Add(shangmenbanfangDTO); |
| | | #endregion |
| | | |
| | | #region 接待来访客户 |
| | |
| | | |
| | | jiedailaifangDTO.benyueshuliang = (jiedailaifangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var jiedailaifangsri = jiedailaifangsyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | baifangkehuDTOs.Add(jiedailaifangDTO); |
| | | if (decimal.Parse(jiedailaifangDTO.benyueshuliang) > 0 || decimal.Parse(jiedailaifangDTO.benrishuliang) > 0) |
| | | baifangkehuDTOs.Add(jiedailaifangDTO); |
| | | #endregion |
| | | |
| | | List<TongjiDingDanDTO> dingdanDTOs = new List<TongjiDingDanDTO>(); |
| | |
| | | var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0; |
| | | |
| | | //本日数量 |
| | | var dingdanDTOsri = dingdanDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | var dingdanDTOsri = dingdanDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList(); |
| | | foreach (var cooperOrderDTO in dingdanDTOsri) |
| | | { |
| | | TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); |
| | |
| | | var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity); |
| | | xinwenzixunDTO.benyueshuliang = dtChannelArticleNewsDTOs.Count.ToString(); |
| | | //本日数量 |
| | | var xinwenzixunsri = dtChannelArticleNewsDTOs.Where(x => x.AddTime >= DateTime.Now.Date && x.AddTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(xinwenzixunDTO); |
| | | if (decimal.Parse(xinwenzixunDTO.benyueshuliang) > 0 || decimal.Parse(xinwenzixunDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(xinwenzixunDTO); |
| | | #endregion |
| | | |
| | | #region 典型案例 |
| | |
| | | var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity); |
| | | dianxinanliDTO.benyueshuliang = dianxinanDTOs.Count.ToString(); |
| | | //本日数量 |
| | | var dianxinanlisri = dianxinanDTOs.Where(x => x.AddTime >= DateTime.Now.Date && x.AddTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(dianxinanliDTO); |
| | | if (decimal.Parse(dianxinanliDTO.benyueshuliang) > 0 || decimal.Parse(dianxinanliDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(dianxinanliDTO); |
| | | #endregion |
| | | #region 政采知识 |
| | | TongjiBaoBiaoDTO zhengcaizhishiDTO = new TongjiBaoBiaoDTO(); |
| | |
| | | var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity); |
| | | zhengcaizhishiDTO.benyueshuliang = zhengcaizhishiDTOs.Count.ToString(); |
| | | //本日数量 |
| | | var zhengcaizhishisri = zhengcaizhishiDTOs.Where(x => x.AddTime >= DateTime.Now.Date && x.AddTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(zhengcaizhishiDTO); |
| | | if (decimal.Parse(zhengcaizhishiDTO.benyueshuliang) > 0 || decimal.Parse(zhengcaizhishiDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(zhengcaizhishiDTO); |
| | | #endregion |
| | | |
| | | #region 新增公众号关注 |
| | |
| | | |
| | | gongzhonghaoDTO.benyueshuliang = (gongzhonghaosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var gongzhonghaosri = gongzhonghaosyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(gongzhonghaoDTO); |
| | | if (decimal.Parse(gongzhonghaoDTO.benyueshuliang) > 0 || decimal.Parse(gongzhonghaoDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(gongzhonghaoDTO); |
| | | #endregion |
| | | |
| | | #region 网页制作 |
| | |
| | | |
| | | wangyeDTO.benyueshuliang = (wangyesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var wangyesri = wangyesyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(wangyeDTO); |
| | | if (decimal.Parse(wangyeDTO.benyueshuliang) > 0 || decimal.Parse(wangyeDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(wangyeDTO); |
| | | #endregion |
| | | |
| | | #region 新增小采问题 |
| | |
| | | var xinzengwendaDTOsyue = _liaotianService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | xinzengwendaDTO.benyueshuliang = xinzengwendaDTOsyue.Count.ToString(); |
| | | //本日数量 |
| | | var xinzengwendaDTOsri = xinzengwendaDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(xinzengwendaDTO); |
| | | if (decimal.Parse(xinzengwendaDTO.benyueshuliang) > 0 || decimal.Parse(xinzengwendaDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(xinzengwendaDTO); |
| | | #endregion |
| | | |
| | | #region 审核小采答问 |
| | |
| | | var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(curentuser.Id, dateminkaoqin, datemaxkaoqin); |
| | | shenhewendaDTO.benyueshuliang = shenhewendaDTOsyue.Count.ToString(); |
| | | //本日数量 |
| | | var shenhewendaDTOsri = shenhewendaDTOsyue.Where(x => x.Shenhetime >= DateTime.Now.Date && x.Shenhetime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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(); |
| | |
| | | } |
| | | } |
| | | } |
| | | ziliaoweihuDTOs.Add(shenhewendaDTO); |
| | | if (decimal.Parse(shenhewendaDTO.benyueshuliang) > 0 || decimal.Parse(shenhewendaDTO.benrishuliang) > 0) |
| | | ziliaoweihuDTOs.Add(shenhewendaDTO); |
| | | #endregion |
| | | |
| | | List<TongjiBaoBiaoDTO> xiangmushishiDTOs = new List<TongjiBaoBiaoDTO>(); |
| | |
| | | |
| | | biaoshuzhizuoDTO.benyueshuliang = (biaoshuzhizuosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var biaoshuzhizuosri = biaoshuzhizuosyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | xiangmushishiDTOs.Add(biaoshuzhizuoDTO); |
| | | if (decimal.Parse(biaoshuzhizuoDTO.benyueshuliang) > 0 || decimal.Parse(biaoshuzhizuoDTO.benrishuliang) > 0) |
| | | xiangmushishiDTOs.Add(biaoshuzhizuoDTO); |
| | | #endregion |
| | | |
| | | #region 标书检查 |
| | |
| | | |
| | | biaoshujianchaDTO.benyueshuliang = (biaoshujianchasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var biaoshujianchasri = biaoshujianchasyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | xiangmushishiDTOs.Add(biaoshujianchaDTO); |
| | | if (decimal.Parse(biaoshujianchaDTO.benyueshuliang) > 0 || decimal.Parse(biaoshujianchaDTO.benrishuliang) > 0) |
| | | xiangmushishiDTOs.Add(biaoshujianchaDTO); |
| | | #endregion |
| | | |
| | | #region 起草质疑投诉 |
| | |
| | | |
| | | zhiyiDTO.benyueshuliang = (zhiyisyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | //本日数量 |
| | | var zhiyisri = zhiyisyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); |
| | | 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.##"); |
| | | |
| | |
| | | } |
| | | } |
| | | } |
| | | xiangmushishiDTOs.Add(zhiyiDTO); |
| | | if (decimal.Parse(zhiyiDTO.benyueshuliang) > 0 || decimal.Parse(zhiyiDTO.benrishuliang) > 0) |
| | | xiangmushishiDTOs.Add(zhiyiDTO); |
| | | #endregion |
| | | |
| | | ViewBag.tuiguangDTOs = tuiguangDTOs; |
| | |
| | | ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs; |
| | | ViewBag.xiangmushishiDTOs = xiangmushishiDTOs; |
| | | |
| | | ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd"); |
| | | |
| | | return View(); |
| | | } |
| | | |
| | | |
| | | |
| | | public IActionResult IndexSuoyou(string Tongjitime = "",string userid = "") |
| | | { |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | ViewData["curentuser"] = curentuser; |
| | | |
| | | DateTime chauxnshijian = DateTime.Now; |
| | | if (!string.IsNullOrEmpty(Tongjitime)) |
| | | { |
| | | DateTime.TryParse(Tongjitime, out chauxnshijian); |
| | | } |
| | | string position = curentuser.HrPosition; |
| | | string Userid = curentuser.Id; |
| | | if (!string.IsNullOrEmpty(userid)) |
| | | { |
| | | Userid = userid; |
| | | position = _userService.GetPltUserEntity(Userid).HrPosition; |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | 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<FiPiecerateDTO> fiPiecerateDTOs = _fiPiecerateService.GetList(); |
| | | List<HrJixiaotichengDTO> hrJixiaotichengDTOs = _hrJixiaotichengService.GetList().Where(x => x.Effecttime < datemaxkaoqin).ToList(); |
| | | var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == position).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<TongjiBaoBiaoDTO> tuiguangDTOs = new List<TongjiBaoBiaoDTO>(); |
| | | |
| | | #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 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 + 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 (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); |
| | | // } |
| | | |
| | | //} |
| | | } |
| | | } |
| | | } |
| | | 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) |
| | | { |
| | | //本月数量 |
| | | 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.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList(); |
| | | zhucehuiyuanDTO.benrishuliang = (zhucehuiyuansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); |
| | | zhucehuiyuanDTO.dangrijixiao = (zhucehuiyuansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); |
| | | |
| | | 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.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; |
| | | // if (youxiaojijian > 0) |
| | | // { |
| | | // zhucehuiyuanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); |
| | | // } |
| | | |
| | | //} |
| | | |
| | | } |
| | | else if (jixiaotichengfangan.Renwustandard == "02") |
| | | { |
| | | zhucehuiyuanDTO.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(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 |
| | | |
| | | |
| | | List<TongjiBaoBiaoDTO> baifangkehuDTOs = new List<TongjiBaoBiaoDTO>(); |
| | | |
| | | #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); |
| | | // } |
| | | |
| | | //} |
| | | } |
| | | } |
| | | } |
| | | 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<TongjiDingDanDTO> dingdanDTOs = new List<TongjiDingDanDTO>(); |
| | | |
| | | #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)).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); |
| | | } |
| | | if (dingdanDTOs.Count == 0) |
| | | { |
| | | TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); |
| | | dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); |
| | | |
| | | dingdanDTOs.Add(dingdanDTO); |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | List<TongjiBaoBiaoDTO> ziliaoweihuDTOs = new List<TongjiBaoBiaoDTO>(); |
| | | #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(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<TongjiBaoBiaoDTO> xiangmushishiDTOs = new List<TongjiBaoBiaoDTO>(); |
| | | #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 |
| | | |
| | | ViewBag.tuiguangDTOs = tuiguangDTOs; |
| | | ViewBag.baifangkehuDTOs = baifangkehuDTOs; |
| | | ViewBag.dingdanDTOs = dingdanDTOs; |
| | | ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs; |
| | | ViewBag.xiangmushishiDTOs = xiangmushishiDTOs; |
| | | |
| | | ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd"); |
| | | ViewBag.Userid = Userid; |
| | | ViewData["UserIds"] = _userService.GetList(); |
| | | |
| | | return View(); |
| | | } |
| | | } |