private void Build(StringBuilder sb, List <object> args, SqlJointer lhs) { if (!String.IsNullOrEmpty(_sql)) { // Add SQL to the string if (sb.Length > 0) { sb.Append("\n"); } var sql = Database.ProcessParams(_sql, _args, args); if (Is(lhs, "WHERE ") && Is(this, "WHERE ")) { sql = "AND " + sql.Substring(6); } if (Is(lhs, "ORDER BY ") && Is(this, "ORDER BY ")) { sql = ", " + sql.Substring(9); } sb.Append(sql); } // Now do rhs if (_rhs != null) { _rhs.Build(sb, args, this); } }
public SqlJointer Append(SqlJointer sql) { if (_rhs != null) _rhs.Append(sql); else _rhs = sql; return this; }
public SqlJointer Append(SqlJointer sql) { if (_rhs != null) { _rhs.Append(sql); } else { _rhs = sql; } return(this); }
public SqlJoinClause(SqlJointer sql) { _sql = sql; }
private void Build(StringBuilder sb, List<object> args, SqlJointer lhs) { if (!String.IsNullOrEmpty(_sql)) { // Add SQL to the string if (sb.Length > 0) { sb.Append("\n"); } var sql = Database.ProcessParams(_sql, _args, args); if (Is(lhs, "WHERE ") && Is(this, "WHERE ")) sql = "AND " + sql.Substring(6); if (Is(lhs, "ORDER BY ") && Is(this, "ORDER BY ")) sql = ", " + sql.Substring(9); sb.Append(sql); } // Now do rhs if (_rhs != null) _rhs.Build(sb, args, this); }
static bool Is(SqlJointer sql, string sqltype) { return sql != null && sql._sql != null && sql._sql.StartsWith(sqltype, StringComparison.InvariantCultureIgnoreCase); }
static bool Is(SqlJointer sql, string sqltype) { return(sql != null && sql._sql != null && sql._sql.StartsWith(sqltype, StringComparison.InvariantCultureIgnoreCase)); }
public SqlJoinClause(SqlJointer sql) { _sql = sql; }