雅达-同步更新：添加 CREATE_USER 属性并移除 CREATE_TIME 更新

Ben Lin

2025-03-04 7aa936eec82e59b9c8d1d976e53cd836fb60a43c

 Tiger.Business.MES/iERP/U9C_MES.cs

@@ -28,7 +28,7 @@
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public ApiAction GetBasItem(U9C_MES_Input input)
        public ApiAction GetBasItem(U9C_Base_Input input)
        {
            var action = new ApiAction();
            Logger.Scheduler.Info($"物料信息开始同步。。。数据检查进行中。。。");
@@ -309,7 +309,7 @@
        /// <param name="input"></param>
        /// <returns></returns>
        /// <exception cref="NotImplementedException"></exception>
        public ApiAction GetCustomer(U9C_MES_Input input)
        public ApiAction GetCustomer(U9C_Base_Input input)
        {
            var action = new ApiAction();
            Logger.Scheduler.Info($"客户信息开始同步。。。数据检查进行中。。。");
@@ -386,7 +386,7 @@
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public ApiAction GetSupplier(U9C_MES_Input input)
        public ApiAction GetSupplier(U9C_Base_Input input)
        {
            var action = new ApiAction();
            Logger.Scheduler.Info($"供应商信息开始同步。。。数据检查进行中。。。");
@@ -460,7 +460,7 @@
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public ApiAction GetCustBarCode(U9C_MES_Input input)
        public ApiAction GetCustBarCode(U9C_Base_Input input)
        {
            var action = new ApiAction();
            Logger.Scheduler.Info($"客户条码信息开始同步。。。数据检查进行中。。。");
@@ -470,6 +470,7 @@
            List<MES_CUST_SN> items = new();
            if (list != null && list.Count > 0)
            {
                Logger.Scheduler.Info($"获取客户条码信息：[{list.ToJson()}]");
                foreach (var item in list)
                {
                    var d = item as System.Dynamic.ExpandoObject;
@@ -490,6 +491,7 @@
                                CREATE_TIME = di["CreatedOn"].ToDateTime(),
                                UPDATE_TIME = di["ModifiedOn"].ToDateTime(),
                                AUTH_ORG = _MES_WO?.AUTH_ORG,
                                CREATE_USER = "U9C"
                            };
                            items.Add(snItem);
                        }
@@ -510,7 +512,7 @@
                                 .WhereColumns(t => new { t.CUST_SN, t.GHOST_ROW })
                                 .ToStorage();
                          y.AsInsertable.ExecuteCommand();
                          y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.CUST_CODE, q.WORK_ORDER, q.CUST_SN, q.FLOW_SN, q.ITEM_CODE, q.CREATE_TIME, q.UPDATE_TIME, q.UPDATE_USER, q.AUTH_ORG }).ExecuteCommand();
                          y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.CUST_CODE, q.WORK_ORDER, q.CUST_SN, q.FLOW_SN, q.ITEM_CODE, q.UPDATE_TIME, q.UPDATE_USER, q.AUTH_ORG }).ExecuteCommand();
                      });
                }
                else
@@ -519,7 +521,7 @@
                           .WhereColumns(t => new { t.CUST_SN, t.GHOST_ROW })
                           .ToStorage();
                    s.AsInsertable.ExecuteCommand();
                    s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.CUST_CODE, q.WORK_ORDER, q.CUST_SN, q.FLOW_SN, q.ITEM_CODE, q.CREATE_TIME, q.UPDATE_TIME, q.UPDATE_USER, q.AUTH_ORG }).ExecuteCommand();
                    s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.CUST_CODE, q.WORK_ORDER, q.CUST_SN, q.FLOW_SN, q.ITEM_CODE, q.UPDATE_TIME, q.UPDATE_USER, q.AUTH_ORG }).ExecuteCommand();
                }
            }

@@ -534,7 +536,7 @@
            return action;
        }

        public ApiAction GetU9CBasWo(U9C_MES_Input input)
        public ApiAction GetU9CBasWo(U9C_Base_Input input)
        {
            var action = new ApiAction();
            Logger.Scheduler.Info($"工单信息开始同步。。。数据检查进行中。。。");
@@ -687,29 +689,6 @@
                    }
                });
            }
            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;
        }
    }