From 35347311da9ca47ac614603ebf4c3ccab8cf26a2 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 16 七月 2025 13:42:59 +0800
Subject: [PATCH] OQC
---
MES.Service/service/Warehouse/MesInvItemMovesManager.cs | 38 ++++++++++++++++++++++----------------
1 files changed, 22 insertions(+), 16 deletions(-)
diff --git a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
index e3122a5..31c8488 100644
--- a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
@@ -14,7 +14,8 @@
public MovesDto ScanInBarcode(WarehouseQuery query)
{
- if (string.IsNullOrEmpty(query.sectionCode)) throw new Exception("璇锋壂搴撲綅鏉＄爜锛�");
+ if (string.IsNullOrEmpty(query.sectionCode))
+ throw new Exception("璇锋壂搴撲綅鏉＄爜锛�");
var pBillTypeId = 300;
var pTransctionNo = 301;
@@ -26,7 +27,8 @@
.Select((a, b) => new { b.DepotCode })
.First();
- if (depotQuery == null) throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
+ if (depotQuery == null)
+ throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
var cDepotCode = depotQuery.DepotCode;
@@ -48,17 +50,20 @@
var iDepotCode = itemMoveQuery.InvDepotsCode;
// 楠岃瘉搴撳尯涓庝粨搴�
- var depotValidationQuery = Db.Queryable<MesDepotSections, MesDepots>(
- (a, b) => new JoinQueryInfos(
+ var depotValidationQuery = Db
+ .Queryable<MesDepotSections, MesDepots>((a, b) =>
+ new JoinQueryInfos(
JoinType.Inner, a.Zuid.ToString() == b.Zuid))
.Where((a, b) => a.DepotSectionCode == query.sectionCode &&
b.DepotCode == iDepotCode)
.Select((a, b) => new { b.DepotCode })
.First();
- if (depotValidationQuery == null) throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
+ if (depotValidationQuery == null)
+ throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
- if (iDepotCode != depotValidationQuery.DepotCode) throw new Exception("瀹為檯浠撳簱涓庣敵璇疯皟鍏ヤ粨搴撲笉绗︼紝璇锋牳瀵癸紒");
+ if (iDepotCode != depotValidationQuery.DepotCode)
+ throw new Exception("瀹為檯浠撳簱涓庣敵璇疯皟鍏ヤ粨搴撲笉绗︼紝璇锋牳瀵癸紒");
var barcodeCount = Db.Queryable<MesInvItemMovesCDetails>()
.Where(b =>
@@ -176,13 +181,14 @@
private List<MesInvItemMovesCDetails> GetItemMovesCDetails(
WarehouseQuery query)
{
- return Db.Queryable<MesInvItemMovesCDetails, MesItems, MesSupplier>(
- (b, c, f) => new JoinQueryInfos(
- JoinType.Left,
- b.ItemNo == c.ItemNo && b.Company == c.Company &&
- b.Factory == c.Factory,
- JoinType.Left, b.SuppNo == f.SuppNo
- ))
+ return Db
+ .Queryable<MesInvItemMovesCDetails, MesItems,
+ MesSupplier>((b, c, f) => new JoinQueryInfos(
+ JoinType.Left,
+ b.ItemNo == c.ItemNo && b.Company == c.Company &&
+ b.Factory == c.Factory,
+ JoinType.Left, b.SuppNo == f.SuppNo
+ ))
.Where((b, c, f) => b.ItemMoveId == query.id)
.Select((b, c, f) => new MesInvItemMovesCDetails
{
@@ -226,9 +232,9 @@
if (mesInvItemMoves == null)
throw new Exception("鍑哄簱鍗� " + query.billNo + "涓嶅瓨鍦紝璇风‘璁わ紒");
- var count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>(
- (a, b) =>
- new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
+ var count = Db
+ .Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) =>
+ new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
.Where((a, b) => b.ItemBarcode == query.barcode
&& a.TransactionNo == TransctionNo &&
SqlFunc.IsNull(a.Status, 0) == 0).Count();
--
Gitblit v1.9.3