From fe7436c222a6e5905beccc4464a496288638afba Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期四, 02 四月 2026 15:38:22 +0800
Subject: [PATCH] 11
---
WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
index 9ce62e0..555fe7a 100644
--- a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
+++ b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
@@ -367,9 +367,9 @@
int HProcID = int.Parse(item["HProcID"].ToString()); //宸ュ簭ID
Double HBeginQty = Double.Parse(item["鏈熷垵鏁伴噺"].ToString());
Double HBeginBal = Double.Parse(item["鏈熷垵閲戦"].ToString());
-
+ Double HPanelQty = Double.Parse(item["鎷兼澘鏁�"].ToString());
// 1. 妫�鏌ヤ富琛ㄦ槸鍚﹀瓨鍦ㄨ褰�
- string checkMainSql = $"select HInterID from Kf_WIPBalMain where HOrgID='{HOrgID}' and HWorkShopID={HWorkShopID} and HCostObjID={HCostObjID}";
+ string checkMainSql = $"select HInterID from Kf_WIPBalMain where HOrgID='{HOrgID}' and HWorkShopID={HWorkShopID} and HCostObjID={HCostObjID} and HYear ={HYear} and HPeriod = {HPeriod}";
DataSet ds = oCN.RunProcReturn(checkMainSql, "Kf_WIPBalMain");
int HInterID;
@@ -385,11 +385,11 @@
// 鎻掑叆涓昏〃
string insertMainSql = $@"
insert into Kf_WIPBalMain
- ( HYear, HPeriod, HCostCenterID, HWorkShopID, HCostObjID,
+ (HInterID, HYear, HPeriod, HCostCenterID, HWorkShopID, HCostObjID,
HICMOInterID, HProcExchInterID, HProcExchEntryID, HIsBack, HBatchNo,
HMaker, HMakeDate, HOrgID)
values
- ( {HYear}, {HPeriod}, 0, {HWorkShopID}, {HCostObjID},
+ ({HInterID},{HYear}, {HPeriod}, 0, {HWorkShopID}, {HCostObjID},
0, 0, 0, 0, '',
'{user}', getdate(), '{HOrgID}')";
@@ -414,7 +414,7 @@
HBeginBal, HCnangeBal, HDebit, HDebit_Sum, HCredit,
HEndBal, HEndBal_Rel, HYtdDebit, HYtdCredit,
HBeginDiff, HReceiveDiff, HSendDiff, HEndDiff,
- HYtdReceiveDiff, HYtdSendDiff)
+ HYtdReceiveDiff, HYtdSendDiff,HPanelQty)
values
({HInterID}, {HEntryID}, {HCostItemID}, {HMaterID}, {HProcID}, 0,
{HBeginQty}, 0, 0, 0, 0,
@@ -422,7 +422,7 @@
{HBeginBal}, 0, 0, 0, 0,
0, 0, 0, 0,
0, 0, 0, 0,
- 0, 0)";
+ 0, 0,{HPanelQty})";
oCN.RunProc(insertSubSql);
--
Gitblit v1.9.1