A059的放电参数修改

lxw

2022-06-17 5bf54efd815653ef2c5edfb326739c266f34ea76

A059的放电参数修改

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

@@ -38,41 +38,51 @@
        return service.update(fbs9100Setparam);
    }

    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-61850放电参数设置",notes = "Fbs9100_setparamAction_action_update61850Param")
    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-61850放电参数设置", notes = "Fbs9100_setparamAction_action_update61850Param")
    @PostMapping("update61850Param")
    public Response update61850Param(@RequestBody Fbs9100Setparam fbs9100Setparam){
    public Response update61850Param(@RequestBody Fbs9100Setparam fbs9100Setparam) {
        return service.update61850Param(fbs9100Setparam);
    }

    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-A059发送指令",notes = "Fbs9100_setparamAction_action_updateA059Cmd")
    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-A059发送指令", notes = "Fbs9100_setparamAction_action_updateA059Cmd")
    @GetMapping("updateA059Cmd")
    public Response updateA059Cmd(@RequestParam int opCmd,@RequestParam int devId){
        return service.updateA059Cmd(opCmd,devId);
    public Response updateA059Cmd(@RequestParam int opCmd, @RequestParam int devId) {
        return service.updateA059Cmd(opCmd, devId);
    }
    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-读取FGCD_A059放电参数",notes = "Fbs9100_setparamAction_action_searchA059Param")

    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-读取FGCD_A059放电参数", notes = "Fbs9100_setparamAction_action_searchA059Param")
    @GetMapping("searchA059Param")
    public Response searchA059Param(@RequestParam int opCmd,@RequestParam int devId){
        return service.searchA059Param(opCmd,devId);
    public Response searchA059Param(@RequestParam int opCmd, @RequestParam int devId) {
        return service.searchA059Param(opCmd, devId);
    }
    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-设置FGCD_A059放电参数",notes = "Fbs9100_setparamAction_action_updateA059Param")

    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-设置FGCD_A059放电参数", notes = "Fbs9100_setparamAction_action_updateA059Param")
    @PostMapping("updateA059Param")
    public Response updateA059Param(@RequestBody Fbs9100Setparam a059setParam){
    public Response updateA059Param(@RequestBody Fbs9100Setparam a059setParam) {
        return service.updateA059Param(a059setParam);
    }
    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-一体机拓扑图界面添加一个温度报警的设置值",notes = "Fbs9100_setparamAction_action_serchCharHighTmp")

    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-设置FGCD_A059放电参数(二期)")
    @PostMapping("updateA059ParamPhaseII")
    public Response updateA059ParamPhaseII(@RequestBody Fbs9100Setparam a059setParam) {
        return service.updateA059ParamPhaseII(a059setParam);
    }

    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-一体机拓扑图界面添加一个温度报警的设置值", notes = "Fbs9100_setparamAction_action_serchCharHighTmp")
    @GetMapping("serchCharHighTmp")
    public Response serchCharHighTmp(@RequestParam int devId){
    public Response serchCharHighTmp(@RequestParam int devId) {
        return service.serchCharHighTmp(devId);
    }

    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-开始/停止显示FGCD_A059图片",notes = "Fbs9100_setparamAction_action_StartOrStopShowPic")
    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-开始/停止显示FGCD_A059图片", notes = "Fbs9100_setparamAction_action_StartOrStopShowPic")
    @GetMapping("StartOrStopShowPic")
    public Response StartOrStopShowPic(@RequestParam int devId,@RequestParam int opCmd){
        return service.StartOrStopShowPic(devId,opCmd);
    public Response StartOrStopShowPic(@RequestParam int devId, @RequestParam int opCmd) {
        return service.StartOrStopShowPic(devId, opCmd);
    }
    @ApiOperation(tags = "在线监测-实时监控",value = "在线监测-实时监控-设置FGCD_A059当前电池组",notes = "Fbs9100_setparamAction_action_SetNowBatt")

    @ApiOperation(tags = "在线监测-实时监控", value = "在线监测-实时监控-设置FGCD_A059当前电池组", notes = "Fbs9100_setparamAction_action_SetNowBatt")
    @GetMapping("SetNowBatt")
    public Response SetNowBatt(@RequestParam int devId,@RequestParam int opCmd,@RequestParam int battGroupNum){
        return service.SetNowBatt(devId,opCmd,battGroupNum);
    public Response SetNowBatt(@RequestParam int devId, @RequestParam int opCmd, @RequestParam int battGroupNum) {
        return service.SetNowBatt(devId, opCmd, battGroupNum);
    }
}

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

@@ -2,20 +2,26 @@

import com.whyc.pojo.Fbs9100Setparam;

import java.util.List;

public interface Fbs9100SetparamMapper extends CustomMapper<Fbs9100Setparam>{

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

    //离线养护功能
    Boolean updateMaintain(Fbs9100Setparam fbs9100Setparam);

    //在线监测-实时监控-BTS放电参数设置
    Boolean updateBtsParam(Fbs9100Setparam fbs9100Setparam);

    //在线监测-实时监控-61850放电参数设置
    Boolean update61850Param(Fbs9100Setparam fbs9100Setparam);

    //在线监测-实时监控-设置FGCD_A059放电参数
    Boolean updateA059Param(Fbs9100Setparam a059setParam);

    //在线监测-实时监控-设置FGCD_A059放电参数(二期)
    Boolean updateA059ParamPhaseII(Fbs9100Setparam a059setParam);

    //在线监测-实时监控-设置FGCD_A059当前电池组
    Boolean SetNowBatt(int devId, int battGroupNum);
}

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

@@ -180,6 +180,83 @@
    @TableField("ChargeVolt")
    private Float chargeVolt;

    //A059二期添加属性
    @ApiModelProperty(value = "保护电压1")
    @TableField("C_ProtectVol1")
    private Float cProtectvol1;
    @ApiModelProperty(value = "保护电压2")
    @TableField("C_ProtectVol2")
    private Float cProtectvol2;
    @ApiModelProperty(value = "保护电压3")
    @TableField("C_ProtectVol3")
    private Float cProtectvol3;
    @ApiModelProperty(value = "单体上限1")
    @TableField("C_mon_uppervol1")
    private Float cMonUppervol1;
    @ApiModelProperty(value = "单体上限2")
    @TableField("C_mon_uppervol2")
    private Float cMonUppervol2;
    @ApiModelProperty(value = "单体上限3")
    @TableField("C_mon_uppervol3")
    private Float cMonUppervol3;
    @ApiModelProperty(value = "上限个数1")
    @TableField("C_mon_uppernum1")
    private Integer cMonUppernum1;
    @ApiModelProperty(value = "上限个数2")
    @TableField("C_mon_uppernum2")
    private Integer cMonUppernum2;
    @ApiModelProperty(value = "上限个数3")
    @TableField("C_mon_uppernum3")
    private Integer cMonUppernum3;
    @ApiModelProperty(value = "恒压总阶段数[1~3]")
    @TableField("C_mon_uppernum")
    private Integer cMonUppernum;
    @ApiModelProperty(value = "恒压阶段1充电电压")
    @TableField("HV_charge_Vol1")
    private Float hvChargeVol1;
    @ApiModelProperty(value = "恒压阶段2充电电压")
    @TableField("HV_charge_Vol2")
    private Float hvChargeVol2;
    @ApiModelProperty(value = "恒压阶段3充电电压")
    @TableField("HV_charge_Vol3")
    private Float hvChargeVol3;
    @ApiModelProperty(value = "恒压阶段1充电时间")
    @TableField("HV_time1")
    private Integer hvTime1;
    @ApiModelProperty(value = "恒压阶段2充电时间")
    @TableField("HV_time2")
    private Integer hvTime2;
    @ApiModelProperty(value = "恒压阶段3充电时间")
    @TableField("HV_time3")
    private Integer hvTime3;
    @ApiModelProperty(value = "保护电流1")
    @TableField("HV_ProtectCurr1")
    private Float hvProtectcurr1;
    @ApiModelProperty(value = "保护电流2")
    @TableField("HV_ProtectCurr2")
    private Float hvProtectcurr2;
    @ApiModelProperty(value = "保护电流3")
    @TableField("HV_ProtectCurr3")
    private Float hvProtectcurr3;
    @ApiModelProperty(value = "单体上限1")
    @TableField("HV_mon_uppervol1")
    private Float hvMonUppervol1;
    @ApiModelProperty(value = "单体上限2")
    @TableField("HV_mon_uppervol2")
    private Float hvMonUppervol2;
    @ApiModelProperty(value = "单体上限3")
    @TableField("HV_mon_uppervol3")
    private Float hvMonUppervol3;
    @ApiModelProperty(value = "上限个数1")
    @TableField("HV_mon_uppernum1")
    private Integer hvMonUppernum1;
    @ApiModelProperty(value = "上限个数2")
    @TableField("HV_mon_uppernum2")
    private Integer hvMonUppernum2;
    @ApiModelProperty(value = "上限个数3")
    @TableField("HV_mon_uppernum3")
    private Integer hvMonUppernum3;

    @TableField(exist = false)
    private String stationName;
    @TableField(exist = false)

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

@@ -96,30 +96,42 @@

    //在线监测-实时监控-读取FGCD_A059放电参数
    public Response searchA059Param(int opCmd, int devId) {
        PageHelper.startPage(1,1);
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("dev_id",devId);
        Fbs9100Setparam a059param=mapper.selectOne(wrapper);
        boolean bl=sendCmdToFBS9100Dev(opCmd,0,devId);
        return new Response().setII(1,bl,a059param,bl==true?"读取参数成功!":"读取A059参数失败,请检查网络!");
        PageHelper.startPage(1, 1);
        QueryWrapper wrapper = new QueryWrapper();
        wrapper.eq("dev_id", devId);
        Fbs9100Setparam a059param = mapper.selectOne(wrapper);
        boolean bl = sendCmdToFBS9100Dev(opCmd, 0, devId);
        return new Response().setII(1, bl, a059param, bl == true ? "读取参数成功!" : "读取A059参数失败,请检查网络!");
    }

    //在线监测-实时监控-设置FGCD_A059放电参数
    public Response updateA059Param(Fbs9100Setparam a059setParam) {
        Boolean b=mapper.updateA059Param(a059setParam);
        boolean bl=false;
        if(b){
            bl=sendCmdToFBS9100Dev(a059setParam.getOpCmd().intValue(),0,a059setParam.getDevId().intValue());
        Boolean b = mapper.updateA059Param(a059setParam);
        boolean bl = false;
        if (b) {
            bl = sendCmdToFBS9100Dev(a059setParam.getOpCmd().intValue(), 0, a059setParam.getDevId().intValue());
        }
        return new Response().set(1,bl,bl==true?"修改参数成功!":"设置A059参数失败,请检查网络!");
        return new Response().set(1, bl, bl == true ? "修改参数成功!" : "设置A059参数失败,请检查网络!");
    }

    //在线监测-实时监控-设置FGCD_A059放电参数(二期)
    public Response updateA059ParamPhaseII(Fbs9100Setparam a059setParam) {
        Boolean b = mapper.updateA059ParamPhaseII(a059setParam);
        boolean bl = false;
        if (b) {
            bl = sendCmdToFBS9100Dev(a059setParam.getOpCmd().intValue(), 0, a059setParam.getDevId().intValue());
        }
        return new Response().set(1, bl, bl == true ? "修改参数成功!" : "设置A059二期参数失败,请检查网络!");
    }

    //一体机拓扑图界面添加一个温度报警的设置值
    @Transactional
    public Response serchCharHighTmp(int devId) {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("dev_id",devId);
        QueryWrapper wrapper = new QueryWrapper();
        wrapper.eq("dev_id", devId);
        wrapper.last(" limit 1");
        Fbs9100Setparam a059param=mapper.selectOne(wrapper);
        return new Response().setII(1,a059param==null?false:true,a059param,a059param==null?"查询失败":"查询成功");
        Fbs9100Setparam a059param = mapper.selectOne(wrapper);
        return new Response().setII(1, a059param == null ? false : true, a059param, a059param == null ? "查询失败" : "查询成功");
    }
    //在线监测-实时监控-开始/停止显示FGCD_A059图片
    public Response StartOrStopShowPic(int devId, int opCmd) {

 src/main/resources/mapper/Fbs9100SetparamMapper.xml

@@ -3,44 +3,207 @@
<mapper namespace="com.whyc.mapper.Fbs9100SetparamMapper">

    <update id="updateMaintain" parameterType="Fbs9100Setparam">
        replace into db_ram_db.tb_fbs9100_setparam(dev_id,MonomerTmp_High,OnLineVol_Low,OffLineYH_Cycle,OffLineYHstarttime,OffLineYHTimes,OffLineYHOnceCycle)
                values(#{devId},#{monomertmpHigh},#{onlinevolLow},#{offlineyhCycle},#{OffLineYHstarttime},#{OffLineYHTimes},#{OffLineYHOnceCycle})
        replace
        into db_ram_db.tb_fbs9100_setparam(dev_id,MonomerTmp_High,OnLineVol_Low,OffLineYH_Cycle,OffLineYHstarttime,OffLineYHTimes,OffLineYHOnceCycle)
                values(
        #{devId},
        #{monomertmpHigh},
        #{onlinevolLow},
        #{offlineyhCycle},
        #{OffLineYHstarttime},
        #{OffLineYHTimes},
        #{OffLineYHOnceCycle}
        )
    </update>
    <update id="updateBtsParam">
        update db_ram_db.tb_Fbs9100_setparam set testCmd=#{TestCmd},HourRate=#{HourRate},DisCurr=#{DisCurr},DisCap=#{DisCap},
                DisTime=#{DisTime},groupVol_Low=#{groupvolLow},monomerVol_Low=#{monomervolLow},monomerLowCount=#{MonomerLowCount},battGroupNum=#{BattGroupNum},
                onlineVolLowAction=#{OnlineVolLowAction},dCVolHighLimit=#{DCVolHighLimit},chargeCurrSet=#{ChargeCurrSet},MonomerTmp_High=#{monomertmpHigh},ChargeVolt=#{chargeVolt} where dev_id=#{devId}
    <update id="updateBtsParam">
        update db_ram_db.tb_Fbs9100_setparam
        set testCmd=#{TestCmd},
            HourRate=#{HourRate},
            DisCurr=#{DisCurr},
            DisCap=#{DisCap},
            DisTime=#{DisTime},
            groupVol_Low=#{groupvolLow},
            monomerVol_Low=#{monomervolLow},
            monomerLowCount=#{MonomerLowCount},
            battGroupNum=#{BattGroupNum},
            onlineVolLowAction=#{OnlineVolLowAction},
            dCVolHighLimit=#{DCVolHighLimit},
            chargeCurrSet=#{ChargeCurrSet},
            MonomerTmp_High=#{monomertmpHigh},
            ChargeVolt=#{chargeVolt}
        where dev_id = #{devId}
    </update>
    <update id="update61850Param">
        update db_ram_db.tb_Fbs9100_setparam set testCmd=#{TestCmd},
               DisCurr=#{DisCurr},DisCap=#{DisCap},DisTime=#{DisTime},MonomerTmp_High=#{monomertmpHigh},groupVol_Low=#{groupvolLow}
              ,monomerVol_Low=#{monomervolLow},DCVolHighLimit=#{DCVolHighLimit},ChargeCurrSet=#{ChargeCurrSet}
               where dev_id=#{devId}
        update db_ram_db.tb_Fbs9100_setparam
        set testCmd=#{TestCmd},
            DisCurr=#{DisCurr},
            DisCap=#{DisCap},
            DisTime=#{DisTime},
            MonomerTmp_High=#{monomertmpHigh},
            groupVol_Low=#{groupvolLow}
                ,
            monomerVol_Low=#{monomervolLow},
            DCVolHighLimit=#{DCVolHighLimit},
            ChargeCurrSet=#{ChargeCurrSet}
        where dev_id = #{devId}
    </update>
    <update id="updateA059Param">
        UPDATE db_ram_db.tb_fbs9100_setparam SET  dev_ip=#{devIp}, op_cmd=#{opCmd}, TestCmd=#{TestCmd}, HourRate=#{HourRate}, DisCurr=#{DisCurr},
            DisCap=#{DisCap}, DisTime=#{DisTime}, GroupVol_LOW=#{groupvolLow}, MonomerVol_LOW=#{monomervolLow}, MonomerLowCount=#{MonomerLowCount}, BattGroupNum=#{BattGroupNum}, OnlineVolLowAction=#{OnlineVolLowAction},
            DCVolHighLimit=#{DCVolHighLimit}, ChargeCurrSet=#{ChargeCurrSet}, MonomerTmp_High=#{monomertmpHigh}, AutoTestStartVol=#{AutoTestStartVol}, OnLineVol_Low=#{onlinevolLow}, OffLineYH_Cycle=#{offlineyhCycle},
            OffLineYHstarttime=#{OffLineYHstarttime}, OffLineYHTimes=#{OffLineYHTimes}, OffLineYHOnceCycle=#{OffLineYHOnceCycle}, MonCount=#{MonCount}, MonVol=#{MonVol}, DisPower=#{DisPower}, DisPreRes=#{DisPreRes},
            CharCap=#{CharCap}, CharTimeLong=#{CharTimeLong}, FloatCharTimeLong=#{FloatCharTimeLong}, CharSotpCurr=#{CharSotpCurr}, MonVolHightLimit=#{MonVolHightLimit}, MonVolHightLimitCount=#{MonVolHightLimitCount},
            CharHighTmp=#{CharHighTmp}, DisWaitTime=#{DisWaitTime}, CharWaitTime=#{CharWaitTime} , FlowOver_Count = #{flowoverCount},  FlowOver_CharCurr_1 = #{flowoverCharcurr1},  FlowOver_CharCurr_2 =#{flowoverCharcurr2},  FlowOver_CharCurr_3 =#{flowoverCharcurr3},
            FlowOver_CharTime_1 =#{flowoverChartime1},  FlowOver_CharTime_2 =#{flowoverChartime2},  FlowOver_CharTime_3 =#{flowoverChartime3} WHERE dev_id = #{devId}
        UPDATE db_ram_db.tb_fbs9100_setparam
        SET dev_ip=#{devIp},
            op_cmd=#{opCmd},
            TestCmd=#{TestCmd},
            HourRate=#{HourRate},
            DisCurr=#{DisCurr},
            DisCap=#{DisCap},
            DisTime=#{DisTime},
            GroupVol_LOW=#{groupvolLow},
            MonomerVol_LOW=#{monomervolLow},
            MonomerLowCount=#{MonomerLowCount},
            BattGroupNum=#{BattGroupNum},
            OnlineVolLowAction=#{OnlineVolLowAction},
            DCVolHighLimit=#{DCVolHighLimit},
            ChargeCurrSet=#{ChargeCurrSet},
            MonomerTmp_High=#{monomertmpHigh},
            AutoTestStartVol=#{AutoTestStartVol},
            OnLineVol_Low=#{onlinevolLow},
            OffLineYH_Cycle=#{offlineyhCycle},
            OffLineYHstarttime=#{OffLineYHstarttime},
            OffLineYHTimes=#{OffLineYHTimes},
            OffLineYHOnceCycle=#{OffLineYHOnceCycle},
            MonCount=#{MonCount},
            MonVol=#{MonVol},
            DisPower=#{DisPower},
            DisPreRes=#{DisPreRes},
            CharCap=#{CharCap},
            CharTimeLong=#{CharTimeLong},
            FloatCharTimeLong=#{FloatCharTimeLong},
            CharSotpCurr=#{CharSotpCurr},
            MonVolHightLimit=#{MonVolHightLimit},
            MonVolHightLimitCount=#{MonVolHightLimitCount},
            CharHighTmp=#{CharHighTmp},
            DisWaitTime=#{DisWaitTime},
            CharWaitTime=#{CharWaitTime},
            FlowOver_Count = #{flowoverCount},
            FlowOver_CharCurr_1 = #{flowoverCharcurr1},
            FlowOver_CharCurr_2 =#{flowoverCharcurr2},
            FlowOver_CharCurr_3 =#{flowoverCharcurr3},
            FlowOver_CharTime_1 =#{flowoverChartime1},
            FlowOver_CharTime_2 =#{flowoverChartime2},
            FlowOver_CharTime_3 =#{flowoverChartime3}
        WHERE dev_id = #{devId}
    </update>
    <update id="SetNowBatt">
        update db_ram_db.tb_Fbs9100_setparam set BattGroupNum=#{battGroupNum} where dev_id=#{devId}
    <update id="SetNowBatt">
        update db_ram_db.tb_Fbs9100_setparam
        set BattGroupNum=#{battGroupNum}
        where dev_id = #{devId}
    </update>
    <update id="updateA059ParamPhaseII">
        UPDATE db_ram_db.tb_fbs9100_setparam
        SET dev_ip=#{devIp},
            op_cmd=#{opCmd},
            TestCmd=#{TestCmd},
            HourRate=#{HourRate},
            DisCurr=#{DisCurr},
            DisCap=#{DisCap},
            DisTime=#{DisTime},
            GroupVol_LOW=#{groupvolLow},
            MonomerVol_LOW=#{monomervolLow},
            MonomerLowCount=#{MonomerLowCount},
            BattGroupNum=#{BattGroupNum},
            OnlineVolLowAction=#{OnlineVolLowAction},
            DCVolHighLimit=#{DCVolHighLimit},
            ChargeCurrSet=#{ChargeCurrSet},
            MonomerTmp_High=#{monomertmpHigh},
            AutoTestStartVol=#{AutoTestStartVol},
            OnLineVol_Low=#{onlinevolLow},
            OffLineYH_Cycle=#{offlineyhCycle},
            OffLineYHstarttime=#{OffLineYHstarttime},
            OffLineYHTimes=#{OffLineYHTimes},
            OffLineYHOnceCycle=#{OffLineYHOnceCycle},
            MonCount=#{MonCount},
            MonVol=#{MonVol},
            DisPower=#{DisPower},
            DisPreRes=#{DisPreRes},
            CharCap=#{CharCap},
            CharTimeLong=#{CharTimeLong},
            FloatCharTimeLong=#{FloatCharTimeLong},
            CharSotpCurr=#{CharSotpCurr},
            MonVolHightLimit=#{MonVolHightLimit},
            MonVolHightLimitCount=#{MonVolHightLimitCount},
            CharHighTmp=#{CharHighTmp},
            DisWaitTime=#{DisWaitTime},
            CharWaitTime=#{CharWaitTime},
            FlowOver_Count = #{flowoverCount},
            FlowOver_CharCurr_1 = #{flowoverCharcurr1},
            FlowOver_CharCurr_2 =#{flowoverCharcurr2},
            FlowOver_CharCurr_3 =#{flowoverCharcurr3},
            FlowOver_CharTime_1 =#{flowoverChartime1},
            FlowOver_CharTime_2 =#{flowoverChartime2},
            FlowOver_CharTime_3 =#{flowoverChartime3},
            C_ProtectVol1 = #{cProtectvol1},
            C_ProtectVol2 = #{cProtectvol2},
            C_ProtectVol3 = #{cProtectvol3},
            C_mon_uppervol1 = #{cMonUppervol1},
            C_mon_uppervol2 = #{cMonUppervol2},
            C_mon_uppervol3 = #{cMonUppervol3},
            C_mon_uppernum1 = #{cMonUppernum1},
            C_mon_uppernum2 = #{cMonUppernum2},
            C_mon_uppernum3 = #{cMonUppernum3},
            C_mon_uppernum = #{cMonUppernum},
            HV_charge_Vol1 = #{hvChargeVol1},
            HV_charge_Vol2 = #{hvChargeVol2},
            HV_charge_Vol3 = #{hvChargeVol3},
            HV_time1 = #{hvTime1},
            HV_time2 = #{hvTime2},
            HV_time3 = #{hvTime3},
            HV_ProtectCurr1 = #{hvProtectcurr1},
            HV_ProtectCurr2 = #{hvProtectcurr2},
            HV_ProtectCurr3 = #{hvProtectcurr3},
            HV_mon_uppervol1 = #{hvMonUppervol1},
            HV_mon_uppervol2 = #{hvMonUppervol2},
            HV_mon_uppervol3 = #{hvMonUppervol3},
            HV_mon_uppernum1 = #{hvMonUppernum1},
            HV_mon_uppernum2 = #{hvMonUppernum2},
            HV_mon_uppernum3 = #{hvMonUppernum3}
        WHERE dev_id = #{devId}
    </update>

    <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,db_ram_db.tb_fbs9100_setparam.BattGroupNum,db_ram_db.tb_fbs9100_setparam.ChargeVolt as chargeVolt
                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>
    <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
             , db_ram_db.tb_fbs9100_setparam.BattGroupNum
             , db_ram_db.tb_fbs9100_setparam.ChargeVolt as chargeVolt
        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>