From 0ffb66720f215aeb107709445130faa3b38cbb84 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期五, 26 九月 2025 13:25:39 +0800
Subject: [PATCH] 1、
---
service/Warehouse/MesXkyShdManager.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/service/Warehouse/MesXkyShdManager.cs b/service/Warehouse/MesXkyShdManager.cs
index 002a115..1ca8274 100644
--- a/service/Warehouse/MesXkyShdManager.cs
+++ b/service/Warehouse/MesXkyShdManager.cs
@@ -46,7 +46,7 @@
A.erpline_id
from DELIVERY_NOTICE_DETAIL A
LEFT JOIN MES_ROH_IN_DATA C ON A.po_line_no = C.EBELN_K3ID
- LEFT JOIN MES_ITEMS D ON C.ITEM_ID = D.item_id
+ LEFT JOIN MES_ITEMS D ON A.product_code = D.item_id
LEFT JOIN dhmx ON dhmx.line_k3id = A.po_line_no AND dhmx.paper_bill_no = A.delivery_no
WHERE A.delivery_no = @shdh";
--
Gitblit v1.9.3