Merge branch 'dev_lxw' of https://gitlab.com/whyclxw1/gx_tieta.git into dev...

hdw

2019-01-19 7f953d9aa0e7d4fcbe3c366c7f9f0b3f847f12bd

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

@@ -9,15 +9,20 @@
import sun.security.jca.GetInstance;



import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BattinfGroupFactory;

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.db.IDatabaseName;

import com.fgkj.dto.BattInf;

import com.fgkj.dto.User_log;

import com.fgkj.dto.ram.FBS9100;

import com.fgkj.dto.ram.Fbs9100_setparam;

import com.fgkj.dto.ram.Fbs9100_state;

import com.fgkj.dto.ram.Fbs9100_sysparam;

import com.fgkj.services.User_logService;



public class Fbs9100_setparamImpl implements BaseDAO,CallBack{



@@ -76,6 +81,77 @@
         fs.getTestCmd(),fs.getHourRate(),fs.getDisCurr(),fs.getDisCap(),fs.getDisTime(),

         fs.getGroupVol_Low(),fs.getMonomerVol_Low(),fs.getMonomerLowCount(),fs.getBattGroupNum(),fs.getOnlineLowAction(),

         fs.getDCVolHighLimit(),fs.getChargeCurrSet(),fs.getMonomerTmp_High(),fs.getDev_id()});

      return bl;

   }

   //批量设置放电参数

   public boolean updatePro(Object obj) {

      List<Fbs9100_setparam> list=(List<Fbs9100_setparam>) 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_setparam fs=list.get(i);

            String sql="update db_ram_db.tb_Fbs9100_setparam set op_cmd="+fs.getOp_cmd()+",testCmd="+fs.getTestCmd()+",HourRate="+fs.getHourRate()+"," +

                  "DisCurr="+fs.getDisCurr()+",DisCap="+fs.getDisCap()+",DisTime="+fs.getDisTime()+",groupVol_Low="+fs.getGroupVol_Low()+",monomerVol_Low="+fs.getMonomerVol_Low()+","

                 + "monomerLowCount="+fs.getMonomerLowCount()+",battGroupNum="+fs.getBattGroupNum()+"," +

                  "onlineVolLowAction="+fs.getOnlineLowAction()+",dCVolHighLimit="+fs.getDCVolHighLimit()+",chargeCurrSet="+fs.getChargeCurrSet()+",MonomerTmp_High="+fs.getMonomerTmp_High()+" where dev_id="+fs.getDev_id();

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

      List<Fbs9100_setparam> list=(List<Fbs9100_setparam>) 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_setparam fs=list.get(i);

            String sql="UPDATE db_ram_db.tb_fbs9100_setparam  SET "

                  + " op_cmd="+fs.getOp_cmd()+ ",TestCmd="+fs.getTestCmd()+ " WHERE dev_id= "+fs.getDev_id();

            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 restartPL_FBS(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="UPDATE db_ram_db.tb_fbs9100_setparam  SET "

                  + " op_cmd="+fs.getOp_cmd()+ " WHERE dev_id= "+fs.getDev_id();

            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;

   }

   //修改放电参数表中ld6

@@ -244,6 +320,8 @@
         case FBS9100_ComBase.CMD_GetDischargeParm: m_cmd_ack = FBS9100_ComBase.CMD_GetDischargeParmAck; break;

         case FBS9100_ComBase.CMd_SetIp_Tem: m_cmd_ack = FBS9100_ComBase.CMd_SetIpAck; break;

         case FBS9100_ComBase.CMd_SetIp_Per: m_cmd_ack = FBS9100_ComBase.CMd_SetIpAck; break;

         case FBS9100_ComBase.CMD_ResetSystem: m_cmd_ack = FBS9100_ComBase.CMD_ResetSystemAck; break;

         case FBS9100_ComBase.CMD_READGPRS_BTS_TASK_INF: m_cmd_ack = FBS9100_ComBase.CMD_READGPRS_BTS_TASK_INFACK; break;

         default: return false;

      }

      String sql_end = "";

@@ -291,11 +369,49 @@
      }

      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_Start: m_cmd_ack = FBS9100_ComBase.CMD_StartAck; break;

         case FBS9100_ComBase.CMD_Stop: m_cmd_ack = FBS9100_ComBase.CMD_StopAck; break;

         case FBS9100_ComBase.CMD_SetDischargeParm: m_cmd_ack = FBS9100_ComBase.CMD_SetDischargeParmAck; break;

         case FBS9100_ComBase.CMD_GetDischargeParm: m_cmd_ack = FBS9100_ComBase.CMD_GetDischargeParmAck; break;

         case FBS9100_ComBase.CMd_SetIp_Tem: m_cmd_ack = FBS9100_ComBase.CMd_SetIpAck; break;

         case FBS9100_ComBase.CMd_SetIp_Per: m_cmd_ack = FBS9100_ComBase.CMd_SetIpAck; break;

         case FBS9100_ComBase.CMD_ResetSystem: m_cmd_ack = FBS9100_ComBase.CMD_ResetSystemAck; break;

         case FBS9100_ComBase.CMD_READGPRS_BTS_TASK_INF: m_cmd_ack = FBS9100_ComBase.CMD_READGPRS_BTS_TASK_INFACK; break;

         default: return false;

      }

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

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

   }

   //根据dev_id查询弹出框中的数据

   public List serchbyDev_id(Object obj) {

      Fbs9100_setparam fsparam=(Fbs9100_setparam) obj;

      String sql=" select db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,db_battinf.tb_battinf.BattGroupName" +

            ",db_battinf.tb_battinf.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd" +

            ",db_battinf.tb_battinf.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd,db_battinf.tb_battinf.charge_curr_max" +

            ",db_ram_db.tb_fbs9100_setparam.HourRate,db_ram_db.tb_fbs9100_setparam.DisCurr,db_ram_db.tb_fbs9100_setparam.DisCap" +

            ",db_ram_db.tb_fbs9100_setparam.DisTime,db_ram_db.tb_fbs9100_setparam.GroupVol_LOW,db_ram_db.tb_fbs9100_setparam.MonomerVol_LOW" +

            ",db_ram_db.tb_fbs9100_setparam.MonomerLowCount,db_ram_db.tb_fbs9100_setparam.OnlineVolLowAction" +

@@ -322,6 +438,7 @@
                  binf.setMonCount(rs.getInt("monCount"));

                  binf.setMonVolStd(rs.getFloat("monVolStd"));

                  binf.setMonCapStd(rs.getFloat("monCapStd"));

                  binf.setCharge_curr_max(rs.getFloat("charge_curr_max"));

                  fbs9100.setBinf(binf);

                  

                  Fbs9100_setparam fsparam=new Fbs9100_setparam();