<%
set shop=server.CreateObject("adodb.recordset")
shop.Open "select * from goods where username='"&request.Cookies("timesshop")("username")&"' and mdel=0 and goodsstats=0 ",conn,1,1
set rsvip=server.CreateObject("adodb.recordset")
rsvip.open "select vip from [user] where username='"&request.Cookies("timesshop")("username")&"' ",conn,1,1
if rsvip("vip") <> 0 then
if shop.recordcount=0 then %>
|
| 欢迎<% = Request.Cookies("timesshop")("username") %>
光临 您是<% if rsvip("vip")=1 then %>一<%elseif rsvip("vip")=2 then%>二<%elseif rsvip("vip")=3 then %>三<%elseif rsvip("vip")=4 then%>四<%end if%>钻会员用户 |
| 您目前没有未处理订单 |
| 共计:0.00元 |
<%
else
dim shopjiage
shopjiage=0
do while not shop.eof
totaljg=shop("totaljg")
shopjiage=totaljg+shopjiage
shop.movenext
loop %>
|
| 欢迎<% = Request.Cookies("timesshop")("username") %>光临 您是<% if rsvip("vip")=1 then %>一<%elseif rsvip("vip")=2 then%>二<%elseif rsvip("vip")=3 then %>三<%elseif rsvip("vip")=4 then%>四<%end if%>钻会员用户 |
| 您目前有 <% = shop.recordcount %> 笔未处理订单 |
| 共计：<% = shopjiage %>
元 |
<%
end if
rsvip.close
set rsvip = nothing
else
if shop.recordcount=0 then %>
|
| 欢迎<% = Request.Cookies("timesshop")("username") %>光临 您是普通用户 |
| 您目前没有未处理订单 |
| 共计:0.00元 |
<%
else
do while not shop.eof
totaljg=shop("totaljg")
shopjiage=totaljg+shopjiage
shop.movenext
loop %>
|
| 欢迎<% = Request.Cookies("timesshop")("username") %>光临 您是普通用户 |
| 您目前有<% = shop.recordcount %>笔未处理订单 |
| 共计：<% = shopjiage %>
元 |
<%
end if
shop.Close
set shop=nothing
end if %> |
|
|
我的消息 .gif){kind=small}
