| | |
| | | headerList.add("含税售价"); |
| | | headerList.add("CAS号"); |
| | | headerList.add("危险性质"); |
| | | headerList.add("供应商"); |
| | | headerList.add("厂家"); |
| | | headerList.add("试剂类型"); |
| | | headerList.add("申购数量"); |
| | |
| | | headerList.add("二级审批者"); |
| | | headerList.add("订单状态"); |
| | | headerList.add("审批批注"); |
| | | |
| | | HSSFWorkbook hssfWorkbook =exportExcelNew(headerList, realDataList); |
| | | hssfWorkbook.write(out); |
| | | out.flush(); |
| | |
| | | dataRow.createCell(6).setCellValue(dataList.get(i).getReagent().getPrice()== null ? "": String.valueOf(dataList.get(i).getReagent().getPrice())); |
| | | dataRow.createCell(7).setCellValue(dataList.get(i).getReagent().getCas()== null ? "": String.valueOf(dataList.get(i).getReagent().getCas())); |
| | | dataRow.createCell(8).setCellValue(dataList.get(i).getReagent().getReagentCharacter()== null ? "": String.valueOf(baseMetaService.getBaseMetaValue(dataList.get(i).getReagent().getReagentCharacter()))); |
| | | dataRow.createCell(9).setCellValue(dataList.get(i).getReagent().getProductHomeName()== null ? "": String.valueOf(dataList.get(i).getReagent().getProductHomeName())); |
| | | dataRow.createCell(10).setCellValue(dataList.get(i).getReagent().getReagentType()== null ? "": String.valueOf(baseMetaService.getBaseMetaValue(dataList.get(i).getReagent().getReagentType()))); |
| | | dataRow.createCell(11).setCellValue(String.valueOf(dataList.get(i).getNum())); |
| | | dataRow.createCell(12).setCellValue(String.valueOf(dataList.get(i).getApplyUserName())); |
| | | dataRow.createCell(13).setCellValue(dataList.get(i).getApplyUserProject() == null?"":String.valueOf(dataList.get(i).getApplyUserProject())); |
| | | dataRow.createCell(14).setCellValue(dataList.get(i).getApplyUserDepartment() == null?"":String.valueOf(dataList.get(i).getApplyUserDepartment())); |
| | | dataRow.createCell(9).setCellValue(dataList.get(i).getReagent().getSupplierName()== null ? "": String.valueOf(dataList.get(i).getReagent().getSupplierName())); |
| | | |
| | | |
| | | dataRow.createCell(15).setCellValue(String.valueOf(dataList.get(i).getCreateTime())); |
| | | dataRow.createCell(10).setCellValue(dataList.get(i).getReagent().getProductHomeName()== null ? "": String.valueOf(dataList.get(i).getReagent().getProductHomeName())); |
| | | dataRow.createCell(11).setCellValue(dataList.get(i).getReagent().getReagentType()== null ? "": String.valueOf(baseMetaService.getBaseMetaValue(dataList.get(i).getReagent().getReagentType()))); |
| | | dataRow.createCell(12).setCellValue(String.valueOf(dataList.get(i).getNum())); |
| | | dataRow.createCell(13).setCellValue(String.valueOf(dataList.get(i).getApplyUserName())); |
| | | dataRow.createCell(14).setCellValue(dataList.get(i).getApplyUserProject() == null?"":String.valueOf(dataList.get(i).getApplyUserProject())); |
| | | dataRow.createCell(15).setCellValue(dataList.get(i).getApplyUserDepartment() == null?"":String.valueOf(dataList.get(i).getApplyUserDepartment())); |
| | | |
| | | |
| | | dataRow.createCell(16).setCellValue(String.valueOf(dataList.get(i).getCreateTime())); |
| | | // SysUser u=sysUserService.getSysUser(dataList.get(i).getApproveUserId()); |
| | | dataRow.createCell(16).setCellValue(String.valueOf(dataList.get(i).getFirName())); |
| | | dataRow.createCell(17).setCellValue(String.valueOf(dataList.get(i).getFirName())); |
| | | if(dataList.get(i).getBeforeApproveUserId()!=null && !dataList.get(i).getBeforeApproveUserId().equals("")){ |
| | | //u=sysUserService.getSysUser(dataList.get(i).getBeforeApproveUserId()); |
| | | dataRow.createCell(17).setCellValue(String.valueOf(dataList.get(i).getApproveUserName())); |
| | | dataRow.createCell(18).setCellValue(String.valueOf(dataList.get(i).getApproveUserName())); |
| | | } |
| | | //dataRow.createCell(14).setCellValue(String.valueOf(u.getName())); |
| | | dataRow.createCell(18).setCellValue(String.valueOf(dataList.get(i).getStatus().getText())); |
| | | dataRow.createCell(19).setCellValue(dataList.get(i).getMemo()==null ?"":String.valueOf(dataList.get(i).getMemo())); |
| | | dataRow.createCell(19).setCellValue(String.valueOf(dataList.get(i).getStatus().getText())); |
| | | dataRow.createCell(20).setCellValue(dataList.get(i).getMemo()==null ?"":String.valueOf(dataList.get(i).getMemo())); |
| | | } |
| | | |
| | | return hssfWorkbook; |