From 3f1a057e6843aa80630e90bfd4a6f646c870d09e Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期一, 27 四月 2026 09:49:20 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
index 9ad48a8..555fe7a 100644
--- a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
+++ b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
@@ -365,11 +365,11 @@
int HCostItemID = int.Parse(item["HCostItemID"].ToString()); //鎴愭湰椤圭洰ID
int HMaterID = int.Parse(item["HMaterID"].ToString()); //鐗╂枡ID
int HProcID = int.Parse(item["HProcID"].ToString()); //宸ュ簭ID
- int HBeginQty = int.Parse(item["鏈熷垵鏁伴噺"].ToString());
- int HBeginBal = int.Parse(item["鏈熷垵閲戦"].ToString());
-
+ 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