| | |
|---|
| | | if(list!=null&&list.size()>0){
|
|---|
| | | for (int i = 0; i < list.size(); i++) {
|
|---|
| | | Fbs9100_sysparam fs=list.get(i);
|
|---|
| | | String sql="REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime"
|
|---|
| | | String sql="REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime"
|
|---|
| | | + ",MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart) "
|
|---|
| | | + " values("+fs.getDev_id()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime()
|
|---|
| | | + " values("+fs.getDev_id()+","+fs.getOp_cmd()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime()
|
|---|
| | | +",'"+fs.getMACADDR()+"',"+fs.getLoaderCount()+","+fs.getDtCardCount()+","+fs.getPowerBreakChargeCurr()+","+fs.getMajorBattGroupNum()+","+fs.getPOF_BG_Boost_Cnt()+","+fs.getPOF_BG_Boost_VolStop()+","+fs.getPOF_BG_Boost_VolStart()+")";
|
|---|
| | | sql_str.add(sql);
|
|---|
| | | {
|
|---|
| | |
|---|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id()});
|
|---|
| | | return bl;
|
|---|
| | | }
|
|---|
| | | //查询系统参数前(如果没有默认数据要用REPLACE 添加一笔数据)同时发送命令
|
|---|
| | | public boolean replacePL(Object obj){
|
|---|
| | | Fbs9100_sysparam sys=(Fbs9100_sysparam) obj;
|
|---|
| | | String sql=" REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) values(?,?)";
|
|---|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id(),sys.getOp_cmd()});
|
|---|
| | | return bl;
|
|---|
| | | }
|
|---|
| | | public boolean del(Object obj) {
|
|---|
| | | // TODO Auto-generated method stub
|
|---|
| | | return false;
|
|---|
