myorder.asp

体育商城

<%@LANGUAGE="VBSCRIPT"%>
<%
' *** Logout the current user.
MM_Logout = CStr(Request.ServerVariables("URL")) & "?MM_Logoutnow=1"
If (CStr(Request("MM_Logoutnow")) = "1") Then
  Session.Abandon
  MM_logoutRedirectPage = "userlogin.asp"
  ' redirect with URL parameters (remove the "MM_Logoutnow" query param).
  if (MM_logoutRedirectPage = "") Then MM_logoutRedirectPage = CStr(Request.ServerVariables("URL"))
  If (InStr(1, UC_redirectPage, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
    MM_newQS = "?"
    For Each Item In Request.QueryString
      If (Item <> "MM_Logoutnow") Then
        If (Len(MM_newQS) > 1) Then MM_newQS = MM_newQS & "&"
        MM_newQS = MM_newQS & Item & "=" & Server.URLencode(Request.QueryString(Item))
      End If
    Next
    if (Len(MM_newQS) > 1) Then MM_logoutRedirectPage = MM_logoutRedirectPage & MM_newQS
  End If
  Response.Redirect(MM_logoutRedirectPage)
End If
%>
<!--#include file="Connections/conn.asp" -->
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="userlogin.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
  If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
         (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
    MM_grantAccess = true
  End If
End If
If Not MM_grantAccess Then
  MM_qsChar = "?"
  If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
  MM_referrer = Request.ServerVariables("URL")
  if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
  MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
  Response.Redirect(MM_authFailedURL)
End If
%>
<%
Dim user__MMColParam
user__MMColParam = "1"
if (Session("mm_username") <> "") then user__MMColParam = Session("mm_username")
%>
<%
set user = Server.CreateObject("ADODB.Recordset")
user.ActiveConnection = MM_conn_STRING
user.Source = "SELECT *  FROM user,orders  WHERE user.user = '" + Replace(user__MMColParam, "'", "''") + "' and user.user=orders.user"
user.CursorType = 0
user.CursorLocation = 2
user.LockType = 3
user.Open()
user_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
user_numRows = user_numRows + Repeat1__numRows
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "="
MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone=""

' add the URL parameters to the MM_keepURL string
For Each Item In Request.QueryString
  NextItem = "&" & Item & "="
  If (InStr(1,MM_removeList,NextItem,1) = 0) Then
    MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item))
  End If
Next

' add the Form variables to the MM_keepForm string
For Each Item In Request.Form
  NextItem = "&" & Item & "="
  If (InStr(1,MM_removeList,NextItem,1) = 0) Then
    MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item))
  End If
Next

' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
if (MM_keepURL <> "")  Then MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)
if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
  If (firstItem <> "") Then
    MM_joinChar = "&"
  Else
    MM_joinChar = ""
  End If
End Function
%>
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>	
function DoTrimProperly(str, nNamedFormat, properly, pointed, points)
  dim strRet
  strRet = Server.HTMLEncode(str)
  strRet = replace(strRet, vbcrlf,"")
  strRet = replace(strRet, vbtab,"")
  If (LEN(strRet) > nNamedFormat) Then
    strRet = LEFT(strRet, nNamedFormat)			
    If (properly = 1) Then					
      Dim TempArray								
      TempArray = split(strRet, " ")	
      Dim n
      strRet = ""
      for n = 0 to Ubound(TempArray) - 1
        strRet = strRet & " " & TempArray(n)
      next
    End If
    If (pointed = 1) Then
      strRet = strRet & points
    End If
  End If
  DoTrimProperly = strRet
End Function
</SCRIPT>
<html>
<head>
<title>我的定单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="ddd.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="2" marginwidth="0" marginheight="0">
<!--#include file="top.asp" -->
<table width="771" border="0" cellspacing="0" cellpadding="0" align="center" height="258" class="bk1">
  <tr> 
    <td valign="top" height="267" width="167"> 
      <p><br>
        <br>
      </p>
      <table width="143" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td><a href="loginok.asp"><img src="images/myziliao.gif" width="165" height="53" border="0"></a></td>
        </tr>
        <tr> 
          <td height="23"><a href="myorder.asp"><img src="images/myorder.gif" width="165" height="53" border="0"></a></td>
        </tr>
        <tr> 
          <td height="2"><a href="mycart.asp"><img src="images/myCART.gif" width="165" height="53" border="0"></a></td>
        </tr>
        <tr> 
          <td height="43"><a href="order.asp"><img src="images/gosyt.gif" width="165" height="53" border="0"></a></td>
        </tr>
        <tr> 
          <td height="38"><a href="default.asp"><img src="images/maidx.gif" width="165" height="53" border="0"></a></td>
        </tr>
        <tr> 
          <td><a href="<%=MM_Logout%>"><img border=0 src="images/loginout.gif" width="165" height="53"></a></td>
        </tr>
      </table>
      <p><br>
      </p>
    </td>
    <td height="267" width="630"> 
      <% If Not user.EOF Or Not user.BOF Then %>
      <table width="589" border="1" cellspacing="2" cellpadding="0" align="center" bordercolor="#FFFFFF">
        <tr> 
          <td height="4" colspan="3"><font color="#FF0000"><b><span class="dfont"><font color="#FF3300"><%=(user.Fields.Item("user").Value)%></font></span></b></font><span class="dfont"><b> 以下是您的定单：</b></span></td>
        </tr>
        <tr bgcolor="#99CC00" bordercolor="#000000"> 
          <td height="11" width="159" class="dfont"> 
            <div align="center">定单号</div>
          </td>
          <td height="11" width="312" class="dfont"> 
            <div align="center">下单日期</div>
          </td>
          <td height="11" width="144" class="dfont"> 
            <div align="center">是否处理</div>
          </td>
        </tr>
        <% 
While ((Repeat1__numRows <> 0) AND (NOT user.EOF)) 
%>
        <tr bordercolor="#000000"> 
          <td height="12" width="159" class="dfont"> 
            <div align="center"><A HREF="myorderxx.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "orderid=" & user.Fields.Item("orderid").Value %>"><b><font color="#000066"><%=(user.Fields.Item("orderid").Value)%></font></b></A></div>
          </td>
          <td height="12" width="312" class="dfont"> 
            <div align="center"><%=(user.Fields.Item("orderdate").Value)%></div>
          </td>
          <td height="12" width="144" class="dfont"> 
            <div align="center"> 
              <% If (user.Fields.Item("chuli").Value) = (-1) Then 'script %>
              是 
              <% End If ' end If (user.Fields.Item("chuli").Value) = (-1) script %>
              <% If (user.Fields.Item("chuli").Value) = (0) Then 'script %>
              否 
              <% End If ' end If (user.Fields.Item("chuli").Value) = (0) script %>
            </div>
          </td>
        </tr>
        <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  user.MoveNext()
Wend
%>
      </table>
      <% End If ' end Not user.EOF Or NOT user.BOF %>
      <% If user.EOF And user.BOF Then %>
      <p align="center">对不起，您没有下过定单！</p>
      <% End If ' end user.EOF And user.BOF %>
    </td>
  </tr>
</table>
<br>
<!--#include file="bottom.asp" -->
</body>
</html>
<%
user.Close()
%>