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_MouldInRequestBillController.cs | 22 +++++++++++++---------
1 files changed, 13 insertions(+), 9 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldInRequestBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldInRequestBillController.cs
index fdba6e0..d877a7d 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldInRequestBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldInRequestBillController.cs
@@ -353,27 +353,31 @@
if (newPallet <= 0)
return new { code = "0", count = 0, Message = "鎵樻暟蹇呴』澶т簬0锛�" };
- // 妫�鏌ユ槸鍚﹀凡瀹℃牳
+
string checkAuditSql = $@"
- SELECT COUNT(*) as HasAudit
- FROM Sc_MouldInRequestBillMain
- WHERE HInterID = {hmainid}
- AND HChecker IS NOT NULL
- AND HCheckDate IS NOT NULL";
+ SELECT HBillStatus
+ FROM Sc_MouldInRequestBillMain
+ 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"]);
+
+ if (hBillStatus == 2)
{
return new { code = "0", count = 0, Message = "鍗曟嵁宸插鏍革紝涓嶈兘淇敼鎵樻暟锛�" };
}
}
+ else
+ {
+ return new { code = "0", count = 0, Message = "鍗曟嵁涓嶅瓨鍦紒" };
+ }
+
// 鐩存帴鏇存柊鎵樻暟
string updateSql = $@"
- UPDATE Sc_MouldInRequestBillMain
+ UPDATE Sc_MouldInRequestBillMain
SET HPackQtys = {newPallet}
WHERE HInterID = {hmainid}";
--
Gitblit v1.9.1