From 71ca7c6fb00de749b2ba2180f1cc04e35574eb19 Mon Sep 17 00:00:00 2001 From: zhang <zc857179121@qq.com> Date: 星期一, 21 七月 2025 15:44:12 +0800 Subject: [PATCH] 1 --- src/main/java/com/zy/third/erp/task/ERPItemScheduler.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/third/erp/task/ERPItemScheduler.java b/src/main/java/com/zy/third/erp/task/ERPItemScheduler.java index 703e185..f5dd32b 100644 --- a/src/main/java/com/zy/third/erp/task/ERPItemScheduler.java +++ b/src/main/java/com/zy/third/erp/task/ERPItemScheduler.java @@ -33,7 +33,7 @@ public void ItemScheduler() { //log.info("ItemScheduler寮�濮嬩簡"); if (!erpEnabled) return; - String sqlItemTB = "select * from erp_ItemTB where LKName='涓壃浜屾湡'"; + String sqlItemTB = "select TOP 1000 * from erp_ItemTB where LKName='涓壃浜屾湡'"; List<ItemTB> itemTBS = erpSqlServer.select(sqlItemTB, ItemTB.class); if (itemTBS != null && itemTBS.size() > 0) { for (ItemTB itemTB : itemTBS) { -- Gitblit v1.9.1