From 60fd52175b5e3c788ddca4c11b4329dbfe959694 Mon Sep 17 00:00:00 2001
From: hao <1836460075@qq.com>
Date: 星期一, 19 五月 2025 16:36:09 +0800
Subject: [PATCH] 1
---
gdbg/gdbg/Controllers/OrderDetailsController.cs | 11 ++++++-----
1 files changed, 6 insertions(+), 5 deletions(-)
diff --git a/gdbg/gdbg/Controllers/OrderDetailsController.cs b/gdbg/gdbg/Controllers/OrderDetailsController.cs
index 8965a38..5bd370f 100644
--- a/gdbg/gdbg/Controllers/OrderDetailsController.cs
+++ b/gdbg/gdbg/Controllers/OrderDetailsController.cs
@@ -30,7 +30,7 @@
// 浣跨敤浣犳彁渚涚殑 SQL 鏌ヨ锛屽苟鏂板涓�涓瓧娈� daa002
var query = @"
- SELECT c.SALE_ORDER_NO, to_char(a.daa016,'YYYY-MM-DD HH24:MI:SS'), a.daa008, a.daa011, a.daa002,s.item_no,nvl(bz.bzsl,0),s.ITEM_NAME,s.ITEM_MODEL,
+ SELECT c.SALE_ORDER_NO, to_char(NVL(a.daa016, SYSDATE), 'YYYY-MM-DD HH24:MI:SS'), a.daa008, a.daa011, a.daa002,s.item_no,nvl(bz.bzsl,0),a.daa018,s.ITEM_NAME,s.ITEM_MODEL,
case when sj.FSECOND_RESU ='鍚堟牸' then 1 else case when sj.FSECOND_RESU ='涓嶅悎鏍�' then 2 else 0 end end sj,
case when xj.FCHECK_RESU ='鍚堟牸' then 1 else case when xj.FCHECK_RESU ='涓嶅悎鏍�' then 2 else 0 end end xj
FROM womdaa a left join BZFS_WH bz on bz.ITEM_ID=a.daa002
@@ -55,10 +55,11 @@
ItemId = reader.GetString(4) , // 鏂板瀛楁 item_id 瀵瑰簲 daa002
ItemNO=reader.GetString(5),
BZSL= reader.GetString(6), //鍖呰鏁�
- Itemname=reader.GetString(7),
- Itemmodel= reader.GetString(8),
- sj=reader.GetInt32(9),
- xj=reader.GetInt32(10)
+ GDZT= reader.GetString(7), //宸ュ崟鐘舵��
+ Itemname=reader.GetString(8),
+ Itemmodel= reader.GetString(9),
+ sj=reader.GetInt32(10),
+ xj=reader.GetInt32(11)
}, parameters);
if (orderDetailsList.Count == 0)
--
Gitblit v1.9.3