雅达-同步更新:添加 CREATE_USER 属性并移除 CREATE_TIME 更新
在 `U9C_MES.cs` 文件中,向 `snItem` 对象添加了 `CREATE_USER` 属性,并将其值设置为 `"U9C"`。
更新了 `AsUpdateable` 的 `UpdateColumns` 方法,移除了 `CREATE_TIME` 属性的更新。
| | |
| | | CREATE_TIME = di["CreatedOn"].ToDateTime(), |
| | | UPDATE_TIME = di["ModifiedOn"].ToDateTime(), |
| | | AUTH_ORG = _MES_WO?.AUTH_ORG, |
| | | CREATE_USER = "U9C" |
| | | }; |
| | | items.Add(snItem); |
| | | } |
| | |
| | | .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 |
| | |
| | | .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(); |
| | | } |
| | | } |
| | | |