bbr_buy_ykj_auction.asp

. 缓存处理技术

<!--#include file="top_cnbbr.asp"-->
<!--#include file="chksession.asp"-->
<!--#include file="inc/mypage.asp"-->

<!--#include file="Cnbbr_UserCenter_Left.asp" -->

<%
Response.Write Cnbbr_Head
  With Response
	.Write "<table width="""& Sys_BodyCenterWidth &""" border=""0"" cellspacing=""0"" cellpadding=""0""  align=""center"" class=""td"">" & Vbcrlf
	.Write "  <tr>" & Vbcrlf
	.Write "   <td width=""150"" align=""left"" valign=""top"" class=td>" & Vbcrlf
	 Disp_CnbbrCenterLeft
	.Write "   </td>" & Vbcrlf
	.Write "   <td align=""left"" valign=""top"" class=td>" & Vbcrlf

	Dim SiteMenu_Width,SiteMenu_Left,SiteMenu_Right
	SiteMenu_Width="98%"
	SiteMenu_Left="BBRhome.asp|[menu]|个人面板||[menu]||BBRhome.asp|[menu]|我是买家||[menu]||BBR_Buy_YkjAuction.asp|[menu]|一口价成交的商品"
	SiteMenu_Right=""
	Response.Write CnbbrSiteMenu(SiteMenu_Width,SiteMenu_Left,SiteMenu_Right)

	.Write "<table border=0 cellpadding=0 cellspacing=0 width=""98%"" align=center>" & Vbcrlf
	.Write "<tr class=td>"& Vbcrlf
	.Write "<td>" & Vbcrlf
  End With


Dim UserID
UserID=Request.Cookies(Super_User)("Uid")
if not isNum(UserID) then Call alertInfo("登录状态异常，请重新登陆系统！","login.asp",1)

Sql="select a.YkjBidItemID,a.YkjbidNum,a.YkjBidAmount,a.YkjBidDate,b.aucid,b.aucitemtitle,b.aucitemowner,b.aucCurrentBid,b.auctotalnum,b.aucnum,b.BBR_AlipayStatus from YkjBids as a left join Auctions as b on a.ykjBidItemID=b.AucId where a.YkjBidBidderID="& UserID &" and b.auctype in ("& SYS_MODEL &") order by a.YkjBidDate Desc"
Dim MP : set MP= New mypage
set rs = MP.Execute(Sql,conn,jsPerPage)
CnbbrConnTimes



if rs.eof then
   HelpTitle="出错了！"
   HelpInfo="对不起，系统没有找到你使用一口价买入的商品信息！"
   HelpList="<Ul>" & Vbcrlf
   HelpList=HelpList & "<LI><a href=""search.asp"">参与一口价商品拍卖</a></LI>" & Vbcrlf
   HelpList=HelpList & "<LI><a href=""javascript: history.back(-1);"">返回上页</a></LI>" & Vbcrlf
   HelpList=HelpList & "</Ul>" & Vbcrlf
   Cnbbr_Helper HelpTitle,HelpInfo,HelpList,368
else
	With Response
	  .Write"<table width=100% border=0 cellspacing=1 cellpadding=0 class=tablebg>" & vbcrlf
	  .write"<tr class=titletd>" & vbcrlf
	  .write"<td width=40% align=center>商品名称</td>" & vbcrlf
	  .write"<td width=15% align=center>卖家</td>" & vbcrlf
	  .write"<td width=10% align=center>成交价</td>" & vbcrlf
	  .write"<td width=8% align=center>数量</td>" & vbcrlf
	  .write"<td width=12% align=center>成交时间</td>" & vbcrlf
	  .write"<td width=8% align=center>支付宝</td>" & vbcrlf
 	  .write"</tr>" & vbcrlf
  
   Do While Not rs.eof
	 .write"<tr class=td height=22>" & vbcrlf
	 .write"<td align=left>"& Vbcrlf
	 .Write"<a href=""AucInfo.asp?AucID="& rs("aucid") &""" target=""_blank"">"

	   Dim AucTitle:auctitle=rs("aucitemtitle")
	   if StrLength(auctitle)>30 then auctitle=InterceptString(auctitle,28)

	 .write "·"& auctitle
	 .write"</a>"& Vbcrlf
	 .write"</td>" & vbcrlf
	 .write"<td align=center>"
	 .write CnbbrSqlUser(rs("aucItemOwner"),0)
   	 .write"</td>" & vbcrlf
	 .write"<td align=right>￥"& FormatNumber(rs("ykjBidAmount"),2,-1) &"</td>" & vbcrlf
	 .write"<td align=center>"
	 .Write rs("ykjbidnum")
	 .write"</td>" & vbcrlf
	.write"<td align=center>"
	.write rs("ykjbiddate")
   	.write"</td>" & vbcrlf
	.write"<td align=center>"

	if Rs("BBR_AlipayStatus")=1 then
	   Dim RsSqlSeller
	   Sql="Select RegId,RegUserName,RegEmail from Users Where RegID="&Rs("aucItemOwner")
	   Set RsSqlSeller=Conn.Execute(Sql)
	   if Not (RsSqlSeller.Eof or RsSqlSeller.Bof) then
	      Dim TempAlipayUrl
	      TempAlipayUrl=RsSqlSeller("RegEmail") &"?subject=购买商品："& Rs("AucItemTitle") &"&body=付款人昵称："& Request.Cookies(Super_User)("UName") &"&price="& Rs("YkjBidAmount") &"&number="& Rs("YkjBidNum") &"&type=3"
	      TempAlipayUrl=Server.UrlEncode(TempAlipayUrl)
              .Write"<a href=""https://www.alipay.com/payto:"& TempAlipayUrl &""" target=""_Blank""><img Src=""Images/AlipayStatus.gif"" border=""0"" alt=""推荐使用支付宝支付，确保安全交易！""></a>"& Vbcrlf
	   else
	      .Write"无"
	   end if
	   RsSqlSeller.Close
	   Set RsSqlSeller=nothing
	end if

   	.write"</td>" & vbcrlf
	.write"</tr>" & vbcrlf
   rs.movenext
   Loop
	.Write"</table>" & vbcrlf
	.Write "<table cellpadding=0 cellspacing=1 width=100% align=center border=0 class=tablebg>" & vbcrlf
	.Write "<tr class=td>"& Vbcrlf
	.Write "<td width=100% align=center>"& Vbcrlf
	.Write MP.PageDispaly()
	.Write "</td>"& Vbcrlf
	.Write "</tr>" & vbcrlf
	.Write "</table>" & vbcrlf
   
   End With
End if

  With Response
	.Write "     </td>" & Vbcrlf
	.Write "    </tr>" & Vbcrlf
	.Write "   </table>" & Vbcrlf
	.Write "   </td>" & Vbcrlf
	.Write "  </tr>" & Vbcrlf
	.Write "</table>" & Vbcrlf
  End With

Response.WRite Cnbbr_Bottom
%>