From 6f6f118881771a70feb186061ebb4ccd03a47e68 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 9月 2025 15:12:31 +0800
Subject: [PATCH] 优化查询
---
wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs | 2 +-
wcs/yunneiWCS/yunneiWCS/ORM/productStockList.cs | 3 +++
2 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs b/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs
index e439d9f..584fea9 100644
--- a/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs
+++ b/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs
@@ -172,7 +172,7 @@
var stock = mod.productStock.Where(a => a.containerCode == _task.containerCode).FirstOrDefault();
if (stock != null)
{
- System.Collections.Generic.List<productStockList> productStocks = mod.productStockList.Where(a => a.stockId == stock.stockId).ToList();
+ System.Collections.Generic.List<productStockList> productStocks = mod.productStockList.Where(a => a.stockId == stock.positionId).ToList();
AddRecord(mod, _outInFlag, positionName, _task, remark,
productStocks, currentTaskType);
}
diff --git a/wcs/yunneiWCS/yunneiWCS/ORM/productStockList.cs b/wcs/yunneiWCS/yunneiWCS/ORM/productStockList.cs
index 0139809..03db8eb 100644
--- a/wcs/yunneiWCS/yunneiWCS/ORM/productStockList.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ORM/productStockList.cs
@@ -12,6 +12,9 @@
[Key]
public long stockListId { get; set; }
+ /// <summary>
+ /// 表position的positionId
+ /// </summary>
public long? stockId { get; set; }
[StringLength(50)]
--
Gitblit v1.9.3