/**
   * This method was generated by MyBatis Generator. This method corresponds to the database table
   * `orderguidereward`
   *
   * @mbggenerated
   */
  public String updateByExampleSelective(Map<String, Object> parameter) {
    FinalOrderGuideReward record = (FinalOrderGuideReward) parameter.get("record");
    FinalOrderGuideRewardCriteria example =
        (FinalOrderGuideRewardCriteria) parameter.get("example");

    SQL sql = new SQL();
    sql.UPDATE("`orderguidereward`");

    if (record.getOrderguiderewardid() != null) {
      sql.SET("orderGuideRewardId = #{record.orderguiderewardid,jdbcType=VARCHAR}");
    }

    if (record.getOrderid() != null) {
      sql.SET("orderId = #{record.orderid,jdbcType=VARCHAR}");
    }

    if (record.getGuideid() != null) {
      sql.SET("guideId = #{record.guideid,jdbcType=INTEGER}");
    }

    if (record.getOrderrewardtype() != null) {
      sql.SET("orderRewardType = #{record.orderrewardtype,jdbcType=INTEGER}");
    }

    if (record.getComment() != null) {
      sql.SET("comment = #{record.comment,jdbcType=VARCHAR}");
    }

    if (record.getReward() != null) {
      sql.SET("reward = #{record.reward,jdbcType=DECIMAL}");
    }

    if (record.getStatus() != null) {
      sql.SET("status = #{record.status,jdbcType=INTEGER}");
    }

    if (record.getUpdatedAt() != null) {
      sql.SET("updated_at = #{record.updatedAt,jdbcType=TIMESTAMP}");
    }

    if (record.getCreatedAt() != null) {
      sql.SET("created_at = #{record.createdAt,jdbcType=TIMESTAMP}");
    }

    applyWhere(sql, example, true);
    return sql.toString();
  }
  /**
   * This method was generated by MyBatis Generator. This method corresponds to the database table
   * `orderguidereward`
   *
   * @mbggenerated
   */
  public String insertSelective(FinalOrderGuideReward record) {
    SQL sql = new SQL();
    sql.INSERT_INTO("`orderguidereward`");

    if (record.getOrderguiderewardid() != null) {
      sql.VALUES("orderGuideRewardId", "#{orderguiderewardid,jdbcType=VARCHAR}");
    }

    if (record.getOrderid() != null) {
      sql.VALUES("orderId", "#{orderid,jdbcType=VARCHAR}");
    }

    if (record.getGuideid() != null) {
      sql.VALUES("guideId", "#{guideid,jdbcType=INTEGER}");
    }

    if (record.getOrderrewardtype() != null) {
      sql.VALUES("orderRewardType", "#{orderrewardtype,jdbcType=INTEGER}");
    }

    if (record.getComment() != null) {
      sql.VALUES("comment", "#{comment,jdbcType=VARCHAR}");
    }

    if (record.getReward() != null) {
      sql.VALUES("reward", "#{reward,jdbcType=DECIMAL}");
    }

    if (record.getStatus() != null) {
      sql.VALUES("status", "#{status,jdbcType=INTEGER}");
    }

    if (record.getUpdatedAt() != null) {
      sql.VALUES("updated_at", "#{updatedAt,jdbcType=TIMESTAMP}");
    }

    if (record.getCreatedAt() != null) {
      sql.VALUES("created_at", "#{createdAt,jdbcType=TIMESTAMP}");
    }

    return sql.toString();
  }
  /**
   * This method was generated by MyBatis Generator. This method corresponds to the database table
   * `orderguidereward`
   *
   * @mbggenerated
   */
  public String updateByPrimaryKeySelective(FinalOrderGuideReward record) {
    SQL sql = new SQL();
    sql.UPDATE("`orderguidereward`");

    if (record.getOrderid() != null) {
      sql.SET("orderId = #{orderid,jdbcType=VARCHAR}");
    }

    if (record.getGuideid() != null) {
      sql.SET("guideId = #{guideid,jdbcType=INTEGER}");
    }

    if (record.getOrderrewardtype() != null) {
      sql.SET("orderRewardType = #{orderrewardtype,jdbcType=INTEGER}");
    }

    if (record.getComment() != null) {
      sql.SET("comment = #{comment,jdbcType=VARCHAR}");
    }

    if (record.getReward() != null) {
      sql.SET("reward = #{reward,jdbcType=DECIMAL}");
    }

    if (record.getStatus() != null) {
      sql.SET("status = #{status,jdbcType=INTEGER}");
    }

    if (record.getUpdatedAt() != null) {
      sql.SET("updated_at = #{updatedAt,jdbcType=TIMESTAMP}");
    }

    if (record.getCreatedAt() != null) {
      sql.SET("created_at = #{createdAt,jdbcType=TIMESTAMP}");
    }

    sql.WHERE("orderGuideRewardId = #{orderguiderewardid,jdbcType=VARCHAR}");

    return sql.toString();
  }