SQL2005分页

     //sql2005分页
   public DataSet GetOrderPageList(string strWhere, int pageIndex)
        {
            const int pageSize = 500;
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select jCode,jName,jUnit,jSupplier,jType,jTech,jStyle,jImg=null,jCost=0,jCMin=null,jCMax=null,jPrice,jMin,jMax,jTmp,JCreate,jDate,jModify,jMDate,jRemark,jStatus,jPromotion,jSerial,jDepot,jAddWeight,jAddCost,jStandard,jCustomer1,jCustomer2,jCustomer3,jCustomer4,jCustomer5,jDelete,jDDate,jSynchron ");
            strSql.Append(" FROM ( select *, row_number() over (order by jstatus desc,jdate,jCode) as rownum from jProduct ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append( " ) as mytab " );
            strSql.Append(string.Format(" where rownum between {0} and {1}  order by rownum", 
                                        pageIndex * pageSize + 1, 
                                        (pageIndex + 1) * pageSize));
            return DbHelperSQL.Query(strSql.ToString());
        }