public override InviteSerialStatCollection GetStatList(InviteSerialStatus state, int pageSize, int pageNumber, out int rowCount) { UpdateExpiresSerialStatus(); using (SqlQuery query = new SqlQuery()) { string orderField = "[TotalSerial]"; switch (state) { case InviteSerialStatus.Used: orderField = "[Used]"; break; case InviteSerialStatus.Expires: orderField = "Expiress"; break; case InviteSerialStatus.Unused: orderField = "Unused"; break; } query.Pager.TableName = "bx_SerialCounter"; query.Pager.PageNumber = pageNumber > 0 ? pageNumber : 1; query.Pager.PageSize = pageSize > 0 ? pageSize : 20; query.Pager.SelectCount = true; query.Pager.SortField = orderField; query.Pager.PrimaryKey = "[UserID]"; rowCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { InviteSerialStatCollection stats = new InviteSerialStatCollection(reader); if (reader.NextResult()) { if (reader.Read()) { rowCount = reader.GetInt32(0); } } return(stats); } } }
public override InviteSerialStatCollection GetStatList(InviteSerialStatus state, int pageSize, int pageNumber, out int rowCount) { UpdateExpiresSerialStatus(); using (SqlQuery query = new SqlQuery()) { string orderField = "[TotalSerial]"; switch (state) { case InviteSerialStatus.Used: orderField = "[Used]"; break; case InviteSerialStatus.Expires: orderField = "Expiress"; break; case InviteSerialStatus.Unused: orderField = "Unused"; break; } query.Pager.TableName = "bx_SerialCounter"; query.Pager.PageNumber = pageNumber > 0 ? pageNumber : 1; query.Pager.PageSize = pageSize > 0 ? pageSize : 20; query.Pager.SelectCount = true; query.Pager.SortField = orderField; query.Pager.PrimaryKey = "[UserID]"; rowCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { InviteSerialStatCollection stats = new InviteSerialStatCollection(reader); if (reader.NextResult()) { if (reader.Read()) rowCount = reader.GetInt32(0); } return stats; } } }