public string BuildSql()
{
if (!String.IsNullOrEmpty(_rawSql))
{
return(_rawSql);
}
string whereClause = WhereStatement.CreateComparisonClause(FieldName, ComparisonOperator, Value);
foreach (SubClause subWhereClause in SubClauses)
{
switch (subWhereClause.LogicOperator)
{
case LogicOperator.And:
whereClause += " AND ";
break;
case LogicOperator.Or:
whereClause += " OR ";
break;
}
whereClause += WhereStatement.CreateComparisonClause(FieldName,
subWhereClause.ComparisonOperator,
subWhereClause.Value);
}
return(whereClause);
}
private string BuildOnClause()
{
if (!String.IsNullOrEmpty(OnClause))
{
return(OnClause);
}
return(WhereStatement.CreateComparisonClause(FriendlyFromTableName + '.' + FromColumn,
ComparisonOperator,
new SqlLiteral(FriendlyToTableName + '.' +
ToColumn)));
}
