@Override
 public PagerModel<User> getPagerModel(User user, Query query) throws Exception {
   PagerModel<User> pm = userDao.getPagerModel(user, query);
   for (User ur : pm.getDatas()) {
     List<Role> list = this.userRoleDao.getRolesByUserId(ur.getId());
     if (list != null && list.size() > 0) {
       StringBuffer s = new StringBuffer();
       for (int i = 0, len = list.size(); i < len; i++) {
         if (i != 0) {
           s.append(",");
         }
         s.append(list.get(i).getName());
       }
       ur.setRoles(s.toString());
     }
   }
   return pm;
 }