更改查询表并添加新编译项

Ben Lin

2025-01-09 4891d952819dd5c2efd727385a5f8178ac640d22

 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_MaterialBarCodeByBin>().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;
        }
    }
}