xuxiuxi

2017-07-25 d343b71cd89f59a87e85c46ce7a04d47c357462d

 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java

@@ -44,7 +44,6 @@
                            cameraInOrOut + "','" +

                            createTime + "'" +")"

            );

            UnknownSurveillanceQueryItemUtil.getInstance().addItems(bitmapList);



        } catch (Exception e) {

            e.printStackTrace();

@@ -76,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;

    }



}