update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
package com.fgkj.mapper.impl.Ld9;
 
import com.fgkj.dto.Ld9testdata_inf;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface Ld9testdata_infMapper{
 
    //历史数据查询
    @Select("select num,BattGroupId,test_record_count,test_record_count_ex,test_type,record_time_interval," +
            "record_num,test_starttime,test_starttime_ex,record_time,test_timelong,test_stoptype," +
            "test_stopreason,group_vol,test_curr,test_cap,mon_num,mon_vol,max_monvol,min_monvol " +
            "from db_ld9_testdata.tb_ld9testdata_inf where BattGroupId=#{battGroupId} " +
            "order by test_starttime desc ")
    public List<Ld9testdata_inf> serchByCondition(Ld9testdata_inf ld9_inf);
 
    //历史数据查询(根据电池组id查询所有的放电单体)
    @Select("select distinct BattGroupId,mon_num,count(test_record_count) as nums " +
            "from db_ld9_testdata.tb_ld9testdata_inf " +
            "where BattGroupId=#{battGroupId} " +
            "group BY mon_num " +
            "order by mon_num asc  ")
    public List<Ld9testdata_inf> serchByInfo(Ld9testdata_inf ld9_inf);
 
}