/// <summary>
/// 如果提供的值是不可空的，则为查询添加一个对应的约束条件，并以 And 与原条件进行连接。
/// </summary>
/// <param name="query">查询.</param>
/// <param name="property">要约束的属性.</param>
/// <param name="op">约束条件操作符.</param>
/// <param name="value">当 value 不可空时，才添加这个对比约束条件。</param>
/// <returns></returns>
public static IQuery AddConstraintIf(this IQuery query, IManagedProperty property, PropertyOperator op, object value)
{
if (ConditionalSql.IsNotEmpty(value))
{
return(AddConstraint(query, property, op, value));
}
return(query);
}
/// <summary>
/// 根据传入的属性列表，来构造 CommonQueryCriteria
/// 返回是否有非空属性需要验证。
/// </summary>
/// <param name="entity"></param>
/// <param name="criteria"></param>
/// <returns></returns>
private bool AddToCriteria(Entity entity, CommonQueryCriteria criteria)
{
bool hasValue = false;
foreach (IProperty property in this.Properties)
{
EnsurePropertyCategory(property);
var value = entity.GetProperty(property);
if (ConditionalSql.IsNotEmpty(value))
{
hasValue = true;
criteria.Add(property, value);
}
}
if (entity.HasId)
{
criteria.Add(Entity.IdProperty, PropertyOperator.NotEqual, entity.Id);
}
return(hasValue);
}
/// <summary>
/// <see cref="CommonQueryCriteria"/> 查询的数据层实现。
/// </summary>
/// <param name="criteria"></param>
public virtual EntityList GetBy(CommonQueryCriteria criteria)
{
var table = qf.Table(_repository);
var q = qf.Query(table);
var allProperties = _repository.EntityMeta.ManagedProperties.GetNonReadOnlyCompiledProperties();
//拼装所有 Where 条件。
bool ignoreNull = criteria.IgnoreNull;
foreach (var group in criteria.Groups)
{
IConstraint groupRes = null;
foreach (var pm in group)
{
var property = allProperties.Find(pm.PropertyName);
if (property != null)
{
var op = pm.Operator;
var value = pm.Value;
bool ignored = false;
if (ignoreNull)
{
ignored = !ConditionalSql.IsNotEmpty(value);
}
else
{
if (value is string || (value == null && property.PropertyType == typeof(string)))
{
#region 如果是对空字符串进行模糊匹配，那么这个条件需要被忽略。
var strValue = value as string;
if (string.IsNullOrEmpty(strValue))
{
switch (op)
{
case PropertyOperator.Like:
case PropertyOperator.Contains:
case PropertyOperator.StartWith:
case PropertyOperator.EndWith:
ignored = true;
break;
default:
break;
}
}
#endregion
}
}
if (!ignored)
{
var propertyRes = qf.Constraint(table.Column(property), op, value);
groupRes = qf.Binary(groupRes, group.Concat, propertyRes);
}
}
}
q.Where = qf.Binary(groupRes, criteria.Concat, q.Where);
}
//OrderBy
if (!string.IsNullOrWhiteSpace(criteria.OrderBy))
{
var orderBy = allProperties.Find(criteria.OrderBy);
if (orderBy != null)
{
var dir = criteria.OrderByAscending ? OrderDirection.Ascending : OrderDirection.Descending;
q.OrderBy.Add(table.Column(orderBy), dir);
}
}
return(this.QueryList(q, criteria.PagingInfo, criteria.EagerLoad));
}