1
<
%@Language
=
"
VBScript
"
Codepage
=
"
936
"
%
>
2
<
%
3
'
分页sql语句生成代码
4
Function
GetPageSql(TblName,FldName,PageSize,PageIndex,OrderType,StrWhere)
5
Dim
StrTemp,StrSql,StrOrder
6
'
根据排序方式生成相关代码
7
If
OrderType
=
0
Then
8
StrTemp
=
"
> (Select Max([
"
&
FldName
&
"
])"
9
StrOrder
=
"
Order By [
"
&
FldName
&
"
] Asc"
10
Else
11
StrTemp
=
"
< (Select Min([
"
&
FldName
&
"
])"
12
StrOrder
=
"
Order By [
"
&
FldName
&
"
] Desc"
13
End
If
14
15
'
若是第1页则无须复杂的语句
16
If
PageIndex
=
1
Then
17
StrTemp
=
"
"
18
If
StrWhere
<>
""
Then
19
Strtmp
=
"
Where
"
&
StrWhere
20
End
If
21
StrSql
=
"
Select Top
"
&
PageSize
&
"
* From [
"
&
TblName
&
"
]
"
&
Strtmp
&
StrOrder
22
Else
'
若不是第1页,构造sql语句
23
StrSql
=
"
Select Top
"
&
PageSize
&
"
* From [
"
&
TblName
&
"
] Where [
"
&
FldName
&
"
]
"
&
StrTemp
&
_
24
"
From (Select Top
"
&
(PageIndex
-
1
)
*
PageSize
&
"
[
"
&
FldName
&
"
] From [
"
&
TblName
&
"
]
"
25
If
StrWhere
<>
""
Then
26
StrSql
=
StrSql
&
"
Where
"
&
StrWhere
27
End
If
28
StrSql
=
StrSql
&
StrOrder
&
"
) As Tbltemp)"
29
If
StrWhere
<>
""
Then
30
StrSql
=
StrSql
&
"
And
"
&
StrWhere
31
End
If
32
StrSql
=
StrSql
&
StrOrder
33
End
If
34
GetPageSql
=
StrSql
'
返回sql语句
35
End Function
36
Response.Write(GetPageSql(
"
Message
"
,
"
MessageID
"
,
10
,
1
,
0
,
""
))
37
%
>
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
2
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
3
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
4
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
5
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
6
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
7
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
8
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
9
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
10
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
11
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
12
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
13
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
14
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
15
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
16
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
17
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
18
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
19
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
20
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
21
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
22
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
23
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
24
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
25
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
26
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
27
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
28
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
29
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
30
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
31
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
32
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
33
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
34
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
35
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
36
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)
37
![](https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif)