修改后台内容

hdw

2018-11-28 954fc81fa128640249f8b4ba0c2cba6bd5ed4e87

修改后台内容

 gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_battparamImpl.java

@@ -49,7 +49,7 @@
    //根据设备id查询电池参数信息

    public List serchByCondition(Object obj) {

        Fbs9100_battparam bparam=(Fbs9100_battparam) obj;

        String sql=" select distinct num,dev_ip,dev_id,op_cmd,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType " +

        String sql=" select distinct dev_id, dev_ip,op_cmd,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType " +

                " ,db_battinf.tb_battinf.DeviceName,StationName,StationName1,StationName2,StationName3,StationName5,StationId " +

                " from db_ram_db.tb_fbs9100_battparam,db_battinf.tb_battinf  " +

                " where dev_id=? and db_ram_db.tb_fbs9100_battparam.dev_id=db_battinf.tb_battinf.fbsdeviceid" +

@@ -61,7 +61,6 @@
                try {

                    while(rs.next()){

                        Fbs9100_battparam b=new Fbs9100_battparam();

                        b.setNum(rs.getInt("num"));

                        b.setDev_ip(rs.getString("dev_ip"));

                        b.setDev_id(rs.getInt("dev_id"));

                        b.setOp_cmd(rs.getInt("op_cmd"));

@@ -106,7 +105,7 @@
        }

        String sql_end = "";

        boolean res_exe = false;

        String sql = "UPDATE db_ram_db.db_ram_db.tb_fbs9100_battparam  SET "

        String sql = "UPDATE db_ram_db.tb_fbs9100_battparam  SET "

                        + " op_cmd=? " + sql_end

                        + " WHERE dev_id=? ";

        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{m_cmd,dev_id});