CREATE PROC Paged

 @pageIndex INT,

 @pageCount INT OUTPUT,

 @pageSize INT

 AS

 DECLARE @count INT

 SELECT @count= COUNT(*) FROM dbo.Student

 SET @pageCount=CEILING(@count*1.0/@pageSize)

 SELECT

 *

 FROM

 (SELECT ROW_NUMBER() OVER(ORDER BY dbo.Student.stuId) AS tempId,* FROM dbo.Student) AS stu

 WHERE tempId >=@pageSize*(@pageIndex-1)+1 AND tempId <=@pageIndex*@pageSize

  //将json格式的时间转换成一般时间

         function ChangeDateFormat(jsondate) {

             jsondate = jsondate.replace("/Date(", "").replace(")/", "");

             if (jsondate.indexOf("+") > 0) {

                 jsondate = jsondate.substring(0, jsondate.indexOf("+"));

             } else if (jsondate.indexOf("-") > 0) {

                 jsondate = jsondate.substring(0, jsondate.indexOf("-"));

             }

             var date = new Date(parseInt(jsondate, 10));

             var month = date.getMonth() + 1 < 10 ? "0" + (date.getMonth() + 1) : date.getMonth() + 1;

             var currentDate = date.getDate() < 10 ? "0" + date.getDate() : date.getDate();

             return date.getFullYear() + "-" + month + "-" + currentDate;

         }