showjingjia.asp

闲置物品免费交易的平台

<table width="600" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
  <tr> 
    <td width="100%" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
      <table width=100% align=center class=table-shang border=0 cellpadding=0 cellspacing=0 bgcolor=#f1f1f1>
        <TR> 
          <TD bgColor=#ffffff colSpan=6 height=1></TD>
        <tr> 
          <td align=center width=16% height=30><div align="center"><font color="#0099CC">竞价人</font></div></td>
          <td align=center width=15% height=30><div align="center"><font color="#0099CC">竞价价格</font></div></td>
          <td align=center width=16% height=30><div align="center"><font color="#0099CC">可购数量</font></div></td>
          <td width=15% align=center><div align="center"></div>
            <div align="center"><font color="#0099CC">竞价数量</font></div></td>
          <td align=center width=23%><div align="center"><font color="#0099CC">竞价结果</font></div></td>
          <td align=center width=15%><font color="#0099CC">竞价处理</font></td>
        </tr>
        <TR> 
          <TD bgColor=#cccccc colSpan=6 height=1></TD>
        </TR>
        <TR> 
          <TD bgColor=#f1f1f1 colSpan=6 height=3></TD>
        </TR>
      </table>
        <%set rs_jia=server.createobject("adodb.recordset")
			rs_jia.open "select * from [bookjia] where bookid="&request("id")&" order by jiage desc",conn,1,1
		do while not rs_jia.eof
		%>
     
     
      <table width="100%" height="11" border="0" align="center" cellpadding="2" cellspacing="0" class="table-xia">
        <tr> 
          <td width="16%" height="11" rowspan="3" align="center" class="table-you"> 
            <%set rs_user=server.createobject("adodb.recordset")
			rs_user.open "select userzhenshiname from [user] where userid="&rs_jia("userid"),conn,1,1
		    %>
            <%=rs_user("userzhenshiname")%> </td>
          <td width="15%"> <div align="center">
              <%			
response.write trim(rs_jia("jiage"))
%>
              <font color="#0099CC">元</font> </div></td>
          <%
			  set rs_books=server.createobject("adodb.recordset")
			  rs_books.open "select kucun,bookchuban from [shop_books] where bookid="&request("id"),conn,1,1
			  %>
          <td width="16%" rowspan="3" class="table-zuo"> <div align="center"><%=rs_books("kucun")%><%=rs_books("bookchuban")%></div></td>
          <td width="15%" rowspan="3" class="table-zuo"><div align="center"> </div>
            <div align="center"><%=rs_jia("shuliang")%><%=rs_books("bookchuban")%></div></td>
          <td width="19%" rowspan="3" class="table-zuo"> <div align="center"> 
              <% if rs_jia("deal")<>1 then%>
              请等待卖家处理 
              <%else%>
              <font color="#0033FF">[此价可以交易<%=rs_jia("dealshuliang")%><%=rs_books("bookchuban")%>]</font> 
              <%end if%>
            </div></td>
          <td width="19%" rowspan="3" class="table-zuo"><div align="center"><%if rs_jia("username")=request.cookies("days6")("username") then%><a href="del_jingjia.asp?selectedid=<%=rs_jia("id")%>">删除</a><%else%>竞价中<%end if%></div></td>
        </tr>
      </table>

        
      
      <% x=x+1 
if x>=rs_books("kucun") then exit do 
rs_jia.movenext 
loop 
%>
    </td>
</tr>
</table>
<table width="600" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
  <%if rs_jia.recordcount>=1 then%>
  <tr> 
    <td width="476"><div align="right"><font color="#0099CC">此商品已竞价<%=rs_jia.recordcount%>次</font></div></td>
    <td width="124"><% absd=request.cookies("days6")("userzhenshiname")			
response.write ""&absd&""
%></td>
  </tr><%else%><tr> 
    <td width="476"><div align="left"><font color="#0099CC">&nbsp;&nbsp;暂无竞价记录！</font></div></td>
    <td width="124">&nbsp;</td>
  </tr><%end if%>
</table>


	  <%rs_jia.close 
set rsjia=nothing%>