| | |
|---|
| | | return battgroupid;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | //根据机房id查询出申请人已审批通过的电池组信息
|
|---|
| | | public List serchById(Object obj){
|
|---|
| | | Battinf_apply bapply=(Battinf_apply) obj;
|
|---|
| | | BattInf binf=bapply.getBinf();
|
|---|
| | | String sql="select * from db_battinf.tb_battinf_apply where stationid=? and apply_uid=? ";
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {binf.getStationId(),bapply.getApply_uid()}, new CallBack() {
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | | try {
|
|---|
| | | while(rs.next()) {
|
|---|
| | | Battinf_apply apply=new Battinf_apply();
|
|---|
| | | apply.setNum(rs.getInt("num"));
|
|---|
| | | apply.setApply_uid(rs.getInt("apply_uid"));
|
|---|
| | | apply.setApply_name((new User_infImpl()).changeUidToUname(apply.getApply_uid()));
|
|---|
| | | apply.setConfrim_uid(rs.getInt("confrim_uid"));
|
|---|
| | | apply.setConfirm_name((new User_infImpl()).changeUidToUname(apply.getConfrim_uid()));
|
|---|
| | | apply.setApply_en(rs.getInt("apply_en"));
|
|---|
| | | apply.setCheck_uid(rs.getInt("check_uid"));
|
|---|
| | | apply.setCheck_en(rs.getInt("check_en"));
|
|---|
| | | apply.setCheck_uname((new User_infImpl()).changeUidToUname(apply.getCheck_en()));
|
|---|
| | | apply.setApply_date(rs.getTimestamp("apply_date"));
|
|---|
| | | apply.setApply_note(rs.getString("apply_note"));
|
|---|
| | | |
|---|
| | | BattInf binf=new BattInf();
|
|---|
| | | binf.setStationId(rs.getString("stationId"));
|
|---|
| | | binf.setStationName(rs.getString("stationName"));
|
|---|
| | | binf.setStationName1(rs.getString("stationName1"));
|
|---|
| | | binf.setStationName2(rs.getString("stationName2"));
|
|---|
| | | binf.setStationName3(rs.getString("stationName3"));
|
|---|
| | | binf.setStationName4(rs.getString("stationName4"));
|
|---|
| | | binf.setStationName5(rs.getString("stationName5"));
|
|---|
| | | binf.setStationIp(rs.getString("stationIp"));
|
|---|
| | | binf.setFBSDeviceId(rs.getInt("fBSDeviceId"));
|
|---|
| | | |
|---|
| | | binf.setFbsDeviceIp(rs.getString("fbsDeviceIp"));
|
|---|
| | | binf.setFbsDeviceIp_YM(rs.getString("fbsDeviceIp_YM"));
|
|---|
| | | binf.setFbsDeviceIp_WG(rs.getString("fbsDeviceIp_WG"));
|
|---|
| | | 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.setFloatVolLevel(rs.getFloat("floatVolLevel"));
|
|---|
| | | binf.setOfflineVolLevel(rs.getFloat("offlineVolLevel"));
|
|---|
| | | binf.setBattFloatCurrent(rs.getFloat("battFloatCurrent"));
|
|---|
| | | binf.setMonCount(rs.getInt("monCount"));
|
|---|
| | | binf.setMonCapStd(rs.getFloat("monCapStd"));
|
|---|
| | | binf.setMonVolStd(rs.getFloat("monVolStd"));
|
|---|
| | | binf.setMonResStd(rs.getFloat("monResStd"));
|
|---|
| | | binf.setMonSerStd(rs.getFloat("monSerStd"));
|
|---|
| | | binf.setMonVolLowToAvg(rs.getFloat("monVolLowToAvg"));
|
|---|
| | | binf.setBattProducer(rs.getString("battProducer"));
|
|---|
| | | binf.setBattModel(rs.getString("battModel"));
|
|---|
| | | binf.setBattProductDate(rs.getDate("battProductDate"));
|
|---|
| | | binf.setBattInUseDate(rs.getDate("battInUseDate"));
|
|---|
| | | binf.setLoad_curr(rs.getFloat("load_curr"));
|
|---|
| | | binf.setInstall_user(rs.getString("install_user"));
|
|---|
| | | binf.setDisCurrMax(rs.getFloat("disCurrMax"));
|
|---|
| | | binf.setStation_phone(rs.getString("station_phone"));
|
|---|
| | | |
|---|
| | | apply.setBinf(binf);
|
|---|
| | | list.add(apply);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | //查询出审核完的申请和待审核的申请
|
|---|
| | | public List serchByInfo(Object obj) {
|
|---|
| | | Battinf_apply bapply=(Battinf_apply) obj;
|
|---|
| | |
|---|
| | | Battinf_applyImpl bimpl=new Battinf_applyImpl();
|
|---|
| | | Battinf_apply bapply=new Battinf_apply();
|
|---|
| | | bapply.setApply_date(ActionUtil.getSimpDate(date2));
|
|---|
| | | bapply.setApply_uid(1002);
|
|---|
| | | bapply.setApply_uid(1004);
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | BattInf binf=new BattInf();
|
|---|
| | |
|---|
| | | binf.setStationName4("BTS设备");
|
|---|
| | | binf.setStationName5("沙洋县");
|
|---|
| | |
|
|---|
| | | binf.setStationId("4011100");
|
|---|
| | | binf.setStationId("42000626");
|
|---|
| | | binf.setStationIp("");
|
|---|
| | | binf.setFBSDeviceId(910001000);
|
|---|
| | | binf.setFbsDeviceIp("127.0.0.1");
|
|---|
| | |
|---|
| | | for (Fbs9100_state f : list) {
|
|---|
| | | System.out.println(f.getDev_id()+" "+f.getDev_commcount());
|
|---|
| | | }*/
|
|---|
| | | List list=bimpl.serchById(bapply);
|
|---|
| | | System.err.println(list.size());
|
|---|
| | | }
|
|---|
| | | }
|
|---|
