采购公告录入 每个月220个 采购公告， 自己手动找的录入的采购公告

username@email.com

2022-12-26 ce50650dbd08bddfa53ef8ab592a477761633e3d

 zhengcaioa/zhengcaioa/Controllers/admin/TongjiBaoBiaoController.cs

@@ -60,6 +60,7 @@
        private readonly IHrPositionService _hrPositionService;
        private readonly IHrDeptService _hrDeptService;
        private readonly IAdmSigninService _admSigninService;
        private readonly IExpertService _expertService;

        public TongjiBaoBiaoController(ILogger<TongjiBaoBiaoController> logger
            , IAdmAttendanceRuleService attendanceRuleService
@@ -90,6 +91,7 @@
            , IHrPositionService hrPositionService
            , IHrDeptService hrDeptService
            , IAdmSigninService admSigninService
            , IExpertService expertService
            )
        {
            _logger = logger;
@@ -121,6 +123,7 @@
            _hrPositionService = hrPositionService;
            _hrDeptService = hrDeptService;
            _admSigninService = admSigninService;
            _expertService = expertService;
        }

        public async Task<IActionResult> IndexAsync(string Tongjitime="")
@@ -245,6 +248,59 @@
                tuiguangDTOs.Add(xiangmuDTO);
            #endregion



            #region 采购公告录入 
            TongjiBaoBiaoDTO caigougonggaoDTO = new TongjiBaoBiaoDTO();
            caigougonggaoDTO.gongzuo = "采购公告录入";
            //本月数量
            var caigougonggaoDTOsyue = _projectService.GetcaigougonggaoListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
            caigougonggaoDTO.benyueshuliang = caigougonggaoDTOsyue.Count.ToString();
            //本日数量
            var caigougonggaoDTOsri = caigougonggaoDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
            caigougonggaoDTO.benrishuliang = caigougonggaoDTOsri.Count.ToString();

            var jijianicaigougonggao = fiPiecerateDTOs.Where(x => x.Project == "采购公告录入").FirstOrDefault();

            if (jijianicaigougonggao != null)
            {
                var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianicaigougonggao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
                if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
                {
                    if (jixiaotichengfangan.Renwustandard == "01")
                    {
                        //本月规定
                        caigougonggaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                        //本日规定
                        caigougonggaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                        if (jixiaotichengfangan.Tichengstandard == "01")
                        {
                            decimal youxiaojijian = caigougonggaoDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                            if (youxiaojijian > 0)
                            {
                                caigougonggaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
                            }
                        }
                    }
                    else if (jixiaotichengfangan.Renwustandard == "02")
                    {
                        //本月规定
                        caigougonggaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
                        //if (jixiaotichengfangan.Tichengstandard == "01")
                        //{
                        //    decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu;
                        //    if (youxiaojijian > 0)
                        //    {
                        //        hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
                        //    }

                        //}
                    }
                }
            }
            if (caigougonggaoDTOsyue.Count > 0 || caigougonggaoDTOsri.Count > 0)
                tuiguangDTOs.Add(caigougonggaoDTO);
            #endregion

            #region 客户资料录入
            TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO();
@@ -987,7 +1043,7 @@
                }
                catch (Exception ex)
                {

                    zhucehuiyuanDTO.benyueshuliang = "0";
                }
                //var zhucehuiyuansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhucehuiyuan.Id).ToList();

@@ -1091,6 +1147,59 @@
            }
            if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0)
                tuiguangDTOs.Add(qianyueDTO);
            #endregion


            #region 专家录入
            TongjiBaoBiaoDTO zhuanjialuruDTO = new TongjiBaoBiaoDTO();
            zhuanjialuruDTO.gongzuo = "专家录入";
            //本月数量
            var zhuanjialuruDTOsyue = _expertService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
            zhuanjialuruDTO.benyueshuliang = zhuanjialuruDTOsyue.Count.ToString();
            //本日数量
            var zhuanjialuruDTOsri = zhuanjialuruDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
            zhuanjialuruDTO.benrishuliang = zhuanjialuruDTOsri.Count.ToString();

            var jijianizhuanjialuru = fiPiecerateDTOs.Where(x => x.Project == "专家录入").FirstOrDefault();

            if (jijianizhuanjialuru != null)
            {
                var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanjialuru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
                if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
                {
                    if (jixiaotichengfangan.Renwustandard == "01")
                    {

                        zhuanjialuruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                        zhuanjialuruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                        if (jixiaotichengfangan.Tichengstandard == "01")
                        {
                            decimal youxiaojijian = zhuanjialuruDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                            if (youxiaojijian > 0)
                            {
                                zhuanjialuruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
                            }

                        }

                    }
                    else if (jixiaotichengfangan.Renwustandard == "02")
                    {
                        zhuanjialuruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
                        //if (jixiaotichengfangan.Tichengstandard == "01")
                        //{
                        //    decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu;
                        //    if (youxiaojijian > 0)
                        //    {
                        //        hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
                        //    }

                        //}
                    }
                }
            }
            if (zhuanjialuruDTOsyue.Count > 0 || zhuanjialuruDTOsri.Count > 0)
                tuiguangDTOs.Add(zhuanjialuruDTO);
            #endregion


@@ -1214,7 +1323,7 @@
            var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0;

            //本日数量
            var dingdanDTOsri = dingdanDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
            var dingdanDTOsri = dingdanDTOsyue.Where(x =>( x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)) || (x.Wangongtime >= chauxnshijian.Date && x.Wangongtime < chauxnshijian.Date.AddDays(1)) ).ToList();
            foreach (var cooperOrderDTO in dingdanDTOsri)
            {
                TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO();
@@ -1953,6 +2062,58 @@
                        tuiguangDTOs.Add(xiangmuDTO);
                    #endregion


                    #region 采购公告录入 
                    TongjiBaoBiaoDTO caigougonggaoDTO = new TongjiBaoBiaoDTO();
                    caigougonggaoDTO.gongzuo = "采购公告录入";
                    //本月数量
                    var caigougonggaoDTOsyue = _projectService.GetcaigougonggaoListsalary(Userid, dateminkaoqin, datemaxkaoqin);
                    caigougonggaoDTO.benyueshuliang = caigougonggaoDTOsyue.Count.ToString();
                    //本日数量
                    var caigougonggaoDTOsri = caigougonggaoDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
                    caigougonggaoDTO.benrishuliang = caigougonggaoDTOsri.Count.ToString();

                    var jijianicaigougonggao = fiPiecerateDTOs.Where(x => x.Project == "采购公告录入").FirstOrDefault();

                    if (jijianicaigougonggao != null)
                    {
                        var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianicaigougonggao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
                        if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
                        {
                            if (jixiaotichengfangan.Renwustandard == "01")
                            {
                                //本月规定
                                caigougonggaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                                //本日规定
                                caigougonggaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                                if (jixiaotichengfangan.Tichengstandard == "01")
                                {
                                    decimal youxiaojijian = caigougonggaoDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                                    if (youxiaojijian > 0)
                                    {
                                        caigougonggaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
                                    }
                                }
                            }
                            else if (jixiaotichengfangan.Renwustandard == "02")
                            {
                                //本月规定
                                caigougonggaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
                                //if (jixiaotichengfangan.Tichengstandard == "01")
                                //{
                                //    decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu;
                                //    if (youxiaojijian > 0)
                                //    {
                                //        hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
                                //    }

                                //}
                            }
                        }
                    }
                    if (caigougonggaoDTOsyue.Count > 0 || caigougonggaoDTOsri.Count > 0)
                        tuiguangDTOs.Add(caigougonggaoDTO);
                    #endregion

                    #region 客户资料录入
                    TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO();
@@ -2695,7 +2856,7 @@
                        }
                        catch (Exception ex)
                        {

                            zhucehuiyuanDTO.benyueshuliang = "0";
                        }


@@ -2794,6 +2955,59 @@
                    }
                    if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0)
                        tuiguangDTOs.Add(qianyueDTO);
                    #endregion


                    #region 专家录入
                    TongjiBaoBiaoDTO zhuanjialuruDTO = new TongjiBaoBiaoDTO();
                    zhuanjialuruDTO.gongzuo = "专家录入";
                    //本月数量
                    var zhuanjialuruDTOsyue = _expertService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
                    zhuanjialuruDTO.benyueshuliang = zhuanjialuruDTOsyue.Count.ToString();
                    //本日数量
                    var zhuanjialuruDTOsri = zhuanjialuruDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
                    zhuanjialuruDTO.benrishuliang = zhuanjialuruDTOsri.Count.ToString();

                    var jijianizhuanjialuru = fiPiecerateDTOs.Where(x => x.Project == "专家录入").FirstOrDefault();

                    if (jijianizhuanjialuru != null)
                    {
                        var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanjialuru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
                        if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
                        {
                            if (jixiaotichengfangan.Renwustandard == "01")
                            {

                                zhuanjialuruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                                zhuanjialuruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                                if (jixiaotichengfangan.Tichengstandard == "01")
                                {
                                    decimal youxiaojijian = zhuanjialuruDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                                    if (youxiaojijian > 0)
                                    {
                                        zhuanjialuruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
                                    }

                                }

                            }
                            else if (jixiaotichengfangan.Renwustandard == "02")
                            {
                                zhuanjialuruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
                                //if (jixiaotichengfangan.Tichengstandard == "01")
                                //{
                                //    decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu;
                                //    if (youxiaojijian > 0)
                                //    {
                                //        hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
                                //    }

                                //}
                            }
                        }
                    }
                    if (zhuanjialuruDTOsyue.Count > 0 || zhuanjialuruDTOsri.Count > 0)
                        tuiguangDTOs.Add(zhuanjialuruDTO);
                    #endregion


@@ -2917,7 +3131,7 @@
                    var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0;

                    //本日数量
                    var dingdanDTOsri = dingdanDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
                    var dingdanDTOsri = dingdanDTOsyue.Where(x => (x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)) || (x.Wangongtime >= chauxnshijian.Date && x.Wangongtime < chauxnshijian.Date.AddDays(1))).ToList();
                    foreach (var cooperOrderDTO in dingdanDTOsri)
                    {
                        TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO();