<% 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 "/shop/user/login.asp?url='"&url&"'" end if%> <%=webname%>  ----  会员中心 - 我的订单
<%=request.cookies("timesshop")("username")%>的订单

<%set rs=server.CreateObject("adodb.recordset") rs.open "select * from goods where username='"&request.cookies("timesshop")("username")&"' order by dcreatedate desc",conn,1,1 intTotalNum = rs.RecordCount do while not rs.eof %> <% rs.movenext loop rs.close set rs=nothing%>
订单号 订单金额 订货人 订单日期 订单状态 付款状态  
" ><%=rs("goodsid")%> <%=rs("totaljg")%> <%=trim(rs("name"))%> <%=trim(rs("dcreatedate"))%> <%if rs("mdel")=1 then%> 自助取消 <%elseif rs("goodsstats") =0 then %> 未处理 <%elseif rs("goodsstats") =1 then%> 无效订单 <%elseif rs("goodsstats")=2 then%> 处理中的订单 <%elseif rs("goodsstats")=3 then%> 交易完成 <%end if%> <% if rs("payforstats")=0 then%>未到款<% elseif rs("payforstats")=1 then%>已到款<%end if%> <%if rs("mdel")=1 then %> " class="style7">恢复 <% elseif rs("goodsstats") =0 and rs("mdel")=0 then %> ">取消 <%end if%>
共有<%=intTotalNum%>个订单