From ef80475ef6f2b80274a0885847dc1bbed0c5cff2 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期四, 20 三月 2025 14:14:58 +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