From 52cffc4ab8e9787a6f233295502c7c9788dddae1 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期二, 07 三月 2023 10:45:17 +0800
Subject: [PATCH] 3.7

---
 src/main/java/com/hxzkoa/controller/BasicInfoController.java |  633 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 632 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/hxzkoa/controller/BasicInfoController.java b/src/main/java/com/hxzkoa/controller/BasicInfoController.java
index 33f0676..519f07a 100644
--- a/src/main/java/com/hxzkoa/controller/BasicInfoController.java
+++ b/src/main/java/com/hxzkoa/controller/BasicInfoController.java
@@ -21,11 +21,13 @@
 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;*/
@@ -47,6 +49,8 @@
 	private BasicInfoService basicInfoService;
 	@Autowired
 	private LabelService labelService;
+	@Autowired
+	private ZhwService zhwService;
 
 	@RequestMapping(value = "/iconManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
 	public String iconManagement(HttpServletRequest request) {
@@ -160,6 +164,17 @@
 		request.setAttribute("curPage", curPage);
 		return toPage;
 	}
+	
+	@ResponseBody
+	@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();
+		json.put("dataList", departmentManagementList);
+		json.put("dataList2", navList);
+		return json;
+	}
 
 	@ResponseBody
 	@RequestMapping(value = "/departmentManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -308,6 +323,51 @@
 		request.setAttribute("curPage", curPage);
 		return toPage;
 	}
+	
+	@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);
+		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);
+		return toPage;
+	}
+	
+	@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);
+		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);
+		return toPage;
+	}
+	
+	@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);
+		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);
+		return toPage;
+	}
 
 	@ResponseBody
 	@RequestMapping(value = "/personManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -337,6 +397,93 @@
 		json.put("curPage", page);
 		return json.toString();
 	}
+	
+	@ResponseBody
+	@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 minPage = PageUtil.getMinPage(count);
+		int curPage = Integer.parseInt(curPageStr);
+		int page = 1;
+		if ("pre".equals(pageStr)) {
+			if (curPage > 1) {
+				page = curPage - 1;
+			}
+		} else if ("next".equals(pageStr)) {
+			if (curPage < minPage) {
+				page = curPage + 1;
+			}
+		} else {
+			page = Integer.parseInt(pageStr);
+		}
+		List<tb_person> personManagementList = basicInfoService.getPersonManagement2(page);
+		List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+		JSONObject json = new JSONObject();
+		json.put("dataList", personManagementList);
+		json.put("pageList", pageList);
+		json.put("curPage", page);
+		return json.toString();
+	}
+	
+	@ResponseBody
+	@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 minPage = PageUtil.getMinPage(count);
+		int curPage = Integer.parseInt(curPageStr);
+		int page = 1;
+		if ("pre".equals(pageStr)) {
+			if (curPage > 1) {
+				page = curPage - 1;
+			}
+		} else if ("next".equals(pageStr)) {
+			if (curPage < minPage) {
+				page = curPage + 1;
+			}
+		} else {
+			page = Integer.parseInt(pageStr);
+		}
+		List<tb_person> personManagementList = basicInfoService.getPersonManagement3(page);
+		List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+		JSONObject json = new JSONObject();
+		json.put("dataList", personManagementList);
+		json.put("pageList", pageList);
+		json.put("curPage", page);
+		return json.toString();
+	}
+	
+	@ResponseBody
+	@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 minPage = PageUtil.getMinPage(count);
+		int curPage = Integer.parseInt(curPageStr);
+		int page = 1;
+		if ("pre".equals(pageStr)) {
+			if (curPage > 1) {
+				page = curPage - 1;
+			}
+		} else if ("next".equals(pageStr)) {
+			if (curPage < minPage) {
+				page = curPage + 1;
+			}
+		} else {
+			page = Integer.parseInt(pageStr);
+		}
+		List<tb_person> personManagementList = basicInfoService.getPersonManagement4(page);
+		List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+		JSONObject json = new JSONObject();
+		json.put("dataList", personManagementList);
+		json.put("pageList", pageList);
+		json.put("curPage", page);
+		return json.toString();
+	}
 
 	@ResponseBody
 	@RequestMapping(value = "/personManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -364,6 +511,87 @@
 		}
 		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 })
@@ -398,6 +626,8 @@
 		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";
 		Udp_Out.udp_to_cs(xieyi);
@@ -409,6 +639,24 @@
 			labelService.labelManagement_modify(tag);
 		}
 	}
+	
+	@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";
+		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);
+			tag.setState(person.getP_name());
+			labelService.labelManagement_modify(tag);
+		}
+	}
 
 	@RequestMapping(value = "/uploadPerson.do")
 	public String uploadPerson(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
@@ -422,7 +670,7 @@
 			}
 			for (MultipartFile file : files) {
 				file.transferTo(new File(filePath + file.getOriginalFilename()));
-				System.out.print(file.getOriginalFilename());
+				////System.out.print(file.getOriginalFilename());
 			}
 		} catch (IOException e) {
 			e.printStackTrace();
@@ -477,6 +725,214 @@
 		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);
+		File file = new File(path);
+		file.delete();
+		return toPage;
+	}
 
 	// 瀵硅薄杞暟缁�
 	public static List<Object[]> personobjectToArray(List<tb_person> personList) {
@@ -499,6 +955,24 @@
 		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);
+			words.add(String.valueOf(person.getId()));
+			words.add(person.getP_name());
+			words.add(person.getP_tagid());
+			words.add(person.getP_department());
+			words.add(person.getP_power());
+			words.add(person.getP_image());
+			words.add(person.getP_addtiem());
+			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<>();
@@ -515,6 +989,20 @@
 			}
 			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;
+		}
 
 	@ResponseBody
 	@RequestMapping(value = "/personManagement_export.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -541,6 +1029,78 @@
 	}
 	
 	@ResponseBody
+	@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<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();
+			excel.export(out);
+			out.flush();
+			out.close();
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+		return toPage;
+	}
+	
+	@ResponseBody
+	@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<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();
+			excel.export(out);
+			out.flush();
+			out.close();
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+		return toPage;
+	}
+	
+	@ResponseBody
+	@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<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();
+			excel.export(out);
+			out.flush();
+			out.close();
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+		return toPage;
+	}
+	
+	@ResponseBody
 	@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";
@@ -564,6 +1124,77 @@
 		return toPage;
 	}
 	
+	@ResponseBody
+	@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<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();
+			excel.export(out);
+			out.flush();
+			out.close();
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+		return toPage;
+	}
+	
+	@ResponseBody
+	@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<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();
+			excel.export(out);
+			out.flush();
+			out.close();
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+		return toPage;
+	}
+	
+	@ResponseBody
+	@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<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();
+			excel.export(out);
+			out.flush();
+			out.close();
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+		return toPage;
+	}
 
 	@RequestMapping(value = "/person_bw_kaoqin.do", method = { RequestMethod.POST, RequestMethod.GET })
 	public void person_bw_kaoqin(HttpServletRequest request) throws IOException {

--
Gitblit v1.10.0