paimai_ok.asp

电子商务系统Easy_Buy是一个在线销售系统

<%qx="38"%>
<!--#include file="../login/0.asp"-->
<!--#include file="../../conn/conn.asp"-->
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<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="450" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
  <tr> 
    <td colspan="2" bgcolor="#f1f1f1"> <font color="#FF6600">&gt;&gt; 竞标得主会员信息</font>&nbsp;&nbsp;&nbsp;&nbsp;
      <input name="Submit" type="button" class="go-wenbenkuang" value="返回上一页" onclick="javascript:window.history.go(-1)"></td>
  </tr>
  <tr bgcolor="#FFFFFF">
    <td width="120" align="center">竞标金额</td>
    <td>&nbsp;<%=rs("jg")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center">会员账号</td>
    <td width="393">&nbsp;<%=hy("huiyuan")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center">真实姓名</td>
    <td>&nbsp;<%=hy("name")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center">联系电话</td>
    <td>&nbsp;<%=hy("tel")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center">联系信箱</td>
    <td>&nbsp;<%=hy("mail")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center">联系地址</td>
    <td>&nbsp;<%=hy("dz")%></td>
  </tr>
</table>
<%huiyuan.close
End If
rs.close%>
<br>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr align="center" bgcolor="#f7f7f7"> 
    <td width="50" height="22">编号</td>
    <td width="200" height="22">竞标会员</td>
    <td height="22">投标金额</td>
    <td width="150" height="22">投标时间</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"><%=i%></td>
    <td width="200" height="22"><%=paimai("huiyuan")%></td>
    <td height="22"><%=paimai("jg")%>元</td>
    <td width="150" height="22"><%=paimai("sj")%></td>
  </tr>
<%i=i+1
paimai.movenext
loop
paimai.close
rs.close
set s=nothing%>
</table>