xuxiuxi

2017-07-26 b1793f4381ec6f66390afaae0c2314db711ff1ed

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

@@ -46,7 +46,7 @@
                    .append(" LEFT JOIN dictionary l on l.dict_id=i.current_state_id ")

                    .append(" WHERE ").append(" 1 = 1 AND a.register_id IS NOT NULL ");

            if(searchText != null && !searchText.trim().isEmpty()) {

                sb.append(" AND b.username LIKE '%").append(searchText).append("%'");

                sb.append(" AND a.username LIKE '%").append(searchText).append("%'");

            }

            sb.append(" ORDER BY i.enter_time desc ");

            StringBuilder count = new StringBuilder(sb.length());

@@ -62,23 +62,23 @@
                aqi.setUsername(c.getString(c.getColumnIndex("username")));

                aqi.setSurveillancePhoto(c.getString(c.getColumnIndex("surveillance_photo")));

                aqi.setIdentifyNum(c.getString(c.getColumnIndex("company_name")));

                aqi.setPostName(c.getString(c.getColumnIndex("tel")));

                aqi.setGender(c.getString(c.getColumnIndex("identify_num")));

                aqi.setTel(c.getString(c.getColumnIndex("tel")));

                aqi.setIdentifyNum(c.getString(c.getColumnIndex("identify_num")));

                aqi.setDeptName(c.getString(c.getColumnIndex("dept_name")));

                aqi.setRegisterId(c.getString(c.getColumnIndex("company_id")));

                aqi.setUsername(c.getString(c.getColumnIndex("post_name")));

                aqi.setSurveillancePhoto(c.getString(c.getColumnIndex("mobile_phone")));

                aqi.setIdentifyNum(c.getString(c.getColumnIndex("type")));

                aqi.setPostName(c.getString(c.getColumnIndex("gender")));

                aqi.setGender(c.getString(c.getColumnIndex("identity_type")));

                aqi.setDeptName(c.getString(c.getColumnIndex("birthday")));

                aqi.setRegisterId(c.getString(c.getColumnIndex("country_name")));

                aqi.setUsername(c.getString(c.getColumnIndex("visitee")));

                aqi.setSurveillancePhoto(c.getString(c.getColumnIndex("visit_reason")));

                aqi.setIdentifyNum(c.getString(c.getColumnIndex("enter_time")));

                aqi.setPostName(c.getString(c.getColumnIndex("exit_time")));

                aqi.setGender(c.getString(c.getColumnIndex("current_status")));

                aqi.setDeptName(c.getString(c.getColumnIndex("id_card_photo")));

                aqi.setCompanyId(c.getString(c.getColumnIndex("company_id")));

                aqi.setPostName(c.getString(c.getColumnIndex("post_name")));

                aqi.setMobilePhone(c.getString(c.getColumnIndex("mobile_phone")));

                aqi.setType(c.getString(c.getColumnIndex("type")));

                aqi.setGender(c.getString(c.getColumnIndex("gender")));

                aqi.setIdentityType(c.getString(c.getColumnIndex("identity_type")));

                aqi.setBirthday(c.getString(c.getColumnIndex("birthday")));

                aqi.setCountryName(c.getString(c.getColumnIndex("country_name")));

                aqi.setVisitee(c.getString(c.getColumnIndex("visitee")));

                aqi.setVisitReason(c.getString(c.getColumnIndex("visit_reason")));

                aqi.setEnterTime(c.getString(c.getColumnIndex("enter_time")));

                aqi.setExitTime(c.getString(c.getColumnIndex("exit_time")));

                aqi.setCurrentStatus(c.getString(c.getColumnIndex("current_status")));

                aqi.setIdCardPhoto(c.getString(c.getColumnIndex("id_card_photo")));

                list.add(aqi);

            }

            Integer total = null;