public SqlOrderByItem AddSqlOrderByItem(IColumnMap columnMap, bool descending)
{
SqlColumnAlias sqlColumnAlias = this.SqlStatement.GetSqlColumnAlias(columnMap);
SqlColumnAliasReference sqlColumnAliasReference = new SqlColumnAliasReference(sqlColumnAlias);
return(AddSqlOrderByItem(sqlColumnAliasReference, descending));
}
public SqlComparePredicate GetSqlComparePredicate(SqlColumnAlias leftColumnAlias, SqlCompareOperatorType sqlCompareOperatorType, SqlColumnAlias rightColumnAlias)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
SqlColumnAliasReference rightSqlColumnAliasReference = new SqlColumnAliasReference(rightColumnAlias);
return(GetSqlComparePredicate(leftSqlColumnAliasReference, sqlCompareOperatorType, rightSqlColumnAliasReference));
}
public SqlIsNullPredicate GetSqlIsNullPredicate(SqlColumnAlias leftColumnAlias, bool negative)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlIsNullPredicate(leftSqlColumnAliasReference, negative);
}
public SqlIsNullPredicate GetSqlIsNullPredicate(SqlColumnAlias leftColumnAlias)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlIsNullPredicate(leftSqlColumnAliasReference, false);
}
public SqlFreeTextPredicate GetSqlFreeTextPredicate(SqlColumnAlias leftColumnAlias, SqlExpression rightExpression)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlFreeTextPredicate(leftSqlColumnAliasReference, rightExpression);
}
public SqlLikePredicate GetSqlLikePredicate(SqlColumnAlias leftColumnAlias, SqlExpression rightExpression, bool negative)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlLikePredicate(leftSqlColumnAliasReference, rightExpression, negative, ""));
}
public virtual void Visited(SqlColumnAliasReference columnAliasReference)
{
//
}
public SqlOrderByItem AddSqlOrderByItem(SqlColumnAlias sqlColumnAlias, bool descending)
{
SqlColumnAliasReference sqlColumnAliasReference = new SqlColumnAliasReference(sqlColumnAlias);
return(AddSqlOrderByItem(sqlColumnAliasReference, descending));
}
public SqlOrderByItem AddSqlOrderByItem(SqlColumnAlias sqlColumnAlias, bool descending)
{
SqlColumnAliasReference sqlColumnAliasReference = new SqlColumnAliasReference(sqlColumnAlias);
return AddSqlOrderByItem(sqlColumnAliasReference, descending);
}
public SqlComparePredicate GetSqlComparePredicate(SqlExpression leftExpression, SqlCompareOperatorType sqlCompareOperatorType, SqlColumnAlias rightColumnAlias)
{
SqlColumnAliasReference rightSqlColumnAliasReference = new SqlColumnAliasReference(rightColumnAlias);
return(GetSqlComparePredicate(leftExpression, sqlCompareOperatorType, rightSqlColumnAliasReference));
}
public SqlComparePredicate GetSqlComparePredicate(SqlColumnAlias leftColumnAlias, SqlCompareOperatorType sqlCompareOperatorType, SqlExpression rightExpression)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlComparePredicate(leftSqlColumnAliasReference, sqlCompareOperatorType, rightExpression));
}
public SqlAllPredicate GetSqlAllPredicate(SqlColumnAlias leftColumnAlias, SqlCompareOperatorType sqlCompareOperatorType)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlAllPredicate(leftSqlColumnAliasReference, sqlCompareOperatorType, SqlAllPredicateType.All));
}
public SqlInPredicate GetSqlInPredicate(SqlColumnAlias leftColumnAlias, bool negative)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlInPredicate(leftSqlColumnAliasReference, negative));
}
public SqlInPredicate GetSqlInPredicate(SqlColumnAlias leftColumnAlias)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlInPredicate(leftSqlColumnAliasReference, false));
}
public SqlLikePredicate GetSqlLikePredicate(SqlColumnAlias leftColumnAlias, SqlExpression rightExpression, bool negative, string escapeCharacter)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlLikePredicate(leftSqlColumnAliasReference, rightExpression, negative, escapeCharacter));
}
public SqlLikePredicate GetSqlLikePredicate(SqlColumnAlias leftColumnAlias, SqlExpression rightExpression, bool negative)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlLikePredicate(leftSqlColumnAliasReference, rightExpression, negative, "");
}
public SqlLikePredicate GetSqlLikePredicate(SqlColumnAlias leftColumnAlias, SqlExpression rightExpression, bool negative, string escapeCharacter)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlLikePredicate(leftSqlColumnAliasReference, rightExpression, negative, escapeCharacter);
}
public SqlAllPredicate GetSqlAllPredicate(SqlColumnAlias leftColumnAlias, SqlCompareOperatorType sqlCompareOperatorType)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlAllPredicate(leftSqlColumnAliasReference , sqlCompareOperatorType, SqlAllPredicateType.All);
}
public SqlOrderByItem AddSqlOrderByItem(IColumnMap columnMap, bool descending)
{
SqlColumnAlias sqlColumnAlias = this.SqlStatement.GetSqlColumnAlias(columnMap);
SqlColumnAliasReference sqlColumnAliasReference = new SqlColumnAliasReference(sqlColumnAlias);
return AddSqlOrderByItem(sqlColumnAliasReference, descending);
}
public SqlComparePredicate GetSqlComparePredicate(SqlColumnAlias leftColumnAlias, SqlCompareOperatorType sqlCompareOperatorType, SqlExpression rightExpression)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
return GetSqlComparePredicate(leftSqlColumnAliasReference, sqlCompareOperatorType, rightExpression);
}
public SqlComparePredicate GetSqlComparePredicate(SqlExpression leftExpression, SqlCompareOperatorType sqlCompareOperatorType, SqlColumnAlias rightColumnAlias)
{
SqlColumnAliasReference rightSqlColumnAliasReference = new SqlColumnAliasReference(rightColumnAlias) ;
return GetSqlComparePredicate(leftExpression, sqlCompareOperatorType, rightSqlColumnAliasReference);
}
public SqlComparePredicate GetSqlComparePredicate(SqlColumnAlias leftColumnAlias, SqlCompareOperatorType sqlCompareOperatorType, SqlColumnAlias rightColumnAlias)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias) ;
SqlColumnAliasReference rightSqlColumnAliasReference = new SqlColumnAliasReference(rightColumnAlias) ;
return GetSqlComparePredicate(leftSqlColumnAliasReference, sqlCompareOperatorType, rightSqlColumnAliasReference);
}
public virtual void Visiting(SqlColumnAliasReference columnAliasReference)
{
SqlColumnAlias columnAlias = columnAliasReference.SqlColumnAlias;
SqlTableAlias tableAlias = columnAlias.SqlTableAlias;
//string alias = columnAlias.Alias;
string alias = columnAlias.SqlColumn.Name ; // weird, but that's how Sql Server likes it...(possibly this should be moved to Sql Server subclass, dunno what is standard...)
string tblAlias = tableAlias.Alias;
sqlBuilder.Append(EncapsulateTable(tblAlias));
sqlBuilder.Append(".");
sqlBuilder.Append(Encapsulate(alias));
}
public SqlFreeTextPredicate GetSqlFreeTextPredicate(SqlColumnAlias leftColumnAlias, SqlExpression rightExpression)
{
SqlColumnAliasReference leftSqlColumnAliasReference = new SqlColumnAliasReference(leftColumnAlias);
return(GetSqlFreeTextPredicate(leftSqlColumnAliasReference, rightExpression));
}
