| | |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == item.Org.ToString())?.ORG_CODE, //生产单元授权标识字符 |
| | | CREATE_TIME = item.ModifiedOn,//--时间不更新 |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = item.ModifiedOn, |
| | | UPDATE_USER = UserCode |
| | | UPDATE_TIME = item.ModifiedOn, |
| | | UPDATE_USER = UserCode, |
| | | ERP_STATUS_CODE = item.Status.ToString(), |
| | | ERP_STATUS_NAME = item.StatusName, |
| | | }; |
| | | resultDt.Add(info); |
| | | } |
| | |
| | | .WhereColumns(t => new { t.ORDER_NO, t.LINE_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.LINE_NO, q.ITEM_CODE, q.QTY, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_USER, q.UPDATE_TIME }).ExecuteCommand(); |
| | | y.AsUpdateable.UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.LINE_NO, q.ITEM_CODE, q.QTY, q.AUTH_ORG, q.ERP_STATUS_CODE, q.ERP_STATUS_NAME, q.CREATE_USER, q.CREATE_TIME, q.UPDATE_USER, q.UPDATE_TIME }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | Logger.Scheduler.Info($"收货单表头信息存入数据库,总数:[{resultDt.Count}]"); |