?? viewaucid.asp
字號(hào):
<TR>
<TD><SPAN id=B1><BR>
<%sqlfind="select * from Bids where bidItemID="&id
set rsfd=conn.execute(sqlfind)
if not rsfd.eof then
sql = "select count(*) as bnum1 from Bids where bidItemID="&id
set rs2=conn.execute(sql)
response.write "共有"&rs2("bnum1")&"人競標(biāo)"
%>
</SPAN></TD>
</TR><%
sqlbider="select bids.biddate,bids.bidAmount,bids.bidBidderID,users.regusername from bids,users where bids.bidBidderID=users.regid and bids.biditemid="&id&" order by bids.biddate desc"
set rsbider=server.createobject("adodb.recordset")
rsbider.open(sqlbider),conn,1,1
'sqlnum = "select count(*) as bnum from Bids where bidItemID="&id&" and bidAmount>"&cdbl(rs("aucReservePrice"))
' set rsnum=conn.execute(sqlnum)
%>
<TR>
<TD>出價(jià)者</TD><TD>出價(jià)時(shí)間</TD><TD>獲得數(shù)量</TD><TD>狀態(tài)</TD>
</TR>
<%i=0
while not rsbider.eof%>
<TR>
<TD><SPAN id=B1>
<%
response.write rsbider("regusername")
%>
</SPAN></TD>
<TD><SPAN id=B1>
<%
response.write rsbider("biddate")
%>
</SPAN></TD>
<TD><SPAN id=B1>
<%
sqlnum = "select count("&cint(rs("aucnum"))&") as n from Bids where bidItemID="&id&" and bidAmount>"&cdbl(rs("aucReservePrice")) '&" order by bidDate desc"
set rsnum=conn.execute(sqlnum)
if i<cdbl(rs("aucnum")) and cdbl(rsbider("bidAmount"))>cdbl(rs("aucReservePrice")) then
response.write "1"
else
response.write "0"
end if
%>
</SPAN></TD>
<TD><SPAN id=B1>
<% if i<cdbl(rs("aucnum")) and cdbl(rsbider("bidAmount"))>cdbl(rs("aucReservePrice")) then
response.write "領(lǐng)先"
else
response.write "出局"
end if
%>
</SPAN></TD>
</TR>
<%
rsbider.movenext
i=i+1
wend
else%>目前尚無買家出價(jià)!<br>
<%
end if
end if%></TBODY></TABLE>
<TABLE align=center bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0
width="760">
<TBODY>
<TR>
<TD align=right height=25 id=B1><NOBR></NOBR></TD>
</TR></TBODY></TABLE><!-- ------------------------------------cci信息-------------------------------------------------------------------------------- --><!-- --------------------------------------------------留言列表------------------------------------------------------------------- -->
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 height=20
width="760"><TBODY>
<TR id=B1>
<TD align=middle id=bg07 width=88><NOBR>賣家留言列表</NOBR></TD>
<TD width=6> </TD>
<TD> </TD></TR></TBODY></TABLE>
<TABLE align=center border=0 cellPadding=4 cellSpacing=1 id=bg01 width="760">
<TBODY> <%sqlmsg="select content,reply from msg where aucid="&id
set rsmsg=conn.execute(sqlmsg)
if rsmsg.eof then
response.write " <TR> " & _
"<TD id=bg12>目前尚無買家留言！</TD>" & _
" </TR>"
else
while not rsmsg.eof
%>
<TR>
<TD id=bg12>問：<%=rsmsg("content")%></TD>
</TR>
<TR>
<TD id=bg02>答：<%=rsmsg("reply")%></TD>
</TR>
<%
rsmsg.movenext
wend
end if
%>
</TBODY>
</TABLE>
<TABLE align=center border=0 cellPadding=5 cellSpacing=0 width="760">
<TBODY>
<TR>
<TD align=right id=b2>
<TABLE border=0 cellPadding=3 cellSpacing=0 id=b1>
<TBODY>
<TR align=middle>
<TD width=120><A
href="<%=weburl%>ask.asp?auc_id=<%=rs("aucid")%>&ownerid=<%=rs("aucItemOwner")%>"
target=_blank><IMG alt=買家提問 border=0 height=19
src="img/buyerword_2.gif"
width=85></A></TD>
<TD width=100><A
href="auction_msg.asp"
t1arget="_blank"><IMG alt=賣家留言 border=0 height=19
src="img/sellerword_2.gif"
width=85></A></TD></TR>
</TBODY></TABLE></TD></TR></TBODY></TABLE><BR><!-- ---------------------------------------------------顯示出價(jià)---------------------------------------------------------------- -->
<div align="center">
<center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="760" style="border-collapse: collapse" bordercolor="#111111">
<TBODY>
<TR id=bg01 ?>
<TD colSpan=2 height=20 id=B2><NOBR><B><FONT id=f4>出價(jià)<A
name=chujia></A></FONT></B></NOBR></TD></TR>
<TR>
<TD colSpan=2 height=5></TD></TR>
<TR>
<TD id=b1 vAlign=top>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4" height="3" id="bg01""><img src="img/trans1p.gif" width="1" height="1"></td>
</tr>
<form action=pre_bid.asp method=post name=bidf1 onsubmit="return ckck1()">
<input type=hidden name=auc_id value="<%=rs("aucid")%>">
<input type=hidden name=aucItemOwner value="<%=rs("aucItemOwner")%>">
<input type=hidden name=auc_title value='<%=rs("aucItemTitle")%>'>
<input type="hidden" name="auc_place" value='<%=rs("regState")%>,<%=rs("regCity")%>'>
<input type=hidden name=zhifu value='<%=rs("zhifu")%>'>
<input type=hidden name=yunfei value='<%=rs("yunfei")%>'>
<tr>
<td id="bg01"" rowspan="5" width="3"></td>
<td colspan="2" id="B1" height="20"><nobr> <b id="B2">填入您愿意接受的最高價(jià)格</b>
<span id="O2">(現(xiàn)價(jià)：<%=rs("aucCurrentBid")%>元/件)</span></td>
<td id="bg01"" rowspan="5" width="4"></td>
</tr>
<tr>
<td colspan="2" height="1" id="bg01""><img src="img/trans1p.gif" width="1" height="1"></td>
</tr>
<tr id="B2">
<td height="20" width="50%"><nobr> 需要數(shù)量：<br> <input type="text" name="getnum" id="B2" value="1" size="20">
</td>
<td><nobr> 每件出價(jià)(元)：<br> <input type="text" name="bid_price" id="B2" value="<%a=cdbl(rs("aucCurrentBid"))
b=cdbl(rs("aucMinimumIncrement"))
c=a+b
response.write c
%>" size="20">
</td>
</tr>
<tr id="B1">
<td width="50%">
</td>
<td height="20"> (不得低于<%=c%>元)</td>
</tr>
<tr>
<td width="50%" id="B1"> <strong>為什么要填能接受的最高價(jià)格？</strong></td>
<td height="25"align="center">
<input name="bid_x" type=submit id="b1" STYLE="color: white;border-color: #CECBCE; background-color: #EF7508;" value=" 出價(jià) ">
</td>
</tr>
<tr>
<td colspan="4" height="3" id="bg01""><img src="img/trans1p.gif" width="1" height="1"></td>
</tr>
</form>
</table>
<DIV align=center><BR>請(qǐng)您遵守<A
href="http://www.vqqq.com/"
target=_blank>vqqq網(wǎng)服務(wù)協(xié)議</A>，誠信出價(jià)購買。一經(jīng)成交您將依法承擔(dān)應(yīng)履行的交易義務(wù)。<BR><BR>請(qǐng)點(diǎn)擊<A
href="http://www.vqqq.com/"
target=_blank>誠信與安全</A>了解更多安全交易的信息<BR></DIV></TD>
<TD vAlign=top width=260>
<TABLE bgColor=#cecfce border=0 cellPadding=0 cellSpacing=1 width="300"><TBODY>
<TR>
<TD>
<div align="center">
<center>
<TABLE bgColor=#ffffff border=0 cellPadding=2 cellSpacing=0 width="300" style="border-collapse: collapse" bordercolor="#111111">
<TBODY>
<TR bgColor=#f7f3f7>
<TD align=middle colSpan=2 height=22 id=B1"><B><FONT
id=f4>對(duì)賣家不放心？</FONT></B></TD></TR>
<TR>
<TD bgColor=#ffffff id=B1 vAlign=top width=12>·</TD>
<TD bgColor=#ffffff
id=B1><STRONG>對(duì)賣家不放心？</STRONG>--參考賣家信用記錄能幫助你作出正確的決定，來看看別的買家對(duì)賣家
</TD>
</TR>
<TR>
<TD bgColor=#ffffff id=B1 vAlign=top width=12>·</TD>
<TD bgColor=#ffffff
id=B1><STRONG>怎樣才算競價(jià)成功？</STRONG>--到商品截標(biāo)時(shí)，您的出價(jià)狀態(tài)是領(lǐng)先的話，您競價(jià)就成功了。</TD></TR>
<TR>
<TD bgColor=#ffffff id=B1 vAlign=top width=12>·</TD>
<TD bgColor=#ffffff
id=B1><STRONG>出價(jià)成功了，然后呢？</STRONG>--請(qǐng)主動(dòng)與賣家聯(lián)系，進(jìn)行線下交易。聯(lián)系方式會(huì)被發(fā)送到您的注冊(cè)郵箱，您也可到<A
href=bought.asp
target=_blank>我的vqqq--已買入的商品</A>中查詢。</TD>
</TR>
<TR>
<TD bgColor=#ffffff id=B1 vAlign=top width=12>·</TD>
<TD bgColor=#ffffff id=B1STRONG>如何付款拿貨？</STRONG>--
一般有三類方式：a.款到發(fā)貨 b.貨到付款 c.見面交易。具體請(qǐng)與賣家協(xié)商。
<TABLE align=center border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD align=right height=15 id=b1 vAlign=top">
更多幫助 </TD>
</TR></TBODY></TABLE></TD></TR>
<TR bgColor=#f7f3f7>
<TD colSpan=2 height=52 id=b1>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0
width="88%">
<TBODY>
<TR>
<TD height=15 id=b1 vAlign=top>
萬一在交易中受到損失，您還可申請(qǐng)交易安全基金。（只有網(wǎng)上成交才可申請(qǐng)）</TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE></center>
</div>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></center>
</div>
<!-- ---------------------------------------------顯示大圖片---------------------------------------------------------------------- --><A
name=pic></A>
<div align="center">
<center>
<TABLE border=0 cellPadding=0 cellSpacing=0 height=20
width="760" style="border-collapse: collapse" bordercolor="#111111"><TBODY>
<TR>
<TD align=middle id=bg01><B><A name=pic></A>商品圖片</B></TD></TR></TBODY></TABLE>
</center>
</div>
<div align="center">
<center>
<TABLE bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0
width="760" style="border-collapse: collapse" bordercolor="#111111">
<TBODY>
<TR>
<TD align=middle><BR>
<%
if rs("aucImageURL")="" then
response.write "沒有圖片"
else%>
<img src="<%=rs("aucImageURL")%>">
<%end if%>
<BR>
</TD></TR></TBODY></TABLE>
</center>
</div>
<DIV align=right id=g4 style="width: 684; height: 16"><A
href="http://www.vqqq.com/">返回頁首</A></DIV>
<!-- ------------------------------------------其他商品列表------------------------------------------------------------------------- --><A
name=other></A>
<P align=center><FONT id=b2>賣家正在出售的商品情況(共<%=rsselling("sellnum")%>件) </FONT></P>
<TABLE border=0 id=B1 width="760" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<TBODY><%
sql="select * from Auctions where aucItemOwner="&rs("aucItemOwner")&" and aucended='N'"
set rs2=conn.execute(sql)
if rs.eof then
response.write "該用戶沒有再賣的商品"
else
while not rs2.eof
%>
<TR id=bg02>
<TD height=20><NOBR><A
href="viewaucid.asp?aucid=<%=rs2("aucId")%>"
target=_blank>███<%=rs2("aucItemTitle")%>███</A></NOBR></TD>
<TD align=middle height=20 width=69><B><%=rs2("aucCurrentBid")%></B></TD>
<TD align=middle height=20 width=69><NOBR><%
date2 = rs2("aucCloseDate")
date1 = now()
sDate = DateDiff("s", date1, date2) '總秒數(shù)
sDay = fix(sDate/60/60/24) '天數(shù)
sDate1 = sDate mod 60*60*24 '余數(shù)
sHour = fix(sDate1/60/60) '小時(shí)
sDate2 = sDate1 mod 60*60 '余數(shù)
sMinute = fix(sDate2/60) '分鐘
sDate3 = sDate2 mod 60 '余數(shù)
response.write sDay & "天" & sHour & "小時(shí)" & sMinute & "分鐘" & sDate3 & "秒"
%></NOBR></TD></TR>
<%rs2.movenext
wend%>
</TBODY></TABLE><BR>
<%end if
%>
<div align="center">
<center>
<TABLE border=0 cellPadding=5 cellSpacing=0 id=bg01 width="760" style="border-collapse: collapse" bordercolor="#111111">
<TBODY>
<TR>
<TD align=middle id=bg02><IMG height=43
src="img/chen.gif"
width=20></TD>
<TD bgColor=#ffffff><SPAN
id=b1>vqqq是一個(gè)誠信、公平、公開、公正的交易社區(qū)。在這里，相信每個(gè)賣家、買家都是誠實(shí)可信的。<BR>目前，我們正與國家有關(guān)部門攜手，堅(jiān)決抵制任何違法、違規(guī)的交易行為，并加強(qiáng)打擊力度。<BR>如果您發(fā)現(xiàn)有任何違反誠信交易原則的行為，請(qǐng)<A
href="<%=weburl%>">聯(lián)系</A>vqqq誠信部門。</SPAN></TD></TR></TBODY></TABLE>
</center>
</div>
<!-- ----------------------------------------------統(tǒng)計(jì)---------------------------------------------------------------------- -->
</CENTER>
<!-- #include file="copyright.asp" -->
</BODY></HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
減小字號(hào)
Ctrl + -