升级界面进入时查询正在升级的设备

81041

2018-11-15 426ae9a57c515b37b0996f62bdf10079110ce488

升级界面进入时查询正在升级的设备

 gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_dfu_stateAction.java

@@ -66,7 +66,12 @@
        result=tojson(model);

        return SUCCESS;

    }

	
    //升级界面实时刷新

    public String searchAll(){

        ServiceModel model=service.searchAll();

        result=tojson(model);

        return SUCCESS;

    }

    public String getResult() {

        return result;

    }


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

@@ -187,10 +187,36 @@
        // TODO Auto-generated method stub

        return false;

    }



    //查询出所有处于升级的设备

    public List searchAll() {

        // TODO Auto-generated method stub

        return null;

        String sql=" select * from  db_ram_db.tb_fbs9100s_dfu_state where dfu_en=1";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null , new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        Fbs9100s_dfu_state dfu=new Fbs9100s_dfu_state();

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

                        dfu.setSysVersion_new(rs.getInt("sysVersion_new"));

                        dfu.setSoftVersion_new(rs.getInt("softVersion_new"));

                        dfu.setSysVersion_dev(rs.getInt("sysVersion_dev"));

                        dfu.setSoftVersion_dev(rs.getInt("softVersion_dev"));

                        dfu.setDfu_file(rs.getString("dfu_file"));

                        dfu.setDfu_en(rs.getInt("dfu_en"));

                        dfu.setDfu_wr_stat(rs.getInt("dfu_wr_stat"));

                        dfu.setDfu_data_blocknum(rs.getInt("dfu_data_blocknum"));

                        dfu.setDfu_data_blocklen(rs.getInt("dfu_data_blocklen"));

                        list.add(dfu);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return list;

    }

    //升级界面实时刷新

    public List serchByCondition(Object obj) {

@@ -268,9 +294,13 @@
    /*

    boolean bl=fimpl.addPro(binf);

    System.out.println(bl);*/

    List<BattInf> listAll=fimpl.serchInserStation(binf);

    /*List<BattInf> listAll=fimpl.serchInserStation(binf);

    for (BattInf b : listAll) {

        System.out.println(b.getStationName3()+" "+b.getFBSDeviceId());

    }*/

    List<Fbs9100s_dfu_state> listAll=fimpl.searchAll();

    for (Fbs9100s_dfu_state dfu : listAll) {

        System.out.println(dfu);

    }

}

}


 gx_tieta/src/com/fgkj/services/ram/Fbs9100s_dfu_stateService.java

@@ -104,4 +104,17 @@
        }

        return model;

    }

    //查询出所有处于升级的设备

    public ServiceModel searchAll() {

        List list=dao.searchAll();

        if(list!=null&&list.size()>0){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功!");

        }else{

            model.setCode(0);

            model.setMsg("查询失败!");

        }

        return model;

    }

}