From e8ceda6276728449f11dbd768cacd122a23eb721 Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期六, 22 七月 2017 15:25:14 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java | 57 ++++++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 40 insertions(+), 17 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java
index 617a886..58159d4 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java
@@ -16,7 +16,7 @@
import cn.com.basic.face.discern.entity.Visit;
import cn.com.basic.face.discern.entity.VisitDetail;
import cn.com.basic.face.discern.query.item.CheckInQueryItem;
-
+import cn.com.basic.face.discern.query.item.OfflineVisitItem;
public class CheckInDao extends BaseDao{
@@ -113,26 +113,49 @@
/**
* 娣诲姞璁垮璁板綍
- * @param params
*/
- public void add(RequestParams params) {
- params.getStringParameter(Visit.FieldNames.visitReasonId);
- params.getStringParameter(Visit.FieldNames.visitReason);
- params.getStringParameter(Visit.FieldNames.remark);
- params.getStringParameter(Visit.FieldNames.visitorId);
- params.getStringParameter(Visit.FieldNames.visiteeId);
- params.getStringParameter(Visit.FieldNames.visitorCompanyId);
- params.getStringParameter(Visit.FieldNames.visiteeCompanyId);
- params.getStringParameter(Visit.FieldNames.enterTime);
- params.getStringParameter(Visit.FieldNames.currentStateId);
- params.getStringParameter(Visit.FieldNames.warning);
- params.getStringParameter(VisitDetail.FieldNames.stateId);
- params.getStringParameter(VisitDetail.FieldNames.createTime);
- params.getStringParameter(VisitDetail.FieldNames.deviceId);
+ public void add(OfflineVisitItem entity) {
+ String sql =
+ "INSERT INTO visit (\n" +
+ " visit_id,\n" +
+ " visit_reason_id,\n" +
+ " remark,\n" +
+ " enter_time,\n" +
+ " exit_time,\n" +
+ " visitor_type_id,\n" +
+ " visitor_id,\n" +
+ " visitor_company_id,\n" +
+ " visitee_id,\n" +
+ " visitee_company_id,\n" +
+ " current_state_id,\n" +
+ " warning,\n" +
+ " update_time,\n" +
+ " is_synchron,\n" +
+ " device_company_id\n" +
+ ")\n" +
+ "VALUES\n" +
+ " (\n" +
+ " '"+entity.getVisitId()+"', "+
+ " '"+entity.getVisitReasonId()+"', "+
+ " '"+entity.getRemark()+"', "+
+ " '"+entity.getEnterTime()+"', "+
+ " '"+entity.getExitTime()+"', "+
+ " '"+entity.getVisitorTypeId()+"', "+
+ " '"+entity.getVisitorId()+"', "+
+ " '"+entity.getVisitorCompanyId()+"', "+
+ " '"+entity.getVisiteeId()+"', "+
+ " '"+entity.getVisiteeCompanyId()+"', "+
+ " '"+entity.getCurrentStateId()+"', "+
+ " '"+entity.getWarning()+"', "+
+ " '"+entity.getUpdateTime()+"', "+
+ " '"+entity.getIsSynchron()+"', "+
+ " '"+entity.getDeviceCompanyId()+"' "+
+ " )";
+ MainActivity.getInstance().db.execSQL(sql);
}
public boolean hasOfflineCheckInData() {
- Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from visit", new String[]{});
+ Cursor c = MainActivity.getInstance().db.rawQuery("select count(*) from visit", new String[]{});
c.moveToFirst();
return c.getInt(0) > 0 ? true : false;
}
--
Gitblit v1.8.0