📄 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 + -