From e09e9f8a34cbc99a33dfa9ef1792b0025575c3a8 Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 01 八月 2017 11:41:19 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java | 15 ++++++++-------
1 files changed, 8 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 6613ad6..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")));
@@ -129,14 +129,15 @@
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