xuxiuxi

2017-08-01 e09e9f8a34cbc99a33dfa9ef1792b0025575c3a8

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

@@ -105,9 +105,9 @@
    public List<Visit>  getVisitList(String deviceCompanyId) {

        List<Visit> list=new ArrayList<Visit>();

        Visit visit=null;

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

        String sql="select * from visit where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId) + " limit 0, 50";

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

        if(c.moveToFirst()){

        while (c.moveToNext()){

            visit=new Visit();

            visit.setVisitId(c.getString(c.getColumnIndex("visit_id")));

            visit.setVisitReasonId(c.getString(c.getColumnIndex("visit_reason_id")));

@@ -129,14 +129,15 @@
            visit.setVisitReason(c.getString(c.getColumnIndex("visit_reason")));

            list.add(visit);

        }

          return  list;

        return  list;

    }



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

    public void delVisitList(){

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

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



    public void delVisitList(List<Visit> list){

        for (Visit item : list) {

            String sql="delete from visit where is_synchron='N' and visit_id='"+item.getVisitId()+"'";

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

        }

    }



    //获取未同步数据总数