Esempio n. 1
0
  /**
   * 查询用户数据
   *
   * @param user
   * @param page
   * @return
   */
  public List<User> listUsers(User user, PageInfo page) {
    StringBuilder sql = new StringBuilder();
    sql.append("SELECT T1.id,nickname,phone,industry,  ")
        .append("T2.name as schoolName,major,grade,T3.name AS gradeName ")
        .append("FROM USER_INFO T1 ")
        .append("LEFT JOIN SYS_SCHOOL T2 ON T2.ID=T1.schoolId ")
        .append("LEFT JOIN SYS_DICT T3 ON T3.CODE=T1.grade AND T3.groupName=? ")
        .append("WHERE 1=1 ");
    ParamInfo paramInfo = new ParamInfo();
    paramInfo.setTypeAndData(Types.VARCHAR, GloabConstant.GROUP_GRADE);
    if (!Utils.isEmpty(user.getNickname())) {
      sql.append(" AND T1.nickname like ? ");
      paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getNickname() + "%");
    }

    if (!Utils.isEmpty(user.getType())) {
      sql.append(" AND T1.type = ? ");
      paramInfo.setTypeAndData(Types.CHAR, user.getType());
    }

    //		if(!Utils.isEmpty(user.getStatus()))
    //		{
    //			sql.append(" AND status = ? ");
    //			paramInfo.setTypeAndData(Types.CHAR, user.getStatus());
    //		}
    return userDao.getRecords(sql.toString(), paramInfo, page, User.class);
  }
Esempio n. 2
0
  /**
   * 更新大拿
   *
   * @param user
   * @return
   */
  @Transactional
  public void updateGreater(User user, Greater greater) {
    updateUser(user);
    StringBuilder sql = new StringBuilder();
    sql.append("update USER_GREATER set ");
    ParamInfo paramInfo = new ParamInfo();
    if (!Utils.isEmpty(greater.getCompany())) {
      sql.append("company=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, greater.getCompany());
    }

    if (!Utils.isEmpty(greater.getPost())) {
      sql.append("post=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, greater.getPost());
    }

    if (!Utils.isEmpty(greater.getTags())) {
      sql.append("tags=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, greater.getTags());
    }

    if (!Utils.isEmpty(greater.getExperience())) {
      sql.append("experience=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, greater.getExperience());
    }

    if (!Utils.isEmpty(greater.getSpecialty())) {
      sql.append("specialty=?,");
      paramInfo.setTypeAndData(Types.CHAR, greater.getSpecialty());
    }

    if (!Utils.isEmpty(greater.getJob())) {
      sql.append("job=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, greater.getJob());
    }

    if (!Utils.isEmpty(greater.getAnswerTimes())) {
      sql.append("answerTimes=?,");
      paramInfo.setTypeAndData(Types.BIGINT, greater.getAnswerTimes());
    }

    if (!Utils.isEmpty(greater.getIsshow())) {
      sql.append("isshow=?,");
      paramInfo.setTypeAndData(Types.CHAR, greater.getIsshow());
    }

    if (!Utils.isEmpty(greater.getOrderNo())) {
      sql.append("orderNo=?,");
      paramInfo.setTypeAndData(Types.INTEGER, greater.getOrderNo());
    }

    if (sql.toString().endsWith(",")) {
      sql.replace(sql.length() - 1, sql.length(), "");
      sql.append(" where id=?");
      paramInfo.setTypeAndData(Types.BIGINT, greater.getId());

      userDao.updateRecord(sql.toString(), paramInfo);
    }
  }
Esempio n. 3
0
  /**
   * 更新用户
   *
   * @param user
   * @return
   */
  public void updateUser(User user) {
    StringBuilder sql = new StringBuilder();
    sql.append("update USER_INFO set ");
    ParamInfo paramInfo = new ParamInfo();
    if (!Utils.isEmpty(user.getName())) {
      sql.append("name=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getName());
    }

    if (!Utils.isEmpty(user.getPhone())) {
      sql.append("phone=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getPhone());
    }

    if (!Utils.isEmpty(user.getNickname())) {
      sql.append("nickname=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getNickname());
    }

    if (!Utils.isEmpty(user.getSchoolId())) {
      sql.append("schoolId=?,");
      paramInfo.setTypeAndData(Types.BIGINT, user.getSchoolId());
    }

    if (!Utils.isEmpty(user.getMajor())) {
      sql.append("major=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getMajor());
    }

    if (!Utils.isEmpty(user.getGrade())) {
      sql.append("grade=?,");
      paramInfo.setTypeAndData(Types.CHAR, user.getGrade());
    }

    if (!Utils.isEmpty(user.getUrl())) {
      sql.append("url=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getUrl());
    }

    if (!Utils.isEmpty(user.getBackground_url())) {
      sql.append("background_url=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getBackground_url());
    }

    if (!Utils.isEmpty(user.getIndustry())) {
      sql.append("industry=?,");
      paramInfo.setTypeAndData(Types.VARCHAR, user.getIndustry());
    }

    if (sql.toString().endsWith(",")) {
      sql.replace(sql.length() - 1, sql.length(), "");
      sql.append(" where id=?");
      paramInfo.setTypeAndData(Types.BIGINT, user.getId());

      userDao.updateRecord(sql.toString(), paramInfo);
    }
  }
Esempio n. 4
0
  /**
   * 查询用户数据的数量
   *
   * @param user
   * @return
   */
  public long getUserCount(User user) {
    StringBuilder sql = new StringBuilder();
    sql.append(" select count(1) from USER_INFO WHERE 1=1 ");
    ParamInfo paramInfo = new ParamInfo();
    if (!Utils.isEmpty(user.getName())) {
      sql.append(" AND name like ? ");
      paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getName() + "%");
    }

    if (!Utils.isEmpty(user.getType())) {
      sql.append(" AND type = ? ");
      paramInfo.setTypeAndData(Types.CHAR, user.getType());
    }

    if (!Utils.isEmpty(user.getStatus())) {
      sql.append(" AND status = ? ");
      paramInfo.setTypeAndData(Types.CHAR, user.getStatus());
    }
    return userDao.getCount(sql.toString(), paramInfo);
  }
Esempio n. 5
0
 /**
  * 判断用户是否存在
  *
  * @param user
  * @return
  */
 public boolean isExistUser(User user) {
   StringBuilder sql = new StringBuilder();
   sql.append(" select 1 from USER_INFO WHERE phone=? ");
   ParamInfo paramInfo = new ParamInfo();
   paramInfo.setTypeAndData(Types.VARCHAR, user.getPhone());
   // paramInfo.setTypeAndData(Types.CHAR, user.getType());
   if (!Utils.isEmpty(user.getId())) {
     sql.append("and id <> ?");
     paramInfo.setTypeAndData(Types.BIGINT, user.getId());
   }
   List<User> l = userDao.getRecords(sql.toString(), paramInfo, User.class);
   if (l != null && l.size() > 0) return true;
   return false;
 }
Esempio n. 6
0
 /**
  * 获取大拿数量
  *
  * @param user
  * @return
  */
 public long getGreaterCount(User user) {
   StringBuilder sql = new StringBuilder();
   sql.append("SELECT count(1) ")
       .append("FROM USER_GREATER T1 ")
       .append("INNER JOIN USER_INFO T2 ON T2.ID=T1.ID ")
       .append("WHERE 1=1 ");
   ParamInfo paramInfo = new ParamInfo();
   if (user != null) {
     if (!Utils.isEmpty(user.getNickname())) {
       sql.append(" AND T2.nickname like ? ");
       paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getNickname() + "%");
     }
   }
   return greaterDao.getCount(sql.toString(), paramInfo);
 }
Esempio n. 7
0
  /**
   * 查询大拿列表
   *
   * @param page
   * @return
   */
  public List<Greater> listGreaters(User user, PageInfo page) {
    StringBuilder sql = new StringBuilder();
    sql.append(
            "SELECT T1.id,T2.phone,T1.tags,T2.nickname,T1.company,T1.post,T2.url,T1.answerTimes ")
        .append("FROM USER_GREATER T1 ")
        .append("INNER JOIN USER_INFO T2 ON T2.ID=T1.ID ")
        .append("WHERE 1=1 ");
    ParamInfo paramInfo = new ParamInfo();
    if (user != null) {
      if (!Utils.isEmpty(user.getNickname())) {
        sql.append(" AND T2.nickname like ? ");
        paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getNickname() + "%");
      }
    } else {
      sql.append("AND isshow=? ");
      paramInfo.setTypeAndData(Types.CHAR, GloabConstant.YESNO_YES);
    }

    sql.append("ORDER BY orderNo ASC ");
    return greaterDao.getRecords(sql.toString(), paramInfo, page, Greater.class);
  }