From 87bf0fe8996e0d2c9078e52d367a348bb6bf6a4a Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期六, 11 十月 2025 18:55:30 +0800
Subject: [PATCH] 优化提示
---
service/Warehouse/MesInvItemInCDetailsManager.cs | 51 ++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 38 insertions(+), 13 deletions(-)
diff --git a/service/Warehouse/MesInvItemInCDetailsManager.cs b/service/Warehouse/MesInvItemInCDetailsManager.cs
index 23981ef..a77ffc4 100644
--- a/service/Warehouse/MesInvItemInCDetailsManager.cs
+++ b/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -1,4 +1,5 @@
锘縰sing Masuit.Tools.Models;
+using Microsoft.AspNetCore.SignalR.Protocol;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
@@ -28,7 +29,7 @@
if (string.IsNullOrEmpty(entity.userName)) throw new ArgumentNullException(nameof(entity.userName), "鐢ㄦ埛鍚嶄笉鍏佽涓虹┖");
if (string.IsNullOrEmpty(entity.sectionCode)) throw new ArgumentNullException(nameof(entity.sectionCode), "搴撲綅缂栧彿涓嶅厑璁镐负绌�");
if (string.IsNullOrEmpty(entity.barcode)) throw new ArgumentNullException(nameof(entity.barcode), "鏉＄爜涓嶅厑璁镐负绌�");
-
+
using (var conn = new SqlConnection(connectionString))
{
using (var cmd = new SqlCommand("[prc_pda_inv_cgrk]", conn))
@@ -56,8 +57,17 @@
string? outMessage = parameters[4].Value?.ToString();
string? outSum = parameters[5].Value?.ToString();
+
+ // 妫�鏌ュ弬鏁版槸鍚︿负绌猴紝骞跺湪寮傚父涓樉绀哄疄闄呭��
if (string.IsNullOrEmpty(outMessage) || string.IsNullOrEmpty(outSum))
- throw new InvalidOperationException("瀛樺偍杩囩▼杩斿洖鍙傛暟寮傚父");
+ {
+ // 鎷兼帴鍙傛暟瀹為檯鍊硷紙澶勭悊 null 鐨勬儏鍐碉級
+ string messageValue = outMessage ?? "null";
+ string sumValue = outSum ?? "null";
+ throw new InvalidOperationException(
+ $"瀛樺偍杩囩▼杩斿洖鍙傛暟寮傚父锛氳緭鍑烘秷鎭负銆恵messageValue}銆戯紝杈撳嚭鏁伴噺涓恒�恵sumValue}銆�"
+ );
+ }
// 楠岃瘉缁撴灉
if (!int.TryParse(outSum, out int result) || result <= 0)
@@ -113,10 +123,16 @@
WHERE a.Item_In_Id = '{0}' AND a.Item_Id = '{1}'", cId, itemBarcodeDetails.ItemId);
res.ItemBarCDetails = Db.Ado.SqlQuery<dynamic>(sql2);
+ //鏌ヨ宸插叆搴撴�绘暟
+ var totalCDetailsQuantity = Db.Queryable<MesInvItemInCDetails>()
+ .Where(it => it.ItemInId == cId)
+ .Sum(it => it.Quantity);
+
+ res.SumQuantity = Convert.ToDecimal(totalCDetailsQuantity);
// 璁剧疆杩斿洖淇℃伅
res.Message = outMessage;
- res.SumQuantity = result;
+
return res;
}
@@ -1299,9 +1315,9 @@
// 灏嗘煡璇㈠埌鐨勬潯鐮佷俊鎭祴鍊肩粰杩斿洖妯″瀷
res.itemBarcodeDetails = itemBarcode;
-
+
res.Message = "鏌ヨ鎴愬姛";
-
+
return res;
}
@@ -1358,7 +1374,7 @@
string strMsg = "";
string intSum = "";
string cfBar = "";
-
+
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("[prc_pda_bar_cf_before]", conn))
@@ -1394,7 +1410,7 @@
string ytMsg = "";
string ytSum = "";
string ytdh = "";
-
+
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("prc_pda_scan_CGYT", conn))
@@ -1412,7 +1428,7 @@
cmd.Parameters.AddRange(ytParameters);
cmd.ExecuteNonQuery();
-
+
ytMsg = ytParameters[2].Value.ToString();
ytSum = ytParameters[3].Value.ToString();
ytdh = ytParameters[4].Value.ToString();
@@ -1424,7 +1440,7 @@
// 璋冪敤鍏ュ簱瀛樺偍杩囩▼ prc_pda_inv_cgrk锛屼娇鐢ㄥ師濮嬫潯鐮�
string rkMsg = "";
string rkSum = "";
-
+
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("prc_pda_inv_cgrk", conn))
@@ -1443,7 +1459,7 @@
cmd.Parameters.AddRange(rkParameters);
cmd.ExecuteNonQuery();
-
+
rkMsg = rkParameters[3].Value.ToString();
rkSum = rkParameters[4].Value.ToString();
@@ -1451,7 +1467,7 @@
}
}
-
+
// 浼樺寲鏌ヨ锛堝幓闄ょ┖鏍煎苟蹇界暐澶у皬鍐欙級
var mesInvItemInCDetails = Db.Queryable<MesInvItemInCDetails>()
@@ -1493,9 +1509,18 @@
res.ItemBarCDetails = Db.Ado.SqlQuery<dynamic>(sql2, new { cId, itemId = itemBarcode.ItemId });
- res.Message = $"楠岄��鎿嶄綔鎴愬姛锛屾媶鍒嗗悗鏉＄爜锛歿cfBar}锛岄獙閫�鍗曞彿锛歿ytdh}";
- res.SumQuantity = res.ItemBarCDetails?.Count ?? 0;
+ //鏌ヨ宸插叆搴撴�绘暟
+ var totalCDetailsQuantity = Db.Queryable<MesInvItemInCDetails>()
+ .Where(it => it.ItemInId == cId)
+ .Sum(it => it.Quantity);
+
+ res.SumQuantity = Convert.ToDecimal(totalCDetailsQuantity);
+
+
+ res.Message = $"楠岄��鎿嶄綔鎴愬姛锛屾媶鍒嗗悗鏉＄爜锛歿cfBar}锛岄獙閫�鍗曞彿锛歿ytdh}";
+ // res.SumQuantity = res.ItemBarCDetails?.Count ?? 0;
+ res.SumQuantity = Convert.ToDecimal(totalCDetailsQuantity);
return res;
}
catch (Exception ex)
--
Gitblit v1.9.3