C# Lambda表达式动态拼接合并，进行两张表的多条件联合查询。

Lamda表达式的拼接合并类

    /// <summary>
    /// Lambda表达式拼接扩展类
    /// </summary>
    public static class ExpressionHelp
    {
        /// <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> Compose<T>(this Expression<T> first, Expression<T> second, Func<Expression, Expression, Expression> merge)
        {
            var map = first.Parameters.Select((f, i) => new { f, s = second.Parameters[i] }).ToDictionary(p => p.s, p => p.f);
            var secondBody = ParameterRebinder.ReplaceParameters(map, second.Body);
            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<T1, T2, bool>> And<T1, T2>(this Expression<Func<T1, T2, bool>> first, Expression<Func<T1, T2, bool>> second)
        {
            return first.Compose(second, Expression.And);
        }
        public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
        {
            return first.Compose(second, Expression.And);
        }

        /// <summary>
        /// or扩展
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="first"></param>
        /// <param name="second"></param>
        /// <returns></returns>
        public static Expression<Func<T1, T2, bool>> Or<T1, T2>(this Expression<Func<T1, T2, bool>> first, Expression<Func<T1, T2, bool>> second)
        {
            return first.Compose(second, Expression.Or);
        }
        public static Expression<Func<T, bool>> Or<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
        {
            return first.Compose(second, Expression.Or);
        }

    }

    /// <summary>
    /// 
    /// </summary>
    public class ParameterRebinder : ExpressionVisitor
    {
        private readonly Dictionary<ParameterExpression, ParameterExpression> map;
        /// <summary>
        /// 
        /// </summary>
        /// <param name="map"></param>
        public ParameterRebinder(Dictionary<ParameterExpression, ParameterExpression> map)
        {
            this.map = map ?? new Dictionary<ParameterExpression, ParameterExpression>();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="map"></param>
        /// <param name="exp"></param>
        /// <returns></returns>
        public static Expression ReplaceParameters(Dictionary<ParameterExpression, ParameterExpression> map, Expression exp)
        {
            return new ParameterRebinder(map).Visit(exp);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="p"></param>
        /// <returns></returns>
        protected override Expression VisitParameter(ParameterExpression p)
        {
            ParameterExpression replacement;
            if (map.TryGetValue(p, out replacement))
            {
                p = replacement;
            }
            return base.VisitParameter(p);
        }
    }

在组合条件查询时，根据输入的参数进行动态合并，使用如下：

                Expression<Func<TaskRunRecord, TaskSet, bool>> where = ((trr, ts) => trr.Id == inId);
                Expression<Func<TaskRunRecord, TaskSet, bool>> exp1 = (trr, ts) => true;
                Expression<Func<TaskRunRecord, TaskSet, bool>> exp2 = (trr, ts) => true;
                Expression<Func<TaskRunRecord, TaskSet, bool>> exp3 = (trr, ts) => true;
                Expression<Func<TaskRunRecord, TaskSet, bool>> exp4 = (trr, ts) => true;
                if (!string.IsNullOrEmpty(taskName.Trim()))
                {
                    exp1 = (trr, ts) => ts.TaskName == taskName;
                    where = ExpressionHelp.And(where, exp1);
                }
                if (!string.IsNullOrEmpty(userName.Trim()))
                {
                    exp2 = (trr, ts) => trr.UserName == userName;
                    where = ExpressionHelp.And(where, exp2);
                }
                if (!string.IsNullOrEmpty(fromTime.Trim()))
                {
                    DateTime fromtt = GetDataTime(fromTime);
                    exp3 = (trr, ts) => trr.StartTime >= fromtt;
                    where = ExpressionHelp.And(where, exp3);
                }
                if (!string.IsNullOrEmpty(toTime.Trim()))
                {
                    exp4 = (trr, ts) => trr.StartTime <= GetDataTime(toTime);
                    where = ExpressionHelp.And(where, exp4);
                }

对两张表进行多条件联合查询

 List<TaskRunRecordData> trrDataLists = new List<TaskRunRecordData>();
                SqlSugarClient db = SugarFactoryMserver.GetInstance();
                trrDataLists = db.Queryable<TaskRunRecord, TaskSet>((trr, ts) => new object[]
                {
                    JoinType.Left, trr.TaskId == ts.Id && trr.rId == ts.rId
                }).Where(where).
                    OrderBy(trr => trr.StartTime, OrderByType.Desc).
                    Select((trr, ts) => new TaskRunRecordData
                    {
                        rId = rId,
                        TaskId = ts.Id,
                        TaskRunRecordId = trr.IncreaseId,
                        TaskName = ts.TaskName,
                        UserName = trr.UserName,
                        StartTime = trr.StartTime,
                        EndTime = trr.EndTime,
                        TaskDescription = ts.Description
                    }).ToPageList(pageIndex, pageSize, ref totalNum);