From 7ee2e58c300374a15c212f9145ba9d762d64e0e6 Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期六, 20 十二月 2025 15:58:11 +0800
Subject: [PATCH] 1.新增MES_PROJECT.cs
---
StandardPda/MES.Service/service/Warehouse/MesItemQtrkManager.cs | 48 ++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 46 insertions(+), 2 deletions(-)
diff --git a/StandardPda/MES.Service/service/Warehouse/MesItemQtrkManager.cs b/StandardPda/MES.Service/service/Warehouse/MesItemQtrkManager.cs
index 268fe67..b7095c0 100644
--- a/StandardPda/MES.Service/service/Warehouse/MesItemQtrkManager.cs
+++ b/StandardPda/MES.Service/service/Warehouse/MesItemQtrkManager.cs
@@ -293,7 +293,22 @@
}
supplierCode = mesSupplier.SuppNo;
}
-
+
+ string mesUnit = "";
+ if (mesItems.ItemUnit != null && mesItems.ItemUnit != "")
+ {
+
+ var mesUnitDb = Db.Queryable<MesUnit>()
+ .Where(s => s.Id == Decimal.Parse(mesItems.ItemUnit))
+ .First();
+ if (mesUnitDb == null)
+ {
+ throw new NotImplementedException("[" + ItemQtRKList.SupplierCode +
+ "]鍗曚綅涓嶅瓨鍦紝璇峰悓姝ョ粰MES");
+ }
+ mesUnit = mesUnitDb.Fnumber;
+ }
+
//var mesInvItemInCItems = Db.Queryable<MesInvItemInCItems>()
// .Where(s => s.ItemInId == mesInvItemIns.Id
@@ -327,7 +342,7 @@
Qd006= ItemQtRKList.PlannedQuantity,
Qd007= ItemQtRKList.AppliedQuantity,
Qd008=0, // 宸插叆鏁伴噺榛樿涓�0
- Qd009= mesItems.ItemUnit,
+ Qd009= mesUnit,
Qd010= ItemQtRKList.Remark,
Qd012= mesItems.Id, // 鐗╂枡鍐呯爜
LineNumber= ItemQtRKList.LineNumber,
@@ -345,6 +360,27 @@
FinishedProduct = ItemQtRKList.FinishedProduct
});
+ }
+
+ var itemDB = mesItemQtrrDetail
+ .Where(x => x.Qd002 != null) // 杩囨护鎺� null 鍊�
+ .GroupBy(x => x.Qd002) // 鎸� Qd002 鍒嗙粍
+ .Select(g => new
+ {
+ no = g.Key,
+ count = g.Count()
+
+ })
+ .ToList();
+
+ // 杈撳嚭缁熻缁撴灉
+ foreach (var item in itemDB)
+ {
+ if (item.count>1)
+ {
+ throw new Exception($"鏄庣粏琛岀墿鏂�:{item.no}閲嶅锛岃妫�鏌ュ悗閲嶈瘯锛�");
+ }
+ //Console.WriteLine($"鐗╂枡缂栧彿: {item.鐗╂枡缂栧彿}, 鍑虹幇娆℃暟: {item.鍑虹幇娆℃暟}");
}
var outItemCommand = Db.Insertable(mesItemQtrrDetail)
@@ -396,6 +432,14 @@
throw new NotImplementedException(
$"鎵句笉鍒版潅鏀跺崟[{from.ApplyNumber}]瀵瑰簲鐨勬槑缁�");
}
+ foreach (var item in mesInvItemOutItems)
+ {
+ if (item.Qd008 > 0)
+ {
+ throw new NotImplementedException(
+ $"璇ユ潅鏀跺崟鍦∕ES宸茬粡鎵爜鍏ュ簱锛屼笉鑳藉弽瀹″垹闄�");
+ }
+ }
// 鍒犻櫎鏉傛敹鍗曟槑缁�
var deleteItemsResult = Db.Deleteable<MesItemQtrrDetail>()
--
Gitblit v1.9.3