你的位置:首页 > 软件开发 > 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

JS
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。