From f1deb7b024e17cba204de5fcb0dac15801436b90 Mon Sep 17 00:00:00 2001
From: sjz <1240968267@qq.com>
Date: 星期一, 28 七月 2025 20:56:41 +0800
Subject: [PATCH] 多组织修改
---
MES.Service/service/Warehouse/MesDepotSectionsManager.cs | 51 +++++++++++++++++++++++++++++++++++++--------------
1 files changed, 37 insertions(+), 14 deletions(-)
diff --git a/MES.Service/service/Warehouse/MesDepotSectionsManager.cs b/MES.Service/service/Warehouse/MesDepotSectionsManager.cs
index 3a02a02..7a944c6 100644
--- a/MES.Service/service/Warehouse/MesDepotSectionsManager.cs
+++ b/MES.Service/service/Warehouse/MesDepotSectionsManager.cs
@@ -17,24 +17,20 @@
.Select((a, b) => a.DepotSectionName).Single();
if (sectionName == null)
- {
throw new Exception("搴撲綅缂栫爜 " + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁わ紒");
- }
return sectionName;
}
+ //搴撲綅鍙樻洿
public MesDepotSections ScanInDepotSectionsName(WarehouseQuery query)
{
-
if (string.IsNullOrEmpty(query.sectionCode))
- {
throw new Exception("璇锋壂搴撲綅鏉＄爜!");
- }
-
- var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>(
- (a, b) =>
- new JoinQueryInfos(JoinType.Inner, a.DepotId == b.DepotId))
+
+ var mesDepotSections = Db
+ .Queryable<MesDepotSections, MesDepots>((a, b) =>
+ new JoinQueryInfos(JoinType.Inner, a.DepotId == b.DepotId))
.Where((a, b) => a.DepotSectionCode == query.sectionCode)
.Select((a, b) => new MesDepotSections
{
@@ -44,20 +40,47 @@
}).First();
if (mesDepotSections == null)
- {
throw new Exception("搴撲綅缂栫爜" + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁�!");
- }
return mesDepotSections;
}
+ //搴撲綅鍙樻洿
public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity)
{
if (string.IsNullOrEmpty(entity.sectionCode))
- {
throw new Exception("璇锋壂搴撲綅鏉＄爜!");
- }
- return null;
+ var mesDepotSections = Db
+ .Queryable<MesDepotSections, MesDepots>((a, b) =>
+ new JoinQueryInfos(JoinType.Inner,
+ a.Zuid.ToString() == b.Zuid))
+ .Where((a, b) => a.DepotSectionCode == entity.sectionCode)
+ .First();
+ if (mesDepotSections == null)
+ throw new Exception("搴撲綅缂栫爜" + entity.sectionCode + " 涓嶅瓨鍦紝璇风‘璁わ紒");
+
+ var mesInvItemStocks = Db.Queryable<MesInvItemStocks>()
+ .Where(s => s.ItemBarcode == entity.barcode).First();
+
+ if (mesInvItemStocks == null) throw new Exception("鏉＄爜鍦ㄤ粨搴撲腑涓嶅瓨鍦紝璇锋牳瀵癸紒");
+
+ if (mesInvItemStocks.DepotsCode != mesDepotSections.DepotCode)
+ throw new Exception(
+ "鏉＄爜鍘熶粨搴擄細" + mesInvItemStocks.DepotsCode + " 涓庣洰鏍囦粨搴擄細" +
+ mesDepotSections.DepotCode + " 涓嶄竴鑷达紝搴撲綅鍙樻洿澶辫触锛�");
+
+ UseTransaction(db =>
+ {
+ return db.Updateable<MesInvItemStocks>()
+ .SetColumns(s => s.DepotsCode == mesDepotSections.DepotCode)
+ .SetColumns(s => s.DepotSectionsCode == entity.sectionCode)
+ .Where(s => s.ItemBarcode == entity.barcode)
+ .ExecuteCommand();
+ });
+
+ return mesInvItemStocks;
}
+
+ //璋冩嫧鍏ュ簱
}
\ No newline at end of file
--
Gitblit v1.9.3