From 753361f589444455fe1b20476c658201ccd92c38 Mon Sep 17 00:00:00 2001
From: helongyang <647556386@qq.com>
Date: 星期三, 30 七月 2025 09:53:19 +0800
Subject: [PATCH] 更新优化
---
代码管理/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/ProStockInfoRepository.cs | 9 ++++-----
1 files changed, 4 insertions(+), 5 deletions(-)
diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/ProStockInfoRepository.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/ProStockInfoRepository.cs"
index f27bff3..7063262 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/ProStockInfoRepository.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/ProStockInfoRepository.cs"
@@ -56,7 +56,7 @@
.Any(v =>
v.ProductCode == proOutOrderDetail.PCode
&& v.ProductVersion.StartsWith(proOutOrderDetail.PVer.Substring(0,1))
- && (isCanLot ? isCanLot : v.BagNo == proOutOrderDetail.PLot)
+ && (isCanLot ? isCanLot : v.ProductCode == proOutOrderDetail.PLot)
&& (isCanDate ? isCanDate : v.DateCode == proOutOrderDetail.DateCode)
))
.ToList();
@@ -74,11 +74,10 @@
{
List<Dt_ProStockInfo>? proStockInfos = null;
bool isCanDate = string.IsNullOrEmpty(mesRworkOutboundOrder.DateCode);
- proStockInfos = Db.Queryable<Dt_ProStockInfo>().Where(x => locationInfos.Contains(x.LocationCode) && x.ProStockAttribute==ProStockAttributeEnum.灏炬暟.ObjToInt())
+ proStockInfos = Db.Queryable<Dt_ProStockInfo>().Where(x => locationInfos.Contains(x.LocationCode))
.Includes(x => x.proStockInfoDetails)
.Where(x => x.proStockInfoDetails
- .Any(v => v.SaleOrder == mesRworkOutboundOrder.SaleOrder
- && v.ProductCode == mesRworkOutboundOrder.ProductCode
+ .Any(v => v.ProductCode == mesRworkOutboundOrder.ProductCode
&& v.ProductVersion == mesRworkOutboundOrder.ProductVersion
&& (isCanDate ? isCanDate : v.DateCode == mesRworkOutboundOrder.DateCode)
))
@@ -99,7 +98,7 @@
.Includes(x => x.proStockInfoDetails)
.Where(x => x.proStockInfoDetails
.Any(v =>
- v.ProductCode == erpProScrapSheetDetail.ScrapProLotNo
+ v.LotNumber == erpProScrapSheetDetail.ScrapProLotNo
&& v.ProductCode == erpProScrapSheetDetail.ScrapProCode
&& v.ProductVersion == erpProScrapSheetDetail.ScrapProVersion
))
--
Gitblit v1.9.3