/// <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))); }