public override PointShowCollection GetPointShowList(int pageSize, int pageNumber) { using (SqlQuery query = new SqlQuery()) { query.Pager.SortField = "[Price]"; query.Pager.IsDesc = true; query.Pager.PrimaryKey = "[UserID]"; query.Pager.PageSize = pageSize; query.Pager.PageNumber = pageNumber; query.Pager.SelectCount = true; query.Pager.TableName = "bx_PointShows"; using (XSqlDataReader reader = query.ExecuteReader()) { PointShowCollection result = new PointShowCollection(reader); if (reader.NextResult()) { while (reader.Read()) { result.TotalRecords = reader.Get <int>(0); } } return(result); } } }
public override PointShowCollection GetPointShowList(int pageSize, int pageNumber) { using (SqlQuery query = new SqlQuery()) { query.Pager.SortField = "[Price]"; query.Pager.IsDesc = true; query.Pager.PrimaryKey = "[UserID]"; query.Pager.PageSize = pageSize; query.Pager.PageNumber = pageNumber; query.Pager.SelectCount = true; query.Pager.TableName = "bx_PointShows"; using (XSqlDataReader reader = query.ExecuteReader()) { PointShowCollection result = new PointShowCollection(reader); if (reader.NextResult()) { while (reader.Read()) result.TotalRecords = reader.Get<int>(0); } return result; } } }