From 29b96ccc6047d2234aa042bb38f1c1e0b5505901 Mon Sep 17 00:00:00 2001
From: wangyi <2946747746@qq.com>
Date: 星期一, 19 一月 2026 15:43:51 +0800
Subject: [PATCH] 托数问题修复
---
WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs | 19 ++++++++++++-------
1 files changed, 12 insertions(+), 7 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs
index 6d28daa..ff7017c 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs
@@ -503,6 +503,7 @@
#region 鍣ㄥ叿鍑哄簱鐢宠鍗� - 鎵樻暟鍙樻洿鍔熻兘
[Route("Sc_MouldOutRequestBillController/UpdatePallet")]
[HttpPost]
+
public object UpdatePallet([FromBody] JObject data)
{
try
@@ -517,24 +518,28 @@
if (newPallet <= 0)
return new { code = "0", count = 0, Message = "鎵樻暟蹇呴』澶т簬0锛�" };
- // 妫�鏌ユ槸鍚﹀凡瀹℃牳
+
string checkAuditSql = $@"
- SELECT COUNT(*) as HasAudit
+ SELECT HBillStatus
FROM Sc_MouldOutRequestBillMain
- WHERE HInterID = {hmainid}
- AND HChecker IS NOT NULL
- AND HCheckDate IS NOT NULL";
+ WHERE HInterID = {hmainid}";
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)
+ int hBillStatus = Convert.ToInt32(dsAudit.Tables[0].Rows[0]["HBillStatus"]);
+ // 鉁� 姝ｇ‘鐨勫垽鏂細HBillStatus = 2 琛ㄧず宸插鏍�
+ if (hBillStatus == 2)
{
return new { code = "0", count = 0, Message = "鍗曟嵁宸插鏍革紝涓嶈兘淇敼鎵樻暟锛�" };
}
}
+ else
+ {
+ return new { code = "0", count = 0, Message = "鍗曟嵁涓嶅瓨鍦紒" };
+ }
+
// 鐩存帴鏇存柊鎵樻暟
string updateSql = $@"
UPDATE Sc_MouldOutRequestBillMain
--
Gitblit v1.9.1