扩展Expression表达式树,实现EF动态条件查询

在我们写一些管理系统后台的时候,经常会出现带多个查询参数的情况。如果按照一般方法就是if里面嵌套if-else 多层，这样代码看起来很乱。

我们通过扩展表达式树就可以实现这些功能。

//主方法
public static void Main(string[] args)
{
    MyWhere where = new MyWhere();
    //if (xxxx)
    where.And(m => m.id >= 2);
    //if(xxxx)
    where.And(m => m.name.Contains("test"));
    //where.Or(m => m.name.Contains("test"));

    var result = new List();
    using (MysqlTestDB db = new MysqlTestDB())
    {
        result = db.tb_tests.Where(where.GetExpression()).ToList();
    }

    foreach (var item in result)
    {
        Console.WriteLine("id: "+ item.id + ",name: "+item.name);
    }
}

//MyWhere工具类
public class MyWhere
{
    private Expressionbool>> _expressions = e => true;

    public void And(Expressionbool>> exp)
    {
        _expressions = _expressions.AndAlso(exp, Expression.AndAlso);
    }

    public void Or(Expressionbool>> exp)
    {
        _expressions = _expressions.AndAlso(exp, Expression.OrElse);
    }

    public Expressionbool>> GetExpression()
    {
        return _expressions;
    }
}

//Expressing扩展类
public static class ExpressionExtensions
{
    public static Expressionbool>> And(
        this Expressionbool>> first, Expressionbool>> secend)
    {
        return first.AndAlso(secend, Expression.AndAlso);
    }

    public static Expressionbool>> Or(
        this Expressionbool>> first, Expressionbool>> secend)
    {
        return first.AndAlso(secend, Expression.OrElse);
    }

    public static Expressionbool>> AndAlso(
        this Expressionbool>> expr1, Expressionbool>> expr2,
        Func func)
    {
        var parameter = Expression.Parameter(typeof(T));

        var leftVisitor = new ReplaceExpressionVisitor(expr1.Parameters[0],parameter);
        var left = leftVisitor.Visit(expr1.Body);

        var rightVisitor = new ReplaceExpressionVisitor(expr2.Parameters[0], parameter);
        var right = rightVisitor.Visit(expr2.Body);

        return Expression.Lambdabool>>(func(left, right), parameter);
    }

    private class ReplaceExpressionVisitor : ExpressionVisitor
    {
        private readonly Expression _oldValue;
        private readonly Expression _newValue;

        public ReplaceExpressionVisitor(Expression oldValue, Expression newValue)
        {
            _oldValue = oldValue;
            _newValue = newValue;
        }

        public override Expression Visit(Expression node)
        {
            if (node == _oldValue)
                return _newValue;

            return base.Visit(node);
        }
    }
}

数据库：

 结果截图：

1-当 选择 And 包含 "test" 时

2-当选择 Or 包含 "test" 时