From d4431c7e89865a506af8662244004d0baa7ed609 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 11 六月 2025 12:24:15 +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