From 1e91dc33009cfdc951b2642877f40280b51c3089 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 28 二月 2025 15:17:01 +0800 Subject: [PATCH] zjh20250228 --- ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java | 97 +++++++++++++++++++++++++----------------------- 1 files changed, 51 insertions(+), 46 deletions(-) diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java index 8a384d3..0c2433c 100644 --- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java +++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java @@ -103,56 +103,61 @@ @ApiOperation(value = "瀵煎嚭excel琛ㄦā鏉�") public void importTemplate(HttpServletResponse response) { //鍘熸潵鐨勪笅杞芥ā鏉胯皟鐢ㄦ帴鍙� - String base64String = PDFBinaryUtil.getPDFBinary(configService.selectConfigByKey("default_excelTemplate")); - if (null != base64String) { - PDFBinaryUtil.base64StringToPDF(base64String, FileUtil.mkdir(value).getPath() + File.separator + "鍥綋棰勭害Excel妯$増.xls"); - String filePath = value + File.separator + "鍥綋棰勭害Excel妯$増.xls"; - File f = new File(filePath); - BufferedInputStream br = null; - OutputStream out = null; - FileInputStream fileInputStream = null; - try { - fileInputStream = new FileInputStream(f); - br = new BufferedInputStream(fileInputStream); - byte[] bs = new byte[1024]; - int len = 0; - response.reset(); // 闈炲父閲嶈 - if (true) { - // 鍦ㄧ嚎鎵撳紑鏂瑰紡 - URL u = new URL("file:///" + filePath); - //System.out.println(u); - String contentType = u.openConnection().getContentType(); - response.setContentType(contentType); - response.setHeader("Content-Disposition", "inline;filename=鍥綋棰勭害Excel妯$増.xls"); - } else { - // 绾笅杞芥柟寮� - response.setContentType("application/x-msdownload"); - response.setContentType("application/pdf;charset=utf-8"); - response.setHeader("Content-Disposition", "attachment;filename=鍥綋棰勭害Excel妯$増.xls"); - } - out = response.getOutputStream(); - while ((len = br.read(bs)) > 0) { - out.write(bs, 0, len); - } - out.flush(); - out.close(); - br.close(); - fileInputStream.close(); - } catch (IOException e) { - e.printStackTrace(); - //System.out.println("pdf澶勭悊鏂囦欢寮傚父" + e); - } finally { - if (out != null) { - try { - out.close(); - br.close(); - fileInputStream.close(); + try { + String base64String = PDFBinaryUtil.getPDFBinary(value + File.separator + "瑗垮畨璺嘲鏈虹數绉戞妧鏈夐檺鍏徃.xls"); + if (null != base64String) { + PDFBinaryUtil.base64StringToPDF(base64String, FileUtil.mkdir(value).getPath() + File.separator + "鍥綋棰勭害Excel妯$増.xls"); + String filePath = value + File.separator + "鍥綋棰勭害Excel妯$増.xls"; + File f = new File(filePath); + BufferedInputStream br = null; + OutputStream out = null; + FileInputStream fileInputStream = null; + try { + fileInputStream = new FileInputStream(f); + br = new BufferedInputStream(fileInputStream); + byte[] bs = new byte[1024]; + int len = 0; + response.reset(); // 闈炲父閲嶈 + if (true) { + // 鍦ㄧ嚎鎵撳紑鏂瑰紡 + URL u = new URL("file:///" + filePath); + //System.out.println(u); + String contentType = u.openConnection().getContentType(); + response.setContentType(contentType); + response.setHeader("Content-Disposition", "inline;filename=鍥綋棰勭害Excel妯$増.xls"); + } else { + // 绾笅杞芥柟寮� + response.setContentType("application/x-msdownload"); + response.setContentType("application/pdf;charset=utf-8"); + response.setHeader("Content-Disposition", "attachment;filename=鍥綋棰勭害Excel妯$増.xls"); + } + out = response.getOutputStream(); + while ((len = br.read(bs)) > 0) { + out.write(bs, 0, len); + } + out.flush(); + out.close(); + br.close(); + fileInputStream.close(); + } catch (IOException e) { + e.printStackTrace(); + //System.out.println("pdf澶勭悊鏂囦欢寮傚父" + e); + } finally { + if (out != null) { + try { + out.close(); + br.close(); + fileInputStream.close(); - } catch (IOException e) { - e.printStackTrace(); + } catch (IOException e) { + e.printStackTrace(); + } } } } + } catch (Exception e) { + ExcelUtils.exportTemplate(response,"鍥綋棰勭害Excel妯$増",TjReservation.class); + throw new RuntimeException(e); } } -- Gitblit v1.8.0