删除电池组信息前备份

81041

2018-12-06 363b9b705d13fd6c3eeff2766d8543e2887ca15a

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

@@ -35,6 +35,7 @@
import com.fgkj.dto.Batttestdata;

import com.fgkj.dto.Batttestdata_inf;

import com.fgkj.dto.Batttestdatastop;

import com.fgkj.dto.Database_backup;

import com.fgkj.dto.Limit;

import com.fgkj.dto.Page;

import com.fgkj.dto.RoleLimit;

@@ -151,6 +152,19 @@
   }

   //删除电池组(多个)

   public boolean del(Object obj) {

      {

          Database_backup  baseup=new Database_backup();

          baseup.setBackup_en(1);

          baseup.setDatabase_name("db_battinf");

          baseup.setTable_name("tb_battinf");

          (new Database_backupImpl()).update(baseup);

           try {

            Thread.sleep(1000*3);

         } catch (InterruptedException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

         }

      };//出现删除操作时，先备份数据库表

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

      ArrayList sql_str=new ArrayList();

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

@@ -179,7 +193,7 @@
      String numberSql=" SELECT FOUND_ROWS() number";

      String sql="select SQL_CALC_FOUND_ROWS distinct(StationId),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,Station_install  " +

             " From db_battinf.tb_battinf " +

             " Where StationName like ? and StationName1 like ? and StationName2 like ?  and StationName5 like ? " +

             " order by StationId  " +

@@ -227,6 +241,7 @@
                  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);



               }