From 4db3ba3f84456c27fdd9be76ff76c17101270914 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 24 九月 2025 14:12:48 +0800
Subject: [PATCH] 111
---
service/Warehouse/MesItemQtrkManager.cs | 46 ++++++++++++++++++++++++++++++++--------------
1 files changed, 32 insertions(+), 14 deletions(-)
diff --git a/service/Warehouse/MesItemQtrkManager.cs b/service/Warehouse/MesItemQtrkManager.cs
index e56aab2..90e859d 100644
--- a/service/Warehouse/MesItemQtrkManager.cs
+++ b/service/Warehouse/MesItemQtrkManager.cs
@@ -93,10 +93,15 @@
MES_DEPOTS b ON a.depot_guid = b.Guid
WHERE a.depot_section_code = @sectionCode;";
- var depotInfo = Db.Ado.SqlQuery<dynamic>(sql2, sqlParams).First();
-
- if (depotInfo is null)
+ dynamic depotInfo;
+ try
+ {
+ depotInfo = Db.Ado.SqlQuery<dynamic>(sql2, sqlParams).First();
+ }
+ catch
+ {
throw new Exception($"搴撲綅缂栫爜 {sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
+ }
// 5. 杩斿洖鎴愬姛淇℃伅
return depotInfo;
@@ -118,18 +123,23 @@
throw new Exception("璇锋壂搴撲綅鏉＄爜锛�");
// 2. 鏌ヨ搴撲綅瀵瑰簲鐨勪粨搴撶紪鐮佸拰浠撳簱ID
- var depotInfo = Db.Queryable<MesDepotSections, MesDepots>(
- (a, b) =>
- new JoinQueryInfos(JoinType.Inner, a.DepotGuid == b.Guid))
- .Where((a, b) => a.DepotSectionCode == p_section_code)
- .Select((a, b) => new { b.DepotCode, b.DepotId })
- .First();
-
- if (depotInfo == null)
+ var depotInfo2 = new { DepotCode = "", DepotId = (int?)0 }; // 鍖归厤鏁版嵁搴撹繑鍥炵殑鍙┖绫诲瀷
+ try
+ {
+ depotInfo2 = Db.Queryable<MesDepotSections, MesDepots>(
+ (a, b) =>
+ new JoinQueryInfos(JoinType.Inner, a.DepotGuid == b.Guid))
+ .Where((a, b) => a.DepotSectionCode == p_section_code)
+ .Select((a, b) => new { b.DepotCode, b.DepotId })
+ .First();
+ }
+ catch
+ {
throw new Exception($"搴撲綅缂栫爜 {p_section_code} 涓嶅瓨鍦紝璇风‘璁わ紒");
+ }
- var c_depot_code = depotInfo.DepotCode;
- var c_depot_id = depotInfo.DepotId;
+ var c_depot_code = depotInfo2.DepotCode;
+ var c_depot_id = depotInfo2.DepotId;
var sqlParams = new List<SugarParameter> { new("@barcode", p_item_barcode), new("@billNo", p_bill_no) };
@@ -145,8 +155,16 @@
- var mesDepost = Db.Queryable<MesDepots>()
+ MesDepots mesDepost;
+ try
+ {
+ mesDepost = Db.Queryable<MesDepots>()
.Where(s => s.DepotId == c_depot_id).First();
+ }
+ catch
+ {
+ throw new Exception($"浠撳簱ID {c_depot_id} 瀵瑰簲鐨勪粨搴撲俊鎭笉瀛樺湪锛岃纭锛�");
+ }
--
Gitblit v1.9.3