<% If request.cookies("timesshop")("username")="" Then dim url url=url&request.ServerVariables("SCRIPT_NAME") if(len(trim(request.ServerVariables("QUERY_STRING")))>0) then url=url & "?" & request.ServerVariables("QUERY_STRING") end if response.write url response.Redirect "/user/login.asp?url='"&url&"'" else%> <%=webname%>:会员中心
本站统计信息
<% dim joindtm,myorder,successed,successedsum,lastorder set rs=server.CreateObject("adodb.recordset") rs.open "select * from [user] where username='"&request.cookies("timesshop")("username")&"'",conn,1,1 joindtm=rs("adddate") deposit=rs("deposit") rs.close rs.open "select * from goods where username='"&request.cookies("timesshop")("username")&"' and mdel=0 ",conn,1,1 if rs.eof and rs.bof then response.write "" else rs.movelast lastorder=rs("dcreatedate") myorder=rs.recordcount end if rs.close rs.open "select count(totaljg) as totaljg from goods where username='"&request.cookies("timesshop")("username")&"' and goodsstats=2 ",conn,1,1 if rs("totaljg")>0 then successedsum=rs("totaljg") else successedsum=0 end if rs.close rs.open "select * from goods where username='"&request.cookies("timesshop")("username")&"' and goodsstats=2 and mdel=0 ",conn,1,1 successed=rs.recordcount set rs=nothing %>
以下是您在本站的一些历史记录的统计信息
注册日期：
   <% =joindtm %>
上次下单：
   <% =lastorder %>
下单次数：
   <% = myorder %> 次
成交次数：
   <% =successed %> 次
成交金额：
   <% =successedsum %> 元
预 存 款：
   <% =deposit %> 元

付款留言

汇款金额：
汇款方式：
汇款日期：
对应订单：
 <% sql = "Select goodsid from goods where username='"& request.cookies("timesshop")("username") &"' and mdel=0 order by goodsid" Set objTemp = Conn.Execute (sql) Response.Write "" objTemp.Close Set objTemp = Nothing %>
留言内容：
 

<%end if%>