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/OrdersController.cs | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/gdbg/gdbg/Controllers/OrdersController.cs b/gdbg/gdbg/Controllers/OrdersController.cs
index 4b6e80a..d7d5d3b 100644
--- a/gdbg/gdbg/Controllers/OrdersController.cs
+++ b/gdbg/gdbg/Controllers/OrdersController.cs
@@ -28,7 +28,7 @@
}
// 瀹氫箟鑾峰彇宸ュ崟鏁版嵁鐨� SQL 鏌ヨ
- var query = "SELECT daa001, nvl(b.qty, 0) FROM womdaa a left join (select sum(QUANTITY) qty, PBILL_NO from MES_WORK_PROD_C_DETAILS where to_char(CREATE_DATE, 'YYYY-MM-DD') = to_char(sysdate, 'YYYY-MM-DD') group by PBILL_NO) b on a.daa001 = b.PBILL_NO left Join womcaa c on c.caa001=a.daa014 WHERE SJ_XTNO = :lineNo and (daa018 = '宸插紑宸�'or daa018 = '寰呭紑宸�' or daa018='鏈紑宸�') and c.JA_BS<>1 order by a.BC_TIME ";
+ var query = "SELECT daa001, nvl(b.qty, 0) FROM womdaa a left join (select sum(QUANTITY) qty, PBILL_NO from MES_WORK_PROD_C_DETAILS where to_char(CREATE_DATE, 'YYYY-MM-DD') = to_char(sysdate, 'YYYY-MM-DD') group by PBILL_NO) b on a.daa001 = b.PBILL_NO left Join womcaa c on c.caa001=a.daa014 WHERE SJ_XTNO = :lineNo and ( daa018 = '寰呭紑宸�' or daa018='鏆傚仠'or daa018='宸插紑宸�') and c.JA_BS<>1 and A.FSTATUS=1 order by a.BC_TIME ";
// 瀹氫箟 SQL 鏌ヨ鐨勫弬鏁�
var parameters = new List<OracleParameter>
@@ -46,5 +46,7 @@
return Ok(orders); // 杩斿洖缁撴灉
}
+ //20250410 淇敼涓鸿皟鐢ㄥ瓨鍌ㄨ繃绋�
+
}
}
--
Gitblit v1.9.3