From 70c9c84b932d4e85c8230a3b042bd984a1feb717 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期四, 10 四月 2025 10:08:37 +0800
Subject: [PATCH] 优化了一些已知问题
---
Tiger.Business.WMS/T100ToWMS/TrasferInfoBusiness.cs | 26 +++++++++++++-------------
1 files changed, 13 insertions(+), 13 deletions(-)
diff --git a/Tiger.Business.WMS/T100ToWMS/TrasferInfoBusiness.cs b/Tiger.Business.WMS/T100ToWMS/TrasferInfoBusiness.cs
index 68979a0..2174396 100644
--- a/Tiger.Business.WMS/T100ToWMS/TrasferInfoBusiness.cs
+++ b/Tiger.Business.WMS/T100ToWMS/TrasferInfoBusiness.cs
@@ -27,7 +27,7 @@
{
foreach (var item in masterData)
{
- item.SOURCECODE = item.BILLCODE;
+ item.SOURCE_ORDER = item.ORDER_NO;
}
}
var detailSource = new List<TrasferInfoDetailDTO>();
@@ -54,32 +54,32 @@
//var db = Biz.Db;// 鍖哄垎姝ｅ紡搴撹繕鏄祴璇曞簱
var db = Biz.DataSource["WMS57"].Client; // 鍖哄垎姝ｅ紡搴撹繕鏄祴璇曞簱
- var BILLCODELst = masterData.Select(i => i.BILLCODE).Distinct().ToList();
+ var BILLCODELst = masterData.Select(i => i.ORDER_NO).Distinct().ToList();
#region 鍖哄垎涓昏〃闇�瑕佹彃鍏ュ強鏇存柊鐨勬暟鎹�
- var hostoryMasterData = db.Queryable<BIZ_WMS_TRANSFER>().Where(i => BILLCODELst.Contains(i.BILLCODE)).ToList();// 鑾峰彇涓昏〃鏃ф暟鎹�
- var resMaster = hostoryMasterData.Select(i => i.BILLCODE).Distinct().ToList();
- var masterNeedInsert = masterData.Where(i => !resMaster.Contains(i.BILLCODE)).ToList();// 闇�瑕佹彃鍏ョ殑鏁版嵁
- var masterNeedUpdate = masterData.Where(i => resMaster.Contains(i.BILLCODE)).ToList();// 闇�瑕佹洿鏂扮殑鏁版嵁
+ var hostoryMasterData = db.Queryable<BIZ_WMS_TRANSFER>().Where(i => BILLCODELst.Contains(i.ORDER_NO)).ToList();// 鑾峰彇涓昏〃鏃ф暟鎹�
+ var resMaster = hostoryMasterData.Select(i => i.ORDER_NO).Distinct().ToList();
+ var masterNeedInsert = masterData.Where(i => !resMaster.Contains(i.ORDER_NO)).ToList();// 闇�瑕佹彃鍏ョ殑鏁版嵁
+ var masterNeedUpdate = masterData.Where(i => resMaster.Contains(i.ORDER_NO)).ToList();// 闇�瑕佹洿鏂扮殑鏁版嵁
foreach (var item in masterNeedUpdate)
{
- item.ID = hostoryMasterData.Where(i => i.BILLCODE == item.BILLCODE).FirstOrDefault()?.ID;
+ item.ID = hostoryMasterData.Where(i => i.ORDER_NO == item.ORDER_NO).FirstOrDefault()?.ID;
}
#endregion 鍖哄垎涓昏〃闇�瑕佹彃鍏ュ強鏇存柊鐨勬暟鎹�
#region 鍖哄垎鏄庣粏琛ㄩ渶瑕佹彃鍏ュ強鏇存柊鐨勬暟鎹�
- var hostoryDetailData = db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => BILLCODELst.Contains(i.BILLCODE)).ToList();// 鑾峰彇鏄庣粏琛ㄦ棫鏁版嵁 鍓旈櫎鐘舵�佷负2鐨勬暟鎹�
+ var hostoryDetailData = db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => BILLCODELst.Contains(i.ORDER_NO)).ToList();// 鑾峰彇鏄庣粏琛ㄦ棫鏁版嵁 鍓旈櫎鐘舵�佷负2鐨勬暟鎹�
var resDetail = hostoryDetailData.Select(i => i.ITEM_CODE).Distinct().ToList();// 鑾峰彇鎵�鏈夌殑鐗╂枡缂栧彿
- var ignoreCode = hostoryDetailData.Where(i => i.LINESTATUS == 2 || i.LINESTATUS == 3).Select(i => i.ITEM_CODE).Distinct().ToList();// 闇�瑕佸拷鐣ョ殑鐗╂枡缂栧彿
+ var ignoreCode = hostoryDetailData.Where(i => i.STATUS == 2 || i.STATUS == 3).Select(i => i.ITEM_CODE).Distinct().ToList();// 闇�瑕佸拷鐣ョ殑鐗╂枡缂栧彿
var needInsertData = detailData.Where(i => !resDetail.Contains(i.ITEM_CODE) && !ignoreCode.Contains(i.ITEM_CODE)).ToList();// 闇�瑕佹彃鍏ョ殑鏁版嵁
if (type == "1")
{
foreach (var item in needInsertData)
{
- item.OUTQTY = 0;
+ item.QTY_OUT = 0;
}
}
@@ -87,9 +87,9 @@
foreach (var item in needUpdateDetail)
{
- if (item.LINESTATUS == 0 && type == "1")
+ if (item.STATUS == 0 && type == "1")
{
- item.OUTQTY = 0;
+ item.QTY_OUT = 0;
}
item.AUTH_ORG = input[0].AUTH_ORG;
}
@@ -97,7 +97,7 @@
var exceptCode = detailData.Select(i => i.ITEM_CODE).Distinct().ToList();
var deletecode = resDetail.Except(exceptCode).ToList();
- var needDeleteData = hostoryDetailData.Where(i => deletecode.Contains(i.ITEM_CODE) && BILLCODELst.Contains(i.BILLCODE)).ToList();
+ var needDeleteData = hostoryDetailData.Where(i => deletecode.Contains(i.ITEM_CODE) && BILLCODELst.Contains(i.ORDER_NO)).ToList();
foreach (var item in needUpdateDetail)
{
--
Gitblit v1.9.3