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/controller/BasicInfoController.java | 1543 +++++++++++++++++++++++++++++++++-------------------------
1 files changed, 870 insertions(+), 673 deletions(-)
diff --git a/src/main/java/com/hxzkoa/controller/BasicInfoController.java b/src/main/java/com/hxzkoa/controller/BasicInfoController.java
index 519f07a..a299d90 100644
--- a/src/main/java/com/hxzkoa/controller/BasicInfoController.java
+++ b/src/main/java/com/hxzkoa/controller/BasicInfoController.java
@@ -1,15 +1,36 @@
+//
+// Source code recreated from a .class file by IntelliJ IDEA
+// (powered by FernFlower decompiler)
+//
+
package com.hxzkoa.controller;
+import com.hxzkoa.json.tb_department;
+import com.hxzkoa.json.tb_icon;
+import com.hxzkoa.json.tb_nav;
+import com.hxzkoa.json.tb_person;
+import com.hxzkoa.json.tb_tag;
+import com.hxzkoa.services.BasicInfoService;
+import com.hxzkoa.services.LabelService;
+import com.hxzkoa.services.ZhwService;
+import com.hxzkoa.udp.GetNowTime;
+import com.hxzkoa.udp.Udp_Out;
+import com.hxzkoa.util.Config;
+import com.hxzkoa.util.ExcelUtils;
+import com.hxzkoa.util.ModifyConfig;
+import com.hxzkoa.util.PageUtil;
+import com.hxzkoa.util.RequestUtils;
import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
-
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
-
-import org.hibernate.dialect.function.VarArgsSQLFunction;
+import jxl.Sheet;
+import jxl.Workbook;
+import jxl.read.biff.BiffException;
+import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
@@ -18,31 +39,6 @@
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
-import com.hxzkoa.json.tb_department;
-import com.hxzkoa.json.tb_icon;
-import com.hxzkoa.json.tb_led;
-import com.hxzkoa.json.tb_nav;
-import com.hxzkoa.json.tb_person;
-import com.hxzkoa.json.tb_realkaoqing;
-import com.hxzkoa.json.tb_tag;
-import com.hxzkoa.services.BasicInfoService;
-import com.hxzkoa.services.LabelService;
-import com.hxzkoa.services.ZhwService;
-import com.hxzkoa.udp.GetNowTime;
-import com.hxzkoa.udp.Udp_Out;
-/*import com.hxzkoa.udp.Udp_Receive;*/
-import com.hxzkoa.util.Config;
-import com.hxzkoa.util.ExcelUtils;
-import com.hxzkoa.util.HttpUtil;
-import com.hxzkoa.util.ModifyConfig;
-import com.hxzkoa.util.PageUtil;
-import com.hxzkoa.util.RequestUtils;
-
-import jxl.Sheet;
-import jxl.Workbook;
-import jxl.read.biff.BiffException;
-import net.sf.json.JSONObject;
-
@Controller
public class BasicInfoController {
@Autowired
@@ -52,25 +48,36 @@
@Autowired
private ZhwService zhwService;
- @RequestMapping(value = "/iconManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public BasicInfoController() {
+ }
+
+ @RequestMapping(value = {"/iconManagement.do"}, method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String iconManagement(HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/iconManagement.jsp";
- List<tb_icon> iconManagementList = basicInfoService.getIconManagement(1);
- int count = basicInfoService.getIconManagementCount();
+ List<tb_icon> iconManagementList = this.basicInfoService.getIconManagement(1);
+ for (int i=0;i<iconManagementList.size();i++){
+ if(iconManagementList.get(i).getIcon_name().contains(".")){
+ String[] name=iconManagementList.get(i).getIcon_name().split("\\.");
+ iconManagementList.get(i).setIcon_name(name[0]);
+ }
+ }
+ int count = this.basicInfoService.getIconManagementCount();
int curPage = 1;
request.setAttribute("iconManagementList", iconManagementList);
int minPage = PageUtil.getMinPage(count);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
return toPage;
}
@ResponseBody
- @RequestMapping(value = "/iconManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(value = {"/iconManagement_page.do"}, method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String iconManagement_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
String curPageStr = request.getParameter("curPage");
- int count = basicInfoService.getIconManagementCount();
+ int count = this.basicInfoService.getIconManagementCount();
int minPage = PageUtil.getMinPage(count);
int curPage = Integer.parseInt(curPageStr);
int page = 1;
@@ -85,7 +92,14 @@
} else {
page = Integer.parseInt(pageStr);
}
- List<tb_icon> iconManagementList = basicInfoService.getIconManagement(page);
+
+ List<tb_icon> iconManagementList = this.basicInfoService.getIconManagement(page);
+ for (int i=0;i<iconManagementList.size();i++){
+ if(iconManagementList.get(i).getIcon_name().contains(".")){
+ String[] name=iconManagementList.get(i).getIcon_name().split("\\.");
+ iconManagementList.get(i).setIcon_name(name[0]);
+ }
+ }
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
JSONObject json = new JSONObject();
json.put("dataList", iconManagementList);
@@ -94,94 +108,130 @@
return json.toString();
}
- @RequestMapping(value = "/uploadIcon.do")
+ @RequestMapping({"/uploadIcon.do"})
public String upload(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
String toPage = "redirect:/iconManagement.do";
String filePath1 = Config.getIconPath() + "/";
String filePath2 = request.getServletContext().getRealPath("/") + "hxzk/image/targeticon/";
+
+ File existFile2;
+ MultipartFile[] var7;
+ int var8;
+ int var9;
+ MultipartFile file;
try {
- File existFile1 = new File(filePath1);
- if (!existFile1.exists()) {
- existFile1.mkdir();
- }
- for (MultipartFile file : files) {
- file.transferTo(new File(filePath1 + file.getOriginalFilename()));
- }
- } catch (IOException e) {
- e.printStackTrace();
- }
- try {
- File existFile2 = new File(filePath2);
+ existFile2 = new File(filePath1);
if (!existFile2.exists()) {
existFile2.mkdir();
}
- for (MultipartFile file : files) {
+
+ var7 = files;
+ var8 = files.length;
+
+ for(var9 = 0; var9 < var8; ++var9) {
+ file = var7[var9];
+ file.transferTo(new File(filePath1 + file.getOriginalFilename()));
+ }
+ } catch (IOException var12) {
+ var12.printStackTrace();
+ }
+
+ try {
+ existFile2 = new File(filePath2);
+ if (!existFile2.exists()) {
+ existFile2.mkdir();
+ }
+
+ var7 = files;
+ var8 = files.length;
+
+ for(var9 = 0; var9 < var8; ++var9) {
+ file = var7[var9];
file.transferTo(new File(filePath2 + file.getOriginalFilename()));
}
- } catch (IOException e) {
- e.printStackTrace();
+ } catch (IOException var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
- @RequestMapping(value = "/iconManagement_add.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/iconManagement_add.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void iconManagement_add(HttpServletRequest request) {
tb_icon icon = new tb_icon();
icon.setIcon_name(request.getParameter("name"));
icon.setIcon_adress("image/targeticon/" + request.getParameter("filePath"));
icon.setBeizhu(request.getParameter("beizhu"));
- basicInfoService.iconManagement_add(icon);
+ this.basicInfoService.iconManagement_add(icon);
}
- @RequestMapping(value = "/iconManagement_check.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/iconManagement_check.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
@ResponseBody
public String iconManagement_check(HttpServletRequest request) {
- String iconName = (request.getParameter("name"));
- int exist = basicInfoService.iconManagement_check(iconName);
+ String iconName = request.getParameter("name");
+ int exist = this.basicInfoService.iconManagement_check(iconName);
return String.valueOf(exist);
}
@ResponseBody
- @RequestMapping(value = "/iconManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/iconManagement_delete.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void iconManagement_delete(HttpServletRequest request) {
String checkValStr = request.getParameter("checkVal");
checkValStr = checkValStr.replaceAll("\"", "");
String[] checkVal = checkValStr.split(",");
- basicInfoService.iconManagement_delete(checkVal);
+ this.basicInfoService.iconManagement_delete(checkVal);
}
- @RequestMapping(value = "/departmentManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String departmentManagement(HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/departmentManagement.jsp";
- List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement(1);
+ List<tb_department> departmentManagementList = this.basicInfoService.getDepartmentManagement(1);
request.setAttribute("departmentManagementList", departmentManagementList);
- List<tb_icon> iconList = basicInfoService.getIconList();
+ List<tb_icon> iconList = this.basicInfoService.getIconList();
request.setAttribute("iconList", iconList);
int curPage = 1;
- int count = basicInfoService.getDepartmentManagementCount();
+ int count = this.basicInfoService.getDepartmentManagementCount();
int minPage = PageUtil.getMinPage(count);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/jiedepartment.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/jiedepartment.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public JSONObject jiedepartment(HttpServletRequest request) {
JSONObject json = new JSONObject();
- List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement2();
- List<tb_nav> navList = zhwService.getnav();
+ List<tb_department> departmentManagementList = this.basicInfoService.getDepartmentManagement2();
+ List<tb_nav> navList = this.zhwService.getnav();
json.put("dataList", departmentManagementList);
json.put("dataList2", navList);
return json;
}
@ResponseBody
- @RequestMapping(value = "/departmentManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_page.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String departmentManagement_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
String curPageStr = request.getParameter("curPage");
- int count = basicInfoService.getDepartmentManagementCount();
+ int count = this.basicInfoService.getDepartmentManagementCount();
int minPage = PageUtil.getMinPage(count);
int curPage = Integer.parseInt(curPageStr);
int page = 1;
@@ -196,7 +246,8 @@
} else {
page = Integer.parseInt(pageStr);
}
- List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement(page);
+
+ List<tb_department> departmentManagementList = this.basicInfoService.getDepartmentManagement(page);
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
JSONObject json = new JSONObject();
json.put("dataList", departmentManagementList);
@@ -206,175 +257,215 @@
}
@ResponseBody
- @RequestMapping(value = "/departmentManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_search.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String departmentManagement_search(HttpServletRequest request) {
String input = request.getParameter("input");
int curPage = 1;
- List<Integer> pageList = new ArrayList<Integer>();
- List<tb_department> departmentManagementList = basicInfoService.searchDepartmentManagement(input);
+ List<Integer> pageList = new ArrayList();
+ List<tb_department> departmentManagementList = this.basicInfoService.searchDepartmentManagement(input);
pageList.add(1);
JSONObject json = new JSONObject();
json.put("dataList", departmentManagementList);
json.put("pageList", pageList);
- json.put("curPage", curPage);
+ json.put("curPage", Integer.valueOf(curPage));
return json.toString();
}
@ResponseBody
- @RequestMapping(value = "/departmentManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_delete.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void departmentManagement_delete(HttpServletRequest request) {
String checkValStr = request.getParameter("checkVal");
checkValStr = checkValStr.replaceAll("\"", "");
String[] checkVal = checkValStr.split(",");
- basicInfoService.departmentManagement_delete(checkVal);
- for(int i = 0;i < checkVal.length;i++) {
- String xieyi = "BSTOCS1,DELETEBUMEN,"+checkVal[i]+",END";
+ this.basicInfoService.departmentManagement_delete(checkVal);
+
+ for(int i = 0; i < checkVal.length; ++i) {
+ String xieyi = "BSTOCS1,DELETEBUMEN," + checkVal[i] + ",END";
Udp_Out.udp_to_cs(xieyi);
}
+
}
@ResponseBody
- @RequestMapping(value = "/departmentManagement_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_deleteAll.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void departmentManagement_deleteAll(HttpServletRequest request) {
- basicInfoService.departmentManagement_deleteAll();
+ this.basicInfoService.departmentManagement_deleteAll();
String xieyi = "BSTOCS1,DELETEALLBUMEN,END";
Udp_Out.udp_to_cs(xieyi);
}
- @RequestMapping(value = "/departmentManagement_add.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_add.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void departmentManagement_add(HttpServletRequest request) {
tb_department department = new tb_department();
department.setDepartmentName(request.getParameter("addName"));
department.setIconadress(request.getParameter("addIcon"));
- basicInfoService.departmentManagement_add(department);
- String xieyi = "BSTOCS1,ADDBUMEN,"+department.getDepartmentName()+","+department.getIconadress()+",END";
+ this.basicInfoService.departmentManagement_add(department);
+ String xieyi = "BSTOCS1,ADDBUMEN," + department.getDepartmentName() + "," + department.getIconadress() + ",END";
Udp_Out.udp_to_cs(xieyi);
}
- @RequestMapping(value = "/departmentManagement_check.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_check.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
@ResponseBody
public String departmentManagement_check(HttpServletRequest request) {
- String name = (request.getParameter("name"));
- int exist = basicInfoService.departmentManagement_check(name);
+ String name = request.getParameter("name");
+ int exist = this.basicInfoService.departmentManagement_check(name);
return String.valueOf(exist);
}
- @RequestMapping(value = "/departmentManagement_modify.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_modify.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void departmentManagement_modify(HttpServletRequest request) {
tb_department department = new tb_department();
department.setId(Integer.parseInt(request.getParameter("id")));
department.setDepartmentName(request.getParameter("addName"));
department.setIconadress(request.getParameter("addIcon"));
- basicInfoService.departmentManagement_modify(department);
- String xieyi = "BSTOCS1,ALTERBUMEN,"+department.getDepartmentName()+","+department.getIconadress()+",END";
+ this.basicInfoService.departmentManagement_modify(department);
+ String xieyi = "BSTOCS1,ALTERBUMEN," + department.getDepartmentName() + "," + department.getIconadress() + ",END";
Udp_Out.udp_to_cs(xieyi);
}
- // 瀵硅薄杞暟缁�
public static List<Object[]> objectToArray(List<tb_department> departmentManagementList) {
- List<Object[]> reList = new ArrayList<>();
- for (int i = 0; i < departmentManagementList.size(); i++) {
- List<String> words = new ArrayList<String>();
- tb_department department = (tb_department) departmentManagementList.get(i);
+ List<Object[]> reList = new ArrayList();
+
+ for(int i = 0; i < departmentManagementList.size(); ++i) {
+ List<String> words = new ArrayList();
+ tb_department department = (tb_department)departmentManagementList.get(i);
words.add(department.getDepartmentName());
words.add(department.getIconadress());
words.add(String.valueOf(department.getAddtime()));
- String[] array = words.toArray(new String[0]);
+ String[] array = (String[])words.toArray(new String[0]);
reList.add(array);
}
+
return reList;
}
@ResponseBody
- @RequestMapping(value = "/departmentManagement_export.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/departmentManagement_export.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String departmentManagement_export(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/departmentManagement.jsp";
- List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement();
- String[] rowName = { "閮ㄩ棬鍚嶇О", "鍥炬爣棰勮", "娣诲姞鏃堕棿" };
+ List<tb_department> departmentManagementList = this.basicInfoService.getDepartmentManagement();
+ String[] rowName = new String[]{"閮ㄩ棬鍚嶇О", "鍥炬爣棰勮", "娣诲姞鏃堕棿"};
List<Object[]> dataList = objectToArray(departmentManagementList);
ExcelUtils excel = new ExcelUtils("閮ㄩ棬绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
- @RequestMapping(value = "/personManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement(HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
- List<tb_person> personManagementList = basicInfoService.getPersonManagement(1);
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement(1);
request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
request.setAttribute("departmentList", departmentList);
int curPage = 1;
- int count = basicInfoService.getPersonManagementCount();
+ int count = this.basicInfoService.getPersonManagementCount();
int minPage = PageUtil.getMinPage(count);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
return toPage;
}
-
- @RequestMapping(value = "/cheliangManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
+
+ @RequestMapping(
+ value = {"/cheliangManagement.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String cheliangManagement(HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/cheliangManagement.jsp";
- List<tb_person> personManagementList = basicInfoService.getPersonManagement2(1);
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement2(1);
request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
request.setAttribute("departmentList", departmentList);
int curPage = 1;
- int count = basicInfoService.getPersonManagementCount2();
+ int count = this.basicInfoService.getPersonManagementCount2();
int minPage = PageUtil.getMinPage(count);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
return toPage;
}
-
- @RequestMapping(value = "/wuziManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
+
+ @RequestMapping(
+ value = {"/wuziManagement.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String wuziManagement(HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/wuziManagement.jsp";
- List<tb_person> personManagementList = basicInfoService.getPersonManagement3(1);
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement3(1);
request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
request.setAttribute("departmentList", departmentList);
int curPage = 1;
- int count = basicInfoService.getPersonManagementCount3();
+ int count = this.basicInfoService.getPersonManagementCount3();
int minPage = PageUtil.getMinPage(count);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
return toPage;
}
-
- @RequestMapping(value = "/personManagement2.do", method = { RequestMethod.POST, RequestMethod.GET })
+
+ @RequestMapping(
+ value = {"/personManagement2.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement2(HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
- List<tb_person> personManagementList = basicInfoService.getPersonManagement4(1);
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement4(1);
request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
request.setAttribute("departmentList", departmentList);
int curPage = 1;
- int count = basicInfoService.getPersonManagementCount4();
+ int count = this.basicInfoService.getPersonManagementCount4();
int minPage = PageUtil.getMinPage(count);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
return toPage;
}
@ResponseBody
- @RequestMapping(value = "/personManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_page.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
String curPageStr = request.getParameter("curPage");
- int count = basicInfoService.getPersonManagementCount();
+ int count = this.basicInfoService.getPersonManagementCount();
int minPage = PageUtil.getMinPage(count);
int curPage = Integer.parseInt(curPageStr);
int page = 1;
@@ -389,7 +480,8 @@
} else {
page = Integer.parseInt(pageStr);
}
- List<tb_person> personManagementList = basicInfoService.getPersonManagement(page);
+
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement(page);
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
JSONObject json = new JSONObject();
json.put("dataList", personManagementList);
@@ -397,13 +489,16 @@
json.put("curPage", page);
return json.toString();
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_page2.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_page2.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_page2(HttpServletRequest request) {
String pageStr = request.getParameter("page");
String curPageStr = request.getParameter("curPage");
- int count = basicInfoService.getPersonManagementCount2();
+ int count = this.basicInfoService.getPersonManagementCount2();
int minPage = PageUtil.getMinPage(count);
int curPage = Integer.parseInt(curPageStr);
int page = 1;
@@ -418,7 +513,8 @@
} else {
page = Integer.parseInt(pageStr);
}
- List<tb_person> personManagementList = basicInfoService.getPersonManagement2(page);
+
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement2(page);
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
JSONObject json = new JSONObject();
json.put("dataList", personManagementList);
@@ -426,13 +522,16 @@
json.put("curPage", page);
return json.toString();
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_page3.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_page3.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_page3(HttpServletRequest request) {
String pageStr = request.getParameter("page");
String curPageStr = request.getParameter("curPage");
- int count = basicInfoService.getPersonManagementCount3();
+ int count = this.basicInfoService.getPersonManagementCount3();
int minPage = PageUtil.getMinPage(count);
int curPage = Integer.parseInt(curPageStr);
int page = 1;
@@ -447,7 +546,8 @@
} else {
page = Integer.parseInt(pageStr);
}
- List<tb_person> personManagementList = basicInfoService.getPersonManagement3(page);
+
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement3(page);
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
JSONObject json = new JSONObject();
json.put("dataList", personManagementList);
@@ -455,13 +555,16 @@
json.put("curPage", page);
return json.toString();
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_page4.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_page4.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_page4(HttpServletRequest request) {
String pageStr = request.getParameter("page");
String curPageStr = request.getParameter("curPage");
- int count = basicInfoService.getPersonManagementCount4();
+ int count = this.basicInfoService.getPersonManagementCount4();
int minPage = PageUtil.getMinPage(count);
int curPage = Integer.parseInt(curPageStr);
int page = 1;
@@ -476,7 +579,8 @@
} else {
page = Integer.parseInt(pageStr);
}
- List<tb_person> personManagementList = basicInfoService.getPersonManagement4(page);
+
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement4(page);
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
JSONObject json = new JSONObject();
json.put("dataList", personManagementList);
@@ -486,139 +590,168 @@
}
@ResponseBody
- @RequestMapping(value = "/personManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_search.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_search(HttpServletRequest request) throws IOException {
JSONObject json = new JSONObject();
String input = request.getParameter("input");
- if (("").equals(input) || input == null) {
+ List personManagementList;
+ if (!"".equals(input) && input != null) {
+ int curPage = 1;
+ List<Integer> pageList = new ArrayList();
+ personManagementList = this.basicInfoService.searchPersonManagement(input);
+ pageList.add(1);
+ json.put("dataList", personManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", Integer.valueOf(curPage));
+ } else {
String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ tb_tag tag = (tb_tag)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
input = tag.getTag_id();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement(input);
- if (personManagementList.size()>0){
+ personManagementList = this.basicInfoService.searchPersonManagement(input);
+ if (personManagementList.size() > 0) {
json.put("result", personManagementList.get(0));
} else {
json.put("result", "null");
}
- } else {
- int curPage = 1;
- List<Integer> pageList = new ArrayList<Integer>();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement(input);
- pageList.add(1);
- json.put("dataList", personManagementList);
- json.put("pageList", pageList);
- json.put("curPage", curPage);
}
- return json.toString();
- }
-
- @ResponseBody
- @RequestMapping(value = "/personManagement_search2.do", method = { RequestMethod.POST, RequestMethod.GET })
- public String personManagement_search2(HttpServletRequest request) throws IOException {
- JSONObject json = new JSONObject();
- String input = request.getParameter("input");
- if (("").equals(input) || input == null) {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
- input = tag.getTag_id();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement2(input);
- if (personManagementList.size()>0){
- json.put("result", personManagementList.get(0));
- } else {
- json.put("result", "null");
- }
- } else {
- int curPage = 1;
- List<Integer> pageList = new ArrayList<Integer>();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement2(input);
- pageList.add(1);
- json.put("dataList", personManagementList);
- json.put("pageList", pageList);
- json.put("curPage", curPage);
- }
- return json.toString();
- }
-
- @ResponseBody
- @RequestMapping(value = "/personManagement_search3.do", method = { RequestMethod.POST, RequestMethod.GET })
- public String personManagement_search3(HttpServletRequest request) throws IOException {
- JSONObject json = new JSONObject();
- String input = request.getParameter("input");
- if (("").equals(input) || input == null) {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
- input = tag.getTag_id();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement3(input);
- if (personManagementList.size()>0){
- json.put("result", personManagementList.get(0));
- } else {
- json.put("result", "null");
- }
- } else {
- int curPage = 1;
- List<Integer> pageList = new ArrayList<Integer>();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement3(input);
- pageList.add(1);
- json.put("dataList", personManagementList);
- json.put("pageList", pageList);
- json.put("curPage", curPage);
- }
- return json.toString();
- }
-
- @ResponseBody
- @RequestMapping(value = "/personManagement_search4.do", method = { RequestMethod.POST, RequestMethod.GET })
- public String personManagement_search4(HttpServletRequest request) throws IOException {
- JSONObject json = new JSONObject();
- String input = request.getParameter("input");
- if (("").equals(input) || input == null) {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
- input = tag.getTag_id();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement4(input);
- if (personManagementList.size()>0){
- json.put("result", personManagementList.get(0));
- } else {
- json.put("result", "null");
- }
- } else {
- int curPage = 1;
- List<Integer> pageList = new ArrayList<Integer>();
- List<tb_person> personManagementList = basicInfoService.searchPersonManagement4(input);
- pageList.add(1);
- json.put("dataList", personManagementList);
- json.put("pageList", pageList);
- json.put("curPage", curPage);
- }
+
return json.toString();
}
@ResponseBody
- @RequestMapping(value = "/personManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_search2.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public String personManagement_search2(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("input");
+ List personManagementList;
+ if (!"".equals(input) && input != null) {
+ int curPage = 1;
+ List<Integer> pageList = new ArrayList();
+ personManagementList = this.basicInfoService.searchPersonManagement2(input);
+ pageList.add(1);
+ json.put("dataList", personManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", Integer.valueOf(curPage));
+ } else {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ personManagementList = this.basicInfoService.searchPersonManagement2(input);
+ if (personManagementList.size() > 0) {
+ json.put("result", personManagementList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ }
+
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(
+ value = {"/personManagement_search3.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public String personManagement_search3(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("input");
+ List personManagementList;
+ if (!"".equals(input) && input != null) {
+ int curPage = 1;
+ List<Integer> pageList = new ArrayList();
+ personManagementList = this.basicInfoService.searchPersonManagement3(input);
+ pageList.add(1);
+ json.put("dataList", personManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", Integer.valueOf(curPage));
+ } else {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ personManagementList = this.basicInfoService.searchPersonManagement3(input);
+ if (personManagementList.size() > 0) {
+ json.put("result", personManagementList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ }
+
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(
+ value = {"/personManagement_search4.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public String personManagement_search4(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("input");
+ List personManagementList;
+ if (!"".equals(input) && input != null) {
+ int curPage = 1;
+ List<Integer> pageList = new ArrayList();
+ personManagementList = this.basicInfoService.searchPersonManagement4(input);
+ pageList.add(1);
+ json.put("dataList", personManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", Integer.valueOf(curPage));
+ } else {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ personManagementList = this.basicInfoService.searchPersonManagement4(input);
+ if (personManagementList.size() > 0) {
+ json.put("result", personManagementList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ }
+
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(
+ value = {"/personManagement_delete.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void personManagement_delete(HttpServletRequest request) {
String checkValStr = request.getParameter("checkVal");
checkValStr = checkValStr.replaceAll("\"", "");
String[] checkVal = checkValStr.split(",");
- for (int i = 0; i < checkVal.length; i++) {
- basicInfoService.personManagement_delete(checkVal[i]);
- String xieyi = "BSTOCS1,DELETEFPERSON,"+checkVal[i]+",END";
+
+ for(int i = 0; i < checkVal.length; ++i) {
+ this.basicInfoService.personManagement_delete(checkVal[i]);
+ String xieyi = "BSTOCS1,DELETEFPERSON," + checkVal[i] + ",END";
Udp_Out.udp_to_cs(xieyi);
}
- // 鍒犻櫎tb_person鍚屾椂闇�瑕佸垹闄ゆ爣绛�
- labelService.labelManagement_delete(checkVal);
+
+ this.labelService.labelManagement_delete(checkVal);
}
@ResponseBody
- @RequestMapping(value = "/personManagement_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_deleteAll.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void personManagement_deleteAll(HttpServletRequest request) {
- basicInfoService.personManagement_deleteAll();
+ this.basicInfoService.personManagement_deleteAll();
String xieyi = "BSTOCS1,DELETEALLPERSON,END";
Udp_Out.udp_to_cs(xieyi);
- // 鍒犻櫎tb_person鍚屾椂闇�瑕佸垹闄ゆ爣绛�
- labelService.labelManagement_deleteAll();
+ this.labelService.labelManagement_deleteAll();
}
- @RequestMapping(value = "/personManagement_modify.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_modify.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void personManagement_modify(HttpServletRequest request) {
tb_person person = new tb_person();
person.setP_tagid(request.getParameter("p_tagid"));
@@ -626,320 +759,341 @@
person.setP_name(request.getParameter("p_name"));
person.setP_sex(request.getParameter("p_sex"));
person.setP_phone(request.getParameter("p_phone"));
-// List<tb_department> departments = basicInfoService.searchDepartmentManagement(request.getParameter("p_department"));
-// person.setP_image(departments.get(0).getIconadress());
- basicInfoService.personManagement_modify(person);
- String xieyi = "BSTOCS1,ALTERPERSON,"+person.getP_name()+","+person.getP_tagid()+","+person.getP_sex()+","+person.getP_department()+","+person.getP_phone()+",END";
+ this.basicInfoService.personManagement_modify(person);
+ String xieyi = "BSTOCS1,ALTERPERSON," + person.getP_name() + "," + person.getP_tagid() + "," + person.getP_sex() + "," + person.getP_department() + "," + person.getP_phone() + ",END";
Udp_Out.udp_to_cs(xieyi);
- // 淇敼tb_person鍚屾椂闇�瑕佷慨鏀规爣绛� 闇�瑕佸厛鏌ュ啀鏀瑰惁鍒欒鐩栫┖
- List<tb_tag> searchLabelManagement = labelService.searchLabelManagement(person.getP_tagid());
- if(searchLabelManagement!=null){
- tb_tag tag = searchLabelManagement.get(0);
+ List<tb_tag> searchLabelManagement = this.labelService.searchLabelManagement(person.getP_tagid());
+ if (searchLabelManagement != null) {
+ tb_tag tag = (tb_tag)searchLabelManagement.get(0);
tag.setState(person.getP_name());
- labelService.labelManagement_modify(tag);
+ this.labelService.labelManagement_modify(tag);
}
+
}
-
- @RequestMapping(value = "/personManagement_modify2.do", method = { RequestMethod.POST, RequestMethod.GET })
+
+ @RequestMapping(
+ value = {"/personManagement_modify2.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void personManagement_modify2(HttpServletRequest request) {
tb_person person = new tb_person();
person.setP_tagid(request.getParameter("p_tagid"));
person.setP_department(request.getParameter("p_department"));
person.setP_name(request.getParameter("p_name"));
- basicInfoService.personManagement_modify2(person);
- String xieyi = "BSTOCS1,ALTERCAR,"+person.getP_name()+","+person.getP_tagid()+","+person.getP_department()+",END";
+ this.basicInfoService.personManagement_modify2(person);
+ String xieyi = "BSTOCS1,ALTERCAR," + person.getP_name() + "," + person.getP_tagid() + "," + person.getP_department() + ",END";
Udp_Out.udp_to_cs(xieyi);
- // 淇敼tb_person鍚屾椂闇�瑕佷慨鏀规爣绛� 闇�瑕佸厛鏌ュ啀鏀瑰惁鍒欒鐩栫┖
- List<tb_tag> searchLabelManagement = labelService.searchLabelManagement(person.getP_tagid());
- if(searchLabelManagement!=null){
- tb_tag tag = searchLabelManagement.get(0);
+ List<tb_tag> searchLabelManagement = this.labelService.searchLabelManagement(person.getP_tagid());
+ if (searchLabelManagement != null) {
+ tb_tag tag = (tb_tag)searchLabelManagement.get(0);
tag.setState(person.getP_name());
- labelService.labelManagement_modify(tag);
+ this.labelService.labelManagement_modify(tag);
}
+
}
- @RequestMapping(value = "/uploadPerson.do")
+ @RequestMapping({"/uploadPerson.do"})
public String uploadPerson(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
String filename = files[0].getOriginalFilename();
+
try {
File existFile = new File(filePath);
if (!existFile.exists()) {
existFile.mkdir();
}
- for (MultipartFile file : files) {
+
+ MultipartFile[] var7 = files;
+ int var8 = files.length;
+
+ for(int var9 = 0; var9 < var8; ++var9) {
+ MultipartFile file = var7[var9];
file.transferTo(new File(filePath + file.getOriginalFilename()));
- ////System.out.print(file.getOriginalFilename());
}
- } catch (IOException e) {
- e.printStackTrace();
+ } catch (IOException var21) {
+ var21.printStackTrace();
}
+
int result = 0;
String path = filePath + filename;
- // 閫夊彇Excel鏂囦欢寰楀埌宸ヤ綔钖�
- Workbook workbook;
+
+ int i;
try {
File file = new File(path);
- workbook = Workbook.getWorkbook(file);
- // 閫夋嫨宸ヤ綔琛紝閫氳繃Workbook鐨刧etSheet鏂规硶閫夋嫨绗竴涓伐浣滆〃锛堜粠0寮�濮嬶級
+ Workbook workbook = Workbook.getWorkbook(file);
Sheet sheet = workbook.getSheet(0);
int rows = sheet.getRows();
- // 閫夋嫨Cell锛岃鍙栧崟鍏冩牸 閫氳繃Sheet鐨刧etCell鏂规硶閫夋嫨浣嶇疆涓篊2鐨勫崟鍏冩牸锛堜袱涓弬鏁伴兘浠�0寮�濮嬶級
- for (int i = 3; i < rows; i++) {
- // 璇诲彇淇℃伅锛岄�氳繃Cell鐨刧etContents鏂规硶璇诲彇鍗曞厓鏍肩殑鍊兼妸鍗曞厓鏍间腑鐨勪俊鎭互瀛楃鐨勫舰寮忚鍙栧嚭鏉�
+
+ for(i = 3; i < rows; ++i) {
String p_name = sheet.getCell(0, i).getContents();
String p_tagid = sheet.getCell(1, i).getContents();
String p_sex = sheet.getCell(2, i).getContents();
String p_department = sheet.getCell(3, i).getContents();
String p_phone = sheet.getCell(4, i).getContents();
- if (!("").equals(p_tagid)) {
+ if (!"".equals(p_tagid)) {
tb_person person = new tb_person();
person.setP_name(p_name);
person.setP_tagid(p_tagid);
person.setP_sex(p_sex);
person.setP_department(p_department);
person.setP_phone(p_phone);
- basicInfoService.personManagement_add(person);
+ this.basicInfoService.personManagement_add(person);
result = 1;
}
}
- // 閲婃斁璧勬簮
+
workbook.close();
- } catch (BiffException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
+ } catch (BiffException var19) {
+ var19.printStackTrace();
+ } catch (IOException var20) {
+ var20.printStackTrace();
}
- request.setAttribute("resultList", result);
- List<tb_person> personManagementList = basicInfoService.getPersonManagement(1);
+
+ request.setAttribute("resultList", Integer.valueOf(result));
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement(1);
request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
request.setAttribute("departmentList", departmentList);
int curPage = 1;
- int count = basicInfoService.getPersonManagementCount();
- int minPage = PageUtil.getMinPage(count);
+ i = this.basicInfoService.getPersonManagementCount();
+ int minPage = PageUtil.getMinPage(i);
request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
- File file = new File(path);
- file.delete();
- return toPage;
- }
-
- @RequestMapping(value = "/uploadPerson2.do")
- public String uploadPerson2(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
- String toPage = "forward:/hxzk/basicInfo/cheliangManagement.jsp";
- String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
- String filename = files[0].getOriginalFilename();
- try {
- File existFile = new File(filePath);
- if (!existFile.exists()) {
- existFile.mkdir();
- }
- for (MultipartFile file : files) {
- file.transferTo(new File(filePath + file.getOriginalFilename()));
- ////System.out.print(file.getOriginalFilename());
- }
- } catch (IOException e) {
- e.printStackTrace();
- }
- int result = 0;
- String path = filePath + filename;
- // 閫夊彇Excel鏂囦欢寰楀埌宸ヤ綔钖�
- Workbook workbook;
- try {
- File file = new File(path);
- workbook = Workbook.getWorkbook(file);
- // 閫夋嫨宸ヤ綔琛紝閫氳繃Workbook鐨刧etSheet鏂规硶閫夋嫨绗竴涓伐浣滆〃锛堜粠0寮�濮嬶級
- Sheet sheet = workbook.getSheet(0);
- int rows = sheet.getRows();
- // 閫夋嫨Cell锛岃鍙栧崟鍏冩牸 閫氳繃Sheet鐨刧etCell鏂规硶閫夋嫨浣嶇疆涓篊2鐨勫崟鍏冩牸锛堜袱涓弬鏁伴兘浠�0寮�濮嬶級
- for (int i = 3; i < rows; i++) {
- // 璇诲彇淇℃伅锛岄�氳繃Cell鐨刧etContents鏂规硶璇诲彇鍗曞厓鏍肩殑鍊兼妸鍗曞厓鏍间腑鐨勪俊鎭互瀛楃鐨勫舰寮忚鍙栧嚭鏉�
- String p_name = sheet.getCell(0, i).getContents();
- String p_tagid = sheet.getCell(1, i).getContents();
- String p_sex = "";
- String p_department = sheet.getCell(2, i).getContents();
- String p_phone = "";
- if (!("").equals(p_tagid)) {
- tb_person person = new tb_person();
- person.setP_name(p_name);
- person.setP_tagid(p_tagid);
- person.setP_sex(p_sex);
- person.setP_department(p_department);
- person.setP_phone(p_phone);
- basicInfoService.personManagement_add(person);
- result = 1;
- }
- }
- // 閲婃斁璧勬簮
- workbook.close();
- } catch (BiffException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- request.setAttribute("resultList", result);
- List<tb_person> personManagementList = basicInfoService.getPersonManagement2(1);
- request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
- request.setAttribute("departmentList", departmentList);
- int curPage = 1;
- int count = basicInfoService.getPersonManagementCount2();
- int minPage = PageUtil.getMinPage(count);
- request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
- File file = new File(path);
- file.delete();
- return toPage;
- }
-
- @RequestMapping(value = "/uploadPerson3.do")
- public String uploadPerson3(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
- String toPage = "forward:/hxzk/basicInfo/wuziManagement.jsp";
- String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
- String filename = files[0].getOriginalFilename();
- try {
- File existFile = new File(filePath);
- if (!existFile.exists()) {
- existFile.mkdir();
- }
- for (MultipartFile file : files) {
- file.transferTo(new File(filePath + file.getOriginalFilename()));
- ////System.out.print(file.getOriginalFilename());
- }
- } catch (IOException e) {
- e.printStackTrace();
- }
- int result = 0;
- String path = filePath + filename;
- // 閫夊彇Excel鏂囦欢寰楀埌宸ヤ綔钖�
- Workbook workbook;
- try {
- File file = new File(path);
- workbook = Workbook.getWorkbook(file);
- // 閫夋嫨宸ヤ綔琛紝閫氳繃Workbook鐨刧etSheet鏂规硶閫夋嫨绗竴涓伐浣滆〃锛堜粠0寮�濮嬶級
- Sheet sheet = workbook.getSheet(0);
- int rows = sheet.getRows();
- // 閫夋嫨Cell锛岃鍙栧崟鍏冩牸 閫氳繃Sheet鐨刧etCell鏂规硶閫夋嫨浣嶇疆涓篊2鐨勫崟鍏冩牸锛堜袱涓弬鏁伴兘浠�0寮�濮嬶級
- for (int i = 3; i < rows; i++) {
- // 璇诲彇淇℃伅锛岄�氳繃Cell鐨刧etContents鏂规硶璇诲彇鍗曞厓鏍肩殑鍊兼妸鍗曞厓鏍间腑鐨勪俊鎭互瀛楃鐨勫舰寮忚鍙栧嚭鏉�
- String p_name = sheet.getCell(0, i).getContents();
- String p_tagid = sheet.getCell(1, i).getContents();
- String p_sex = "";
- String p_department = sheet.getCell(2, i).getContents();
- String p_phone = "";
- if (!("").equals(p_tagid)) {
- tb_person person = new tb_person();
- person.setP_name(p_name);
- person.setP_tagid(p_tagid);
- person.setP_sex(p_sex);
- person.setP_department(p_department);
- person.setP_phone(p_phone);
- basicInfoService.personManagement_add(person);
- result = 1;
- }
- }
- // 閲婃斁璧勬簮
- workbook.close();
- } catch (BiffException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- request.setAttribute("resultList", result);
- List<tb_person> personManagementList = basicInfoService.getPersonManagement3(1);
- request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
- request.setAttribute("departmentList", departmentList);
- int curPage = 1;
- int count = basicInfoService.getPersonManagementCount3();
- int minPage = PageUtil.getMinPage(count);
- request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
- File file = new File(path);
- file.delete();
- return toPage;
- }
-
- @RequestMapping(value = "/uploadPerson4.do")
- public String uploadPerson4(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
- String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
- String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
- String filename = files[0].getOriginalFilename();
- try {
- File existFile = new File(filePath);
- if (!existFile.exists()) {
- existFile.mkdir();
- }
- for (MultipartFile file : files) {
- file.transferTo(new File(filePath + file.getOriginalFilename()));
- ////System.out.print(file.getOriginalFilename());
- }
- } catch (IOException e) {
- e.printStackTrace();
- }
- int result = 0;
- String path = filePath + filename;
- // 閫夊彇Excel鏂囦欢寰楀埌宸ヤ綔钖�
- Workbook workbook;
- try {
- File file = new File(path);
- workbook = Workbook.getWorkbook(file);
- // 閫夋嫨宸ヤ綔琛紝閫氳繃Workbook鐨刧etSheet鏂规硶閫夋嫨绗竴涓伐浣滆〃锛堜粠0寮�濮嬶級
- Sheet sheet = workbook.getSheet(0);
- int rows = sheet.getRows();
- // 閫夋嫨Cell锛岃鍙栧崟鍏冩牸 閫氳繃Sheet鐨刧etCell鏂规硶閫夋嫨浣嶇疆涓篊2鐨勫崟鍏冩牸锛堜袱涓弬鏁伴兘浠�0寮�濮嬶級
- for (int i = 3; i < rows; i++) {
- // 璇诲彇淇℃伅锛岄�氳繃Cell鐨刧etContents鏂规硶璇诲彇鍗曞厓鏍肩殑鍊兼妸鍗曞厓鏍间腑鐨勪俊鎭互瀛楃鐨勫舰寮忚鍙栧嚭鏉�
- String p_name = sheet.getCell(0, i).getContents();
- String p_tagid = sheet.getCell(1, i).getContents();
- String p_sex = sheet.getCell(2, i).getContents();
- String p_department = sheet.getCell(3, i).getContents();
- String p_phone = sheet.getCell(4, i).getContents();
- if (!("").equals(p_tagid)) {
- tb_person person = new tb_person();
- person.setP_name(p_name);
- person.setP_tagid(p_tagid);
- person.setP_sex(p_sex);
- person.setP_department(p_department);
- person.setP_phone(p_phone);
- basicInfoService.renyuandaoru(person);
- tb_tag tag = new tb_tag();
- tag.setState(p_name);
- tag.setTag_id(p_tagid);
- labelService.updatetagname(tag);
- result = 1;
- }
- }
- // 閲婃斁璧勬簮
- workbook.close();
- } catch (BiffException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- request.setAttribute("resultList", result);
- List<tb_person> personManagementList = basicInfoService.getPersonManagement4(1);
- request.setAttribute("personManagementList", personManagementList);
- List<tb_department> departmentList = basicInfoService.getDepartmentList();
- request.setAttribute("departmentList", departmentList);
- int curPage = 1;
- int count = basicInfoService.getPersonManagementCount4();
- int minPage = PageUtil.getMinPage(count);
- request.setAttribute("pageList", PageUtil.getPage(minPage));
- request.setAttribute("curPage", curPage);
+ request.setAttribute("curPage", Integer.valueOf(curPage));
File file = new File(path);
file.delete();
return toPage;
}
- // 瀵硅薄杞暟缁�
+ @RequestMapping({"/uploadPerson2.do"})
+ public String uploadPerson2(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
+ String toPage = "forward:/hxzk/basicInfo/cheliangManagement.jsp";
+ String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
+ String filename = files[0].getOriginalFilename();
+
+ try {
+ File existFile = new File(filePath);
+ if (!existFile.exists()) {
+ existFile.mkdir();
+ }
+
+ MultipartFile[] var7 = files;
+ int var8 = files.length;
+
+ for(int var9 = 0; var9 < var8; ++var9) {
+ MultipartFile file = var7[var9];
+ file.transferTo(new File(filePath + file.getOriginalFilename()));
+ }
+ } catch (IOException var21) {
+ var21.printStackTrace();
+ }
+
+ int result = 0;
+ String path = filePath + filename;
+
+ int i;
+ try {
+ File file = new File(path);
+ Workbook workbook = Workbook.getWorkbook(file);
+ Sheet sheet = workbook.getSheet(0);
+ int rows = sheet.getRows();
+
+ for(i = 3; i < rows; ++i) {
+ String p_name = sheet.getCell(0, i).getContents();
+ String p_tagid = sheet.getCell(1, i).getContents();
+ String p_sex = "";
+ String p_department = sheet.getCell(2, i).getContents();
+ String p_phone = "";
+ if (!"".equals(p_tagid)) {
+ tb_person person = new tb_person();
+ person.setP_name(p_name);
+ person.setP_tagid(p_tagid);
+ person.setP_sex(p_sex);
+ person.setP_department(p_department);
+ person.setP_phone(p_phone);
+ this.basicInfoService.personManagement_add(person);
+ result = 1;
+ }
+ }
+
+ workbook.close();
+ } catch (BiffException var19) {
+ var19.printStackTrace();
+ } catch (IOException var20) {
+ var20.printStackTrace();
+ }
+
+ request.setAttribute("resultList", Integer.valueOf(result));
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement2(1);
+ request.setAttribute("personManagementList", personManagementList);
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
+ request.setAttribute("departmentList", departmentList);
+ int curPage = 1;
+ i = this.basicInfoService.getPersonManagementCount2();
+ int minPage = PageUtil.getMinPage(i);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", Integer.valueOf(curPage));
+ File file = new File(path);
+ file.delete();
+ return toPage;
+ }
+
+ @RequestMapping({"/uploadPerson3.do"})
+ public String uploadPerson3(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
+ String toPage = "forward:/hxzk/basicInfo/wuziManagement.jsp";
+ String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
+ String filename = files[0].getOriginalFilename();
+
+ try {
+ File existFile = new File(filePath);
+ if (!existFile.exists()) {
+ existFile.mkdir();
+ }
+
+ MultipartFile[] var7 = files;
+ int var8 = files.length;
+
+ for(int var9 = 0; var9 < var8; ++var9) {
+ MultipartFile file = var7[var9];
+ file.transferTo(new File(filePath + file.getOriginalFilename()));
+ }
+ } catch (IOException var21) {
+ var21.printStackTrace();
+ }
+
+ int result = 0;
+ String path = filePath + filename;
+
+ int i;
+ try {
+ File file = new File(path);
+ Workbook workbook = Workbook.getWorkbook(file);
+ Sheet sheet = workbook.getSheet(0);
+ int rows = sheet.getRows();
+
+ for(i = 3; i < rows; ++i) {
+ String p_name = sheet.getCell(0, i).getContents();
+ String p_tagid = sheet.getCell(1, i).getContents();
+ String p_sex = "";
+ String p_department = sheet.getCell(2, i).getContents();
+ String p_phone = "";
+ if (!"".equals(p_tagid)) {
+ tb_person person = new tb_person();
+ person.setP_name(p_name);
+ person.setP_tagid(p_tagid);
+ person.setP_sex(p_sex);
+ person.setP_department(p_department);
+ person.setP_phone(p_phone);
+ this.basicInfoService.personManagement_add(person);
+ result = 1;
+ }
+ }
+
+ workbook.close();
+ } catch (BiffException var19) {
+ var19.printStackTrace();
+ } catch (IOException var20) {
+ var20.printStackTrace();
+ }
+
+ request.setAttribute("resultList", Integer.valueOf(result));
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement3(1);
+ request.setAttribute("personManagementList", personManagementList);
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
+ request.setAttribute("departmentList", departmentList);
+ int curPage = 1;
+ i = this.basicInfoService.getPersonManagementCount3();
+ int minPage = PageUtil.getMinPage(i);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", Integer.valueOf(curPage));
+ File file = new File(path);
+ file.delete();
+ return toPage;
+ }
+
+ @RequestMapping({"/uploadPerson4.do"})
+ public String uploadPerson4(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
+ String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
+ String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
+ String filename = files[0].getOriginalFilename();
+
+ try {
+ File existFile = new File(filePath);
+ if (!existFile.exists()) {
+ existFile.mkdir();
+ }
+
+ MultipartFile[] var7 = files;
+ int var8 = files.length;
+
+ for(int var9 = 0; var9 < var8; ++var9) {
+ MultipartFile file = var7[var9];
+ file.transferTo(new File(filePath + file.getOriginalFilename()));
+ }
+ } catch (IOException var22) {
+ var22.printStackTrace();
+ }
+
+ int result = 0;
+ String path = filePath + filename;
+
+ int i;
+ try {
+ File file = new File(path);
+ Workbook workbook = Workbook.getWorkbook(file);
+ Sheet sheet = workbook.getSheet(0);
+ int rows = sheet.getRows();
+
+ for(i = 3; i < rows; ++i) {
+ String p_name = sheet.getCell(0, i).getContents();
+ String p_tagid = sheet.getCell(1, i).getContents();
+ String p_sex = sheet.getCell(2, i).getContents();
+ String p_department = sheet.getCell(3, i).getContents();
+ String p_phone = sheet.getCell(4, i).getContents();
+ if (!"".equals(p_tagid)) {
+ tb_person person = new tb_person();
+ person.setP_name(p_name);
+ person.setP_tagid(p_tagid);
+ person.setP_sex(p_sex);
+ person.setP_department(p_department);
+ person.setP_phone(p_phone);
+ this.basicInfoService.renyuandaoru(person);
+ tb_tag tag = new tb_tag();
+ tag.setState(p_name);
+ tag.setTag_id(p_tagid);
+ this.labelService.updatetagname(tag);
+ result = 1;
+ }
+ }
+
+ workbook.close();
+ } catch (BiffException var20) {
+ var20.printStackTrace();
+ } catch (IOException var21) {
+ var21.printStackTrace();
+ }
+
+ request.setAttribute("resultList", Integer.valueOf(result));
+ List<tb_person> personManagementList = this.basicInfoService.getPersonManagement4(1);
+ request.setAttribute("personManagementList", personManagementList);
+ List<tb_department> departmentList = this.basicInfoService.getDepartmentList();
+ request.setAttribute("departmentList", departmentList);
+ int curPage = 1;
+ i = this.basicInfoService.getPersonManagementCount4();
+ int minPage = PageUtil.getMinPage(i);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", Integer.valueOf(curPage));
+ File file = new File(path);
+ file.delete();
+ return toPage;
+ }
+
public static List<Object[]> personobjectToArray(List<tb_person> personList) {
- List<Object[]> reList = new ArrayList<>();
- for (int i = 0; i < personList.size(); i++) {
- List<String> words = new ArrayList<String>();
- tb_person person = (tb_person) personList.get(i);
+ List<Object[]> reList = new ArrayList();
+
+ for(int i = 0; i < personList.size(); ++i) {
+ List<String> words = new ArrayList();
+ tb_person person = (tb_person)personList.get(i);
words.add(String.valueOf(person.getId()));
words.add(person.getP_name());
words.add(person.getP_tagid());
@@ -949,17 +1103,19 @@
words.add(person.getP_power());
words.add(person.getP_image());
words.add(person.getP_addtiem());
- String[] array = words.toArray(new String[0]);
+ String[] array = (String[])words.toArray(new String[0]);
reList.add(array);
}
+
return reList;
}
-
+
public static List<Object[]> personobjectToArray2(List<tb_person> personList) {
- List<Object[]> reList = new ArrayList<>();
- for (int i = 0; i < personList.size(); i++) {
- List<String> words = new ArrayList<String>();
- tb_person person = (tb_person) personList.get(i);
+ List<Object[]> reList = new ArrayList();
+
+ for(int i = 0; i < personList.size(); ++i) {
+ List<String> words = new ArrayList();
+ tb_person person = (tb_person)personList.get(i);
words.add(String.valueOf(person.getId()));
words.add(person.getP_name());
words.add(person.getP_tagid());
@@ -967,312 +1123,353 @@
words.add(person.getP_power());
words.add(person.getP_image());
words.add(person.getP_addtiem());
- String[] array = words.toArray(new String[0]);
+ String[] array = (String[])words.toArray(new String[0]);
reList.add(array);
}
+
return reList;
}
-
- // 瀵硅薄杞暟缁�
- public static List<Object[]> personTemplateobjectToArray(List<tb_person> personList) {
- List<Object[]> reList = new ArrayList<>();
- for (int i = 0; i < personList.size(); i++) {
- List<String> words = new ArrayList<String>();
- tb_person person = (tb_person) personList.get(i);
- words.add(person.getP_name());
- words.add(person.getP_tagid());
- words.add(person.getP_sex());
- words.add(person.getP_department());
- words.add(person.getP_phone());
- String[] array = words.toArray(new String[0]);
- reList.add(array);
- }
- return reList;
- }
-
- public static List<Object[]> personTemplateobjectToArray2(List<tb_person> personList) {
- List<Object[]> reList = new ArrayList<>();
- for (int i = 0; i < personList.size(); i++) {
- List<String> words = new ArrayList<String>();
- tb_person person = (tb_person) personList.get(i);
- words.add(person.getP_name());
- words.add(person.getP_tagid());
- words.add(person.getP_department());
- String[] array = words.toArray(new String[0]);
- reList.add(array);
- }
- return reList;
+
+ public static List<Object[]> personTemplateobjectToArray(List<tb_person> personList) {
+ List<Object[]> reList = new ArrayList();
+
+ for(int i = 0; i < personList.size(); ++i) {
+ List<String> words = new ArrayList();
+ tb_person person = (tb_person)personList.get(i);
+ words.add(person.getP_name());
+ words.add(person.getP_tagid());
+ words.add(person.getP_sex());
+ words.add(person.getP_department());
+ words.add(person.getP_phone());
+ String[] array = (String[])words.toArray(new String[0]);
+ reList.add(array);
}
+ return reList;
+ }
+
+ public static List<Object[]> personTemplateobjectToArray2(List<tb_person> personList) {
+ List<Object[]> reList = new ArrayList();
+
+ for(int i = 0; i < personList.size(); ++i) {
+ List<String> words = new ArrayList();
+ tb_person person = (tb_person)personList.get(i);
+ words.add(person.getP_name());
+ words.add(person.getP_tagid());
+ words.add(person.getP_department());
+ String[] array = (String[])words.toArray(new String[0]);
+ reList.add(array);
+ }
+
+ return reList;
+ }
+
@ResponseBody
- @RequestMapping(value = "/personManagement_export.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_export.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_export(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
- List<tb_person> personList = basicInfoService.getPersonManagement();
- String[] rowName = { "搴忓彿", "濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿" };
+ List<tb_person> personList = this.basicInfoService.getPersonManagement();
+ String[] rowName = new String[]{"搴忓彿", "濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿"};
List<Object[]> dataList = personobjectToArray(personList);
ExcelUtils excel = new ExcelUtils("浜哄憳绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_export2.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_export2.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_export2(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/cheliangmentManagement.jsp";
- List<tb_person> personList = basicInfoService.getPersonManagement2();
- String[] rowName = { "搴忓彿", "杞﹁締鍚嶇О", "鏍囩ID", "閮ㄩ棬", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿" };
+ List<tb_person> personList = this.basicInfoService.getPersonManagement2();
+ String[] rowName = new String[]{"搴忓彿", "杞﹁締鍚嶇О", "鏍囩ID", "閮ㄩ棬", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿"};
List<Object[]> dataList = personobjectToArray2(personList);
ExcelUtils excel = new ExcelUtils("杞﹁締绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_export3.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_export3.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_export3(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/wuzimentManagement.jsp";
- List<tb_person> personList = basicInfoService.getPersonManagement3();
- String[] rowName = { "搴忓彿", "鐗╄祫鍚嶇О", "鏍囩ID", "閮ㄩ棬", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿" };
+ List<tb_person> personList = this.basicInfoService.getPersonManagement3();
+ String[] rowName = new String[]{"搴忓彿", "鐗╄祫鍚嶇О", "鏍囩ID", "閮ㄩ棬", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿"};
List<Object[]> dataList = personobjectToArray2(personList);
ExcelUtils excel = new ExcelUtils("鐗╄祫绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_export4.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_export4.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_export4(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
- List<tb_person> personList = basicInfoService.getPersonManagement4();
- String[] rowName = { "搴忓彿", "濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿" };
+ List<tb_person> personList = this.basicInfoService.getPersonManagement4();
+ String[] rowName = new String[]{"搴忓彿", "濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽", "鐢甸噺%", "鍥炬爣", "娣诲姞鏃堕棿"};
List<Object[]> dataList = personobjectToArray(personList);
ExcelUtils excel = new ExcelUtils("浜哄憳绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_exportTemplate.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_exportTemplate.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_exportTemplate(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
- List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate(1);
- String[] rowName = { "濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽"};
+ List<tb_person> personTemplateList = this.basicInfoService.getPersonManagementTemplate(1);
+ String[] rowName = new String[]{"濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽"};
List<Object[]> dataList = personTemplateobjectToArray(personTemplateList);
ExcelUtils excel = new ExcelUtils("浜哄憳绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_exportTemplate2.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_exportTemplate2.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_exportTemplate2(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/cheliangmentManagement.jsp";
- List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate2(1);
- String[] rowName = { "杞﹁締鍚嶇О", "鏍囩ID", "閮ㄩ棬"};
+ List<tb_person> personTemplateList = this.basicInfoService.getPersonManagementTemplate2(1);
+ String[] rowName = new String[]{"杞﹁締鍚嶇О", "鏍囩ID", "閮ㄩ棬"};
List<Object[]> dataList = personTemplateobjectToArray2(personTemplateList);
ExcelUtils excel = new ExcelUtils("杞﹁締绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_exportTemplate3.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_exportTemplate3.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_exportTemplate3(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/wuzimentManagement.jsp";
- List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate3(1);
- String[] rowName = { "鐗╄祫鍚嶇О", "鏍囩ID", "閮ㄩ棬"};
+ List<tb_person> personTemplateList = this.basicInfoService.getPersonManagementTemplate3(1);
+ String[] rowName = new String[]{"鐗╄祫鍚嶇О", "鏍囩ID", "閮ㄩ棬"};
List<Object[]> dataList = personTemplateobjectToArray2(personTemplateList);
ExcelUtils excel = new ExcelUtils("鐗╄祫绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
-
+
@ResponseBody
- @RequestMapping(value = "/personManagement_exportTemplate4.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/personManagement_exportTemplate4.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public String personManagement_exportTemplate4(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
- List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate4(1);
- String[] rowName = { "濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽"};
+ List<tb_person> personTemplateList = this.basicInfoService.getPersonManagementTemplate4(1);
+ String[] rowName = new String[]{"濮撳悕", "鏍囩ID", "鎬у埆", "閮ㄩ棬", "鐢佃瘽"};
List<Object[]> dataList = personTemplateobjectToArray(personTemplateList);
ExcelUtils excel = new ExcelUtils("浜哄憳绠$悊", rowName, dataList);
- OutputStream out;
+
try {
String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
String headStr = "attachment; filename=\"" + fileName + "\"";
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", headStr);
- out = response.getOutputStream();
+ OutputStream out = response.getOutputStream();
excel.export(out);
out.flush();
out.close();
- } catch (Exception e) {
- e.printStackTrace();
+ } catch (Exception var11) {
+ var11.printStackTrace();
}
+
return toPage;
}
- @RequestMapping(value = "/person_bw_kaoqin.do", method = { RequestMethod.POST, RequestMethod.GET })
+ @RequestMapping(
+ value = {"/person_bw_kaoqin.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
public void person_bw_kaoqin(HttpServletRequest request) throws IOException {
String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
- //鏄剧ずsql
- String sqlString = "UPDATE tb_person SET p_kaoqin = "+person.getP_kaoqing() +"WHERE p_tagid= +"+person.getP_tagid();
- String messageJson = GetNowTime.timestamp2()+ " 鏀讹細"+ sqlString ;
+ tb_person person = (tb_person)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
+ String sqlString = "UPDATE tb_person SET p_kaoqin = " + person.getP_kaoqing() + "WHERE p_tagid= +" + person.getP_tagid();
+ (new StringBuilder()).append(GetNowTime.timestamp2()).append(" 鏀讹細").append(sqlString).toString();
String BaowenPath = Config.getBaowenConfig();
String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
- if (baowenStatus.equals("1")){
- /* Udp_Receive.mysqlMessage.add(messageJson); */
+ if (baowenStatus.equals("1")) {
}
- //
- basicInfoService.person_modify_kaoqin(person);
- }
- @RequestMapping(value = "/person_bw_power.do", method = { RequestMethod.POST, RequestMethod.GET })
- public void person_bw_power(HttpServletRequest request) throws IOException {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
- //鏄剧ずsql
- String sqlString = "UPDATE tb_person SET p_kaoqin = "+person.getP_kaoqing() +"WHERE p_tagid= +"+person.getP_tagid();
- String messageJson = GetNowTime.timestamp2()+ " 鏀讹細"+ sqlString ;
- String BaowenPath = Config.getBaowenConfig();
- String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
- if (baowenStatus.equals("1")){
- /* Udp_Receive.mysqlMessage.add(messageJson); */
- }
- //
- basicInfoService.person_modify_power(person);
- }
-
- @RequestMapping(value = "/person_bw_SOS.do", method = { RequestMethod.POST, RequestMethod.GET })
- public void person_bw_SOS(HttpServletRequest request) throws IOException {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
- //鏄剧ずsql
- String sqlString = "UPDATE tb_person SET p_sos = "+person.getP_sos() +"WHERE p_tagid= +"+person.getP_tagid();
- String messageJson = GetNowTime.timestamp2()+ " 鏀讹細"+ sqlString ;
- String BaowenPath = Config.getBaowenConfig();
- String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
- if (baowenStatus.equals("1")){
- /* Udp_Receive.mysqlMessage.add(messageJson); */
- }
- //
- basicInfoService.person_modify_sos(person);
- }
-
- @RequestMapping(value = "/person_bw_warning.do", method = { RequestMethod.POST, RequestMethod.GET })
- public void person_bw_warning(HttpServletRequest request) throws IOException {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
- //鏄剧ずsql
- String sqlString = "UPDATE tb_person SET p_sos = "+person.getP_sos() +"WHERE p_tagid= +"+person.getP_tagid();
- String messageJson = GetNowTime.timestamp2()+ " 鏀讹細"+ sqlString ;
- String BaowenPath = Config.getBaowenConfig();
- String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
- if (baowenStatus.equals("1")){
- /* Udp_Receive.mysqlMessage.add(messageJson); */
- }
- //
- basicInfoService.person_modify_warning(person);
- }
-
- @RequestMapping(value = "/person_bw_XYF.do", method = { RequestMethod.POST, RequestMethod.GET })
- public void person_bw_XYF(HttpServletRequest request) throws IOException {
- String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
- tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
- //鏄剧ずsql
- String sqlString = "UPDATE tb_person SET p_x = "+person.getP_x()+",p_y = "+person.getP_y()+",p_floor = "+person.getP_floor()+"WHERE p_tagid= "+person.getP_tagid();
- String messageJson = GetNowTime.timestamp2()+ " 鏀讹細"+ sqlString ;
- String BaowenPath = Config.getBaowenConfig();
- String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
- if (baowenStatus.equals("1")){
- /* Udp_Receive.mysqlMessage.add(messageJson); */
- }
- //
- basicInfoService.person_modify_XYF(person);
+
+ this.basicInfoService.person_modify_kaoqin(person);
}
+ @RequestMapping(
+ value = {"/person_bw_power.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public void person_bw_power(HttpServletRequest request) throws IOException {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_person person = (tb_person)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
+ String sqlString = "UPDATE tb_person SET p_kaoqin = " + person.getP_kaoqing() + "WHERE p_tagid= +" + person.getP_tagid();
+ (new StringBuilder()).append(GetNowTime.timestamp2()).append(" 鏀讹細").append(sqlString).toString();
+ String BaowenPath = Config.getBaowenConfig();
+ String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
+ if (baowenStatus.equals("1")) {
+ }
+
+ this.basicInfoService.person_modify_power(person);
+ }
+
+ @RequestMapping(
+ value = {"/person_bw_SOS.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public void person_bw_SOS(HttpServletRequest request) throws IOException {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_person person = (tb_person)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
+ String sqlString = "UPDATE tb_person SET p_sos = " + person.getP_sos() + "WHERE p_tagid= +" + person.getP_tagid();
+ (new StringBuilder()).append(GetNowTime.timestamp2()).append(" 鏀讹細").append(sqlString).toString();
+ String BaowenPath = Config.getBaowenConfig();
+ String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
+ if (baowenStatus.equals("1")) {
+ }
+
+ this.basicInfoService.person_modify_sos(person);
+ }
+
+ @RequestMapping(
+ value = {"/person_bw_warning.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public void person_bw_warning(HttpServletRequest request) throws IOException {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_person person = (tb_person)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
+ String sqlString = "UPDATE tb_person SET p_sos = " + person.getP_sos() + "WHERE p_tagid= +" + person.getP_tagid();
+ (new StringBuilder()).append(GetNowTime.timestamp2()).append(" 鏀讹細").append(sqlString).toString();
+ String BaowenPath = Config.getBaowenConfig();
+ String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
+ if (baowenStatus.equals("1")) {
+ }
+
+ this.basicInfoService.person_modify_warning(person);
+ }
+
+ @RequestMapping(
+ value = {"/person_bw_XYF.do"},
+ method = {RequestMethod.POST, RequestMethod.GET}
+ )
+ public void person_bw_XYF(HttpServletRequest request) throws IOException {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_person person = (tb_person)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
+ String sqlString = "UPDATE tb_person SET p_x = " + person.getP_x() + ",p_y = " + person.getP_y() + ",p_floor = " + person.getP_floor() + "WHERE p_tagid= " + person.getP_tagid();
+ (new StringBuilder()).append(GetNowTime.timestamp2()).append(" 鏀讹細").append(sqlString).toString();
+ String BaowenPath = Config.getBaowenConfig();
+ String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
+ if (baowenStatus.equals("1")) {
+ }
+
+ this.basicInfoService.person_modify_XYF(person);
+ }
}
--
Gitblit v1.10.0