批量设置放电参数的查询机房

81041

2018-12-26 6ca12d78daab3ad1dec7f5bd6e1f26b6b5fd2f11

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

@@ -4373,6 +4373,80 @@
      }

      return battgroupid;

   }

	
   //批量设置放电参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组

   public List serchByDischarge(Object obj) {

      BattInf binf=(BattInf) obj;

      Page page=binf.getPage();

      Connection conn=DBUtil.getConn();

      String numberSql=" SELECT FOUND_ROWS() number";

      String sql=" select SQL_CALC_FOUND_ROWS * from db_battinf.tb_battinf "

            + "  where StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "

            + "  and GroupIndexInFBSDevice=?   and MonVolStd=? "

            + "  order by StationId asc,GroupIndexInFBSDevice asc "

            + "  limit ?,? ";

      List<BattInf> list=DAOHelper.executeQueryLimit(sql, conn, new Object[] {"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationName5()+"%",binf.getGroupIndexInFBSDevice(),binf.getMonVolStd(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {

			
         @Override

         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

               while(rs.next()) {

                  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"));

                        binf.setStation_install(rs.getInt("station_install"));

                  list.add(binf);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

      //去掉limit条件后的总数

      int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);

      //System.out.println("number: "+number);

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

         list.get(list.size()-1).setNum(number);

      }

      return list;

   }



   public static void main(String[] args) throws ParseException {

      //new BattInfImpl().searchAll();

      

@@ -4382,11 +4456,14 @@
      binf.setBattGroupId(1000001);

      binf.setStationName("广西省-百色-GX百色乐业县立新小区WF-BTS设备");

      binf.setStationName1("");

      binf.setStationName2("");

      binf.setStationName2("百色");

      binf.setStationName3("");

      binf.setStationName5("");

      binf.setBattGroupName("");

      binf.setBattProducer("1");

      binf.setStationId("42000575");

      binf.setGroupIndexInFBSDevice(0);

      binf.setMonVolStd(2f);

      User_inf uinf=new User_inf();

      uinf.setUId(1002);

      

@@ -4423,8 +4500,13 @@
      System.out.println(list.size());*/

      /*int nums=biml.serchByInstall_count(uinf);

      System.out.println(nums);*/

      boolean bl=biml.judgeBattInOrNot(binf);

      System.out.println(bl);

      /*boolean bl=biml.judgeBattInOrNot(binf);

      System.out.println(bl);*/

      List<BattInf> list=biml.serchByDischarge(binf);

      for (BattInf b : list) {

         System.out.println(b);

      }

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

   }

   

    public List getResults(ResultSet rs) {