From c40ce123424183b2fce3bf9dfb24d859f3eacb52 Mon Sep 17 00:00:00 2001 From: Ben Lin <maobin001@msn.com> Date: 星期四, 09 一月 2025 17:00:03 +0800 Subject: [PATCH] 新增获取物料条码信息的功能 --- Tiger.Business.MES/iERP/U9C_MES.cs | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/Tiger.Business.MES/iERP/U9C_MES.cs b/Tiger.Business.MES/iERP/U9C_MES.cs index dfe8d48..15d031f 100644 --- a/Tiger.Business.MES/iERP/U9C_MES.cs +++ b/Tiger.Business.MES/iERP/U9C_MES.cs @@ -17,6 +17,7 @@ using Apache.NMS.ActiveMQ.Commands; using System.Security.Cryptography; using System.Diagnostics; +using Tiger.Model.MES.Yada; namespace Tiger.Business.MES { @@ -688,5 +689,28 @@ } return action; } + + /// <summary> + /// 鍚屾鐗╂枡鏉$爜淇℃伅 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + public ApiAction GetMaterialBarCode(U9C_MES_Input input) + { + var action = new ApiAction(); + Logger.Scheduler.Info($"鐗╂枡鏉$爜淇℃伅寮�濮嬪悓姝ャ�傘�傘�傛暟鎹鏌ヨ繘琛屼腑銆傘�傘��"); + Logger.Scheduler.Info($"{input.triggerDetail}"); + DbClient db = Biz.DataSource["YadaU9C"].Client; + try + { + var list = db.Queryable<mes_MaterialBarCode>().Where("ModifiedOn > @startTime And ModifiedOn < @endTime", new { startTime = input.startTime, endTime = input.endTime }).ToList(); + } + catch (Exception ex) + { + action.CatchExceptionWithLog(ex, Biz.L(ex.Message)); + } + + return action; + } } } -- Gitblit v1.9.3