From eacd4c4f0581f1c4b55f7f0c7f1092b3f965a6f8 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 29 三月 2023 14:04:58 +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