Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r15003 -r15058 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 15003) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 15058) @@ -79,6 +79,14 @@ import com.forgon.tools.util.ForgonDateUtils; import com.forgon.tools.util.SqlUtils; +import jxl.Workbook; +import jxl.write.Label; +import jxl.write.WritableCellFormat; +import jxl.write.WritableFont; +import jxl.write.WritableSheet; +import jxl.write.WritableWorkbook; + + import edu.emory.mathcs.backport.java.util.Collections; /** @@ -879,8 +887,126 @@ tousseList = basketQr.list(); } } - createExportFile(tousseList, ops); + //createExportFile(tousseList, ops); + createExportFileByJxl(tousseList, ops); } + + /** + * 基础jxl组件的导出下载实现方法 + */ + private void createExportFileByJxl(List tousseList, + OutputStream ops){ + WritableWorkbook book = null; + try { + // 打开文件 + book = Workbook.createWorkbook(ops); + + if(tousseList!=null && !tousseList.isEmpty()){ + int length=tousseList.size();//查询结果记录数 + int sheetSize=60000; + int sheetNum=1; + if(length%sheetSize>0){ + sheetNum=length/sheetSize+1; + }else{ + sheetNum=length/sheetSize; + } + //需导出的列头定义(与器械包信息页面列表保持一致) + String ss[] = {"器械包名称","条码","标识牌条码","状态","所在位置","所属仓库","清洗人","清洗时间","失效日期","装配人","装配时间","审核人","审核时间","包装类型","灭菌员","灭菌完成时间","灭菌程序","灭菌批号","发货人","发货时间","废弃时间","废弃原因","废弃操作人" }; + Label label; + //循环sheet数量 + for(int kk=0;kk tousseList, OutputStream ops) {