LINQ OrderBy句を使用して条件付きで列を並べ替える方法。
ex-プロパティFilter.OrderBy
とFilter.Order
ます。 OrderBy
では多くのex> Name、Address、Cityなどがあり、 Order
は昇順または降順になりますが、条件付き列で並べ替える方法がわかりません
参考のために以下のコードを見つけてください-
IQueryable<Filter> query;
PropertyInfo prop = typeof(Filter).GetProperty(Filter.OrderBy);
if (Filter.Order ==" Ascending"){
query = query.OrderBy ( x = > prop.GetValue(x,null));
}
else if (Filter.Order ==" Descending"){
query = query.OrderByDescending ( x = > prop.GetValue(x,null));
}
しかし、クエリは失敗しています。リフレクションを使用してpropプロパティを表示するとどのような問題があるのかわかりませんが、式prop.GetValueが機能していません。
これについて私を助けてください
動的なクエリ、選択、順序付けをサポートするライブラリSystem.Linq.Dynamic.Coreを使用できます。
コード例:
var q = new List<Person>
{
new Person{Name = "C", Age = 30 },
new Person{Name = "A", Age = 7 },
new Person{Name = "B", Age = 5 }
}.AsQueryable();
var x1 = q.OrderBy("Name asc");
var a1 = q.OrderBy("Age desc");
完全に機能する例については、 dotnetfiddleを参照してください
public static class LinqUtils
{
/// <summary>
/// Orders the by.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source">The source.</param>
/// <param name="propertyName">Name of the property.</param>
/// <param name="direction">The direction.</param>
/// <returns></returns>
public static IOrderedMongoQueryable<T> OrderBy<T>(this IMongoQueryable<T> source, string propertyName, OrderDirection direction)
{
switch (direction)
{
case OrderDirection.ASC:
return source.OrderBy(ToLambda<T>(propertyName));
case OrderDirection.DESC:
return source.OrderByDescending(ToLambda<T>(propertyName));
default:
return source.OrderBy(ToLambda<T>(propertyName));
}
}
/// <summary>
/// Orders the by.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source">The source.</param>
/// <param name="propertyName">Name of the property.</param>
/// <param name="direction">The direction.</param>
/// <returns></returns>
public static IOrderedMongoQueryable<T> OrderBy<T>(this IMongoQueryable<T> source, string propertyName, int direction)
{
var dir = (OrderDirection)direction;
switch (dir)
{
case OrderDirection.ASC:
return source.OrderBy(ToLambda<T>(propertyName));
case OrderDirection.DESC:
return source.OrderByDescending(ToLambda<T>(propertyName));
default:
return source.OrderBy(ToLambda<T>(propertyName));
}
}
/// <summary>
/// Orders the by.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source">The source.</param>
/// <param name="propertyName">Name of the property.</param>
/// <returns></returns>
public static IOrderedMongoQueryable<T> OrderBy<T>(this IMongoQueryable<T> source, string propertyName)
{
return source.OrderBy(ToLambda<T>(propertyName));
}
/// <summary>
/// Orders the by descending.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source">The source.</param>
/// <param name="propertyName">Name of the property.</param>
/// <returns></returns>
public static IOrderedMongoQueryable<T> OrderByDescending<T>(this IMongoQueryable<T> source, string propertyName)
{
return source.OrderByDescending(ToLambda<T>(propertyName));
}
/// <summary>
/// Wheres the specified property name.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source">The source.</param>
/// <param name="propertyName">Name of the property.</param>
/// <param name="stringToSource">The string to source.</param>
/// <returns></returns>
public static IMongoQueryable<T> Where<T>(this IMongoQueryable<T> source, string propertyName, string stringToSource)
{
return source.Where(ToLambdaWhere<T>(propertyName, stringToSource));
}
/// <summary>
/// Wheres the text.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query">The query.</param>
/// <param name="field">The field.</param>
/// <param name="search">The search.</param>
/// <returns></returns>
public static IMongoQueryable<T> WhereText<T>(this IMongoQueryable<T> query, Expression<Func<T, object>> field, string search)
{
search = Regex.Escape(search);
var filter = Builders<T>.Filter.Text(search);
var member = HelpersLinq.PropertyName<T>(field);
var regexFilter = string.Format("^{0}.*", search);
var filterRegex = Builders<T>.Filter.Regex(member, BsonRegularExpression.Create(new Regex(regexFilter, RegexOptions.IgnoreCase)));
return query.Where(_ => filter.Inject() && filterRegex.Inject());
}
/// <summary>
/// Converts to lambda.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="propertyName">Name of the property.</param>
/// <returns></returns>
private static Expression<Func<T, object>> ToLambda<T>(string propertyName)
{
var parameter = Expression.Parameter(typeof(T));
var property = Expression.Property(parameter, propertyName);
var propAsObject = Expression.Convert(property, typeof(object));
return Expression.Lambda<Func<T, object>>(propAsObject, parameter);
}
/// <summary>
/// Converts to lambdawhere.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="propertyName">Name of the property.</param>
/// <param name="stringToSearch">The string to search.</param>
/// <returns></returns>
private static Expression<Func<T, bool>> ToLambdaWhere<T>(string propertyName, string stringToSearch)
{
//var parameter = Expression.Parameter(typeof(T));
// Create a parameter to use for both of the expression bodies.
var parameter = Expression.Parameter(typeof(T), "x");
// Invoke each expression with the new parameter, and combine the expression bodies with OR.
var predicate = Expression.Lambda<Func<T, bool>>(Expression.Call(Expression.PropertyOrField(parameter, propertyName), "Contains", null, Expression.Constant(stringToSearch)), parameter);
return predicate;
}
}
public static class HelpersLinq
{
public static string PropertyName<T>(Expression<Func<T, object>> expression)
{
var member = expression.Body as MemberExpression;
if (member != null && member.Member is PropertyInfo)
return member.Member.Name;
throw new ArgumentException("Expression is not a Property", "expression");
}
}
public enum OrderDirection
{
ASC = 1,
DESC
}
だからあなたはそれを次のように使うことができます:
initialQuery.OrderBy("Name", OrderDirection.ASC)
お役に立てば幸いです。