From 0a681611c0b0278e03e6da031c37a28d2973b7b2 Mon Sep 17 00:00:00 2001 From: sujinwen <sujinwen@454eff88-639b-444f-9e54-f578c98de674> Date: 星期一, 24 七月 2017 15:30:50 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java | 45 +-------------------------------------------- 1 files changed, 1 insertions(+), 44 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 3cf4048..4f21f6c 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 @@ -112,56 +112,13 @@ } } - /** - * 娣诲姞璁垮璁板綍 - */ - 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 = MainActivity.getInstance().db.rawQuery("select count(*) from visit", new String[]{}); c.moveToFirst(); return c.getInt(0) > 0 ? true : false; } - public ResultBean findCheckInLeftVisitorListByVisitorId(long registerId) { + public ResultBean findCheckInLeftVisitorListByVisitorId(String registerId) { SQLiteDatabase db = MainActivity.getInstance().db; ResultBean resultBean = new ResultBean(); try { -- Gitblit v1.8.0