From 98cd7063d9b9a1570dcfbac92f5c2b35d904868b Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 05 七月 2021 15:41:29 +0800
Subject: [PATCH] 修改修改
---
zhengcaioa/Services/IntentionVisitService.cs | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/IntentionVisitService.cs b/zhengcaioa/Services/IntentionVisitService.cs
index afa8354..62ad494 100644
--- a/zhengcaioa/Services/IntentionVisitService.cs
+++ b/zhengcaioa/Services/IntentionVisitService.cs
@@ -148,6 +148,11 @@
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()
+
@@ -162,6 +167,7 @@
&& (string.IsNullOrWhiteSpace(searchEntity.City) || zz.City == searchEntity.City.Trim())
&& (string.IsNullOrWhiteSpace(searchEntity.AreaId) || zz.AreaId == searchEntity.AreaId.Trim())
&& (string.IsNullOrWhiteSpace(searchEntity.Viscustomer) || a.Viscustomer == searchEntity.Viscustomer.Trim())
+ && (string.IsNullOrWhiteSpace(searchEntity.Creater) || zz.Creater == searchEntity.Creater.Trim())
select new IntentionVisitDTO
{
Id = a.Id,
@@ -181,6 +187,7 @@
Talk = a.Talk,
Khfk = a.Khfk,
Yx = a.Yx,
+ CreaterName = zzzzz.UserName,
Jy = a.Jy,
Creater = a.Creater,
--
Gitblit v1.9.1