Expression<Func<T, bool>> 扩展方法的使用方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Linq.Expressions;

namespace ZhaoXi.ASP.NET.MVC5.AuthorityProject.Models
{

    namespace Core.Util
    {

        //用法
         // var predicate = PredicateBuilder.GetTrue<Student>();
         //predicate = predicate.And(it => it.id.ToString().Contains(strID));
         //predicate = predicate.And(it => it.Birthday.ToString().Contains(strBir));
         //predicate = predicate.And(it => it.Sex.ToString().Contains(strSex));
         //predicate = predicate.And(it => it.Age == 20);
         //var lst = db.Queryable<Student>.Where(predicate).ToList();
        /// 
        /// 
        /// </summary>
        public static partial class Extention
        {
            #region 拓展AndIf与AndOr

            /// <summary>
            /// 符合条件则And
            /// </summary>
            /// <typeparam name="T">实体类型</typeparam>
            /// <param name="left">原表达式</param>
            /// <param name="need">是否符合条件</param>
            /// <param name="right">新表达式</param>
            /// <returns></returns>
            public static Expression<Func<T, bool>> AndIf<T>(this Expression<Func<T, bool>> left, bool need, Expression<Func<T, bool>> right)
            {
                if (need)
                {
                    // return left.And(right);
                    return left;
                }
                else
                {
                    return left;
                }
            }

            public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
            {
                return first.AndAlso<T>(second, Expression.AndAlso);
            }
            public static Expression<Func<T, bool>> Or<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
            {
                return first.AndAlso<T>(second, Expression.OrElse);
            }
            private static Expression<Func<T, bool>> AndAlso<T>(this Expression<Func<T, bool>> expr1, Expression<Func<T, bool>> expr2, Func<Expression, Expression, BinaryExpression> 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.Lambda<Func<T, bool>>(
                    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);
                }
            }

            /// <summary>
            /// 符合条件则Or
            /// </summary>
            /// <typeparam name="T">实体类型</typeparam>
            /// <param name="left">原表达式</param>
            /// <param name="need">是否符合条件</param>
            /// <param name="right">新表达式</param>
            /// <returns></returns>
            public static Expression<Func<T, bool>> OrIf<T>(this Expression<Func<T, bool>> left, bool need, Expression<Func<T, bool>> right)
            {
                if (need)
                {
                    // return left.Or(right);
                    return left;
                }
                else
                {
                    return left;
                }
            }

            #endregion

            #region 拓展BuildExtendSelectExpre方法

            /// <summary>
            /// 组合继承属性选择表达式树,无拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, TResult>> BuildExtendSelectExpre<TBase, TResult>(this Expression<Func<TBase, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,1个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, TResult>> BuildExtendSelectExpre<TBase, T1, TResult>(this Expression<Func<TBase, T1, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,2个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, TResult>> BuildExtendSelectExpre<TBase, T1, T2, TResult>(this Expression<Func<TBase, T1, T2, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,3个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, TResult>(this Expression<Func<TBase, T1, T2, T3, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,4个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="T4">拓展类型4</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, T4, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, T4, TResult>(this Expression<Func<TBase, T1, T2, T3, T4, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, T4, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,5个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="T4">拓展类型4</typeparam>
            /// <typeparam name="T5">拓展类型5</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, T4, T5, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, T4, T5, TResult>(this Expression<Func<TBase, T1, T2, T3, T4, T5, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, T4, T5, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,6个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="T4">拓展类型4</typeparam>
            /// <typeparam name="T5">拓展类型5</typeparam>
            /// <typeparam name="T6">拓展类型6</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, T4, T5, T6, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, T4, T5, T6, TResult>(this Expression<Func<TBase, T1, T2, T3, T4, T5, T6, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, T4, T5, T6, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,7个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="T4">拓展类型4</typeparam>
            /// <typeparam name="T5">拓展类型5</typeparam>
            /// <typeparam name="T6">拓展类型6</typeparam>
            /// <typeparam name="T7">拓展类型7</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, T4, T5, T6, T7, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, T4, T5, T6, T7, TResult>(this Expression<Func<TBase, T1, T2, T3, T4, T5, T6, T7, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, T4, T5, T6, T7, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,8个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="T4">拓展类型4</typeparam>
            /// <typeparam name="T5">拓展类型5</typeparam>
            /// <typeparam name="T6">拓展类型6</typeparam>
            /// <typeparam name="T7">拓展类型7</typeparam>
            /// <typeparam name="T8">拓展类型8</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, T4, T5, T6, T7, T8, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, T4, T5, T6, T7, T8, TResult>(this Expression<Func<TBase, T1, T2, T3, T4, T5, T6, T7, T8, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, T4, T5, T6, T7, T8, TResult>>(expression);
            }

            /// <summary>
            /// 组合继承属性选择表达式树,9个拓展参数
            /// TResult将继承TBase的所有属性
            /// </summary>
            /// <typeparam name="TBase">原数据类型</typeparam>
            /// <typeparam name="T1">拓展类型1</typeparam>
            /// <typeparam name="T2">拓展类型2</typeparam>
            /// <typeparam name="T3">拓展类型3</typeparam>
            /// <typeparam name="T4">拓展类型4</typeparam>
            /// <typeparam name="T5">拓展类型5</typeparam>
            /// <typeparam name="T6">拓展类型6</typeparam>
            /// <typeparam name="T7">拓展类型7</typeparam>
            /// <typeparam name="T8">拓展类型8</typeparam>
            /// <typeparam name="T9">拓展类型9</typeparam>
            /// <typeparam name="TResult">返回类型</typeparam>
            /// <param name="expression">拓展表达式</param>
            /// <returns></returns>
            public static Expression<Func<TBase, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>> BuildExtendSelectExpre<TBase, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>(this Expression<Func<TBase, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>> expression)
            {
                return GetExtendSelectExpre<TBase, TResult, Func<TBase, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>>(expression);
            }

            #endregion

            #region 私有成员

            private static Expression<TDelegate> GetExtendSelectExpre<TBase, TResult, TDelegate>(Expression<TDelegate> expression)
            {
                NewExpression newBody = Expression.New(typeof(TResult));
                MemberInitExpression oldExpression = (MemberInitExpression)expression.Body;

                ParameterExpression[] oldParamters = expression.Parameters.ToArray();
                List<string> existsProperties = new List<string>();
                oldExpression.Bindings.ToList().ForEach(aBinding =>
                {
                    existsProperties.Add(aBinding.Member.Name);
                });

                List<MemberBinding> newBindings = new List<MemberBinding>();
                typeof(TBase).GetProperties().Where(x => !existsProperties.Contains(x.Name)).ToList().ForEach(aProperty =>
                {
                    if (typeof(TResult).GetMembers().Any(x => x.Name == aProperty.Name))
                    {
                        MemberBinding newMemberBinding = null;
                        var valueExpre = Expression.Property(oldParamters[0], aProperty.Name);
                        if (typeof(TBase).IsAssignableFrom(typeof(TResult)))
                        {
                            newMemberBinding = Expression.Bind(aProperty, valueExpre);
                        }
                        else
                        {
                            newMemberBinding = Expression.Bind(typeof(TResult).GetProperty(aProperty.Name), valueExpre);
                        }
                        newBindings.Add(newMemberBinding);
                    }
                });

                newBindings.AddRange(oldExpression.Bindings);

                var body = Expression.MemberInit(newBody, newBindings.ToArray());
                var resExpression = Expression.Lambda<TDelegate>(body, oldParamters);

                return resExpression;
            }

            #endregion
        }

        /// <summary>
        /// 继承ExpressionVisitor类,实现参数替换统一
        /// </summary>
        internal class ParameterReplaceVisitor : System.Linq.Expressions.ExpressionVisitor
        {
            public ParameterReplaceVisitor(ParameterExpression paramExpr)
            {
                _parameter = paramExpr;
            }

            //新的表达式参数
            private readonly ParameterExpression _parameter;

            protected override Expression VisitParameter(ParameterExpression p)
            {
                if (p.Type == _parameter.Type)
                {
                    return _parameter;
                }

                else
                {
                    return p;
                }
            }
        }
    }

}

public interface IService<T> where T : BaseEntity { ICacheService CacheContext { get; } Microsoft.AspNetCore.Http.HttpContext Context { get; } /// <summary> /// 前端查询条件转换为EF查询Queryable(2023.04.02) /// </summary> /// <param name="options">前端查询参数</param> /// <param name="useTenancy">是否使用数据隔离</param> /// <returns></returns> IQueryable<T> GetPageDataQueryFilter(PageDataOptions options, bool useTenancy = true); /// <summary> /// 查询 /// </summary> /// <param name="pageData"></param> /// <returns></returns> PageGridData<T> GetPageData(PageDataOptions pageData); object GetDetailPage(PageDataOptions pageData); WebResponseContent Upload(List<IFormFile> files); WebResponseContent DownLoadTemplate(); WebResponseContent Import(List<IFormFile> files); /// <summary> /// 导出 /// </summary> /// <param name="pageData"></param> /// <returns></returns> WebResponseContent Export(PageDataOptions pageData); /// <summary> /// 新增 /// </summary> /// <param name="saveDataModel">主表与子表的数据</param> /// <returns></returns> WebResponseContent Add(SaveModel saveDataModel); /// <summary> /// /// </summary> /// <param name="entity">保存的实体</param> /// <param name="validationEntity">是否对实体进行校验</param> /// <returns></returns> WebResponseContent AddEntity(T entity, bool validationEntity = true); /// <summary> /// /// </summary> /// <typeparam name="TDetail"></typeparam> /// <param name="entity">保存的实体</param> /// <param name="list">保存的明细</param> /// <param name="validationEntity">是否对实体进行校验</param> /// <returns></returns> WebResponseContent Add<TDetail>(T entity, List<TDetail> list = null, bool validationEntity = true) where TDetail : class; /// <summary> /// 编辑 /// </summary> /// <param name="saveDataModel">主表与子表的数据</param> /// <returns></returns> WebResponseContent Update(SaveModel saveDataModel); /// <summary> /// 删除数据 /// </summary> /// <param name="keys">删除的主键</param> /// <param name="delList">是否删除对应明细(默认会删除明细)</param> /// <returns></returns> WebResponseContent Del(object[] keys, bool delList = true); WebResponseContent Audit(object[] id, int? auditStatus, string auditReason); (string, T, bool) ApiValidate(string bizContent, Expression<Func<T, object>> expression = null); /// <summary> /// /// </summary> /// <typeparam name="TInput"></typeparam> /// <param name="bizContent"></param> /// <param name="expression">对指属性验证格式如:x=>new { x.UserName,x.Value }</param> /// <returns>(string,TInput, bool) string:返回验证消息,TInput:bizContent序列化后的对象,bool:验证是否通过</returns> (string, TInput, bool) ApiValidateInput<TInput>(string bizContent, Expression<Func<TInput, object>> expression); /// <summary> /// /// </summary> /// <typeparam name="TInput"></typeparam> /// <param name="bizContent"></param> /// <param name="expression">对指属性验证格式如:x=>new { x.UserName,x.Value }</param> /// <param name="validateExpression">对指定的字段只做合法性判断比如长度是是否超长</param> /// <returns>(string,TInput, bool) string:返回验证消息,TInput:bizContent序列化后的对象,bool:验证是否通过</returns> (string, TInput, bool) ApiValidateInput<TInput>(string bizContent, Expression<Func<TInput, object>> expression, Expression<Func<TInput, object>> validateExpression); /// <summary> /// 将数据源映射到新的数据中,List<TSource>映射到List<TResult>或TSource映射到TResult /// 目前只支持Dictionary或实体类型 /// </summary> /// <typeparam name="TSource"></typeparam> /// <typeparam name="TResult"></typeparam> /// <param name="source"></param> /// <param name="resultExpression">只映射返回对象的指定字段</param> /// <param name="sourceExpression">只映射数据源对象的指定字段</param> /// 过滤条件表达式调用方式:List表达式x => new { x[0].MenuName, x[0].Menu_Id},表示指定映射MenuName,Menu_Id字段 /// List<Sys_Menu> list = new List<Sys_Menu>(); /// list.MapToObject<List<Sys_Menu>, List<Sys_Menu>>(x => new { x[0].MenuName, x[0].Menu_Id}, null); /// ///过滤条件表达式调用方式:实体表达式x => new { x.MenuName, x.Menu_Id},表示指定映射MenuName,Menu_Id字段 /// Sys_Menu sysMenu = new Sys_Menu(); /// sysMenu.MapToObject<Sys_Menu, Sys_Menu>(x => new { x.MenuName, x.Menu_Id}, null); /// <returns></returns> TResult MapToEntity<TSource, TResult>(TSource source, Expression<Func<TResult, object>> resultExpression, Expression<Func<TSource, object>> sourceExpression = null) where TResult : class; /// <summary> /// 将一个实体的赋到另一个实体上,应用场景: /// 两个实体,a a1= new a();b b1= new b(); a1.P=b1.P; a1.Name=b1.Name; /// </summary> /// <typeparam name="TSource"></typeparam> /// <typeparam name="TResult"></typeparam> /// <param name="source"></param> /// <param name="result"></param> /// <param name="expression">指定对需要的字段赋值,格式x=>new {x.Name,x.P},返回的结果只会对Name与P赋值</param> void MapValueToEntity<TSource, TResult>(TSource source, TResult result, Expression<Func<TResult, object>> expression = null) where TResult : class; }
08-01
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值