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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
| package com.fgkj.mapper.impl.ram;
|
| import com.fgkj.dto.ram.Fbs9100s_fod_param;
| import org.apache.ibatis.annotations.Select;
| import org.apache.ibatis.annotations.Update;
|
| public interface Fbs9100s_fod_paramMapper{
|
| //发送命令修改参数
| @Update(" replace into db_ram_db.tb_fbs9100s_fod_param"
| +"(dev_id,GroupNum,STDCap_one,FloatVol_one,Strength_one,YHStrength_one,TimeLong_one,STDCap_two,FloatVol_two,Strength_two,YHStrength_two,TimeLong_two,"
| + "STDCap_three,FloatVol_three,Strength_three,YHStrength_three,TimeLong_three,STDCap_four,FloatVol_four,Strength_four,YHStrength_four,TimeLong_four) "
| + " values(#{dev_id},#{groupNum},#{stdCap_one},#{floatVol_one},#{strength_one},#{yhstrength_one},#{timeLong_one},#{stdCap_two},"
| + "#{floatVol_two},#{strength_two},#{yhstrength_two},#{timeLong_two},#{stdCap_three},#{floatVol_three},#{strength_three},#{yhstrength_three},"
| +"#{timeLong_three},#{stdCap_four},#{floatVol_four},#{strength_four},#{yhstrength_four},#{timeLong_four})"
| )
| public int update(Fbs9100s_fod_param fod);
| //启动和停止命令
| @Update(" replace into db_ram_db.tb_fbs9100s_fod_param(dev_id,GroupNum) "
| + " values(#{dev_id},#{groupNum})")
| public boolean startOrStopTest(Fbs9100s_fod_param fod);
|
| //机房命令操作设备时的cmd和ack校验
| // public boolean sendCmdToFBS9100FOD(int cmd,int dev_id);
|
| //根据设备id查询参数
| @Select(" select distinct num,dev_id,GroupNum"
| + ",STDCap_one,FloatVol_one,Strength_one,YHStrength_one,TimeLong_one "
| + ",STDCap_two,FloatVol_two,Strength_two,YHStrength_two,TimeLong_two "
| + ",STDCap_three,FloatVol_three,Strength_three,YHStrength_three,TimeLong_three "
| + ",STDCap_four,FloatVol_four,Strength_four,YHStrength_four,TimeLong_four "
| + " from db_ram_db.tb_fbs9100s_fod_param where dev_id=#{dev_id} limit 1")
| public Fbs9100s_fod_param serchByCondition(Fbs9100s_fod_param fod);
|
| @Update( "UPDATE db_ram_db.tb_fbs9100s_fod_param SET "
| + " op_cmd=#{m_cmd} "
| + " WHERE dev_id=#{dev_id} ")
| int updateOpCmdByDevId(int m_cmd, int dev_id);
|
| @Select("SELECT op_cmd FROM db_ram_db.tb_fbs9100s_fod_param "+
| " WHERE dev_id=#{dev_id}")
| int getOpCmdByDevId(int dev_id);
| }
|
|
