| | |
| | | //修改放电参数表中 |
| | | public boolean update(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=?"; |
| | | String sql="update db_ram_db.tb_Fbs9100_setparam set testCmd=?,battGroupNum=? " + |
| | | "chargeCurrSet=?,DCVolHighLimit=?,HourRate=?,DisCurr=?,GroupVol_LOW=?,DisTime=? 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()}); |
| | | fs.getTestCmd(),fs.getBattGroupNum(),fs.getChargeCurrSet(),fs.getDCVolHighLimit(), |
| | | fs.getHourRate(),fs.getDisCurr(),fs.getGroupVol_Low(), |
| | | fs.getDisTime(),fs.getDev_id()}); |
| | | return bl; |
| | | } |
| | | //批量设置放电参数 |
| | |
| | | Fbs9100_setparam fsparam=(Fbs9100_setparam) obj; |
| | | String sql=" 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.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd,db_battinf.tb_battinf.charge_curr_max" + |
| | | ",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.HourRate,db_ram_db.tb_fbs9100_setparam.DisCurr " + |
| | | ",db_ram_db.tb_fbs9100_setparam.DisTime,db_ram_db.tb_fbs9100_setparam.GroupVol_LOW " + |
| | | ",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.dCVolHighLimit " + |
| | | " 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=? limit 1"; |
| | |
| | | Fbs9100_setparam fsparam=new Fbs9100_setparam(); |
| | | fsparam.setHourRate(rs.getInt("hourRate")); |
| | | fsparam.setDisCurr(rs.getFloat("disCurr")); |
| | | fsparam.setDisCap(rs.getFloat("disCap")); |
| | | fsparam.setDisTime(rs.getInt("disTime")); |
| | | fsparam.setGroupVol_Low(rs.getFloat("groupVol_Low")); |
| | | fsparam.setMonomerVol_Low(rs.getFloat("monomerVol_Low")); |
| | | fsparam.setMonomerLowCount(rs.getInt("monomerLowCount")); |
| | | fsparam.setOnlineLowAction(rs.getInt("onlineVolLowAction")); |
| | | fsparam.setDCVolHighLimit(rs.getFloat("dCVolHighLimit")); |
| | | fsparam.setChargeCurrSet(rs.getFloat("chargeCurrSet")); |
| | | fsparam.setBattGroupNum(rs.getInt("battGroupNum")); |
| | | fsparam.setTestCmd(rs.getInt("testCmd")); |
| | | fsparam.setMonomerTmp_High(rs.getFloat("monomerTmp_High")); |
| | | fsparam.setAutoTestStartVol(rs.getFloat("autoTestStartVol")); |
| | | fbs9100.setFsparam(fsparam); |
| | | |
| | | list.add(fbs9100); |