Exemplo n.º 1
0
  /**
   * This method was generated by MyBatis Generator. This method corresponds to the database table
   * `trade_move_check`
   *
   * @mbggenerated
   */
  public String selectByExample(TradeMoveCheckExample example) {
    SQL sql = new SQL();
    if (example != null && example.isDistinct()) {
      sql.SELECT_DISTINCT("id");
    } else {
      sql.SELECT("id");
    }
    sql.SELECT("order_id");
    sql.SELECT("order_sn");
    sql.SELECT("order_no");
    sql.SELECT("is_move_success");
    sql.SELECT("is_in_info");
    sql.SELECT("info_flag");
    sql.SELECT("info_desc");
    sql.SELECT("create_time");
    sql.SELECT("update_time");
    sql.FROM("`trade_move_check`");
    applyWhere(sql, example, false);

    if (example != null && example.getOrderByClause() != null) {
      sql.ORDER_BY(example.getOrderByClause());
    }

    String sqlStr = sql.toString();
    if (example.getPage() != null) {
      sqlStr =
          sqlStr
              + " limit "
              + example.getPage().getOffset()
              + ","
              + example.getPage().getLimit()
              + "";
    }
    return sqlStr;
  }
  /**
   * This method was generated by MyBatis Generator. This method corresponds to the database table
   * `orderguidereward`
   *
   * @mbggenerated
   */
  public String selectByExample(FinalOrderGuideRewardCriteria example) {
    SQL sql = new SQL();
    if (example != null && example.isDistinct()) {
      sql.SELECT_DISTINCT("orderGuideRewardId");
    } else {
      sql.SELECT("orderGuideRewardId");
    }
    sql.SELECT("orderId");
    sql.SELECT("guideId");
    sql.SELECT("orderRewardType");
    sql.SELECT("comment");
    sql.SELECT("reward");
    sql.SELECT("status");
    sql.SELECT("updated_at");
    sql.SELECT("created_at");
    sql.FROM("`orderguidereward`");
    applyWhere(sql, example, false);

    if (example != null && example.getOrderByClause() != null) {
      sql.ORDER_BY(example.getOrderByClause());
    }

    String sqlStr = sql.toString();
    if (example.getPage() != null) {
      sqlStr =
          sqlStr
              + " limit "
              + example.getPage().getOffset()
              + ","
              + example.getPage().getLimit()
              + "";
    }
    return sqlStr;
  }
Exemplo n.º 3
0
 /**
  * This method was generated by MyBatis Generator. This method corresponds to the database table
  * `trade_move_check`
  *
  * @mbggenerated
  */
 public String countByExample(TradeMoveCheckExample example) {
   SQL sql = new SQL();
   sql.SELECT("count(*)").FROM("`trade_move_check`");
   applyWhere(sql, example, false);
   return sql.toString();
 }
Exemplo n.º 4
0
 private SQL startQuery() {
   SQL sql = new SQL();
   return sql.SELECT("DISTINCT r.resource_id, r.repository_id, r.id, r.uri").FROM("resource r");
 }
 /**
  * This method was generated by MyBatis Generator. This method corresponds to the database table
  * `agentaccountlog`
  *
  * @mbggenerated
  */
 public String countByExample(FinalAgentaccountLogCriteria example) {
   SQL sql = new SQL();
   sql.SELECT("count(*)").FROM("`agentaccountlog`");
   applyWhere(sql, example, false);
   return sql.toString();
 }
  /**
   * This method was generated by MyBatis Generator. This method corresponds to the database table
   * `agentaccountlog`
   *
   * @mbggenerated
   */
  public String selectByExample(FinalAgentaccountLogCriteria example) {
    SQL sql = new SQL();
    if (example != null && example.isDistinct()) {
      sql.SELECT_DISTINCT("agentAccountLogId");
    } else {
      sql.SELECT("agentAccountLogId");
    }
    sql.SELECT("agentId");
    sql.SELECT("agentUserId");
    sql.SELECT("agentUserName");
    sql.SELECT("orderId");
    sql.SELECT("type");
    sql.SELECT("bizType");
    sql.SELECT("price");
    sql.SELECT("content");
    sql.SELECT("comment");
    sql.SELECT("tips");
    sql.SELECT("bizStatus");
    sql.SELECT("payType");
    sql.SELECT("bizComment");
    sql.SELECT("updated_at");
    sql.SELECT("created_at");
    sql.FROM("`agentaccountlog`");
    applyWhere(sql, example, false);

    if (example != null && example.getOrderByClause() != null) {
      sql.ORDER_BY(example.getOrderByClause());
    }

    String sqlStr = sql.toString();
    if (example.getPage() != null) {
      sqlStr =
          sqlStr
              + " limit "
              + example.getPage().getOffset()
              + ","
              + example.getPage().getLimit()
              + "";
    }
    return sqlStr;
  }
 /**
  * This method was generated by MyBatis Generator. This method corresponds to the database table
  * `orderguidereward`
  *
  * @mbggenerated
  */
 public String countByExample(FinalOrderGuideRewardCriteria example) {
   SQL sql = new SQL();
   sql.SELECT("count(*)").FROM("`orderguidereward`");
   applyWhere(sql, example, false);
   return sql.toString();
 }