From e914b1710eced9226539d86b72c92a02f8939ccb Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期五, 28 七月 2017 15:24:23 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java | 13 ++++++++-----
1 files changed, 8 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..3819410 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")));
@@ -358,9 +359,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