From 02b26bfaca24386f7b4f4a5e9f336812370ed49b Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期一, 22 十二月 2025 09:45:46 +0800
Subject: [PATCH] 获取BOM参数调整
---
service/Warehouse/MesXkyShdManager.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/service/Warehouse/MesXkyShdManager.cs b/service/Warehouse/MesXkyShdManager.cs
index cdb3113..0567540 100644
--- a/service/Warehouse/MesXkyShdManager.cs
+++ b/service/Warehouse/MesXkyShdManager.cs
@@ -68,9 +68,9 @@
D.item_model,
A.include_qty,
A.po_erp_no,
- ISNULL(B.OLDQTY,0) AS ysl
+ ISNULL(B.QUANTITY,0) AS ysl
FROM TBL_BARCODE_INFORMATION A
- LEFT JOIN MES_INV_ITEM_BARCODES B ON a.small_barcode = b.ITEM_BARCODE
+ LEFT JOIN MES_XKY_BARCODE_RE B ON a.small_barcode = b.ITEM_BARCODE
LEFT JOIN MES_ROH_IN_DATA C ON C.EBELN_K3ID = A.po_line_no
LEFT JOIN MES_ITEMS D ON D.item_id = C.item_id
WHERE A.delivery_no = @shdh";
--
Gitblit v1.9.3