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
package com.fgkj.mapper.impl.Ld9;
 
import com.fgkj.dto.LD9_state;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface LD9_stateMapper{
 
    //查询所有LD9设备的实时数据
    @Select("select " +
            "num,dev_id,sys_state,sys_online_vol,sys_group_vol,sys_now_battnum,sys_now_battstate, " +
            "sys_now_battvol,sys_now_battcurr,sys_now_battcap,sys_now_testtime,dev_commcount,dev_errcommcount " +
            "from db_ram_db.tb_ld9_state " +
            "order by sys_now_battnum")
    public List<LD9_state> searchAll();
 
    //Ld9设备通信状态查询
    /*
     * Ld9:op_cmd:0:全部;1:fbs9100,2:fbs9600,3:ld9
     * dev_errcommcount;0:通讯正常,1:通讯中断,100:全部
     * */
    public List serchByCondition(LD9_state obj);
 
}