使用Iframe标签 发送ajax 返回 文件名
···
public void exportData(@RequestParam("ids") String ids, HttpServletResponse response, HttpServletRequest request) {
this.tbService.exportToExcel(ids, response, request);
}
···
/**
* 导出表格
* */
```
@Override
public void exportToExcel(String ids, HttpServletResponse response, HttpServletRequest request) {
PageParameter page = new PageParameter();
page.setRows(Integer.MAX_VALUE);
List<Object[]> list = new ArrayList<Object[]>();
String [] str = ids.split(",");
String code ="";
String snStr="";
String freeStr="";
String qStr="";
for(int j=0; j<str.length; j++) {
TraceabilityDto trDto = traceabilityMapperDao.selectDtoById(Integer.parseInt(str[j]));
if(trDto ==null) {
continue;
}else {
Object[] obj = new Object[12];
obj[0] = trDto.getMaterialName();
obj[1] = trDto.getCustomerName();
if(trDto.getRaditmCode() !=null) {
code=trDto.getRaditmCode();
}else if(trDto.getNgCode() !=null){
code=trDto.getNgCode();
}else {
code="";
}
obj[2] = code;
obj[3] = trDto.getMachiningOp();
obj[4] = trDto.getMaterialHeatNumber();
obj[5] = trDto.getProductName();
obj[6] = trDto.getProductCode();
obj[7] = trDto.getEncasementCode();
obj[8] = trDto.getPalletCode();
if(trDto.getSn() == 1){
snStr="压铸完成";
}else if(trDto.getSn() == 2){
snStr="抛丸镭雕完成";
}else if(trDto.getSn() == 3){
snStr="入半成品库";
}else if(trDto.getSn() == 4){
snStr="出半成品库";
}else if(trDto.getSn() == 5){
snStr="机加完成";
}else if(trDto.getSn() == 6){
snStr="装箱";
}else if(trDto.getSn() == 7){
snStr="客户码";
}else if(trDto.getSn() == 8){
snStr="入成品库";
}else if(trDto.getSn() == 9){
snStr="检验合格";
}else if(trDto.getSn() == 10){
snStr="出成品库";
}else if(trDto.getSn() == 11){
snStr="镭雕不良";
}else if(trDto.getSn() == 12){
snStr="镭雕返工返修";
}else if(trDto.getSn() == 13){
snStr="机加不良";
}else if(trDto.getSn() == 14){
snStr="机加返工返修";
}else if(trDto.getSn() == 15){
snStr="报废";
}else if(trDto.getSn() == 16){
snStr="送检";
}else if(trDto.getSn() == 17){
snStr="出货检测为嫌疑品";
}
obj[9] = snStr;
if (trDto.getQualified() == 0) {
qStr="良品";
}else if (trDto.getQualified() == 1) {
qStr="不良品";
}else if (trDto.getQualified() == 2) {
qStr= "嫌疑品";
}
obj[10] =qStr;
if(trDto.getFreeze()==0){
freeStr="未冻结";
}else if(trDto.getFreeze() ==1){
freeStr="冻结";
}
obj[11] =freeStr;
list.add(obj);
}
}
String path = SystemUtil.getSystemTempPath();
String templatePath = request.getSession().getServletContext().getRealPath("/template");
ExcelWriteConfig config = new ExcelWriteConfig();
config.setStartRowIndex(2);
String fileName = "\\trace_" + (new Date()).getTime() + ".xlsx";
ExcelUtil.writeToExcel(list, path + fileName, templatePath + "/template_trace.xlsx", config);
FileUtil.downloadFile(response, path, fileName);
}
```
网友评论