From 24e1c6a1c3d5331b5a4f1111dcbae3ef148eda1a Mon Sep 17 00:00:00 2001
From: yzt <Xynz17@163.com>
Date: 星期一, 08 五月 2023 12:08:12 +0800
Subject: [PATCH] BS版本 1.20
---
src/main/java/com/hxzkoa/services/LabelService.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/LabelService.java b/src/main/java/com/hxzkoa/services/LabelService.java
index 614e949..0da66cc 100644
--- a/src/main/java/com/hxzkoa/services/LabelService.java
+++ b/src/main/java/com/hxzkoa/services/LabelService.java
@@ -64,7 +64,7 @@
sql = "SELECT id,tag_id,state,power,status,gaodu,sudu,pinglv,sleep_satus,sleep_time,gongfang,dong_status,version,addtime,imu,type FROM (SELECT id,tag_id,state,power,status,gaodu,sudu,pinglv,sleep_satus,sleep_time,gongfang,dong_status,version,addtime,imu,type FROM tb_tag ORDER BY id DESC) s LIMIT :start,:end";
query = this.em.createNativeQuery(sql);
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
- query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", 50);
List resultList = query.getResultList();
List<tb_tag> tb_tagList = new ArrayList<tb_tag>();
if (resultList.size() > 0) {
@@ -654,7 +654,7 @@
sql = "SELECT * FROM (SELECT * FROM tb_tagpower ORDER BY time DESC) tp LIMIT :start,:end";
query = this.em.createNativeQuery(sql);
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
- query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", 50);
List resultList = query.getResultList();
List<tb_tagpower> tagpowerList = new ArrayList<tb_tagpower>();
if (resultList.size() > 0) {
@@ -730,7 +730,7 @@
sql = "SELECT id,tagid,power,time FROM (SELECT * FROM tb_history_power ORDER BY time DESC) thp LIMIT :start,:end";
query = this.em.createNativeQuery(sql);
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
- query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", 50);
List resultList = query.getResultList();
List<tb_history_power> tb_history_powerList = new ArrayList<tb_history_power>();
if (resultList.size() > 0) {
--
Gitblit v1.10.0