update DLG_Progress、Ld9testdata、Ld9testdata_inf、Ld9testdatastop and related...

whycrzh

2021-01-26 2da88e0ad99dce340f0d25bff5b50fa629bcce15

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
package com.fgkj.mapper.impl.Ld9;
 
import com.fgkj.dto.Ld9testdata;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface Ld9testdataMapper{
 
    //历史监测
    @Select("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 " +
            "  from db_ld9_testdata.tb_ld9testdata_#{battGroupId} " +
            " where test_record_count=#{test_record_count}  and (record_num%#{num}=0 ) and test_monnum=#{test_monnum} ")
    public List<Ld9testdata> serchByCondition(Ld9testdata ld9);
 
    //查询某次测试下电池组节数放电情况
    @Select("select test_monnum,max(record_num) as record_num,BattGroupId,test_record_count " +
            "from db_ld9_testdata.tb_ld9testdata_#{battGroupId} " +
            "where test_record_count=#{test_record_count} GROUP BY test_monnum  order by test_monnum asc")
    public List<Ld9testdata> serchByInfo(Ld9testdata ld9);
 
}