| | |
| | | String cap_echart = req.getParameter("cap_echart"); //测试容量折线图 |
| | | String actualCap_echart = req.getParameter("actualCap_echart"); //实际容量折线图 |
| | | String vol_echart = req.getParameter("vol_echart"); //单体电压折线图 |
| | | String tempEnvi_echart = req.getParameter("tempEnvi_echart");//环境温度折线图 |
| | | String HumiEnvi_echart = req.getParameter("tempEnvi_echart");//环境湿度折线图 |
| | | |
| | | |
| | | String filePath = req.getParameter("filePath"); |
| | | FboDataInf fboDataInf = new FboDataInf(); |
| | |
| | | String[] url = vol_echart.split(","); |
| | | bytes.add(new BASE64Decoder().decodeBuffer(url[1])); |
| | | } |
| | | if (ServletUtils.isNotNull(tempEnvi_echart)) { |
| | | String[] url = tempEnvi_echart.split(","); |
| | | bytes.add(new BASE64Decoder().decodeBuffer(url[1])); |
| | | } |
| | | if (ServletUtils.isNotNull(HumiEnvi_echart)) { |
| | | String[] url = HumiEnvi_echart.split(","); |
| | | bytes.add(new BASE64Decoder().decodeBuffer(url[1])); |
| | | } |
| | | }catch (Exception e){ |
| | | e.printStackTrace(); |
| | | } |
| | |
| | | sheet.getRow(rowNumSheet).createCell(1).setCellValue("单体数量:"+start.batt_mon_num); |
| | | rowNumSheet++; |
| | | sheet.createRow(rowNumSheet); |
| | | sheet.getRow(rowNumSheet).createCell(0).setCellValue("测试开始时间:"+formartDate(start.testStartTime,"yyyy-MM-dd")); |
| | | sheet.getRow(rowNumSheet).createCell(0).setCellValue("测试开始时间:"+formartDate(start.testStartTime,"yyyy-MM-dd HH:mm:ss")); |
| | | sheet.getRow(rowNumSheet).createCell(1).setCellValue("测试时长:"+stop.TestTimeLong.hms()); |
| | | rowNumSheet++; |
| | | sheet.createRow(rowNumSheet); |
| | |
| | | rowNumSheet+=2; |
| | | //插入图片 |
| | | int picNum = 0; |
| | | String[] picName = new String[]{ |
| | | "电池电流折线图","组端电压折线图","测试容量折线图","实际容量折线图","单体电压折线图" |
| | | }; |
| | | String[] picName = getPicName(start.DataType); |
| | | if (picName.length==bytes.size()){ |
| | | for(int i=0;i<picName.length;i++){ |
| | | sheet.createRow(rowNumSheet-1); |
| | |
| | | } |
| | | } |
| | | |
| | | public String[] getPicName(int dateType){ |
| | | if (dateType==0xFB){ |
| | | String[] picName1 = new String[]{ |
| | | "电池电流折线图","组端电压折线图","测试容量折线图","实际容量折线图","单体电压折线图","环境温度折线图","环境湿度折线图" |
| | | }; |
| | | return picName1; |
| | | }else{ |
| | | String[] picName = new String[]{ |
| | | "电池电流折线图","组端电压折线图","测试容量折线图","实际容量折线图","单体电压折线图" |
| | | }; |
| | | return picName; |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 将日期格式转换成指定的字符串格式 |