xuxiuxi

2017-08-01 e09e9f8a34cbc99a33dfa9ef1792b0025575c3a8

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

@@ -8,6 +8,7 @@
import java.util.List;



import cn.com.basic.face.base.MainActivity;

import cn.com.basic.face.discern.common.CommonVariables;

import cn.com.basic.face.discern.entity.Register;

import cn.com.basic.face.discern.query.item.OfflineAttenderRegisterItem;

import cn.com.basic.face.discern.query.item.OfflineVisitorRegisterItem;

@@ -314,9 +315,9 @@
    public List<Register>  getRegisterList(String deviceCompanyId){

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

        Register result=null;

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

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

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

        if(c.moveToFirst()){

        while(c.moveToNext()){

            result=new Register();

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

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

@@ -329,6 +330,8 @@
            result.setCity(c.getString(c.getColumnIndex("city")));

            result.setBirthday(c.getString(c.getColumnIndex("birthday")));

            result.setTel(c.getString(c.getColumnIndex("tel")));

            result.setCompany(c.getString(c.getColumnIndex("company")));

            result.setVisitorOrAttender(c.getString(c.getColumnIndex("visitor_or_attender")));

            result.setMobilePhone(c.getString(c.getColumnIndex("mobile_phone")));

            result.setIdentityTypeId(c.getString(c.getColumnIndex("identity_type_id")));

            result.setIdentifyNum(c.getString(c.getColumnIndex("identify_num")));

@@ -358,9 +361,11 @@
    }



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

    public void delRegiterList(){

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

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

    public void delRegiterList(List<Register> list){

        for (Register item : list) {

            String sql="delete from register where is_synchron='N' and register_id='"+item.getRegisterId()+"'";

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

        }

    }



    //获取未同步数据总数