From 98f6ca14245a0952c0c52074ba1ecef5881bac24 Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期三, 13 五月 2026 11:14:18 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs | 18 +++++++-----------
1 files changed, 7 insertions(+), 11 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
index 9ce62e0..365bb45 100644
--- a/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
+++ b/WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
@@ -160,11 +160,7 @@
}
else if (costObject == "")
{
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "绗�" + index + "琛�,璇�" + HORGName + "缁勭粐,鎴愭湰瀵硅薄:" + costObject + ",涓虹┖";
- objJsonResult.data = null;
- return objJsonResult;
+ tb2.Rows[i]["HCostObjID"] = 0;
}
else
{
@@ -367,9 +363,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 +381,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 +410,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 +418,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