mysql 分页存储过程 一次返回两个记录集（行的条数，以及行记录）,DataReader的Read方法和NextResult方法

DELIMITER $$

USE `netschool`$$

DROP PROCEDURE IF EXISTS `fn_jk_GetCourses`$$

CREATE DEFINER=`root`@`%` PROCEDURE `fn_jk_GetCourses`(IN p_pageIndex INT, IN p_pageSize INT )
BEGIN
-- select p_Tid,p_Functionid,p_BeginTime,p_EndTime,p_pageIndex,p_pageSize;
	--   定义key字段临时表 
	DROP   TABLE   IF   EXISTS   _temptable_keyid;     --   删除临时表,如果存在 
	CREATE   TEMPORARY     TABLE     _temptable_keyid 
	( 
		`CourseId` INT
		
	);
	--   构建动态的sql，输出关键字key的id集合 
	--   查找条件 
	SET   @SQL   =' SELECT `CourseId` from `tb_cs_course`  '; 
	

	
	-- SET 	@SQL=CONCAT(@SQL, '  ORDER BY `ExName` DESC '); 
	
	-- select @SQL;
--   准备id记录插入到临时表 
	SET   @SQL=CONCAT('insert   into   _temptable_keyid(`CourseId`) ', @SQL); 
	PREPARE   stmt   FROM   @SQL; 
	EXECUTE   stmt   ; 
	DEALLOCATE   PREPARE   stmt; 
	--   下面是输出 
	SELECT   COUNT(*) AS  RecordCount FROM _temptable_keyid; 
	
	--   计算记录的起点位置 
	SET   @STARTPOINT   =   IFNULL((p_pageIndex-1)*p_pageSize,0); 
	
	SET   @SQL='select c.`CourseId`,`CourseName` AS `Name`,`GetSubject`(`SubjectId`) AS `Subject`,`GetGradeName`(`GradeId`) AS `Grade`,
`GetTeacherName`(`TeacherId`) AS Teacher,`GetKnowledgeNameByCourseid`(c.`CourseId`) AS Knowledge,`VideoCount`,`ExName` AS Image,`PicUrl` AS Poster 
from `tb_cs_course` c inner join  _temptable_keyid t on c.`CourseId`=t.`CourseId`  ';
	
	SET   @SQL=CONCAT(@SQL, ' limit ',@STARTPOINT,' , ',p_pageSize); 
	PREPARE   stmt   FROM   @SQL; 
	EXECUTE   stmt   ; 
	DEALLOCATE   PREPARE   stmt; 
	DROP   TABLE   _temptable_keyid; 
	-- 给出实际查询的表
	-- 结束
END$$

DELIMITER ;

会返回两个结果，一个是 RecordCount 行数  ，一个是真正的记录

那么怎么去读取这2个值呢？

 

public List<MGetXiaoWuHistory> GetMessageHistoryByPage(int functionId, string tId, string beginTime,string endTime, int pg, int pagesize,string key, ref int recordcount)
        {
            IDataReader rdr = DataProvider.Instance().GetMessageHistoryByPage(functionId, tId, beginTime, endTime, pg, key,pagesize);
            List<MGetXiaoWuHistory> objArray = null;
            if (rdr.Read())
            {
                recordcount = Convert.ToInt32(rdr["RecordCount"]);
            }

            if (rdr.NextResult())
            {
                objArray = CBO.FillCollection<MGetXiaoWuHistory>(rdr);
            }
            return objArray;

        }