From 7aa936eec82e59b9c8d1d976e53cd836fb60a43c Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期二, 04 三月 2025 10:29:15 +0800
Subject: [PATCH] 雅达-同步更新：添加 CREATE_USER 属性并移除 CREATE_TIME 更新
---
Tiger.Business.MES/iERP/U9C_MES.cs | 39 +++++++++------------------------------
1 files changed, 9 insertions(+), 30 deletions(-)
diff --git a/Tiger.Business.MES/iERP/U9C_MES.cs b/Tiger.Business.MES/iERP/U9C_MES.cs
index 15d031f..cb09fa4 100644
--- a/Tiger.Business.MES/iERP/U9C_MES.cs
+++ b/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;
}
}
--
Gitblit v1.9.3