交流主配子站

whyclxw

2020-11-16 0f83d3041c29677f90cd9db1f1d4e3ed12b22434

交流主配子站

 DyEnvir_system/src/com/fgkj/actions/CsvFileDownloadAction.java

@@ -24,6 +24,7 @@
import com.fgkj.elemachinery.dto.Motor_readdata;
import com.fgkj.elemachinery.impl.Motor_readdataImpl;
import com.fgkj.partinsystem.dto.Ac230v_ups;
import com.fgkj.partinsystem.dto.AcDistribution;
import com.fgkj.partinsystem.dto.Battery_monitor;
import com.fgkj.partinsystem.dto.Cabin_board;
import com.fgkj.partinsystem.dto.Dc230v_batt;
@@ -35,6 +36,7 @@
import com.fgkj.partinsystem.dto.Reliable_board;
import com.fgkj.partinsystem.dto.Switch_board;
import com.fgkj.partinsystem.impl.Ac230v_upsImpl;
import com.fgkj.partinsystem.impl.AcDistributionImpl;
import com.fgkj.partinsystem.impl.Battery_monitorImpl;
import com.fgkj.partinsystem.impl.Cabin_boardImpl;
import com.fgkj.partinsystem.impl.Dc230v_battImpl;
@@ -335,6 +337,12 @@
             dd.setNote(cs.getTablists());
             exportData=(new DcDistributionImpl()).serchCSV(dd);
         }else if(cs.getExport_num()==12){
             AcDistribution ad=new AcDistribution();
             ad.setDev_id(cs.getDev_id());
             ad.setRecord_time(cs.getRecord_time());
             ad.setRecord_time1(cs.getRecord_time1());
             ad.setNote(cs.getTablists());
             exportData=(new AcDistributionImpl()).serchCSV(ad);
            
         }else if(cs.getExport_num()==13){       //推进电机
             Propulsion_motor pm=new Propulsion_motor();

 DyEnvir_system/src/com/fgkj/actions/partinsystem/AcDistributionAction.java

New file
@@ -0,0 +1,47 @@
package com.fgkj.actions.partinsystem;

import com.fgkj.actions.ActionUtil;
import com.fgkj.partinsystem.dto.AcDistribution;
import com.fgkj.partinsystem.service.AcDistributionService;
import com.fgkj.services.ServiceModel;

public class AcDistributionAction extends ActionUtil{
    private AcDistributionService service=new AcDistributionService();
    private String json;
    private String result;
	
	
	
    //根据参试设备id查询设备的实时数据
    public String serchByCondition() {
        AcDistribution ac=ActionUtil.getGson(ActionUtil.time_yyyyMMddHHmmss).fromJson(json, AcDistribution.class);
        ServiceModel model=service.serchByCondition(ac);
        result=tojson(model);
        return SUCCESS;
    }
	
    //设备实时数据显示（前100笔数据服务器的时间）
    public String serchByInfo() {
        AcDistribution ac=ActionUtil.getGson(ActionUtil.time_yyyyMMddHHmmss).fromJson(json, AcDistribution.class);
        ServiceModel model=service.serchByInfo(ac);
        result=tojson(model);
        return SUCCESS;
    }
    //设备历史数据查询
    public String serchHistory() {
        AcDistribution ac=ActionUtil.getGson(ActionUtil.time_yyyyMMddHHmmss).fromJson(json, AcDistribution.class);
        ServiceModel model=service.serchHistory(ac);
        result=tojson(model);
        return SUCCESS;
    }
    public String getResult() {
        return result;
    }
    public void setJson(String json) {
        this.json = json;
    }
	
	
	

}

 DyEnvir_system/src/com/fgkj/dao/BaseDAO.java

@@ -123,6 +123,7 @@
    public static final int  SWITCH_BOARD=66;
    public static final int  PROPULSION_MOTOR=67;
    public static final int  DCDISTRIBUTION=68;
    public static final int  ACDISTRIBUTION=69;
    
        
    public boolean add(Object obj); // 添加

 DyEnvir_system/src/com/fgkj/dao/BaseDAOFactory.java

@@ -52,6 +52,7 @@
import com.fgkj.elemachinery.impl.Motor_readdataImpl;
import com.fgkj.elemachinery.impl.Subject_motor_stateImpl;
import com.fgkj.partinsystem.impl.Ac230v_upsImpl;
import com.fgkj.partinsystem.impl.AcDistributionImpl;
import com.fgkj.partinsystem.impl.Battery_monitorImpl;
import com.fgkj.partinsystem.impl.Cabin_boardImpl;
import com.fgkj.partinsystem.impl.Centra_frequencyImpl;
@@ -154,6 +155,7 @@
        case 66:return new Switch_boardImpl();
        case 67:return new Propulsion_motorImpl();
        case 68:return new DcDistributionImpl();
        case 69:return new AcDistributionImpl();
        default :return null;
        }
    }

 DyEnvir_system/src/com/fgkj/partinsystem/dto/AcDistribution.java

New file
@@ -0,0 +1,2185 @@
package com.fgkj.partinsystem.dto;

import java.io.Serializable;
import java.util.Date;

public class AcDistribution implements Serializable{
    private int dev_id;
    private Date record_time;	
    private Date record_time1;	
    private int state1;
    private int state2;
    private int state3;
    private int state4;
    private int state5;
    private int state6;
    private int state7;
    private int state8;
    private int state9;
    private int state10;
    private int state11;
    private int state12;
    private int ac_connstate;
    private float state1_curr_a;
    private float state1_curr_b;
    private float state1_curr_c;
    private int state1_switch_st;
    private int state1_ele_st;
    private float state1_vol_a;
    private float state1_vol_b;
    private float state1_vol_c;
    private float state1_ac_f;
    private float state1_ac_power;
    private float state1_app_power;
    private float state2_curr_a;
    private float state2_curr_b;
    private float state2_curr_c;
    private int state2_switch_st;
    private int state2_ele_st;
    private float state2_vol_a;
    private float state2_vol_b;
    private float state2_vol_c;
    private float state2_ac_f;
    private float state2_ac_power;
    private float state2_app_power;
    private float state3_curr_a;
    private float state3_curr_b;
    private float state3_curr_c;
    private int state3_switch_st;
    private int state3_ele_st;
    private float state3_vol_a;
    private float state3_vol_b;
    private float state3_vol_c;
    private float state3_ac_f;
    private float state3_ac_power;
    private float state3_app_power;
    private float state4_curr_a;
    private float state4_curr_b;
    private float state4_curr_c;
    private int state4_switch_st;
    private int state4_ele_st;
    private float state4_vol_a;
    private float state4_vol_b;
    private float state4_vol_c;
    private float state4_ac_f;
    private float state4_ac_power;
    private float state4_app_power;
    private float state5_curr_a;
    private float state5_curr_b;
    private float state5_curr_c;
    private int state5_switch_st;
    private int state5_ele_st;
    private float state5_vol_a;
    private float state5_vol_b;
    private float state5_vol_c;
    private float state5_ac_f;
    private float state5_ac_power;
    private float state5_app_power;
    private float state6_curr_a;
    private float state6_curr_b;
    private float state6_curr_c;
    private int state6_switch_st;
    private int state6_ele_st;
    private float state6_vol_a;
    private float state6_vol_b;
    private float state6_vol_c;
    private float state6_ac_f;
    private float state6_ac_power;
    private float state6_app_power;
    private float state7_curr_a;
    private float state7_curr_b;
    private float state7_curr_c;
    private int state7_switch_st;
    private int state7_ele_st;
    private float state7_vol_a;
    private float state7_vol_b;
    private float state7_vol_c;
    private float state7_ac_f;
    private float state7_ac_power;
    private float state7_app_power;
    private float state8_curr_a;
    private float state8_curr_b;
    private float state8_curr_c;
    private int state8_switch_st;
    private int state8_ele_st;
    private float state8_vol_a;
    private float state8_vol_b;
    private float state8_vol_c;
    private float state8_ac_f;
    private float state8_ac_power;
    private float state8_app_power;
    private float state9_curr_a;
    private float state9_curr_b;
    private float state9_curr_c;
    private int state9_switch_st;
    private int state9_ele_st;
    private float state9_vol_a;
    private float state9_vol_b;
    private float state9_vol_c;
    private float state9_ac_f;
    private float state9_ac_power;
    private float state9_app_power;
    private float state10_curr_a;
    private float state10_curr_b;
    private float state10_curr_c;
    private int state10_switch_st;
    private int state10_ele_st;
    private float state10_vol_a;
    private float state10_vol_b;
    private float state10_vol_c;
    private float state10_ac_f;
    private float state10_ac_power;
    private float state10_app_power;
    private float state11_curr_a;
    private float state11_curr_b;
    private float state11_curr_c;
    private int state11_switch_st;
    private int state11_ele_st;
    private float state11_vol_a;
    private float state11_vol_b;
    private float state11_vol_c;
    private float state11_ac_f;
    private float state11_ac_power;
    private float state11_app_power;
    private float state12_curr_a;
    private float state12_curr_b;
    private float state12_curr_c;
    private int state12_switch_st;
    private int state12_ele_st;
    private float state12_vol_a;
    private float state12_vol_b;
    private float state12_vol_c;
    private float state12_ac_f;
    private float state12_ac_power;
    private float state12_app_power;
	
    /********** 第一帧 ********************/
    private float fram11_q11;                //[1号交流主配AB相电压;1号可靠配电板AB相电压;3号交流主配电板AB相电压;2号可靠配电板AB相电压]
    private float fram11_q12;                //[1号交流主配BC相电压;1号可靠配电板BC相电压;3号交流主配电板BC相电压;2号可靠配电板BC相电压]
    private float fram11_q13;                //[1号交流主配CA相电压;1号可靠配电板CA相电压;3号交流主配电板CA相电压;2号可靠配电板CA相电压]
    private float fram11_q14;                //[交流主配电板频率;保留;3号交流主配电板频率;保留]
	
    /*********** 第二帧 ****************************/
    private float fram12_q11;                //[q11A相电流;1号逆变电源(q10)AB相电压;交流岸电A相电压;4号逆变电源(Q40)AB相电压]
    private float fram12_q12;                //[保留;1号逆变电源(10)BC相电压;交流岸电B相电压;4号逆变电源(Q40)BC相电压]
    private float fram12_q13;                //[q15A相电流;1号逆变电源(q10)CA相电压;交流岸电C相电压;4号逆变电源(Q40)CA相电压]
    private float fram12_q14;                //[q17A相电流;1号逆变电源(q10)频率(0.1Hz);交流岸电功率;4号逆变电源(Q40)频率(0.1Hz)]
	
    /*********** 第三帧 ****************************/
    private float fram13_q11;                //[q18A相电流;q10A相电流;交流岸电A相电流;2号可靠配电板频率(0.1Hz)]
    private float fram13_q12;                //[q19A相电流;1号可靠配电板频率(0.1Hz);交流岸电B相电流;Q62A相电流]
    private float fram13_q13;                ////[保留;q51A相电流;交流岸电C相电流;Q65A相电流]
    private float fram13_q14;                //[保留;q52A相电流;q35A相电流;Q40A相电流]
	
    /*********** 第四帧 ****************************/
    private float fram14_q11;                //[交流母联A相电流q12;q53A相电流;q37A相电流;Q67A相电流]
    private float fram14_q12;                //[保留;q55A相电流;q33A相电流;Q68A相电流]
    private float fram14_q13;                //[保留;q56A相电流;q30A相电流;Q81A相电流]
    private float fram14_q14;                //[保留;q57A相电流;保留;Q82A相电流]
	
    /*********** 第五帧 ****************************/
    private int fram15_q11;                    //[q11状态;q10状态;q30状态;Q40状态]			
    private int fram15_q12;                    //[q12状态;q51状态;q33状态;Q62状态]
    private int fram15_q13;                    //[q15状态;q52状态;q35状态;Q65状态]
    private int fram15_q14;                    //[q17状态;q53状态;q37状态;Q67状态]
    private int fram15_q15;                    //[q18状态;q55状态;q38状态;Q68状态]
    private int fram15_q16;                    //[q19状态;q56状态;;;Q81状态]
    private int fram15_q17;                    //[保留;q57状态;;Q82状态]
    private int fram15_q18;                    //[保留;q58状态;;Q83状态]
    private int fram15_q19;                    //[保留;q59状态;;]
    private int fram15_q20;                    //[保留;q71状态;;]
    private int fram15_q21;                    //[保留;q72状态;;]
    private int fram15_q22;                    //[保留;q73状态;;]
    private int fram15_q23;                    //[1号交流主配电板控制电源状态;1号可靠配电板控制电源状态;3号交流主配电板控制电源状态;2号可靠配电板控制电源状态]
    private int fram15_q24;                    //[;非同期保护,q10合闸抑制;非同期保护,Q35合闸抑制;非同期保护,Q62合闸抑制]
    private int fram15_q25;                    ////[;;非同期保护,Q30合闸抑制;非同期保护,Q65合闸抑制]
    private int fram15_q26;                    //[;;;非同期保护,Q40合闸抑制]
	
    /*********** 第六帧 ****************************/
    private float fram16_q11;                //[保留;q58A相电流;3号逆变电源(Q30)AB相电压;Q83A相电流
    private float fram16_q12;                //[保留;q59A相电流;3号逆变电源(Q30)BC相电压;
    private float fram16_q13;                //[保留;q71A相电流;3号逆变电源(Q30)CA相电压;
    private float fram16_q14;                //[保留;q72A相电流;3号逆变电源(Q30)频率(Hz);
	
    /*********** 第七帧 ****************************/
    private float fram17_q11;                //[连接状态0:正常  1:无法连接  2:故障1 3:故障2 4:故障3]
    private float fram17_q12;		
    private float fram17_q13;		
    private float fram17_q14;
	
    /*********** 第八帧 ****************************/
    private float fram18_q11;                //[;q73A相电流;;]
    private float fram18_q12;                //[;;;]
    private float fram18_q13;                //[;;;]
    private float fram18_q14;                //[;;;]
	
    /*********** 第九帧 1****************************/
    private float fram21_q11;                //[2号交流主配AB相电压;;4号交流主配电板AB相电压;
    private float fram21_q12;                //[2号交流主配BC相电压;;4号交流主配电板BC相电压;
    private float fram21_q13;                //[2号交流主配CA相电压;;4号交流主配电板CA相电压;
    private float fram21_q14;                //[2号交流主配电板频率;;4号交流主配电板频率(0.1Hz);
	
    /*********** 第十帧 2****************************/
    private float fram22_q11;                //[q22A相电流;;交流母联Q43A相电流;]
    private float fram22_q12;                //[q20A相电流;;保留;]
    private float fram22_q13;                //[q26A相电流;;保留;]
    private float fram22_q14;                //[q27A相电流;;Q44A相电流;]
	
    /*********** 第十一帧 3****************************/
    private float fram23_q11;                //[q28A相电流;;Q46A相电流;
    private float fram23_q12;                //[q29A相电流;;Q47A相电流;
    private float fram23_q13;                //[保留;;Q48A相电流;]
    private float fram23_q14;                //[保留;;无;]
	
    /*********** 第十三帧 4****************************/
    private int fram25_q11;                    //[Q20状态;;Q43状态;]			
    private int fram25_q12;                    //[Q22状态;;Q44状态;]
    private int fram25_q13;                    //[Q26状态;;Q46状态;]
    private int fram25_q14;                    //[Q27状态;;Q47状态;]
    private int fram25_q15;                    //[Q28状态;;Q48状态;]
    private int fram25_q16;                    //[Q29状态;;;]
    private int fram25_q17;                    //[;;;]
    private int fram25_q18;                    //[;;;]
    private int fram25_q19;                    //[;;;]
    private int fram25_q20;                    //[;;;]
    private int fram25_q21;                    //[;;;]
    private int fram25_q22;                    //[;;;]
    private int fram25_q23;                    //[2号交流主配电板控制电源状态;;4号交流主配电板控制电源状态;]
    private int fram25_q24;                    //[非同期保护,q20合闸抑制;;;]
	
	
    /*********** 第十二帧 5****************************/
    private float fram24_q11;                //[2号逆变电源(q20)AB相电压;;;]
    private float fram24_q12;                //[2号逆变电源(q20)BC相电压;;;]
    private float fram24_q13;                //[2号逆变电源(q20)CA相电压;;;]
    private float fram24_q14;                //[2号逆变电源(q20)频率;;;]
	
    private String note;

    public int getDev_id() {
        return dev_id;
    }

    public void setDev_id(int dev_id) {
        this.dev_id = dev_id;
    }

    public Date getRecord_time() {
        return record_time;
    }

    public void setRecord_time(Date record_time) {
        this.record_time = record_time;
    }

    public Date getRecord_time1() {
        return record_time1;
    }

    public void setRecord_time1(Date record_time1) {
        this.record_time1 = record_time1;
    }

    public int getState1() {
        return state1;
    }

    public void setState1(int state1) {
        this.state1 = state1;
    }

    public int getState2() {
        return state2;
    }

    public void setState2(int state2) {
        this.state2 = state2;
    }

    public int getState3() {
        return state3;
    }

    public void setState3(int state3) {
        this.state3 = state3;
    }

    public int getState4() {
        return state4;
    }

    public void setState4(int state4) {
        this.state4 = state4;
    }

    public int getState5() {
        return state5;
    }

    public void setState5(int state5) {
        this.state5 = state5;
    }

    public int getState6() {
        return state6;
    }

    public void setState6(int state6) {
        this.state6 = state6;
    }

    public int getState7() {
        return state7;
    }

    public void setState7(int state7) {
        this.state7 = state7;
    }

    public int getState8() {
        return state8;
    }

    public void setState8(int state8) {
        this.state8 = state8;
    }

    public int getState9() {
        return state9;
    }

    public void setState9(int state9) {
        this.state9 = state9;
    }

    public int getState10() {
        return state10;
    }

    public void setState10(int state10) {
        this.state10 = state10;
    }

    public int getState11() {
        return state11;
    }

    public void setState11(int state11) {
        this.state11 = state11;
    }

    public int getState12() {
        return state12;
    }

    public void setState12(int state12) {
        this.state12 = state12;
    }

    public int getAc_connstate() {
        return ac_connstate;
    }

    public void setAc_connstate(int ac_connstate) {
        this.ac_connstate = ac_connstate;
    }

    public float getState1_curr_a() {
        return state1_curr_a;
    }

    public void setState1_curr_a(float state1_curr_a) {
        this.state1_curr_a = state1_curr_a;
    }

    public float getState1_curr_b() {
        return state1_curr_b;
    }

    public void setState1_curr_b(float state1_curr_b) {
        this.state1_curr_b = state1_curr_b;
    }

    public float getState1_curr_c() {
        return state1_curr_c;
    }

    public void setState1_curr_c(float state1_curr_c) {
        this.state1_curr_c = state1_curr_c;
    }

    public int getState1_switch_st() {
        return state1_switch_st;
    }

    public void setState1_switch_st(int state1_switch_st) {
        this.state1_switch_st = state1_switch_st;
    }

    public int getState1_ele_st() {
        return state1_ele_st;
    }

    public void setState1_ele_st(int state1_ele_st) {
        this.state1_ele_st = state1_ele_st;
    }

    public float getState1_vol_a() {
        return state1_vol_a;
    }

    public void setState1_vol_a(float state1_vol_a) {
        this.state1_vol_a = state1_vol_a;
    }

    public float getState1_vol_b() {
        return state1_vol_b;
    }

    public void setState1_vol_b(float state1_vol_b) {
        this.state1_vol_b = state1_vol_b;
    }

    public float getState1_vol_c() {
        return state1_vol_c;
    }

    public void setState1_vol_c(float state1_vol_c) {
        this.state1_vol_c = state1_vol_c;
    }

    public float getState1_ac_f() {
        return state1_ac_f;
    }

    public void setState1_ac_f(float state1_ac_f) {
        this.state1_ac_f = state1_ac_f;
    }

    public float getState1_ac_power() {
        return state1_ac_power;
    }

    public void setState1_ac_power(float state1_ac_power) {
        this.state1_ac_power = state1_ac_power;
    }

    public float getState1_app_power() {
        return state1_app_power;
    }

    public void setState1_app_power(float state1_app_power) {
        this.state1_app_power = state1_app_power;
    }

    public float getState2_curr_a() {
        return state2_curr_a;
    }

    public void setState2_curr_a(float state2_curr_a) {
        this.state2_curr_a = state2_curr_a;
    }

    public float getState2_curr_b() {
        return state2_curr_b;
    }

    public void setState2_curr_b(float state2_curr_b) {
        this.state2_curr_b = state2_curr_b;
    }

    public float getState2_curr_c() {
        return state2_curr_c;
    }

    public void setState2_curr_c(float state2_curr_c) {
        this.state2_curr_c = state2_curr_c;
    }

    public int getState2_switch_st() {
        return state2_switch_st;
    }

    public void setState2_switch_st(int state2_switch_st) {
        this.state2_switch_st = state2_switch_st;
    }

    public int getState2_ele_st() {
        return state2_ele_st;
    }

    public void setState2_ele_st(int state2_ele_st) {
        this.state2_ele_st = state2_ele_st;
    }

    public float getState2_vol_a() {
        return state2_vol_a;
    }

    public void setState2_vol_a(float state2_vol_a) {
        this.state2_vol_a = state2_vol_a;
    }

    public float getState2_vol_b() {
        return state2_vol_b;
    }

    public void setState2_vol_b(float state2_vol_b) {
        this.state2_vol_b = state2_vol_b;
    }

    public float getState2_vol_c() {
        return state2_vol_c;
    }

    public void setState2_vol_c(float state2_vol_c) {
        this.state2_vol_c = state2_vol_c;
    }

    public float getState2_ac_f() {
        return state2_ac_f;
    }

    public void setState2_ac_f(float state2_ac_f) {
        this.state2_ac_f = state2_ac_f;
    }

    public float getState2_ac_power() {
        return state2_ac_power;
    }

    public void setState2_ac_power(float state2_ac_power) {
        this.state2_ac_power = state2_ac_power;
    }

    public float getState2_app_power() {
        return state2_app_power;
    }

    public void setState2_app_power(float state2_app_power) {
        this.state2_app_power = state2_app_power;
    }

    public float getState3_curr_a() {
        return state3_curr_a;
    }

    public void setState3_curr_a(float state3_curr_a) {
        this.state3_curr_a = state3_curr_a;
    }

    public float getState3_curr_b() {
        return state3_curr_b;
    }

    public void setState3_curr_b(float state3_curr_b) {
        this.state3_curr_b = state3_curr_b;
    }

    public float getState3_curr_c() {
        return state3_curr_c;
    }

    public void setState3_curr_c(float state3_curr_c) {
        this.state3_curr_c = state3_curr_c;
    }

    public int getState3_switch_st() {
        return state3_switch_st;
    }

    public void setState3_switch_st(int state3_switch_st) {
        this.state3_switch_st = state3_switch_st;
    }

    public int getState3_ele_st() {
        return state3_ele_st;
    }

    public void setState3_ele_st(int state3_ele_st) {
        this.state3_ele_st = state3_ele_st;
    }

    public float getState3_vol_a() {
        return state3_vol_a;
    }

    public void setState3_vol_a(float state3_vol_a) {
        this.state3_vol_a = state3_vol_a;
    }

    public float getState3_vol_b() {
        return state3_vol_b;
    }

    public void setState3_vol_b(float state3_vol_b) {
        this.state3_vol_b = state3_vol_b;
    }

    public float getState3_vol_c() {
        return state3_vol_c;
    }

    public void setState3_vol_c(float state3_vol_c) {
        this.state3_vol_c = state3_vol_c;
    }

    public float getState3_ac_f() {
        return state3_ac_f;
    }

    public void setState3_ac_f(float state3_ac_f) {
        this.state3_ac_f = state3_ac_f;
    }

    public float getState3_ac_power() {
        return state3_ac_power;
    }

    public void setState3_ac_power(float state3_ac_power) {
        this.state3_ac_power = state3_ac_power;
    }

    public float getState3_app_power() {
        return state3_app_power;
    }

    public void setState3_app_power(float state3_app_power) {
        this.state3_app_power = state3_app_power;
    }

    public float getState4_curr_a() {
        return state4_curr_a;
    }

    public void setState4_curr_a(float state4_curr_a) {
        this.state4_curr_a = state4_curr_a;
    }

    public float getState4_curr_b() {
        return state4_curr_b;
    }

    public void setState4_curr_b(float state4_curr_b) {
        this.state4_curr_b = state4_curr_b;
    }

    public float getState4_curr_c() {
        return state4_curr_c;
    }

    public void setState4_curr_c(float state4_curr_c) {
        this.state4_curr_c = state4_curr_c;
    }

    public int getState4_switch_st() {
        return state4_switch_st;
    }

    public void setState4_switch_st(int state4_switch_st) {
        this.state4_switch_st = state4_switch_st;
    }

    public int getState4_ele_st() {
        return state4_ele_st;
    }

    public void setState4_ele_st(int state4_ele_st) {
        this.state4_ele_st = state4_ele_st;
    }

    public float getState4_vol_a() {
        return state4_vol_a;
    }

    public void setState4_vol_a(float state4_vol_a) {
        this.state4_vol_a = state4_vol_a;
    }

    public float getState4_vol_b() {
        return state4_vol_b;
    }

    public void setState4_vol_b(float state4_vol_b) {
        this.state4_vol_b = state4_vol_b;
    }

    public float getState4_vol_c() {
        return state4_vol_c;
    }

    public void setState4_vol_c(float state4_vol_c) {
        this.state4_vol_c = state4_vol_c;
    }

    public float getState4_ac_f() {
        return state4_ac_f;
    }

    public void setState4_ac_f(float state4_ac_f) {
        this.state4_ac_f = state4_ac_f;
    }

    public float getState4_ac_power() {
        return state4_ac_power;
    }

    public void setState4_ac_power(float state4_ac_power) {
        this.state4_ac_power = state4_ac_power;
    }

    public float getState4_app_power() {
        return state4_app_power;
    }

    public void setState4_app_power(float state4_app_power) {
        this.state4_app_power = state4_app_power;
    }

    public float getState5_curr_a() {
        return state5_curr_a;
    }

    public void setState5_curr_a(float state5_curr_a) {
        this.state5_curr_a = state5_curr_a;
    }

    public float getState5_curr_b() {
        return state5_curr_b;
    }

    public void setState5_curr_b(float state5_curr_b) {
        this.state5_curr_b = state5_curr_b;
    }

    public float getState5_curr_c() {
        return state5_curr_c;
    }

    public void setState5_curr_c(float state5_curr_c) {
        this.state5_curr_c = state5_curr_c;
    }

    public int getState5_switch_st() {
        return state5_switch_st;
    }

    public void setState5_switch_st(int state5_switch_st) {
        this.state5_switch_st = state5_switch_st;
    }

    public int getState5_ele_st() {
        return state5_ele_st;
    }

    public void setState5_ele_st(int state5_ele_st) {
        this.state5_ele_st = state5_ele_st;
    }

    public float getState5_vol_a() {
        return state5_vol_a;
    }

    public void setState5_vol_a(float state5_vol_a) {
        this.state5_vol_a = state5_vol_a;
    }

    public float getState5_vol_b() {
        return state5_vol_b;
    }

    public void setState5_vol_b(float state5_vol_b) {
        this.state5_vol_b = state5_vol_b;
    }

    public float getState5_vol_c() {
        return state5_vol_c;
    }

    public void setState5_vol_c(float state5_vol_c) {
        this.state5_vol_c = state5_vol_c;
    }

    public float getState5_ac_f() {
        return state5_ac_f;
    }

    public void setState5_ac_f(float state5_ac_f) {
        this.state5_ac_f = state5_ac_f;
    }

    public float getState5_ac_power() {
        return state5_ac_power;
    }

    public void setState5_ac_power(float state5_ac_power) {
        this.state5_ac_power = state5_ac_power;
    }

    public float getState5_app_power() {
        return state5_app_power;
    }

    public void setState5_app_power(float state5_app_power) {
        this.state5_app_power = state5_app_power;
    }

    public float getState6_curr_a() {
        return state6_curr_a;
    }

    public void setState6_curr_a(float state6_curr_a) {
        this.state6_curr_a = state6_curr_a;
    }

    public float getState6_curr_b() {
        return state6_curr_b;
    }

    public void setState6_curr_b(float state6_curr_b) {
        this.state6_curr_b = state6_curr_b;
    }

    public float getState6_curr_c() {
        return state6_curr_c;
    }

    public void setState6_curr_c(float state6_curr_c) {
        this.state6_curr_c = state6_curr_c;
    }

    public int getState6_switch_st() {
        return state6_switch_st;
    }

    public void setState6_switch_st(int state6_switch_st) {
        this.state6_switch_st = state6_switch_st;
    }

    public int getState6_ele_st() {
        return state6_ele_st;
    }

    public void setState6_ele_st(int state6_ele_st) {
        this.state6_ele_st = state6_ele_st;
    }

    public float getState6_vol_a() {
        return state6_vol_a;
    }

    public void setState6_vol_a(float state6_vol_a) {
        this.state6_vol_a = state6_vol_a;
    }

    public float getState6_vol_b() {
        return state6_vol_b;
    }

    public void setState6_vol_b(float state6_vol_b) {
        this.state6_vol_b = state6_vol_b;
    }

    public float getState6_vol_c() {
        return state6_vol_c;
    }

    public void setState6_vol_c(float state6_vol_c) {
        this.state6_vol_c = state6_vol_c;
    }

    public float getState6_ac_f() {
        return state6_ac_f;
    }

    public void setState6_ac_f(float state6_ac_f) {
        this.state6_ac_f = state6_ac_f;
    }

    public float getState6_ac_power() {
        return state6_ac_power;
    }

    public void setState6_ac_power(float state6_ac_power) {
        this.state6_ac_power = state6_ac_power;
    }

    public float getState6_app_power() {
        return state6_app_power;
    }

    public void setState6_app_power(float state6_app_power) {
        this.state6_app_power = state6_app_power;
    }

    public float getState7_curr_a() {
        return state7_curr_a;
    }

    public void setState7_curr_a(float state7_curr_a) {
        this.state7_curr_a = state7_curr_a;
    }

    public float getState7_curr_b() {
        return state7_curr_b;
    }

    public void setState7_curr_b(float state7_curr_b) {
        this.state7_curr_b = state7_curr_b;
    }

    public float getState7_curr_c() {
        return state7_curr_c;
    }

    public void setState7_curr_c(float state7_curr_c) {
        this.state7_curr_c = state7_curr_c;
    }

    public int getState7_switch_st() {
        return state7_switch_st;
    }

    public void setState7_switch_st(int state7_switch_st) {
        this.state7_switch_st = state7_switch_st;
    }

    public int getState7_ele_st() {
        return state7_ele_st;
    }

    public void setState7_ele_st(int state7_ele_st) {
        this.state7_ele_st = state7_ele_st;
    }

    public float getState7_vol_a() {
        return state7_vol_a;
    }

    public void setState7_vol_a(float state7_vol_a) {
        this.state7_vol_a = state7_vol_a;
    }

    public float getState7_vol_b() {
        return state7_vol_b;
    }

    public void setState7_vol_b(float state7_vol_b) {
        this.state7_vol_b = state7_vol_b;
    }

    public float getState7_vol_c() {
        return state7_vol_c;
    }

    public void setState7_vol_c(float state7_vol_c) {
        this.state7_vol_c = state7_vol_c;
    }

    public float getState7_ac_f() {
        return state7_ac_f;
    }

    public void setState7_ac_f(float state7_ac_f) {
        this.state7_ac_f = state7_ac_f;
    }

    public float getState7_ac_power() {
        return state7_ac_power;
    }

    public void setState7_ac_power(float state7_ac_power) {
        this.state7_ac_power = state7_ac_power;
    }

    public float getState7_app_power() {
        return state7_app_power;
    }

    public void setState7_app_power(float state7_app_power) {
        this.state7_app_power = state7_app_power;
    }

    public float getState8_curr_a() {
        return state8_curr_a;
    }

    public void setState8_curr_a(float state8_curr_a) {
        this.state8_curr_a = state8_curr_a;
    }

    public float getState8_curr_b() {
        return state8_curr_b;
    }

    public void setState8_curr_b(float state8_curr_b) {
        this.state8_curr_b = state8_curr_b;
    }

    public float getState8_curr_c() {
        return state8_curr_c;
    }

    public void setState8_curr_c(float state8_curr_c) {
        this.state8_curr_c = state8_curr_c;
    }

    public int getState8_switch_st() {
        return state8_switch_st;
    }

    public void setState8_switch_st(int state8_switch_st) {
        this.state8_switch_st = state8_switch_st;
    }

    public int getState8_ele_st() {
        return state8_ele_st;
    }

    public void setState8_ele_st(int state8_ele_st) {
        this.state8_ele_st = state8_ele_st;
    }

    public float getState8_vol_a() {
        return state8_vol_a;
    }

    public void setState8_vol_a(float state8_vol_a) {
        this.state8_vol_a = state8_vol_a;
    }

    public float getState8_vol_b() {
        return state8_vol_b;
    }

    public void setState8_vol_b(float state8_vol_b) {
        this.state8_vol_b = state8_vol_b;
    }

    public float getState8_vol_c() {
        return state8_vol_c;
    }

    public void setState8_vol_c(float state8_vol_c) {
        this.state8_vol_c = state8_vol_c;
    }

    public float getState8_ac_f() {
        return state8_ac_f;
    }

    public void setState8_ac_f(float state8_ac_f) {
        this.state8_ac_f = state8_ac_f;
    }

    public float getState8_ac_power() {
        return state8_ac_power;
    }

    public void setState8_ac_power(float state8_ac_power) {
        this.state8_ac_power = state8_ac_power;
    }

    public float getState8_app_power() {
        return state8_app_power;
    }

    public void setState8_app_power(float state8_app_power) {
        this.state8_app_power = state8_app_power;
    }

    public float getState9_curr_a() {
        return state9_curr_a;
    }

    public void setState9_curr_a(float state9_curr_a) {
        this.state9_curr_a = state9_curr_a;
    }

    public float getState9_curr_b() {
        return state9_curr_b;
    }

    public void setState9_curr_b(float state9_curr_b) {
        this.state9_curr_b = state9_curr_b;
    }

    public float getState9_curr_c() {
        return state9_curr_c;
    }

    public void setState9_curr_c(float state9_curr_c) {
        this.state9_curr_c = state9_curr_c;
    }

    public int getState9_switch_st() {
        return state9_switch_st;
    }

    public void setState9_switch_st(int state9_switch_st) {
        this.state9_switch_st = state9_switch_st;
    }

    public int getState9_ele_st() {
        return state9_ele_st;
    }

    public void setState9_ele_st(int state9_ele_st) {
        this.state9_ele_st = state9_ele_st;
    }

    public float getState9_vol_a() {
        return state9_vol_a;
    }

    public void setState9_vol_a(float state9_vol_a) {
        this.state9_vol_a = state9_vol_a;
    }

    public float getState9_vol_b() {
        return state9_vol_b;
    }

    public void setState9_vol_b(float state9_vol_b) {
        this.state9_vol_b = state9_vol_b;
    }

    public float getState9_vol_c() {
        return state9_vol_c;
    }

    public void setState9_vol_c(float state9_vol_c) {
        this.state9_vol_c = state9_vol_c;
    }

    public float getState9_ac_f() {
        return state9_ac_f;
    }

    public void setState9_ac_f(float state9_ac_f) {
        this.state9_ac_f = state9_ac_f;
    }

    public float getState9_ac_power() {
        return state9_ac_power;
    }

    public void setState9_ac_power(float state9_ac_power) {
        this.state9_ac_power = state9_ac_power;
    }

    public float getState9_app_power() {
        return state9_app_power;
    }

    public void setState9_app_power(float state9_app_power) {
        this.state9_app_power = state9_app_power;
    }

    public float getState10_curr_a() {
        return state10_curr_a;
    }

    public void setState10_curr_a(float state10_curr_a) {
        this.state10_curr_a = state10_curr_a;
    }

    public float getState10_curr_b() {
        return state10_curr_b;
    }

    public void setState10_curr_b(float state10_curr_b) {
        this.state10_curr_b = state10_curr_b;
    }

    public float getState10_curr_c() {
        return state10_curr_c;
    }

    public void setState10_curr_c(float state10_curr_c) {
        this.state10_curr_c = state10_curr_c;
    }

    public int getState10_switch_st() {
        return state10_switch_st;
    }

    public void setState10_switch_st(int state10_switch_st) {
        this.state10_switch_st = state10_switch_st;
    }

    public int getState10_ele_st() {
        return state10_ele_st;
    }

    public void setState10_ele_st(int state10_ele_st) {
        this.state10_ele_st = state10_ele_st;
    }

    public float getState10_vol_a() {
        return state10_vol_a;
    }

    public void setState10_vol_a(float state10_vol_a) {
        this.state10_vol_a = state10_vol_a;
    }

    public float getState10_vol_b() {
        return state10_vol_b;
    }

    public void setState10_vol_b(float state10_vol_b) {
        this.state10_vol_b = state10_vol_b;
    }

    public float getState10_vol_c() {
        return state10_vol_c;
    }

    public void setState10_vol_c(float state10_vol_c) {
        this.state10_vol_c = state10_vol_c;
    }

    public float getState10_ac_f() {
        return state10_ac_f;
    }

    public void setState10_ac_f(float state10_ac_f) {
        this.state10_ac_f = state10_ac_f;
    }

    public float getState10_ac_power() {
        return state10_ac_power;
    }

    public void setState10_ac_power(float state10_ac_power) {
        this.state10_ac_power = state10_ac_power;
    }

    public float getState10_app_power() {
        return state10_app_power;
    }

    public void setState10_app_power(float state10_app_power) {
        this.state10_app_power = state10_app_power;
    }

    public float getState11_curr_a() {
        return state11_curr_a;
    }

    public void setState11_curr_a(float state11_curr_a) {
        this.state11_curr_a = state11_curr_a;
    }

    public float getState11_curr_b() {
        return state11_curr_b;
    }

    public void setState11_curr_b(float state11_curr_b) {
        this.state11_curr_b = state11_curr_b;
    }

    public float getState11_curr_c() {
        return state11_curr_c;
    }

    public void setState11_curr_c(float state11_curr_c) {
        this.state11_curr_c = state11_curr_c;
    }

    public int getState11_switch_st() {
        return state11_switch_st;
    }

    public void setState11_switch_st(int state11_switch_st) {
        this.state11_switch_st = state11_switch_st;
    }

    public int getState11_ele_st() {
        return state11_ele_st;
    }

    public void setState11_ele_st(int state11_ele_st) {
        this.state11_ele_st = state11_ele_st;
    }

    public float getState11_vol_a() {
        return state11_vol_a;
    }

    public void setState11_vol_a(float state11_vol_a) {
        this.state11_vol_a = state11_vol_a;
    }

    public float getState11_vol_b() {
        return state11_vol_b;
    }

    public void setState11_vol_b(float state11_vol_b) {
        this.state11_vol_b = state11_vol_b;
    }

    public float getState11_vol_c() {
        return state11_vol_c;
    }

    public void setState11_vol_c(float state11_vol_c) {
        this.state11_vol_c = state11_vol_c;
    }

    public float getState11_ac_f() {
        return state11_ac_f;
    }

    public void setState11_ac_f(float state11_ac_f) {
        this.state11_ac_f = state11_ac_f;
    }

    public float getState11_ac_power() {
        return state11_ac_power;
    }

    public void setState11_ac_power(float state11_ac_power) {
        this.state11_ac_power = state11_ac_power;
    }

    public float getState11_app_power() {
        return state11_app_power;
    }

    public void setState11_app_power(float state11_app_power) {
        this.state11_app_power = state11_app_power;
    }

    public float getState12_curr_a() {
        return state12_curr_a;
    }

    public void setState12_curr_a(float state12_curr_a) {
        this.state12_curr_a = state12_curr_a;
    }

    public float getState12_curr_b() {
        return state12_curr_b;
    }

    public void setState12_curr_b(float state12_curr_b) {
        this.state12_curr_b = state12_curr_b;
    }

    public float getState12_curr_c() {
        return state12_curr_c;
    }

    public void setState12_curr_c(float state12_curr_c) {
        this.state12_curr_c = state12_curr_c;
    }

    public int getState12_switch_st() {
        return state12_switch_st;
    }

    public void setState12_switch_st(int state12_switch_st) {
        this.state12_switch_st = state12_switch_st;
    }

    public int getState12_ele_st() {
        return state12_ele_st;
    }

    public void setState12_ele_st(int state12_ele_st) {
        this.state12_ele_st = state12_ele_st;
    }

    public float getState12_vol_a() {
        return state12_vol_a;
    }

    public void setState12_vol_a(float state12_vol_a) {
        this.state12_vol_a = state12_vol_a;
    }

    public float getState12_vol_b() {
        return state12_vol_b;
    }

    public void setState12_vol_b(float state12_vol_b) {
        this.state12_vol_b = state12_vol_b;
    }

    public float getState12_vol_c() {
        return state12_vol_c;
    }

    public void setState12_vol_c(float state12_vol_c) {
        this.state12_vol_c = state12_vol_c;
    }

    public float getState12_ac_f() {
        return state12_ac_f;
    }

    public void setState12_ac_f(float state12_ac_f) {
        this.state12_ac_f = state12_ac_f;
    }

    public float getState12_ac_power() {
        return state12_ac_power;
    }

    public void setState12_ac_power(float state12_ac_power) {
        this.state12_ac_power = state12_ac_power;
    }

    public float getState12_app_power() {
        return state12_app_power;
    }

    public void setState12_app_power(float state12_app_power) {
        this.state12_app_power = state12_app_power;
    }

    public float getFram11_q11() {
        return fram11_q11;
    }

    public void setFram11_q11(float fram11_q11) {
        this.fram11_q11 = fram11_q11;
    }

    public float getFram11_q12() {
        return fram11_q12;
    }

    public void setFram11_q12(float fram11_q12) {
        this.fram11_q12 = fram11_q12;
    }

    public float getFram11_q13() {
        return fram11_q13;
    }

    public void setFram11_q13(float fram11_q13) {
        this.fram11_q13 = fram11_q13;
    }

    public float getFram11_q14() {
        return fram11_q14;
    }

    public void setFram11_q14(float fram11_q14) {
        this.fram11_q14 = fram11_q14;
    }

    public float getFram12_q11() {
        return fram12_q11;
    }

    public void setFram12_q11(float fram12_q11) {
        this.fram12_q11 = fram12_q11;
    }

    public float getFram12_q12() {
        return fram12_q12;
    }

    public void setFram12_q12(float fram12_q12) {
        this.fram12_q12 = fram12_q12;
    }

    public float getFram12_q13() {
        return fram12_q13;
    }

    public void setFram12_q13(float fram12_q13) {
        this.fram12_q13 = fram12_q13;
    }

    public float getFram12_q14() {
        return fram12_q14;
    }

    public void setFram12_q14(float fram12_q14) {
        this.fram12_q14 = fram12_q14;
    }

    public float getFram13_q11() {
        return fram13_q11;
    }

    public void setFram13_q11(float fram13_q11) {
        this.fram13_q11 = fram13_q11;
    }

    public float getFram13_q12() {
        return fram13_q12;
    }

    public void setFram13_q12(float fram13_q12) {
        this.fram13_q12 = fram13_q12;
    }

    public float getFram13_q13() {
        return fram13_q13;
    }

    public void setFram13_q13(float fram13_q13) {
        this.fram13_q13 = fram13_q13;
    }

    public float getFram13_q14() {
        return fram13_q14;
    }

    public void setFram13_q14(float fram13_q14) {
        this.fram13_q14 = fram13_q14;
    }

    public float getFram14_q11() {
        return fram14_q11;
    }

    public void setFram14_q11(float fram14_q11) {
        this.fram14_q11 = fram14_q11;
    }

    public float getFram14_q12() {
        return fram14_q12;
    }

    public void setFram14_q12(float fram14_q12) {
        this.fram14_q12 = fram14_q12;
    }

    public float getFram14_q13() {
        return fram14_q13;
    }

    public void setFram14_q13(float fram14_q13) {
        this.fram14_q13 = fram14_q13;
    }

    public float getFram14_q14() {
        return fram14_q14;
    }

    public void setFram14_q14(float fram14_q14) {
        this.fram14_q14 = fram14_q14;
    }

    public int getFram15_q11() {
        return fram15_q11;
    }

    public void setFram15_q11(int fram15_q11) {
        this.fram15_q11 = fram15_q11;
    }

    public int getFram15_q12() {
        return fram15_q12;
    }

    public void setFram15_q12(int fram15_q12) {
        this.fram15_q12 = fram15_q12;
    }

    public int getFram15_q13() {
        return fram15_q13;
    }

    public void setFram15_q13(int fram15_q13) {
        this.fram15_q13 = fram15_q13;
    }

    public int getFram15_q14() {
        return fram15_q14;
    }

    public void setFram15_q14(int fram15_q14) {
        this.fram15_q14 = fram15_q14;
    }

    public int getFram15_q15() {
        return fram15_q15;
    }

    public void setFram15_q15(int fram15_q15) {
        this.fram15_q15 = fram15_q15;
    }

    public int getFram15_q16() {
        return fram15_q16;
    }

    public void setFram15_q16(int fram15_q16) {
        this.fram15_q16 = fram15_q16;
    }

    public int getFram15_q17() {
        return fram15_q17;
    }

    public void setFram15_q17(int fram15_q17) {
        this.fram15_q17 = fram15_q17;
    }

    public int getFram15_q18() {
        return fram15_q18;
    }

    public void setFram15_q18(int fram15_q18) {
        this.fram15_q18 = fram15_q18;
    }

    public int getFram15_q19() {
        return fram15_q19;
    }

    public void setFram15_q19(int fram15_q19) {
        this.fram15_q19 = fram15_q19;
    }

    public int getFram15_q20() {
        return fram15_q20;
    }

    public void setFram15_q20(int fram15_q20) {
        this.fram15_q20 = fram15_q20;
    }

    public int getFram15_q21() {
        return fram15_q21;
    }

    public void setFram15_q21(int fram15_q21) {
        this.fram15_q21 = fram15_q21;
    }

    public int getFram15_q22() {
        return fram15_q22;
    }

    public void setFram15_q22(int fram15_q22) {
        this.fram15_q22 = fram15_q22;
    }

    public int getFram15_q23() {
        return fram15_q23;
    }

    public void setFram15_q23(int fram15_q23) {
        this.fram15_q23 = fram15_q23;
    }

    public int getFram15_q24() {
        return fram15_q24;
    }

    public void setFram15_q24(int fram15_q24) {
        this.fram15_q24 = fram15_q24;
    }

    public int getFram15_q25() {
        return fram15_q25;
    }

    public void setFram15_q25(int fram15_q25) {
        this.fram15_q25 = fram15_q25;
    }

    public int getFram15_q26() {
        return fram15_q26;
    }

    public void setFram15_q26(int fram15_q26) {
        this.fram15_q26 = fram15_q26;
    }

    public float getFram16_q11() {
        return fram16_q11;
    }

    public void setFram16_q11(float fram16_q11) {
        this.fram16_q11 = fram16_q11;
    }

    public float getFram16_q12() {
        return fram16_q12;
    }

    public void setFram16_q12(float fram16_q12) {
        this.fram16_q12 = fram16_q12;
    }

    public float getFram16_q13() {
        return fram16_q13;
    }

    public void setFram16_q13(float fram16_q13) {
        this.fram16_q13 = fram16_q13;
    }

    public float getFram16_q14() {
        return fram16_q14;
    }

    public void setFram16_q14(float fram16_q14) {
        this.fram16_q14 = fram16_q14;
    }

    public float getFram17_q11() {
        return fram17_q11;
    }

    public void setFram17_q11(float fram17_q11) {
        this.fram17_q11 = fram17_q11;
    }

    public float getFram17_q12() {
        return fram17_q12;
    }

    public void setFram17_q12(float fram17_q12) {
        this.fram17_q12 = fram17_q12;
    }

    public float getFram17_q13() {
        return fram17_q13;
    }

    public void setFram17_q13(float fram17_q13) {
        this.fram17_q13 = fram17_q13;
    }

    public float getFram17_q14() {
        return fram17_q14;
    }

    public void setFram17_q14(float fram17_q14) {
        this.fram17_q14 = fram17_q14;
    }

    public float getFram18_q11() {
        return fram18_q11;
    }

    public void setFram18_q11(float fram18_q11) {
        this.fram18_q11 = fram18_q11;
    }

    public float getFram18_q12() {
        return fram18_q12;
    }

    public void setFram18_q12(float fram18_q12) {
        this.fram18_q12 = fram18_q12;
    }

    public float getFram18_q13() {
        return fram18_q13;
    }

    public void setFram18_q13(float fram18_q13) {
        this.fram18_q13 = fram18_q13;
    }

    public float getFram18_q14() {
        return fram18_q14;
    }

    public void setFram18_q14(float fram18_q14) {
        this.fram18_q14 = fram18_q14;
    }

    public float getFram21_q11() {
        return fram21_q11;
    }

    public void setFram21_q11(float fram21_q11) {
        this.fram21_q11 = fram21_q11;
    }

    public float getFram21_q12() {
        return fram21_q12;
    }

    public void setFram21_q12(float fram21_q12) {
        this.fram21_q12 = fram21_q12;
    }

    public float getFram21_q13() {
        return fram21_q13;
    }

    public void setFram21_q13(float fram21_q13) {
        this.fram21_q13 = fram21_q13;
    }

    public float getFram21_q14() {
        return fram21_q14;
    }

    public void setFram21_q14(float fram21_q14) {
        this.fram21_q14 = fram21_q14;
    }

    public float getFram22_q11() {
        return fram22_q11;
    }

    public void setFram22_q11(float fram22_q11) {
        this.fram22_q11 = fram22_q11;
    }

    public float getFram22_q12() {
        return fram22_q12;
    }

    public void setFram22_q12(float fram22_q12) {
        this.fram22_q12 = fram22_q12;
    }

    public float getFram22_q13() {
        return fram22_q13;
    }

    public void setFram22_q13(float fram22_q13) {
        this.fram22_q13 = fram22_q13;
    }

    public float getFram22_q14() {
        return fram22_q14;
    }

    public void setFram22_q14(float fram22_q14) {
        this.fram22_q14 = fram22_q14;
    }

    public float getFram23_q11() {
        return fram23_q11;
    }

    public void setFram23_q11(float fram23_q11) {
        this.fram23_q11 = fram23_q11;
    }

    public float getFram23_q12() {
        return fram23_q12;
    }

    public void setFram23_q12(float fram23_q12) {
        this.fram23_q12 = fram23_q12;
    }

    public float getFram23_q13() {
        return fram23_q13;
    }

    public void setFram23_q13(float fram23_q13) {
        this.fram23_q13 = fram23_q13;
    }

    public float getFram23_q14() {
        return fram23_q14;
    }

    public void setFram23_q14(float fram23_q14) {
        this.fram23_q14 = fram23_q14;
    }

    public int getFram25_q11() {
        return fram25_q11;
    }

    public void setFram25_q11(int fram25_q11) {
        this.fram25_q11 = fram25_q11;
    }

    public int getFram25_q12() {
        return fram25_q12;
    }

    public void setFram25_q12(int fram25_q12) {
        this.fram25_q12 = fram25_q12;
    }

    public int getFram25_q13() {
        return fram25_q13;
    }

    public void setFram25_q13(int fram25_q13) {
        this.fram25_q13 = fram25_q13;
    }

    public int getFram25_q14() {
        return fram25_q14;
    }

    public void setFram25_q14(int fram25_q14) {
        this.fram25_q14 = fram25_q14;
    }

    public int getFram25_q15() {
        return fram25_q15;
    }

    public void setFram25_q15(int fram25_q15) {
        this.fram25_q15 = fram25_q15;
    }

    public int getFram25_q16() {
        return fram25_q16;
    }

    public void setFram25_q16(int fram25_q16) {
        this.fram25_q16 = fram25_q16;
    }

    public int getFram25_q17() {
        return fram25_q17;
    }

    public void setFram25_q17(int fram25_q17) {
        this.fram25_q17 = fram25_q17;
    }

    public int getFram25_q18() {
        return fram25_q18;
    }

    public void setFram25_q18(int fram25_q18) {
        this.fram25_q18 = fram25_q18;
    }

    public int getFram25_q19() {
        return fram25_q19;
    }

    public void setFram25_q19(int fram25_q19) {
        this.fram25_q19 = fram25_q19;
    }

    public int getFram25_q20() {
        return fram25_q20;
    }

    public void setFram25_q20(int fram25_q20) {
        this.fram25_q20 = fram25_q20;
    }

    public int getFram25_q21() {
        return fram25_q21;
    }

    public void setFram25_q21(int fram25_q21) {
        this.fram25_q21 = fram25_q21;
    }

    public int getFram25_q22() {
        return fram25_q22;
    }

    public void setFram25_q22(int fram25_q22) {
        this.fram25_q22 = fram25_q22;
    }

    public int getFram25_q23() {
        return fram25_q23;
    }

    public void setFram25_q23(int fram25_q23) {
        this.fram25_q23 = fram25_q23;
    }

    public int getFram25_q24() {
        return fram25_q24;
    }

    public void setFram25_q24(int fram25_q24) {
        this.fram25_q24 = fram25_q24;
    }

    public float getFram24_q11() {
        return fram24_q11;
    }

    public void setFram24_q11(float fram24_q11) {
        this.fram24_q11 = fram24_q11;
    }

    public float getFram24_q12() {
        return fram24_q12;
    }

    public void setFram24_q12(float fram24_q12) {
        this.fram24_q12 = fram24_q12;
    }

    public float getFram24_q13() {
        return fram24_q13;
    }

    public void setFram24_q13(float fram24_q13) {
        this.fram24_q13 = fram24_q13;
    }

    public float getFram24_q14() {
        return fram24_q14;
    }

    public void setFram24_q14(float fram24_q14) {
        this.fram24_q14 = fram24_q14;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note;
    }

    @Override
    public String toString() {
        return "AcDistribution [dev_id=" + dev_id + ", record_time="
                + record_time + ", record_time1=" + record_time1 + ", state1="
                + state1 + ", state2=" + state2 + ", state3=" + state3
                + ", state4=" + state4 + ", state5=" + state5 + ", state6="
                + state6 + ", state7=" + state7 + ", state8=" + state8
                + ", state9=" + state9 + ", state10=" + state10 + ", state11="
                + state11 + ", state12=" + state12 + ", ac_connstate="
                + ac_connstate + ", state1_curr_a=" + state1_curr_a
                + ", state1_curr_b=" + state1_curr_b + ", state1_curr_c="
                + state1_curr_c + ", state1_switch_st=" + state1_switch_st
                + ", state1_ele_st=" + state1_ele_st + ", state1_vol_a="
                + state1_vol_a + ", state1_vol_b=" + state1_vol_b
                + ", state1_vol_c=" + state1_vol_c + ", state1_ac_f="
                + state1_ac_f + ", state1_ac_power=" + state1_ac_power
                + ", state1_app_power=" + state1_app_power + ", state2_curr_a="
                + state2_curr_a + ", state2_curr_b=" + state2_curr_b
                + ", state2_curr_c=" + state2_curr_c + ", state2_switch_st="
                + state2_switch_st + ", state2_ele_st=" + state2_ele_st
                + ", state2_vol_a=" + state2_vol_a + ", state2_vol_b="
                + state2_vol_b + ", state2_vol_c=" + state2_vol_c
                + ", state2_ac_f=" + state2_ac_f + ", state2_ac_power="
                + state2_ac_power + ", state2_app_power=" + state2_app_power
                + ", state3_curr_a=" + state3_curr_a + ", state3_curr_b="
                + state3_curr_b + ", state3_curr_c=" + state3_curr_c
                + ", state3_switch_st=" + state3_switch_st + ", state3_ele_st="
                + state3_ele_st + ", state3_vol_a=" + state3_vol_a
                + ", state3_vol_b=" + state3_vol_b + ", state3_vol_c="
                + state3_vol_c + ", state3_ac_f=" + state3_ac_f
                + ", state3_ac_power=" + state3_ac_power
                + ", state3_app_power=" + state3_app_power + ", state4_curr_a="
                + state4_curr_a + ", state4_curr_b=" + state4_curr_b
                + ", state4_curr_c=" + state4_curr_c + ", state4_switch_st="
                + state4_switch_st + ", state4_ele_st=" + state4_ele_st
                + ", state4_vol_a=" + state4_vol_a + ", state4_vol_b="
                + state4_vol_b + ", state4_vol_c=" + state4_vol_c
                + ", state4_ac_f=" + state4_ac_f + ", state4_ac_power="
                + state4_ac_power + ", state4_app_power=" + state4_app_power
                + ", state5_curr_a=" + state5_curr_a + ", state5_curr_b="
                + state5_curr_b + ", state5_curr_c=" + state5_curr_c
                + ", state5_switch_st=" + state5_switch_st + ", state5_ele_st="
                + state5_ele_st + ", state5_vol_a=" + state5_vol_a
                + ", state5_vol_b=" + state5_vol_b + ", state5_vol_c="
                + state5_vol_c + ", state5_ac_f=" + state5_ac_f
                + ", state5_ac_power=" + state5_ac_power
                + ", state5_app_power=" + state5_app_power + ", state6_curr_a="
                + state6_curr_a + ", state6_curr_b=" + state6_curr_b
                + ", state6_curr_c=" + state6_curr_c + ", state6_switch_st="
                + state6_switch_st + ", state6_ele_st=" + state6_ele_st
                + ", state6_vol_a=" + state6_vol_a + ", state6_vol_b="
                + state6_vol_b + ", state6_vol_c=" + state6_vol_c
                + ", state6_ac_f=" + state6_ac_f + ", state6_ac_power="
                + state6_ac_power + ", state6_app_power=" + state6_app_power
                + ", state7_curr_a=" + state7_curr_a + ", state7_curr_b="
                + state7_curr_b + ", state7_curr_c=" + state7_curr_c
                + ", state7_switch_st=" + state7_switch_st + ", state7_ele_st="
                + state7_ele_st + ", state7_vol_a=" + state7_vol_a
                + ", state7_vol_b=" + state7_vol_b + ", state7_vol_c="
                + state7_vol_c + ", state7_ac_f=" + state7_ac_f
                + ", state7_ac_power=" + state7_ac_power
                + ", state7_app_power=" + state7_app_power + ", state8_curr_a="
                + state8_curr_a + ", state8_curr_b=" + state8_curr_b
                + ", state8_curr_c=" + state8_curr_c + ", state8_switch_st="
                + state8_switch_st + ", state8_ele_st=" + state8_ele_st
                + ", state8_vol_a=" + state8_vol_a + ", state8_vol_b="
                + state8_vol_b + ", state8_vol_c=" + state8_vol_c
                + ", state8_ac_f=" + state8_ac_f + ", state8_ac_power="
                + state8_ac_power + ", state8_app_power=" + state8_app_power
                + ", state9_curr_a=" + state9_curr_a + ", state9_curr_b="
                + state9_curr_b + ", state9_curr_c=" + state9_curr_c
                + ", state9_switch_st=" + state9_switch_st + ", state9_ele_st="
                + state9_ele_st + ", state9_vol_a=" + state9_vol_a
                + ", state9_vol_b=" + state9_vol_b + ", state9_vol_c="
                + state9_vol_c + ", state9_ac_f=" + state9_ac_f
                + ", state9_ac_power=" + state9_ac_power
                + ", state9_app_power=" + state9_app_power
                + ", state10_curr_a=" + state10_curr_a + ", state10_curr_b="
                + state10_curr_b + ", state10_curr_c=" + state10_curr_c
                + ", state10_switch_st=" + state10_switch_st
                + ", state10_ele_st=" + state10_ele_st + ", state10_vol_a="
                + state10_vol_a + ", state10_vol_b=" + state10_vol_b
                + ", state10_vol_c=" + state10_vol_c + ", state10_ac_f="
                + state10_ac_f + ", state10_ac_power=" + state10_ac_power
                + ", state10_app_power=" + state10_app_power
                + ", state11_curr_a=" + state11_curr_a + ", state11_curr_b="
                + state11_curr_b + ", state11_curr_c=" + state11_curr_c
                + ", state11_switch_st=" + state11_switch_st
                + ", state11_ele_st=" + state11_ele_st + ", state11_vol_a="
                + state11_vol_a + ", state11_vol_b=" + state11_vol_b
                + ", state11_vol_c=" + state11_vol_c + ", state11_ac_f="
                + state11_ac_f + ", state11_ac_power=" + state11_ac_power
                + ", state11_app_power=" + state11_app_power
                + ", state12_curr_a=" + state12_curr_a + ", state12_curr_b="
                + state12_curr_b + ", state12_curr_c=" + state12_curr_c
                + ", state12_switch_st=" + state12_switch_st
                + ", state12_ele_st=" + state12_ele_st + ", state12_vol_a="
                + state12_vol_a + ", state12_vol_b=" + state12_vol_b
                + ", state12_vol_c=" + state12_vol_c + ", state12_ac_f="
                + state12_ac_f + ", state12_ac_power=" + state12_ac_power
                + ", state12_app_power=" + state12_app_power + ", fram11_q11="
                + fram11_q11 + ", fram11_q12=" + fram11_q12 + ", fram11_q13="
                + fram11_q13 + ", fram11_q14=" + fram11_q14 + ", fram12_q11="
                + fram12_q11 + ", fram12_q12=" + fram12_q12 + ", fram12_q13="
                + fram12_q13 + ", fram12_q14=" + fram12_q14 + ", fram13_q11="
                + fram13_q11 + ", fram13_q12=" + fram13_q12 + ", fram13_q13="
                + fram13_q13 + ", fram13_q14=" + fram13_q14 + ", fram14_q11="
                + fram14_q11 + ", fram14_q12=" + fram14_q12 + ", fram14_q13="
                + fram14_q13 + ", fram14_q14=" + fram14_q14 + ", fram15_q11="
                + fram15_q11 + ", fram15_q12=" + fram15_q12 + ", fram15_q13="
                + fram15_q13 + ", fram15_q14=" + fram15_q14 + ", fram15_q15="
                + fram15_q15 + ", fram15_q16=" + fram15_q16 + ", fram15_q17="
                + fram15_q17 + ", fram15_q18=" + fram15_q18 + ", fram15_q19="
                + fram15_q19 + ", fram15_q20=" + fram15_q20 + ", fram15_q21="
                + fram15_q21 + ", fram15_q22=" + fram15_q22 + ", fram15_q23="
                + fram15_q23 + ", fram15_q24=" + fram15_q24 + ", fram15_q25="
                + fram15_q25 + ", fram15_q26=" + fram15_q26 + ", fram16_q11="
                + fram16_q11 + ", fram16_q12=" + fram16_q12 + ", fram16_q13="
                + fram16_q13 + ", fram16_q14=" + fram16_q14 + ", fram17_q11="
                + fram17_q11 + ", fram17_q12=" + fram17_q12 + ", fram17_q13="
                + fram17_q13 + ", fram17_q14=" + fram17_q14 + ", fram18_q11="
                + fram18_q11 + ", fram18_q12=" + fram18_q12 + ", fram18_q13="
                + fram18_q13 + ", fram18_q14=" + fram18_q14 + ", fram21_q11="
                + fram21_q11 + ", fram21_q12=" + fram21_q12 + ", fram21_q13="
                + fram21_q13 + ", fram21_q14=" + fram21_q14 + ", fram22_q11="
                + fram22_q11 + ", fram22_q12=" + fram22_q12 + ", fram22_q13="
                + fram22_q13 + ", fram22_q14=" + fram22_q14 + ", fram23_q11="
                + fram23_q11 + ", fram23_q12=" + fram23_q12 + ", fram23_q13="
                + fram23_q13 + ", fram23_q14=" + fram23_q14 + ", fram25_q11="
                + fram25_q11 + ", fram25_q12=" + fram25_q12 + ", fram25_q13="
                + fram25_q13 + ", fram25_q14=" + fram25_q14 + ", fram25_q15="
                + fram25_q15 + ", fram25_q16=" + fram25_q16 + ", fram25_q17="
                + fram25_q17 + ", fram25_q18=" + fram25_q18 + ", fram25_q19="
                + fram25_q19 + ", fram25_q20=" + fram25_q20 + ", fram25_q21="
                + fram25_q21 + ", fram25_q22=" + fram25_q22 + ", fram25_q23="
                + fram25_q23 + ", fram25_q24=" + fram25_q24 + ", fram24_q11="
                + fram24_q11 + ", fram24_q12=" + fram24_q12 + ", fram24_q13="
                + fram24_q13 + ", fram24_q14=" + fram24_q14 + ", note=" + note
                + "]";
    }
	
	
}

 DyEnvir_system/src/com/fgkj/partinsystem/impl/AcDistributionImpl.java

New file
@@ -0,0 +1,937 @@
package com.fgkj.partinsystem.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.fgkj.actions.ActionUtil;
import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.partinsystem.dto.Ac230v_ups;
import com.fgkj.partinsystem.dto.AcDistribution;

public class AcDistributionImpl implements BaseDAO,CallBack{

    @Override
    public List getResults(ResultSet rs) {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public boolean add(Object obj) {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean update(Object obj) {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean del(Object obj) {
        // TODO Auto-generated method stub
        return false;
    }
     
    @Override
    public List searchAll() {
        // TODO Auto-generated method stub
        return null;
    }
    //根据参试设备id查询设备的实时数据
    @Override
    public List serchByCondition(Object obj) {
        AcDistribution ad=(AcDistribution) obj;
        String sql=" select * from db_partinsystem.acdistribution where dev_id=? ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ad.getDev_id()}, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()){
                        AcDistribution a=new AcDistribution();
                        a.setDev_id(rs.getInt("dev_id"));
                        a.setRecord_time(rs.getTimestamp("record_time"));
                        a.setState1(rs.getInt("state1"));
                        a.setState2(rs.getInt("state2"));
                        a.setState3(rs.getInt("state3"));
                        a.setState4(rs.getInt("state4"));
                        a.setState5(rs.getInt("state5"));
                        a.setState6(rs.getInt("state6"));
                        a.setState7(rs.getInt("state7"));
                        a.setState8(rs.getInt("state8"));
                        a.setState9(rs.getInt("state9"));
                        a.setState10(rs.getInt("state10"));
                        a.setState11(rs.getInt("state11"));
                        a.setState12(rs.getInt("state12"));
                        a.setAc_connstate(rs.getInt("ac_connstate"));
                        a.setState1_curr_a(rs.getFloat("state1_curr_a"));
                        a.setState1_curr_b(rs.getFloat("state1_curr_b"));
                        a.setState1_curr_c(rs.getFloat("state1_curr_c"));
                        a.setState1_switch_st(rs.getInt("state1_switch_st"));
                        a.setState1_ele_st(rs.getInt("state1_ele_st"));
                        a.setState1_vol_a(rs.getFloat("state1_vol_a"));
                        a.setState1_vol_b(rs.getFloat("state1_vol_b"));
                        a.setState1_vol_c(rs.getFloat("state1_vol_c"));
                        a.setState1_ac_f(rs.getFloat("state1_ac_f"));
                        a.setState1_ac_power(rs.getFloat("state1_ac_power"));
                        a.setState1_app_power(rs.getFloat("state1_app_power"));
					    
                        a.setState2_curr_a(rs.getFloat("state2_curr_a"));
                        a.setState2_curr_b(rs.getFloat("state2_curr_b"));
                        a.setState2_curr_c(rs.getFloat("state2_curr_c"));
                        a.setState2_switch_st(rs.getInt("state2_switch_st"));
                        a.setState2_ele_st(rs.getInt("state2_ele_st"));
                        a.setState2_vol_a(rs.getFloat("state2_vol_a"));
                        a.setState2_vol_b(rs.getFloat("state2_vol_b"));
                        a.setState2_vol_c(rs.getFloat("state2_vol_c"));
                        a.setState2_ac_f(rs.getFloat("state2_ac_f"));
                        a.setState2_ac_power(rs.getFloat("state2_ac_power"));
                        a.setState2_app_power(rs.getFloat("state2_app_power"));
						
                        a.setState3_curr_a(rs.getFloat("state3_curr_a"));
                        a.setState3_curr_b(rs.getFloat("state3_curr_b"));
                        a.setState3_curr_c(rs.getFloat("state3_curr_c"));
                        a.setState3_switch_st(rs.getInt("state3_switch_st"));
                        a.setState3_ele_st(rs.getInt("state3_ele_st"));
                        a.setState3_vol_a(rs.getFloat("state3_vol_a"));
                        a.setState3_vol_b(rs.getFloat("state3_vol_b"));
                        a.setState3_vol_c(rs.getFloat("state3_vol_c"));
                        a.setState3_ac_f(rs.getFloat("state3_ac_f"));
                        a.setState3_ac_power(rs.getFloat("state3_ac_power"));
                        a.setState3_app_power(rs.getFloat("state3_app_power"));
						
                        a.setState4_curr_a(rs.getFloat("state4_curr_a"));
                        a.setState4_curr_b(rs.getFloat("state4_curr_b"));
                        a.setState4_curr_c(rs.getFloat("state4_curr_c"));
                        a.setState4_switch_st(rs.getInt("state4_switch_st"));
                        a.setState4_ele_st(rs.getInt("state4_ele_st"));
                        a.setState4_vol_a(rs.getFloat("state4_vol_a"));
                        a.setState4_vol_b(rs.getFloat("state4_vol_b"));
                        a.setState4_vol_c(rs.getFloat("state4_vol_c"));
                        a.setState4_ac_f(rs.getFloat("state4_ac_f"));
                        a.setState4_ac_power(rs.getFloat("state4_ac_power"));
                        a.setState4_app_power(rs.getFloat("state4_app_power"));
					    
                        a.setState5_curr_a(rs.getFloat("state5_curr_a"));
                        a.setState5_curr_b(rs.getFloat("state5_curr_b"));
                        a.setState5_curr_c(rs.getFloat("state5_curr_c"));
                        a.setState5_switch_st(rs.getInt("state5_switch_st"));
                        a.setState5_ele_st(rs.getInt("state5_ele_st"));
                        a.setState5_vol_a(rs.getFloat("state5_vol_a"));
                        a.setState5_vol_b(rs.getFloat("state5_vol_b"));
                        a.setState5_vol_c(rs.getFloat("state5_vol_c"));
                        a.setState5_ac_f(rs.getFloat("state5_ac_f"));
                        a.setState5_ac_power(rs.getFloat("state5_ac_power"));
                        a.setState5_app_power(rs.getFloat("state5_app_power"));
					    
                        a.setState6_curr_a(rs.getFloat("state6_curr_a"));
                        a.setState6_curr_b(rs.getFloat("state6_curr_b"));
                        a.setState6_curr_c(rs.getFloat("state6_curr_c"));
                        a.setState6_switch_st(rs.getInt("state6_switch_st"));
                        a.setState6_ele_st(rs.getInt("state6_ele_st"));
                        a.setState6_vol_a(rs.getFloat("state6_vol_a"));
                        a.setState6_vol_b(rs.getFloat("state6_vol_b"));
                        a.setState6_vol_c(rs.getFloat("state6_vol_c"));
                        a.setState6_ac_f(rs.getFloat("state6_ac_f"));
                        a.setState6_ac_power(rs.getFloat("state6_ac_power"));
                        a.setState6_app_power(rs.getFloat("state6_app_power"));
					    
                        a.setState7_curr_a(rs.getFloat("state7_curr_a"));
                        a.setState7_curr_b(rs.getFloat("state7_curr_b"));
                        a.setState7_curr_c(rs.getFloat("state7_curr_c"));
                        a.setState7_switch_st(rs.getInt("state7_switch_st"));
                        a.setState7_ele_st(rs.getInt("state7_ele_st"));
                        a.setState7_vol_a(rs.getFloat("state7_vol_a"));
                        a.setState7_vol_b(rs.getFloat("state7_vol_b"));
                        a.setState7_vol_c(rs.getFloat("state7_vol_c"));
                        a.setState7_ac_f(rs.getFloat("state7_ac_f"));
                        a.setState7_ac_power(rs.getFloat("state7_ac_power"));
                        a.setState7_app_power(rs.getFloat("state7_app_power"));
					    
                        a.setState8_curr_a(rs.getFloat("state8_curr_a"));
                        a.setState8_curr_b(rs.getFloat("state8_curr_b"));
                        a.setState8_curr_c(rs.getFloat("state8_curr_c"));
                        a.setState8_switch_st(rs.getInt("state8_switch_st"));
                        a.setState8_ele_st(rs.getInt("state8_ele_st"));
                        a.setState8_vol_a(rs.getFloat("state8_vol_a"));
                        a.setState8_vol_b(rs.getFloat("state8_vol_b"));
                        a.setState8_vol_c(rs.getFloat("state8_vol_c"));
                        a.setState8_ac_f(rs.getFloat("state8_ac_f"));
                        a.setState8_ac_power(rs.getFloat("state8_ac_power"));
                        a.setState8_app_power(rs.getFloat("state8_app_power"));
					    
                        a.setState9_curr_a(rs.getFloat("state9_curr_a"));
                        a.setState9_curr_b(rs.getFloat("state9_curr_b"));
                        a.setState9_curr_c(rs.getFloat("state9_curr_c"));
                        a.setState9_switch_st(rs.getInt("state9_switch_st"));
                        a.setState9_ele_st(rs.getInt("state9_ele_st"));
                        a.setState9_vol_a(rs.getFloat("state9_vol_a"));
                        a.setState9_vol_b(rs.getFloat("state9_vol_b"));
                        a.setState9_vol_c(rs.getFloat("state9_vol_c"));
                        a.setState9_ac_f(rs.getFloat("state9_ac_f"));
                        a.setState9_ac_power(rs.getFloat("state9_ac_power"));
                        a.setState9_app_power(rs.getFloat("state9_app_power"));
					    
                        a.setState10_curr_a(rs.getFloat("state10_curr_a"));
                        a.setState10_curr_b(rs.getFloat("state10_curr_b"));
                        a.setState10_curr_c(rs.getFloat("state10_curr_c"));
                        a.setState10_switch_st(rs.getInt("state10_switch_st"));
                        a.setState10_ele_st(rs.getInt("state10_ele_st"));
                        a.setState10_vol_a(rs.getFloat("state10_vol_a"));
                        a.setState10_vol_b(rs.getFloat("state10_vol_b"));
                        a.setState10_vol_c(rs.getFloat("state10_vol_c"));
                        a.setState10_ac_f(rs.getFloat("state10_ac_f"));
                        a.setState10_ac_power(rs.getFloat("state10_ac_power"));
                        a.setState10_app_power(rs.getFloat("state10_app_power"));
					    
                        a.setState11_curr_a(rs.getFloat("state11_curr_a"));
                        a.setState11_curr_b(rs.getFloat("state11_curr_b"));
                        a.setState11_curr_c(rs.getFloat("state11_curr_c"));
                        a.setState11_switch_st(rs.getInt("state11_switch_st"));
                        a.setState11_ele_st(rs.getInt("state11_ele_st"));
                        a.setState11_vol_a(rs.getFloat("state11_vol_a"));
                        a.setState11_vol_b(rs.getFloat("state11_vol_b"));
                        a.setState11_vol_c(rs.getFloat("state11_vol_c"));
                        a.setState11_ac_f(rs.getFloat("state11_ac_f"));
                        a.setState11_ac_power(rs.getFloat("state11_ac_power"));
                        a.setState11_app_power(rs.getFloat("state11_app_power"));
						
                        a.setState12_curr_a(rs.getFloat("state12_curr_a"));
                        a.setState12_curr_b(rs.getFloat("state12_curr_b"));
                        a.setState12_curr_c(rs.getFloat("state12_curr_c"));
                        a.setState12_switch_st(rs.getInt("state12_switch_st"));
                        a.setState12_ele_st(rs.getInt("state12_ele_st"));
                        a.setState12_vol_a(rs.getFloat("state12_vol_a"));
                        a.setState12_vol_b(rs.getFloat("state12_vol_b"));
                        a.setState12_vol_c(rs.getFloat("state12_vol_c"));
                        a.setState12_ac_f(rs.getFloat("state12_ac_f"));
                        a.setState12_ac_power(rs.getFloat("state12_ac_power"));
                        a.setState12_app_power(rs.getFloat("state12_app_power"));
						
                        a.setFram11_q11(rs.getFloat("fram11_q11"));
                        a.setFram11_q12(rs.getFloat("fram11_q12"));
                        a.setFram11_q13(rs.getFloat("fram11_q13"));
                        a.setFram11_q14(rs.getFloat("fram11_q14"));
					    
                        a.setFram12_q11(rs.getFloat("fram12_q11"));
                        a.setFram12_q12(rs.getFloat("fram12_q12"));
                        a.setFram12_q13(rs.getFloat("fram12_q13"));
                        a.setFram12_q14(rs.getFloat("fram12_q14"));
					    
                        a.setFram13_q11(rs.getFloat("fram13_q11"));
                        a.setFram13_q12(rs.getFloat("fram13_q12"));
                        a.setFram13_q13(rs.getFloat("fram13_q13"));
                        a.setFram13_q14(rs.getFloat("fram13_q14"));
					    
                        a.setFram14_q11(rs.getFloat("fram14_q11"));
                        a.setFram14_q12(rs.getFloat("fram14_q12"));
                        a.setFram14_q13(rs.getFloat("fram14_q13"));
                        a.setFram14_q14(rs.getFloat("fram14_q14"));
					    
                        a.setFram15_q11(rs.getInt("fram15_q11"));
                        a.setFram15_q12(rs.getInt("fram15_q12"));
                        a.setFram15_q13(rs.getInt("fram15_q13"));
                        a.setFram15_q14(rs.getInt("fram15_q14"));
                        a.setFram15_q15(rs.getInt("fram15_q15"));
                        a.setFram15_q16(rs.getInt("fram15_q16"));
                        a.setFram15_q17(rs.getInt("fram15_q17"));
                        a.setFram15_q18(rs.getInt("fram15_q18"));
                        a.setFram15_q19(rs.getInt("fram15_q19"));
                        a.setFram15_q20(rs.getInt("fram15_q20"));
                        a.setFram15_q21(rs.getInt("fram15_q21"));
                        a.setFram15_q22(rs.getInt("fram15_q22"));
                        a.setFram15_q23(rs.getInt("fram15_q23"));
                        a.setFram15_q24(rs.getInt("fram15_q24"));
                        a.setFram15_q25(rs.getInt("fram15_q25"));
                        a.setFram15_q26(rs.getInt("fram15_q26"));
					    
                        a.setFram16_q11(rs.getFloat("fram16_q11"));
                        a.setFram16_q12(rs.getFloat("fram16_q12"));
                        a.setFram16_q13(rs.getFloat("fram16_q13"));
                        a.setFram16_q14(rs.getFloat("fram16_q14"));
					    
                        a.setFram17_q11(rs.getFloat("fram17_q11"));
                        a.setFram17_q12(rs.getFloat("fram17_q12"));
                        a.setFram17_q13(rs.getFloat("fram17_q13"));
                        a.setFram17_q14(rs.getFloat("fram17_q14"));
					    
                        a.setFram18_q11(rs.getFloat("fram18_q11"));
                        a.setFram18_q12(rs.getFloat("fram18_q12"));
                        a.setFram18_q13(rs.getFloat("fram18_q13"));
                        a.setFram18_q14(rs.getFloat("fram18_q14"));
					    
                        a.setFram21_q11(rs.getFloat("fram21_q11"));
                        a.setFram21_q12(rs.getFloat("fram21_q12"));
                        a.setFram21_q13(rs.getFloat("fram21_q13"));
                        a.setFram21_q14(rs.getFloat("fram21_q14"));
					    
                        a.setFram22_q11(rs.getFloat("fram22_q11"));
                        a.setFram22_q12(rs.getFloat("fram22_q12"));
                        a.setFram22_q13(rs.getFloat("fram22_q13"));
                        a.setFram22_q14(rs.getFloat("fram22_q14"));
					    
                        a.setFram23_q11(rs.getFloat("fram23_q11"));
                        a.setFram23_q12(rs.getFloat("fram23_q12"));
                        a.setFram23_q13(rs.getFloat("fram23_q13"));
                        a.setFram23_q14(rs.getFloat("fram23_q14"));
					    
                        a.setFram25_q11(rs.getInt("fram25_q11"));
                        a.setFram25_q12(rs.getInt("fram25_q12"));
                        a.setFram25_q13(rs.getInt("fram25_q13"));
                        a.setFram25_q14(rs.getInt("fram25_q14"));
                        a.setFram25_q15(rs.getInt("fram25_q15"));
                        a.setFram25_q16(rs.getInt("fram25_q16"));
                        a.setFram25_q17(rs.getInt("fram25_q17"));
                        a.setFram25_q18(rs.getInt("fram25_q18"));
                        a.setFram25_q19(rs.getInt("fram25_q19"));
                        a.setFram25_q20(rs.getInt("fram25_q20"));
                        a.setFram25_q21(rs.getInt("fram25_q21"));
                        a.setFram25_q22(rs.getInt("fram25_q22"));
                        a.setFram25_q23(rs.getInt("fram25_q23"));
                        a.setFram25_q24(rs.getInt("fram25_q24"));
					    
                        a.setFram24_q11(rs.getFloat("fram24_q11"));
                        a.setFram24_q12(rs.getFloat("fram24_q12"));
                        a.setFram24_q13(rs.getFloat("fram24_q13"));
                        a.setFram24_q14(rs.getFloat("fram24_q14"));
					    
					    
                        list.add(a);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }
     //设备实时数据显示（前100笔数据服务器的时间）
    @Override
    public List serchByInfo(Object obj) {
        AcDistribution ad=(AcDistribution) obj;
        Date date=new Date();
        String table=DAOHelper.sdf_withOut.format(date);
        String sql=" select * from db_partinsystem_history.acdistribution_"+ad.getDev_id()+"_"+table+" where dev_id=? limit 0,100";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ad.getDev_id()}, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()){
                        AcDistribution a=new AcDistribution();
                        a.setDev_id(rs.getInt("dev_id"));
                        a.setRecord_time(rs.getTimestamp("record_time"));
                        a.setState1(rs.getInt("state1"));
                        a.setState2(rs.getInt("state2"));
                        a.setState3(rs.getInt("state3"));
                        a.setState4(rs.getInt("state4"));
                        a.setState5(rs.getInt("state5"));
                        a.setState6(rs.getInt("state6"));
                        a.setState7(rs.getInt("state7"));
                        a.setState8(rs.getInt("state8"));
                        a.setState9(rs.getInt("state9"));
                        a.setState10(rs.getInt("state10"));
                        a.setState11(rs.getInt("state11"));
                        a.setState12(rs.getInt("state12"));
                        a.setAc_connstate(rs.getInt("ac_connstate"));
                        a.setState1_curr_a(rs.getFloat("state1_curr_a"));
                        a.setState1_curr_b(rs.getFloat("state1_curr_b"));
                        a.setState1_curr_c(rs.getFloat("state1_curr_c"));
                        a.setState1_switch_st(rs.getInt("state1_switch_st"));
                        a.setState1_ele_st(rs.getInt("state1_ele_st"));
                        a.setState1_vol_a(rs.getFloat("state1_vol_a"));
                        a.setState1_vol_b(rs.getFloat("state1_vol_b"));
                        a.setState1_vol_c(rs.getFloat("state1_vol_c"));
                        a.setState1_ac_f(rs.getFloat("state1_ac_f"));
                        a.setState1_ac_power(rs.getFloat("state1_ac_power"));
                        a.setState1_app_power(rs.getFloat("state1_app_power"));
					    
                        a.setState2_curr_a(rs.getFloat("state2_curr_a"));
                        a.setState2_curr_b(rs.getFloat("state2_curr_b"));
                        a.setState2_curr_c(rs.getFloat("state2_curr_c"));
                        a.setState2_switch_st(rs.getInt("state2_switch_st"));
                        a.setState2_ele_st(rs.getInt("state2_ele_st"));
                        a.setState2_vol_a(rs.getFloat("state2_vol_a"));
                        a.setState2_vol_b(rs.getFloat("state2_vol_b"));
                        a.setState2_vol_c(rs.getFloat("state2_vol_c"));
                        a.setState2_ac_f(rs.getFloat("state2_ac_f"));
                        a.setState2_ac_power(rs.getFloat("state2_ac_power"));
                        a.setState2_app_power(rs.getFloat("state2_app_power"));
						
                        a.setState3_curr_a(rs.getFloat("state3_curr_a"));
                        a.setState3_curr_b(rs.getFloat("state3_curr_b"));
                        a.setState3_curr_c(rs.getFloat("state3_curr_c"));
                        a.setState3_switch_st(rs.getInt("state3_switch_st"));
                        a.setState3_ele_st(rs.getInt("state3_ele_st"));
                        a.setState3_vol_a(rs.getFloat("state3_vol_a"));
                        a.setState3_vol_b(rs.getFloat("state3_vol_b"));
                        a.setState3_vol_c(rs.getFloat("state3_vol_c"));
                        a.setState3_ac_f(rs.getFloat("state3_ac_f"));
                        a.setState3_ac_power(rs.getFloat("state3_ac_power"));
                        a.setState3_app_power(rs.getFloat("state3_app_power"));
						
                        a.setState4_curr_a(rs.getFloat("state4_curr_a"));
                        a.setState4_curr_b(rs.getFloat("state4_curr_b"));
                        a.setState4_curr_c(rs.getFloat("state4_curr_c"));
                        a.setState4_switch_st(rs.getInt("state4_switch_st"));
                        a.setState4_ele_st(rs.getInt("state4_ele_st"));
                        a.setState4_vol_a(rs.getFloat("state4_vol_a"));
                        a.setState4_vol_b(rs.getFloat("state4_vol_b"));
                        a.setState4_vol_c(rs.getFloat("state4_vol_c"));
                        a.setState4_ac_f(rs.getFloat("state4_ac_f"));
                        a.setState4_ac_power(rs.getFloat("state4_ac_power"));
                        a.setState4_app_power(rs.getFloat("state4_app_power"));
					    
                        a.setState5_curr_a(rs.getFloat("state5_curr_a"));
                        a.setState5_curr_b(rs.getFloat("state5_curr_b"));
                        a.setState5_curr_c(rs.getFloat("state5_curr_c"));
                        a.setState5_switch_st(rs.getInt("state5_switch_st"));
                        a.setState5_ele_st(rs.getInt("state5_ele_st"));
                        a.setState5_vol_a(rs.getFloat("state5_vol_a"));
                        a.setState5_vol_b(rs.getFloat("state5_vol_b"));
                        a.setState5_vol_c(rs.getFloat("state5_vol_c"));
                        a.setState5_ac_f(rs.getFloat("state5_ac_f"));
                        a.setState5_ac_power(rs.getFloat("state5_ac_power"));
                        a.setState5_app_power(rs.getFloat("state5_app_power"));
					    
                        a.setState6_curr_a(rs.getFloat("state6_curr_a"));
                        a.setState6_curr_b(rs.getFloat("state6_curr_b"));
                        a.setState6_curr_c(rs.getFloat("state6_curr_c"));
                        a.setState6_switch_st(rs.getInt("state6_switch_st"));
                        a.setState6_ele_st(rs.getInt("state6_ele_st"));
                        a.setState6_vol_a(rs.getFloat("state6_vol_a"));
                        a.setState6_vol_b(rs.getFloat("state6_vol_b"));
                        a.setState6_vol_c(rs.getFloat("state6_vol_c"));
                        a.setState6_ac_f(rs.getFloat("state6_ac_f"));
                        a.setState6_ac_power(rs.getFloat("state6_ac_power"));
                        a.setState6_app_power(rs.getFloat("state6_app_power"));
					    
                        a.setState7_curr_a(rs.getFloat("state7_curr_a"));
                        a.setState7_curr_b(rs.getFloat("state7_curr_b"));
                        a.setState7_curr_c(rs.getFloat("state7_curr_c"));
                        a.setState7_switch_st(rs.getInt("state7_switch_st"));
                        a.setState7_ele_st(rs.getInt("state7_ele_st"));
                        a.setState7_vol_a(rs.getFloat("state7_vol_a"));
                        a.setState7_vol_b(rs.getFloat("state7_vol_b"));
                        a.setState7_vol_c(rs.getFloat("state7_vol_c"));
                        a.setState7_ac_f(rs.getFloat("state7_ac_f"));
                        a.setState7_ac_power(rs.getFloat("state7_ac_power"));
                        a.setState7_app_power(rs.getFloat("state7_app_power"));
					    
                        a.setState8_curr_a(rs.getFloat("state8_curr_a"));
                        a.setState8_curr_b(rs.getFloat("state8_curr_b"));
                        a.setState8_curr_c(rs.getFloat("state8_curr_c"));
                        a.setState8_switch_st(rs.getInt("state8_switch_st"));
                        a.setState8_ele_st(rs.getInt("state8_ele_st"));
                        a.setState8_vol_a(rs.getFloat("state8_vol_a"));
                        a.setState8_vol_b(rs.getFloat("state8_vol_b"));
                        a.setState8_vol_c(rs.getFloat("state8_vol_c"));
                        a.setState8_ac_f(rs.getFloat("state8_ac_f"));
                        a.setState8_ac_power(rs.getFloat("state8_ac_power"));
                        a.setState8_app_power(rs.getFloat("state8_app_power"));
					    
                        a.setState9_curr_a(rs.getFloat("state9_curr_a"));
                        a.setState9_curr_b(rs.getFloat("state9_curr_b"));
                        a.setState9_curr_c(rs.getFloat("state9_curr_c"));
                        a.setState9_switch_st(rs.getInt("state9_switch_st"));
                        a.setState9_ele_st(rs.getInt("state9_ele_st"));
                        a.setState9_vol_a(rs.getFloat("state9_vol_a"));
                        a.setState9_vol_b(rs.getFloat("state9_vol_b"));
                        a.setState9_vol_c(rs.getFloat("state9_vol_c"));
                        a.setState9_ac_f(rs.getFloat("state9_ac_f"));
                        a.setState9_ac_power(rs.getFloat("state9_ac_power"));
                        a.setState9_app_power(rs.getFloat("state9_app_power"));
					    
                        a.setState10_curr_a(rs.getFloat("state10_curr_a"));
                        a.setState10_curr_b(rs.getFloat("state10_curr_b"));
                        a.setState10_curr_c(rs.getFloat("state10_curr_c"));
                        a.setState10_switch_st(rs.getInt("state10_switch_st"));
                        a.setState10_ele_st(rs.getInt("state10_ele_st"));
                        a.setState10_vol_a(rs.getFloat("state10_vol_a"));
                        a.setState10_vol_b(rs.getFloat("state10_vol_b"));
                        a.setState10_vol_c(rs.getFloat("state10_vol_c"));
                        a.setState10_ac_f(rs.getFloat("state10_ac_f"));
                        a.setState10_ac_power(rs.getFloat("state10_ac_power"));
                        a.setState10_app_power(rs.getFloat("state10_app_power"));
					    
                        a.setState11_curr_a(rs.getFloat("state11_curr_a"));
                        a.setState11_curr_b(rs.getFloat("state11_curr_b"));
                        a.setState11_curr_c(rs.getFloat("state11_curr_c"));
                        a.setState11_switch_st(rs.getInt("state11_switch_st"));
                        a.setState11_ele_st(rs.getInt("state11_ele_st"));
                        a.setState11_vol_a(rs.getFloat("state11_vol_a"));
                        a.setState11_vol_b(rs.getFloat("state11_vol_b"));
                        a.setState11_vol_c(rs.getFloat("state11_vol_c"));
                        a.setState11_ac_f(rs.getFloat("state11_ac_f"));
                        a.setState11_ac_power(rs.getFloat("state11_ac_power"));
                        a.setState11_app_power(rs.getFloat("state11_app_power"));
						
                        a.setState12_curr_a(rs.getFloat("state12_curr_a"));
                        a.setState12_curr_b(rs.getFloat("state12_curr_b"));
                        a.setState12_curr_c(rs.getFloat("state12_curr_c"));
                        a.setState12_switch_st(rs.getInt("state12_switch_st"));
                        a.setState12_ele_st(rs.getInt("state12_ele_st"));
                        a.setState12_vol_a(rs.getFloat("state12_vol_a"));
                        a.setState12_vol_b(rs.getFloat("state12_vol_b"));
                        a.setState12_vol_c(rs.getFloat("state12_vol_c"));
                        a.setState12_ac_f(rs.getFloat("state12_ac_f"));
                        a.setState12_ac_power(rs.getFloat("state12_ac_power"));
                        a.setState12_app_power(rs.getFloat("state12_app_power"));
						
                        a.setFram11_q11(rs.getFloat("fram11_q11"));
                        a.setFram11_q12(rs.getFloat("fram11_q12"));
                        a.setFram11_q13(rs.getFloat("fram11_q13"));
                        a.setFram11_q14(rs.getFloat("fram11_q14"));
					    
                        a.setFram12_q11(rs.getFloat("fram12_q11"));
                        a.setFram12_q12(rs.getFloat("fram12_q12"));
                        a.setFram12_q13(rs.getFloat("fram12_q13"));
                        a.setFram12_q14(rs.getFloat("fram12_q14"));
					    
                        a.setFram13_q11(rs.getFloat("fram13_q11"));
                        a.setFram13_q12(rs.getFloat("fram13_q12"));
                        a.setFram13_q13(rs.getFloat("fram13_q13"));
                        a.setFram13_q14(rs.getFloat("fram13_q14"));
					    
                        a.setFram14_q11(rs.getFloat("fram14_q11"));
                        a.setFram14_q12(rs.getFloat("fram14_q12"));
                        a.setFram14_q13(rs.getFloat("fram14_q13"));
                        a.setFram14_q14(rs.getFloat("fram14_q14"));
					    
                        a.setFram15_q11(rs.getInt("fram15_q11"));
                        a.setFram15_q12(rs.getInt("fram15_q12"));
                        a.setFram15_q13(rs.getInt("fram15_q13"));
                        a.setFram15_q14(rs.getInt("fram15_q14"));
                        a.setFram15_q15(rs.getInt("fram15_q15"));
                        a.setFram15_q16(rs.getInt("fram15_q16"));
                        a.setFram15_q17(rs.getInt("fram15_q17"));
                        a.setFram15_q18(rs.getInt("fram15_q18"));
                        a.setFram15_q19(rs.getInt("fram15_q19"));
                        a.setFram15_q20(rs.getInt("fram15_q20"));
                        a.setFram15_q21(rs.getInt("fram15_q21"));
                        a.setFram15_q22(rs.getInt("fram15_q22"));
                        a.setFram15_q23(rs.getInt("fram15_q23"));
                        a.setFram15_q24(rs.getInt("fram15_q24"));
                        a.setFram15_q25(rs.getInt("fram15_q25"));
                        a.setFram15_q26(rs.getInt("fram15_q26"));
					    
                        a.setFram16_q11(rs.getFloat("fram16_q11"));
                        a.setFram16_q12(rs.getFloat("fram16_q12"));
                        a.setFram16_q13(rs.getFloat("fram16_q13"));
                        a.setFram16_q14(rs.getFloat("fram16_q14"));
					    
                        a.setFram17_q11(rs.getFloat("fram17_q11"));
                        a.setFram17_q12(rs.getFloat("fram17_q12"));
                        a.setFram17_q13(rs.getFloat("fram17_q13"));
                        a.setFram17_q14(rs.getFloat("fram17_q14"));
					    
                        a.setFram18_q11(rs.getFloat("fram18_q11"));
                        a.setFram18_q12(rs.getFloat("fram18_q12"));
                        a.setFram18_q13(rs.getFloat("fram18_q13"));
                        a.setFram18_q14(rs.getFloat("fram18_q14"));
					    
                        a.setFram21_q11(rs.getFloat("fram21_q11"));
                        a.setFram21_q12(rs.getFloat("fram21_q12"));
                        a.setFram21_q13(rs.getFloat("fram21_q13"));
                        a.setFram21_q14(rs.getFloat("fram21_q14"));
					    
                        a.setFram22_q11(rs.getFloat("fram22_q11"));
                        a.setFram22_q12(rs.getFloat("fram22_q12"));
                        a.setFram22_q13(rs.getFloat("fram22_q13"));
                        a.setFram22_q14(rs.getFloat("fram22_q14"));
					    
                        a.setFram23_q11(rs.getFloat("fram23_q11"));
                        a.setFram23_q12(rs.getFloat("fram23_q12"));
                        a.setFram23_q13(rs.getFloat("fram23_q13"));
                        a.setFram23_q14(rs.getFloat("fram23_q14"));
					    
                        a.setFram25_q11(rs.getInt("fram25_q11"));
                        a.setFram25_q12(rs.getInt("fram25_q12"));
                        a.setFram25_q13(rs.getInt("fram25_q13"));
                        a.setFram25_q14(rs.getInt("fram25_q14"));
                        a.setFram25_q15(rs.getInt("fram25_q15"));
                        a.setFram25_q16(rs.getInt("fram25_q16"));
                        a.setFram25_q17(rs.getInt("fram25_q17"));
                        a.setFram25_q18(rs.getInt("fram25_q18"));
                        a.setFram25_q19(rs.getInt("fram25_q19"));
                        a.setFram25_q20(rs.getInt("fram25_q20"));
                        a.setFram25_q21(rs.getInt("fram25_q21"));
                        a.setFram25_q22(rs.getInt("fram25_q22"));
                        a.setFram25_q23(rs.getInt("fram25_q23"));
                        a.setFram25_q24(rs.getInt("fram25_q24"));
					    
                        a.setFram24_q11(rs.getFloat("fram24_q11"));
                        a.setFram24_q12(rs.getFloat("fram24_q12"));
                        a.setFram24_q13(rs.getFloat("fram24_q13"));
                        a.setFram24_q14(rs.getFloat("fram24_q14"));
					    
					    
                        list.add(a);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }
    //设备历史数据查询
    public List serchHistory(Object obj) {
        AcDistribution ad=(AcDistribution) obj;
        String table=DAOHelper.sdf_withOut.format(ad.getRecord_time());
        String sql=" select * from db_partinsystem_history.acdistribution_"+ad.getDev_id()+"_"+table+" "
                + "  where dev_id=?  and record_time >= ? and record_time <= ?  order by record_time asc ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ad.getDev_id(),ad.getRecord_time(),ad.getRecord_time1()}, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()){
                        AcDistribution a=new AcDistribution();
                        a.setDev_id(rs.getInt("dev_id"));
                        a.setRecord_time(rs.getTimestamp("record_time"));
                        a.setState1(rs.getInt("state1"));
                        a.setState2(rs.getInt("state2"));
                        a.setState3(rs.getInt("state3"));
                        a.setState4(rs.getInt("state4"));
                        a.setState5(rs.getInt("state5"));
                        a.setState6(rs.getInt("state6"));
                        a.setState7(rs.getInt("state7"));
                        a.setState8(rs.getInt("state8"));
                        a.setState9(rs.getInt("state9"));
                        a.setState10(rs.getInt("state10"));
                        a.setState11(rs.getInt("state11"));
                        a.setState12(rs.getInt("state12"));
                        a.setAc_connstate(rs.getInt("ac_connstate"));
                        a.setState1_curr_a(rs.getFloat("state1_curr_a"));
                        a.setState1_curr_b(rs.getFloat("state1_curr_b"));
                        a.setState1_curr_c(rs.getFloat("state1_curr_c"));
                        a.setState1_switch_st(rs.getInt("state1_switch_st"));
                        a.setState1_ele_st(rs.getInt("state1_ele_st"));
                        a.setState1_vol_a(rs.getFloat("state1_vol_a"));
                        a.setState1_vol_b(rs.getFloat("state1_vol_b"));
                        a.setState1_vol_c(rs.getFloat("state1_vol_c"));
                        a.setState1_ac_f(rs.getFloat("state1_ac_f"));
                        a.setState1_ac_power(rs.getFloat("state1_ac_power"));
                        a.setState1_app_power(rs.getFloat("state1_app_power"));
					    
                        a.setState2_curr_a(rs.getFloat("state2_curr_a"));
                        a.setState2_curr_b(rs.getFloat("state2_curr_b"));
                        a.setState2_curr_c(rs.getFloat("state2_curr_c"));
                        a.setState2_switch_st(rs.getInt("state2_switch_st"));
                        a.setState2_ele_st(rs.getInt("state2_ele_st"));
                        a.setState2_vol_a(rs.getFloat("state2_vol_a"));
                        a.setState2_vol_b(rs.getFloat("state2_vol_b"));
                        a.setState2_vol_c(rs.getFloat("state2_vol_c"));
                        a.setState2_ac_f(rs.getFloat("state2_ac_f"));
                        a.setState2_ac_power(rs.getFloat("state2_ac_power"));
                        a.setState2_app_power(rs.getFloat("state2_app_power"));
						
                        a.setState3_curr_a(rs.getFloat("state3_curr_a"));
                        a.setState3_curr_b(rs.getFloat("state3_curr_b"));
                        a.setState3_curr_c(rs.getFloat("state3_curr_c"));
                        a.setState3_switch_st(rs.getInt("state3_switch_st"));
                        a.setState3_ele_st(rs.getInt("state3_ele_st"));
                        a.setState3_vol_a(rs.getFloat("state3_vol_a"));
                        a.setState3_vol_b(rs.getFloat("state3_vol_b"));
                        a.setState3_vol_c(rs.getFloat("state3_vol_c"));
                        a.setState3_ac_f(rs.getFloat("state3_ac_f"));
                        a.setState3_ac_power(rs.getFloat("state3_ac_power"));
                        a.setState3_app_power(rs.getFloat("state3_app_power"));
						
                        a.setState4_curr_a(rs.getFloat("state4_curr_a"));
                        a.setState4_curr_b(rs.getFloat("state4_curr_b"));
                        a.setState4_curr_c(rs.getFloat("state4_curr_c"));
                        a.setState4_switch_st(rs.getInt("state4_switch_st"));
                        a.setState4_ele_st(rs.getInt("state4_ele_st"));
                        a.setState4_vol_a(rs.getFloat("state4_vol_a"));
                        a.setState4_vol_b(rs.getFloat("state4_vol_b"));
                        a.setState4_vol_c(rs.getFloat("state4_vol_c"));
                        a.setState4_ac_f(rs.getFloat("state4_ac_f"));
                        a.setState4_ac_power(rs.getFloat("state4_ac_power"));
                        a.setState4_app_power(rs.getFloat("state4_app_power"));
					    
                        a.setState5_curr_a(rs.getFloat("state5_curr_a"));
                        a.setState5_curr_b(rs.getFloat("state5_curr_b"));
                        a.setState5_curr_c(rs.getFloat("state5_curr_c"));
                        a.setState5_switch_st(rs.getInt("state5_switch_st"));
                        a.setState5_ele_st(rs.getInt("state5_ele_st"));
                        a.setState5_vol_a(rs.getFloat("state5_vol_a"));
                        a.setState5_vol_b(rs.getFloat("state5_vol_b"));
                        a.setState5_vol_c(rs.getFloat("state5_vol_c"));
                        a.setState5_ac_f(rs.getFloat("state5_ac_f"));
                        a.setState5_ac_power(rs.getFloat("state5_ac_power"));
                        a.setState5_app_power(rs.getFloat("state5_app_power"));
					    
                        a.setState6_curr_a(rs.getFloat("state6_curr_a"));
                        a.setState6_curr_b(rs.getFloat("state6_curr_b"));
                        a.setState6_curr_c(rs.getFloat("state6_curr_c"));
                        a.setState6_switch_st(rs.getInt("state6_switch_st"));
                        a.setState6_ele_st(rs.getInt("state6_ele_st"));
                        a.setState6_vol_a(rs.getFloat("state6_vol_a"));
                        a.setState6_vol_b(rs.getFloat("state6_vol_b"));
                        a.setState6_vol_c(rs.getFloat("state6_vol_c"));
                        a.setState6_ac_f(rs.getFloat("state6_ac_f"));
                        a.setState6_ac_power(rs.getFloat("state6_ac_power"));
                        a.setState6_app_power(rs.getFloat("state6_app_power"));
					    
                        a.setState7_curr_a(rs.getFloat("state7_curr_a"));
                        a.setState7_curr_b(rs.getFloat("state7_curr_b"));
                        a.setState7_curr_c(rs.getFloat("state7_curr_c"));
                        a.setState7_switch_st(rs.getInt("state7_switch_st"));
                        a.setState7_ele_st(rs.getInt("state7_ele_st"));
                        a.setState7_vol_a(rs.getFloat("state7_vol_a"));
                        a.setState7_vol_b(rs.getFloat("state7_vol_b"));
                        a.setState7_vol_c(rs.getFloat("state7_vol_c"));
                        a.setState7_ac_f(rs.getFloat("state7_ac_f"));
                        a.setState7_ac_power(rs.getFloat("state7_ac_power"));
                        a.setState7_app_power(rs.getFloat("state7_app_power"));
					    
                        a.setState8_curr_a(rs.getFloat("state8_curr_a"));
                        a.setState8_curr_b(rs.getFloat("state8_curr_b"));
                        a.setState8_curr_c(rs.getFloat("state8_curr_c"));
                        a.setState8_switch_st(rs.getInt("state8_switch_st"));
                        a.setState8_ele_st(rs.getInt("state8_ele_st"));
                        a.setState8_vol_a(rs.getFloat("state8_vol_a"));
                        a.setState8_vol_b(rs.getFloat("state8_vol_b"));
                        a.setState8_vol_c(rs.getFloat("state8_vol_c"));
                        a.setState8_ac_f(rs.getFloat("state8_ac_f"));
                        a.setState8_ac_power(rs.getFloat("state8_ac_power"));
                        a.setState8_app_power(rs.getFloat("state8_app_power"));
					    
                        a.setState9_curr_a(rs.getFloat("state9_curr_a"));
                        a.setState9_curr_b(rs.getFloat("state9_curr_b"));
                        a.setState9_curr_c(rs.getFloat("state9_curr_c"));
                        a.setState9_switch_st(rs.getInt("state9_switch_st"));
                        a.setState9_ele_st(rs.getInt("state9_ele_st"));
                        a.setState9_vol_a(rs.getFloat("state9_vol_a"));
                        a.setState9_vol_b(rs.getFloat("state9_vol_b"));
                        a.setState9_vol_c(rs.getFloat("state9_vol_c"));
                        a.setState9_ac_f(rs.getFloat("state9_ac_f"));
                        a.setState9_ac_power(rs.getFloat("state9_ac_power"));
                        a.setState9_app_power(rs.getFloat("state9_app_power"));
					    
                        a.setState10_curr_a(rs.getFloat("state10_curr_a"));
                        a.setState10_curr_b(rs.getFloat("state10_curr_b"));
                        a.setState10_curr_c(rs.getFloat("state10_curr_c"));
                        a.setState10_switch_st(rs.getInt("state10_switch_st"));
                        a.setState10_ele_st(rs.getInt("state10_ele_st"));
                        a.setState10_vol_a(rs.getFloat("state10_vol_a"));
                        a.setState10_vol_b(rs.getFloat("state10_vol_b"));
                        a.setState10_vol_c(rs.getFloat("state10_vol_c"));
                        a.setState10_ac_f(rs.getFloat("state10_ac_f"));
                        a.setState10_ac_power(rs.getFloat("state10_ac_power"));
                        a.setState10_app_power(rs.getFloat("state10_app_power"));
					    
                        a.setState11_curr_a(rs.getFloat("state11_curr_a"));
                        a.setState11_curr_b(rs.getFloat("state11_curr_b"));
                        a.setState11_curr_c(rs.getFloat("state11_curr_c"));
                        a.setState11_switch_st(rs.getInt("state11_switch_st"));
                        a.setState11_ele_st(rs.getInt("state11_ele_st"));
                        a.setState11_vol_a(rs.getFloat("state11_vol_a"));
                        a.setState11_vol_b(rs.getFloat("state11_vol_b"));
                        a.setState11_vol_c(rs.getFloat("state11_vol_c"));
                        a.setState11_ac_f(rs.getFloat("state11_ac_f"));
                        a.setState11_ac_power(rs.getFloat("state11_ac_power"));
                        a.setState11_app_power(rs.getFloat("state11_app_power"));
						
                        a.setState12_curr_a(rs.getFloat("state12_curr_a"));
                        a.setState12_curr_b(rs.getFloat("state12_curr_b"));
                        a.setState12_curr_c(rs.getFloat("state12_curr_c"));
                        a.setState12_switch_st(rs.getInt("state12_switch_st"));
                        a.setState12_ele_st(rs.getInt("state12_ele_st"));
                        a.setState12_vol_a(rs.getFloat("state12_vol_a"));
                        a.setState12_vol_b(rs.getFloat("state12_vol_b"));
                        a.setState12_vol_c(rs.getFloat("state12_vol_c"));
                        a.setState12_ac_f(rs.getFloat("state12_ac_f"));
                        a.setState12_ac_power(rs.getFloat("state12_ac_power"));
                        a.setState12_app_power(rs.getFloat("state12_app_power"));
						
                        a.setFram11_q11(rs.getFloat("fram11_q11"));
                        a.setFram11_q12(rs.getFloat("fram11_q12"));
                        a.setFram11_q13(rs.getFloat("fram11_q13"));
                        a.setFram11_q14(rs.getFloat("fram11_q14"));
					    
                        a.setFram12_q11(rs.getFloat("fram12_q11"));
                        a.setFram12_q12(rs.getFloat("fram12_q12"));
                        a.setFram12_q13(rs.getFloat("fram12_q13"));
                        a.setFram12_q14(rs.getFloat("fram12_q14"));
					    
                        a.setFram13_q11(rs.getFloat("fram13_q11"));
                        a.setFram13_q12(rs.getFloat("fram13_q12"));
                        a.setFram13_q13(rs.getFloat("fram13_q13"));
                        a.setFram13_q14(rs.getFloat("fram13_q14"));
					    
                        a.setFram14_q11(rs.getFloat("fram14_q11"));
                        a.setFram14_q12(rs.getFloat("fram14_q12"));
                        a.setFram14_q13(rs.getFloat("fram14_q13"));
                        a.setFram14_q14(rs.getFloat("fram14_q14"));
					    
                        a.setFram15_q11(rs.getInt("fram15_q11"));
                        a.setFram15_q12(rs.getInt("fram15_q12"));
                        a.setFram15_q13(rs.getInt("fram15_q13"));
                        a.setFram15_q14(rs.getInt("fram15_q14"));
                        a.setFram15_q15(rs.getInt("fram15_q15"));
                        a.setFram15_q16(rs.getInt("fram15_q16"));
                        a.setFram15_q17(rs.getInt("fram15_q17"));
                        a.setFram15_q18(rs.getInt("fram15_q18"));
                        a.setFram15_q19(rs.getInt("fram15_q19"));
                        a.setFram15_q20(rs.getInt("fram15_q20"));
                        a.setFram15_q21(rs.getInt("fram15_q21"));
                        a.setFram15_q22(rs.getInt("fram15_q22"));
                        a.setFram15_q23(rs.getInt("fram15_q23"));
                        a.setFram15_q24(rs.getInt("fram15_q24"));
                        a.setFram15_q25(rs.getInt("fram15_q25"));
                        a.setFram15_q26(rs.getInt("fram15_q26"));
					    
                        a.setFram16_q11(rs.getFloat("fram16_q11"));
                        a.setFram16_q12(rs.getFloat("fram16_q12"));
                        a.setFram16_q13(rs.getFloat("fram16_q13"));
                        a.setFram16_q14(rs.getFloat("fram16_q14"));
					    
                        a.setFram17_q11(rs.getFloat("fram17_q11"));
                        a.setFram17_q12(rs.getFloat("fram17_q12"));
                        a.setFram17_q13(rs.getFloat("fram17_q13"));
                        a.setFram17_q14(rs.getFloat("fram17_q14"));
					    
                        a.setFram18_q11(rs.getFloat("fram18_q11"));
                        a.setFram18_q12(rs.getFloat("fram18_q12"));
                        a.setFram18_q13(rs.getFloat("fram18_q13"));
                        a.setFram18_q14(rs.getFloat("fram18_q14"));
					    
                        a.setFram21_q11(rs.getFloat("fram21_q11"));
                        a.setFram21_q12(rs.getFloat("fram21_q12"));
                        a.setFram21_q13(rs.getFloat("fram21_q13"));
                        a.setFram21_q14(rs.getFloat("fram21_q14"));
					    
                        a.setFram22_q11(rs.getFloat("fram22_q11"));
                        a.setFram22_q12(rs.getFloat("fram22_q12"));
                        a.setFram22_q13(rs.getFloat("fram22_q13"));
                        a.setFram22_q14(rs.getFloat("fram22_q14"));
					    
                        a.setFram23_q11(rs.getFloat("fram23_q11"));
                        a.setFram23_q12(rs.getFloat("fram23_q12"));
                        a.setFram23_q13(rs.getFloat("fram23_q13"));
                        a.setFram23_q14(rs.getFloat("fram23_q14"));
					    
                        a.setFram25_q11(rs.getInt("fram25_q11"));
                        a.setFram25_q12(rs.getInt("fram25_q12"));
                        a.setFram25_q13(rs.getInt("fram25_q13"));
                        a.setFram25_q14(rs.getInt("fram25_q14"));
                        a.setFram25_q15(rs.getInt("fram25_q15"));
                        a.setFram25_q16(rs.getInt("fram25_q16"));
                        a.setFram25_q17(rs.getInt("fram25_q17"));
                        a.setFram25_q18(rs.getInt("fram25_q18"));
                        a.setFram25_q19(rs.getInt("fram25_q19"));
                        a.setFram25_q20(rs.getInt("fram25_q20"));
                        a.setFram25_q21(rs.getInt("fram25_q21"));
                        a.setFram25_q22(rs.getInt("fram25_q22"));
                        a.setFram25_q23(rs.getInt("fram25_q23"));
                        a.setFram25_q24(rs.getInt("fram25_q24"));
					    
                        a.setFram24_q11(rs.getFloat("fram24_q11"));
                        a.setFram24_q12(rs.getFloat("fram24_q12"));
                        a.setFram24_q13(rs.getFloat("fram24_q13"));
                        a.setFram24_q14(rs.getFloat("fram24_q14"));
					    
					    
                        list.add(a);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }
    //文件导出时的历史查询
    public List serchCSV(Object obj) {
        final AcDistribution ad=(AcDistribution) obj;
        String tablists=ad.getNote()+",record_time";
        String table=DAOHelper.sdf_withOut.format(ad.getRecord_time());
        String table1=DAOHelper.sdf_withOut.format(ad.getRecord_time1());
		
        String SqlAll="";
        String sql=" (select "+tablists+" from db_partinsystem_history.acDistribution_"+ad.getDev_id()+"_"+table+" "
                + "  where record_time >= ? and record_time <= ?  order by record_time asc )";
        String sql_union=" union all ";
		
        String sql1= " (select "+tablists+" from db_partinsystem_history.acDistribution_"+ad.getDev_id()+"_"+table1+" "
                + "  where record_time >= ? and record_time <= ?  order by record_time asc )"; 
		
        Object[] strarr=null;
        List list=new ArrayList();
        String st=ad.getDev_id()+"_"+table;
        String st1=ad.getDev_id()+"_"+table1;
		
        int size=DAOHelper.serchTable(st);
        int size1=DAOHelper.serchTable(st1);
		
        //表都存在
        if(size>0&&size1>0){
            if(table.equals(table1)){
                SqlAll=sql;
                strarr=new Object[]{DAOHelper.sdf.format(ad.getRecord_time()),DAOHelper.sdf.format(ad.getRecord_time1())};
				
            }else{
                SqlAll=sql+sql_union+sql1;
                strarr=new Object[]{DAOHelper.sdf.format(ad.getRecord_time()),DAOHelper.sdfwithOut.format(ad.getRecord_time())+" 23:59:59",DAOHelper.sdfwithOut.format(ad.getRecord_time())+" 00:00:00",DAOHelper.sdf.format(ad.getRecord_time1())};
            }
        }
        //存在一个表
        if(size>0&&size1<=0){
            SqlAll=sql;
            strarr=new Object[]{DAOHelper.sdf.format(ad.getRecord_time()),DAOHelper.sdfwithOut.format(ad.getRecord_time())+" 23:59:59"};
			
        }
        if(size<=0&&size1>0){
            SqlAll=sql1;
            strarr=new Object[]{DAOHelper.sdfwithOut.format(ad.getRecord_time1())+" 00:00:00",DAOHelper.sdf.format(ad.getRecord_time1())};
			
        }
        //表都不存在
        if(size<=0&&size1<=0){
            return  list;
        }
        list=DAOHelper.executeQuery(SqlAll, DBUtil.getConn(), strarr, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                String[] state=ad.getNote().split(",");
                try {
                    while(rs.next()){
                        List row=new ArrayList();
                        row.add(ActionUtil.chageDateToString(rs.getTimestamp("record_time"), ActionUtil.time_yyyyMMddHHmmss).trim());
                        for (int i = 0; i < state.length; i++) {
                            row.add(rs.getFloat(state[i]));
                        }
                        list.add(row);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }
}

 DyEnvir_system/src/com/fgkj/partinsystem/service/AcDistributionService.java

New file
@@ -0,0 +1,59 @@
package com.fgkj.partinsystem.service;

import java.util.List;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BaseDAOFactory;
import com.fgkj.partinsystem.impl.AcDistributionImpl;
import com.fgkj.services.ServiceModel;

public class AcDistributionService {
    private BaseDAO dao;
    private ServiceModel model;
	
    public AcDistributionService() {
        super();
        this.dao=BaseDAOFactory.getBaseDAO(BaseDAO.ACDISTRIBUTION);
        this.model=new ServiceModel();
    }
    //根据参试设备id查询设备的实时数据
    public ServiceModel serchByCondition(Object obj) {
        List list=dao.serchByCondition(obj);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    //设备实时数据显示（前100笔数据服务器的时间）
    public ServiceModel serchByInfo(Object obj) {
        List list=dao.serchByInfo(obj);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    //设备历史数据查询
    public ServiceModel serchHistory(Object obj) {
        List list=((AcDistributionImpl)dao).serchHistory(obj);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }

}