From 87e0fae22046ea3e99ba28aa55a43e32a3113494 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期三, 15 十月 2025 15:18:36 +0800
Subject: [PATCH] 生产领料单 同步插件 接口优化
---
zymes/OperationService/zymes_RealessPrdReceive.cs | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessPrdReceive.cs b/zymes/OperationService/zymes_RealessPrdReceive.cs
index 67cf730..066619f 100644
--- a/zymes/OperationService/zymes_RealessPrdReceive.cs
+++ b/zymes/OperationService/zymes_RealessPrdReceive.cs
@@ -67,8 +67,12 @@
, a.FDATE as HDate, YEAR(a.FDATE) as HYear, MONTH(a.FDATE) as HPeriod, 'CLOUD瀵煎叆' as HRemark
, a.FCREATORID as HMaker, a.FCREATEDATE as HMakeDate, 0 as HSupID, FSTOCKERID as HWHID, 0 as HSCWHID
, a.FPICKERID as HEmpID, 0 as HManagerID, a.FPICKERID as HSecManagerID, a.FSTOCKERID as HKeeperID
- , 0 as HDeptID, 'CLOUD瀵煎叆' as HExplanation, a.FBILLNO as HInnerBillNo, CONVERT(bit, 0) as HRedBlueFlag
- ,o.FNUMBER as HOrganNumber
+ , 0 as HDeptID, 'CLOUD瀵煎叆' as HExplanation, a.FBILLNO as HInnerBillNo, 1 as HRedBlueFlag
+ ,o.FNUMBER as HOrganNumber,a.FAPPROVERID as HChecker,a.FAPPROVEDATE as HCheckDate,
+ (select top 1 b.FWORKSHOPID
+ from T_PRD_PICKMTRLDATA b with(nolock)
+ where b.FID = a.FID
+ order by b.FID) as HDeptID
from T_PRD_PICKMTRL a with(nolock)
inner join T_ORG_Organizations o with (nolock) on a.FSTOCKORGID = o.FORGID
Where a.FID={id}
--
Gitblit v1.9.1