提高查询速度

whyclj

2020-08-25 ecd980ec6c9763dfbd183a3e5560e10fb85199e5

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
package com.electrical.FourKW;
 
import java.util.Date;
 
import com.base.Com;
import com.modbus.data.MyModbusMaster;
import com.modbus.data.MyModbusUtils;
import com.serotonin.modbus4j.BatchRead;
import com.serotonin.modbus4j.BatchResults;
import com.serotonin.modbus4j.code.DataType;
 
public class Electric_alarm {
      public int num ;//'Ö÷¼ü',
      public int electric_id;//  'É豸id',
      public int alarm_id;//  '¸æ¾¯id',
      public Date alarm_starttime ;//'¸æ¾¯¿ªÊ¼Ê±¼ä',
      public Date alarm_endtime;//'¸æ¾¯½áÊøʱ¼ä',
      public int alarm_confirm;// '¸æ¾¯È·ÈÏ',
      public Date alarm_confirmtime ;//'¸æ¾¯È·ÈÏʱ¼ä',
      public String note ;// '',
      
      public int dcover_curr;
      public int synchro_lose;
      public int dcover_vol;
      public int case_pulse_block;
      public int case_transA_overcurr;
      public int case_transB_overcurr;
      public int case_transC_overcurr;
      public int case_cuurfeedback_lose;
      public int case_synchro_cycle_fault;
      public int main_cabinet_fault_one;
      public int main_cabinet_fault_two;
      
    public Electric_alarm(int electric_id) {
        super();
        this.electric_id=electric_id;
    }
    public int getNum() {
        return num;
    }
    public void setNum(int num) {
        this.num = num;
    }
    public int getElectric_id() {
        return electric_id;
    }
    public void setElectric_id(int electric_id) {
        this.electric_id = electric_id;
    }
    public int getAlarm_id() {
        return alarm_id;
    }
    public void setAlarm_id(int alarm_id) {
        this.alarm_id = alarm_id;
    }
    public Date getAlarm_starttime() {
        return alarm_starttime;
    }
    public void setAlarm_starttime(Date alarm_starttime) {
        this.alarm_starttime = alarm_starttime;
    }
    public Date getAlarm_endtime() {
        return alarm_endtime;
    }
    public void setAlarm_endtime(Date alarm_endtime) {
        this.alarm_endtime = alarm_endtime;
    }
    public int getAlarm_confirm() {
        return alarm_confirm;
    }
    public void setAlarm_confirm(int alarm_confirm) {
        this.alarm_confirm = alarm_confirm;
    }
    public Date getAlarm_confirmtime() {
        return alarm_confirmtime;
    }
    public void setAlarm_confirmtime(Date alarm_confirmtime) {
        this.alarm_confirmtime = alarm_confirmtime;
    }
    public String getNote() {
        return note;
    }
    public void setNote(String note) {
        this.note = note;
    }
    @Override
    public String toString() {
        return "Electric_alarm [num=" + num + ", electric_id=" + electric_id + ", alarm_id=" + alarm_id
                + ", alarm_starttime=" + alarm_starttime + ", alarm_endtime=" + alarm_endtime + ", alarm_confirm="
                + alarm_confirm + ", alarm_confirmtime=" + alarm_confirmtime + ", note=" + note + "]";
    }
    
    /**
     * ´´½¨¶ÁÈ¡¼¯ºÏ
     * @param master
     * @return
     */
    public BatchRead<Integer> createBatchRead(MyModbusMaster master) {
        BatchRead<Integer> batch = new BatchRead<Integer>();        
        batch.addLocator(0,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "dcover_curr"), master));                //Ö±Á÷¹ýÁ÷
        batch.addLocator(1,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "synchro_lose"), master));                //ͬ²½¶ªÊ§    
        batch.addLocator(2,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "dcover_vol"), master));                //Ö±Á÷¹ýѹ    
        batch.addLocator(3,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "case_pulse_block"), master));            //»úÏäÂö³å·âËø
        batch.addLocator(4,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "case_transA_overcurr"), master));        //»úÏä±äѹÆ÷AÏà¹ýÁ÷
        batch.addLocator(5,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "case_transB_overcurr"), master));        //»úÏä±äѹÆ÷BÏà¹ýÁ÷
        batch.addLocator(6,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "case_transC_overcurr"), master));        //»úÏä±äѹÆ÷CÏà¹ýÁ÷
        batch.addLocator(7,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "case_cuurfeedback_lose"), master));    //»úÏäÖ±Á÷·´À¡¶ªÊ§
        batch.addLocator(8,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "case_synchro_cycle_fault"), master));    //»úÏäͬ²½ÖÜÆÚ¹ÊÕÏ
        batch.addLocator(9,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "main_cabinet_fault_one"), master));    //1ºÅÖ÷¹ñ¿ìÈÛ¹ÊÕÏ
        batch.addLocator(10,MyModbusUtils.createBaseLocator(Electric_4KW_ModbusAddress.getFaultAdd(this.electric_id, "main_cabinet_fault_two"), master));    //2ºÅÖ÷¹ñ¿ìÈÛ¹ÊÕÏ
            
        return batch;
    }
      
    /**
     * ½âÎö·µ»ØÇëÇó
     * @param res
     */
    public void putBatchResult(BatchResults<Integer> res) {
        if(res != null) {
            this.dcover_curr = MyModbusUtils.readBooleanToInt(res.getValue(0));                    //Ö±Á÷¹ýÁ÷
            this.synchro_lose = MyModbusUtils.readBooleanToInt(res.getValue(1));                //ͬ²½¶ªÊ§                
            this.dcover_vol = MyModbusUtils.readBooleanToInt(res.getValue(2));                    //Ö±Á÷¹ýѹ    
            this.case_pulse_block = MyModbusUtils.readBooleanToInt(res.getValue(3));            //»úÏäÂö³å·âËø
            this.case_transA_overcurr = MyModbusUtils.readBooleanToInt(res.getValue(4));        //»úÏä±äѹÆ÷AÏà¹ýÁ÷
            this.case_transB_overcurr = MyModbusUtils.readBooleanToInt(res.getValue(5));        //»úÏä±äѹÆ÷BÏà¹ýÁ÷    
            this.case_transC_overcurr = MyModbusUtils.readBooleanToInt(res.getValue(6));        //»úÏä±äѹÆ÷CÏà¹ýÁ÷
            this.case_cuurfeedback_lose = MyModbusUtils.readBooleanToInt(res.getValue(7));        //»úÏäÖ±Á÷·´À¡¶ªÊ§
            this.case_synchro_cycle_fault = MyModbusUtils.readBooleanToInt(res.getValue(8));    //»úÏäͬ²½ÖÜÆÚ¹ÊÕÏ
            this.main_cabinet_fault_one = MyModbusUtils.readBooleanToInt(res.getValue(9));        //1ºÅÖ÷¹ñ¿ìÈÛ¹ÊÕÏ            
            this.main_cabinet_fault_two = MyModbusUtils.readBooleanToInt(res.getValue(10));        //2ºÅÖ÷¹ñ¿ìÈÛ¹ÊÕÏ
        }
    } 
}