From 63d047db30e03608479ab3d340e925bc3366357c Mon Sep 17 00:00:00 2001
From: huawei <huawei@2214094776>
Date: 星期六, 20 十二月 2025 09:11:45 +0800
Subject: [PATCH] 看板模块
---
service/Warehouse/MesXkyShdManager.cs | 9 +++++----
1 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/service/Warehouse/MesXkyShdManager.cs b/service/Warehouse/MesXkyShdManager.cs
index dd9a9d2..1ca8274 100644
--- a/service/Warehouse/MesXkyShdManager.cs
+++ b/service/Warehouse/MesXkyShdManager.cs
@@ -42,10 +42,11 @@
A.delivery_qty - ISNULL(dhmx.quantity, 0) as dssl,
A.po_erp_no,
C.PURCHASE_ORDER_LINE_NUMBER,
- dhmx.GUID AS DDHID
+ dhmx.GUID AS DDHID,
+ 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";
@@ -62,8 +63,8 @@
//// 浣跨敤鍙傛暟鍖栨煡璇㈤槻姝QL娉ㄥ叆
var sqlParams = new List<SugarParameter> { new("@shdh", unity.shdh) };
- var sql2 = @"SELECT A.small_barcode,
- D.item_no,
+ var sql2 = @"SELECT A.small_barcode,
+ D.item_no,
D.item_name,
D.item_model,
A.include_qty,
--
Gitblit v1.9.3