public async Task <PageList <TReturn> > PageListAsync <TReturn>(int pageIndex, int pageSize, bool where, Expression <Func <T, TReturn> > trueSelect, Expression <Func <T, TReturn> > falseSelect)
{
if (where)
{
SqlProvider.Context.Set.SelectExpression = trueSelect;
}
else
{
SqlProvider.Context.Set.SelectExpression = falseSelect;
}
//查询总行数
SqlProvider.FormatCount();
var pageTotal = await DbCon.QuerySinglesAsync <int>(SqlProvider, DbTransaction);
//查询数据
List <TReturn> itemList;
SqlProvider.Clear();
if (pageTotal != 0)
{
SqlProvider.FormatToPageList <T>(pageIndex, pageSize);
itemList = await DbCon.Query_1Async <TReturn>(SqlProvider, DbTransaction);
}
else
{
itemList = new List <TReturn>();
}
return(new PageList <TReturn>(pageIndex, pageSize, pageTotal, itemList));
}
public PageList <TSource> PageList <TSource>(int pageIndex, int pageSize)
{
//查询总行数
SqlProvider.FormatCount();
var pageTotal = DbCon.QuerySingles <int>(SqlProvider, DbTransaction);
//查询数据
List <TSource> itemList;
SqlProvider.Clear();
if (pageTotal != 0)
{
SqlProvider.FormatToPageList <T>(pageIndex, pageSize);
itemList = DbCon.Query_1 <TSource>(SqlProvider, DbTransaction);
}
else
{
itemList = new List <TSource>();
}
return(new PageList <TSource>(pageIndex, pageSize, pageTotal, itemList));
}
public async Task <PageList <T> > PageListAsync(int pageIndex, int pageSize)
{
//查询总行数
SqlProvider.FormatCount();
var pageTotal = await DbCon.QuerySinglesAsync <int>(SqlProvider, DbTransaction);
//查询数据
List <T> itemList;
SqlProvider.Clear();
if (pageTotal != 0)
{
SqlProvider.FormatToPageList <T>(pageIndex, pageSize);
itemList = await DbCon.Query_1Async <T>(SqlProvider, DbTransaction);
}
else
{
itemList = new List <T>();
}
return(new PageList <T>(pageIndex, pageSize, pageTotal, itemList));
}
public PageList <TReturn> PageList <TReturn>(int pageIndex, int pageSize, Expression <Func <T, TReturn> > select)
{
SqlProvider.Context.Set.SelectExpression = select;
//查询总行数
SqlProvider.FormatCount();
var pageTotal = DbCon.QuerySingles <int>(SqlProvider, DbTransaction);
//查询数据
List <TReturn> itemList;
SqlProvider.Clear();
if (pageTotal != 0)
{
SqlProvider.FormatToPageList <T>(pageIndex, pageSize);
itemList = DbCon.Query_1 <TReturn>(SqlProvider, DbTransaction);
}
else
{
itemList = new List <TReturn>();
}
return(new PageList <TReturn>(pageIndex, pageSize, pageTotal, itemList));
}
