xuxiuxi
2017-07-22 ad2575022f1a06f267b34c21bb99f6f83ea70854
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java
@@ -6,7 +6,7 @@
import java.util.ArrayList;
import java.util.List;
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.AttendanceQueryItem;
@@ -26,8 +26,7 @@
     */
    public ResultBean findLeftVisitorList(String searchText, int pageNum) {
        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 a.register_id,a.username,a.surveillance_photo,d.company_name,a.tel,a.identify_num,b.dept_name,")
@@ -88,13 +87,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;
    }