<%
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' Programming By Smartpig '
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Class TBGrid
public DataSource '数据源
public style '表格总风格
public HeadStyle '表头风格
public HeadItemStyle '表头单独风格
public itemStyle '单元格独立网络
public HeadSort '表头是否显示排序功能
public Columns '需要显示的列元素
public Alternate '是否交替风格
public AlternateStyle '偶数行风格
public NormalStyle '正常风格
public DefaultStyle '默认风格簇
public PageSize '页大小
public AllowPageing '是否分页
public PageingStyle '页数风格
Private Templates '自定义单元项
private CurPage '当前页
private PageStart '页面开始运行时间
'内容之间的关系
'Columns.add "Field","HeadText"
'AddTemplate("HeadText",Template)
'itemStyle.add "Field","style:adsasd"
'HeadSort.add "Field",True
'DataSource(Columns.Keys(i))
Private Sub Class_Initialize ' 设置 Initialize 事件。
Set itemStyle = CreateObject("Scripting.Dictionary")
Set HeadSort = CreateObject("Scripting.Dictionary")
Set HeadItemStyle = CreateObject("Scripting.Dictionary")
Set Columns = CreateObject("Scripting.Dictionary")
Set Templates = CreateObject("Scripting.Dictionary")
Set DataSource = CreateObject("ADODB.Recordset")
Alternate = 0
PageStart = Timer
End Sub
Private Sub Class_Terminate ' 设置 Terminate 事件。
Set itemStyle = Nothing
Set HeadSort = Nothing
Set HeadItemStyle = Nothing
Set Columns = Nothing
Set DataSource = Nothing
End Sub
Private Sub InitTable()
'Set FieldsNum = DataSource.Fields.Count
'Set RowsNum = DataSource.RecordCount
if Columns.Count = 0 then
For i = 0 to DataSource.Fields.Count -1
Columns.add DataSource.Fields(i).Name,DataSource.Fields(i).Name
response.Write(DataSource.Fields(i).Name)
Next
end if
if IsEmpty(Style) and IsEmpty(NormalStyle) then
DefaultStyle = 1
Else
DefaultStyle = Style
end if
CurPage = CInt(Request.QueryString("page"))
if CurPage = "" then
CurPage = 1
End If
if PageSize = Empty then
PageSize = 10
end if
select Case DefaultStyle
Case 1
Style ="align=center border=0 cellpadding=4 cellspacing=1 bgcolor='#cccccc'"
Alternate = 1
HeadStyle = "Height=25 style=""background-color:#006699;color:#ffffff"""
AlternateStyle = "bgColor=#ffffff height=25"
NormalStyle = "height=25 bgcolor=#f5f5f5"
AllowPageing = true
tbGrid1.PageingStyle = "bgcolor='#f5f5f5' align='right'"
Case 2
Style ="align=center border=0 cellpadding=4 cellspacing=1 bgcolor='#cccccc'"
Alternate = 0
HeadStyle = "Height=25 style=""background-color:#ffffff"""
AlternateStyle = "bgColor=#ffffff height=25"
NormalStyle = "height=25 bgcolor=#ffffff"
Case Else
End Select
End sub
public Sub AddTemplate(ByVal ColumnName,ByVal Template)
Columns.add ColumnName,ColumnName
Templates.add ColumnName,Template
End Sub
public Sub Show()
InitTable()
Dim tableStr
Dim tdStart,tdEnd,tbStyle,tbContent
Dim curRow
Dim clm
Dim regEx,Match,Matches
tableStr = "<table "&style&">" & vbCrLF
'Draw Table Head
Response.Write(tableStr)
Response.Write("<tr>")
for Each clm in Columns.Keys()
tbStyle = HeadStyle & " " & HeadItemStyle(clm)
tdStart = "<th "&tbStyle&">"
tdEnd = "</th>" & vbCrLf
Response.Write(tdStart)
'加入表头排序功能
'Code by Redsun
'Date:2005-1-17
If HeadSort(clm) Then
Response.Write Sort(clm,Columns(clm))
Else
Response.Write(Columns(clm))
End If
Response.Write(tdEnd)
Next
Response.Write("</tr>" & vbCrLF)
'Draw Table items
curRow = 1
if AllowPageing <> Empty then
DataSource.PageSize = PageSize
else
DataSource.PageSize = DataSource.RecordCount
end if
if CurPage < 1 then
DataSource.AbsolutePage = 1
end if
if CurPage >= DataSource.PageCount then
DataSource.AbsolutePage = DataSource.PageCount
end if
if CurPage >= 1 and CurPage <= DataSource.PageCount then
DataSource.AbsolutePage = CurPage
end if
for curRow = 1 to DataSource.PageSize
if DataSource.EOF then
Exit For
end if
Response.Write("<tr>")
for Each clm in Columns.Keys()
if Alternate = 0 then
tbStyle = NormalStyle & " " & ItemStyle(clm)
else
if curRow mod 2 = 0 then
tbStyle = AlternateStyle & " " & ItemStyle(clm)
else
tbStyle = NormalStyle & " " & ItemStyle(clm)
end if
end if
tdStart = "<td "&tbStyle&">"
tdEnd = "</td>" & vbCrLf
if Templates(clm) = Empty then
tbContent = DataSource(clm)
else
tbContent = Templates(clm)
Set regEx = New RegExp
regEx.Pattern= "{[A-Za-z0-9_-]+}"
regEx.IgnoreCase = True
regEx.Global = True
Set Matches=regEx.Execute(Templates(clm))
For each match in matches
On Error Resume Next
tbContent = Replace(tbContent,Match.Value,DataSource(Mid(Match.Value,2,Len(Match.Value)-2)),1)
Next
end if
Response.Write(tdStart)
Response.Write(tbContent)
Response.Write(tdEnd)
Next
Response.Write("</tr>" & vbCrLF)
DataSource.MoveNext
Next
'Draw Pageing Row
if DataSource.PageCount > 1 and LCase(pageingStyle) <> "none" then
Dim i,EndPage,StartPage
response.write("<tr>")
response.write("<td colspan=" & Columns.Count & " " & PageingStyle & ">")
'改进分页功能
'Code by Redsun
'Date:2005-1-17
If CurPage>4 Then
If CurPage+2<DataSource.PageCount Then
StartPage = CurPage-2
EndPage = CurPage+2
Else
StartPage = DataSource.PageCount-4
EndPage = DataSource.PageCount
End If
Else
StartPage = 1
If DataSource.PageCount>5 Then
EndPage = 5
Else
EndPage = DataSource.PageCount
End If
End If
If CurPage>1 Then
Response.Write "<a title='首页' href='"&GetUrl("page")&"page=1'><font face=webdings>9</font></a> "
Response.Write "<a title='上页' href='"&GetUrl("page")&"page="&CurPage-1&"'><font face=webdings>3</font></a> "
Else
Response.Write "<font face=webdings>9</font> "
Response.Write "<font face=webdings>3</font> "
End If
For i=StartPage to EndPage
if i <> CurPage then
response.write("<a title='第"&i&"页' href='"&GetUrl("page")&"page="&i&"'>"&i&"</a> ")
Else
response.write("<b>"&i&"</b> ")
End if
next
If CurPage<DataSource.PageCount Then
Response.Write "<a title='下页' href='"&GetUrl("&page&")&"page="&CurPage+1&"'><font face=webdings>4</font></a> "
Response.Write "<a title='尾页' href='"&GetUrl("&page&")&"page="&DataSource.PageCount&"'><font face=webdings>:</font></a> "
Else
Response.Write "<font face=webdings>4</font> "
Response.Write "<font face=webdings>:</font> "
End If
Response.Write " [共"&DataSource.RecordCount&"条] ["&PageSize&"条/页] [共"&DataSource.PageCount&"页]"
Response.Write " PageExecute:"&Round((Timer-PageStart)*1000,2)&" MS"
response.write("</td></tr>" & vbCrLf)
End if
'Draw Table end
Response.Write("</table>")
End sub
'====================================================================
'获取当前Url参数的函数
'Codeing by Redsun
'====================================================================
Private Function GetUrl(RemoveList)
Dim ScriptAddress, M_ItemUrl, M_item
ScriptAddress = CStr(Request.ServerVariables("SCRIPT_NAME"))&"?"'取得当前地址
M_ItemUrl = ""
For Each M_item In Request.QueryString
If InStr(RemoveList,M_Item)=0 Then
M_ItemUrl = M_ItemUrl & M_Item &"="& Server.URLEncode(Request.QueryString(""&M_Item&"")) & "&"
End If
Next
GetUrl = ScriptAddress & M_ItemUrl
End Function
'=============================
'实现列表排序
'返回Url参数并动态改变排序方式
'参数:需要进行排序的字段名,显示的名称
'=============================
Private Function Sort(SortStr,DispName)
If SortStr = "" Or DispName="" Then Exit Function
Sort = GetUrl("SOrder,SSort")
SSort = UCase(Request.QueryString("SSort"))
If SSort = "DESC" Then
SSort = "ASC"
Else
SSort = "DESC"
End If
Sort = "<a class='headhref' href='"&Sort&"SOrder="&SortStr&"&SSort="&SSort&"'>"&DispName&SortType(SortStr)&"</a>"
End Function
'-----------------------------------------------
'标识排序列为升序还是降序方式
'参数:排序列字段名称
'-----------------------------------------------
Private Function SortType(FieldName)
Dim SOrderName
SOrderName = Request.QueryString("SOrder")
If SOrderName<>FieldName Then Exit Function
Dim SSortImg
SSortImg = Request.QueryString("SSort")
SortType = "<img src='/OrderFormSystem/images/"&SSortImg&".gif' border='0'>"
End Function
End Class
'users Like { UserID,LoginName,Password,RealName,Age,Gender,}
'initDB
Rs.Open "Select * from users",Cn
Dim tbGrid1
Set tbGrid1 = New TBGrid
Set tbGrid1.DataSource = Rs
tbGrid1.Columns.add "LoginName","用户名"
tbGrid1.HeadSort.add "LoginName",True
tbGrid1.Columns.add "Password","密码"
tbGrid1.AddTemplate "修改","<a href='aaa.asp?id={UserID}'><font color=red>{RealName}</font></a>"
tbGrid1.ItemStyle.add "Password","align=right"
tbGrid1.ItemStyle.add "修改","width=100"
tbGrid1.PageSize = 5
tbGrid1.AllowPageing = true
tbGrid1.PageingStyle = "align=right"
tbGrid1.Show()
'CloseDB
%>
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' Programming By Smartpig '
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Class TBGrid
public DataSource '数据源
public style '表格总风格
public HeadStyle '表头风格
public HeadItemStyle '表头单独风格
public itemStyle '单元格独立网络
public HeadSort '表头是否显示排序功能
public Columns '需要显示的列元素
public Alternate '是否交替风格
public AlternateStyle '偶数行风格
public NormalStyle '正常风格
public DefaultStyle '默认风格簇
public PageSize '页大小
public AllowPageing '是否分页
public PageingStyle '页数风格
Private Templates '自定义单元项
private CurPage '当前页
private PageStart '页面开始运行时间
'内容之间的关系
'Columns.add "Field","HeadText"
'AddTemplate("HeadText",Template)
'itemStyle.add "Field","style:adsasd"
'HeadSort.add "Field",True
'DataSource(Columns.Keys(i))
Private Sub Class_Initialize ' 设置 Initialize 事件。
Set itemStyle = CreateObject("Scripting.Dictionary")
Set HeadSort = CreateObject("Scripting.Dictionary")
Set HeadItemStyle = CreateObject("Scripting.Dictionary")
Set Columns = CreateObject("Scripting.Dictionary")
Set Templates = CreateObject("Scripting.Dictionary")
Set DataSource = CreateObject("ADODB.Recordset")
Alternate = 0
PageStart = Timer
End Sub
Private Sub Class_Terminate ' 设置 Terminate 事件。
Set itemStyle = Nothing
Set HeadSort = Nothing
Set HeadItemStyle = Nothing
Set Columns = Nothing
Set DataSource = Nothing
End Sub
Private Sub InitTable()
'Set FieldsNum = DataSource.Fields.Count
'Set RowsNum = DataSource.RecordCount
if Columns.Count = 0 then
For i = 0 to DataSource.Fields.Count -1
Columns.add DataSource.Fields(i).Name,DataSource.Fields(i).Name
response.Write(DataSource.Fields(i).Name)
Next
end if
if IsEmpty(Style) and IsEmpty(NormalStyle) then
DefaultStyle = 1
Else
DefaultStyle = Style
end if
CurPage = CInt(Request.QueryString("page"))
if CurPage = "" then
CurPage = 1
End If
if PageSize = Empty then
PageSize = 10
end if
select Case DefaultStyle
Case 1
Style ="align=center border=0 cellpadding=4 cellspacing=1 bgcolor='#cccccc'"
Alternate = 1
HeadStyle = "Height=25 style=""background-color:#006699;color:#ffffff"""
AlternateStyle = "bgColor=#ffffff height=25"
NormalStyle = "height=25 bgcolor=#f5f5f5"
AllowPageing = true
tbGrid1.PageingStyle = "bgcolor='#f5f5f5' align='right'"
Case 2
Style ="align=center border=0 cellpadding=4 cellspacing=1 bgcolor='#cccccc'"
Alternate = 0
HeadStyle = "Height=25 style=""background-color:#ffffff"""
AlternateStyle = "bgColor=#ffffff height=25"
NormalStyle = "height=25 bgcolor=#ffffff"
Case Else
End Select
End sub
public Sub AddTemplate(ByVal ColumnName,ByVal Template)
Columns.add ColumnName,ColumnName
Templates.add ColumnName,Template
End Sub
public Sub Show()
InitTable()
Dim tableStr
Dim tdStart,tdEnd,tbStyle,tbContent
Dim curRow
Dim clm
Dim regEx,Match,Matches
tableStr = "<table "&style&">" & vbCrLF
'Draw Table Head
Response.Write(tableStr)
Response.Write("<tr>")
for Each clm in Columns.Keys()
tbStyle = HeadStyle & " " & HeadItemStyle(clm)
tdStart = "<th "&tbStyle&">"
tdEnd = "</th>" & vbCrLf
Response.Write(tdStart)
'加入表头排序功能
'Code by Redsun
'Date:2005-1-17
If HeadSort(clm) Then
Response.Write Sort(clm,Columns(clm))
Else
Response.Write(Columns(clm))
End If
Response.Write(tdEnd)
Next
Response.Write("</tr>" & vbCrLF)
'Draw Table items
curRow = 1
if AllowPageing <> Empty then
DataSource.PageSize = PageSize
else
DataSource.PageSize = DataSource.RecordCount
end if
if CurPage < 1 then
DataSource.AbsolutePage = 1
end if
if CurPage >= DataSource.PageCount then
DataSource.AbsolutePage = DataSource.PageCount
end if
if CurPage >= 1 and CurPage <= DataSource.PageCount then
DataSource.AbsolutePage = CurPage
end if
for curRow = 1 to DataSource.PageSize
if DataSource.EOF then
Exit For
end if
Response.Write("<tr>")
for Each clm in Columns.Keys()
if Alternate = 0 then
tbStyle = NormalStyle & " " & ItemStyle(clm)
else
if curRow mod 2 = 0 then
tbStyle = AlternateStyle & " " & ItemStyle(clm)
else
tbStyle = NormalStyle & " " & ItemStyle(clm)
end if
end if
tdStart = "<td "&tbStyle&">"
tdEnd = "</td>" & vbCrLf
if Templates(clm) = Empty then
tbContent = DataSource(clm)
else
tbContent = Templates(clm)
Set regEx = New RegExp
regEx.Pattern= "{[A-Za-z0-9_-]+}"
regEx.IgnoreCase = True
regEx.Global = True
Set Matches=regEx.Execute(Templates(clm))
For each match in matches
On Error Resume Next
tbContent = Replace(tbContent,Match.Value,DataSource(Mid(Match.Value,2,Len(Match.Value)-2)),1)
Next
end if
Response.Write(tdStart)
Response.Write(tbContent)
Response.Write(tdEnd)
Next
Response.Write("</tr>" & vbCrLF)
DataSource.MoveNext
Next
'Draw Pageing Row
if DataSource.PageCount > 1 and LCase(pageingStyle) <> "none" then
Dim i,EndPage,StartPage
response.write("<tr>")
response.write("<td colspan=" & Columns.Count & " " & PageingStyle & ">")
'改进分页功能
'Code by Redsun
'Date:2005-1-17
If CurPage>4 Then
If CurPage+2<DataSource.PageCount Then
StartPage = CurPage-2
EndPage = CurPage+2
Else
StartPage = DataSource.PageCount-4
EndPage = DataSource.PageCount
End If
Else
StartPage = 1
If DataSource.PageCount>5 Then
EndPage = 5
Else
EndPage = DataSource.PageCount
End If
End If
If CurPage>1 Then
Response.Write "<a title='首页' href='"&GetUrl("page")&"page=1'><font face=webdings>9</font></a> "
Response.Write "<a title='上页' href='"&GetUrl("page")&"page="&CurPage-1&"'><font face=webdings>3</font></a> "
Else
Response.Write "<font face=webdings>9</font> "
Response.Write "<font face=webdings>3</font> "
End If
For i=StartPage to EndPage
if i <> CurPage then
response.write("<a title='第"&i&"页' href='"&GetUrl("page")&"page="&i&"'>"&i&"</a> ")
Else
response.write("<b>"&i&"</b> ")
End if
next
If CurPage<DataSource.PageCount Then
Response.Write "<a title='下页' href='"&GetUrl("&page&")&"page="&CurPage+1&"'><font face=webdings>4</font></a> "
Response.Write "<a title='尾页' href='"&GetUrl("&page&")&"page="&DataSource.PageCount&"'><font face=webdings>:</font></a> "
Else
Response.Write "<font face=webdings>4</font> "
Response.Write "<font face=webdings>:</font> "
End If
Response.Write " [共"&DataSource.RecordCount&"条] ["&PageSize&"条/页] [共"&DataSource.PageCount&"页]"
Response.Write " PageExecute:"&Round((Timer-PageStart)*1000,2)&" MS"
response.write("</td></tr>" & vbCrLf)
End if
'Draw Table end
Response.Write("</table>")
End sub
'====================================================================
'获取当前Url参数的函数
'Codeing by Redsun
'====================================================================
Private Function GetUrl(RemoveList)
Dim ScriptAddress, M_ItemUrl, M_item
ScriptAddress = CStr(Request.ServerVariables("SCRIPT_NAME"))&"?"'取得当前地址
M_ItemUrl = ""
For Each M_item In Request.QueryString
If InStr(RemoveList,M_Item)=0 Then
M_ItemUrl = M_ItemUrl & M_Item &"="& Server.URLEncode(Request.QueryString(""&M_Item&"")) & "&"
End If
Next
GetUrl = ScriptAddress & M_ItemUrl
End Function
'=============================
'实现列表排序
'返回Url参数并动态改变排序方式
'参数:需要进行排序的字段名,显示的名称
'=============================
Private Function Sort(SortStr,DispName)
If SortStr = "" Or DispName="" Then Exit Function
Sort = GetUrl("SOrder,SSort")
SSort = UCase(Request.QueryString("SSort"))
If SSort = "DESC" Then
SSort = "ASC"
Else
SSort = "DESC"
End If
Sort = "<a class='headhref' href='"&Sort&"SOrder="&SortStr&"&SSort="&SSort&"'>"&DispName&SortType(SortStr)&"</a>"
End Function
'-----------------------------------------------
'标识排序列为升序还是降序方式
'参数:排序列字段名称
'-----------------------------------------------
Private Function SortType(FieldName)
Dim SOrderName
SOrderName = Request.QueryString("SOrder")
If SOrderName<>FieldName Then Exit Function
Dim SSortImg
SSortImg = Request.QueryString("SSort")
SortType = "<img src='/OrderFormSystem/images/"&SSortImg&".gif' border='0'>"
End Function
End Class
'users Like { UserID,LoginName,Password,RealName,Age,Gender,}
'initDB
Rs.Open "Select * from users",Cn
Dim tbGrid1
Set tbGrid1 = New TBGrid
Set tbGrid1.DataSource = Rs
tbGrid1.Columns.add "LoginName","用户名"
tbGrid1.HeadSort.add "LoginName",True
tbGrid1.Columns.add "Password","密码"
tbGrid1.AddTemplate "修改","<a href='aaa.asp?id={UserID}'><font color=red>{RealName}</font></a>"
tbGrid1.ItemStyle.add "Password","align=right"
tbGrid1.ItemStyle.add "修改","width=100"
tbGrid1.PageSize = 5
tbGrid1.AllowPageing = true
tbGrid1.PageingStyle = "align=right"
tbGrid1.Show()
'CloseDB
%>
标签:
ASP数据岛操作类
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件!
如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
暂无“ASP数据岛操作类”评论...
《魔兽世界》大逃杀!60人新游玩模式《强袭风暴》3月21日上线
暴雪近日发布了《魔兽世界》10.2.6 更新内容,新游玩模式《强袭风暴》即将于3月21 日在亚服上线,届时玩家将前往阿拉希高地展开一场 60 人大逃杀对战。
艾泽拉斯的冒险者已经征服了艾泽拉斯的大地及遥远的彼岸。他们在对抗世界上最致命的敌人时展现出过人的手腕,并且成功阻止终结宇宙等级的威胁。当他们在为即将于《魔兽世界》资料片《地心之战》中来袭的萨拉塔斯势力做战斗准备时,他们还需要在熟悉的阿拉希高地面对一个全新的敌人──那就是彼此。在《巨龙崛起》10.2.6 更新的《强袭风暴》中,玩家将会进入一个全新的海盗主题大逃杀式限时活动,其中包含极高的风险和史诗级的奖励。
《强袭风暴》不是普通的战场,作为一个独立于主游戏之外的活动,玩家可以用大逃杀的风格来体验《魔兽世界》,不分职业、不分装备(除了你在赛局中捡到的),光是技巧和战略的强弱之分就能决定出谁才是能坚持到最后的赢家。本次活动将会开放单人和双人模式,玩家在加入海盗主题的预赛大厅区域前,可以从强袭风暴角色画面新增好友。游玩游戏将可以累计名望轨迹,《巨龙崛起》和《魔兽世界:巫妖王之怒 经典版》的玩家都可以获得奖励。
更新动态
2024年10月06日
2024年10月06日
- 群星《前途海量 电影原声专辑》[FLAC/分轨][227.78MB]
- 张信哲.1992-知道新曲与精丫巨石】【WAV+CUE】
- 王翠玲.1995-ANGEL【新艺宝】【WAV+CUE】
- 景冈山.1996-我的眼里只有你【大地唱片】【WAV+CUE】
- 群星《八戒 电影原声带》[320K/MP3][188.97MB]
- 群星《我的阿勒泰 影视原声带》[320K/MP3][139.47MB]
- 纪钧瀚《胎教古典音乐 钢琴与大提琴的沉浸时光》[320K/MP3][148.91MB]
- 刘雅丽.2001-丽花皇后·EMI精选王【EMI百代】【FLAC分轨】
- 齐秦.1994-黄金十年1981-1990CHINA.TOUR.LIVE精丫上华】【WAV+CUE】
- 群星.2008-本色·百代音乐人创作专辑【EMI百代】【WAV+CUE】
- 群星.2001-同步过冬AVCD【环球】【WAV+CUE】
- 群星.2020-同步过冬2020冀待晴空【环球】【WAV+CUE】
- 沈雁.1986-四季(2012梦田复刻版)【白云唱片】【WAV+CUE】
- 纪钧瀚《胎教古典音乐 钢琴与大提琴的沉浸时光》[FLAC/分轨][257.88MB]
- 《国语老歌 怀旧篇 3CD》[WAV/分轨][1.6GB]