工资绩效改版

username@email.com

2023-02-28 67a0042c5f29e4bb0e0b82f6190f2bc51480b45c

 zhengcaioa/Services/IntentionCustomerService.cs

@@ -49,12 +49,43 @@

            if (String.IsNullOrEmpty(intentionCustomer.Id))
            {
                    if (!string.IsNullOrEmpty(intentionCustomer.Ywjl))
                    {
                        intentionCustomer.Ywjltime = DateTime.Now;
                        var Cooper = _context.CooperatecustomCustomers.Count(x => x.RecStatus == "A" && x.Ywjl == intentionCustomer.Ywjl);
                        var Inten = _context.IntentionCustomers.Count(x => x.RecStatus == "A" && x.Ywjl == intentionCustomer.Ywjl);
                        if(Cooper+ Inten > 2000)
                        {
                            resultEntity.Result = false;
                            resultEntity.Message = "该业务经理，客户单位和合作客户合计超过2000！";
                            return resultEntity;
                        }
                    }

                    intentionCustomer.Id = Guid.NewGuid().ToString();
                _context.IntentionCustomers.Add(intentionCustomer);
            }
            else
            {
                var updateproject = _context.IntentionCustomers.Find(intentionCustomer.Id);
                    var updateproject = _context.IntentionCustomers.Find(intentionCustomer.Id);
                    if (!string.IsNullOrEmpty(intentionCustomer.Ywjl) && (string.IsNullOrEmpty(updateproject.Ywjl) || !string.IsNullOrEmpty(updateproject.Ywjl) && intentionCustomer.Ywjl!= updateproject.Ywjl ))
                    {
                        updateproject.Ywjltime = DateTime.Now;
                        var Cooper = _context.CooperatecustomCustomers.Count(x => x.RecStatus == "A" && x.Ywjl == intentionCustomer.Ywjl);
                        var Inten = _context.IntentionCustomers.Count(x => x.RecStatus == "A" && x.Ywjl == intentionCustomer.Ywjl);
                        if (Cooper + Inten >= 2000)
                        {
                            resultEntity.Result = false;
                            resultEntity.Message = "该业务经理，客户单位和合作客户合计超过2000！";
                            return resultEntity;
                        }
                    }

                    if (string.IsNullOrEmpty(intentionCustomer.Ywjl)){
                        updateproject.Ywjltime = null;
                    }



                updateproject.Sheng = intentionCustomer.Sheng;
                updateproject.City = intentionCustomer.City;
@@ -214,25 +245,25 @@


            var query = (from a in _context.IntentionCustomers
                     join b in listCode.Where(x => x.CodeTable == "IntentionCustomer" && x.CodeField == "khly")
                     on a.Khly equals b.CodeSn
                     join c in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "hyfl")
                     on a.Hyfl equals c.CodeSn
                     join d in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khlx")
                    on a.Khlx equals d.CodeSn
                     join e in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" && x.IsYwjl == "A")
                     on a.Ywjl equals e.Id
                     into esss
                     from abi in esss.DefaultIfEmpty()
                    // join b in listCode.Where(x => x.CodeTable == "IntentionCustomer" && x.CodeField == "khly")
                    // on a.Khly equals b.CodeSn
                    // join c in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "hyfl")
                    // on a.Hyfl equals c.CodeSn
                    // join d in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khlx")
                    //on a.Khlx equals d.CodeSn
                    // join e in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" && x.IsYwjl == "A")
                    // on a.Ywjl equals e.Id
                    // into esss
                    // from abi in esss.DefaultIfEmpty()

                             join f in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" )
                            on a.Dianxiaozhuanyuan equals f.Id
                            into fsss
                             from fff in fsss.DefaultIfEmpty()
                    //         join f in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" )
                    //        on a.Dianxiaozhuanyuan equals f.Id
                    //        into fsss
                    //         from fff in fsss.DefaultIfEmpty()

                             join f in _context.Areas on a.Sheng equals f.CodeId
                     join g in _context.Areas on a.City equals g.CodeId
                     join h in _context.Areas on a.AreaId equals h.CodeId
                    //         join f in _context.Areas on a.Sheng equals f.CodeId
                    // join g in _context.Areas on a.City equals g.CodeId
                    // join h in _context.Areas on a.AreaId equals h.CodeId


                         join l in _context.IntentionVisits.Where(x => x.RecStatus == "A").GroupBy(q => new { q.Viscustomer }).Select(q => new
@@ -250,7 +281,7 @@
                      && (string.IsNullOrWhiteSpace(searchEntity.Khly) || a.Khly == searchEntity.Khly.Trim())
                       && (string.IsNullOrWhiteSpace(searchEntity.Hyfl) || a.Hyfl == searchEntity.Hyfl.Trim())
                        && (string.IsNullOrWhiteSpace(searchEntity.Khlx) || a.Khlx == searchEntity.Khlx.Trim())
                         && (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || a.Ywjl == searchEntity.Ywjl.Trim())
                         //&& (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || a.Ywjl == searchEntity.Ywjl.Trim())
                          && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || a.Sheng == searchEntity.Sheng.Trim())
                           && (string.IsNullOrWhiteSpace(searchEntity.City) || a.City == searchEntity.City.Trim())
                            && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || a.AreaId == searchEntity.AreaId.Trim())
@@ -274,13 +305,13 @@
                         Hyfl = a.Hyfl,
                         Khlx = a.Khlx,
                         Ywjl = a.Ywjl,
                         ShengName = f.Name + "-" + g.Name + "-" + h.Name,
                         CityName = g.Name,
                         AreaIdName = h.Name,
                         KhlyName = b.Comments,
                         HyflName = c.Comments,
                         KhlxName = d.Comments,
                         YwjlName = abi.UserName,
                         //ShengName = f.Name + "-" + g.Name + "-" + h.Name,
                         //CityName = g.Name,
                         //AreaIdName = h.Name,
                         //KhlyName = b.Comments,
                         //HyflName = c.Comments,
                         //KhlxName = d.Comments,
                         //YwjlName = abi.UserName,
                         Name = a.Name,
                         Postal = a.Postal,
                         Address = a.Address,
@@ -317,7 +348,7 @@
                                 YixiangtimeName = a.Yixiangtime.HasValue? a.Yixiangtime.Value.ToString("yyyy-MM-dd"):"",
                                 Yixiang = a.Yixiang,
                                 Dianxiaozhuanyuan = a.Dianxiaozhuanyuan,
                                 DianxiaozhuanyuanName = fff.UserName,
                                 //DianxiaozhuanyuanName = fff.UserName,
                                 Zuijinzhuizongtime = a.Zuijinzhuizongtime,
                                 ZuijinzhuizongtimeName = a.Zuijinzhuizongtime.HasValue ? a.Zuijinzhuizongtime.Value.ToString("yyyy-MM-dd") : "",
                             Visittimes = lll.Visittimes,
@@ -328,6 +359,20 @@
            {
                query = query.Where( a=>a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim());
            }

            if (!string.IsNullOrWhiteSpace(searchEntity.Ywjl))
            {
                if(searchEntity.Ywjl != "11111")
                {
                    query = query.Where(a => a.Ywjl == searchEntity.Ywjl.Trim());
                }else
                {
                    query = query.Where(a => a.Ywjl == null   );
                }

              
            }

            if (!string.IsNullOrWhiteSpace(searchEntity.ShifouDianhua))
            {
                if (searchEntity.ShifouDianhua != "A")
@@ -358,6 +403,71 @@
            searchEntity.totalrows = query.Count();
        var lianlist = query.OrderByDescending(x => x.Modifytime).Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();

            if(lianlist!=null && lianlist.Count > 0)
            {
                var areas = _context.Areas;
                var pltUsers = _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A");

                var khly = listCode.Where(x => x.CodeTable == "IntentionCustomer" && x.CodeField == "khly");


                var hyfl = listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "hyfl");


                var khlx = listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khlx");


                foreach (var intentionCustomerDTO in lianlist)
                {
                  var sheng =  areas.Where(x => x.CodeId == intentionCustomerDTO.Sheng).FirstOrDefault();
                    var city = areas.Where(x => x.CodeId == intentionCustomerDTO.City).FirstOrDefault();
                    var Area = areas.Where(x => x.CodeId == intentionCustomerDTO.AreaId).FirstOrDefault();
                    if (sheng != null)
                    {
                        intentionCustomerDTO.ShengName = sheng.Name;
                    }
                    if (city != null)
                    {
                        intentionCustomerDTO.CityName = city.Name;
                        intentionCustomerDTO.ShengName += "-" + city.Name;
                    }
                    if (Area != null)
                    {
                        intentionCustomerDTO.AreaIdName = Area.Name;
                        intentionCustomerDTO.ShengName += "-" + Area.Name;
                    }
                   var ywjl  = pltUsers.Where(x => x.Id == intentionCustomerDTO.Ywjl).FirstOrDefault();
                    if (ywjl != null)
                    {
                        intentionCustomerDTO.YwjlName = ywjl.UserName;
                    }
                    var Dianxiaozhuanyuan = pltUsers.Where(x => x.Id == intentionCustomerDTO.Dianxiaozhuanyuan).FirstOrDefault();
                    if (Dianxiaozhuanyuan != null)
                    {
                        intentionCustomerDTO.DianxiaozhuanyuanName = Dianxiaozhuanyuan.UserName;
                    }
                    var KhlyName = khly.Where(x => x.CodeSn == intentionCustomerDTO.Khly).FirstOrDefault();
                    if (KhlyName != null)
                    {
                        intentionCustomerDTO.KhlyName = KhlyName.Comments;
                    }
                    var HyflName = hyfl.Where(x => x.CodeSn == intentionCustomerDTO.Hyfl).FirstOrDefault();
                    if (HyflName != null)
                    {
                        intentionCustomerDTO.HyflName = HyflName.Comments;
                    }
                    var KhlxName = khlx.Where(x => x.CodeSn == intentionCustomerDTO.Khlx).FirstOrDefault();
                    if (KhlxName != null)
                    {
                        intentionCustomerDTO.KhlxName = KhlxName.Comments;
                    }


                    intentionCustomerDTO.Guanliankehushu = _context.CustomerGuanlians.Count(x => x.CustomerId == intentionCustomerDTO.Id);
                }
            }

          

            //foreach (var intentionCustomerDTO in lianlist)
            //{
@@ -365,7 +475,7 @@
            //}


            data.LoadData(searchEntity, lianlist);
                data.LoadData(searchEntity, lianlist);
        return data;
    }

@@ -400,21 +510,35 @@
        /// 获取所有有效意向客户
        /// </summary>
        /// <returns></returns>
        public List<IntentionCustomerDTO> GetList()
        public List<IntentionCustomerDTO> GetList(string huiyuanId = null)
        {
            List<IntentionCustomerDTO> intentionCustomerDTOs = (List<IntentionCustomerDTO>)CacheHelperNetCore.CacheValue("intentionCustomerDTOs");
             

            if (intentionCustomerDTOs != null && intentionCustomerDTOs.Count > 0)
            {
                if (!string.IsNullOrEmpty(huiyuanId))
                {
                    intentionCustomerDTOs = intentionCustomerDTOs.Where(x => x.HuiyuanId == huiyuanId).ToList();
                }

                
                return intentionCustomerDTOs;
            }


            var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A").ToList();

            intentionCustomerDTOs = _mapper.Map<List<IntentionCustomerDTO>>(listPosition);
            CacheHelperNetCore.CacheInsert("intentionCustomerDTOs", intentionCustomerDTOs);

            var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition);
            return list;

            if (!string.IsNullOrEmpty(huiyuanId))
            {
                intentionCustomerDTOs = intentionCustomerDTOs.Where(x => x.HuiyuanId == huiyuanId).ToList();
            }

            return intentionCustomerDTOs;
        }

        /// <summary>