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 | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
index 62b71ce..555fe7a 100644
--- a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
+++ b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
@@ -369,7 +369,7 @@
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}')";
--
Gitblit v1.9.1