📄 dispbyme.asp
字号:
<%
dim page
if Session.Contents("UserName")="" then
response.write("SORRY！您没有<a href=index.htm>登录</a>。")
else
page=request.querystring("page")
DBPath = Server.MapPath("../../../data/horses.asp")
PageSize = 20
set conn=server.createobject("adodb.connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
set buys=server.createobject("adodb.recordset")
buys.open "Select * From horsebuylist Where username='"&Session.Contents("UserName")&"' Order by time DESC",conn,3,3
buys.PageSize = PageSize
pgnum=buys.Pagecount
if page="" or clng(page)<1 then page=1
if clng(page) > pgnum then page=pgnum
if pgnum>0 then buys.AbsolutePage=page
%>
<HTML>
<HEAD>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type=text/css>
<!--
body,table {font-size: 9pt; font-family: 宋体}
input { font-size: 9pt; color: #000000; background-color: #f7f7f7; padding-top: 3px}
.c { font-family: 宋体; font-size: 9pt; font-style: normal; line-height: 12pt; font-weight: normal; font-variant: normal; text-decoration: none}
--></style>
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#0033CC" vlink="#003399">
<div align=center>
<p><font size="3"><b> 跑马场</b></font></p>
<table width=95% border=0 cellspacing=0 cellpadding=0 align="center">
<tr>
<td align=left width=20%>[共<%=buys.pagecount%>页]</td>
<td align=right width=80%>[<a href="dispbyme.asp?page=<%=page-1%>">上一页</a>][第<%=page%>页][<a href="dispbyme.asp?page=<%=page+1%>">下一页</a>]</td>
</tr>
</table>
<table width=95% border=1 cellspacing=0 cellpadding=3 align="center" bordercolordark="#FFFFFF">
<tr bgcolor="#F2D9B3">
<td colspan=6>
<%=Session.Contents("UserName")%>的个人跑马记录
</td>
</tr>
<tr bgcolor="#FAF0E2">
<td>马名</td>
<td>场次</td>
<td>下注金额</td>
<td>赔率</td>
<td>下注时间</td>
<td>中奖金额</td>
</tr>
<%
count=0
do while not buys.eof and count<buys.PageSize
%>
<tr bgcolor="#FEF7ED">
<td><%=buys("horse")%></td>
<td><%=buys("number")%></td>
<td><%=buys("money")%></td>
<td>1：<%=buys("pl")%></td>
<td>20<%=buys("time")%></td>
<td><%if buys("winmoney")>0 then
response.write("<b><font color=cc0000>"&buys("winmoney")&"</font></b>")
else
response.write(" ")
end if
%></td>
</tr>
<%buys.movenext%>
<%count=count+1%>
<%loop%>
<tr bgcolor="#F2D9B3">
<td colspan=6 align=right>
<a href="javascript:history.back()">返回</a>
</td>
</tr>
</table>
<p align="center"><a href="index.asp">返回马场</a></p>
</div>
</body>
</HTML>
<%
buys.close
set buys=nothing
end if
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -