批量修改放电参数

81041

2018-12-27 ff1f112468e24296821865b4df968e01f6152f04

批量修改放电参数

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_setparamAction$1.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_setparamAction.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_setparamImpl$1.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_setparamImpl$2.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_setparamImpl$3.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_setparamImpl.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/ram/Fbs9100_setparamService.class

Binary files differ

 gx_tieta/src/com/fgkj/actions/ram/Fbs9100_setparamAction.java

@@ -49,6 +49,14 @@
        result = tojson(model);        

        return SUCCESS;    

    }

    //批量设置放电参数

    public String updatePro() {

        List<Fbs9100_setparam> list=getGson().fromJson(json, new TypeToken<List<Fbs9100_setparam>>(){}.getType());

        Fbs9100_setparam fbs = getGson().fromJson(json, Fbs9100_setparam.class);

        ServiceModel model = service.updatePro(list);

        result = tojson(model);		
        return SUCCESS;	
    }

    //点击弹出框的设定按钮,修改ld6测试参数

    public String updateld6Param(){

        Fbs9100_setparam fbs = getGson().fromJson(json, Fbs9100_setparam.class);


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

@@ -9,15 +9,19 @@
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.services.User_logService;



public class Fbs9100_setparamImpl implements BaseDAO,CallBack{



@@ -80,14 +84,27 @@
    }

    //批量设置放电参数

    public boolean updatePro(Object obj) {

        Fbs9100_setparam fs=(Fbs9100_setparam) obj;

        String sql="update db_ram_db.tb_Fbs9100_setparam set testCmd=?,HourRate=?," +

                "DisCurr=?,DisCap=?,DisTime=?,groupVol_Low=?,monomerVol_Low=?,monomerLowCount=?,battGroupNum=?," +

                "onlineVolLowAction=?,dCVolHighLimit=?,chargeCurrSet=?,MonomerTmp_High=? where dev_id=?";

        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{

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

        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;

    }

    //修改放电参数表中ld6

@@ -305,6 +322,44 @@
        }

        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;


 gx_tieta/src/com/fgkj/services/ram/Fbs9100_setparamService.java

@@ -1,5 +1,6 @@
package com.fgkj.services.ram;



import java.util.Calendar;

import java.util.List;



import com.fgkj.dao.BaseDAO;

@@ -82,6 +83,40 @@
        }        

        return model;    

    }

    //批量设置放电参数

    public ServiceModel updatePro(Object obj) {

        boolean bl=((Fbs9100_setparamImpl)dao).updatePro(obj);

        if(bl) {

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

            Calendar c = Calendar.getInstance(); 
            //现在的时间(单位：毫秒) 
            long now_time = c.getTimeInMillis();

            long time=0;

            int success=0;

            do {

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

                    Fbs9100_setparam fs=list.get(i);

                    if(fs.getNum()==0) {

                        boolean b=((Fbs9100_setparamImpl)dao).getCmdAck(fs.getOp_cmd(), fs.getDev_id());

                        if(b) {

                            success+=1;

                            fs.setNum(1);

                        }

                    }

                }

                long moment_time = c.getTimeInMillis();

                time=moment_time=now_time;

            }while(time<=5);

            model.setData(list);

            model.setCode(1);

            model.setSum(success);

            model.setMsg("修改成功!");

        }else {

            model.setCode(0);

            model.setMsg("修改失败!");

        }

        return model;	
    }

    //点击弹出框的设定按钮,修改ld6测试参数

    public ServiceModel updateld6Param(Object obj){

        Fbs9100_setparam fsparam=(Fbs9100_setparam) obj;