public static class LambdaHelper
{
/// <summary>
/// Lambda表达式拼接
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="first"></param>
/// <param name="second"></param>
/// <param name="merge"></param>
/// <returns></returns>
public static Expression<T> LambdaCompose<T>(this Expression<T> first, Expression<T> second, Func<Expression, Expression, Expression> merge)
{
// build parameter map (from parameters of second to parameters of first)
//构建参数映射(从第二个参数到第一个参数)
var map = first.Parameters.Select((f, i) => new { f, s = second.Parameters[i] }).ToDictionary(p => p.s, p => p.f);
// replace parameters in the second lambda expression with parameters from the first
//用第一个lambda表达式中的参数替换第二个lambda表达式中的参数
var secondBody = ParameterRebinder.ReplaceParameters(map, second.Body);
// apply composition of lambda expression bodies to parameters from the first expression
//将lambda表达式体的组合应用于来自第一个表达式的参数
return Expression.Lambda<T>(merge(first.Body, secondBody), first.Parameters);
}
/// <summary>
/// and扩展
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="first"></param>
/// <param name="second"></param>
/// <returns></returns>
public static Expression<Func<T, bool>> LambdaAnd<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
{
return first.LambdaCompose(second, Expression.And);
}
/// <summary>
/// or扩展
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="first"></param>
/// <param name="second"></param>
/// <returns></returns>
public static Expression<Func<T, bool>> LambdaOr<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
{
return first.LambdaCompose(second, Expression.Or);
}
}
常见用途,比如我们数据层封装了如下方法:
/// <summary>
/// 获取一个实体
/// </summary>
/// <param name="expWhere">查询条件</param>
/// <returns></returns>
public virtual T Find(Expression<Func<T, bool>> expWhere) {
T entity = null;
using (IDbContext MsSqlDB = CreateSqlContext()) {
IQuery<T> q = MsSqlDB.Query<T>();
entity = q.Where(expWhere).FirstOrDefault();
}
return entity;
}
调用
Expression<Func<Books, bool>> where = c => true;
if (bookID == "-1")
{
where = where.And(a => a.Id == "001");
}
if (bookName == "-1")
{
where = where.Or(a => a.Name == "Test");
}
new BaseLocalBll<Books>().Find(where);
转载:https://blog.csdn.net/shujudeliu/article/details/84314642