From 6912d8235648a51e2e7b7e93d0f5b5e868511462 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 06 八月 2024 12:45:59 +0800
Subject: [PATCH] 添加读取配置的类。将数据库连接，接口地址写入到配置文件中，获取时通过配置文件获取
---
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