xuxiuxi

2017-08-01 785fd3c3e9984f301018b3b5deb91ecc2c8da124

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

@@ -19,10 +19,11 @@
        return instance;

    }



    //加载公司表

    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();

@@ -31,11 +32,26 @@
            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;



    }



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

    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);

    }



}