业务经理查询客户接口

username@email.com

2023-03-08 f7a2d28869cc31c7dbe057a1d80dd40536d97fed

 zhengcaioa/Services/IntentionCustomerService.cs

@@ -54,10 +54,10 @@
                        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 >= 1000)
                        if(Cooper+ Inten > 2000)
                        {
                            resultEntity.Result = false;
                            resultEntity.Message = "该业务经理，客户单位和合作客户合计超过1000！";
                            resultEntity.Message = "该业务经理，客户单位和合作客户合计超过2000！";
                            return resultEntity;
                        }
                    }
@@ -73,10 +73,10 @@
                        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 >= 1000)
                        if (Cooper + Inten >= 2000)
                        {
                            resultEntity.Result = false;
                            resultEntity.Message = "该业务经理，客户单位和合作客户合计超过1000！";
                            resultEntity.Message = "该业务经理，客户单位和合作客户合计超过2000！";
                            return resultEntity;
                        }
                    }
@@ -162,7 +162,7 @@

        var entity = _context.IntentionCustomers.Find(id);

            if (entity.RecStatus != "A")
            if (entity ==null || entity.RecStatus != "A")
            {
                entity = new IntentionCustomer();
            }
@@ -245,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
@@ -305,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,
@@ -348,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,
@@ -403,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)
            //{
@@ -410,7 +475,7 @@
            //}


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

@@ -445,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>
@@ -513,5 +592,40 @@
            return list;
        }

        public ResultEntity saveKhlx(CooperatecustomCustomerDTO cooperatecustomCustomerDTO)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {






                var updateproject = _context.IntentionCustomers.Find(cooperatecustomCustomerDTO.Id);


                updateproject.Khlx = cooperatecustomCustomerDTO.Khlx;

                updateproject.Modifier = cooperatecustomCustomerDTO.Modifier;
                updateproject.Modifytime = cooperatecustomCustomerDTO.Modifytime;


                _context.SaveChanges();


                resultEntity.ReturnID = cooperatecustomCustomerDTO.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }

    }
}