public IList <TDto> View <TDto>(Pager pager, string filter, string sort)
{
Check.Require(pager != null, "pager may not be null!");
if (!string.IsNullOrEmpty(filter))
{
filter = "where " + filter;
}
if (!string.IsNullOrEmpty(sort))
{
sort = " order by " + sort;
}
long c = (long)((SessionImpl)Session).CreateFilter(this, "select count(*) " + filter).UniqueResult();
pager.ItemCount = (int)c;
String selector = "select " + QuerySelectorBuilder.BuildSelector <T, TDto>();
var q = ((SessionImpl)(Session)).CreateFilter(this, selector + " " + filter + sort);
q.SetFirstResult(pager.FromRowIndex);
q.SetMaxResults(pager.PageSize);
var viewlist = q.SetResultTransformer(Transformers.AliasToBean <TDto>()).List <TDto>();
return(viewlist);
}
public IList <TDto> View <TDto>(string filter, string sort)
{
if (!string.IsNullOrEmpty(filter))
{
filter = "where " + filter;
}
if (!string.IsNullOrEmpty(sort))
{
sort = " order by " + sort;
}
String selector = "select " + QuerySelectorBuilder.BuildSelector <T, TDto>();
var q = ((SessionImpl)(Session)).CreateFilter(this, selector + " " + filter + sort);
var viewlist = q.SetResultTransformer(Transformers.AliasToBean <TDto>()).List <TDto>();
return(viewlist);
}
