业务经理意向和合作客户只能1000，90天意向不转合作就制空业务经理，查询没有业务经理的档案客户和合作客户

username@email.com

2023-01-04 5421f9a6e5e2b28cc32aa8aa6dec9becd0c1eb3c

 zhengcaioa/Services/CooperatecustomCustomerService.cs

@@ -55,12 +55,43 @@

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

                    cooperatecustomCustomer.Id = Guid.NewGuid().ToString();
                    _context.CooperatecustomCustomers.Add(cooperatecustomCustomer);
                }
                else
                {
                    var updateproject = _context.CooperatecustomCustomers.Find(cooperatecustomCustomer.Id);

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


                    updateproject.Sheng = cooperatecustomCustomer.Sheng;
                    updateproject.City = cooperatecustomCustomer.City;
@@ -272,7 +303,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())
@@ -340,9 +371,21 @@
                             Taocanjianshu = a.Taocanjianshu ?? 0,
                             Customertype = "合作客户",
                         }
                        ).OrderByDescending(x => x.Modifytime).ToList();
                        );

            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 (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
@@ -350,7 +393,7 @@
            data.Heji2 = Math.Round(query.Sum(x => x.Shouxinedu) ?? 0, 2);
            data.Heji3 = Math.Round(query.Sum(x => x.Shenyushouxin) ?? 0, 2);
            data.Heji4 = Math.Round(query.Sum(x => x.Moneycountde) ?? 0, 2);
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            var lianlist = query.OrderByDescending(x => x.Modifytime).Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.Yufukuan) ?? 0, 2);
            data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Shouxinedu) ?? 0, 2);
            data.DangyeHeji3 = Math.Round(lianlist.Sum(x => x.Shenyushouxin) ?? 0, 2);