sujinwen

2017-07-24 8c1533ecbf59fc04d684bf610e978bb4165db6d5

git-svn-id: http://192.168.1.226/svn/proxy@864 454eff88-639b-444f-9e54-f578c98de674

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

@@ -43,4 +43,12 @@
        String sql="delete from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);

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

    }



    //获取未同步数据总数

    public int  getSynDataCount(){

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

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

         return c.getCount();

    }



}


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

@@ -179,6 +179,11 @@


    }





    //获取未同步数据总数

    public int  getSynDataCount(){

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

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

        return c.getCount();

    }



}


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

@@ -172,7 +172,12 @@
     MainActivity.getInstance().db.execSQL(sql);



 }



    //获取未同步数据总数

    public int  getSynDataCount(){

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

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

        return c.getCount();

    }



 }