@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;
 }
 /** 修改企业用户 */
 @Override
 public UserResult updateBusinessUser(BusinessUserEntity bu) {
   UserResult ur = new UserResult();
   try {
     if (bu != null) {
       BusinessUserDetail businessUserdetail = null;
       String id = bu.getId();
       int userid = 0;
       if (!StringUtils.isBlank(id)) {
         userid = Integer.parseInt(id);
         updateUserCommon(
             id, bu.getName(), bu.getPhone(), null, null, null, null, null, null, null);
         businessUserdetail = businessUserDetailService.findByUserId(userid);
       }
       if (userid > 0) {
         Date date = new Date();
         if (businessUserdetail == null) {
           businessUserdetail = new BusinessUserDetail();
           businessUserdetail.setUserid(userid);
           businessUserdetail.setCreateDate(date);
         }
         businessUserdetail.setAddress(bu.getAddress());
         businessUserdetail.setBusinesslicence(bu.getBusinesslicence());
         businessUserdetail.setContactor(bu.getContactor());
         businessUserdetail.setIdentitycard(bu.getIdentitycard());
         businessUserdetail.setScope(bu.getScope());
         businessUserdetail.setZuoji(bu.getZuoji());
         businessUserdetail.setUpdateDate(date);
         businessUserDetailService.saveOrUpdate(businessUserdetail);
         String uid = bu.getId();
         if (StringUtils.isNotBlank(uid)) {
           User busr = userService.findById(Integer.parseInt(uid));
           if (busr != null) {
             BusinessUserEntity busrEntity =
                 ConvertHelper.toBusinessUserEntity(busr, businessUserdetail);
             ur.setBusinessUser(busrEntity);
             ur.setErrorCode(0);
             ur.setErrorMessage("");
           } else {
             ValidationError er = ValidationError.USER_NOEXIST;
             int errorCode = er.getErrorCode();
             String errorMessage = er.getErrorMessage();
             ur.setErrorCode(errorCode);
             ur.setErrorMessage(errorMessage);
           }
         }
       }
     }
   } catch (Exception ex) {
     ValidationError ve = ValidationError.SYSTEM_ERROR;
     ur.setErrorCode(ve.getErrorCode());
     ur.setErrorMessage("系统错误");
     logger.error(ex.getMessage());
   }
   return ur;
 }
 @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 UserRemarkResult saveOrUpdateRemark(UserRemarkEntity remark) {
   UserRemarkResult ur = new UserRemarkResult();
   try {
     Integer userId = 0;
     Integer friendId = 0;
     UserRemarkEntity remarkEntity = refactorUserRemarkEntity(remark);
     userId = remarkEntity.getUserId();
     friendId = remarkEntity.getFriendId();
     if (userId > 0 && friendId > 0) {
       List<UserRemark> userRemarks =
           userRemarkService.find(
               " from UserRemark where userId=" + userId + " and friendId=" + friendId);
       UserRemark userRemark = null;
       Date time = new Date();
       if (userRemarks != null && userRemarks.size() > 0) {
         userRemark = userRemarks.get(0);
         userRemark.setRemark(remark.getRemark());
         userRemark.setUpdateDate(time);
       } else {
         userRemark = new UserRemark();
         userRemark.setRemark(remark.getRemark());
         userRemark.setUserId(userId);
         userRemark.setFriendId(friendId);
         userRemark.setCreateDate(time);
         userRemark.setUpdateDate(time);
       }
       userRemarkService.saveOrUpdate(userRemark);
       ur.setErrorCode(0);
       ur.setErrorMessage("");
       UserRemarkEntity userRemarkEntity = ConvertHelper.toUserRemarkEntity(userRemark);
       ur.setRemark(userRemarkEntity);
     } else {
       ValidationError er = ValidationError.PARAM_MISSING;
       ur.setErrorCode(er.getErrorCode());
       ur.setErrorMessage("Param Missing");
     }
   } catch (Exception e) {
     ValidationError ve = ValidationError.SYSTEM_ERROR;
     ur.setErrorCode(ve.getErrorCode());
     ur.setErrorMessage("系统错误");
     logger.error(e.getMessage());
   }
   return ur;
 }
 @Override
 public UserResult getUserByShipCard(String shipCard) {
   UserResult ur = new UserResult();
   try {
     if (StringUtils.isNotBlank(shipCard)) {
       User user = userService.findByCardId(shipCard);
       if (user != null) {
         UserEntity ue = ConvertHelper.toUserEntity(user, null);
         ur.setUser(ue);
       }
     }
     ur.setErrorCode(0);
     ur.setErrorMessage("");
   } catch (Exception ex) {
     ur.setErrorCode(-1);
     ur.setErrorMessage(ex.getMessage());
     ex.printStackTrace();
   }
   return ur;
 }
 @Override
 public UserResult getUser(String id) {
   UserResult ur = new UserResult();
   try {
     if (!StringUtils.isBlank(id)) {
       User user = userService.findById(Integer.valueOf(id));
       if (user != null) {
         UserDetail userdetail = userDetailService.findByUserId(Integer.parseInt(id));
         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;
 }
  @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 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;
   }
 }
  /** 修改普通用户 支持单字段更新 */
  @Override
  public UserResult updateuser(UserEntity user) {
    UserResult ur = new UserResult();
    try {
      if (user != null) {
        UserDetail userdetail = null;
        String id = user.getId();
        int userid = 0;
        if (!StringUtils.isBlank(id)) {
          userid = Integer.parseInt(id);
          updateUserCommon(
              id,
              user.getName(),
              user.getPhone(),
              user.getBoatcard(),
              user.getCansearchbyphone(),
              user.getHideroomtelephone(),
              user.getCansearch(),
              user.getRealname(),
              user.getRoomtelephone(),
              user.getAge());
          userdetail = userDetailService.findByUserId(userid);
        }
        if (userid > 0) {
          Date date = new Date();
          if (userdetail == null) {
            userdetail = new UserDetail();
            userdetail.setUserid(userid);
            userdetail.setCreateDate(date);
          }
          userdetail.setUpdateDate(date);
          if (user.getAge() != null) {
            userdetail.setAge(user.getAge());
          }
          if (user.getCity() != null) {
            userdetail.setCity(user.getCity());
          }
          if (user.getCountry() != null) {
            userdetail.setCountry(user.getCountry());
          }
          String sex = user.getSex();
          if (sex != null) {
            userdetail.setSex(Integer.valueOf(sex));
          }
          if (user.getState() != null) {
            userdetail.setState(user.getState());
          }
          if (user.getConstellation() != null) {
            userdetail.setConstellation(user.getConstellation());
          }
          if (user.getSignature() != null) {
            userdetail.setSignature(user.getSignature());
          }
          if (user.getHobby() != null) {
            userdetail.setHobby(user.getHobby());
          }
          if (user.getCansearchbyphone() != null) {}

          if (user.getRoomtelephone() != null) {
            userdetail.setRoom(user.getRoomtelephone());
          }
          userDetailService.saveOrUpdate(userdetail);
          if (!StringUtils.isBlank(id)) {
            User usr = userService.findById(Integer.parseInt(id));
            if (usr != null) {
              ur.setErrorCode(0);
              ur.setErrorMessage("");
              UserEntity userVO = ConvertHelper.toUserEntity(usr, userdetail);
              ur.setUser(userVO);
            } else {
              ValidationError er = ValidationError.USER_NOEXIST;
              int errorCode = er.getErrorCode();
              String errorMessage = er.getErrorMessage();
              ur.setErrorCode(errorCode);
              ur.setErrorMessage(errorMessage);
            }
          }
        }
      }

    } catch (Exception ex) {
      ValidationError ve = ValidationError.SYSTEM_ERROR;
      ur.setErrorCode(ve.getErrorCode());
      ur.setErrorMessage("系统错误");
      logger.error(ex.getMessage());
    }
    return ur;
  }