From 2331d50cf12f0b8c882e6850d3a6a11baf4985e6 Mon Sep 17 00:00:00 2001
From: 刘小明 <liuxm_a@163.com>
Date: 星期二, 24 九月 2024 14:30:48 +0800
Subject: [PATCH] 接口中添加产品类型字段

---
 pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java |   31 ++++++++++++++++++++++++++++++-
 1 files changed, 30 insertions(+), 1 deletions(-)

diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java
index 4fae5bf..c259586 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java
@@ -82,7 +82,36 @@
             response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
             EasyExcel.write(response.getOutputStream(), list.get(0).getClass()).sheet(sheetName).doWrite(list);
         }catch (Exception e){
-            log.error("瀵煎嚭浜у搧淇℃伅寮傚父", e);
+            log.error("瀵煎嚭{}寮傚父",sheetName,e);
         }
     }
+    public static void downloadExcelSheets(HttpServletResponse response, String fileName, String sheetName, List<Converter> list){
+        if(CollectionUtils.isEmpty(list)){
+            return;
+        }
+        /*try(ExcelWriter excelWriter = EasyExcel.write(file).build()) {
+            WriteSheet writeSheet;
+            for (SheetInfoBean bean : sheetInfoList) {
+                // 鏋勫缓sheet瀵硅薄
+                writeSheet = EasyExcel.writerSheet(bean.getSheetName()).head(bean.getHeadClass()).build();
+                // 鍐欏嚭sheet鏁版嵁
+                excelWriter.write(bean.getDataList(), writeSheet);
+            }
+            // 鍏虫祦
+            excelWriter.finish();
+        } catch (Exception e) {
+            // do something you want
+        }*/
+        try{
+            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+            response.setCharacterEncoding("utf-8");
+            fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+            response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
+            EasyExcel.write(response.getOutputStream(), list.get(0).getClass()).sheet(sheetName).doWrite(list);
+        }catch (Exception e){
+            log.error("瀵煎嚭{}寮傚父",sheetName,e);
+        }
+    }
+
+
 }
\ No newline at end of file

--
Gitblit v1.8.0