protected void Page_Load(object sender, EventArgs e)
{
int threadID = _Request.Get<int>("threadid", Method.Get, 0);
if (threadID < 0)
{
ShowError(new InvalidParamError("threadid"));
}
int pageNumber = _Request.Get<int>("page",Method.Get,1);
threadRankList = PostBOV5.Instance.GetThreadRanks(threadID, pageNumber, pageSize, out totalCount);
WaitForFillSimpleUsers<ThreadRank>(threadRankList);
//SetPager("list", string.Format("rankusers.aspx?threadid={0}&page={1}&isdialog=1", threadID, "{0}"), pageNumber, pageSize, totalCount);
}
protected void Page_Load(object sender, EventArgs e)
{
int threadID = _Request.Get <int>("threadid", Method.Get, 0);
if (threadID < 0)
{
ShowError(new InvalidParamError("threadid"));
}
int pageNumber = _Request.Get <int>("page", Method.Get, 1);
threadRankList = PostBOV5.Instance.GetThreadRanks(threadID, pageNumber, pageSize, out totalCount);
WaitForFillSimpleUsers <ThreadRank>(threadRankList);
//SetPager("list", string.Format("rankusers.aspx?threadid={0}&page={1}&isdialog=1", threadID, "{0}"), pageNumber, pageSize, totalCount);
}
public override ThreadRankCollection GetThreadRanks(int threadID, int pageNumber, int pageSize, out int totalCount)
{
totalCount = 0;
using (SqlQuery query = new SqlQuery())
{
query.Pager.IsDesc = true;
query.Pager.ResultFields = "*";
query.Pager.SortField = "[CreateDate]";
query.Pager.PrimaryKey = "[UserID]";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
//query.Pager.TotalRecords = totalThreads;
query.Pager.SelectCount = true;
query.Pager.TableName = "[bx_ThreadRanks]";
query.Pager.Condition = " [ThreadID] = @ThreadID ";
query.CreateParameter<int>("@ThreadID", threadID, SqlDbType.Int);
ThreadRankCollection ranks;
using (XSqlDataReader reader = query.ExecuteReader())
{
ranks = new ThreadRankCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
{
totalCount = reader.Get<int>(0);
}
}
}
return ranks;
}
}
