• 返回一个条件表达式树的拓展方法


    之前做了一个这样的功能,一个页面的查询功能,需要支持很多条件,然后可以点击添加一个条件,类似于Navicat 的这种

    代码如下

    /// <summary>
            /// 根据条件返回表达式树
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <typeparam name="V"></typeparam>
            /// <param name="propName">字段名</param>
            /// <param name="value"></param>
            /// <param name="ysf">运算符</param>
            /// <returns></returns>
            public static Expression<Func<T, bool>> GenerateExpression<T, V>(string propName, V value, string ysf) where T : class, new()
            {
                Type type = typeof(T);
                //获得参数表达式树
                ParameterExpression parameterExpression = Expression.Parameter(type, "item");
                //分割字段
                string[] propNameArray = propName.Split('.');
                var _propName = propNameArray[0];
                //获取返回类型的公共属性
                int i = 1;
                PropertyInfo propInfo = type.GetProperty(_propName);
                //定义成员表达式树
                MemberExpression memberExpression = Expression.Property(parameterExpression, propInfo);
                //如果字段有导航属性,则执行下面
                for (; i < propNameArray.Length; i++)
                {
                    //获取下一级的公共属性
                    propInfo = propInfo.PropertyType.GetProperty(propNameArray[i]);
                    //获取下一级的成员表达式树
                    memberExpression = Expression.Property(memberExpression, propInfo);
                }
                //把参数value转型成和propInfo字段一样的类型
                try
                {
                    TypeConverter typeConverter = TypeDescriptor.GetConverter(propInfo.PropertyType);
                    var _value = typeConverter.ConvertFrom(value);
                    //获取常量表达式树
                    ConstantExpression constantExpression = Expression.Constant(_value, propInfo.PropertyType);
                    if (ysf == ">")
                    {
                        //Expression.GreaterThan表达式树大于比较,成员树memberExpression,常量值树constantExpression,生成二元运算树BinaryExp
                        BinaryExpression BinaryExp = Expression.GreaterThan(memberExpression, constantExpression);
                        return Expression.Lambda<Func<T, bool>>(BinaryExp, new ParameterExpression[] { parameterExpression });
                    }
                    else if (ysf == ">=")
                    {
                        BinaryExpression BinaryExp = Expression.GreaterThanOrEqual(memberExpression, constantExpression);
                        return Expression.Lambda<Func<T, bool>>(BinaryExp, new ParameterExpression[] { parameterExpression });
                    }
                    else if (ysf == "<")
                    {
                        BinaryExpression BinaryExp = Expression.LessThan(memberExpression, constantExpression);
                        return Expression.Lambda<Func<T, bool>>(BinaryExp, new ParameterExpression[] { parameterExpression });
                    }
                    else if (ysf == "<=")
                    {
                        BinaryExpression BinaryExp = Expression.LessThanOrEqual(memberExpression, constantExpression);
                        return Expression.Lambda<Func<T, bool>>(BinaryExp, new ParameterExpression[] { parameterExpression });
                    }
                    else if (ysf == "=")
                    {
                        var methodExpress = Expression.Call(memberExpression, propInfo.PropertyType.GetMethod("Equals", new Type[] { propInfo.PropertyType }), new Expression[] { constantExpression });
                        //返回lamda表达式树
                        return Expression.Lambda<Func<T, bool>>(methodExpress, new ParameterExpression[] { parameterExpression });
                    }
                    else if (ysf == "like")
                    {
                        constantExpression = Expression.Constant(_value, propInfo.PropertyType);
                        var methodExpress = Expression.Call(memberExpression, propInfo.PropertyType.GetMethod("Contains", new Type[] { propInfo.PropertyType }), new Expression[] { constantExpression });
                        //返回lamda表达式树
                        return Expression.Lambda<Func<T, bool>>(methodExpress, new ParameterExpression[] { parameterExpression });
                    }
                    else
                    {
                        new VerifyException("运算符不正确");
                        return null;
                    }
                }
                catch (Exception)
                {
    
                    throw new VerifyException($"第{i}个字段的值格式不正确");
                }
            }
  • 相关阅读:
    Masscan入门手册
    Deepin安装Python3
    docker 配置 kafka+zookeeper,golang操作kafka
    VMware安装Centos7超详细过程(图文)
    国家代码查询
    thinkphp5 关于跨域的一些坑,附上解决办法(比较全面了)
    网络协议分析与抓包 TCP/IP UDP等
    一维数组分组成二维数组
    Fiddler在抓取https数据包时如何解决Tunnel to 443的问题?
    十条nmap常用的扫描命令
  • 原文地址:https://www.cnblogs.com/haixiaocan/p/10699839.html
Copyright © 2020-2023  润新知