xuxiuxi

2017-07-20 2235796b1f18a699dd86395f18db64512b0a47e6

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
package cn.com.basic.face.service.sqlite; 
 
import android.database.Cursor; 
import android.database.sqlite.SQLiteDatabase; 
 
import org.xutils.http.RequestParams; 
 
import java.io.File; 
 
import cn.com.basic.face.base.Config; 
import cn.com.basic.face.discern.query.item.OfflineAttenderRegisterItem; 
import cn.com.basic.face.discern.query.item.OfflineVisitorRegisterItem; 
import cn.com.basic.face.discern.query.item.UnknownQueryItem; 
import cn.com.basic.face.util.FileUtil; 
 
public class RegisterDao { 
 
    public static RegisterDao instance = new RegisterDao(); 
    public static RegisterDao getInstance() { 
        return instance; 
    } 
 
    /** 
     * 访客注册 
     * @param params 
     * @param idCardHeadPhoto 
     * @return 
     */ 
    public boolean add(RequestParams params, String idCardHeadPhoto) { 
        return true; 
    } 
 
    /** 
     * 考勤注册 
     * @param params 
     * @param idCardHeadPhoto 
     * @return 
     */ 
    public boolean addAttender(RequestParams params, String idCardHeadPhoto) { 
        return true; 
    } 
 
    public boolean hasOfflineVisitorRegisterData() { 
        Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from register", new String[]{}); 
        c.moveToFirst(); 
        return c.getInt(0) > 0 ? true : false; 
    } 
 
    public boolean hasOfflineAttenderRegisterData() { 
        Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from register", new String[]{}); 
        c.moveToFirst(); 
        return c.getInt(0) > 0 ? true : false; 
    } 
 
    public OfflineVisitorRegisterItem readOfflineVisitorRegister() { 
        OfflineVisitorRegisterItem item = null; 
        String sql = 
                "SELECT\n" + 
                "    a.visitor_id,\n" + 
                "    a.username,\n" + 
                "    a.mobile_phone,\n" + 
                "    a.gender_id,\n" + 
                "    a.identity_type_id,\n" + 
                "    a.country_id,\n" + 
                "    a.visitor_type_id,\n" + 
                "    a.identify_num,\n" + 
                "    a.company_id,\n" + 
                "    a.birthday,\n" + 
                "    a.remark,\n" + 
                "    a.raw_surveillance_photo_path,\n" + 
                "    a.raw_surveillance_photo_width,\n" + 
                "    a.raw_surveillance_photo_height,\n" + 
                "    a.surveillance_photo_path,\n" + 
                "    a.upload_custom_photo_path,\n" + 
                "    a.id_card_photo_path,\n" + 
                "    a.create_time\n" + 
                "FROM\n" + 
                "    offline_visitor_register a"; 
        SQLiteDatabase db = Config.sqlMap.getDb(); 
        db.beginTransaction(); 
        Cursor c = db.rawQuery(sql, new String[]{}); 
        if (c.moveToFirst()) { 
            item = new OfflineVisitorRegisterItem(); 
            item.setVisitorId(c.getString(c.getColumnIndex("visitor_id"))); 
            item.setUsername(c.getString(c.getColumnIndex("username"))); 
            item.setMobilePhone(c.getString(c.getColumnIndex("mobile_phone"))); 
            item.setGenderId(c.getString(c.getColumnIndex("gender_id"))); 
            item.setIdentityTypeId(c.getString(c.getColumnIndex("identity_type_id"))); 
            item.setCountryId(c.getString(c.getColumnIndex("country_id"))); 
            item.setVisitorTypeId(c.getString(c.getColumnIndex("visitor_type_id"))); 
            item.setIdentifyNum(c.getString(c.getColumnIndex("identify_num"))); 
            item.setCompanyId(c.getString(c.getColumnIndex("company_id"))); 
            item.setBirthday(c.getString(c.getColumnIndex("birthday"))); 
            item.setRemark(c.getString(c.getColumnIndex("remark"))); 
            item.setRawSurveillancePhotoPath(c.getString(c.getColumnIndex("raw_surveillance_photo_path"))); 
            item.setRawSurveillancePhotoWidth(c.getString(c.getColumnIndex("raw_surveillance_photo_width"))); 
            item.setRawSurveillancePhotoHeight(c.getString(c.getColumnIndex("raw_surveillance_photo_height"))); 
            item.setSurveillancePhotoPath(c.getString(c.getColumnIndex("surveillance_photo_path"))); 
            item.setUploadCustomPhotoPath(c.getString(c.getColumnIndex("upload_custom_photo_path"))); 
            item.setIdCardPhotoPath(c.getString(c.getColumnIndex("id_card_photo_path"))); 
            item.setCreateTime(c.getString(c.getColumnIndex("create_time"))); 
        } 
        c.close(); 
        db.endTransaction(); 
        return item; 
    } 
 
    public OfflineAttenderRegisterItem readOfflineAttenderRegister() { 
        return null; 
    } 
 
    public void removeOfflineVisitorRegister(OfflineVisitorRegisterItem item) { 
        try { 
            String sql = "delete from offline_visitor_register where visitor_id='"+item.getVisitorId()+"'"; 
            SQLiteDatabase db = Config.sqlMap.getDb(); 
            db.beginTransaction(); 
            db.execSQL(sql); 
            db.endTransaction(); 
            item.deleteFiles(); 
        } 
        catch (Exception e) { 
            e.printStackTrace(); 
        } 
    } 
 
}