📄 guanli.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!-- #include file=check.asp -->
<%
dim feilei
fenlei=request("fenlei")
%>
<html>
<head>
<meta HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<title>报名名单查看</title>
</head>
<body text=000000 bgcolor=000000 leftmargin="20" style="background-color: #FFFFFF">
<%
Maxlist=55
tablebackcolor="#f0f0f0"
function showRecord
tempRecord="<tr width=""100%""><td>"&server.htmlencode(mingzi)&"</td><td>"&server.htmlencode(youjian)&"</td><td>"&server.htmlencode(dianhua)&"</td><td>"&server.htmlencode(danwei)&"</td><td>"&server.htmlencode(zhuzhi)&"</td><td>"&server.htmlencode(xiangmu)&"</td><td> <a href=read.asp?id="&id&"&page="¤tpage&" title="&server.htmlencode(shuomin)&">查看</a></td><td>"&server.htmlencode(jiaofei)&"</td><td>"&ndatetime&"</td><td><a href=shanchu.asp?id="&id&"&page="¤tpage&">删除记录</a></td>"
response.write tempRecord
end function
%>
<%
if fenlei="" then
Rs.open "select * from baoming order by shijian DESC",con,1,1
else
Rs.open "select * from baoming where xiangmu="&fenlei&" order by shijian DESC",con,1,1
end if
if Rs.eof or Rs.bof then
response.write "<span class=p9>还没有任何报名!</span>"
%>
【<a href="jiaofei.asp">返回</a>】
【<a href="http://www.yuxisan.com">返回主页</a>】
<%
Rs.close
set Rs=nothing
con.close
set con=nothing
response.end
end if
currentpage=request("page")
if isNumeric(currentpage)=0 then currentpage=1
currentpage=Cint(currentpage)
if currentpage<1 or currentpage>9999999 then currentpage=1
CountRecord=rs.recordcount
rs.pagesize=Maxlist
searchpageCount=rs.pagecount
if currentpage>searchpageCount then currentpage=searchpageCount
rs.absolutepage=currentpage
getdata=rs.getrows(Maxlist)
tempString="<TABLE align=center border=0 cellPadding=0 cellSpacing=3 width=""100%"">"
tempString=tempString&"<form method=POST action=guanli.asp name=selPagesList>"
tempString=tempString&"<TBODY><TR bgColor="&tablebackcolor&"><TD noWrap vAlign=center><p>"
tempString=tempString&"分页"
if currentpage=1 then
tempString=tempString&"<font color=darkgray><<首页 前页</font>"
else
tempString=tempString&"<a href=guanli.asp?page=1><<首页</a> <a href=guanli.asp?page="¤tpage-1&">前页</a>"
end if
tempString=tempString&" "
if currentpage=searchpageCount then
tempString=tempString&"<font color=darkgray>后页 尾页>></font>"
else
tempString=tempString&"<a href=guanli.asp?page="¤tpage+1&">后页</a> <a href=guanli.asp?page="&searchpageCount&">尾页>></a>"
end if
tempString=tempString&" 页次:<strong>"¤tPage&"</strong>/<strong>"&searchpageCount&"</strong>页 共"&CountRecord&"条记录"
tempString=tempString&"</P></TD><TD noWrap vAlign=center>"
tempString=tempString&"<div align=right><p>转到:<input type=text mingzi=page size=5 maxlength=10 class=smallInput value="¤tpage&"><input class=buttonface type=submit value=Go mingzi=B1></span></p>"
tempString=tempString&"</TD></TR></FORM></TBODY></TABLE>"
response.write "<table width=""100%""><tr bgcolor=#f0f0f0><td>名字</td><td>邮件</td><td>电话</td><td>工作单位</td><td>住址</td><td>项目</td><td>意见建议</td><td>交款方式</td><td>报名时间</td><td>管理</td></tr>"
for nn=0 to Ubound(getdata,2)
mingzi=getdata(1,nn)
youjian=getdata(2,nn)
dianhua=getdata(3,nn)
danwei=getdata(4,nn)
zhuzhi=getdata(5,nn)
xiangmu=getdata(6,nn)
ndatetime=getdata(7,nn)
shuomin=getdata(8,nn)
jiaofei=getdata(9,nn)
id=getdata(0,nn)
showRecord()
next
response.write "</table>"
response.write tempString
Rs.close
set Rs=nothing
con.close
set con=nothing
%>
<center>
<span class=p9>
【<a href="jiaofei.asp">返回</a>】
【<a href=http://www.yuxisan.com>返回主页</a>】
</span>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -