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/VisitDao.java | 16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java
index 474693e..cc8efb0 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java
+++ b/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")));
@@ -127,15 +127,17 @@
visit.setIsValid(c.getString(c.getColumnIndex("is_valid")));
visit.setCreateTime(c.getString(c.getColumnIndex("create_time")));
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);
+ }
}
//鑾峰彇鏈悓姝ユ暟鎹�绘暟
--
Gitblit v1.8.0