From 2080267e3245f0df9efc621c279922dc5ebb7c8e Mon Sep 17 00:00:00 2001
From: 15832144755 <67030627+15832144755@users.noreply.github.com>
Date: 星期四, 08 七月 2021 17:57:27 +0800
Subject: [PATCH] 7.8
---
src/main/java/com/hxzkoa/services/FenceService.java | 108 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 107 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/FenceService.java b/src/main/java/com/hxzkoa/services/FenceService.java
index 73fcd9a..78c2d30 100644
--- a/src/main/java/com/hxzkoa/services/FenceService.java
+++ b/src/main/java/com/hxzkoa/services/FenceService.java
@@ -12,7 +12,9 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import com.hxzkoa.json.tb_achor;
import com.hxzkoa.json.tb_fence;
+import com.hxzkoa.json.tb_shipin;
import com.hxzkoa.json.tb_xunjianbaobiao;
import com.hxzkoa.json.tb_xunjianset;
import com.hxzkoa.util.Config;
@@ -53,7 +55,111 @@
return tb_fenceList;
}
-
+ public List<tb_shipin> getShipinManagement(int page) {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT * FROM tb_shipin 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")));
+ List resultList = query.getResultList();
+ List<tb_shipin> tb_shipinList = new ArrayList<tb_shipin>();
+ if (resultList.size() > 0) {
+ for (int i = 0; i < resultList.size(); i++) {
+ tb_shipin shipin = new tb_shipin();
+ Object[] obj = (Object[]) resultList.get(i);
+ shipin.setId((int) obj[0]);
+ shipin.setFencename(obj[1] == null ? "" : obj[1].toString());
+ shipin.setShebeiid(obj[2] == null ? "" : obj[2].toString());
+ shipin.setTongdaoid(obj[3] == null ? "" : obj[3].toString());
+ shipin.setAddtime(obj[4] == null ? "" : obj[4].toString());
+ tb_shipinList.add(shipin);
+ }
+ }
+ return tb_shipinList;
+ }
+
+ public int getShipinManagementCount() {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT count(1) FROM tb_shipin";
+ query = this.em.createNativeQuery(sql);
+ return Integer.parseInt(query.getSingleResult().toString());
+ }
+
+ @Transactional
+ public int shipinManagement_add(tb_shipin shipin) {
+ String sql = null;
+ Query query = null;
+ sql = "INSERT INTO tb_shipin(fencename,shebeiid,tongdaoid,addtime) VALUES(:fencename,:shebeiid,:tongdaoid,now())";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("fencename", shipin.getFencename());
+ query.setParameter("shebeiid", shipin.getShebeiid());
+ query.setParameter("tongdaoid", shipin.getTongdaoid());
+ int executeUpdate = query.executeUpdate();
+ return executeUpdate;
+ }
+
+ @Transactional
+ public void shipinManagement_modify(tb_shipin shipin) {
+ String sql = null;
+ Query query = null;
+ sql = "UPDATE tb_shipin SET fencename=:fencename,shebeiid=:shebeiid,tongdaoid=:tongdaoid WHERE id=:id";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("id", shipin.getId());
+ query.setParameter("fencename", shipin.getFencename());
+ query.setParameter("shebeiid", shipin.getShebeiid());
+ query.setParameter("tongdaoid", shipin.getTongdaoid());
+ System.out.print(sql);
+ query.executeUpdate();
+ }
+
+ @Transactional
+ public void shipinManagement_delete(String[] checkVal) {
+ String sql = null;
+ Query query = null;
+ for (int i = 0; i < checkVal.length; i++) {
+ int id = Integer.parseInt(checkVal[i]);
+ sql = "DELETE FROM tb_shipin WHERE id = :id";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("id", id);
+ query.executeUpdate();
+ }
+ }
+
+ @Transactional
+ public void shipinManagement_deleteAll() {
+ String sql = null;
+ Query query = null;
+ sql = "DELETE FROM tb_shipin";
+ query = this.em.createNativeQuery(sql);
+ query.executeUpdate();
+ }
+
+ public List<tb_shipin> searchshipinManagement(String input) {
+ String sql = null;
+ Query query = null;
+ System.out.print(input);
+ sql = "SELECT * FROM tb_shipin WHERE fencename = :fencename";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("fencename", input);
+ List resultList = query.getResultList();
+ List<tb_shipin> tb_shipinList = new ArrayList<tb_shipin>();
+ if (resultList.size() > 0) {
+ for (int i = 0; i < resultList.size(); i++) {
+ tb_shipin shipin = new tb_shipin();
+ Object[] obj = (Object[]) resultList.get(i);
+ shipin.setId((int) obj[0]);
+ shipin.setFencename(obj[1] == null ? "" : obj[1].toString());
+ shipin.setShebeiid(obj[2] == null ? "" : obj[2].toString());
+ shipin.setTongdaoid(obj[3] == null ? "" : obj[3].toString());
+ shipin.setAddtime(obj[4] == null ? "" : obj[4].toString());
+ tb_shipinList.add(shipin);
+ }
+ }
+ return tb_shipinList;
+ }
+
public List<tb_fence> searchFenceList(String input) throws ParseException {
String sql = null;
--
Gitblit v1.10.0