public void Start()
{
this.connection = new SqlConnection(SQLHelpers.GetConnectionString(SQLServer, SQLUser, SQLPassword, SQLUseSQLAuth, SQLDatabase));
Grid sortGrid = new Grid
{
Value = config["SortGrid"]
};
SortClause = "";
foreach (var row in sortGrid.Rows)
{
SortClause += " " + row["SortColumn"].ToString() + " " + row["SortOrder"] + ",";
}
if (!String.IsNullOrWhiteSpace(SortClause))
{
SortClause = " ORDER BY " + SortClause.TrimEnd(',');
}
WhereClause = "";
if (Filters != "null" && !string.IsNullOrWhiteSpace(Filters))
{
filterExpression = ExpressionReader.Evaluate(Filters);
WhereClause = filterExpression.ConvertToSQL();
if (!string.IsNullOrWhiteSpace(WhereClause))
{
WhereClause = "WHERE " + WhereClause;
}
}
TopClause = MaxRows > 0 ? "TOP " + MaxRows : "";
}
public void AddPredicate(FilterExpressionBase expr)
{
var eq = expr.ToQuery();
if (eq.StartsWith("where "))
{
eq = eq.Substring(6);
}
AddPredicate(eq);
}
private static FilterExpressionBase JoinFilterExpression(
FilterExpressionBase firstExpression,
FilterExpressionBase secondExpression,
FilterType logicalOperator)
{
return(new ComplexFilterExpression
{
FirstExpression = firstExpression,
SecondExpression = secondExpression,
LogicalOperator = logicalOperator
});
}
