From a4699af3282d7abe89f9a9be40e8742fdd3b12b3 Mon Sep 17 00:00:00 2001 From: zc <zc> Date: 星期五, 01 十一月 2024 14:30:38 +0800 Subject: [PATCH] # --- 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