internal static bool ColumnIsValid(this gsSelectColumn column)
{
if (column is gsRawColumn || column is gsBinaryColumn)
{
return(true);
}
return(column.ColumnName.HasValue() || Convert.ToString(column.Value).HasValue());
}
private void AddColumns(QuerySpecification qrySpec, gsSelectQuery qry)
{
foreach (var selectElement in qrySpec.SelectElements)
{
gsColumnParserBase colParser = gsColumnParserFactory.CreateParser(selectElement);
gsSelectColumn selCol = colParser.Parse();
qry.Columns.Add(selCol);
}
}
private void AddParameter(gsSelectColumn column, bool addQuotes)
{
if (column is gsDateColumn || column is gsParameterColumn)
{
SqlParameters.Instance.Add(new gsParameter {
Name = column.ColumnName,
Value = column.Value == null ? "{VALUE}" : column.Value,
AddQuotes = addQuotes
});
}
}
internal gsGroupByTerm GetGroupByTerm(ExpressionGroupingSpecification groupingSpec)
{
gsGroupByTerm groupByTerm;
gsSelectColumn selCol = gsScalarExpressionParserFactory.CreateParser(groupingSpec.Expression, null).Parse();
groupByTerm = new gsGroupByTerm {
Field = selCol.ColumnName
};
groupByTerm.Table = selCol.Table;
return(groupByTerm);
}
internal gsOrderByTerm GetOrderByTerm(ExpressionWithSortOrder orderByElement)
{
gsOrderByTerm orderByTerm;
gsSelectColumn selCol = gsScalarExpressionParserFactory.CreateParser(orderByElement.Expression, null).Parse();
orderByTerm = new gsOrderByTerm()
{
Direction = orderByElement.SortOrder.ToOrderByDirection(),
Field = selCol.ColumnName
};
orderByTerm.Table = selCol.Table;
return(orderByTerm);
}
