whycrzg
2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
package com.fgkj.mapper.impl.ram;
 
import com.fgkj.dto.ram.Fbs9100s_fod_state;
import org.apache.ibatis.annotations.Select;
 
public interface Fbs9100s_fod_stateMapper{
 
    //根据设备id查询状态
    @Select(" select distinct num,dev_id,record_time,"
            + "  RestTime_one,WorkState_one,VGroupVol_one,VpeakVol_one,"
            + "  RestTime_two,WorkState_two,VGroupVol_two,VpeakVol_two,"
            + "  RestTime_three,WorkState_three,VGroupVol_three,VpeakVol_three,"
            + "  RestTime_four,WorkState_four,VGroupVol_four,VpeakVol_four "
            + "  from db_ram_db.tb_fbs9100s_fod_state "
            + "  where dev_id=#{dev_id} limit 1")
    public Fbs9100s_fod_state serchByCondition(Fbs9100s_fod_state fod);
 
}