From e150655a785de36a65a26a0dc4d3d6d65fe7e9d0 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期四, 04 五月 2023 18:03:37 +0800
Subject: [PATCH] 11111
---
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