| | |
|---|
| | | * @return
|
|---|
| | | */
|
|---|
| | | public boolean add(RequestParams params, String idCardHeadPhoto) {
|
|---|
| | | OfflineVisitorRegisterItem item = null;
|
|---|
| | | 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;
|
|---|
| | | }
|
|---|
| | |
|
|---|
