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