申请验收前的查询

81041

2018-12-21 6d492bc6298a71f58fb046ff5c332fbd88aae620

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

@@ -160,7 +160,7 @@
      return bl;

      

   }

   //验收申请(多条)

   //验收(多条)

   public boolean check(Object obj) {

      List<Battinf_apply> list=(List<Battinf_apply>) obj;

      List<User_log> listU=new ArrayList<User_log>();//存放user_log

@@ -174,6 +174,28 @@
             sql_str.add(sql_update_apply);

             {

               String msg="验收"+binf.getStationName()+"机房";

               User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg);

               listU.add(ulog);

             }

         }

      }

      Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);

      (new User_logService()).addPro(listU);//将用户的操作记录下来

      return bl;

   }

   //申请验收(多条)

   public boolean checkPro(Object obj) {

      List<Battinf_apply> list=(List<Battinf_apply>) obj;

      List<User_log> listU=new ArrayList<User_log>();//存放user_log

      ArrayList<String> sql_str=new ArrayList();

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

         for (int i = 0; i < list.size(); i++) {

            Battinf_apply bapply=list.get(i);

            BattInf binf=bapply.getBinf();

            String sql_update_apply=" update db_battinf.tb_battinf_apply set check_en=2 where battgroupid="+binf.getBattGroupId();

             sql_str.add(sql_update_apply);

             {

               String msg="申请验收"+binf.getStationName()+"机房";

               User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg);

               listU.add(ulog);

             }

@@ -423,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;

@@ -647,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();

@@ -658,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");

@@ -710,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());

   }

}