在线监测-实时监控-BTS停止

whyclxw

2022-01-04 94c97cfe487585986d9e71892b5dc0564a7c95e8

在线监测-实时监控-BTS停止

 src/main/java/com/whyc/controller/Fbs9100SetparamController.java

@@ -22,4 +22,10 @@
    private Response serchdevParam(@RequestParam int devId){
        return  service.serchdevParam(devId);
    }

    @ApiOperation("在线监测-实时监控-BTS停止")
    @GetMapping("serchbyDev_id")
    private Response serchbyDev_id(@RequestParam int num,@RequestParam int testCmd,@RequestParam int devId){
        return service.serchbyDev_id(num,testCmd,devId);
    }
}

 src/main/java/com/whyc/mapper/Fbs9100SetparamMapper.java

@@ -5,6 +5,7 @@
import java.util.List;

public interface Fbs9100SetparamMapper extends CustomMapper<Fbs9100Setparam>{
    //查询设备的参数
    List serchdevParam(int devId);

    //右键查看参数和弹出框的刷新按钮-----BTS停止
    Fbs9100Setparam serchbyDev_id(int devId);
}

 src/main/java/com/whyc/pojo/Fbs9100Setparam.java

@@ -176,5 +176,25 @@
    @TableField("FlowOver_CharTime_3")
    private Integer flowoverChartime3;

    @TableField(exist = false)
    private String stationName;
    @TableField(exist = false)
    private Integer fBSDeviceId;
    @TableField(exist = false)
    private String fbsDeviceIp;
    @TableField(exist = false)
    private Integer battGroupId;
    @TableField(exist = false)
    private String battGroupName;
    @TableField(exist = false)
    private Integer groupIndexInFBSDevice;
    @TableField(exist = false)
    private Float monVolStd;
    @TableField(exist = false)
    private Integer monCount;
    @TableField(exist = false)
    private Float monCapStd;
    @TableField(exist = false)
    private Float loadCurr;

}

 src/main/java/com/whyc/service/Fbs9100SetparamService.java

@@ -26,6 +26,15 @@
        PageInfo pageInfo=new PageInfo(list);
        return  new Response().set(1,pageInfo);
    }

    //右键查看参数和弹出框的刷新按钮-----BTS停止
    public Response serchbyDev_id(int num,int testCmd,int devId) {
        boolean bl=sendCmdToFBS9100Dev(num,testCmd,devId);
        Fbs9100Setparam setparam=mapper.serchbyDev_id(devId);
        return  new Response().setII(1,setparam,bl,bl==true?"查询成功!":"设置9100参数失败,请检查网络!");
    }


    //机房命令操作设备时的cmd和ack校验  test_type  -->默认启动测试的类型
    public boolean sendCmdToFBS9100Dev(int cmd,int test_type,int dev_id)
    {
@@ -85,4 +94,5 @@
        }
        return res_exe;
    }
}

}

 src/main/resources/mapper/Fbs9100SetparamMapper.xml

@@ -2,4 +2,17 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.Fbs9100SetparamMapper">

    <select id="serchbyDev_id" resultType="com.whyc.pojo.Fbs9100Setparam">
        select db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,db_battinf.tb_battinf.BattGroupName,db_battinf.tb_battinf.BattGroupId
                ,db_battinf.tb_battinf.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd,db_battinf.tb_battinf.load_curr 
                ,db_ram_db.tb_fbs9100_setparam.HourRate,db_ram_db.tb_fbs9100_setparam.DisCurr,db_ram_db.tb_fbs9100_setparam.DisCap
                ,db_ram_db.tb_fbs9100_setparam.DisTime,db_ram_db.tb_fbs9100_setparam.GroupVol_LOW,db_ram_db.tb_fbs9100_setparam.MonomerVol_LOW 
                ,db_ram_db.tb_fbs9100_setparam.MonomerLowCount,db_ram_db.tb_fbs9100_setparam.OnlineVolLowAction
                ,db_ram_db.tb_fbs9100_setparam.dCVolHighLimit,db_ram_db.tb_fbs9100_setparam.chargeCurrSet,db_ram_db.tb_fbs9100_setparam.battgroupnum 
                ,db_ram_db.tb_fbs9100_setparam.testcmd,db_ram_db.tb_fbs9100_setparam.testcmd,db_ram_db.tb_fbs9100_setparam.MonomerTmp_High 
                ,db_ram_db.tb_fbs9100_setparam.AutoTestStartVol,db_ram_db.tb_fbs9100_setparam.OnLineVol_Low,db_ram_db.tb_fbs9100_setparam.OffLineYH_Cycle,OffLineYHstarttime,OffLineYHTimes,OffLineYHOnceCycle   
                FROM db_battinf.tb_battinf 
                LEFT OUTER JOIN db_ram_db.tb_fbs9100_setparam on db_ram_db.tb_fbs9100_setparam.dev_id=db_battinf.tb_battinf.FBSDeviceId  
                WHERE db_battinf.tb_battinf.FBSDeviceId=#{devId} limit 1
    </select>
</mapper>