From 876602afd2ed18f139f331c55a1cbf868e606b7b Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期日, 19 十月 2025 12:59:24 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/simoer_jiekou
---
zymes/OperationService/zymes_RealessUnit.cs | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessUnit.cs b/zymes/OperationService/zymes_RealessUnit.cs
index 582995f..c56552c 100644
--- a/zymes/OperationService/zymes_RealessUnit.cs
+++ b/zymes/OperationService/zymes_RealessUnit.cs
@@ -51,10 +51,11 @@
/*dialect*/
select a.FUNITID as HItemID,a.FUNITID as HERPItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
,1 as HLevel,'true' as HEndFlag,case when a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP瀵煎叆' as HRemark,getdate() as HMakeTime
- ,'true' as HStandard,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID
+ ,'true' as HStandard,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID,o.FNUMBER as HOrganNumber
from T_BD_UNIT a with(nolock)
inner join T_BD_UNIT_L l with(nolock) on a.FUNITID=l.FUNITID
- Where a.FUNITID={id}
+ INNER JOIN T_ORG_Organizations o on a.FUSEORGID=o.FORGID
+ Where l.FLOCALEID=2052 and a.FUNITID={id}
";
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
if (dt.Rows.Count == 0)
@@ -64,7 +65,7 @@
}
//鑾峰彇鍗曚綅鐨勪娇鐢ㄧ粍缁�
- DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HUSEORGID"].ToString());
+ DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
if (dataTable.Rows.Count == 0)
continue;
--
Gitblit v1.9.1