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>&nbsp;&nbsp;&nbsp;&nbsp;
    <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">&nbsp;<%=rs("jg")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center" bgcolor="#E8F1FF">会员账号</td>
    <td width="393" bgcolor="#E8F1FF">&nbsp;<%=hy("huiyuan")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center" bgcolor="#E8F1FF">真实姓名</td>
    <td bgcolor="#E8F1FF">&nbsp;<%=hy("name")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center" bgcolor="#E8F1FF">联系电话</td>
    <td bgcolor="#E8F1FF">&nbsp;<%=hy("tel")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center" bgcolor="#E8F1FF">联系信箱</td>
    <td bgcolor="#E8F1FF">&nbsp;<%=hy("mail")%></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="120" align="center" bgcolor="#E8F1FF">联系地址</td>
    <td bgcolor="#E8F1FF">&nbsp;<%=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 + -
显示快捷键?