<%
‘’===========================================================
‘’分页类,大体思想由.Net的DataGrid的使用方式而来
‘’功能:自动生成datagrid列表头和内容，以及分页栏
‘’根据网友bubuy (澎湃 NoMoneyToBuy)得分页函数修改成类
‘’使用示例:
‘’dim DG
‘’dim Url
‘’dim Fld(2)
‘’dim FldName(2)
‘’dim FldWidth(2)
‘’Fld(0) = "ID"
‘’Fld(1) = "Title"
‘’Fld(2) = "Input_Date"
‘’FldName(0) = "编号"
‘’FldName(1) = "标题"
‘’FldName(2) = "录入日期"
‘’FldWidth(0) = "10%"
‘’FldWidth(1) = "60%"
‘’FldWidth(2) = "30%"
‘’set DG = new DataGrid
‘’DG.DataSource = rs_Grid
‘’DG.titleColor = "#DCE19D"
‘’DG.PageSize = 1
‘’DG.Fields = Fld
‘’DG.FieldsName = FldName
‘’DG.fieldWidth = FldWidth
‘’Url = request.ServerVariables("URL") & "?Param=testParameter"//存在原有参数的情况
‘’DG.Url = Url
‘’DG.Generate()
‘’=============Designed By windancer 2003.10.17===============
Class DataGrid
Private obj_RecordSet ‘’ recordset
Private int_PageSize ‘’ 每页纪录数
‘’两个数组保存数据库字段名和中文名称
Private Arr_Field ‘’ 数据库字段
Private Arr_FieldName ‘’ 字段显示名称()
Private Arr_FieldWidth ‘’ 字段显示宽度
Private str_TitleColor ‘’ 表头颜色#efffce
Private str_Url ‘’请求的URL
Private str_Error ‘’ 出错信息
Private Sub Class_Initialize()
int_PageSize = 10
str_TitleColor = "#ffffff"
str_Error = ""
End Sub
‘’===============================================================
‘’属性信息
‘’================================================================
‘’-----------------------------------
‘’数据源,暂时只支持RecordSet
‘’-----------------------------------
Public Property Let dataSource(obj)
set obj_RecordSet = obj
End Property
Public Property Let pageSize(intvalue)
int_PageSize = intvalue
End Property
Public Property Get pageSize
PageSize= int_Categoryid
End Property
Public Property Let Fields(Arr)
Arr_Field = Arr
End Property
Public Property Get Fields
Fields= Arr_Field
End Property
Public Property Let fieldsName(Arr)
Arr_FieldName = Arr
End Property
Public Property Get fieldsName
fieldsName= Arr_FieldName
End Property
Public Property Let fieldWidth(Arr)
Arr_FieldWidth = Arr
End Property
Public Property Get fieldWidth
fieldWidth= Arr_FieldWidth
End Property
Public Property Let titleColor(strvalue)
str_TitleColor = strvalue
End Property
Public Property Get titleColor
titleColor= str_TitleColor
End Property
‘’-----------------------------------------------------
‘’这个属性是为了保存Url路径
‘’如果当前路径带有参数,那么就用&Page=x,否则就用?Page=x
‘’------------------------------------------------------
Public Property Let Url(Strvalue)
str_Url = Strvalue
End Property
Public Property Get Url
Url= str_Url
End Property
‘’================================================================
‘’方法
‘’================================================================
‘’----------------------------------------------------------------
‘’显示当前错误
‘’----------------------------------------------------------------
Private Sub ShowLastError()
response.Write(str_Error)
response.End()
End Sub
‘’----------------------------------------------------------------
‘’Generate()
‘’利用ado分页
‘’-----------------------------------------------------------------
Public Sub Generate()
‘’----检查参数--------------------------
Check
‘’---------变量声明-----------------------------------
Dim FieldCount ‘’显示字段
FieldCount = Ubound(Arr_Field) + 1
Dim CurrentPage ‘’当前页
Dim PgCount ‘’总页数
Dim RecCount ‘’记录数，本来用rs.recordCount可以取到，保存下来效率会比较高
Dim HasOtherParam ‘’URL是否包含其他参数
Dim PageParam ‘’当前分页Url参数
Dim PageInfomation ‘’当前分页状态信息
Dim Seperator ‘’设置分隔符
Seperator = " "
‘’-------------处理Url参数---------------------------
if instr(str_Url,"?")>0 then
HasOtherParam = true
PageParam = "&Page="
else
HasOtherParam = false
PageParam = "?Page="
end if
‘’----------获取当前页--------------------------------
CurrentPage = request.QueryString("Page")
if CurrentPage="" then
CurrentPage=1
else
CurrentPage=Cint(CurrentPage)
end if
‘’-----------处理数据源------------------------------
obj_RecordSet.PageSize = int_PageSize
RecCount = obj_RecordSet.RecordCount
PgCount = obj_RecordSet.PageCount
IF obj_RecordSet.Eof Then
Response.Write("<center><font stlye=‘’font-size:14px;‘’ color=‘’#ff0000‘’>对不起，没有记录！</font></center>")
Else
‘’-----------处理ADO分页----------------------------
IF CurrentPage < 1 Then
CurrentPage = 1
Else
If CurrentPage>PgCount Then
CurrentPage = PgCount
End If
End IF
obj_RecordSet.absolutepage = CurrentPage
Response.Write("<table width=100% border=‘’0‘’ cellpadding=‘’0‘’ cellspacing=‘’0‘’ style=‘’font-size:12px;‘’>")
‘’---------------翻页链接-----------------------------
Dim FirstLink,PrevLink,NextLink,LastLink ‘’定义向上和向下翻的变量
‘’-----------------------首页-------------------------
if CurrentPage>1 then
FirstLink = "<a href=‘’" & URL & PageParam & "1‘’>首页</a>"
PrevLink = "<a href=‘’" & URL & PageParam & Cstr(CurrentPage-1) & "‘’>上一页</a>"
else
FirstLink = "首页"
PrevLink = "上一页"
end if
‘’------------下一页----------------
if CurrentPage<PgCount then
NextLink = "<a href=‘’" & URL & PageParam & Cstr(CurrentPage+1) & "‘’>下一页</a>"
LastLink = "<a href=‘’" & URL & PageParam & PgCount & "‘’>尾页</a>"
else
NextLink = "下一页"
LastLink = "尾页"
end if
PageInfomation = FirstLink & Seperator & PrevLink & Seperator & NextLink & Seperator & LastLink & Seperator & "每页" & Cstr(int_PageSize) & "条记录" & Seperator & "共" & PgCount & "页" & Seperator & "目前第" & CurrentPage & "页" & Seperator
Response.Write("<tr><td align=center>")
Response.Write("<table width=‘’100%‘’ border=‘’1‘’ cellpadding=‘’2‘’ cellspacing=‘’2‘’ bordercolor=‘’#999999‘’>")
‘’---------------设置表头-----------------
Response.Write("<tr bgcolor=‘’" & str_TitleColor & "‘’>")
Dim i
For i=0 to FieldCount -1
Response.Write("<td align=‘’center‘’ width=‘’" & Arr_FieldWidth(i) & "‘’><font style=‘’font-size:14px;‘’><b>" & Arr_FieldName(i) & "</b></font></td>")
Next
Response.Write("</tr>")
‘’---------------------输出内容---------------------------------
i=0
While (not obj_RecordSet.EOF) and i<int_PageSize
Dim Cursor
Response.Write("<tr>")
For Cursor = 0 to FieldCount -1
Response.Write("<td align=‘’center‘’>" & obj_RecordSet(Arr_Field(Cursor)) & "</td>")
Next
Response.Write("</tr>")
i=i+1
obj_RecordSet.MoveNext
Wend
‘’------------------------输出分页条------------------------------------
Response.Write("<tr><td align=‘’right‘’ colspan=‘’" & Cstr(FieldCount) & "‘’>" & PageInfomation & "</td></tr>")
response.Write("</table></td></tr></table>")
End IF
End Sub
‘’----------检查参数是否正确---------------
Private Sub Check()
if Ubound(Arr_Field)<>Ubound(Arr_FieldName) then
str_Error="Fields数组和FieldName数组维数必须相同"
end if
if obj_RecordSet=empty then
str_Error="数据源不能为空,请设置dataSource属性"
end if
if int_PageSize="" then
str_Error="数据源不能为空"
end if
ShowLastError
End Sub
End Class
%>
文章来源于领测软件测试网 https://www.ltesting.net/