动态生成FreeSql的过滤表达式

1、主要是做一个通用的过滤器，如果泛型实体对象中存在成员，则构建过滤器。

/// <summary>
/// 过滤器
/// </summary>
/// <typeparam name="T"></typeparam>
public class FreeSqlFilter<T>
{
	/// <summary>
	/// 相等过滤器
	/// </summary>
	/// <param name="membername"></param>
	/// <param name="value"></param>
	/// <returns></returns>
	public static Expression<Func<T, bool>> FilterEqual(string membername, object value)
	{
		if (value == null)
			return null;

		Type type = typeof(T);
		PropertyInfo p = type.GetProperty(membername);
		if (p == null)
		{
			return null;
		}

		var param_obj = Expression.Parameter(typeof(T));
		var left = Expression.Property(param_obj, p);
		Expression constantValue = Expression.Constant(value);
		// 类型转换
		Expression right = Expression.Convert(constantValue, p.PropertyType);

		var body = Expression.Equal(left, right);
		var result = Expression.Lambda<Func<T, bool>>(body, param_obj);
		return result;
	}

	/// <summary>
	/// 包含过滤器
	/// </summary>
	/// <typeparam name="T1"></typeparam>
	/// <param name="membername"></param>
	/// <param name="value"></param>
	/// <returns></returns>
	public static Expression<Func<T, bool>> FilterConstain<T1>(string membername, List<T1> value)
	{
		if (value == null || value.Count < 1)
			return null;

		Type type = typeof(T);
		PropertyInfo p = type.GetProperty(membername);
		if (p == null)
		{
			return null;
		}

		var param_obj = Expression.Parameter(typeof(T));
		var propItem = Expression.Property(param_obj, p);
		// 类型转换
		Expression arg0 = Expression.Convert(propItem, typeof(T1));
		var containsMethod = typeof(List<T1>).GetMethod("Contains", new Type[] { typeof(T1) });
		var listValue = System.Linq.Expressions.Expression.Constant(value);
		var body = MethodCallExpression.Call(listValue, containsMethod, arg0);
		var result = Expression.Lambda<Func<T, bool>>(body, param_obj);
		return result;
	}
}

2、调用

/// <summary>
/// 忽略的实体
/// </summary>
public static List<string> IgnoreEntity = new List<string>
{
	"Enterprise",
};

...

// 设置过滤器
Expression<Func<T, bool>> filter = null;
if (!IgnoreEntity.Contains(typeof(T).Name))
{
	filter = FreeSqlFilter<T>.FilterConstain<string>("Code", new List<string> { "F4011", "4012" });
	
}
this.selectSql = freeSql.Queryable<T>().Where(filter);