dupengyue
2017-07-21 a96129c2b6ef6d9ede992030ec1082ff25f2619c
调试接口添加

git-svn-id: http://192.168.1.226/svn/proxy@808 454eff88-639b-444f-9e54-f578c98de674
1个文件已修改
18 ■■■■ 已修改文件
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java 18 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
@@ -7,7 +7,7 @@
import java.util.List;
import cn.com.basic.face.base.BaseApplication;
import cn.com.basic.face.base.Config;
import cn.com.basic.face.base.MainActivity;
import cn.com.basic.face.discern.common.CommonVariables;
import cn.com.basic.face.discern.common.ResultBean;
import cn.com.basic.face.discern.query.item.AttendanceDetailQueryItem;
@@ -40,8 +40,7 @@
     */
    public ResultBean reloadLeftList(String searchText, final int pageNum, final boolean append) {
        ResultBean resultBean = new ResultBean();
        SQLiteDatabase db = Config.sqlMap.getDb();
        db.beginTransaction();
        SQLiteDatabase db = MainActivity.getInstance().db;
        try {
            StringBuilder sb = new StringBuilder(40);
            sb.append("SELECT b.register_id,").append(" b.username,").append(" b.surveillance_photo,")
@@ -85,13 +84,8 @@
            resultBean.setTotalPages(getTotalPageSize(total));
            resultBean.setPageNum(pageNum);
            resultBean.setData(list);
            c.close();
            c_count.close();
            db.setTransactionSuccessful();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            db.endTransaction();
        }
        return resultBean;
    }
@@ -101,8 +95,7 @@
     */
    public List<AttendanceDetailQueryItem> reloadAttendanceDetail(AttendanceQueryItem item) {
        List<AttendanceDetailQueryItem> list = new ArrayList();
        SQLiteDatabase db = Config.sqlMap.getDb();
        db.beginTransaction();
        SQLiteDatabase db = MainActivity.getInstance().db;
        try {
            StringBuilder sb = new StringBuilder(40);
            sb.append("SELECT a.time,").append(" b.device_name,").append(" case when a.attendance_type_id=305 then '签到'")
@@ -140,13 +133,8 @@
            while (c_count.moveToNext()) {
                total = c.getInt(c.getColumnIndex("count"));
            }
            c.close();
            c_count.close();
            db.setTransactionSuccessful();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            db.endTransaction();
        }
        return list;
    }