Expression「Func「TSource, object」」 转Expression「Func「TSource, object」」[]

本文介绍了一种处理多个属性生成Lambda表达式的方法,从单一的Expression<Func<TSource,object>>到多个的Expression<Func<TSource,object>>[]。同时,提供了获取实体所有属性的Lambda表达式的数组实现。
 //处理多个属性生成Expression表达式,从Expression<Func<TSource, object>> 到Expression<Func<TSource, object>>[],单个到多个
//从 x=>new{x.a,x.b}  到 x=>x.a x=>x.b

private static Expression<Func<TSource, object>>[] ProcessExpressionObjet<TSource>(Expression<Func<TSource, object>> propertyExpression)
        {
            Expression<Func<TSource, object>>[] expressions = new Expression<Func<TSource, object>>[] { };
            Expression expression = propertyExpression.Body;
            while (expression.NodeType == ExpressionType.Convert || expression.NodeType == ExpressionType.ConvertChecked)
                expression = ((UnaryExpression)expression).Operand;
            //Parameter
            ParameterExpression parameterExpression = propertyExpression.Parameters.Single<ParameterExpression>();

            if (expression is NewExpression)
            {
                NewExpression newExpression = expression as NewExpression;
                if (newExpression == null)
                    return expressions;
                expressions = new Expression<Func<TSource, object>>[newExpression.Arguments.Count];
                int index = 0;
                foreach (Expression subExpression in newExpression.Arguments)
                {
                    MemberExpression member = subExpression as MemberExpression;
                    Expression exProperty = Expression.Property(parameterExpression, member.Member.Name);
                    var body = Expression.Convert(exProperty, typeof(object));
                    expressions[index] = Expression.Lambda<Func<TSource, object>>(body, parameterExpression);
                    index++;
                }
                return expressions;
            }
            else if (expression is MemberExpression)
            {
                expressions = new Expression<Func<TSource, object>>[1];
                Expression exProperty = Expression.Property(parameterExpression, (expression as MemberExpression).Member.Name);
                var body = Expression.Convert(exProperty, typeof(object));
                expressions[0] = Expression.Lambda<Func<TSource, object>>(body, parameterExpression);
                return expressions;
            }
            else
                return expressions;
        }

来源思路:

获取实体T的所有属性的lambda表达式数组:如x->x.a,x->x.b,x->x.b,x->x.c

public static Expression<Func<T, object>>[] GetExpressions<T>()
        {
            var properties = typeof(T).GetProperties();
            Expression<Func<T, object>>[] expressions = new Expression<Func<T, object>>[properties.Length];
            var p = Expression.Parameter(typeof(T), "x");
            for (int i = 0; i < properties.Length; i++)
            {
                Expression exProperty = Expression.Property(p, properties[i]);
                var body = Expression.Convert(exProperty, typeof(object));

                expressions[i] = Expression.Lambda<Func<T, object>>(body, p);
            }
            return expressions;
        }

 

public interface IRepository<TEntity> where TEntity : BaseEntity { /// <summary> /// EF DBContext /// </summary> VOLContext DbContext { get; } ISqlDapper DapperContext { get; } /// <summary> /// 执行事务。将在执行的方法带入Action /// </summary> /// <param name="action"></param> /// <returns></returns> WebResponseContent DbContextBeginTransaction(Func<WebResponseContent> action); /// <summary> /// 通过条件查询数据 /// </summary> /// <param name="where"></param> /// <returns></returns> List<TEntity> Find(Expression<Func<TEntity, bool>> where); /// <summary> /// /// </summary> /// <param name="predicate"></param> /// <param name="orderBySelector">排序字段,数据格式如: /// orderBy = x => new Dictionary<object, bool>() { /// { x.BalconyName,QueryOrderBy.Asc}, /// { x.TranCorpCode1,QueryOrderBy.Desc} /// }; /// /// </param> /// <returns></returns> TEntity FindFirst(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, QueryOrderBy>>> orderBy = null); /// <summary> /// /// </summary> /// <param name="predicate">where条件</param> /// <param name="orderBy">排序字段,数据格式如: /// orderBy = x => new Dictionary<object, bool>() { /// { x.BalconyName,QueryOrderBy.Asc}, /// { x.TranCorpCode1,QueryOrderBy.Desc} /// }; /// </param> /// <returns></returns> IQueryable<TEntity> FindAsIQueryable(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, QueryOrderBy>>> orderBy = null); /// <summary> /// 通过条件查询数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="predicate">查询条件</param> /// <param name="selector">返回类型如:Find(x => x.UserName == loginInfo.userName, p => new { uname = p.UserName });</param> /// <returns></returns> List<T> Find<T>(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, T>> selector); /// <summary> /// 根据条件,返回查询的类 /// </summary> /// <typeparam name="TFind"></typeparam> /// <param name="predicate"></param> /// <returns></returns> List<TFind> Find<TFind>(Expression<Func<TFind, bool>> predicate) where TFind : class; Task<TFind> FindAsyncFirst<TFind>(Expression<Func<TFind, bool>> predicate) where TFind : class; Task<TEntity> FindAsyncFirst(Expression<Func<TEntity, bool>> predicate); Task<List<TFind>> FindAsync<TFind>(Expression<Func<TFind, bool>> predicate) where TFind : class; Task<TEntity> FindFirstAsync(Expression<Func<TEntity, bool>> predicate); Task<List<TEntity>> FindAsync(Expression<Func<TEntity, bool>> predicate); Task<List<T>> FindAsync<T>(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, T>> selector); Task<T> FindFirstAsync<T>(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, T>> selector); /// <summary> /// 多条件查询 /// </summary> /// <typeparam name="Source"></typeparam> /// <param name="sources">要查询的多个条件的数据源</param> /// <param name="predicate">生成的查询条件</param> /// <returns></returns> List<TEntity> Find<Source>(IEnumerable<Source> sources, Func<Source, Expression<Func<TEntity, bool>>> predicate) where Source : class; /// <summary> /// 多条件查询 /// </summary> /// <typeparam name="Source"></typeparam> /// <param name="sources">要查询的多个条件的数据源</param> /// <param name="predicate">生成的查询条件</param> /// <param name="selector">自定义返回结果</param> /// <returns></returns> List<TResult> Find<Source, TResult>(IEnumerable<Source> sources, Func<Source, Expression<Func<TEntity, bool>>> predicate, Expression<Func<TEntity, TResult>> selector) where Source : class; /// <summary> /// 多条件查询 /// </summary> /// <typeparam name="Source"></typeparam> /// <param name="sources">要查询的多个条件的数据源</param> /// <param name="predicate">生成的查询条件</param> /// <returns></returns> IQueryable<TEntity> FindAsIQueryable<Source>(IEnumerable<Source> sources, Func<Source, Expression<Func<TEntity, bool>>> predicate) where Source : class; Task<bool> ExistsAsync(Expression<Func<TEntity, bool>> predicate); bool Exists(Expression<Func<TEntity, bool>> predicate); bool Exists<TExists>(Expression<Func<TExists, bool>> predicate) where TExists : class; Task<bool> ExistsAsync<TExists>(Expression<Func<TExists, bool>> predicate) where TExists : class; IIncludableQueryable<TEntity, TProperty> Include<TProperty>(Expression<Func<TEntity, TProperty>> incluedProperty); /// <summary> /// /// </summary> /// <typeparam name="TResult"></typeparam> /// <param name="pageIndex"></param> /// <param name="pagesize"></param> /// <param name="rowcount"></param> /// <param name="predicate"></param> /// <param name="orderBy"> /// 通过多个字段排序Expression<Func<TEntity, Dictionary<object, bool>>> /// orderBy = x => new Dictionary<object, bool>() { /// { x.BalconyName,QueryOrderBy.Asc}, /// { x.TranCorpCode1,QueryOrderBy.Desc} /// }; /// <param name="selectorResult">查询返回的对象</param> /// <returns></returns> List<TResult> QueryByPage<TResult>(int pageIndex, int pagesize, out int rowcount, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, QueryOrderBy>>> orderBySelector, Expression<Func<TEntity, TResult>> selectorResult, bool returnRowCount = true); List<TResult> QueryByPage<TResult>(int pageIndex, int pagesize, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, QueryOrderBy>>> orderBy, Expression<Func<TEntity, TResult>> selectorResult = null); /// <summary> /// /// </summary> /// <param name="pageIndex"></param> /// <param name="pagesize"></param> /// <param name="rowcount"></param> /// <param name="predicate"></param> /// <param name="orderBy"></param> /// /// 通过多个字段排序Expression<Func<TEntity, Dictionary<object, bool>>> /// orderBy = x => new Dictionary<object, bool>() { /// { x.BalconyName,QueryOrderBy.Asc}, /// { x.TranCorpCode1,QueryOrderBy.Desc} /// }; /// <returns></returns> List<TEntity> QueryByPage(int pageIndex, int pagesize, out int rowcount, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, QueryOrderBy>>> orderBy, bool returnRowCount = true); IQueryable<TFind> IQueryablePage<TFind>(int pageIndex, int pagesize, out int rowcount, Expression<Func<TFind, bool>> predicate, Expression<Func<TEntity, Dictionary<object, QueryOrderBy>>> orderBy, bool returnRowCount = true) where TFind : class; IQueryable<TEntity> IQueryablePage(IQueryable<TEntity> queryable, int pageIndex, int pagesize, out int rowcount, Dictionary<string, QueryOrderBy> orderBy, bool returnRowCount = true); /// <summary> /// /// </summary> /// <param name="entity"></param> /// <param name="properties">指定更新字段:x=>new {x.Name,x.Enable}</param> /// <param name="saveChanges">是否保存</param> /// <returns></returns> int Update(TEntity entity, Expression<Func<TEntity, object>> properties, bool saveChanges = false); /// <summary> /// /// </summary> /// <param name="entity"></param> /// <param name="properties">指定更新字段:x=>new {x.Name,x.Enable}</param> /// <param name="saveChanges">是否保存</param> /// <returns></returns> int Update<TSource>(TSource entity, Expression<Func<TSource, object>> properties, bool saveChanges = false) where TSource : class; int Update<TSource>(TSource entity, bool saveChanges = false) where TSource : class; int Update<TSource>(TSource entity, string[] properties, bool saveChanges = false) where TSource : class; int UpdateRange<TSource>(IEnumerable<TSource> entities, bool saveChanges = false) where TSource : class; /// <summary> /// /// </summary> /// <param name="entity"></param> /// <param name="properties">指定更新字段:x=>new {x.Name,x.Enable}</param> /// <param name="saveChanges">是否保存</param> /// <returns></returns> int UpdateRange<TSource>(IEnumerable<TSource> models, Expression<Func<TSource, object>> properties, bool saveChanges = false) where TSource : class; int UpdateRange<TSource>(IEnumerable<TSource> entities, string[] properties, bool saveChanges = false) where TSource : class; /// <summary> ///修改时同时对明细的添加、删除、修改 /// </summary> /// <param name="entity"></param> /// <param name="updateDetail">是否修改明细</param> /// <param name="delNotExist">是否删除明细不存在的数据</param> /// <param name="updateMainFields">主表指定修改字段</param> /// <param name="updateDetailFields">明细指定修改字段</param> /// <param name="saveChange">是否保存</param> /// <returns></returns> WebResponseContent UpdateRange<Detail>(TEntity entity, bool updateDetail = false, bool delNotExist = false, Expression<Func<TEntity, object>> updateMainFields = null, Expression<Func<Detail, object>> updateDetailFields = null, bool saveChange = false) where Detail : class; void Delete(TEntity model, bool saveChanges=false); /// <summary> /// /// </summary> /// <param name="keys"></param> /// <param name="delList">是否将子表的数据也删除</param> /// <returns></returns> int DeleteWithKeys(object[] keys, bool delList = false); void Add(TEntity entities, bool SaveChanges = false); void AddRange(IEnumerable<TEntity> entities, bool SaveChanges = false); Task AddAsync(TEntity entities); Task AddRangeAsync(IEnumerable<TEntity> entities); void AddRange<T>(IEnumerable<T> entities, bool saveChanges = false) where T : class; void BulkInsert(IEnumerable<TEntity> entities, bool setOutputIdentity = false); int SaveChanges(); Task<int> SaveChangesAsync(); int ExecuteSqlCommand(string sql, params SqlParameter[] sqlParameters); List<TEntity> FromSql(string sql, params SqlParameter[] sqlParameters); /// <summary> /// 执行sql /// 使用方式 FormattableString sql=$"select * from xx where name ={xx} and pwd={xx1} ", /// FromSqlInterpolated内部处理sql注入的问题,直接在{xx}写对应的值即可 /// 注意:sql必须 select * 返回所有TEntity字段, /// </summary> /// <param name="formattableString"></param> /// <returns></returns> IQueryable<TEntity> FromSqlInterpolated([System.Diagnostics.CodeAnalysis.NotNull] FormattableString sql); /// <summary> /// 取消上下文跟踪 /// 更新报错时,请调用此方法:The instance of entity type 'XXX' cannot be tracked because another instance with the same key value for {'XX'} is already being tracked. /// </summary> /// <param name="entity"></param> void Detached(TEntity entity); void DetachedRange(IEnumerable<TEntity> entities); }
最新发布
08-01
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值