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/PrintController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/gdbg/gdbg/Controllers/PrintController.cs b/gdbg/gdbg/Controllers/PrintController.cs
index 2c41b38..3948f86 100644
--- a/gdbg/gdbg/Controllers/PrintController.cs
+++ b/gdbg/gdbg/Controllers/PrintController.cs
@@ -25,7 +25,7 @@
// 淇敼 SQL 鏌ヨ浠ヨ繑鍥炴洿澶氬瓧娈�
string query = "SELECT ITEM_BARCODE, TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS PRINT_DATE, b.STAFF_NAME,a.quantity " +
"FROM MES_INV_ITEM_BARCODES a left join MES_STAFF b on a.CREATE_BY=b.STAFF_NO " +
- "WHERE BILL_NO = :orderNo and TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD')=to_char(SYSDATE,'YYYY-MM-DD') " +
+ "WHERE BILL_NO = :orderNo and TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD')<=to_char(SYSDATE,'YYYY-MM-DD') and TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD')>=to_char(SYSDATE-2,'YYYY-MM-DD') " +
"order by a.CREATE_DATE desc";
--
Gitblit v1.9.3