包头word导出

lxw

2023-09-05 1e375c38e6ea500e4001cfd438a17e36e968155e

包头word导出

 src/main/java/com/whyc/dto/paramter/TestDataInfDoc.java

@@ -15,6 +15,7 @@
    private float groupVol;
    private float testCurr;
    private float testCap;
    private int testTimelong;
    private List<BatttestdataId> datalist;

    public int getNum() {
@@ -81,6 +82,14 @@
        this.recordNum = recordNum;
    }

    public int getTestTimelong() {
        return testTimelong;
    }

    public void setTestTimelong(int testTimelong) {
        this.testTimelong = testTimelong;
    }

    public List<BatttestdataId> getDatalist() {
        return datalist;
    }

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

@@ -159,7 +159,7 @@
                mapRow.put("l1", "放电时间");
                for (int j = 0; j < lineCount; j++) {
                    TestDataInfDoc infDoc = list.get(j);
                    mapRow.put("l" + (j + 2), ActionUtil.sdfwithtime.format(infDoc.getRecordTime()));
                    mapRow.put("l" + (j + 2), ActionUtil.secToTime(infDoc.getTestTimelong()));
                }
            } else if (i == 1) {
                mapRow.put("l1", "总电压（V）");

 src/main/resources/mapper/BatttestdataMapper.xml

@@ -31,13 +31,15 @@
        <result property="battGroupId" column="BattGroupId"></result>
        <result property="testRecordCount" column="test_record_count"></result>
        <result property="recordNum" column="record_num"></result>
        <result property="testTimelong" column="test_timelong"></result>
        <collection property="datalist" javaType="java.util.ArrayList"
                    ofType="com.whyc.pojo.BatttestdataId"
                    column="{battGroupId=BattGroupId,testRecordCount=test_record_count,recordNum=record_num}"
                    select="selectBatttestdataId"></collection>
    </resultMap>
    <select id="searchWordExport" resultMap="infDoc">
        SELECT distinct BattGroupId, record_time, test_record_count, group_vol, test_curr, test_cap, record_num
        SELECT distinct BattGroupId, record_time, test_record_count, group_vol, test_curr, test_cap,
        record_num,test_timelong
        FROM db_batt_testdata.tb_batttestdata_#{battGroupId}
        WHERE test_record_count = #{testRecordCount}
        and record_num in