From d343b71cd89f59a87e85c46ce7a04d47c357462d Mon Sep 17 00:00:00 2001 From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674> Date: 星期二, 25 七月 2017 15:46:45 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java | 14 +++++++++++++- 1 files changed, 13 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 1d432e5..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(); @@ -297,4 +297,16 @@ } 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