public DataTable GetMembers(int pageSize, int pageIndex, string where, out int allCount)
{
allCount = 0;
if (pageSize <= 0 || pageIndex < 1)
{
return(null);
}
DataTable dt = null;
string w = "where (1=1)";
if (!string.IsNullOrEmpty(where))
{
w = where.Trim().ToLower();
if (!w.StartsWith("where "))
{
w = "where " + w;
}
}
object o = sqlHelper.GetSingle("select COUNT(*) from TF_View_Member " + w);
if (o != null && o != DBNull.Value)
{
allCount = Convert.ToInt32(o);
}
string sql = "select top " + pageSize + " * from TF_View_Member " + w + " and ID not in (select top " + (pageSize * (pageIndex - 1)) + " ID from TF_View_Member " + w + " order by ID desc) order by ID desc";
dt = sqlHelper.Query(sql);
return(dt);
}