| | |
| | | /*Connection conn=DBUtil.getConn();
|
| | | String numberSql=" SELECT FOUND_ROWS() number";SQL_CALC_FOUND_ROWS*/
|
| | | String sql=" select distinct(StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
|
| | | + "FBSDeviceName,GroupIndexInFBSDevice,db_battinf.tb_battinf.battgroupId,BattGroupNum" +
|
| | | + "FBSDeviceName,GroupIndexInFBSDevice,db_battinf.tb_battinf.battgroupId,battGroupName" +
|
| | | ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax"
|
| | | + ",db_ram_db.tb_fbs9100_state.dev_version "
|
| | | + " from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state "
|
| | |
| | | binf.setFBSDeviceName(rs.getString("fBSDeviceName"));
|
| | | binf.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice"));
|
| | | binf.setBattGroupId(rs.getInt("battGroupId"));
|
| | | /*binf.setBattGroupNum(rs.getInt("battGroupNum"));
|
| | | binf.setBattGroupName(rs.getString("battGroupName"));
|
| | | /*binf.setBattGroupNum(rs.getInt("battGroupNum"));
|
| | | binf.setFloatVolLevel(rs.getFloat("floatVolLevel"));
|
| | | binf.setOfflineVolLevel(rs.getFloat("offlineVolLevel"));
|
| | | binf.setBattFloatCurrent(rs.getFloat("battFloatCurrent"));*/
|
| | |
| | | fs.getDCVolHighLimit(),fs.getChargeCurrSet(),fs.getMonomerTmp_High(),fs.getDev_id()});
|
| | | return bl;
|
| | | }
|
| | | //批量设置放电参数
|
| | | public boolean updatePro(Object obj) {
|
| | | Fbs9100_setparam fs=(Fbs9100_setparam) obj;
|
| | | String sql="update db_ram_db.tb_Fbs9100_setparam set testCmd=?,HourRate=?," +
|
| | | "DisCurr=?,DisCap=?,DisTime=?,groupVol_Low=?,monomerVol_Low=?,monomerLowCount=?,battGroupNum=?," +
|
| | | "onlineVolLowAction=?,dCVolHighLimit=?,chargeCurrSet=?,MonomerTmp_High=? where dev_id=?";
|
| | | Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{
|
| | | fs.getTestCmd(),fs.getHourRate(),fs.getDisCurr(),fs.getDisCap(),fs.getDisTime(),
|
| | | fs.getGroupVol_Low(),fs.getMonomerVol_Low(),fs.getMonomerLowCount(),fs.getBattGroupNum(),fs.getOnlineLowAction(),
|
| | | fs.getDCVolHighLimit(),fs.getChargeCurrSet(),fs.getMonomerTmp_High(),fs.getDev_id()});
|
| | | return bl;
|
| | | }
|
| | | //修改放电参数表中ld6
|
| | | public boolean updateld6Param(Object obj) {
|
| | | Fbs9100_setparam fs=(Fbs9100_setparam) obj;
|