From 3984be8b16325365e12260a2c20912e073230be0 Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期五, 27 二月 2026 17:17:15 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/仓存管理/领料发货/Kf_StockOutRequestBillController.cs | 63 +++++++++++++++++++++++++++++++
1 files changed, 63 insertions(+), 0 deletions(-)
diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs"
index 736ed46..aef9728 100644
--- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs"
+++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs"
@@ -304,6 +304,69 @@
#endregion
+ #region 鍑哄簱鐢宠鍗� - 鎵樻暟鍙樻洿鍔熻兘
+ [Route("Kf_StockOutRequestBill/UpdatePallet")]
+ [HttpPost]
+ public object UpdatePallet([FromBody] JObject data)
+ {
+ try
+ {
+ long hmainid = data["hmainid"]?.ToObject<long>() ?? 0;
+ int newPallet = data["newPallet"]?.ToObject<int>() ?? 0;
+ string operatorName = data["operator"]?.ToString() ?? "";
+
+ if (hmainid <= 0)
+ return new { code = "0", count = 0, Message = "鍗曟嵁ID涓嶈兘涓虹┖锛�" };
+
+ if (newPallet <= 0)
+ return new { code = "0", count = 0, Message = "鎵樻暟蹇呴』澶т簬0锛�" };
+
+ // 妫�鏌ユ槸鍚﹀凡瀹℃牳 - 鏀逛负妫�鏌ュ嚭搴撶敵璇峰崟涓昏〃
+ string checkAuditSql = $@"
+ SELECT COUNT(*) as HasAudit
+ FROM Kf_StockOutRequestBillMain
+ WHERE HInterID = {hmainid}
+ AND HChecker IS NOT NULL
+ AND HCheckDate IS NOT NULL";
+
+ DataSet dsAudit = oCn.RunProcReturn(checkAuditSql, "CheckAudit");
+
+ if (dsAudit != null && dsAudit.Tables[0].Rows.Count > 0)
+ {
+ int hasAudit = Convert.ToInt32(dsAudit.Tables[0].Rows[0]["HasAudit"]);
+ if (hasAudit > 0)
+ {
+ return new { code = "0", count = 0, Message = "鍗曟嵁宸插鏍革紝涓嶈兘淇敼鎵樻暟锛�" };
+ }
+ }
+
+ // 鐩存帴鏇存柊鎵樻暟 - 鏀逛负鏇存柊鍑哄簱鐢宠鍗曚富琛�
+ string updateSql = $@"
+ UPDATE Kf_StockOutRequestBillMain
+ SET HPackQtys = {newPallet}
+ WHERE HInterID = {hmainid}";
+
+ oCn.RunProc(updateSql); // 鐩存帴璋冪敤锛屼笉璧嬪�肩粰鍙橀噺
+
+ return new
+ {
+ code = "1",
+ count = 1,
+ Message = "鎵樻暟淇敼鎴愬姛锛�"
+ };
+ }
+ catch (Exception e)
+ {
+ return new
+ {
+ code = "0",
+ count = 0,
+ Message = "淇敼澶辫触锛�" + e.Message
+ };
+ }
+ }
+ #endregion
+
#region 鍑哄簱鐢宠鍗曞垪琛�
[Route("Kf_StockOutRequestBill/cx")]
[HttpGet]
--
Gitblit v1.9.1