修改

81041

2018-12-12 10544dfdf4955a680994903edcd4204005fc2849

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

@@ -41,8 +41,8 @@
      if(list!=null && list.size()>0){

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

            Battinf_apply bapply=list.get(i);

            /*int uid=((User_inf)ActionUtil.getUser()).getUId();

             bapply.setApply_uid(uid);*/

            int uid=((User_inf)ActionUtil.getUser()).getUId();

             bapply.setApply_uid(uid);

            BattInf binf=bapply.getBinf();

            //验证新添加的机房是否存在

            List listS=(new BattInfImpl()).judgeBatt(binf);

@@ -67,11 +67,11 @@
            }

            maxb++;

            sql_str.add(sql);

            /*{

            {

               String msg=((User_inf)ActionUtil.getUser()).getUId()+"申请添加"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";

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

               listU.add(ulog);

             }*/

             }

         }

      }

      Boolean bl=false;

@@ -81,7 +81,7 @@
      }else{

         return false;

      }

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

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

      

      return bl;

   }

@@ -109,7 +109,7 @@
                  ",'"+binf.getBattProducer()+"','"+binf.getBattModel()+"','"+DAOHelper.sdf.format(binf.getBattProductDate())+"','"+DAOHelper.sdf.format(binf.getBattInUseDate())+"',"+binf.getLoad_curr()+",'"+binf.getInstall_user()+"',"+binf.getDisCurrMax()+",'"+binf.getStation_phone()+"',"+binf.getStation_install()+")";

             sql_str.add(sql_insert_binf);

             {

               String msg=((User_inf)ActionUtil.getUser()).getUId()+"确认添加"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";

               String msg="确认添加"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";

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

               listU.add(ulog);

             }

@@ -138,6 +138,173 @@
   }

   //查询出所有需要确认的申请

   public List serchByCondition(Object obj) {

      Page page=(Page) obj;

      Connection conn=DBUtil.getConn();

      String numberSql=" SELECT FOUND_ROWS() number";

      String sql=" select SQL_CALC_FOUND_ROWS distinct num,apply_uid,confrim_uid,apply_date,apply_en,apply_note,StationId,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FbsDeviceId,FbsDeviceIp_YM,FbsDeviceIp_WG,FbsDeviceIp"+

              ",FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +

             ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,install_user,DisCurrMax,station_phone " +

            " from db_battinf.tb_battinf_apply " +

            " where apply_en=0  order by apply_date desc" +

            " limit ?,? ";

      List<Battinf_apply> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {

			
         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.setConfrim_uid(rs.getInt("confrim_uid"));

                  apply.setApply_en(rs.getInt("apply_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;

         }

      });

      //去掉limit条件后的总数

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

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

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

         list.get(list.size()-1).setApply_note(String.valueOf(number));

      }

      return list;

   }

   //查询出当前存在内存中最大的设备的id(很重要**********)

   public int searchMaxdevId_apply(){

      String sql="select max(FbsDeviceId) as id  from db_battinf.tb_battinf_apply limit 1";

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

			
         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

               while(rs.next()){

                  int dev_id=0;

                  if(rs.getString("id")!=null){

                     dev_id=rs.getInt("id");

                  }

                  list.add(dev_id);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

      int dev_id=0;

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

         dev_id=(Integer) list.get(list.size()-1);

      }

      return dev_id;

   }

   //查询出当前存在内存中最大的stationid很重要**********)

   public int searchMaxId_apply(){

      String sql="select max(StationId) as id from db_battinf.tb_battinf_apply  limit 1";

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

			
         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

					
               while(rs.next()){

                  int id=0;

                  if(rs.getString("id") != null){

                     id=Integer.parseInt(rs.getString("id"));

                  }

                  list.add(id);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

      int stationid=0;

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

         stationid=(Integer) list.get(list.size()-1);

      }

      return stationid;

   }

   //查询出当前存在内存中最大的电池组的id(很重要**********)

   public int searchMaxBattgroupId_apply(){

      String sql=" select max(battgroupId) as id from db_battinf.tb_battinf_apply limit 1";

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

			
         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

               while(rs.next()){

                  int battgroupid=0;

                  if(rs.getString("id")!=null){

                     battgroupid=rs.getInt("id");

                  }

                  list.add(battgroupid);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

      int battgroupid=0;

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

         battgroupid=(Integer) list.get(list.size()-1);

      }

      return battgroupid;

   }

	
    //查询出审核完的申请和待审核的申请

   public List serchByInfo(Object obj) {

      Battinf_apply bapply=(Battinf_apply) obj;

      BattInf b=bapply.getBinf();

      Page page=b.getPage();

@@ -147,9 +314,9 @@
              ",FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +

             ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,install_user,DisCurrMax,station_phone " +

            " from db_battinf.tb_battinf_apply " +

            " where apply_en=0  and stationName1 like ? and stationName2 like ? and stationId like ? and stationName5 like ? " +

            " where apply_en=?  and apply_uid=? " +

            " limit ?,? ";

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

      List<Battinf_apply> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{bapply.getApply_en(),bapply.getNum(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {

         

         public List getResults(ResultSet rs) {

            List list=new ArrayList();

@@ -219,37 +386,6 @@
      }

      return list;

   }

   //查询出当前存在内存中最大的设备的id(很重要**********)

   public int searchMaxdevId_apply(){

      String sql="select max(FbsDeviceId) as id  from db_battinf.tb_battinf_apply limit 1";

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

			
         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

               while(rs.next()){

                  int dev_id=0;

                  if(rs.getString("id")!=null){}

                  dev_id=rs.getInt("id");

                  list.add(dev_id);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

      int dev_id=0;

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

         dev_id=(Integer) list.get(list.size()-1);

      }

      return dev_id;

   }

   public List serchByInfo(Object obj) {

      // TODO Auto-generated method stub

      return null;

   }

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

       SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

      Date date1 = sdf.parse("2000-01-01 00:00:00");

@@ -300,13 +436,17 @@
      page.setPageSize(10);

      binf.setPage(page);

      bapply.setBinf(binf);

      /*List list=bimpl.serchByCondition(bapply);

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

      List list=bimpl.serchByCondition(page);

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

      /*List list=new ArrayList();

      list.add(bapply);

      boolean bl=bimpl.add(list);

      System.err.println(bl);*/

      int dev_id=BattinfGroupFactory.searchmaxdev_id();

      /*int dev_id=BattinfGroupFactory.searchmaxdev_id();

      System.out.println(dev_id);

      int station_id=BattinfGroupFactory.searchStationId();

      System.out.println(station_id);

      int battgroup_id=BattinfGroupFactory.searchMaxBattgroupId();

      System.out.println(battgroup_id);*/

   }

}