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/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..49ad6d4 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' where visit_id='"+item.getVisitId()+"'";
+ MainActivity.getInstance().db.execSQL(sql);
+ }
}
//鑾峰彇鏈悓姝ユ暟鎹�绘暟
--
Gitblit v1.8.0