?? list.asp
字號:
<!--#include file="conn.asp"-->
<%
oid=request("oid")
set rs=server.createobject("adodb.recordset")
sql="select * from orderlist where oid='"&oid&"' order by oid desc"
rs.open sql,conn,1,1
if not rs.eof then
%>
<html>
<head>
<title>查看訂單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../edit.css" type="text/css">
</head>
<body bgcolor="#9CC7EF" text="#000000" leftMargin=0 topMargin=0>
<table width="480" height="400" border="1" align="center" cellpadding="4" cellspacing="0" bordercolorlight=#145AA0 bordercolordark=#9CC7EF>
<tr bgcolor="#4296E7">
<td colspan="2"> >訂單 <b><font color="#FF9900"><%=Form_Id%></font></b></td>
</tr>
<tr>
<td height="25" align="center" nowrap>所訂產品</td>
<td nowrap> <a href="../ArticleShow.asp?hw_id=<%=rs("hw_id")%>" target="_blank"><%
set rs1=server.createobject("adodb.recordset")
sql="select hw_name from shop where hw_id="&rs("hw_id")&""
rs1.open sql,conn,1,1
if not rs1.eof then response.write rs1("hw_name")
rs1.close
%></a></td>
</tr>
<tr>
<td width="23%" height="25" align="center" nowrap>訂貨人姓名</td>
<td width="77%" nowrap> <%=rs("name")%></td>
</tr>
<tr>
<td height="25" align="center">聯系地址</td>
<td> <%=rs("address")%></td>
</tr>
<tr>
<td height="25" align="center">郵政編碼</td>
<td> <%=rs("zip")%></td>
</tr>
<tr>
<td height="25" align="center">聯系電話</td>
<td> <%=rs("tel")%></td>
</tr>
<tr>
<td height="25" align="center">傳真</td>
<td> <%=rs("fax")%></td>
</tr>
<tr>
<td height="25" align="center">E-mail</td>
<td> <%=rs("email")%></td>
</tr>
<tr>
<td height="25" align="center">發布日期</td>
<td> <%=rs("pub_time")%></td>
</tr>
<tr>
<td height="25" align="center">備注</td>
<td height="100"> <%=rs("remark")%></td>
</tr>
<tr bgcolor="#4296E7">
<td colspan="2" align="center"><strong>
<INPUT style="BORDER-RIGHT: 1px outset; BORDER-TOP: 1px outset; FONT-WEIGHT: normal; FONT-SIZE: 9pt; BORDER-LEFT: 1px outset; BORDER-BOTTOM: 1px outset; FONT-STYLE: normal; FONT-VARIANT: normal" type=submit onclick="javascript:window.close();" value=" 關 閉 窗 口 " name=Submit>
</strong></td>
</tr>
</table>
</body>
</html>
<%
end if
rs.close
conn.close
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -