From bfa0a4079b2ac3f363826b7e329115f88b4bf0f5 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 22 十一月 2023 10:49:20 +0800
Subject: [PATCH] 生产开报工查询增加销售单号查询
---
VueWebApi/DLL/DAL/PurchaseOrderDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
index e905881..e4ecfa6 100644
--- a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
+++ b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
@@ -402,7 +402,7 @@
{
//鑾峰彇閲囪喘鍒拌揣鍗曠墿鏂欎俊鎭�
sql = @"select S.hpartcode as partcode,M.partname,M.partspec,M.uom_code,T.name as uom_name,
- S.hqty,S.hqty,S.hreturnqty,S.hacceptdate,S.hstorehousecode,K.name as hstorehousename,S.hcheckstaus
+ S.hqty,S.hinqty,S.hreturnqty,S.hacceptdate,S.hstorehousecode,K.name as hstorehousename,S.hcheckstaus
from T_PurchaseArrivalOrder A
left join T_PurchaseArrivalOrder_sub S on A.hbillno=S.hbillno
left join TMateriel_Info M on S.hpartcode=M.partcode
--
Gitblit v1.9.3