申请验收前的查询

81041

2018-12-21 6d492bc6298a71f58fb046ff5c332fbd88aae620

申请验收前的查询

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/Battinf_applyAction.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$5.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$6.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$7.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$8.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/Battinf_applyService.class

Binary files differ

 gx_tieta/src/com/fgkj/actions/Battinf_applyAction.java

@@ -97,6 +97,15 @@
        result=tojson(model);

        return SUCCESS;

    }

    //根据机房id查询出申请人已审批通过的电池组信息

    public String serchById(){

        Battinf_apply bapply=ActionUtil.getGson().fromJson(json, Battinf_apply.class);

        User_inf uinf=(User_inf) getUser();

        bapply.setApply_uid(uinf.getUId());

        ServiceModel model=service.serchById(bapply);

        result=tojson(model);

        return SUCCESS;

    }

    

    public String getResult() {

        return result;


 gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java

@@ -445,6 +445,81 @@
        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;

@@ -669,7 +744,7 @@
        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();

@@ -680,7 +755,7 @@
        binf.setStationName4("BTS设备");

        binf.setStationName5("沙洋县");

        

        binf.setStationId("4011100");

        binf.setStationId("42000626");

        binf.setStationIp("");

        binf.setFBSDeviceId(910001000);

        binf.setFbsDeviceIp("127.0.0.1");

@@ -732,5 +807,7 @@
        for (Fbs9100_state f : list) {

            System.out.println(f.getDev_id()+"   "+f.getDev_commcount());

        }*/

        List list=bimpl.serchById(bapply);

        System.err.println(list.size());

    }

}


 gx_tieta/src/com/fgkj/services/Battinf_applyService.java

@@ -152,4 +152,18 @@
        }

        return model;

    }

    
    //根据机房id查询出申请人已审批通过的电池组信息

    public ServiceModel serchById(Object obj) {

        List list=((Battinf_applyImpl)dao).serchById(obj);

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

            model.setCode(1);

            model.setData(list);

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

        }else{

            model.setCode(0);

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

        }

        return model;

    }

}