예제 #1
0
 public long count(AdminAccountQuery query) {
   AdminAccountExample example = new AdminAccountExample();
   Criteria criteria = example.createCriteria();
   criteria.andStatEqualTo(DataStatus.ENABLED);
   if (StringUtils.isNotEmpty(query.getAccountCode())) {
     criteria.andUserNameEqualTo(query.getAccountCode());
   }
   if (StringUtils.isNotEmpty(query.getRoleId())) {
     criteria.andRoleIdEqualTo(query.getRoleId());
   }
   return mapper.countByExample(example);
 }
예제 #2
0
 public List<AdminAccount> find(AdminAccountQuery query, PageQuery page) {
   AdminAccountExample example = new AdminAccountExample();
   Criteria criteria = example.createCriteria();
   criteria.andStatEqualTo(DataStatus.ENABLED);
   if (StringUtils.isNotEmpty(query.getAccountCode())) {
     criteria.andUserNameEqualTo(query.getAccountCode());
   }
   if (StringUtils.isNotEmpty(query.getRoleId())) {
     criteria.andRoleIdEqualTo(query.getRoleId());
   }
   example.setOrderByClause(
       " create_time asc limit " + page.getStartNum() + ", " + page.getPageSize());
   return mapper.selectByExample(example);
 }