From b80534b85b8cd065505145fdb913978b38da9548 Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期四, 20 七月 2017 12:35:08 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
index ad0fc73..185a2fc 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
@@ -27,6 +27,52 @@
* @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;
}
--
Gitblit v1.8.0