Failed commit: Default

sujinwen

2017-07-25 8f003b35b74d5e84db192376b49404ae7666aa01

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

@@ -39,8 +39,16 @@
    }



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

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

         return c.getCount();

    }



}