From 8a286d8dd894be550bd0ce9fd859781f98478747 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 20 七月 2021 15:15:04 +0800
Subject: [PATCH] 今日开发 客户资料。前端同步到后端 ，书城端和会员端都需要同步 绩效管理 菜单修改 绩效管理-我的报表，没有参与的大项，小项都不显示 绩效管理-工作报表 批量查询，批量打印
---
zhengcaioa/Services/CooperatecustomCustomerService.cs | 51 ++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 44 insertions(+), 7 deletions(-)
diff --git a/zhengcaioa/Services/CooperatecustomCustomerService.cs b/zhengcaioa/Services/CooperatecustomCustomerService.cs
index 368891e..0f51554 100644
--- a/zhengcaioa/Services/CooperatecustomCustomerService.cs
+++ b/zhengcaioa/Services/CooperatecustomCustomerService.cs
@@ -173,14 +173,26 @@
var query = (from a in _context.CooperatecustomCustomers
join b in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khly")
on a.Khly equals b.CodeSn
+ into bsss
+ from bbb in bsss.DefaultIfEmpty()
+
join c in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "hyfl")
on a.Hyfl equals c.CodeSn
+ into csss
+ from ccc in csss.DefaultIfEmpty()
+
join d in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khlx")
on a.Khlx equals d.CodeSn
+ into dsss
+ from ddd in dsss.DefaultIfEmpty()
+
+
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 i in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.ChedanStatus !="A" ).GroupBy(q => new { q.Khdw }).Select(q => new
{
Khdw = q.Key.Khdw,
@@ -191,9 +203,24 @@
on a.Id equals i.Khdw
into isss
from iii in isss.DefaultIfEmpty()
+
+
+
join f in _context.Areas on a.Sheng equals f.CodeId
+ into fsss
+ from fff in fsss.DefaultIfEmpty()
+
+
join g in _context.Areas on a.City equals g.CodeId
+ into gsss
+ from ggg in gsss.DefaultIfEmpty()
+
+
join h in _context.Areas on a.AreaId equals h.CodeId
+ into hsss
+ from hhh in hsss.DefaultIfEmpty()
+
+
where a.RecStatus == "A"
&& (string.IsNullOrWhiteSpace(searchEntity.Createtime) || (a.Createtime >= Createtimestart && a.Createtime <= Createtimeend))
@@ -218,12 +245,12 @@
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,
+ ShengName = fff.Name + "-" + ggg.Name+ "-" + hhh.Name,
+ CityName = ggg.Name,
+ AreaIdName = hhh.Name,
+ KhlyName = bbb.Comments,
+ HyflName = ccc.Comments,
+ KhlxName = ddd.Comments,
YwjlName = abi.UserName,
Name = a.Name,
Postal = a.Postal,
@@ -303,12 +330,22 @@
/// 鑾峰彇鎵�鏈夋湁鏁堝悎浣滃鎴�
/// </summary>
/// <returns></returns>
- public List<CooperatecustomCustomerDTO> GetList()
+ public List<CooperatecustomCustomerDTO> GetList(string HuiyuanId = "", string Name = "")
{
var listPosition = _context.CooperatecustomCustomers.Where(r => r.RecStatus == "A").ToList();
+ if (!string.IsNullOrEmpty(HuiyuanId))
+ {
+ listPosition = listPosition.Where(x => x.HuiyuanId == HuiyuanId).ToList();
+ }
+
+ if (!string.IsNullOrEmpty(Name))
+ {
+ listPosition = listPosition.Where(x => x.Name == Name).ToList();
+ }
+
var list = _mapper.Map<List<CooperatecustomCustomerDTO>>(listPosition);
return list;
}
--
Gitblit v1.9.1