'ld9导出'

whyclxw

2022-03-15 2bc4dc1abb05d0c6d2d26f05f8046c2863222967

'ld9导出'

 src/main/java/com/whyc/pojo/Ld9testdata.java

@@ -66,5 +66,9 @@

    private Integer testMonnum;

    private Float monCap;

    private Float monRestCap;


}

 src/main/java/com/whyc/pojo/Ld9testdatastop.java

@@ -69,5 +69,9 @@

    private Integer testStopreason;

    private Float monCap;

    private Float monRestCap;


}

 src/main/java/com/whyc/service/EchartPictureDowloadService.java

@@ -287,7 +287,7 @@


        String[] arrTh = new String[]{
                "单体编号","起始单体电压(V)","截止单体电压(V)","测试容量(AH)","单体内阻(mΩ)","起始单体温度(℃)","终止单体温度(℃)"
                "单体编号","起始单体电压(V)","截止单体电压(V)","测试容量(AH)","实际容量(AH)","剩余容量(AH)","单体内阻(mΩ)","起始单体温度(℃)","终止单体温度(℃)"
        };
        sheet1.createRow(rownum);
        for(int i = 0 ;i<arrTh.length;i++){
@@ -723,6 +723,8 @@
                    sheet.getRow(currRow+4).createCell(currCel).setCellValue("电流(A)");
                    sheet.getRow(currRow+5).createCell(currCel).setCellValue("测试容量(AH)");
                    sheet.getRow(currRow+6).createCell(currCel).setCellValue("单体电压"+monNum+"(V)");
                    sheet.getRow(currRow+7).createCell(currCel).setCellValue("实际容量(AH)");
                    sheet.getRow(currRow+8).createCell(currCel).setCellValue("剩余容量(AH)");
                }
                currCel++;
                sheet.getRow(currRow+1).createCell(currCel).setCellValue(formatTestLong(data.getTestTimelong()));
@@ -731,6 +733,8 @@
                sheet.getRow(currRow+4).createCell(currCel).setCellValue(formartDouble(data.getTestCurr(),3));
                sheet.getRow(currRow+5).createCell(currCel).setCellValue(formartDouble(data.getTestCap(),1));
                sheet.getRow(currRow+6).createCell(currCel).setCellValue(formartDouble(data.getMonVol(),3));
                sheet.getRow(currRow+7).createCell(currCel).setCellValue(formartDouble(data.getMonCap(),1));
                sheet.getRow(currRow+8).createCell(currCel).setCellValue(formartDouble(data.getMonRestCap(),1));
            }
        }
    }

 src/main/resources/mapper/Ld9testdataMapper.xml

@@ -10,7 +10,7 @@
        GROUP BY test_monnum  order by test_monnum asc
    </select>
    <select id="serchByCondition" resultType="com.whyc.pojo.Ld9testdata">
        select num,BattGroupId,test_record_count,test_type,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol,test_curr,test_cap,mon_num,mon_vol,mon_tmp,test_monnum
        select num,BattGroupId,test_record_count,test_type,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol,test_curr,test_cap,mon_cap,mon_rest_cap,mon_num,mon_vol,mon_tmp,test_monnum
        from db_ld9_testdata.tb_ld9testdata_${battGroupId}
        where test_record_count=#{testRecordCount}  and (record_num%#{roteN}=0 ) and test_monnum=#{testMonNum}
    </select>

 src/main/resources/mapper/Ld9testdatastopMapper.xml

@@ -4,12 +4,12 @@


    <select id="serchByInfo" resultType="com.whyc.pojo.Ld9testdatastop">
        select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_num,mon_vol,test_monnum,max_monvol,min_monvol,test_stopreason
        select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_cap,mon_rest_cap,mon_num,mon_vol,test_monnum,max_monvol,min_monvol,test_stopreason
        from db_ld9_testdata.tb_ld9testdatastop_${battGroupId}
        where test_record_count=#{testRecordCount} and test_monnum=#{testMonNum}
    </select>
    <select id="serchByCondition" resultType="com.whyc.pojo.Ld9testdatastop">
        select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_num,mon_vol,test_monnum,max_monvol,min_monvol,test_stopreason
        select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_cap,mon_rest_cap,mon_num,mon_vol,test_monnum,max_monvol,min_monvol,test_stopreason
        from db_ld9_testdata.tb_ld9testdatastop_${battGroupId}
        where test_record_count=#{testRecordCount}
    </select>