public IList <MessageData> Search(CommonSearchNode parameter)
{
IQueryable <Message> list = null;
if (parameter.Pagination.NoPaging == true)
{
list = this.db.Database.SqlQuery <Message>(parameter.GetSearchSQL()).AsQueryable();
}
else
{
list = this.db.Database.SqlQuery <Message>(parameter.GetSearchSQL()).AsQueryable().Skip(parameter.Pagination.Size * (parameter.Pagination.Index - 1)).Take(parameter.Pagination.Size);
}
parameter.Pagination.All = Count(parameter);
if (parameter.Pagination.Size != 0)
{
parameter.Pagination.Count = parameter.Pagination.All / parameter.Pagination.Size;
}
return(list.ToViewList());
}
/// <summary>
/// 复杂条件查询
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public virtual void Search(CommonSearchNode parameter, ref IQueryable <TObject> list)
{
//IQueryable<TObject> list = null;
list = this.db.Database.SqlQuery <TObject>(parameter.GetSearchSQL()).AsQueryable();
if (parameter.Pagination != null)
{
parameter.Pagination.All = Count(parameter);
if (parameter.Pagination.Size != 0)
{
parameter.Pagination.Count = parameter.Pagination.All / parameter.Pagination.Size;
}
}
// return null;
}