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/SurveillanceDao.java | 14 +++++++++++--- 1 files changed, 11 insertions(+), 3 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 0f9e427..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 @@ -44,9 +44,7 @@ cameraInOrOut + "','" + createTime + "'" +")" ); - UnknownSurveillanceQueryItemUtil.getInstance().addItems(bitmapList); - readOfflineUnknownFromLocal(); } catch (Exception e) { e.printStackTrace(); } @@ -77,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