From 223ad76695223d90104da82e7bc6e9e984563e47 Mon Sep 17 00:00:00 2001
From: YangYuGang <1378265336@qq.com>
Date: 星期一, 07 四月 2025 16:45:36 +0800
Subject: [PATCH] 调拨单对应字段修改
---
Tiger.Business.WMS/ERP/U9C_WMS.cs | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/Tiger.Business.WMS/ERP/U9C_WMS.cs b/Tiger.Business.WMS/ERP/U9C_WMS.cs
index 1c9ac2e..ba66a6d 100644
--- a/Tiger.Business.WMS/ERP/U9C_WMS.cs
+++ b/Tiger.Business.WMS/ERP/U9C_WMS.cs
@@ -809,7 +809,7 @@
.GroupBy(x => new { x.DocNo })
.Select(x => new BIZ_WMS_TRANSFER
{
- ORDER_NO = x.Key.DocNo, //鍗曟嵁鍙�
+ ORDER_NO = x.Key.DocNo, //璋冩嫧鍗曞彿
ORDER_DATE = x.Max(t => t.BusinessDate), //鍗曟嵁鏃ユ湡
STATUS = BIZ_WMS_TRANSFER.STATUSs.Init.GetValue(), //鐘舵��
//OUT_WH_CODE 璋冨嚭浠撳簱
@@ -847,14 +847,14 @@
IN_WH_CODE = item.TransInWhCode, // 鎷ㄥ叆浠撳簱
OUT_LOTNO = item.LotCode,// 璋冨嚭鎵规 -- 鎵规
IN_LOTNO = item.LotCode, // 鎷ㄥ叆鎵规 -- 鎵规
- //SOURCE_CODE = item.BenefitDept,// 鏉ユ簮鍗曟嵁缂栫爜锛屽涓敤鈥�,鈥濆垎闅�
- //SOURCE_ORDER = item.BenefitDeptName, // 鏉ユ簮鍗曡鍙凤紝澶氫釜鐢ㄢ��,鈥濆垎闅旓紝璺熺紪鐮佷竴涓�瀵瑰簲
- //SOURCE_LINE = item.ReturnStorageReason,//
+ //SOURCE_CODE = item.BenefitDept,// 鏉ユ簮鍗曟嵁缂栫爜
+ SOURCE_ORDER = item.TransferInId.ToString(), // 鏉ユ簮鍗曡鍙�-- 鍗曞ごID
+ SOURCE_LINE = item.DocLineNo.ToString(),// 鏉ユ簮鍗曡鍙� ---琛屽彿
// ERP_ORDER = item.InStorageReason, // ERP鍗曟嵁鍙风爜
- //REMARK 澶囨敞
+ //REMARK 澶囨敞
AUTH_ORG = orgs.FirstOrDefault(q => q.ID == org.Org.ToString())?.ORG_CODE, //缁勭粐
- CREATE_TIME = item.ModifiedOn,//--鏃堕棿涓嶆洿鏂�
- CREATE_USER = UserCode,
+ CREATE_TIME = item.CreatedOn,//--鏃堕棿涓嶆洿鏂�
+ CREATE_USER = item.CreatedBy,
UPDATE_TIME = item.ModifiedOn,
UPDATE_USER = UserCode,
};
@@ -870,7 +870,7 @@
.WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW })
.ToStorage();
y.AsInsertable.ExecuteCommand();
- y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.ORDER_DATE, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, q.HANDLED, q.HANDLED_DATE, }).ExecuteCommand();
+ y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new {q.ORDER_NO, q.ORDER_DATE, q.STATUS,q.SOURCE_CODE,q.SOURCE_ORDER,q.HANDLED,q.HANDLED_DATE, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER,}).ExecuteCommand();
});
}
@@ -882,7 +882,7 @@
.WhereColumns(t => new { t.ORDER_NO, t.ORDER_LINE, t.GHOST_ROW })
.ToStorage();
y.AsInsertable.ExecuteCommand();
- y.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO, q.ORDER_LINE, q.STATUS, q.ITEM_CODE, q.UNIT, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER }).ExecuteCommand();
+ y.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO, q.ORDER_LINE, q.STATUS, q.ITEM_CODE, q.UNIT, q.QTY_REQ,q.QTY_OUT,q.OUT_WH_CODE,q.IN_WH_CODE,q.OUT_LOTNO,q.IN_LOTNO, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
});
}
Logger.Scheduler.Info($"璋冩嫧鍗曟嵁琛ㄥご淇℃伅瀛樺叆鏁版嵁搴擄紝鎬绘暟锛歔{resultDt.Count}]");
--
Gitblit v1.9.3