xuxiuxi

2017-07-21 ec544e9cc330ce40aeb78e96aa362e245feecd4d

 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java

@@ -50,7 +50,6 @@
                    .append(" LEFT JOIN register b ON a.register_id = b.register_id ")

                    .append(" LEFT JOIN dictionary d ON d.dict_id = b.gender_id ")

                    .append(" LEFT JOIN post e ON e.post_id = b.post_id ")

                    .append(" LEFT JOIN post e ON e.post_id = b.post_id ")

                    .append(" LEFT JOIN department f ON f.dept_id = b.department_id ")

                    .append(" WHERE ").append(" 1 = 1 ").append(" GROUP BY b.register_id ")

                    .append(" ORDER BY b.username ");

@@ -81,7 +80,7 @@
            }

            Integer total = null;

            while (c_count.moveToNext()) {

                total = c.getInt(c.getColumnIndex("register_id"));

                total = c.getInt(c.getColumnIndex("count"));

            }

            resultBean.setTotalPages(getTotalPageSize(total));

            resultBean.setPageNum(pageNum);

@@ -139,7 +138,7 @@
            }

            Integer total = null;

            while (c_count.moveToNext()) {

                total = c.getInt(c.getColumnIndex("register_id"));

                total = c.getInt(c.getColumnIndex("count"));

            }

            c.close();

            c_count.close();