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