xuxiuxi

2017-07-23 d9129dafb57f57f629c5d6203eecba67a6c839f4

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
135
136
137
138
139
140
package cn.com.basic.face.service.sqlite; 
 
import android.database.Cursor; 
import android.database.sqlite.SQLiteDatabase; 
 
import java.util.ArrayList; 
import java.util.List; 
 
import cn.com.basic.face.base.Config; 
import cn.com.basic.face.base.MainActivity; 
import cn.com.basic.face.discern.entity.Device; 
import cn.com.basic.face.discern.entity.Dictionary; 
 
/** 
 * 设备Dao 
 */ 
public class DeviceDao { 
 
    private static DeviceDao instance = new DeviceDao(); 
 
    public static DeviceDao getInstance() { 
        return instance; 
    } 
 
    /** 
     * 加载主设备 
     * @param sn 设备序列号 
     * @param type 设备类型 
     */ 
    public List<Device> loadMainDevice(String type, String sn) { 
 
        List<Device> list = new ArrayList<Device>(); 
 
        try { 
            StringBuilder sb = new StringBuilder(40); 
                    sb.append("select a.device_id, ").append("a.company_id, "). 
                            append("a.device_name, ").append("a.type, ").append("a.install_address, ") 
                            .append("a.school_name, ").append("a.brand_id, ").append("a.ip, ") 
                            .append("a.port, ").append("a.resolution_id, ").append("a.username, ") 
                            .append("a.password, ").append("a.protocol_id, ").append("a.sn, ") 
                            .append("a.belong_id ").append("from device a ") 
                            .append("where 1 = 1"); 
            if(type != null && !type.trim().isEmpty()) { 
                sb.append(" AND a.type = '").append(type).append("'"); 
            } 
            if(sn != null && !sn.trim().isEmpty()) { 
                sb.append(" AND a.sn = ").append(sn) ; 
            } 
 
 
 
            Device aqi = null; 
 
            Cursor c = MainActivity.getInstance().db.rawQuery(sb.toString(), new String[]{}); 
            while (c.moveToNext()) { 
                aqi = new Device(); 
                aqi.setDeviceId(c.getString(c.getColumnIndex("device_id"))); 
                aqi.setCompanyId(c.getString((c.getColumnIndex("company_id")))); 
                aqi.setDeviceName(c.getString((c.getColumnIndex("device_name")))); 
                aqi.setType(c.getString(c.getColumnIndex("type"))); 
                aqi.setInstallAddress(c.getString((c.getColumnIndex("install_address")))); 
                aqi.setSchoolName(c.getString((c.getColumnIndex("school_name")))); 
                aqi.setBrandId(c.getString(c.getColumnIndex("brand_id"))); 
                aqi.setIp(c.getString(c.getColumnIndex("ip"))); 
                aqi.setPort(c.getString(c.getColumnIndex("port"))); 
                aqi.setResolutionId(c.getString(c.getColumnIndex("resolution_id"))); 
                aqi.setUsername(c.getString(c.getColumnIndex("username"))); 
                aqi.setPassword(c.getString(c.getColumnIndex("password"))); 
                aqi.setProtocolId(c.getString(c.getColumnIndex("protocol_id"))); 
                aqi.setSn(c.getString(c.getColumnIndex("sn"))); 
                aqi.setBelongId(c.getString(c.getColumnIndex("belong_id"))); 
 
                list.add(aqi); 
            } 
        }catch (Exception e) { 
            e.printStackTrace(); 
        } 
        return list; 
    } 
 
    /** 
     * 加载摄像头 
     * @param type 设备类型 
     * @param belongId 所属设备Id（主设备） 
     * @return 
     */ 
    public List<Device> loadCamera(String type, String belongId) { 
 
        List<Device> list = new ArrayList<Device>(); 
 
 
        try { 
            StringBuilder sb = new StringBuilder(40); 
 
            sb.append("select a.device_id, ").append("a.company_id, "). 
                    append("a.device_name, ").append("a.type, ").append("a.install_address, ") 
                    .append("a.school_name, ").append("a.brand_id, ").append("a.ip, ") 
                    .append("a.port, ").append("a.resolution_id, ").append("a.username, ") 
                    .append("a.password, ").append("a.protocol_id, ").append("a.sn, ") 
                    .append("a.belong_id ").append("from device a ") 
                    .append("where 1 = 1"); 
            if(type != null && !type.trim().isEmpty()) { 
                sb.append(" AND a.type = '").append(type).append("'"); 
            } 
            if(belongId != null && !belongId.trim().isEmpty()) { 
                sb.append(" AND a.belong_id = ").append(belongId) ; 
            } 
 
            Device aqi = null; 
 
            Cursor c = MainActivity.getInstance().db.rawQuery(sb.toString(), new String[]{}); 
            while (c.moveToNext()) { 
                aqi = new Device(); 
                aqi.setDeviceId(c.getString(c.getColumnIndex("device_id"))); 
                aqi.setCompanyId(c.getString((c.getColumnIndex("company_id")))); 
                aqi.setDeviceName(c.getString((c.getColumnIndex("device_name")))); 
                aqi.setType(c.getString(c.getColumnIndex("type"))); 
                aqi.setInstallAddress(c.getString((c.getColumnIndex("install_address")))); 
                aqi.setSchoolName(c.getString((c.getColumnIndex("school_name")))); 
                aqi.setBrandId(c.getString(c.getColumnIndex("brand_id"))); 
                aqi.setIp(c.getString(c.getColumnIndex("ip"))); 
                aqi.setPort(c.getString(c.getColumnIndex("port"))); 
                aqi.setResolutionId(c.getString(c.getColumnIndex("resolution_id"))); 
                aqi.setUsername(c.getString(c.getColumnIndex("username"))); 
                aqi.setPassword(c.getString(c.getColumnIndex("password"))); 
                aqi.setProtocolId(c.getString(c.getColumnIndex("protocol_id"))); 
                aqi.setSn(c.getString(c.getColumnIndex("sn"))); 
                aqi.setBelongId(c.getString(c.getColumnIndex("belong_id"))); 
 
                list.add(aqi); 
            } 
            c.close(); 
 
        }catch (Exception e) { 
            e.printStackTrace(); 
        } 
        return list; 
    } 
 
}