update bean parameter

whycrzh

2021-01-25 963af0d0b768e737a06cfd409e56abc1a9690dd7

update bean parameter

 src/main/java/com/fgkj/mapper/impl/BattInfMapper.java

@@ -880,8 +880,8 @@
    public List searchBattByStationId(Object obj);

    //根据battgroupid查询机房id
    @Select("SELECT DISTINCT db_battinf.tb_battinf.FBSDeviceId  as dev_id from db_battinf.tb_battinf where battgroupid=#{BattGroupId}")
    public int serchDev_id(BattInf binf);
    @Select("SELECT DISTINCT db_battinf.tb_battinf.FBSDeviceId  as dev_id from db_battinf.tb_battinf where battgroupid=#{battGroupId}")
    public Integer serchDev_id(BattInf binf);

    //查询总的单体数（电池健康率）
    /*public int serchMonAll(){

 src/main/java/com/fgkj/mapper/impl/ram/Fbs9100_setparamMapper.java

@@ -16,7 +16,7 @@
    //修改放电参数表中
    @Update("update db_ram_db.tb_Fbs9100_setparam set testCmd=#{testCmd},HourRate=#{hourRate},DisCurr=#{disCurr}," +
            "DisCap=#{disCap},DisTime=#{disTime},groupVol_Low=#{groupVol_Low},monomerVol_Low=#{monomerVol_Low},monomerLowCount=#{monomerLowCount},battGroupNum=#{battGroupNum}," +
            "onlineVolLowAction=#{onlineVolLowAction},dCVolHighLimit=#{dCVolHighLimit},chargeCurrSet=#{chargeCurrSet},MonomerTmp_High=#{monomerTmp_High} where dev_id=#{dev_id}"
            "onlineVolLowAction=#{onlineLowAction},dCVolHighLimit=#{dCVolHighLimit},chargeCurrSet=#{chargeCurrSet},MonomerTmp_High=#{monomerTmp_High} where dev_id=#{dev_id}"
    )
    public int update(Fbs9100_setparam fsparam);

@@ -51,7 +51,7 @@
    public int judgeSatationInParam(int dev_id);
    
    //根据机房编号和维护区查询放电机房的信息和放电参数
    public List serchByCondition(Object obj);
    public List serchByCondition(BattInf obj);

   //根据设备id查询设备的放电参数
    @Select("select db_ram_db.tb_fbs9100_setparam.dev_id,db_ram_db.tb_fbs9100_setparam.HourRate,db_ram_db.tb_fbs9100_setparam.DisCurr,db_ram_db.tb_fbs9100_setparam.DisCap " +

 src/main/java/com/fgkj/services/ram/Fbs9100_setparamService.java

@@ -183,8 +183,10 @@
    //根据机房编号和维护区查询放电机房的信息和放电参数
    public ServiceModel serchByCondition(BattInf binf){
        ServiceModel model = new ServiceModel();

        int dev_id=battInfMapper.serchDev_id(binf);
        Integer dev_id=battInfMapper.serchDev_id(binf);
        if (null==dev_id){
            dev_id=-1;
        }
        boolean bl=sendCmdToFBS9100Dev(binf.getNum(),0, dev_id);

        List list=mapper.serchByCondition(binf);

 src/main/resources/mapper/ram/Fbs9100SetParamMapper.xml

@@ -191,13 +191,11 @@
        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
        LEFT OUTER JOIN db_ram_db.tb_fbs9100_state  on db_ram_db.tb_fbs9100_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} ;
        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} ;
    </select>
    <select id="sendCmdToFBS9100Dev" resultType="java.lang.Boolean"></select>
    <select id="serchByInfo" resultType="java.util.List">

    </select>
    <select id="serchbyDev_id" resultMap="BaseResultMap2">
        select
            db_battinf.tb_battinf.StationName,