?? viewaucid.asp
字號:
<!--#include file="conn.asp" -->
<!-- #include file="inc/adovbs.inc" -->
<!-- #include file="inc/info.asp" -->
<!-- #include file="webtop.asp" -->
<html>
<head>
<TITLE><%=webname%>--首頁</TITLE>
<link href="images/yq_style.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY bgColor=#ffffff leftMargin=0 onmouseover=exitpop=false text=#000000 topMargin=0 marginheight="0" marginwidth="0">
<CENTER>
<%'on error resume next
dim strsql,id
id=rst("aucid")
if id ="" then id =1
strsql = "SELECT aucid,aucEnded,aucbuyprice,aucEmailsSent,aucItemOwner,aucItemTitle,aucImageURL,catid,catsonid," & _
"aucAvailDate,aucCloseDate,aucStartingBid,aucReservePrice,aucMinimumIncrement,aucCurrentBid," & _
"aucCurrentBidder,aucDescription,aucnum,oldnew,yunfei,zhifu,songhuo,fapiao,baoxiu,limit," & _
"regID,regUserName, regEmail, regCity, regState, regCountry,regtime ,haoping,credit " & _
"FROM Auctions LEFT JOIN users on Auctions.aucItemOwner = users.regID " & _
"WHERE aucID = " & id
set rs=conn.execute(strsql)
if not rs.eof then
%>
<table border=0 cellpadding=0 cellspacing=1 id=bg01 width="760">
<tbody>
<tr>
<td bgcolor=#ffffff>
<table border=0 cellpadding=2 cellspacing=0 width="760">
<tbody>
<tr>
<td width=90> </td>
<td colspan=2 id=bg01><strong>
<%
if rs("aucended")="Y" then
response.write " <font color=red>該商品"&rs("aucItemTitle")&"已經結束 </font></strong></td>"
else
response.write " ███"&rs("aucItemTitle")&"███ </strong></td>"
end if
%>
</tr>
<tr>
<td></td>
<td height=1 id=bg03 valign=top></td>
<td id=bg03></td>
</tr>
<tr>
<td align=middle valign=top><br>
<%
if rs("aucImageURL")="" then
response.write "沒有圖片"
else%>
<img src="<%=rs("aucImageURL")%>" width="72" height="72">
<%end if%>
</td>
<td id=bg02 valign=top>
<table border=0 cellpadding=1 cellspacing=0 width="100%">
<tbody>
<tr>
<td id=b2>
<table border=0 cellpadding=1 cellspacing=0>
<tr>
<td id=b2><nobr><font id=f4> 現(xiàn)價：</font> <%=rs("aucCurrentBid")%>
元/件</nobr></td>
</tr>
<tbody>
<tr>
<td id=b2><nobr><font id=f4> 一口價：</font>
<%=rs("aucbuyprice")%>
元/件</nobr></td>
</tr>
<tr>
<td id=b2><nobr><font id=f4> 起始價：</font> <%=rs("aucStartingBid")%>
元/件</nobr></td>
</tr>
<tr>
<td id=b2><nobr><font id=f4> 可購數(shù)量：</font><%=rs("aucnum")%> </nobr></td>
</tr>
<tr>
<td id=b2><nobr><font id=f4> 剩余時間：</font> <%
date2 = rs("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) '小時
sDate2 = sDate1 mod 60*60 '余數(shù)
sMinute = fix(sDate2/60) '分鐘
sDate3 = sDate2 mod 60 '余數(shù)
if sDate3>=0 then
response.write sDay & "天" & sHour & "小時" & sMinute & "分鐘" & sDate3 & "秒"
end if
if sDate3 < 0 then
response.write ""
end if
%></nobr></td>
</tr>
<tr>
<td id=b2><nobr><font id=f4> 所在地：</font> <%=rs("regState")%><%=rs("regCity")%></nobr></td>
</tr>
<tr>
<td id=b2><nobr><font id=f4> 交易情況：</font> 最后出價：
<%
if rs("aucCurrentBidder") <> "" then
sqllast="select regusername from users where regid="&rs("aucCurrentBidder")
set rslast=conn.execute(sqllast)
sqltimes="select count(*) as times from bids where bidItemID="&id
set rstimes=conn.execute(sqltimes)
response.write rslast("regusername")
response.write "出價"&rstimes("times")&"次"
else
'if rs("aucCurrentBidder") = "" then
response.write "無人出價"
response.write "出價0次"
end if%>
</nobr></td>
</tr>
</tbody>
</table>
</td>
<td id=b1 valign=top>
<table border=0 cellpadding=0 cellspacing=0 width=100>
<tbody>
<tr>
<td height=10></td>
</tr>
</tbody>
</table>
<table
background=img/bg_botton_2.gif
border=0 cellpadding=0 cellspacing=0 id=b2 width=90
bgid="f3">
<tbody>
<tr>
<td align=middle height=26><a
href="#chujia"><strong><font
color=#ffffff>出價</font></strong></a> </td>
</tr>
</tbody>
</table>
<br>
</td>
</tr>
</tbody>
</table>
</td>
<td id=bg04 valign=top>
<table border=0 cellpadding=1 cellspacing=0 width="100%">
<tbody>
<tr>
<td id=bg02><span id=b2>賣家信息</span></td>
<td align=right id=bg02></td>
</tr>
<tr>
<td colspan=2 id=b2>賣家： <%=rs("regUsername")%>
<%dim a
a=rs("credit")
select case a
case 0
response.write " 新會員"
case 1
response.write "<a href=usercredit.asp?user_id="&rs("aucItemOwner")&"><img alt=""會員信用級別""：建議您出價前點擊其星級查看信用詳情。 border=0 src=""img/1star.gif""></a>"
case 2
response.write "<a href=usercredit.asp?user_id="&rs("aucItemOwner")&"><img alt=""會員信用級別""：建議您出價前點擊其星級查看信用詳情。 border=0 src=""img/2star.gif""></a>"
case 3
response.write "<a href=usercredit.asp?user_id="&rs("aucItemOwner")&"><img alt=""會員信用級別""：建議您出價前點擊其星級查看信用詳情。 border=0 src=""img/3star.gif""></a>"
case 4
response.write "<a href=usercredit.asp?user_id="&rs("aucItemOwner")&"><img alt=""會員信用級別""：建議您出價前點擊其星級查看信用詳情。 border=0 src=""img/4star.gif""></a>"
case default
response.write "新會員"
end select
%>
</td>
</tr>
<tr>
<td colspan=2 id=b2><nobr> <strong>信用度：<%=rs("credit")%></strong> <span
id=b1>好評率：<%=rs("haoping")%></span></nobr></td>
</tr>
<tr>
<td colspan=2 id=b1><nobr> <font
color=#666666>注冊時間：<%=rs("regTime")%></font></nobr></td>
</tr>
<tr>
<td colspan=2 id=b1><a
href=usercredit.asp?user_id=<%=rs("regID")%>
target=_blank>查看信用詳情</a></td>
</tr>
<tr>
<td colspan=2 id=b1><a
href=ask.asp?auc_id=<%=rs("aucid")%>&ownerid=<%=rs("aucItemOwner")%>>向賣家提問</a></td>
</tr>
<tr>
<td colspan=2 height=6></td>
</tr>
<tr>
<td colspan=2 id=b1><a
href=selling.asp?user_id=<%=rs("regID")%>
target=_blank>
<%
sqlselling="select count(*) as sellnum from auctions where aucItemOwner="&rs("regID")&" and aucended='N'"
set rsselling=conn.execute(sqlselling)
if not rs.eof then
%>
該用戶在售商品(共<%=rsselling("sellnum")%>件)
<%end if%>
</a></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<br>
<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><a
href1="<%=weburl%>">商品描述</a></nobr></td>
<td> </td>
<td> </td>
</tr>
</tbody>
</table>
<br>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="760">
<TBODY>
<TR>
<TD id=bg01><IMG height=1 src="img/trans1p.gif"
width=1></TD></TR></TBODY></TABLE>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="760">
<TBODY>
<TD><%=replace(rs("aucDescription"),chr(10),"<br>")%><BR></TD></TR>
<TR>
<TD bgColor=#d7d7d7><IMG height=1
src="img/trans1p.gif"
width=1></TD></TR>
<TR>
<TD height=3></TD></TR></TBODY></TABLE><br>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="760">
<TBODY>
<TR align=right>
<TD colSpan=4 height=20 id=B1><A
href="sell.asp?catid=<%=RS("catid")%>&cats=<%=rs("catsonid")%>">我有此類商品要賣</A>
<A
href="http://www.vqqq.com">將此商品告訴朋友</A>
</TD></TR></TBODY></TABLE>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="760"
dwcopytype="CopyTableRow">
<TBODY>
<TR>
<TD colSpan=4 height=20 id=b2><B><FONT id=f4>附屬信息：</FONT></B></TD>
</TR>
<TR>
<TD align=right height=20 id=bg02 width="20%"><FONT id=f4>商品號：</FONT></TD>
<TD height=20 id=bg02 width="20%"><%=rs("aucId")%></TD>
<TD align=right height=20 id=bg02 width="30%"><FONT
id=f4>發(fā)票：<BR>
</FONT></TD>
<TD height=20 id=bg02 width="30%"><%=rs("fapiao")%> </TD>
</TR>
<TR>
<TD align=right height=20 id=bg02><FONT id=f4>開始時間：</FONT></TD>
<TD height=20 id=bg02><%=rs("aucAvailDate")%></TD>
<TD align=right height=20 id=bg02><FONT id=f4>保修：<BR>
</FONT></TD>
<TD height=20 id=bg02><%=rs("baoxiu")%></TD>
</TR>
<TR>
<TD align=right height=20 id=bg02><FONT id=f4>結束時間：</FONT></TD>
<TD height=20 id=bg02><%=rs("aucCloseDate")%></TD>
<TD align=right height=20 id=bg02><FONT id=f4>誰負擔運費：<BR>
</FONT></TD>
<TD height=20 id=bg02><%=rs("yunfei")%> </TD>
</TR>
<TR>
<TD align=right height=20 id=bg02><FONT id=f4>商品所在地：</FONT></TD>
<TD height=20 id=bg02><%=rs("regState")%><%=rs("regCity")%></TD>
<TD align=right height=20 id=bg02><FONT id=f4>支付方式：<BR>
</FONT></TD>
<TD height=20 id=bg02><%=rs("zhifu")%></TD>
</TR>
<TR>
<TD align=right height=20 id=bg02><FONT id=f4>銷售區(qū)域：</FONT></TD>
<TD height=20 id=bg02>中國</TD>
<TD align=right height=20 id=bg02><FONT id=f4>送貨方式：</FONT></TD>
<TD height=20 id=bg02><%=rs("songhuo")%> </TD>
</TR>
<TR>
<TD align=right height=20 id=bg02><FONT id=f4>買家信用限制：</FONT></TD>
<TD height=20 id=bg02>
<%=rs("limit")%>
</TD>
<TD align=right height=20 id=bg02></TD>
<TD height=20 id=bg02></TD>
</TR>
<TR>
<TD align=right height=20 id=bg02><FONT id=f4>新舊程度：</FONT></TD>
<TD height=20 id=bg02>
<%=rs("oldnew")%>
</TD>
<TD align=right height=20 id=bg02></TD>
<TD height=20 id=bg02></TD>
</TR>
</TBODY>
</TABLE>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 id=b1 width="760">
<TBODY>
<TR>
<TD align=right><A
href="<%=weburl%>"
target=_blank>我想找賣家了解商品怎么辦？</A></TD></TR></TBODY></TABLE><!-- ---------------------------一口價過程 ----------------------------------------------------------------------------- --><A
name=bid></A><BR>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 height=20
width="760"><TBODY>
<TR id=B1>
<TD align=middle id=bg07 width=90><NOBR>競標過程</NOBR></TD>
<TD align=right width=792><NOBR> </NOBR></TD></TR></TBODY></TABLE>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="760">
<TBODY>
<TR>
<TD id=bg01><IMG height=1
src="img/trans1p.gif"
width=1></TD></TR></TBODY></TABLE><!-- -----------------------------競價列表-------------------------------------------------------------------------------------------- -->
<TABLE align=center bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0
width="760">
<TBODY>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -