你的位置:
首页
>
软件开发 >
ASP.net > 基于Jquery+Ajax+Json+存储过程 高效分页
基于Jquery+Ajax+Json+存储过程 高效分页
发布时间:2015-08-05 21:00:03
1 CREATE PROCEDURE [dbo].[PAGINATION] 2 @FEILDS VARCHAR(1000),--要显示的字段 3 @PAGE_INDEX INT,--当前页码 4 @PAGE_SIZE INT,--页面大小 5 @ORDERTYPE BIT,-- ...
1 CREATE PROCEDURE [dbo].[PAGINATION] 2 @FEILDS VARCHAR(1000),--要显示的字段 3 @PAGE_INDEX INT,--当前页码 4 @PAGE_SIZE INT,--页面大小 5 @ORDERTYPE BIT,--当为0时 则为 desc 当为1 时 asc 6 @ANDWHERE VARCHAR(1000)='',--where语句 不用加where 7 @ORDERFEILD VARCHAR(100), --排序的字段 8 @TABLENAME VARCHAR(100) --查询的表明 9 10 as11 DECLARE @EXECSQL VARCHAR(2000)12 DECLARE @ORDERSTR VARCHAR(100)13 DECLARE @ORDERBY VARCHAR(100)14 BEGIN15 set NOCOUNT on16 IF @ORDERTYPE = 1 17 BEGIN18 SET @ORDERSTR = ' > ( SELECT MAX(['+@ORDERFEILD+'])'19 SET @ORDERBY = 'ORDER BY '+@ORDERFEILD+' ASC'20 END21 ELSE 22 BEGIN23 SET @ORDERSTR = ' < ( SELECT MIN(['+@ORDERFEILD+'])'24 SET @ORDERBY = 'ORDER BY '+@ORDERFEILD+' DESC'25 END26 IF @PAGE_INDEX = 1 --当页码是第一页时直接运行,提高速度27 BEGIN28 IF @ANDWHERE=''29 SET @EXECSQL = 'SELECT TOP '+STR(@PAGE_SIZE)+' '+@FEILDS+' FROM '+@TABLENAME+' '+@ORDERBY30 ELSE31 SET @EXECSQL = 'SELECT TOP '+STR(@PAGE_SIZE)+' '+@FEILDS+' FROM '+@TABLENAME+' WHERE '+@ANDWHERE+' '+ @ORDERBY32 END33 ELSE34 BEGIN35 IF @ANDWHERE=''36 BEGIN --以子查询结果当做新表时 要给表名别名才能用37 SET @EXECSQL = 'SELECT TOP'+STR(@PAGE_SIZE)+' '+@FEILDS+' FROM '+@TABLENAME+' WHERE '+@ORDERFEILD+38 @ORDERSTR+' FROM (SELECT TOP '+STR(@PAGE_SIZE*(@PAGE_INDEX-1))+' '+@ORDERFEILD+39 ' FROM '+@TABLENAME+' '+@ORDERBY+') AS TEMP) '+ @ORDERBY40 END41 ELSE42 BEGIN43 SET @EXECSQL = 'SELECT TOP'+STR(@PAGE_SIZE)+' '+@FEILDS+' FROM '+@TABLENAME+' WHERE '+@ORDERFEILD+44 @ORDERSTR+' FROM (SELECT TOP '+ STR(@PAGE_SIZE*(@PAGE_INDEX-1))+' '+@ORDERFEILD+45 ' FROM '+@TABLENAME+' WHERE '+@ANDWHERE+' '+@ORDERBY+') AS TEMP) AND '+@ANDWHERE+' '+ @ORDERBY46 END47 END48 EXEC (@EXECSQL)--这里要加括号49 END
原标题:基于Jquery+Ajax+Json+存储过程 高效分页
关键词:JS
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。