📄 showmessage.asp
字号:
<!--#include file="my_conn.asp"-->
<!--#include file="my_cookie.asp"-->
<%
dim uclass
uclass=request("uclass")
dim rs
dim sql
msg_per_page = 8 '定义每页显示记录条数
set rs=server.createobject("adodb.recordset")
sql="select * from message where uclass='" & request("uclass") & "' order by AddTime desc"
rs.Open sql,conn,1,3
'rs.cursorlocation = 3 '使用客户端游标，可以使效率提高
rs.pagesize = msg_per_page '定义分页记录集每页显示记录数
if err.number<>0 then '错误处理
response.write "数据库操作失败：" & err.description
err.clear
else
if not (rs.eof and rs.bof) then '检测记录集是否为空
totalrec = RS.RecordCount 'totalrec：总记录条数
if rs.recordcount mod msg_per_page = 0 then '计算总页数,recordcount:数据的总记录数
n = rs.recordcount\msg_per_page 'n:总页数
else
n = rs.recordcount\msg_per_page+1
end if
currentpage = request("page") 'currentpage:当前页
If currentpage <> "" then
currentpage = cint(currentpage)
if currentpage < 1 then
currentpage = 1
end if
if err.number <> 0 then
err.clear
currentpage = 1
end if
else
currentpage = 1
End if
if currentpage*msg_per_page > totalrec and not((currentpage-1)*msg_per_page < totalrec)then
currentPage=1
end if
rs.absolutepage = currentpage 'absolutepage：设置指针指向某页开头
rowcount = rs.pagesize 'pagesize：设置每一页的数据记录数
end if
end if
dim i
dim k
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body{font-size:12px}
td{font-size:12px}
</style>
</head>
<body text="#000000" background="../IMAGES/bg.gif">
<div align="center"><b><font color="#FF0000">会员管理系统V1.0 <br>
</font></b>
<hr size="1">
<table width="450" border="1" cellspacing="5" cellpadding="0" bordercolor="#CFE9F3">
<tr bordercolor="#000000">
<td onMouseOver="this.style.backgroundColor='#ffffff'" onMouseOut="this.style.backgroundColor=''" onclick="javascript:location.href='index.asp'" bgcolor="#993300" height="20">
<div align="center"><font color="#FFCC00">最新会员</font></div>
</td>
<td onMouseOver="this.style.backgroundColor='#ffffff'" onMouseOut="this.style.backgroundColor=''" onclick="javascript:location.href='member.asp'" bgcolor="#993300">
<div align="center" ><font color="#FFCC00">会员管理</font></div>
</td>
<!-- 会员类别变化内容 -->
<%
SQL="select * from baseinfo where locations='会员管理' order by locations"
set rsp=server.createobject("adodb.recordset")
rsp.open sql,conn,1,1
do while not rsp.eof
%>
<%if rsp("detail")=request("uclass") then %>
<td onMouseOver="this.style.backgroundColor='#ffffff'" onMouseOut="this.style.backgroundColor=''" onclick="javascript:location.href='showmessage.asp?uclass=<%=rsp("detail")%>'" bgcolor="#ffffff" >
<%else%>
<td onMouseOver="this.style.backgroundColor='#ffffff'" onMouseOut="this.style.backgroundColor=''" onclick="javascript:location.href='showmessage.asp?uclass=<%=rsp("detail")%>'" bgcolor="#883600" >
<%end if%>
<div align="center"><font color="#FFCC00"><%=rsp("detail")%>贴士</font></div>
</td>
<%
rsp.movenext
loop
%>
<!-- 会员类别变化内容 -->
</tr>
</table>
<hr size="1">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody><form action="insertm.asp?uclass=<%=request("uclass")%>" method=post> <tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0" align="center">
<tr bgcolor="#993300">
<td width="18%" height="22">
<div align="center"><font color="#FFCC00">时间</font></div>
</td>
<td width="17%">
<div align="center"><font color="#FFCC00">上盘</font></div>
</td>
<td width="8%">
<div align="center"><font color="#FFCC00">让球</font></div>
</td>
<td width="17%">
<div align="center"><font color="#FFCC00">下盘</font></div>
</td>
<td width="12%">
<div align="center"><font color="#FFCC00">赛果</font></div>
</td>
<td width="16%">
<div align="center"><font color="#FFCC00">本站推价</font></div>
</td>
<td width="10%">
<div align="center"><font color="#FFCC00">推介指数</font></div>
</td>
</tr>
<tr>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input type="text" name="TheMonth" size="3">月
<input type="text" name="TheDay" size="3">号</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input type="text" name="RUp" size="12">
</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input type="text" name="RLet" size="5">
</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input type="text" name="RDown" size="12">
</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input name="Result" type="text" size="8">
</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input type="text" name="RCommend" size="12">
</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<input type="text" name="RExp" size="5">
</div>
</td>
</tr>
</table>
<div align="center"><br>
<input type="submit" name="Add_Best" value=" 添加 ">
<input type="reset" name="Submit2" value=" 清空 ">
<br>
</div>
</td>
</tr></form></tbody>
</table>
<br>
<%
if rs.RecordCount <=0 then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:#000000 1px double" bgcolor="#F2FEEF">
<tr>
<td background="../IMAGES/tdbg.gif"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><font color=#ff0000>对不起！</font>还没有任何贴士！</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<%else %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="60%">
<div align="center">
</div>
</td>
<td width="40%">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="40" align="right">
<tbody>
<form method=post action=showmessage.asp name=userdata>
<tr>
<td height="13">
<%call listPages()%>
</td>
</tr>
</form>
</tbody>
</table>
</td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="4%" height="22" bgcolor="#993300">
<div align="center"><font color="#FFCC00">序号</font></div>
</td>
<td width="7%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">时间</font></div>
</td>
<td width="14%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">上盘</font></div>
</td>
<td width="7%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">让球</font></div>
</td>
<td width="14%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">下盘</font></div>
</td>
<td width="6%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">赛果</font></div>
</td>
<td width="14%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">本站推介</font></div>
</td>
<td width="7%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">推介指数</font></div>
</td>
<td width="13%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">加入时间</font></div>
</td>
<td width="6%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">显示</font></div>
</td>
<td width="6%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">删除</font></div>
</td>
<td width="6%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">修改</font></div>
</td>
<td width="6%" bgcolor="#993300">
<div align="center"><font color="#FFCC00">转移</font></div>
</td>
</tr>
<%
k=1
do while not rs.eof and rowcount > 0
%>
<tr>
<td height="22" background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RcdId")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RTime")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RUp")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RLet")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RDown")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RResult")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RCommend")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("RExp")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><%=rs("AddTime")%></div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center">
<form>
<input name="b2" type="button" onClick="javascript:window.location='showm.asp?rcdid=<%=cstr(rs("rcdid"))%>&uclass=<%=request("uclass")%>'" value="<%if rs("rshow")=1 then%>已选<%else%>未选<%end if%>">
</form>
</div>
</td>
<td background="../IMAGES/tdbg.gif">
<div align="center"><form>
<input name="b1" type="button" onClick="javascript:window.location='delm.asp?rcdid=<%=cstr(rs("rcdid"))%>&uclass=<%=request("uclass")%>'" value="删除">
</form>
</div>
</td>
<td background="../IMAGES/tdbg.gif"> <div align="center">
<form>
<input name="b3" type="button" onClick="javascript:window.open('editmessage.asp?rcdid=<%=cstr(rs("rcdid"))%>')" value="修改">
</form></div></td>
<td background="../IMAGES/tdbg.gif"> <div align="center">
<form name="f9" method=post action="copymessage.asp?rcdid=<%=cstr(rs("rcdid"))%>">
<select name="sb" id="txt7">
<%
SQL="select * from baseinfo where locations='会员管理' order by locations"
set rsp=server.createobject("adodb.recordset")
rsp.open sql,conn,1,1
do while not rsp.eof
if rsp("detail")<>request("uclass") then
%>
<option value="<%=rsp("detail")%>"><%=rsp("detail")%></option>
<%
end if
rsp.movenext
loop
set rsp=nothing
%>
</select>
<input name="b3" type="submit" value="复制">
</form></div></td>
</tr>
<%
k=k+1
rowcount=rowcount-1
rs.MoveNext
loop
rs.Close
set rs=nothing
%>
</table>
<%end if %>
<br>
</div>
</body>
</html>
<%
sub listPages()
if n <= 1 then exit sub
for i=0 to n\msg_per_page-1
for j=1 to msg_per_page
%>
<a href="<%=request.ServerVariables("script_name")%>?page=<%=i*msg_per_page+j %>&uclass=<%=uclass%>">[<% =i*msg_per_page+j %>]</a>
<%
next
next
EndPage = n mod msg_per_page
for j=1 to EndPage
%>
<a href="<%=request.ServerVariables("script_name")%>?page=<% =i*msg_per_page+j %>&uclass=<%=uclass%>">[<% =i*msg_per_page+j %>]</a>
<%next%>
当前页数:<%=currentpage%>/<%=n%>页 记录总数:<%=totalrec%>条
<%end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -