申请添加修改

81041

2018-12-26 e3e09bc29f2ddc1600e27a8d0ec12981215e68b2

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

@@ -11,6 +11,7 @@


import com.fgkj.actions.ActionUtil;

import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BattTestData;

import com.fgkj.dao.BattinfGroupFactory;

import com.fgkj.dao.CallBack;

import com.fgkj.dao.DAOHelper;

@@ -22,6 +23,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{

@@ -30,7 +33,7 @@
      // TODO Auto-generated method stub

      return null;

   }

    //添加申请

    //添加申请(新建)

   public boolean add(Object obj) {

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

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

@@ -41,8 +44,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,22 +70,49 @@
            }

            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;

      boolean en=BattinfGroupFactory.backup_battinf();

      if(en){

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

      }else{

         return false;

      }

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

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

      

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

		
      return bl;

   }

   //添加申请(修改旧的)

   public boolean addPro(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);

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

             bapply.setApply_uid(uid);

            BattInf binf=bapply.getBinf();

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

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

            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=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);

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

      return bl;

   }

    //确认申请(多条)

@@ -96,9 +126,9 @@
            bapply.setConfrim_uid(((User_inf)ActionUtil.getUser()).getUId());

            BattInf binf=bapply.getBinf();

            binf.setStation_install(1);

            String sql_update_apply=" update db_battinf.tb_battinf_apply set confrim_uid="+bapply.getConfrim_uid()+",apply_en=1 where num="+bapply.getNum();

            String sql_update_apply=" update db_battinf.tb_battinf_apply set confrim_uid="+bapply.getConfrim_uid()+",apply_en=1 where battgroupid="+binf.getBattGroupId();

             sql_str.add(sql_update_apply);

             String sql_insert_binf="insert into db_battinf.tb_battinf(" +

             String sql_insert_binf="replace into db_battinf.tb_battinf(" +

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

@@ -108,6 +138,9 @@
                  ","+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()+"',"+binf.getStation_install()+")";

             sql_str.add(sql_insert_binf);

             String baoji_sql="REPLACE into db_user.tb_user_battgroup_baojigroup_battgroup(baoji_group_id,StationId,BattGroupId) " + 
                            " SELECT baoji_group_id,'"+binf.getStationId()+"',"+binf.getBattGroupId()+" from  db_user.tb_user_battgroup_baojigroup ";

             sql_str.add(baoji_sql);

             {

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

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

@@ -123,8 +156,56 @@
         return false;

      }

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

      BattTestData.run_cmd();

      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

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

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

            String sql_update_apply=" update db_battinf.tb_battinf_apply set check_uid="+bapply.getCheck_uid()+",check_en=1 where battgroupid="+binf.getBattGroupId();

             sql_str.add(sql_update_apply);

             String sql_replace_map=" replace into web_site.tb_battmap_information(StationId,StationName,address,longitude,latitude) values('"+binf.getStationId()+"','"+binf.getStationName()+"','"+bapply.getAddress()+"',"+bapply.getLongitude()+","+bapply.getLatitude()+")";

             sql_str.add(sql_replace_map);

             {

               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,longitude="+bapply.getLongitude()+",latitude="+bapply.getLatitude()+",address='"+bapply.getAddress()+"' 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);

             }

         }

      }

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

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

      return bl;

   }

    //申请人再我的申请页面的修改操作

   public boolean updatePro(Object obj){

@@ -134,27 +215,33 @@
      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();

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

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

                  + "FBSDeviceName='"+binf.getFBSDeviceName()+"',GroupIndexInFBSDevice="+binf.getGroupIndexInFBSDevice()+",BattGroupNum="+binf.getBattGroupNum()+",BattGroupName='"+binf.getBattGroupName()+"',FloatVolLevel="+binf.getFloatVolLevel()+",OfflineVolLevel="+binf.getOfflineVolLevel()+",BattFloatCurrent="+binf.getBattFloatCurrent()+"," +

                    "MonCount="+binf.getMonCount()+",MonCapStd="+binf.getMonCapStd()+",monVolStd="+binf.getMonVolStd()+",monResStd="+binf.getMonResStd()+",MonSerStd="+binf.getMonSerStd()+",MonVolLowToAvg="+binf.getMonVolLowToAvg()+",BattProducer='"+binf.getBattProducer()+"',BattModel='"+binf.getBattModel()+"',BattProductDate='"+DAOHelper.sdf.format(binf.getBattProductDate())+"',BattInUseDate='"+DAOHelper.sdf.format(binf.getBattInUseDate())+"', "

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

             sql_str.add(sql_update_apply);

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

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

            sql_str.add(sql_update_apply);

             {

               String msg="修改"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";

               String msg="修改申请的"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";

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

               listU.add(ulog);

             }

         }

      }

      Boolean bl=false;

      boolean en=BattinfGroupFactory.backup_battinf();

      if(en){

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

      }else{

         return false;

      }

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

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

      return bl;

   }

@@ -167,7 +254,7 @@
         for (int i = 0; i < list.size(); i++) {

            Battinf_apply bapply=list.get(i);

            BattInf binf=bapply.getBinf();

            String sql_del_apply=" delete from  db_battinf.tb_battinf_apply where num="+bapply.getNum();

            String sql_del_apply=" delete from  db_battinf.tb_battinf_apply where battgroupid="+binf.getBattGroupId();

             sql_str.add(sql_del_apply);

             {

               String msg="取消"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的申请";

@@ -176,13 +263,8 @@
             }

         }

      }

      Boolean bl=false;

      boolean en=BattinfGroupFactory.backup_battinf();

      if(en){

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

      }else{

         return false;

      }

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

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

      return bl;

   }

@@ -193,16 +275,19 @@
   }

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

   public List serchByCondition(Object obj) {

      Page page=(Page) obj;

      Battinf_apply bapply=(Battinf_apply) obj;

      BattInf binf=bapply.getBinf();

      Page page=binf.getPage();

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

      String sql=" select SQL_CALC_FOUND_ROWS distinct num,apply_uid,confrim_uid,check_uid,check_en,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 " +

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

             + ",longitude,latitude,address " +

            " from db_battinf.tb_battinf_apply " +

            " where apply_en=0  order by apply_date desc" +

            " where apply_en=?  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() {

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

         

         public List getResults(ResultSet rs) {

            List list=new ArrayList();

@@ -215,8 +300,14 @@
                  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_uid()));

                  apply.setApply_date(rs.getTimestamp("apply_date"));

                  apply.setApply_note(rs.getString("apply_note"));

                  apply.setLongitude(rs.getDouble("longitude"));

                  apply.setLatitude(rs.getDouble("latitude"));

                  apply.setAddress(rs.getString("address"));

                  

                  BattInf binf=new BattInf();

                  binf.setStationId(rs.getString("stationId"));

@@ -360,6 +451,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;

@@ -367,13 +533,97 @@
      Page page=b.getPage();

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

      String sql=" select SQL_CALC_FOUND_ROWS distinct num,apply_uid,confrim_uid,check_uid,check_en,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=?  and apply_uid=? order by apply_date desc " +

            " limit ?,? ";

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

            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;

         }

      });

      //去掉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;

   }

    //申请人修改待审核的申请时的查询

   public List serchbystationId(Object obj){

      Battinf_apply bapply=(Battinf_apply) obj;

      BattInf b=bapply.getBinf();

      String sql=" select  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  and apply_uid=? and stationid=? order by apply_date desc " ;

      List<Battinf_apply> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{bapply.getNum(),b.getStationId()}, new CallBack() {

         

         public List getResults(ResultSet rs) {

            List list=new ArrayList();

@@ -437,15 +687,63 @@
            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;

   }

   
    //判断新增的电池组是否存在

   public boolean judgeBattInOrNot(Object obj){

      BattInf binf=(BattInf) obj;

      String sql="select distinct stationid from db_battinf.tb_battinf_apply where stationname=? limit 1";

      List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationName()}, new CallBack() {

			
         public List getResults(ResultSet rs) {

            List list=new ArrayList();

            try {

               while(rs.next()){

                  String stationid=rs.getString("stationid");

                  list.add(stationid);

               }

            } catch (SQLException e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

            }

            return list;

         }

      });

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

         return true;

      }else{

         return false;

      }

   }

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

   public List devCommNum() {

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

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

                  fbs.setDev_errcommcount(rs.getInt("dev_errcommcount"));

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

@@ -453,16 +751,18 @@
      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();

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

      binf.setStationName1("湖北省");

      binf.setStationName2("荆门市");

      binf.setStationName3("测试设备机房2");

      binf.setStationName4("BTS设备");

      binf.setStationName5("沙洋县");

      binf.setStationId("4011100");

		
      binf.setStationId("42000626");

      binf.setStationIp("");

      binf.setFBSDeviceId(910001000);

      binf.setFbsDeviceIp("127.0.0.1");

@@ -498,15 +798,23 @@
      bapply.setBinf(binf);

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

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

      List list=new ArrayList();

      /*List list=new ArrayList();

      list.add(bapply);

      boolean bl=bimpl.add(list);

      System.err.println(bl);

      System.err.println(bl);*/

      /*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);*/

      /*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());

      }*/

      List list=bimpl.serchById(bapply);

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

   }

}