| | |
|---|
| | |
|
|---|
| | | /**
|
|---|
| | | * 访客注册
|
|---|
| | | * @param params
|
|---|
| | | * @param idCardHeadPhoto
|
|---|
| | | * @return
|
|---|
| | | */
|
|---|
| | | public boolean add(RequestParams params, String idCardHeadPhoto) {
|
|---|
| | | public boolean add(OfflineVisitorRegisterItem item) {
|
|---|
| | | String sql =
|
|---|
| | | "INSERT INTO offline_visitor_register (\n" +
|
|---|
| | | " visitor_id,\n" +
|
|---|
| | | " username,\n" +
|
|---|
| | | " mobile_phone,\n" +
|
|---|
| | | " gender_id,\n" +
|
|---|
| | | " identity_type_id,\n" +
|
|---|
| | | " country_id,\n" +
|
|---|
| | | " visitor_type_id,\n" +
|
|---|
| | | " identify_num,\n" +
|
|---|
| | | " company_id,\n" +
|
|---|
| | | " birthday,\n" +
|
|---|
| | | " remark,\n" +
|
|---|
| | | " raw_surveillance_photo_path,\n" +
|
|---|
| | | " raw_surveillance_photo_width,\n" +
|
|---|
| | | " raw_surveillance_photo_height,\n" +
|
|---|
| | | " surveillance_photo_path,\n" +
|
|---|
| | | " upload_custom_photo_path,\n" +
|
|---|
| | | " id_card_photo_path,\n" +
|
|---|
| | | " create_time\n" +
|
|---|
| | | ")\n" +
|
|---|
| | | "VALUES\n" +
|
|---|
| | | " (\n" +
|
|---|
| | | " null,\n" +
|
|---|
| | | " '"+item.getUsername()+"',\n" +
|
|---|
| | | " '"+item.getMobilePhone()+"',\n" +
|
|---|
| | | " '"+item.getGenderId()+"',\n" +
|
|---|
| | | " '"+item.getIdentityTypeId()+"',\n" +
|
|---|
| | | " '"+item.getCountryId()+"',\n" +
|
|---|
| | | " '"+item.getVisitorTypeId()+"',\n" +
|
|---|
| | | " '"+item.getIdentifyNum()+"',\n" +
|
|---|
| | | " '"+item.getCompanyId()+"',\n" +
|
|---|
| | | " '"+item.getBirthday()+"',\n" +
|
|---|
| | | " '"+item.getRemark()+"',\n" +
|
|---|
| | | " '"+item.getRawSurveillancePhotoPath()+"',\n" +
|
|---|
| | | " '"+item.getRawSurveillancePhotoWidth()+"',\n" +
|
|---|
| | | " '"+item.getRawSurveillancePhotoHeight()+"',\n" +
|
|---|
| | | " '"+item.getSurveillancePhotoPath()+"',\n" +
|
|---|
| | | " '"+item.getUploadCustomPhotoPath()+"',\n" +
|
|---|
| | | " '"+item.getIdCardPhotoPath()+"',\n" +
|
|---|
| | | " '"+item.getCreateTime()+"'\n" +
|
|---|
| | | " )";
|
|---|
| | | SQLiteDatabase db = Config.sqlMap.getDb();
|
|---|
| | | db.beginTransaction();
|
|---|
| | | db.execSQL(sql);
|
|---|
| | | db.endTransaction();
|
|---|
| | | return true;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | |
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public boolean hasOfflineVisitorRegisterData() {
|
|---|
| | | Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from register", new String[]{});
|
|---|
| | | Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from offline_visitor_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[]{});
|
|---|
| | | Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from offline_attender_register", new String[]{});
|
|---|
| | | c.moveToFirst();
|
|---|
| | | return c.getInt(0) > 0 ? true : false;
|
|---|
| | | }
|
|---|
