From 46a8044f3449c6e9a884c90477ada5a5e6879367 Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 01 八月 2017 17:37:39 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java | 15 ++++++++++-----
1 files changed, 10 insertions(+), 5 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
index 84aee6d..f5cb70c 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
+++ b/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);
+ }
}
//鑾峰彇鏈悓姝ユ暟鎹�绘暟
--
Gitblit v1.8.0