sqlServer通用分頁

 1         /// <summary> 2         /// 分頁擷取資料列表 3         /// </summary> 4         public DataSet GetList(int PageSize, int PageIndex, string strWhere) 5         { 6             StringBuilder strSql = new StringBuilder(); 7             strSql.Append("select count(userId) as AllRows from USERS where " + strWhere + " "); 8             strSql.Append("SELECT * FROM ( "); 9             strSql.Append("SELECT ROW_NUMBER() OVER(ORDER BY createTime) as ROWID, userId, userType, personId, account, password, isAdmin, enabled, loginIP, loginTime, loginTimes, lastLoginIP, lastLoginTime, remark, state, createUser, createTime, updateUser, updateTime FROM  USERS ");10             strSql.Append("  WHERE " + strWhere);11             strSql.Append(") AS TMP_GAME ");12             strSql.Append(" WHERE ROWID > " + (PageSize * (PageIndex - 1)));13             strSql.Append(" AND   ROWID <= " + (PageSize * (PageIndex - 1) + PageSize));14             return new DbHelperSQL().ExecuteQuery(strSql.ToString());