From e93d2a1c8fdfadf50f9fbf9e30c04ffe73df023a Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 14 八月 2024 16:26:03 +0800
Subject: [PATCH] 11
---
MES.Service/service/Warehouse/MesInvItemArnManager.cs | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/MES.Service/service/Warehouse/MesInvItemArnManager.cs b/MES.Service/service/Warehouse/MesInvItemArnManager.cs
index 81d0c48..c382c5c 100644
--- a/MES.Service/service/Warehouse/MesInvItemArnManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemArnManager.cs
@@ -49,4 +49,18 @@
return result;
}
+
+ public List<MesSupplier> GetSuppliers()
+ {
+ return Db.Queryable<MesInvItemArn, MesSupplier>((a, b) =>
+ new JoinQueryInfos(JoinType.Left, a.SuppNo == b.SuppNo))
+ .GroupBy((a, b) => new { b.Id, a.SuppNo, b.SuppName })
+ .Select((a, b) => new MesSupplier
+ {
+ SuppNo = a.SuppNo,
+ SuppName = b.SuppName,
+ Id = b.Id
+ })
+ .ToList();
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3