From ce43535d56152482c1f12e6b13ba3377bd268009 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期二, 13 八月 2024 13:42:28 +0800 Subject: [PATCH] 期初入库扫码,接受erp发送的用户数据时,在写入MES用户表时增加部分默认字段 --- 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