From f6c8a961595ea54f2c9a6b7da589480481cc6283 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期一, 21 六月 2021 14:28:08 +0800
Subject: [PATCH] #
---
src/main/java/com/slcf/service/impl/WaitPakOutLogServiceImpl.java | 94 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 91 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/slcf/service/impl/WaitPakOutLogServiceImpl.java b/src/main/java/com/slcf/service/impl/WaitPakOutLogServiceImpl.java
index 891049d..04e840e 100644
--- a/src/main/java/com/slcf/service/impl/WaitPakOutLogServiceImpl.java
+++ b/src/main/java/com/slcf/service/impl/WaitPakOutLogServiceImpl.java
@@ -1,9 +1,15 @@
package com.slcf.service.impl;
+import java.io.IOException;
+import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
+import com.slcf.util.DateTimeUtil;
+import org.apache.poi.hssf.usermodel.HSSFRow;
+import org.apache.poi.hssf.usermodel.HSSFSheet;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -11,6 +17,8 @@
import com.slcf.dao.WaitPakOutLogDao;
import com.slcf.pojo.WaitPakOutLogBean;
import com.slcf.service.WaitPakOutLogService;
+
+import javax.servlet.http.HttpServletResponse;
/**
* 鍑哄簱閫氱煡鍘嗗彶妗ｆ帴鍙ｅ疄鐜�
@@ -22,7 +30,7 @@
@Autowired
WaitPakOutLogDao waitPakOutLogDao;
-
+
/**
* 鍒嗛〉鏌ヨ鎵�鏈�
*/
@@ -52,5 +60,85 @@
return null;
}
}
-
-}
\ No newline at end of file
+
+ public void ExportWaitPakOutLogList(WaitPakOutLogCondition condition, HttpServletResponse response) {
+ //杈撳嚭Excel鏂囦欢
+ try {
+ //HSSFWorkbook瀵硅薄(excel鐨勬枃妗ｅ璞�)
+ HSSFWorkbook workBook=new HSSFWorkbook();
+
+ //sheet瀵硅薄锛坋xcel鐨勮〃鍗曪級
+ HSSFSheet sheet=workBook.createSheet("鍑哄簱閫氱煡鍘嗗彶妗�");
+
+ //琛屾暟锛屽弬鏁颁负琛岀储寮�(excel鐨勮)
+// HSSFRow rowHead=sheet.createRow(0);//绗竴琛� 鍙互鏄�0锝�65535涔嬮棿鐨勪换浣曚竴涓�
+
+// //鍒涘缓excel鐨勫崟鍏冩牸锛屽弬鏁颁负鍒楃储寮曪紝鍙互鏄�0锝�255涔嬮棿鐨勪换浣曚竴涓�
+// HSSFCell cellOne=rowHead.createCell(0);
+// cellOne.setCellValue("鐢ㄦ埛淇℃伅");//琛ㄥご
+
+ //鍚堝苟鍗曞厓鏍糃ellRangeAddress鏋勯�犲弬鏁颁緷娆¤〃绀鸿捣濮嬭锛屾埅鑷宠锛岃捣濮嬪垪锛� 鎴嚦鍒�
+// sheet.addMergedRegion(new CellRangeAddress(0,0,0,5));
+
+ sheet.setColumnWidth(0, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(1, (int)((20 + 0.72) * 256));
+ sheet.setColumnWidth(2, (int)((15 + 0.72) * 256));
+ sheet.setColumnWidth(3, (int)((15 + 0.72) * 256));
+ sheet.setColumnWidth(4, (int)((15 + 0.72) * 256));
+ sheet.setColumnWidth(5, (int)((25 + 0.72) * 256));
+ sheet.setColumnWidth(6, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(7, (int)((8 + 0.72) * 256));
+ sheet.setColumnWidth(8, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(9, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(10, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(11, (int)((25 + 0.72) * 256));
+ sheet.setColumnWidth(12, (int)((25 + 0.72) * 256));
+
+ HSSFRow rows=sheet.createRow(0);//绗簩琛�
+ //鍒涘缓鍗曞厓鏍煎苟璁剧疆鍗曞厓鏍煎唴瀹�
+ rows.createCell(0).setCellValue("浠撳簱鍙�");
+ rows.createCell(1).setCellValue("杞偍缂栧彿");
+ rows.createCell(2).setCellValue("琛岄」鐩�");
+ rows.createCell(3).setCellValue("鐗╂枡");
+ rows.createCell(4).setCellValue("鐗╂枡鎻忚堪");
+ rows.createCell(5).setCellValue("宸ュ巶");
+ rows.createCell(6).setCellValue("鏁伴噺");
+ rows.createCell(7).setCellValue("鍗曚綅");
+ rows.createCell(8).setCellValue("婧愬彂鍦扮被鍨�");
+ rows.createCell(9).setCellValue("婧愬彂鍦颁粨浣�");
+ rows.createCell(10).setCellValue("鐩殑鍦扮被鍨�");
+ rows.createCell(11).setCellValue("鐩殑鍦颁粨浣�");
+ rows.createCell(12).setCellValue("鐢ㄦ埛ID");
+
+ List<WaitPakOutLogBean> list=waitPakOutLogDao.getWaitPakOutLogAll(condition);
+ for(int i=0;i<list.size();i++){
+ HSSFRow row=sheet.createRow(i+1);//浠庣涓夎寮�濮�
+ //鍒涘缓鍗曞厓鏍煎苟璁剧疆鍗曞厓鏍煎唴瀹�
+ row.createCell(0).setCellValue(list.get(i).getLgnum());
+ row.createCell(1).setCellValue(list.get(i).getTanum());
+ row.createCell(2).setCellValue(list.get(i).getTapos());
+ row.createCell(3).setCellValue(list.get(i).getMatnr());
+ row.createCell(4).setCellValue(list.get(i).getMaktx());
+ row.createCell(5).setCellValue(list.get(i).getWerks());
+ row.createCell(6).setCellValue(list.get(i).getVsolm());
+ row.createCell(7).setCellValue(list.get(i).getMeins());
+ row.createCell(8).setCellValue(list.get(i).getVltyp());
+ row.createCell(9).setCellValue(list.get(i).getVlpla());
+ row.createCell(10).setCellValue(list.get(i).getNltyp());
+ row.createCell(11).setCellValue(list.get(i).getNlpla());
+ row.createCell(12).setCellValue(list.get(i).getBname());
+ }
+// //杈撳嚭Excel鏂囦欢
+// try {
+ OutputStream output=response.getOutputStream();
+ response.reset();
+ response.setHeader("Content-disposition", "attachment; filename=WaitPakOutLog"+ DateTimeUtil.getStringDateTime(14)+".xls");
+ response.setContentType("application/msexcel");
+ workBook.write(output);
+ output.close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+
+}
--
Gitblit v1.9.1