From 439f10462e6b1ab0ebd454f53c2156c6fab24266 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 14 十一月 2022 11:12:46 +0800
Subject: [PATCH] 抓取的项目， 已确认，未确认 未确认为橙色 客户档案管理 有无手机号，未确认为橙色 客户资料页面查看访问记录
---
zhengcaioa/Services/CooperVisitService.cs | 13 ++++++++-----
1 files changed, 8 insertions(+), 5 deletions(-)
diff --git a/zhengcaioa/Services/CooperVisitService.cs b/zhengcaioa/Services/CooperVisitService.cs
index 27ccb94..d5c2448 100644
--- a/zhengcaioa/Services/CooperVisitService.cs
+++ b/zhengcaioa/Services/CooperVisitService.cs
@@ -156,12 +156,15 @@
join zz in _context.CooperatecustomCustomers
on a.Viscustomer equals zz.Id
-
- //join g in _context.Areas on zz.Sheng equals g.CodeId
- //join h in _context.Areas on zz.City equals h.CodeId
- //join i in _context.Areas on zz.AreaId equals i.CodeId
+ //join g in _context.Areas on zz.Sheng equals g.CodeId
+ //join h in _context.Areas on zz.City equals h.CodeId
+ //join i in _context.Areas on zz.AreaId equals i.CodeId
+ join zzz in _context.PltUsers.Where(x => x.RecStatus == "A")
+ on a.Creater equals zzz.Id
+ into zsssss
+ from zzzzz in zsssss.DefaultIfEmpty()
where a.RecStatus == "A"
@@ -198,7 +201,7 @@
Jy = a.Jy,
Creater = a.Creater,
Createtime = a.Createtime,
-
+ CreaterName = zzzzz.UserName,
RecStatus = a.RecStatus,
Modifier = a.Modifier,
Modifytime = a.Modifytime,
--
Gitblit v1.9.1