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/WarningService.java | 620 ++++++++++++++++++++++++++++++++-----------------------
1 files changed, 362 insertions(+), 258 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/WarningService.java b/src/main/java/com/hxzkoa/services/WarningService.java
index 34c5415..9e6acb0 100644
--- a/src/main/java/com/hxzkoa/services/WarningService.java
+++ b/src/main/java/com/hxzkoa/services/WarningService.java
@@ -1,18 +1,10 @@
+//
+// Source code recreated from a .class file by IntelliJ IDEA
+// (powered by FernFlower decompiler)
+//
+
package com.hxzkoa.services;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-
-import javax.persistence.EntityManager;
-import javax.persistence.PersistenceContext;
-import javax.persistence.Query;
-
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Transactional;
-
import com.hxzkoa.json.tb_historyinwarning;
import com.hxzkoa.json.tb_lixianrecord;
import com.hxzkoa.json.tb_message_history;
@@ -22,6 +14,16 @@
import com.hxzkoa.json.tb_warning;
import com.hxzkoa.util.Config;
import com.hxzkoa.util.ModifyConfig;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import javax.persistence.Query;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
@Service
public class WarningService {
@@ -30,18 +32,21 @@
@Autowired
private CaozuoService cs;
+ public WarningService() {
+ }
+
public List<tb_warning> getWarningSummary() {
String sql = null;
Query query = null;
sql = "SELECT id,type,objectid,`status`,time FROM tb_warning";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
- List<tb_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -49,6 +54,7 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
@@ -58,14 +64,14 @@
sql = "SELECT id,type,objectid,`status`,time,baoliu1 FROM tb_warning ORDER BY id DESC 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_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -74,21 +80,74 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
-
+
+ public List<tb_warning> iframeSoS(int page) {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT id,type,objectid,`status`,time,baoliu1 FROM tb_warning WHERE type = 'SOS' ORDER BY id DESC LIMIT :start,:end";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", 50);
+ List resultList = query.getResultList();
+ List<tb_warning> tb_warningList = new ArrayList();
+ if (resultList.size() > 0) {
+ for(int i = 0; i < resultList.size(); ++i) {
+ tb_warning warning = new tb_warning();
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
+ warning.setType(obj[1] == null ? "" : obj[1].toString());
+ warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
+ warning.setStatus(obj[3] == null ? "" : obj[3].toString());
+ warning.setTime(obj[4] == null ? "" : obj[4].toString());
+ warning.setBaoliu1(obj[5] == null ? "" : obj[5].toString());
+ tb_warningList.add(warning);
+ }
+ }
+
+ return tb_warningList;
+ }
+
+ public List<tb_warning> iframeDdl(int page) {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT id,type,objectid,`status`,time,baoliu1 FROM tb_warning WHERE type = '浣庣數閲�' ORDER BY id DESC LIMIT :start,:end";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", 50);
+ List resultList = query.getResultList();
+ List<tb_warning> tb_warningList = new ArrayList();
+ if (resultList.size() > 0) {
+ for(int i = 0; i < resultList.size(); ++i) {
+ tb_warning warning = new tb_warning();
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
+ warning.setType(obj[1] == null ? "" : obj[1].toString());
+ warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
+ warning.setStatus(obj[3] == null ? "" : obj[3].toString());
+ warning.setTime(obj[4] == null ? "" : obj[4].toString());
+ warning.setBaoliu1(obj[5] == null ? "" : obj[5].toString());
+ tb_warningList.add(warning);
+ }
+ }
+
+ return tb_warningList;
+ }
+
public List<tb_warning> getWarningSummarya() {
String sql = null;
Query query = null;
sql = "SELECT id,type,objectid,`status`,time,baoliu1,baoliu2,baoliu3 FROM tb_warning ORDER BY id DESC";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
- List<tb_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -99,6 +158,7 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
@@ -117,12 +177,12 @@
query = this.em.createNativeQuery(sql);
query.setParameter("objectid", input);
List resultList = query.getResultList();
- List<tb_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -131,6 +191,7 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
@@ -142,21 +203,25 @@
query = this.em.createNativeQuery(sql);
query.setParameter("str", str);
List resultList = query.getResultList();
- Map<String, Integer> reMap = new HashMap<String, Integer>();
- int warningSummaryCount = getWarningSummaryCount();
+ Map<String, Integer> reMap = new HashMap();
+ int warningSummaryCount = this.getWarningSummaryCount();
+ int i;
+ Object[] obj;
if (resultList.size() > 3) {
- for (int i = 0; i < 3; i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(i = 0; i < 3; ++i) {
+ obj = (Object[])((Object[])resultList.get(i));
reMap.put(obj[0].toString(), Integer.parseInt(obj[1].toString()));
- warningSummaryCount = warningSummaryCount - Integer.parseInt(obj[1].toString());
+ warningSummaryCount -= Integer.parseInt(obj[1].toString());
}
+
reMap.put("鍏朵粬", warningSummaryCount);
} else {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(i = 0; i < resultList.size(); ++i) {
+ obj = (Object[])((Object[])resultList.get(i));
reMap.put(obj[0].toString(), Integer.parseInt(obj[1].toString()));
}
}
+
return reMap;
}
@@ -166,12 +231,12 @@
sql = "SELECT id,area,name,bumen,tagid,intime FROM tb_realinwarning";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
- List<tb_realinwarning> tb_realinwarningList = new ArrayList<tb_realinwarning>();
+ List<tb_realinwarning> tb_realinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_realinwarning realinwarning = new tb_realinwarning();
- Object[] obj = (Object[]) resultList.get(i);
- realinwarning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ realinwarning.setId((Integer)obj[0]);
realinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
realinwarning.setName(obj[2] == null ? "" : obj[2].toString());
realinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -180,6 +245,7 @@
tb_realinwarningList.add(realinwarning);
}
}
+
return tb_realinwarningList;
}
@@ -189,14 +255,14 @@
sql = "SELECT id,area,name,bumen,tagid,intime FROM tb_realinwarning 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_realinwarning> tb_realinwarningList = new ArrayList<tb_realinwarning>();
+ List<tb_realinwarning> tb_realinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_realinwarning realinwarning = new tb_realinwarning();
- Object[] obj = (Object[]) resultList.get(i);
- realinwarning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ realinwarning.setId((Integer)obj[0]);
realinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
realinwarning.setName(obj[2] == null ? "" : obj[2].toString());
realinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -205,21 +271,22 @@
tb_realinwarningList.add(realinwarning);
}
}
+
return tb_realinwarningList;
}
-
+
public List<tb_realinwarning> getRealinWarninga() {
String sql = null;
Query query = null;
sql = "SELECT id,area,name,bumen,tagid,intime FROM tb_realinwarning";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
- List<tb_realinwarning> tb_realinwarningList = new ArrayList<tb_realinwarning>();
+ List<tb_realinwarning> tb_realinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_realinwarning realinwarning = new tb_realinwarning();
- Object[] obj = (Object[]) resultList.get(i);
- realinwarning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ realinwarning.setId((Integer)obj[0]);
realinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
realinwarning.setName(obj[2] == null ? "" : obj[2].toString());
realinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -228,6 +295,7 @@
tb_realinwarningList.add(realinwarning);
}
}
+
return tb_realinwarningList;
}
@@ -243,28 +311,32 @@
public void realinWarning_delete(String[] checkVal) {
String sql = null;
Query query = null;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_realinwarning WHERE id = :id";
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
}
-
+
@Transactional
public int realinWarning_deletea(String[] checkVal) {
String sql = null;
Query query = null;
int aaa = checkVal.length;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_realinwarning WHERE id = :id";
- cs.tb_caozuo("tb_realinwarning", 2);
+ this.cs.tb_caozuo("tb_realinwarning", 2);
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
return aaa;
}
@@ -273,17 +345,17 @@
String sql = null;
Query query = null;
sql = "DELETE FROM tb_realinwarning";
- cs.tb_caozuo("tb_realinwarning", 2);
+ this.cs.tb_caozuo("tb_realinwarning", 2);
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
-
+
@Transactional
public int realinWarning_deleteAlla() {
String sql = null;
Query query = null;
sql = "DELETE FROM tb_realinwarning";
- cs.tb_caozuo("tb_realinwarning", 2);
+ this.cs.tb_caozuo("tb_realinwarning", 2);
query = this.em.createNativeQuery(sql);
int aaa = query.executeUpdate();
return aaa;
@@ -296,11 +368,11 @@
query = this.em.createNativeQuery(sql);
query.setParameter("tag_id", input);
List resultList = query.getResultList();
- List<tb_realinwarning> tb_realinwarningList = new ArrayList<tb_realinwarning>();
+ List<tb_realinwarning> tb_realinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_realinwarning realinwarning = new tb_realinwarning();
- Object[] obj = (Object[]) resultList.get(i);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
realinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
realinwarning.setName(obj[2] == null ? "" : obj[2].toString());
realinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -309,6 +381,7 @@
tb_realinwarningList.add(realinwarning);
}
}
+
return tb_realinwarningList;
}
@@ -318,12 +391,12 @@
sql = "SELECT id,area,name,bumen,tagid,intime,outtime,alltime,beizhu FROM tb_historyinwarning";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
- List<tb_historyinwarning> tb_historyinwarningList = new ArrayList<tb_historyinwarning>();
+ List<tb_historyinwarning> tb_historyinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(int i = 0; i < resultList.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultList.get(i));
tb_historyinwarning historyinwarning = new tb_historyinwarning();
- historyinwarning.setId((int) obj[0]);
+ historyinwarning.setId((Integer)obj[0]);
historyinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
historyinwarning.setName(obj[2] == null ? "" : obj[2].toString());
historyinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -335,6 +408,7 @@
tb_historyinwarningList.add(historyinwarning);
}
}
+
return tb_historyinwarningList;
}
@@ -344,14 +418,14 @@
sql = "SELECT id,area,name,bumen,tagid,intime,outtime,alltime,beizhu FROM tb_historyinwarning 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_historyinwarning> tb_historyinwarningList = new ArrayList<tb_historyinwarning>();
+ List<tb_historyinwarning> tb_historyinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(int i = 0; i < resultList.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultList.get(i));
tb_historyinwarning historyinwarning = new tb_historyinwarning();
- historyinwarning.setId((int) obj[0]);
+ historyinwarning.setId((Integer)obj[0]);
historyinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
historyinwarning.setName(obj[2] == null ? "" : obj[2].toString());
historyinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -363,21 +437,22 @@
tb_historyinwarningList.add(historyinwarning);
}
}
+
return tb_historyinwarningList;
}
-
+
public List<tb_historyinwarning> getHistoricalWarninga() {
String sql = null;
Query query = null;
sql = "SELECT id,area,name,bumen,tagid,intime,outtime,alltime,beizhu FROM tb_historyinwarning";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
- List<tb_historyinwarning> tb_historyinwarningList = new ArrayList<tb_historyinwarning>();
+ List<tb_historyinwarning> tb_historyinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(int i = 0; i < resultList.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultList.get(i));
tb_historyinwarning historyinwarning = new tb_historyinwarning();
- historyinwarning.setId((int) obj[0]);
+ historyinwarning.setId((Integer)obj[0]);
historyinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
historyinwarning.setName(obj[2] == null ? "" : obj[2].toString());
historyinwarning.setBumen(obj[3] == null ? "" : obj[3].toString());
@@ -389,6 +464,7 @@
tb_historyinwarningList.add(historyinwarning);
}
}
+
return tb_historyinwarningList;
}
@@ -404,59 +480,67 @@
public void historicalWarning_delete(String[] checkVal) {
String sql = null;
Query query = null;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_historyinwarning WHERE id = :id";
- cs.tb_caozuo("tb_historyinwarning", 2);
+ this.cs.tb_caozuo("tb_historyinwarning", 2);
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
}
-
+
@Transactional
public int historicalWarning_deletea(String[] checkVal) {
String sql = null;
Query query = null;
int aaa = checkVal.length;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_historyinwarning WHERE id = :id";
- cs.tb_caozuo("tb_historyinwarning", 2);
+ this.cs.tb_caozuo("tb_historyinwarning", 2);
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
return aaa;
}
-
+
@Transactional
public void Warning_delete(String[] checkVal) {
String sql = null;
Query query = null;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_warning WHERE id = :id";
- cs.tb_caozuo("tb_warning", 2);
+ this.cs.tb_caozuo("tb_warning", 2);
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
}
-
+
@Transactional
public int Warning_deletea(String[] checkVal) {
String sql = null;
Query query = null;
int aaa = checkVal.length;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_warning WHERE id = :id";
- cs.tb_caozuo("tb_warning", 2);
+ this.cs.tb_caozuo("tb_warning", 2);
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
return aaa;
}
@@ -465,87 +549,89 @@
String sql = null;
Query query = null;
sql = "DELETE FROM tb_historyinwarning";
- cs.tb_caozuo("tb_historyinwarning", 2);
+ this.cs.tb_caozuo("tb_historyinwarning", 2);
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
-
+
@Transactional
public int historicalWarning_deleteAlla() {
String sql = null;
Query query = null;
sql = "DELETE FROM tb_historyinwarning";
- cs.tb_caozuo("tb_historyinwarning", 2);
+ this.cs.tb_caozuo("tb_historyinwarning", 2);
query = this.em.createNativeQuery(sql);
int aaa = query.executeUpdate();
return aaa;
}
-
+
@Transactional
public void Warning_deleteAll() {
String sql = null;
Query query = null;
sql = "DELETE FROM tb_warning";
- cs.tb_caozuo("tb_warning", 2);
+ this.cs.tb_caozuo("tb_warning", 2);
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
-
+
@Transactional
public int Warning_deleteAlla() {
String sql = null;
Query query = null;
sql = "DELETE FROM tb_warning";
- cs.tb_caozuo("tb_warning", 2);
+ this.cs.tb_caozuo("tb_warning", 2);
query = this.em.createNativeQuery(sql);
int aaa = query.executeUpdate();
return aaa;
}
-
+
@Transactional
public void Warning_deletefenlei(String fenlei) {
String sql = null;
Query query = null;
sql = "DELETE FROM tb_warning WHERE type=:fenlei";
- cs.tb_caozuo("tb_warning", 2);
+ this.cs.tb_caozuo("tb_warning", 2);
query = this.em.createNativeQuery(sql);
query.setParameter("fenlei", fenlei);
query.executeUpdate();
}
-
+
@Transactional
public int historicalWarning_handle(String[] checkVal) {
String sql = null;
Query query = null;
int aaa = checkVal.length;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "UPDATE tb_warning SET status='宸插鐞�' WHERE objectid = :id";
- cs.tb_caozuo("tb_warning", 3);
+ this.cs.tb_caozuo("tb_warning", 3);
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
return aaa;
}
-
+
@Transactional
public int historicalWarning_handleAll() {
String sql = null;
Query query = null;
sql = "UPDATE tb_warning SET status='宸插鐞�'";
- cs.tb_caozuo("tb_warning", 3);
+ this.cs.tb_caozuo("tb_warning", 3);
query = this.em.createNativeQuery(sql);
int aaa = query.executeUpdate();
return aaa;
}
-
+
@Transactional
public void historicalWarning_handleAll_realpositoin() {
String sql = null;
Query query = null;
sql = "UPDATE tb_realpositoin SET sos='0'";
- cs.tb_caozuo("tb_realpositoin", 3);
+ this.cs.tb_caozuo("tb_realpositoin", 3);
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
@@ -557,10 +643,10 @@
query = this.em.createNativeQuery(sql);
query.setParameter("tag_id", input);
List resultList = query.getResultList();
- List<tb_historyinwarning> tb_historyinwarningList = new ArrayList<tb_historyinwarning>();
+ List<tb_historyinwarning> tb_historyinwarningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(int i = 0; i < resultList.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultList.get(i));
tb_historyinwarning historyinwarning = new tb_historyinwarning();
historyinwarning.setArea(obj[1] == null ? "" : obj[1].toString());
historyinwarning.setName(obj[2] == null ? "" : obj[2].toString());
@@ -573,6 +659,7 @@
tb_historyinwarningList.add(historyinwarning);
}
}
+
return tb_historyinwarningList;
}
@@ -581,7 +668,7 @@
String sql = null;
Query query = null;
sql = "INSERT tb_warning (type,objectid,status,time) VALUES (:type,:objectid,:status,now())";
- cs.tb_caozuo("tb_warning", 1);
+ this.cs.tb_caozuo("tb_warning", 1);
query = this.em.createNativeQuery(sql);
query.setParameter("type", warning.getType().toString());
query.setParameter("objectid", warning.getObjectid());
@@ -594,7 +681,7 @@
String sql = null;
Query query = null;
sql = "INSERT tb_realinwarning (area,name,bumen,tagid,intime) VALUES (:area,:name,:bumen,:tagid,now())";
- cs.tb_caozuo("tb_realinwarning", 1);
+ this.cs.tb_caozuo("tb_realinwarning", 1);
query = this.em.createNativeQuery(sql);
query.setParameter("area", realinwarning.getArea());
query.setParameter("name", realinwarning.getName());
@@ -602,7 +689,7 @@
query.setParameter("tagid", realinwarning.getTagid());
query.executeUpdate();
}
-
+
public List<tb_warning> getleixing(String fenlei) {
String sql = null;
Query query = null;
@@ -610,12 +697,12 @@
query = this.em.createNativeQuery(sql);
query.setParameter("fenlei", fenlei);
List resultList = query.getResultList();
- List<tb_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -624,9 +711,10 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
-
+
public List<tb_warning> getzhuangtai(String fenlei) {
String sql = null;
Query query = null;
@@ -634,12 +722,12 @@
query = this.em.createNativeQuery(sql);
query.setParameter("fenlei", fenlei);
List resultList = query.getResultList();
- List<tb_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -648,10 +736,11 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
-
- public List<tb_warning> getshuangshai(String fenlei,String fenlei2) {
+
+ public List<tb_warning> getshuangshai(String fenlei, String fenlei2) {
String sql = null;
Query query = null;
sql = "SELECT id,type,objectid,`status`,time,baoliu1 FROM tb_warning WHERE type=:fenlei and status=:fenlei2 ORDER BY id DESC";
@@ -659,12 +748,12 @@
query.setParameter("fenlei", fenlei);
query.setParameter("fenlei2", fenlei2);
List resultList = query.getResultList();
- List<tb_warning> tb_warningList = new ArrayList<tb_warning>();
+ List<tb_warning> tb_warningList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
+ for(int i = 0; i < resultList.size(); ++i) {
tb_warning warning = new tb_warning();
- Object[] obj = (Object[]) resultList.get(i);
- warning.setId((int) obj[0]);
+ Object[] obj = (Object[])((Object[])resultList.get(i));
+ warning.setId((Integer)obj[0]);
warning.setType(obj[1] == null ? "" : obj[1].toString());
warning.setObjectid(obj[2] == null ? "" : obj[2].toString());
warning.setStatus(obj[3] == null ? "" : obj[3].toString());
@@ -673,9 +762,10 @@
tb_warningList.add(warning);
}
}
+
return tb_warningList;
}
-
+
public List<tb_tag> getPermissionManagement(int page) {
String sql = null;
Query query = null;
@@ -684,12 +774,12 @@
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
List resultList = query.getResultList();
- List<tb_tag> tb_tagList = new ArrayList<tb_tag>();
+ List<tb_tag> tb_tagList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(int i = 0; i < resultList.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultList.get(i));
tb_tag tag = new tb_tag();
- tag.setId((int) obj[0]);
+ tag.setId((Integer)obj[0]);
tag.setStatus(obj[4] == null ? "" : obj[4].toString());
tag.setTag_id(obj[1] == null ? "" : obj[1].toString());
tag.setState(obj[2] == null ? "" : obj[2].toString());
@@ -703,11 +793,12 @@
tb_tagList.add(tag);
}
}
+
return tb_tagList;
}
-
+
@Transactional
- public int permissionupdate(String baoliu18,String tagid) {
+ public int permissionupdate(String baoliu18, String tagid) {
String sql = null;
Query query = null;
sql = "UPDATE tb_person SET baoliu18=:baoliu18 WHERE p_tagid = :tagid";
@@ -717,7 +808,7 @@
int aaa = query.executeUpdate();
return aaa;
}
-
+
public List<tb_tag> getPermissionid(String tagid) {
String sql = null;
Query query = null;
@@ -725,12 +816,12 @@
query = this.em.createNativeQuery(sql);
query.setParameter("tagid", tagid);
List resultList = query.getResultList();
- List<tb_tag> tb_tagList = new ArrayList<tb_tag>();
+ List<tb_tag> tb_tagList = new ArrayList();
if (resultList.size() > 0) {
- for (int i = 0; i < resultList.size(); i++) {
- Object[] obj = (Object[]) resultList.get(i);
+ for(int i = 0; i < resultList.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultList.get(i));
tb_tag tag = new tb_tag();
- tag.setId((int) obj[0]);
+ tag.setId((Integer)obj[0]);
tag.setStatus(obj[4] == null ? "" : obj[4].toString());
tag.setTag_id(obj[1] == null ? "" : obj[1].toString());
tag.setState(obj[2] == null ? "" : obj[2].toString());
@@ -744,10 +835,11 @@
tb_tagList.add(tag);
}
}
+
return tb_tagList;
}
-
- public List<tb_permission> findpermission(int page){
+
+ public List<tb_permission> findpermission(int page) {
String sql = null;
Query query = null;
sql = "select * from tb_permission ORDER BY addtime DESC LIMIT :start,:end";
@@ -755,24 +847,25 @@
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
List resultlist = query.getResultList();
- List<tb_permission> permissions = new ArrayList<>();
+ List<tb_permission> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_permission per = new tb_permission();
- per.setId((int)obj[0]);
- per.setType(obj[1] == null?null:obj[1].toString());
- per.setName(obj[2] == null?null:obj[2].toString());
- per.setTagid(obj[3] == null?null:obj[3].toString());
- per.setEvent(obj[4] == null?null:obj[4].toString());
- per.setAddtime(obj[5] == null?null:obj[5].toString());
- per.setDetails(obj[6] == null?null:obj[6].toString());
+ per.setId((Integer)obj[0]);
+ per.setType(obj[1] == null ? null : obj[1].toString());
+ per.setName(obj[2] == null ? null : obj[2].toString());
+ per.setTagid(obj[3] == null ? null : obj[3].toString());
+ per.setEvent(obj[4] == null ? null : obj[4].toString());
+ per.setAddtime(obj[5] == null ? null : obj[5].toString());
+ per.setDetails(obj[6] == null ? null : obj[6].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
+
public int getperManagementCount() {
String sql = null;
Query query = null;
@@ -780,7 +873,7 @@
query = this.em.createNativeQuery(sql);
return Integer.parseInt(query.getSingleResult().toString());
}
-
+
@Transactional
public void Warning_deleteper(String id) {
String sql = null;
@@ -790,7 +883,7 @@
query.setParameter("id", id);
query.executeUpdate();
}
-
+
@Transactional
public void Warning_deleteper2() {
String sql = null;
@@ -799,32 +892,33 @@
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
-
- public List<tb_permission> findidpermission2(String tagid){
+
+ public List<tb_permission> findidpermission2(String tagid) {
String sql = null;
Query query = null;
sql = "select * from tb_permission WHERE name = :tagid OR tagid = :tagid ORDER BY addtime DESC";
query = this.em.createNativeQuery(sql);
query.setParameter("tagid", tagid);
List resultlist = query.getResultList();
- List<tb_permission> permissions = new ArrayList<>();
+ List<tb_permission> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_permission per = new tb_permission();
- per.setId((int)obj[0]);
- per.setType(obj[1] == null?null:obj[1].toString());
- per.setName(obj[2] == null?null:obj[2].toString());
- per.setTagid(obj[3] == null?null:obj[3].toString());
- per.setEvent(obj[4] == null?null:obj[4].toString());
- per.setAddtime(obj[5] == null?null:obj[5].toString());
- per.setDetails(obj[6] == null?null:obj[6].toString());
+ per.setId((Integer)obj[0]);
+ per.setType(obj[1] == null ? null : obj[1].toString());
+ per.setName(obj[2] == null ? null : obj[2].toString());
+ per.setTagid(obj[3] == null ? null : obj[3].toString());
+ per.setEvent(obj[4] == null ? null : obj[4].toString());
+ per.setAddtime(obj[5] == null ? null : obj[5].toString());
+ per.setDetails(obj[6] == null ? null : obj[6].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
+
@Transactional
public void permission_add(tb_permission permission) {
String sql = null;
@@ -838,67 +932,69 @@
query.setParameter("details", permission.getDetails());
query.executeUpdate();
}
-
- public List<tb_message_history> findmessage(int page){
+
+ public List<tb_message_history> findmessage(int page) {
String sql = null;
Query query = null;
sql = "select * from tb_message_history ORDER BY sendtime DESC 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_message_history> permissions = new ArrayList<>();
+ List<tb_message_history> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_message_history per = new tb_message_history();
- per.setId((int)obj[0]);
- per.setBianma(obj[1] == null?null:obj[1].toString());
- per.setTagid(obj[2] == null?null:obj[2].toString());
- per.setUsername(obj[3] == null?null:obj[3].toString());
- per.setInfo(obj[4] == null?null:obj[4].toString());
- per.setSendtime(obj[5] == null?null:obj[5].toString());
- per.setReplytime(obj[6] == null?null:obj[6].toString());
- per.setBaoliu1(obj[7] == null?null:obj[7].toString());
- per.setBaoliu2(obj[8] == null?null:obj[8].toString());
- per.setBaoliu3(obj[9] == null?null:obj[9].toString());
- per.setBaoliu4(obj[10] == null?null:obj[10].toString());
- per.setBaoliu5(obj[11] == null?null:obj[11].toString());
+ per.setId((Integer)obj[0]);
+ per.setBianma(obj[1] == null ? null : obj[1].toString());
+ per.setTagid(obj[2] == null ? null : obj[2].toString());
+ per.setUsername(obj[3] == null ? null : obj[3].toString());
+ per.setInfo(obj[4] == null ? null : obj[4].toString());
+ per.setSendtime(obj[5] == null ? null : obj[5].toString());
+ per.setReplytime(obj[6] == null ? null : obj[6].toString());
+ per.setBaoliu1(obj[7] == null ? null : obj[7].toString());
+ per.setBaoliu2(obj[8] == null ? null : obj[8].toString());
+ per.setBaoliu3(obj[9] == null ? null : obj[9].toString());
+ per.setBaoliu4(obj[10] == null ? null : obj[10].toString());
+ per.setBaoliu5(obj[11] == null ? null : obj[11].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
- public List<tb_message_history> findmessage2(){
+
+ public List<tb_message_history> findmessage2() {
String sql = null;
Query query = null;
sql = "select * from tb_message_history ORDER BY sendtime DESC";
query = this.em.createNativeQuery(sql);
List resultlist = query.getResultList();
- List<tb_message_history> permissions = new ArrayList<>();
+ List<tb_message_history> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_message_history per = new tb_message_history();
- per.setId((int)obj[0]);
- per.setBianma(obj[1] == null?null:obj[1].toString());
- per.setTagid(obj[2] == null?null:obj[2].toString());
- per.setUsername(obj[3] == null?null:obj[3].toString());
- per.setInfo(obj[4] == null?null:obj[4].toString());
- per.setSendtime(obj[5] == null?null:obj[5].toString());
- per.setReplytime(obj[6] == null?null:obj[6].toString());
- per.setBaoliu1(obj[7] == null?null:obj[7].toString());
- per.setBaoliu2(obj[8] == null?null:obj[8].toString());
- per.setBaoliu3(obj[9] == null?null:obj[9].toString());
- per.setBaoliu4(obj[10] == null?null:obj[10].toString());
- per.setBaoliu5(obj[11] == null?null:obj[11].toString());
+ per.setId((Integer)obj[0]);
+ per.setBianma(obj[1] == null ? null : obj[1].toString());
+ per.setTagid(obj[2] == null ? null : obj[2].toString());
+ per.setUsername(obj[3] == null ? null : obj[3].toString());
+ per.setInfo(obj[4] == null ? null : obj[4].toString());
+ per.setSendtime(obj[5] == null ? null : obj[5].toString());
+ per.setReplytime(obj[6] == null ? null : obj[6].toString());
+ per.setBaoliu1(obj[7] == null ? null : obj[7].toString());
+ per.setBaoliu2(obj[8] == null ? null : obj[8].toString());
+ per.setBaoliu3(obj[9] == null ? null : obj[9].toString());
+ per.setBaoliu4(obj[10] == null ? null : obj[10].toString());
+ per.setBaoliu5(obj[11] == null ? null : obj[11].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
+
public int getmessageManagementCount() {
String sql = null;
Query query = null;
@@ -906,20 +1002,22 @@
query = this.em.createNativeQuery(sql);
return Integer.parseInt(query.getSingleResult().toString());
}
-
+
@Transactional
public void message_delete(String[] checkVal) {
String sql = null;
Query query = null;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_message_history WHERE id = :id";
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
}
-
+
@Transactional
public void message_deletea() {
String sql = null;
@@ -928,85 +1026,88 @@
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
-
- public List<tb_message_history> findmessage3(String input){
+
+ public List<tb_message_history> findmessage3(String input) {
String sql = null;
Query query = null;
sql = "select * from tb_message_history WHERE tagid = :input OR baoliu1 = :input ORDER BY sendtime DESC";
query = this.em.createNativeQuery(sql);
query.setParameter("input", input);
List resultlist = query.getResultList();
- List<tb_message_history> permissions = new ArrayList<>();
+ List<tb_message_history> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_message_history per = new tb_message_history();
- per.setId((int)obj[0]);
- per.setBianma(obj[1] == null?null:obj[1].toString());
- per.setTagid(obj[2] == null?null:obj[2].toString());
- per.setUsername(obj[3] == null?null:obj[3].toString());
- per.setInfo(obj[4] == null?null:obj[4].toString());
- per.setSendtime(obj[5] == null?null:obj[5].toString());
- per.setReplytime(obj[6] == null?null:obj[6].toString());
- per.setBaoliu1(obj[7] == null?null:obj[7].toString());
- per.setBaoliu2(obj[8] == null?null:obj[8].toString());
- per.setBaoliu3(obj[9] == null?null:obj[9].toString());
- per.setBaoliu4(obj[10] == null?null:obj[10].toString());
- per.setBaoliu5(obj[11] == null?null:obj[11].toString());
+ per.setId((Integer)obj[0]);
+ per.setBianma(obj[1] == null ? null : obj[1].toString());
+ per.setTagid(obj[2] == null ? null : obj[2].toString());
+ per.setUsername(obj[3] == null ? null : obj[3].toString());
+ per.setInfo(obj[4] == null ? null : obj[4].toString());
+ per.setSendtime(obj[5] == null ? null : obj[5].toString());
+ per.setReplytime(obj[6] == null ? null : obj[6].toString());
+ per.setBaoliu1(obj[7] == null ? null : obj[7].toString());
+ per.setBaoliu2(obj[8] == null ? null : obj[8].toString());
+ per.setBaoliu3(obj[9] == null ? null : obj[9].toString());
+ per.setBaoliu4(obj[10] == null ? null : obj[10].toString());
+ per.setBaoliu5(obj[11] == null ? null : obj[11].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
- public List<tb_lixianrecord> findlixian(int page){
+
+ public List<tb_lixianrecord> findlixian(int page) {
String sql = null;
Query query = null;
sql = "select * from tb_lixianrecord_0829 ORDER BY time DESC 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_lixianrecord> permissions = new ArrayList<>();
+ List<tb_lixianrecord> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_lixianrecord per = new tb_lixianrecord();
- per.setId((int)obj[0]);
- per.setTagid(obj[1] == null?null:obj[1].toString());
- per.setName(obj[2] == null?null:obj[2].toString());
- per.setBumen(obj[3] == null?null:obj[3].toString());
- per.setPhone(obj[4] == null?null:obj[4].toString());
- per.setTime(obj[5] == null?null:obj[5].toString());
+ per.setId((Integer)obj[0]);
+ per.setTagid(obj[1] == null ? null : obj[1].toString());
+ per.setName(obj[2] == null ? null : obj[2].toString());
+ per.setBumen(obj[3] == null ? null : obj[3].toString());
+ per.setPhone(obj[4] == null ? null : obj[4].toString());
+ per.setTime(obj[5] == null ? null : obj[5].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
- public List<tb_lixianrecord> findlixian2(){
+
+ public List<tb_lixianrecord> findlixian2() {
String sql = null;
Query query = null;
sql = "select * from tb_lixianrecord_0829 ORDER BY time DESC";
query = this.em.createNativeQuery(sql);
List resultlist = query.getResultList();
- List<tb_lixianrecord> permissions = new ArrayList<>();
+ List<tb_lixianrecord> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_lixianrecord per = new tb_lixianrecord();
- per.setId((int)obj[0]);
- per.setTagid(obj[1] == null?null:obj[1].toString());
- per.setName(obj[2] == null?null:obj[2].toString());
- per.setBumen(obj[3] == null?null:obj[3].toString());
- per.setPhone(obj[4] == null?null:obj[4].toString());
- per.setTime(obj[5] == null?null:obj[5].toString());
+ per.setId((Integer)obj[0]);
+ per.setTagid(obj[1] == null ? null : obj[1].toString());
+ per.setName(obj[2] == null ? null : obj[2].toString());
+ per.setBumen(obj[3] == null ? null : obj[3].toString());
+ per.setPhone(obj[4] == null ? null : obj[4].toString());
+ per.setTime(obj[5] == null ? null : obj[5].toString());
permissions.add(per);
}
}
+
return permissions;
}
-
+
public int getlixianManagementCount() {
String sql = null;
Query query = null;
@@ -1014,20 +1115,22 @@
query = this.em.createNativeQuery(sql);
return Integer.parseInt(query.getSingleResult().toString());
}
-
+
@Transactional
public void lixian_delete(String[] checkVal) {
String sql = null;
Query query = null;
- for (int i = 0; i < checkVal.length; i++) {
+
+ for(int i = 0; i < checkVal.length; ++i) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_lixianrecord_0829 WHERE id = :id";
query = this.em.createNativeQuery(sql);
query.setParameter("id", id);
query.executeUpdate();
}
+
}
-
+
@Transactional
public void lixian_deletea() {
String sql = null;
@@ -1036,28 +1139,29 @@
query = this.em.createNativeQuery(sql);
query.executeUpdate();
}
-
- public List<tb_lixianrecord> findlixian3(String input){
+
+ public List<tb_lixianrecord> findlixian3(String input) {
String sql = null;
Query query = null;
sql = "select * from tb_lixianrecord_0829 WHERE tagid = :input OR name = :input ORDER BY time DESC";
query = this.em.createNativeQuery(sql);
query.setParameter("input", input);
List resultlist = query.getResultList();
- List<tb_lixianrecord> permissions = new ArrayList<>();
+ List<tb_lixianrecord> permissions = new ArrayList();
if (resultlist.size() > 0) {
- for (int i=0; i<resultlist.size(); i++) {
- Object[] obj = (Object[])resultlist.get(i);
+ for(int i = 0; i < resultlist.size(); ++i) {
+ Object[] obj = (Object[])((Object[])resultlist.get(i));
tb_lixianrecord per = new tb_lixianrecord();
- per.setId((int)obj[0]);
- per.setTagid(obj[1] == null?null:obj[1].toString());
- per.setName(obj[2] == null?null:obj[2].toString());
- per.setBumen(obj[3] == null?null:obj[3].toString());
- per.setPhone(obj[4] == null?null:obj[4].toString());
- per.setTime(obj[5] == null?null:obj[5].toString());
+ per.setId((Integer)obj[0]);
+ per.setTagid(obj[1] == null ? null : obj[1].toString());
+ per.setName(obj[2] == null ? null : obj[2].toString());
+ per.setBumen(obj[3] == null ? null : obj[3].toString());
+ per.setPhone(obj[4] == null ? null : obj[4].toString());
+ per.setTime(obj[5] == null ? null : obj[5].toString());
permissions.add(per);
}
}
+
return permissions;
}
}
--
Gitblit v1.10.0