xuxiuxi

2017-07-21 dc49680d28bffdba2168671e967e8a11988960ba

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

@@ -30,22 +30,27 @@
        if (bitmapList == null || bitmapList.size() == 0) {

            return;

        }

        SQLiteDatabase db = null;

        try {

        String rawDataFileName = UUID.randomUUID().toString()+"";

        FileUtil.writeToFile(rawDataFileName, rawData);

        String headPicture = "";

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        String createTime = sdf.format(new Date());

        String sql = "insert offline_unknown(raw_data_path, camera_in_or_out, create_time) values('"+

            String sql = "insert into offline_surveillance(raw_data_path, camera_in_or_out, create_time) values('" +

                rawDataFileName+"','"+

                cameraInOrOut+"','"+

                createTime+"','"+

                "null" +"')";

        SQLiteDatabase db = Config.sqlMap.getDb();

                    createTime + "'" +")";

            db = Config.sqlMap.getDb();

        db.beginTransaction();

        db.execSQL(sql);

        db.endTransaction();



        UnknownSurveillanceQueryItemUtil.getInstance().addItems(bitmapList);



            readOfflineUnknownFromLocal();

        } catch (Exception e) {

            e.printStackTrace();

        }



        //人员注册可以选择本地图片

        //同步临时表

@@ -57,7 +62,7 @@


    public UnknownQueryItem readOfflineUnknownFromLocal() {

        UnknownQueryItem item = null;

        String sql = "select raw_data_path,camera_in_or_out,create_time from offline_unknown order by create_time create_time limit 1";

        String sql = "select raw_data_path,camera_in_or_out,create_time from offline_surveillance order by create_time limit 1";

        SQLiteDatabase db = Config.sqlMap.getDb();

        db.beginTransaction();

        Cursor c = db.rawQuery(sql, new String[]{});