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