paimai_ok.asp
来自「电子商务系统Easy_Buy是一个在线销售系统」· ASP 代码 · 共 83 行
ASP
83 行
<!--#include file="0.asp"-->
<!--#include file="../../conn/conn.asp"-->
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<STYLE>
BODY {
SCROLLBAR-FACE-COLOR: #799ae1;
SCROLLBAR-HIGHLIGHT-COLOR: #799ae1;
SCROLLBAR-SHADOW-COLOR: #799ae1;
SCROLLBAR-3DLIGHT-COLOR: #799ae1;
SCROLLBAR-ARROW-COLOR: #fcfcfc;
SCROLLBAR-TRACK-COLOR: #aabfec;
SCROLLBAR-DARKSHADOW-COLOR: #799ae1;
SCROLLBAR-BASE-COLOR: #799ae1;
background-color: #CAD7F7;
}
.STYLE3 {
color: #FFFFFF;
font-weight: bold;
}
</STYLE>
<br>
<%
set rs = conn.execute("select top 1 jg,huiyuan from paimai where pid="&request("id")&" and ok=1 order by id desc")
if not rs.eof then
set hy = conn.execute("select huiyuan,name,tel,mail,dz,yb from huiyuan where huiyuan='"&rs("huiyuan")&"'")%>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="2" background="../../images/admin_bg_11.gif" bgcolor="#f1f1f1"> <span class="STYLE3"> 竞标得主会员信息</span>
<input name="Submit" type="button" value="返回上一页" onclick="javascript:window.history.go(-1)"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="120" align="center" bgcolor="#E8F1FF">竞标金额</td>
<td bgcolor="#E8F1FF"> <%=rs("jg")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="120" align="center" bgcolor="#E8F1FF">会员账号</td>
<td width="393" bgcolor="#E8F1FF"> <%=hy("huiyuan")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="120" align="center" bgcolor="#E8F1FF">真实姓名</td>
<td bgcolor="#E8F1FF"> <%=hy("name")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="120" align="center" bgcolor="#E8F1FF">联系电话</td>
<td bgcolor="#E8F1FF"> <%=hy("tel")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="120" align="center" bgcolor="#E8F1FF">联系信箱</td>
<td bgcolor="#E8F1FF"> <%=hy("mail")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="120" align="center" bgcolor="#E8F1FF">联系地址</td>
<td bgcolor="#E8F1FF"> <%=hy("dz")%></td>
</tr>
</table>
<%huiyuan.close
End If
rs.close%>
<br>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr align="center" bgcolor="#f7f7f7">
<td width="50" height="22" background="../../images/admin_bg_11.gif"><span class="STYLE3">编号</span></td>
<td width="200" height="22" background="../../images/admin_bg_11.gif"><span class="STYLE3">竞标会员</span></td>
<td height="22" background="../../images/admin_bg_11.gif"><span class="STYLE3">投标金额</span></td>
<td width="150" height="22" background="../../images/admin_bg_11.gif"><span class="STYLE3">投标时间</span></td>
</tr>
<%set paimai = conn.execute("select jg,huiyuan,sj from paimai where pid="&request("id")&" and ok=0 order by id desc")
i=1
do while not paimai.eof%>
<tr align="center" bgcolor="#FFFFFF">
<td width="50" height="22" bgcolor="#E8F1FF"><%=i%></td>
<td width="200" height="22" bgcolor="#E8F1FF"><%=paimai("huiyuan")%></td>
<td height="22" bgcolor="#E8F1FF"><%=paimai("jg")%>元</td>
<td width="150" height="22" bgcolor="#E8F1FF"><%=paimai("sj")%></td>
</tr>
<%i=i+1
paimai.movenext
loop
paimai.close
rs.close
set s=nothing%>
</table>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?