From bc131131c5c96f8cb3bed679d4a359820c22e335 Mon Sep 17 00:00:00 2001
From: 15832144755 <67030627+15832144755@users.noreply.github.com>
Date: 星期四, 17 三月 2022 09:38:47 +0800
Subject: [PATCH] 3.17
---
src/main/java/com/hxzkoa/services/AnchorService.java | 87 +++++++++++++++++++++++++++++++++++++++++--
1 files changed, 82 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/AnchorService.java b/src/main/java/com/hxzkoa/services/AnchorService.java
index 8e3f066..7ca8f16 100644
--- a/src/main/java/com/hxzkoa/services/AnchorService.java
+++ b/src/main/java/com/hxzkoa/services/AnchorService.java
@@ -116,6 +116,35 @@
}
return tb_achorList;
}
+
+ public List<tb_achor> getAnchorManagementa() {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM (SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor ORDER BY id DESC) s";
+ query = this.em.createNativeQuery(sql);
+ List resultList = query.getResultList();
+ List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
+ if (resultList.size() > 0) {
+ for (int i = 0; i < resultList.size(); i++) {
+ tb_achor achor = new tb_achor();
+ Object[] obj = (Object[]) resultList.get(i);
+ achor.setId((int) obj[0]);
+ achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
+ achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
+ achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
+ achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
+ achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
+ achor.setLayer(obj[5] == null ? "" : obj[5].toString());
+ achor.setZu(obj[6] == null ? "" : obj[6].toString());
+ achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
+ achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
+ achor.setVersion(obj[10] == null ? "" : obj[10].toString());
+ achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
+ tb_achorList.add(achor);
+ }
+ }
+ return tb_achorList;
+ }
public List<tb_achor> searchAnchorManagement(String input) {
String sql = null;
@@ -196,7 +225,7 @@
}
@Transactional
- public void anchorManagement_modify(tb_achor achor) {
+ public int anchorManagement_modify(tb_achor achor) {
String sql = null;
Query query = null;
sql = "UPDATE tb_achor SET POSX=:POSX,POSY=:POSY,POSZ=:POSZ,layer=:layer,zu=:zu,liangcheng=:liangcheng,anchorip=:anchorip WHERE anchorid=:anchorid";
@@ -210,7 +239,8 @@
query.setParameter("zu", achor.getZu());
query.setParameter("liangcheng", achor.getLiangcheng());
query.setParameter("anchorip", achor.getAnchorip());
- query.executeUpdate();
+ int aaa = query.executeUpdate();
+ return aaa;
}
@Transactional
@@ -228,9 +258,10 @@
}
@Transactional
- public void anchorManagement_delete(String[] checkVal) {
+ public int anchorManagement_delete(String[] checkVal) {
String sql = null;
Query query = null;
+ int aaa = checkVal.length;
for (int i = 0; i < checkVal.length; i++) {
int id = Integer.parseInt(checkVal[i]);
sql = "DELETE FROM tb_achor WHERE id = :id";
@@ -239,6 +270,22 @@
query.setParameter("id", id);
query.executeUpdate();
}
+ return aaa;
+ }
+
+ @Transactional
+ public int anchorManagement_deletea(String[] checkVal) {
+ String sql = null;
+ Query query = null;
+ int aaa = checkVal.length;
+ for (int i = 0; i < checkVal.length; i++) {
+ sql = "DELETE FROM tb_achor WHERE anchorid = :anchorid";
+ cs.tb_caozuo("tb_achor", 2);
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("anchorid", checkVal[i]);
+ query.executeUpdate();
+ }
+ return aaa;
}
@Transactional
@@ -256,13 +303,14 @@
}
@Transactional
- public void anchorManagement_deleteAll() {
+ public int anchorManagement_deleteAll() {
String sql = null;
Query query = null;
sql = "DELETE FROM tb_achor";
cs.tb_caozuo("tb_achor", 2);
query = this.em.createNativeQuery(sql);
- query.executeUpdate();
+ int aaa = query.executeUpdate();
+ return aaa;
}
public List<tb_anchor_nearby> getProximityConfiguration() {
@@ -622,4 +670,33 @@
return list;
}
+ public List<tb_achor> searchidAnchorManagement(String id) {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor WHERE id = :id";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("id", id);
+ List resultList = query.getResultList();
+ List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
+ if (resultList.size() > 0) {
+ for (int i = 0; i < resultList.size(); i++) {
+ tb_achor achor = new tb_achor();
+ Object[] obj = (Object[]) resultList.get(i);
+ achor.setId((int) obj[0]);
+ achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
+ achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
+ achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
+ achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
+ achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
+ achor.setLayer(obj[5] == null ? "" : obj[5].toString());
+ achor.setZu(obj[6] == null ? "" : obj[6].toString());
+ achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
+ achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
+ achor.setVersion(obj[10] == null ? "" : obj[10].toString());
+ achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
+ tb_achorList.add(achor);
+ }
+ }
+ return tb_achorList;
+ }
}
--
Gitblit v1.10.0