/// <summary>
/// <see cref="ODataQueryCriteria"/> 查询的数据层实现。
/// </summary>
/// <param name="criteria"></param>
public virtual EntityList GetBy(ODataQueryCriteria criteria)
{
var t = f.Table(this.Repository);
var q = f.Query(from: t);
var properties = this.Repository.EntityMeta.ManagedProperties.GetCompiledProperties();
#region Filter
if (!string.IsNullOrWhiteSpace(criteria.Filter))
{
var parser = new ODataFilterParser
{
_properties = properties
};
parser.Parse(criteria.Filter, q);
}
#endregion
#region OrderBy
if (!string.IsNullOrWhiteSpace(criteria.OrderBy))
{
var orderByProperties = criteria.OrderBy.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var orderByExp in orderByProperties)
{
var values = orderByExp.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
var property = values[0];
var orderBy = properties.Find(property, true);
if (orderBy != null)
{
var dir = values.Length == 1 || values[1].ToLower() == "asc" ? OrderDirection.Ascending : OrderDirection.Descending;
q.OrderBy.Add(f.OrderBy(t.Column(orderBy), dir));
}
}
}
#endregion
#region Expand
if (!string.IsNullOrWhiteSpace(criteria.Expand))
{
var eagerLoad = new EagerLoadOptions();
var expandProperties = criteria.Expand.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var splitter = new char[] { '.' };
foreach (var expand in expandProperties)
{
//如果有'.'，表示类似于 Section.Chapter.Book 这种表达式。
if (expand.Contains('.'))
{
Type nextEntityType = null;//下一个需要使用的实体类型
var cascadeProperties = expand.Split(splitter, StringSplitOptions.RemoveEmptyEntries);
foreach (var property in cascadeProperties)
{
var container = properties;
if (nextEntityType != null)
{
var meta = CommonModel.Entities.Find(nextEntityType);
container = meta.ManagedProperties.GetCompiledProperties();
}
var mp = container.Find(property, true);
if (mp != null)
{
var refProperty = mp as IRefEntityProperty;
if (refProperty != null)
{
eagerLoad.LoadWith(refProperty);
nextEntityType = refProperty.RefEntityType;
}
else if (mp is IListProperty)
{
eagerLoad.LoadWith(mp as IListProperty);
nextEntityType = (mp as IListProperty).ListEntityType;
}
}
}
}
else
{
var mp = properties.Find(expand, true);
if (mp != null)
{
if (mp is IListProperty)
{
eagerLoad.LoadWith(mp as IListProperty);
}
else if (mp is IRefEntityProperty)
{
eagerLoad.LoadWith(mp as IRefEntityProperty);
}
}
else if (expand == EntityConvention.TreeChildrenPropertyName)
{
eagerLoad.LoadWithTreeChildren();
}
}
criteria.EagerLoad = eagerLoad;
}
}
#endregion
return(this.QueryList(q, criteria.PagingInfo, criteria.EagerLoad));
}
