简单的分页存储过程
1 CREATE PROC Paged 2 @pageIndex INT, 3 @pageCount INT OUTPUT, 4 @pageSize INT 5 AS 6 DECLARE @count INT 7 SELECT @count= COUNT(*) FROM dbo.Student 8 SET @pageCount=CEILING(@count*1.0/@pageSize) 9 SELECT 10 * 11 FROM 12 (SELECT ROW_NUMBER() OVER(ORDER BY dbo.Student.stuId) AS tempId,* FROM dbo.Student) AS stu13 WHERE tempId >=@pageSize*(@pageIndex-1)+1 AND tempId <=@pageIndex*@pageSize
Json日期转换为一般日期:json日期:/Date(1316756746000)/ 转换为2013-09-01格式的
1 //将json格式的时间转换成一般时间 2 function ChangeDateFormat(jsondate) { 3 jsondate = jsondate.replace("/Date(", "").replace(")/", ""); 4 if (jsondate.indexOf("+") > 0) { 5 jsondate = jsondate.substring(0, jsondate.indexOf("+")); 6 } else if (jsondate.indexOf("-") > 0) { 7 jsondate = jsondate.substring(0, jsondate.indexOf("-")); 8 } 9 var date = new Date(parseInt(jsondate, 10));10 var month = date.getMonth() + 1 < 10 ? "0" + (date.getMonth() + 1) : date.getMonth() + 1;11 var currentDate = date.getDate() < 10 ? "0" + date.getDate() : date.getDate();12 return date.getFullYear() + "-" + month + "-" + currentDate;13 }
今天准备写一个简单的分页,关于数据弄了一上午。把中间用到的两个小知识点记录在此,备忘!