xuxiuxi

2017-07-26 54b23ebcea16ba422afd595bcaf04d0b7cb6407c

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

@@ -166,6 +166,8 @@
            device.setType(c.getString(c.getColumnIndex("type")));

            device.setSchoolName(c.getString(c.getColumnIndex("school_name")));

            device.setScrappedDate(c.getString(c.getColumnIndex("scrapped_date")));

            device.setIsValid(c.getString(c.getColumnIndex("is_valid")));

            device.setCreateTime(c.getString(c.getColumnIndex("create_time")));

            result.add(device);

        }

        return result;

@@ -173,12 +175,18 @@




    //删除已经上传到服务器的同步数据

    public void delDevice(String deviceCompanyId){

        String sql="delete from device where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);

    public void delDevice(){

        String sql="delete from device where is_synchron='N'";

        MainActivity.getInstance().db.execSQL(sql);



    }





    //获取未同步数据总数

    public int  getSynDataCount(){

        String sql="select count(*) from device where is_synchron='N' ";

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

        c.moveToFirst();

        return c.getInt(0);

    }



}