/// <summary>
/// 分页_获取指定条件的数据集合（开始位置，结束位置）
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageIndex">开始位置（默认从1开始）</param>
/// <param name="pageSize">当前页数</param>
/// <param name="pageCount">总页数</param>
/// <param name="dataCount">总查询数</param>
/// <returns></returns>
public virtual List <T> GetListByByRowNumber(DapperExQuery <T> query, string orderString, int startRowNumber, int endRowNumber, out long dataCount)
{
using (DbBase DbContext = new DbBase(connectionName))
{
//设置Order条件
query.SetOrder(orderString);
return(DbContext.PageDataByRowNumber <T>(startRowNumber, endRowNumber, out dataCount, query.GetSqlQuery(DbContext)));
}
}
/// <summary>
/// 分页_获取指定条件的数据集合（第几页，每页个数）
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageIndex">开始位置（默认从1开始）</param>
/// <param name="pageSize">页面显示数量</param>
/// <param name="pageCount">总页数</param>
/// <param name="dataCount">总查询数</param>
/// <returns></returns>
public virtual List <T> GetListByPage(DapperExQuery <T> query, string orderString, int pageIndex, int pageSize, out long dataCount)
{
using (DbBase DbContext = new DbBase(connectionName))
{
//设置Order条件
query.SetOrder(orderString);
return(DbContext.PageData <T>(pageIndex, pageSize, out dataCount, query.GetSqlQuery(DbContext)));
}
}
/// <summary>
/// 获取指定条件的实体集合
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual List <T> GetList(DapperExQuery <T> query, string orderString = "")
{
if (!string.IsNullOrEmpty(orderString))
{
//设置Order条件
query.SetOrder(orderString);
}
return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext)));
}
/// <summary>
/// 获取指定条件的所有数据集合
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual List <T> GetAllList(DapperExQuery <T> query, string orderString = "")
{
using (DbBase DbContext = new DbBase(connectionName))
{
if (!string.IsNullOrEmpty(orderString))
{
//设置Order条件
query.SetOrder(orderString);
}
return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext)));
}
}
/// <summary>
/// 获取指定条件的实体集合
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual List <T> GetAllList(string orderString = "")
{
if (!string.IsNullOrEmpty(orderString))
{
DapperExQuery <T> query = new DapperExQuery <T>();
query.SetOrder(orderString);
return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext)));
}
else
{
return(DbContext.QueryData <T>());
}
}
/// <summary>
/// 分页_获取指定条件的数据集合
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageIndex">开始位置（默认从1开始）</param>
/// <param name="pageSize">当前页数</param>
/// <param name="pageCount">总页数</param>
/// <param name="dataCount">总查询数</param>
/// <returns></returns>
public virtual List <T> GetList(DapperExQuery <T> query, string orderString, int pageIndex, int pageSize, out long dataCount)
{
//设置Order条件
query.SetOrder(orderString);
return(DbContext.PageData <T>(pageIndex, pageSize, out dataCount, query.GetSqlQuery(DbContext)));
}
