/**
* 分页查询
*
* @param phonenum
* @param start
* @param limit
* @return
*/
public List<TmpGprs> search(String phonenum, String loginName, int start, int limit)
throws Exception {
Cnd condition = null;
if (null != phonenum && !"".equals(phonenum)) {
condition =
Cnd.where("d_phone_number", "=", phonenum)
.and("d_uid", "=", loginName.replace("weinan2", "weinan1"));
// if(null != loginName && !"".equals(loginName)){
// if(loginName.equals("weinan1")){
// condition.and("d_id","<","2368");
// }else if(loginName.equals("weinan2")){
// condition.and("d_id",">","2367").and("d_id","<","4736");
// }else if(loginName.equals("weinan3")){
// condition.and("d_id",">","4735").and("d_id","<","7103");
// }else if(loginName.equals("weinan5")){
// condition.and("d_id",">","7102");
// }
// }
start = start / limit + 1;
if (start == 0) {
start = 1;
}
List<TmpGprs> list = tmpGprsDao.searchByPage(TmpGprs.class, condition, start, limit);
return list;
} else {
return null;
}
}
/**
* 分页查询
*
* @param phonenum
* @param start
* @param limit
* @return
*/
public List<TmpGprs> search(String phonenum, int start, int limit) throws Exception {
Cnd condition = null;
if (null != phonenum && !"".equals(phonenum)) {
condition = Cnd.where("d_phone_number", "=", phonenum);
}
start = start / limit + 1;
if (start == 0) {
start = 1;
}
List<TmpGprs> list = tmpGprsDao.searchByPage(TmpGprs.class, condition, start, limit);
return list;
}
/**
* 分页查询
*
* @param phonenum
* @param start
* @param limit
* @return
*/
public List<TmpGprs> search(
String bdcode, String phonenum, String loginName, int start, int limit) throws Exception {
Cnd condition = null;
if (null != phonenum && !"".equals(phonenum)) {
condition =
Cnd.where("d_phone_number", "=", phonenum)
.and("d_uid", "=", loginName.replace("weinan2", "weinan1"))
.and("", "=", bdcode);
start = start / limit + 1;
if (start == 0) {
start = 1;
}
List<TmpGprs> list = tmpGprsDao.searchByPage(TmpGprs.class, condition, start, limit);
return list;
} else {
return null;
}
}