From 38339731265cb8ffef7954fb90874036fd46f09d Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期一, 22 十二月 2025 09:46:11 +0800
Subject: [PATCH] 供应商分数获取调整
---
service/Warehouse/MesDepotSectionsManager.cs | 156 ++++++++++++++++++++++++++-------------------------
1 files changed, 80 insertions(+), 76 deletions(-)
diff --git a/service/Warehouse/MesDepotSectionsManager.cs b/service/Warehouse/MesDepotSectionsManager.cs
index 9d39c4b..33fda90 100644
--- a/service/Warehouse/MesDepotSectionsManager.cs
+++ b/service/Warehouse/MesDepotSectionsManager.cs
@@ -3,86 +3,90 @@
using NewPdaSqlServer.entity;
using SqlSugar;
-namespace NewPdaSqlServer.service.Warehouse
+namespace NewPdaSqlServer.service.Warehouse;
+
+public class MesDepotSectionsManager : Repository<MesDepotSections>
{
- public class MesDepotSectionsManager : Repository<MesDepotSections>
+ public dynamic GetSectionName(WarehouseQuery query)
{
- public string GetSectionName(WarehouseQuery query)
- {
- var sectionName = Db.Queryable<MesDepotSections, MesDepots>(
- (a, b) =>
- new JoinQueryInfos(JoinType.Inner,
- a.DepotGuid == b.Guid))
- .Where((a, b) => a.DepotSectionCode == query.sectionCode)
- .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.DepotGuid == b.Guid))
- .Where((a, b) => a.DepotSectionCode == query.sectionCode)
- .Select((a, b) => new MesDepotSections
- {
- DepotSectionName = a.DepotSectionName,
- DepotCode = b.DepotCode,
- DepotName = b.DepotName
- }).First();
-
- if (mesDepotSections == null)
- throw new Exception("搴撲綅缂栫爜" + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁�!");
-
- return mesDepotSections;
- }
-
- //搴撲綅鍙樻洿
- public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity)
- {
- if (string.IsNullOrEmpty(entity.sectionCode))
- throw new Exception("璇锋壂搴撲綅鏉＄爜!");
-
- 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 =>
+ var sectionName = Db.Queryable<MesDepotSections, MesDepots>(
+ (a, b) =>
+ new JoinQueryInfos(JoinType.Inner,
+ a.DepotGuid == b.Guid)) // 纭繚Guid绫诲瀷姝ｇ‘姣旇緝
+ .Where((a, b) => a.DepotSectionCode == query.sectionCode)
+ .Select((a, b) => new // 鏀圭敤鍖垮悕绫诲瀷鏇夸唬dynamic
{
- return db.Updateable<MesInvItemStocks>()
- .SetColumns(s => s.DepotsCode == mesDepotSections.DepotCode)
- .SetColumns(s => s.DepotSectionsCode == entity.sectionCode)
- .Where(s => s.ItemBarcode == entity.barcode)
- .ExecuteCommand();
- });
+ a.DepotSectionName,
+ DepotName = b.DepotName, // 鏄惧紡鎸囧畾瀛楁鍒悕
+ DepotCode = b.DepotCode
+ }).Single();
- return mesInvItemStocks;
- }
+ 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.DepotGuid == b.Guid))
+ .Where((a, b) => a.DepotSectionCode == query.sectionCode)
+ .Select((a, b) => new MesDepotSections
+ {
+ DepotSectionName = a.DepotSectionName,
+ DepotCode = b.DepotCode,
+ DepotName = b.DepotName
+ }).First();
+
+ if (mesDepotSections == null)
+ throw new Exception("搴撲綅缂栫爜" + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁�!");
+
+ return mesDepotSections;
+ }
+
+ //搴撲綅鍙樻洿
+ public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity)
+ {
+ if (string.IsNullOrEmpty(entity.sectionCode))
+ throw new Exception("璇锋壂搴撲綅鏉＄爜!");
+
+ 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