oracle分页查询问题

            //OracleParameter[] parameters = {
            //        new OracleParameter("tblName", OracleType.VarChar, 255),
            //        new OracleParameter("PageSize", OracleType.Number),
            //        new OracleParameter("PageIndex", OracleType.Number),
            //        new OracleParameter("IsReCount", OracleType.Number),
            //        new OracleParameter("strWhere", OracleType.VarChar,1000),
            //        new OracleParameter("strColums", OracleType.VarChar,1000),
            //        new OracleParameter("v_cur", OracleType.Cursor),
            //        };
            //parameters[0].Value = "BS_ROLE_VIEW";
            //parameters[1].Value = PageSize;
            //parameters[2].Value = PageIndex;
            //parameters[3].Direction = ParameterDirection.Output;
            //parameters[4].Value = strWhere;
            //parameters[5].Value = " ID,NAME,ROLE_DESC,SYSTEMID,DEPTID,SYSIDS,ISOPENREG,ISSYSROLE,SORTID,SYSTEMNAME";
            //parameters[6].Direction = ParameterDirection.Output;
            //DataSet ds = DbHelperOra.RunProcedure("P_PAGE2.UP_GetRecordByPage", parameters, "ds");
            //pageCount = parameters[3].Value.ToString();
            //return ds;
//注释部分带条件查询有问题
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" select ROWNUM RN,A.* from ");
            strSql.Append(" (select * from BS_ROLE_VIEW  ");
            StringBuilder StrReturnCount = new StringBuilder();
            StrReturnCount.AppendFormat(" select count(*) from BS_ROLE_VIEW ");
            if (!string.IsNullOrEmpty(strWhere))
            {
                strSql.AppendFormat(" where {0} ", strWhere);
                StrReturnCount.AppendFormat(" where {0} ", strWhere);
            }
            strSql.AppendFormat(" ) A where ROWNUM between {0} and {1} ", startIndex, endIndex);


            DataTable dt = DbHelperOra.Query(StrReturnCount.ToString()).Tables[0];
            pageCount = dt.Rows[0][0].ToString();
            return DbHelperOra.Query(strSql.ToString());