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); }