批量读取系统参数

81041

2019-01-11 fa00382db413a8489d07983b66f0869305b51a9a

 gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java

@@ -11,8 +11,13 @@
import com.fgkj.dao.CallBack;

import com.fgkj.dao.DAOHelper;

import com.fgkj.dao.FBS9100_ComBase;

import com.fgkj.dao.UinfDaoFactory;

import com.fgkj.db.DBUtil;

import com.fgkj.dto.User_log;

import com.fgkj.dto.ram.Fbs9100_battparam;

import com.fgkj.dto.ram.Fbs9100_setparam;

import com.fgkj.dto.ram.Fbs9100_sysparam;

import com.fgkj.services.User_logService;



public class Fbs9100_sysparamImpl implements BaseDAO,CallBack{



@@ -35,11 +40,66 @@
         ,sys.getMACADDR(),sys.getLoaderCount(),sys.getDtCardCount(),sys.getPowerBreakChargeCurr(),sys.getMajorBattGroupNum(),sys.getPOF_BG_Boost_Cnt(),sys.getPOF_BG_Boost_VolStop(),sys.getPOF_BG_Boost_VolStart(),sys.getDev_id()});

      return bl;

   }

   //批量设置系统参数

   public boolean updatePro(Object obj) {

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

      ArrayList sql_str=new ArrayList();

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

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

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

            Fbs9100_sysparam fs=list.get(i);

            String sql="REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime"

                  + ",MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart) "

                  + " values("+fs.getDev_id()+","+fs.getOp_cmd()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime()

                  +",'"+fs.getMACADDR()+"',"+fs.getLoaderCount()+","+fs.getDtCardCount()+","+fs.getPowerBreakChargeCurr()+","+fs.getMajorBattGroupNum()+","+fs.getPOF_BG_Boost_Cnt()+","+fs.getPOF_BG_Boost_VolStop()+","+fs.getPOF_BG_Boost_VolStart()+")";

            sql_str.add(sql);

            {

               String msg="修改"+fs.getDev_id()+"机房系统参数";

               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;

   }

    //查询系统参数前(如果没有默认数据要用REPLACE 添加一笔数据)

   public boolean replace (Object obj){

      Fbs9100_sysparam sys=(Fbs9100_sysparam) obj;

      String sql=" REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id) values(?)";

      boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id()});

      return bl;

   }

   //查询系统参数前(如果没有默认数据要用REPLACE 添加一笔数据)同时发送命令

   public boolean replacePL(Object obj){

      Fbs9100_sysparam sys=(Fbs9100_sysparam) obj;

      String sql=" REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) values(?,?)";

      boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id(),sys.getOp_cmd()});

      return bl;

   }

   //批量读取电池参数

   public boolean readPL(Object obj) {

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

      ArrayList sql_str=new ArrayList();

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

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

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

            Fbs9100_sysparam fs=list.get(i);

            String sql="replace into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) "

                  + " values("+fs.getDev_id()+","+fs.getOp_cmd()+")";

            sql_str.add(sql);

            {

               String msg="获取"+fs.getDev_id()+"系统参数";

               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 del(Object obj) {

@@ -152,6 +212,40 @@
      }

      return res_exe;

   }

	
   //批量设置系统参数成功后读取命令的ACK

   public boolean getCmdAck(int cmd,int dev_id) {

      int m_cmd = cmd;

      int m_cmd_ack = cmd;

      switch(m_cmd) {

      case FBS9100_ComBase.CMD_GetSYSSetParam: m_cmd_ack = FBS9100_ComBase.CMD_GetSYSSetParamAck; break;

      case FBS9100_ComBase.CMD_SetSYSSetParam: m_cmd_ack = FBS9100_ComBase.CMD_SetSYSSetParamAck; break;

      default: return false;

       }

      String sql = "SELECT op_cmd FROM db_ram_db.tb_fbs9100_sysparam "+

            " WHERE dev_id="+dev_id;

      Connection conn=DBUtil.getConn();

      PreparedStatement ps = null;

      ResultSet rs = null;

      boolean res_exe=false;

      try {

         ps = conn.prepareStatement(sql);

         rs=ps.executeQuery();

         if(rs.next())

         {

            if(rs.getInt("op_cmd") == m_cmd_ack)

            {

               res_exe = true;

            }

         }

      } catch (SQLException e) {

         // TODO Auto-generated catch block

         e.printStackTrace();

      }

      DBUtil.close(rs, ps, conn);

      return res_exe;

   }

	
   public List serchByInfo(Object obj) {

      // TODO Auto-generated method stub

      return null;