note.asp

电子商务网络购物系统

<% response.write "<table><tr><td>"
response.write "<div align=center>"
if request.cookies("timesshop")("username")="" then
				response.write "您还没有登录！"
else
set rs=server.CreateObject("adodb.recordset")
rs.open "select product.price2,orders.productnum from product inner join orders on product.id=orders.id where orders.state=1 and orders.username='"&trim(request.Cookies("timesshop")("username"))&"' ",conn,1,1
dim shop
set shop=server.CreateObject("adodb.recordset")
shop.Open "select distinct(goods) from orders where username='"&request.Cookies("timesshop")("username")&"' and state=1 ",conn,1,1
if shop.recordcount=0 then
response.write "<b><font color=#94515A><br>欢迎您<font color=#000000>【"&Request.Cookies("timesshop")("username")&"】</b><IMG SRC=images/gb.gif WIDTH=20 HEIGHT=16 ALT=小喇叭开始广播啦><br></font>"&notify&""
else
dim shopjiage
do while not rs.eof
shopjiage=round(shopjiage+rs("price2")*rs("productnum"),2)
rs.movenext
loop
response.write "<b><font color=#94515A><br>欢迎您<font color=#000000>【"&request.cookies("timesshop")("username")&"】</b><IMG SRC=images/gb.gif WIDTH=20 HEIGHT=16 ALT=小喇叭开始广播啦><br></font>"&notify&""
end if
shop.Close
set shop=nothing
rs.close
set rs=nothing
end if
response.write "</div></td></tr></table>"
%>