From 0586ecbff59bccae701b9684211d4e1213b21b2b Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期六, 17 十二月 2022 12:42:05 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/simoer_jiekou into master
---
zymes/OperationService/zymes_RealessOperator.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessOperator.cs b/zymes/OperationService/zymes_RealessOperator.cs
index 8d5a62d..f0b966b 100644
--- a/zymes/OperationService/zymes_RealessOperator.cs
+++ b/zymes/OperationService/zymes_RealessOperator.cs
@@ -53,11 +53,12 @@
string sql =string.Empty;
sql = $@"
/*dialect*/
-select a.FENTRYID as HItemID,a.FNUMBER as HNumber,l.FNAME as HName,'' as HHelpCode,a.FNUMBER as HShortNumber,0 as HParentID
+select a.FENTRYID as HItemID,st.FNUMBER as HNumber,l.FNAME as HName,'' as HHelpCode,st.FNUMBER as HShortNumber,0 as HParentID
,1 as HLevel,'true' as HEndFlag,'false' as HStopflag,'CLD-ERP瀵煎叆' as HRemark,'' as HUseFlag,0 as HUSEORGID
,a.FOPERATORID as HOperatorId,a.FOPERATORTYPE as HOperatorType,a.FSEQ as HSEQ,a.FSTAFFID as HStaffId,a.FISUSE as HIsUse
from T_BD_OPERATORENTRY a with(nolock)
inner join T_BD_OPERATORENTRY_L l with(nolock) on a.FENTRYID=l.FENTRYID and FLOCALEID=2052
+left join T_BD_STAFF st on a.FSTAFFID = st.FSTAFFID
Where a.FOPERATORID={id}
";
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
--
Gitblit v1.9.1