public static DynamicQuery SetDefaultOrderBy(this DynamicQuery dynamicQuery, string field, ListSortDirection sort = ListSortDirection.Ascending) { if (dynamicQuery == null) { throw new ArgumentNullException(nameof(dynamicQuery)); } if (string.IsNullOrWhiteSpace(field)) { throw new ArgumentNullException(nameof(dynamicQuery)); } if (dynamicQuery.Order == null) { dynamicQuery.Order = new List <DynamicQueryOrder>(); } if (!dynamicQuery.Order.Any()) { dynamicQuery.Order.Add(new DynamicQueryOrder { Name = field, Sort = sort }); } return(dynamicQuery); }
public void SqlBuilderSample(FeiniuBus.DynamicQuery dynamicQuery, ISelectBuilder selectBuilder) { var sb = new StringBuilder(); var mappings = new SqlFieldMappings(); mappings.Map("Guest", "t1.Guest") .Map("Address", "t1.Address") .Map("Disabled", "t1.Disabled") .Map("Amout", "t1.Amout") .Map("Price", "t1.Price") .Map("Drink", "t1.Drink") .Map("Count", "t1.Count") .Map("Total", "t1.Total") .Map("Url", "t1.Url"); selectBuilder.Mapping(mappings); selectBuilder.Where(dynamicQuery.ParamGroup); var whereClause = selectBuilder.BuildWhere(); var orderbyClause = selectBuilder.OrderBy(dynamicQuery.Order); System.Console.WriteLine(whereClause); System.Console.WriteLine(orderbyClause); }
public virtual DynamicQuery Converter(DynamicQuery dynamicQuery) { if (dynamicQuery == null) { return(null); } var result = new DynamicQuery(dynamicQuery.Pager); result.Take = dynamicQuery.Take; result.Skip = dynamicQuery.Skip; result.ParamGroup = new DynamicQueryParamGroup(); result.Order = ConverterOrderFieldName(dynamicQuery.Order); if (dynamicQuery.ParamGroup != null) { var newgroup = new DynamicQueryParamGroup(); ConverterDynamicQueryParamGroupFieldName(newgroup, dynamicQuery.ParamGroup); result.ParamGroup = newgroup; } result.Select = ConverterSelectFieldName(dynamicQuery.Select); return(result); }
public DynamicQueryBuilder(bool pager) { _query = new DynamicQuery(pager); ParamGroupBuilder = new DynamicQueryParamGroupBuilder(_query.ParamGroup); }