From 7b30c6a4efb1762cf08153077cf4a8906eb79a59 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期四, 16 十月 2025 15:54:57 +0800
Subject: [PATCH] 新增 采购入库单 审核同步 接口
---
WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs | 94 ++--------------------------------------------
1 files changed, 5 insertions(+), 89 deletions(-)
diff --git a/WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs b/WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs
index 770ad6d..e5006c0 100644
--- a/WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs
+++ b/WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs
@@ -2102,9 +2102,9 @@
public object Kf_POStockInBillSaveApi([FromBody] JObject sMainSub)
{
try
- {
+ {
oCN.BeginTran();
- LogService.Write("鐢熶骇鍏ュ簱鍗曞悓姝�,淇濆瓨鏂规硶鎵ц锛�" + sMainSub.ToString());
+ LogService.Write("閲囪喘鍏ュ簱鍗曞悓姝�,淇濆瓨鏂规硶鎵ц锛�" + sMainSub.ToString());
var model = sMainSub["model"].ToString();
var entry = sMainSub["model"]["HENTRY"].ToString();
@@ -2113,8 +2113,7 @@
List<ClsKf_ICStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ICStockBillMain>>(model);
List<ClsKf_ICStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ICStockBillSub>>(entry);
-
- // 鍒ゆ柇 鏁版嵁搴撲腑鏄惁瀛樺湪id鍜屽崟鎹彿鐩哥瓑鐨勬墦鍗曟嵁锛屽瓨鍦紝鍒欓噸寤猴紝鍙湁id鍙风浉绛夛紝鍒欑敵璇锋柊鐨刬d鍙�
+ // 鍒ゆ柇 鏁版嵁搴撲腑鏄惁瀛樺湪id鍜屽崟鎹彿鐩哥瓑鐨勫崟鎹紝瀛樺湪锛屽垯閲嶅缓锛屽彧鏈塱d鍙风浉绛夛紝鍒欑敵璇锋柊鐨刬d鍙�
var ds1 = oCN.RunProcReturn($@"
select hmainid HInterID, 鍗曟嵁鍙� HBillNO from h_v_Kf_POStockInBillList where hmainid = {mainList[0].HInterID}
", "h_v_Kf_POStockInBillList");
@@ -2142,7 +2141,7 @@
}
}
-
+
// 涓昏〃
// 涓昏〃鎻掑叆
oCN.RunProc($@"Insert Into Kf_ICStockBillMain
@@ -2185,90 +2184,7 @@
// 瀛愯〃鎻掑叆
foreach (var osub in subList)
{
-
- LogService.Write($@"Insert into Kf_ICStockBillSub
- (HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice
- ,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo
- ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
- ,HPOOrderInterID,HPOOrderEntryID ,HPOOrderBillNo
- ,HPropertyID,HSecUnitID,HSecUnitRate,HPlanMode,HRemark,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo
- ,HTaxRate,HTaxPrice,HlineTotal)
- values (
- '{osub.HInterID}',
- '{osub.HEntryID}',
- '{osub.HMaterID}',
- '{osub.HUnitID}',
- '{osub.HQtyMust}',
- '{osub.HQty}',
- '{osub.HPrice}',
- '{osub.HMoney}',
- '{osub.HOrderPrice}',
- '{osub.HWHID}',
- '{osub.HSPID}',
- '{osub.HRelationQty}',
- '{osub.HBatchNo}',
- '{osub.HSourceInterID}',
- '{osub.HSourceEntryID}',
- '{osub.HSourceBillNo}',
- '{osub.HSourceBillType}',
- '{osub.HPOOrderInterID}',
- '{osub.HPOOrderEntryID}',
- '{osub.HPOOrderBillNo}',
- '{osub.HPropertyID}',
- '{osub.HSecUnitID}',
- '{osub.HSecUnitRate}',
- '{osub.HPlanMode}',
- '{osub.HRemark}',
- '{osub.HSeOrderInterID}',
- '{osub.HSeOrderEntryID}',
- '{osub.HSeOrderBillNo}',
- '{osub.HTaxRate}',
- '{osub.HTaxPrice}',
- '{osub.HlineTotal}'
- )
- ");
-
- LogService.Write($@"Insert into Kf_ICStockBillSub
- (HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice
- ,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo
- ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
- ,HPOOrderInterID,HPOOrderEntryID ,HPOOrderBillNo
- ,HPropertyID,HSecUnitID,HSecUnitRate,HPlanMode,HRemark,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo
- ,HTaxRate,HTaxPrice,HlineTotal)
- values (
- '{osub.HInterID}',
- '{osub.HEntryID}',
- '{osub.HMaterID}',
- '{osub.HUnitID}',
- '{osub.HQtyMust}',
- '{osub.HQty}',
- '{osub.HPrice}',
- '{osub.HMoney}',
- '{osub.HOrderPrice}',
- '{osub.HWHID}',
- '{osub.HSPID}',
- '{osub.HRelationQty}',
- '{osub.HBatchNo}',
- '{osub.HSourceInterID}',
- '{osub.HSourceEntryID}',
- '{osub.HSourceBillNo}',
- '{osub.HSourceBillType}',
- '{osub.HPOOrderInterID}',
- '{osub.HPOOrderEntryID}',
- '{osub.HPOOrderBillNo}',
- '{osub.HPropertyID}',
- '{osub.HSecUnitID}',
- '{osub.HSecUnitRate}',
- '{osub.HPlanMode}',
- '{osub.HRemark}',
- '{osub.HSeOrderInterID}',
- '{osub.HSeOrderEntryID}',
- '{osub.HSeOrderBillNo}',
- '{osub.HTaxRate}',
- '{osub.HTaxPrice}',
- '{osub.HlineTotal}'
- )
- ");
+
oCN.RunProc($@"Insert into Kf_ICStockBillSub
(HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice
,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo
--
Gitblit v1.9.1