xuxiuxi

2017-08-01 e09e9f8a34cbc99a33dfa9ef1792b0025575c3a8

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

@@ -23,7 +23,7 @@
    public List<Company> getCompanyList( String deviceCompanyId){

        List<Company> result=new ArrayList<Company>();

        Company company=null;

        String sql="select * from company where is_synchron='N' and device_company_id="+deviceCompanyId;

        String sql="select * from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);

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

        if(c.moveToFirst()){

            company=new Company();

@@ -32,6 +32,8 @@
            company.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id")));

            company.setIsSynchron(c.getString(c.getColumnIndex("is_synchron")));

            company.setUpdateTime(c.getString(c.getColumnIndex("update_time")));

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

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

            result.add(company);

        }

        return result;

@@ -39,8 +41,17 @@
    }



    //删除已上传给你服务器的数据

    public void delCompanyList(String deviceCompanyId){

        String sql="delete from company where is_synchron='N' and device_company_id="+deviceCompanyId;

    public void delCompanyList(){

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

        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[]{});

        c.moveToFirst();

        return c.getInt(0);

    }



}