?? 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 + -