| | |
| | | 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;
|
| | |
| | | */
|
| | | 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,")
|
| | |
| | | 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;
|
| | | }
|
| | |
| | | */
|
| | | 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 '签到'")
|
| | |
| | | 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;
|
| | | }
|