From 6c25b3ab09696a6048b4621c54cb9066c5bd2eaa Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 14 十月 2025 23:51:33 +0800
Subject: [PATCH] 1.到货单收货优化
---
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