public SelectSqlSection(Database db, QueryTable table, params ExpressionClip[] columns)
{
this.db = db;
this.tableName = table.TableName;
string aliasName = table.TableAlias;
this.whereClip = new WhereClip(new FromClip(this.tableName, string.IsNullOrEmpty(aliasName) ? this.tableName : aliasName));
if (table is IExpression)
{
SqlQueryUtils.AddParameters(this.whereClip.Parameters, table as IExpression);
}
if (columns != null && columns.Length > 0)
{
this.columnNames = new string[columns.Length];
for (int i = 0; i < columns.Length; ++i)
{
this.columnNames[i] = columns[i].ToString();
//add parameters in column to whereClip
if (columns[i].Parameters.Count > 0)
{
SqlQueryUtils.AddParameters(this.whereClip.Parameters, columns[i]);
}
}
}
}
public SelectSqlSection RightJoin(QueryTable joinTable, string joinTableAliasName, WhereClip joinOnWhere)
{
this.whereClip.From.RightJoin(joinTable.TableName, joinTableAliasName, joinOnWhere);
if (joinOnWhere.Parameters.Count > 0)
{
SqlQueryUtils.AddParameters(whereClip.Parameters, joinOnWhere);
}
return(this);
}