📄 orderslog.asp
字号:
<!--#include file="adminconn.inc" -->
<%
if request("dingdan")<>"" then
sql="select * from orders where inBillNo='"&request("dingdan")&"'"
else
sql="select * from orders where id="&request("search")
end if
set rs=server.createobject("ADODB.Recordset")
rs.open sql,conn,1,1
username=rs("username")
sql1="select * from user where username='"&username&"'"
set rs1=server.createobject("ADODB.Recordset")
rs1.open sql1,conn,1,1
%>
<html>
<head>
<title>订单详细说明</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../inc/guhongying.css" type="text/css">
</head>
<body bgcolor="6699CC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#000000" vspace="0" hspace="0">
<tr>
<td bgcolor="#316395" height="27"><font color="#FFFFFF">.:: 您可以在这里查看帐号的订单的详细信息</font></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="50"> </td>
</tr>
</table>
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#000000" width="60%" align="center">
<form name="form1" method="post" action="edituser.asp">
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>订购帐号:</font></td>
<td bgcolor="#336699" height="30" width="69%">
<a href="edituser.asp?searchuser=<%=rs("username")%>"><font color=ffffff><b><%=rs("username")%> </b></font></a></td>
</tr>
<tr>
<td bgcolor="#7C96B8" align="left" height="30" width="31%"><font color=ffffff>订单号码:</font></td>
<td bgcolor="#7C96B8" align="left" height="30" width="69%"><font color=ffffff><b><%=rs("inBillNo")%></b></font></td>
</tr>
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>订购总价格:</font></td>
<td bgcolor="#336699" height="30" width="69%"><font color=ffffff><b><%=rs("summoney")%>
RMB </b></font></td>
</tr>
<tr bgcolor="#7C96B8">
<td height="30" width="31%"><font color=ffffff>订购时间:</font></td>
<td height="30" width="69%"><font color=ffffff><b> <%=rs("ordertime")%></b></font></td>
</tr>
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>支付方式:</font></td>
<td bgcolor="#336699" height="30" width="69%"><font color=ffffff><b><%=rs("paymenttype")%>
</b></font></td>
</tr>
<tr bgcolor="#7C96B8">
<td height="30" width="31%"><font color=ffffff>订购人信箱:</font></td>
<td height="30" width="69%"><font color=ffffff><b><%=rs1("email")%> </b></font></td>
</tr>
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>收件人信箱:</font></td>
<td bgcolor="#336699" height="30" width="69%"><font color=ffffff><b><%=rs("semail")%>
</b></font></td>
</tr>
<tr bgcolor="#7C96B8">
<td height="30" width="31%"><font color=ffffff>收件人地址:</font></td>
<td height="30" width="69%" bgcolor="#7C96B8"><font color=ffffff><b><%=rs("saddress")%>
</b></font></td>
</tr>
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>此订单是否交易:</font></td>
<td bgcolor="#336699" height="30" width="69%"><font color=ffffff><b>
<%
if rs("comp")=true then
response.write "已经交易"
else
response.write "尚未交易"
end if
%>
</b></font></td>
</tr>
<tr bgcolor="#7C96B8">
<td align="left" height="50" colspan="2">
<div align="center"><b><font color="#FFFFFF">扩展功能等待添加^&^ </font></b></div>
</td>
</tr>
</form>
</table>
<p> </p><p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -