From d343b71cd89f59a87e85c46ce7a04d47c357462d Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 25 七月 2017 15:46:45 +0800
Subject: [PATCH] 

---
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java |    7 +++----
 1 files changed, 3 insertions(+), 4 deletions(-)

diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
index 63df3ec..cc508c8 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
@@ -79,7 +79,7 @@
             }
             Integer total = null;
             while (c_count.moveToNext()) {
-                total = c.getInt(c.getColumnIndex("count"));
+                total = c_count.getInt(0);
             }
             resultBean.setTotalPages(getTotalPageSize(total));
             resultBean.setPageNum(pageNum);
@@ -115,7 +115,7 @@
             if(deviceCompanyId != null && !deviceCompanyId.trim().isEmpty()) {
                 sb.append(" AND a.device_company_id = ").append(deviceCompanyId);
             }
-            sb.append("ORDER BY a.time DESC");
+            sb.append(" ORDER BY a.time DESC");
             StringBuilder count = new StringBuilder(sb.length());
             count.append("select count(*) as count from (").append(sb).append(" ) _table");
             sb.append(" LIMIT ").append("0").append(",").append(100);
@@ -131,13 +131,12 @@
             }
             Integer total = null;
             while (c_count.moveToNext()) {
-                total = c.getInt(c.getColumnIndex("count"));
+                total = c_count.getInt(0);
             }
         } catch (Exception e) {
             e.printStackTrace();
         }
         return list;
     }
-
 
 }

--
Gitblit v1.8.0