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