From 260206f45cce3d1238568af29d6410bf19facd7e Mon Sep 17 00:00:00 2001 From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674> Date: 星期一, 24 七月 2017 18:03:37 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 deletions(-) diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java index f8ff6d0..400269f 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java @@ -75,11 +75,21 @@ if (file.exists()) { file.delete(); } - MainActivity.getInstance().db.execSQL("delete from offline_unknown where raw_data_path='"+item.getRawDataPath()+"'"); + MainActivity.getInstance().db.execSQL("delete from offline_surveillance where raw_data_path='"+item.getRawDataPath()+"'"); } catch (Exception e) { e.printStackTrace(); } } + public boolean hasMoreOfflineSurveillance() { + boolean hasMore = false; + String sql = "select count(*) from offline_surveillance order by create_time "; + Cursor c = MainActivity.getInstance().db.rawQuery(sql, new String[]{}); + if (c.moveToFirst()) { + hasMore = c.getInt(0) > 0; + } + return hasMore; + } + } -- Gitblit v1.8.0