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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
package com.fgkj.mapper.impl.ram;
 
import com.fgkj.dto.BattInf;
import com.fgkj.dto.User_inf;
import com.fgkj.dto.ram.Fbs9600_state;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
public interface Fbs9600_stateMapper{
 
    @Insert("insert into db_ram_db.tb_Fbs9600_state(dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount," +
            "dev_errcommcount) values(#{dev_ip},#{dev_id},#{op_cmd},#{dev_workstate},#{dev_alarmstate},#{dev_commcount},#{dev_errcommcount})")
    public int add(Fbs9600_state state);
 
    //fbs显示屏启动放电
    // public boolean update(Object obj);
 
    //fbs9600设备内阻测试
    public int updatePro(List<Fbs9600_state> list);
 
    @Delete("delete from db_ram_db.tb_Fbs9600_state where num=#{num}")
    public int del(Fbs9600_state state);
 
    //FBS9600设备内阻测试显示全部9600设备的信息
    @Select("select  distinct tb_Fbs9600_state.num,dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount,dev_errcommcount, " +
            " db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName " +
            " from db_ram_db.tb_Fbs9600_state  " +
            " left outer join db_battinf.tb_battinf ON tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId  " +
            " where  tb_fbs9600_state.dev_id in(select distinct db_battinf.tb_battinf.FBSDeviceId " +
            " from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf   " +
            " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId   " +
            " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id  " +
            " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid  " +
            " and db_user.tb_user_inf.uid=#{uId} ) and tb_fbs9600_state.dev_id like '%9600%' or tb_fbs9600_state.dev_id like '%9616%' ")
    public List<Fbs9600_state> searchByUid(User_inf uinf);
 
    //11.1FBS9100设备通信状态查询
        /*
         * fbs9100：op_cmd:0:全部；1：fbs9100,2:fbs9600
         * dev_errcommcount;0:通讯正常，1：通讯中断，100：全部*/
    public List<Fbs9600_state> serchByCondition(Fbs9600_state state);
   
    //机房命令操作设备时的cmd和ack校验
//    public boolean sendCmdToFBS9600Dev(int cmd,int dev_id);
    
    //放电测试添加fbs9600设备的添加电池组的操作
    @Select("select db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,FbsDeviceName,db_battinf.tb_battinf.BattGroupName" +
            ",db_battinf.tb_battinf.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd" +
            ",db_ram_db.tb_fbs9600_state.dev_ip,db_ram_db.tb_fbs9600_state.dev_id,db_ram_db.tb_fbs9600_state.op_cmd" +
            ",db_ram_db.tb_fbs9600_state.dev_commcount,db_ram_db.tb_fbs9600_state.dev_errcommcount  " +
            " FROM db_battinf.tb_battinf " +
            " LEFT OUTER JOIN db_ram_db.tb_fbs9600_state  on db_ram_db.tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
            " where db_battinf.tb_battinf.StationName1 like concat('%',#{stationName1},'%') and db_battinf.tb_battinf.StationName LIKE concat('%',#{stationName},'%') " +
            " and db_battinf.tb_battinf.battgroupid=#{battGroupId} ")
    public List<Fbs9600_state> serchByInfo(BattInf binf);
 
    @Update( "UPDATE db_ram_db.tb_fbs9600_state  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_fbs9600_state "+
            " WHERE dev_id=#{dev_id}")
    int getOpCmdByDevId(int dev_id);
    
}