@Override
 public UserResult getUserByName(String loginname) {
   UserResult ur = new UserResult();
   try {
     if (!StringUtils.isBlank(loginname)) {
       User user = userService.findByLoginName(loginname);
       if (user != null) {
         if (user.getUsertype() == 2) {
           BusinessUserDetail businessUserdetail =
               businessUserDetailService.findByUserId(user.getId());
           BusinessUserEntity businessUserVO =
               ConvertHelper.toBusinessUserEntity(user, businessUserdetail);
           ur.setBusinessUser(businessUserVO);
         } else {
           UserDetail userdetail = userDetailService.findByUserId(user.getId());
           UserEntity userVO = ConvertHelper.toUserEntity(user, userdetail);
           ur.setUser(userVO);
         }
       }
     }
     ur.setErrorCode(0);
     ur.setErrorMessage("");
   } catch (Exception ex) {
     ValidationError ve = ValidationError.SYSTEM_ERROR;
     ur.setErrorCode(ve.getErrorCode());
     ur.setErrorMessage("系统错误");
     logger.error(ex.getMessage());
   }
   return ur;
 }
 /*
  * 输入用户id,用户名都可以
  */
 private UserRemarkEntity refactorUserRemarkEntity(UserRemarkEntity remark) {
   UserRemarkEntity result = new UserRemarkEntity();
   Integer userId = 0;
   Integer friendId = 0;
   if (remark != null) {
     if (remark.getUserName() != null && (remark.getUserId() == null || remark.getUserId() == 0)) {
       User user = userService.findByLoginName(remark.getUserName());
       if (user != null) {
         userId = user.getId();
       }
     } else {
       userId = remark.getUserId();
     }
     if (remark.getFriendUserName() != null
         && (remark.getFriendId() == null || remark.getFriendId() == 0)) {
       User fUser = userService.findByLoginName(remark.getFriendUserName());
       if (fUser != null) {
         friendId = fUser.getId();
       }
     } else {
       friendId = remark.getFriendId();
     }
   }
   result.setUserId(userId);
   result.setFriendId(friendId);
   return result;
 }
 private boolean isContain(List<User> users, Integer userId) {
   if (users != null && users.size() > 0) {
     for (User user : users) {
       if (user.getId().equals(userId)) {
         return true;
       }
     }
   }
   return false;
 }
 @Override
 public UserResult getUserAndRemark(RemarkQueryCondition condition) {
   UserResult ur = new UserResult();
   try {
     User user = null;
     if (condition != null && condition.getFriendId() != null && condition.getFriendId() > 0) {
       Integer friendId = condition.getFriendId();
       user = userService.findById(friendId);
     }
     if (condition != null && !StringUtils.isBlank(condition.getFriendLoginName())) {
       String loginname = condition.getFriendLoginName();
       user = userService.findByLoginName(loginname);
     }
     if (user != null) {
       UserDetail userdetail = userDetailService.findByUserId(user.getId());
       UserEntity userVO = ConvertHelper.toUserEntity(user, userdetail);
       Integer friendId = 0;
       if (condition != null && condition.getFriendId() != null && condition.getFriendId() > 0) {
         friendId = condition.getFriendId();
       } else {
         friendId = user.getId();
       }
       Integer userId = 0;
       if (condition != null
           && condition.getUserName() != null
               & (condition.getUserId() == null || condition.getUserId() == 0)) {
         User userself = userService.findByLoginName(condition.getUserName());
         if (userself != null) {
           userId = userself.getId();
         }
       } else {
         userId = condition.getUserId();
       }
       if (userId > 0 && friendId > 0) {
         List<UserRemark> userRemarks =
             userRemarkService.find(
                 " from UserRemark where userId=" + userId + " and friendId=" + friendId);
         UserRemark userRemark = null;
         if (userRemarks != null && userRemarks.size() > 0) {
           userRemark = userRemarks.get(0);
           userVO.setRemark(userRemark.getRemark());
         }
       }
       ur.setUser(userVO);
     }
     ur.setErrorCode(0);
     ur.setErrorMessage("");
   } catch (Exception ex) {
     ValidationError ve = ValidationError.SYSTEM_ERROR;
     ur.setErrorCode(ve.getErrorCode());
     ur.setErrorMessage("系统错误");
     logger.error(ex.getMessage());
   }
   return ur;
 }
  /** 登录服务 return UserResult */
  @Override
  public UserResult login(UserEntity user) {
    UserResult ur = new UserResult();
    try {
      String username = user.getLoginname();
      String password = MD5Util.md5(user.getPwd());
      User u = null;
      u = userService.findByLoginNameAndPwd(username, password);
      if (u == null) {
        ValidationError er = ValidationError.LOGINFAILE;
        int errorCode = er.getErrorCode();
        String errorMessage = er.getErrorMessage();
        ur.setErrorCode(errorCode);
        ur.setErrorMessage(errorMessage);

      } else {
        if (u.getUsertype() == 2) {
          BusinessUserDetail businessUserdetail = businessUserDetailService.findByUserId(u.getId());
          BusinessUserEntity businessUserVO =
              ConvertHelper.toBusinessUserEntity(u, businessUserdetail);
          ur.setBusinessUser(businessUserVO);
        } else {
          UserDetail userdetail = userDetailService.findByUserId(u.getId());
          UserEntity userVO = ConvertHelper.toUserEntity(u, userdetail);
          ur.setUser(userVO);
        }
        ur.setErrorCode(0);
        ur.setErrorMessage("");
      }
    } catch (Exception ex) {
      ValidationError er = ValidationError.SYSTEM_ERROR;
      ur.setErrorCode(er.getErrorCode());
      ur.setErrorMessage("系统错误");
      logger.error(ex.getMessage());
    }
    return ur;
  }
  @Override
  public QueryUsersResult quickSearchUser(QueryCondition condition) {
    QueryUsersResult result = null;
    try {
      List<UserEntity> userList = new ArrayList<UserEntity>();
      System.out.println("query pageNumber is =" + condition.getPageNum());
      int pageSize = condition.getPageSize();
      if (pageSize < 1) {
        pageSize = 1;
      }
      int curNum = condition.getPageNum();
      if (curNum < 1) {
        curNum = 1;
      }
      String sql = "where ";
      if (condition.getKey() != null) {
        sql +=
            " (loginname like '%"
                + condition.getKey().trim()
                + "%' or name like '%"
                + condition.getKey().trim()
                + "%' or realname like '%"
                + condition.getKey().trim()
                + "%') and";
      }
      if (condition.getUsertype() != null) {
        sql += " usertype =" + condition.getUsertype() + " and";
      }
      sql = sql.substring(0, sql.length() - 3);
      String searchSql = "";
      if (sql.length() > 8) {
        searchSql = "from User " + sql;
      } else {
        searchSql = "from User";
      }
      List<User> users = userService.find(searchSql, curNum, pageSize);
      try {
        if (users != null && users.size() > 0) {
          for (User user : users) {

            UserDetail userdetail = userDetailService.findByUserId(user.getId());
            UserEntity userInfo = ConvertHelper.toUserEntity(user, userdetail);
            userList.add(userInfo);
          }
        }
      } catch (Exception e1) {
        e1.printStackTrace();
      }
      if (condition.getPageNum() == 1) {
        List<UserDetail> userDetails =
            userDetailService.find("from UserDetail where room='" + condition.getKey() + "'");
        if (userDetails != null && userDetails.size() > 0) {
          for (UserDetail userDetail : userDetails) {
            if (!isContain(users, userDetail.getUserid())) {
              User user = userService.findById(userDetail.getUserid());
              UserEntity userInfo = ConvertHelper.toUserEntity(user, userDetail);
              userList.add(userInfo);
            }
          }
        }
      }
      System.out.println("get all users");
      result = new QueryUsersResult(0, "", userList, userList.size());
      return result;
    } catch (Exception e) {
      result = new QueryUsersResult(-1, "系统错误!", null, 0);
      return result;
    }
  }
 @Override
 public UserResult register(UserEntity user) {
   UserResult ur = new UserResult();
   try {
     if (user != null) {
       String loginName = user.getLoginname();
       // 检查登录名是否重复
       boolean res = chekLoginName(loginName);
       if (!res) {
         User usr = new User();
         String pwd = "";
         if (user.getPwd() != null) {
           pwd = MD5Util.md5(user.getPwd());
           usr.setPlainPassword(user.getPwd());
         }
         usr.setCreateDate(new Date());
         usr.setLoginname(loginName);
         usr.setPwd(pwd);
         usr.setName(user.getName());
         usr.setPhone(user.getPhone());
         usr.setStatus(3);
         usr.setLat(user.getLat());
         usr.setLon(user.getLon());
         usr.setParseaddress(user.getParseaddress());
         usr.setUsertype(user.getUsertype());
         this.saveOrUpdate(usr);
         User userinfo = userService.findByLoginName(loginName);
         if (userinfo != null) {
           user.setId(userinfo.getId().toString());
         }
         user.setPwd("");
         user.setState(Constants.DEFAULT_STATE);
         user.setCity(Constants.DEFAULT_CITY);
         user.setSex(Constants.DEFAULT_SEX_VALUE);
         ur.setUser(user);
         ur.setErrorCode(0);
         ur.setErrorMessage("");
       } else {
         ValidationError ve = ValidationError.LOGINNAMEREPEAT;
         int errorCode = ve.getErrorCode();
         String message = Utils.getErrorMessage(ve);
         ur.setErrorCode(errorCode);
         ur.setErrorMessage(message);
       }
     }
   } catch (Exception ex) {
     ValidationError er = ValidationError.SYSTEM_ERROR;
     int errorCode = er.getErrorCode();
     ur.setErrorCode(errorCode);
     ur.setErrorMessage("系统错误");
     logger.error(ex.getMessage());
   }
   return ur;
 }
 @Override
 public QueryUsersResult getAllConditionUser(QueryCondition condition) {
   QueryUsersResult result = null;
   Map<Integer, String> remarkMap = new HashMap<Integer, String>();
   if (condition.getRemarkUserId() != null) {
     // 获取所有好友的remark信息
     List<UserRemark> userRemarks =
         userRemarkService.find(" from UserRemark where userId=" + condition.getRemarkUserId());
     if (userRemarks != null && userRemarks.size() > 0) {
       for (int i = 0; i < userRemarks.size(); i++) {
         UserRemark userRemark = userRemarks.get(i);
         remarkMap.put(userRemark.getFriendId(), userRemark.getRemark());
       }
     }
   }
   // 先查询航班号
   String hsql = "from User order by createDate desc";
   List<User> husers = userService.find(hsql, 1, 5);
   String voyagId = null;
   if (husers != null && husers.size() > 0) {
     voyagId = husers.get(0).getVoyagId();
   }
   try {
     List<UserEntity> userList = new ArrayList<UserEntity>();
     String phone = condition.getPhone();
     System.out.println("query pageNumber is =" + condition.getPageNum());
     int pageSize = condition.getPageSize();
     if (pageSize < 1) {
       pageSize = 1;
     }
     int curNum = condition.getPageNum();
     if (curNum < 1) {
       curNum = 1;
     }
     String sql = "where ";
     if (condition.getUserName() != null && !condition.getUserName().isEmpty()) {
       sql += " loginname like '%" + condition.getUserName() + "%' and";
     }
     if (condition.getName() != null && !condition.getName().isEmpty()) {
       sql += " name like '%" + condition.getName() + "%' and";
     }
     if (condition.getCountry() != null && !condition.getCountry().isEmpty()) {
       sql += " country='" + condition.getCountry() + "' and";
     }
     if (condition.getPhone() != null && !condition.getPhone().isEmpty()) {
       sql += " phone='" + condition.getPhone() + "' and";
     }
     if (condition.getArea() != null && !condition.getArea().isEmpty()) {
       sql += " area ='" + condition.getArea() + "' and";
     }
     if (condition.getAgeStart() > 0) {
       sql += " age >" + condition.getAgeStart() + " and";
     }
     if (condition.getAgeEnd() > 0) {
       sql += " age <" + condition.getAgeEnd() + " and";
     }
     if (condition.getSex() > 0) {
       sql += " sex =" + condition.getSex() + " and";
     }
     if (condition.getUsertype() != null) {
       sql += " usertype =" + condition.getUsertype() + " and";
     }
     sql = sql.substring(0, sql.length() - 3);
     String searchSql = "";
     if (sql.length() > 8) {
       if (StringUtils.isBlank(phone)) {
         searchSql = "from User " + sql + " and  cansearch=1";
       } else {
         searchSql = "from User " + sql + " and  cansearchbyphone=1";
       }
     } else {
       if (StringUtils.isBlank(phone)) {
         searchSql = "from User where  cansearch=1";
       } else {
         searchSql = "from User " + sql + " and  cansearchbyphone=1";
       }
     }
     if (condition.getUsertype() != null && condition.getUsertype().equals(1) && voyagId != null) {
       searchSql += " and voyagId='" + voyagId + "'";
     }
     List<User> users = userService.find(searchSql, curNum, pageSize);
     try {
       if (users != null && users.size() > 0) {
         for (User user : users) {
           UserDetail userdetail = userDetailService.findByUserId(user.getId());
           UserEntity userInfo = ConvertHelper.toUserEntity(user, userdetail);
           String remark = remarkMap.get(user.getId());
           if (remark != null) {
             userInfo.setRemark(remark);
           }
           userList.add(userInfo);
         }
       }
     } catch (Exception e1) {
       e1.printStackTrace();
     }
     System.out.println("get all users");
     result = new QueryUsersResult(0, "", userList, userList.size());
     return result;
   } catch (Exception e) {
     // TODO: handle exception
     result = new QueryUsersResult(-1, "系统错误!", null, 0);
     return result;
   }
 }
 private void updateUserCommon(
     String userid,
     String name,
     String phone,
     String boatcard,
     Integer cansearchbyphone,
     Integer hideroomtelephone,
     Integer cansearch,
     String realname,
     String room,
     Integer age) {
   User u = null;
   if (!StringUtils.isBlank(userid)) {
     u = userService.findById(Integer.valueOf(userid));
   }
   if (u != null) {
     if (StringUtils.isNotBlank(name)) {
       u.setName(name);
     }
     if (StringUtils.isNotBlank(phone)) {
       u.setPhone(phone);
     }
     if (StringUtils.isNotBlank(boatcard)) {
       u.setBoatcard(boatcard);
     }
     if (cansearchbyphone != null) {
       u.setCansearchbyphone(cansearchbyphone);
     }
     if (age != null) {
       u.setAge(age);
     }
     if (cansearch != null) {
       u.setCansearch(cansearch);
     }
     if (hideroomtelephone != null) {
       u.setHideroomtelephone(hideroomtelephone);
     }
     if (StringUtils.isNotBlank(realname)) {
       u.setRealname(realname);
       if (StringUtils.isBlank(u.getPinyinname())) {
         String pinyin = Utils.getPinYin(realname);
         if (StringUtils.isNotBlank(pinyin)) {
           u.setPinyinname(pinyin);
         }
         if (StringUtils.isBlank(u.getName())) {
           u.setName(pinyin);
         }
       }
     }
     if (StringUtils.isNotBlank(room)) {
       u.setRoomtelephone(room);
     }
     userService.saveOrUpdate(u);
   }
 }