From 0e8fc8d9e8764432ffa2ef574b979f003fe4503b Mon Sep 17 00:00:00 2001 From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674> Date: 星期二, 25 七月 2017 13:52:56 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java | 13 ++++++++++++- 1 files changed, 12 insertions(+), 1 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 57aab24..e80d2a9 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 @@ -268,7 +268,7 @@ public void removeOfflineVisitorRegister(OfflineVisitorRegisterItem item) { try { - String sql = "delete from register where visitor_id='"+item.getRegisterId()+"' AND a.is_synchron = 'N'"; + String sql = "delete from register where visitor_id='"+item.getRegisterId()+"' AND a.is_synchron = 'N' and visitor_or_attender='visitor'"; SQLiteDatabase db = MainActivity.getInstance().db; db.execSQL(sql); item.deleteFiles(); @@ -298,4 +298,15 @@ return hasMore; } + public void removeOfflineAttenderRegister(OfflineAttenderRegisterItem item) { + try { + String sql = "delete from register where visitor_id='"+item.getRegisterId()+"' AND a.is_synchron = 'N' and visitor_or_attender='attender' "; + SQLiteDatabase db = MainActivity.getInstance().db; + db.execSQL(sql); + item.deleteFiles(); + } + catch (Exception e) { + e.printStackTrace(); + } + } } -- Gitblit v1.8.0