给已审批的设备查询出连接数

81041

2018-12-19 fa91c2f8661fffdeddb5cd447a783f00b0dbd2ae

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

@@ -22,6 +22,8 @@
import com.fgkj.dto.Page;

import com.fgkj.dto.User_inf;

import com.fgkj.dto.User_log;

import com.fgkj.dto.ram.FBS9100;

import com.fgkj.dto.ram.Fbs9100_state;

import com.fgkj.services.User_logService;



public class Battinf_applyImpl implements BaseDAO,CallBack{

@@ -129,7 +131,7 @@
      if(list!=null&&list.size()>0){

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

            Battinf_apply bapply=list.get(i);

            bapply.setConfrim_uid(((User_inf)ActionUtil.getUser()).getUId());

            bapply.setApply_uid(((User_inf)ActionUtil.getUser()).getUId());

            BattInf binf=bapply.getBinf();

            //System.out.println(binf);

            /* String sql_update_apply= "update db_battinf.tb_battinf_apply set StationName='"+binf.getStationName()+"',StationName1='"+binf.getStationName1()+"',StationName2='"+binf.getStationName2()+"',StationName3='"+binf.getStationName3()+"',StationName4='"+binf.getStationName4()+"',StationName5='"+binf.getStationName5()+"',StationIp='"+binf.getStationIp()+"',"

@@ -138,11 +140,11 @@
                   +" Load_curr="+binf.getLoad_curr()+",install_user='"+binf.getInstall_user()+"',DisCurrMax="+binf.getDisCurrMax()+",station_phone='"+binf.getStation_phone()+"'  where num="+bapply.getNum();

             */

            String sql_update_apply = "replace into db_battinf.tb_battinf_apply(" +

                  ",StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,"

                  "apply_uid,apply_date,StationId,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp,FbsDeviceIp_YM,FbsDeviceIp_WG,"

                  + "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" +

                  ") values('"+binf.getStationName()+"','"+binf.getStationName1()+"','"+binf.getStationName2()+"','"+binf.getStationName3()+"','"+binf.getStationName4()+"','"+binf.getStationName5()+

                  "','"+binf.getStationIp()+"','"+binf.getFBSDeviceName()+"',"+binf.getGroupIndexInFBSDevice()+

                  ") values("+bapply.getApply_uid()+",'"+DAOHelper.sdf.format(bapply.getApply_date())+"','"+binf.getStationId()+"','"+binf.getStationName()+"','"+binf.getStationName1()+"','"+binf.getStationName2()+"','"+binf.getStationName3()+"','"+binf.getStationName4()+"','"+binf.getStationName5()+

                  "','"+binf.getStationIp()+"',"+binf.getFBSDeviceId()+",'"+binf.getFbsDeviceIp()+"','"+binf.getFbsDeviceIp_YM()+"','"+binf.getFbsDeviceIp_WG()+"','"+binf.getFBSDeviceName()+"',"+binf.getGroupIndexInFBSDevice()+

                  ","+binf.getBattGroupId()+","+binf.getBattGroupNum()+",'"+binf.getBattGroupName()+"',"+binf.getFloatVolLevel()+","+binf.getOfflineVolLevel()+","+binf.getBattFloatCurrent()+

                  ","+binf.getMonCount()+","+binf.getMonCapStd()+","+binf.getMonVolStd()+","+binf.getMonResStd()+","+binf.getMonSerStd()+","+binf.getMonVolLowToAvg()+

                  ",'"+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()+"')";

@@ -542,7 +544,34 @@
         return false;

      }

   }



    //申请表中已审批通过的设备连接数

   public List devCommNum() {

      String sql=" select  distinct db_battinf.tb_battinf_apply.FbsDeviceId,dev_commcount " +

            " from db_battinf.tb_battinf_apply,db_ram_db.tb_fbs9100_state " +

            " where apply_en=1  and db_battinf.tb_battinf_apply.FbsDeviceId=db_ram_db.tb_fbs9100_state.dev_id "

         +   " order by apply_date desc" ;

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

			
         @Override

         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

               while(rs.next()) {

                  Fbs9100_state fbs=new Fbs9100_state();

                  fbs.setDev_id(rs.getInt("FbsDeviceId"));

                  fbs.setDev_commcount(rs.getInt("dev_commcount"));

                  list.add(fbs);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

      return list;

		
   }

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

@@ -607,7 +636,11 @@
      System.out.println(station_id);

      int battgroup_id=BattinfGroupFactory.searchMaxBattgroupId();

      System.out.println(battgroup_id);*/

      boolean bl=bimpl.judgeBattInOrNot(binf);

      System.out.println(bl);

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

      System.out.println(bl);*/

      /*List<Fbs9100_state> list=bimpl.devCommNum();

      for (Fbs9100_state f : list) {

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

      }*/

   }

}