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);