📄 print2.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
dim dbpath
dbpath="../"
%>
<!--#include file="chk.asp" -->
<!--#include file="../db_conn.asp"-->
<!--#include file="../comm/my_request.asp"-->
<%
response.buffer = true
%>
<html>
<head>
<title>报表</title>
<style media="print">.Noprint { DISPLAY: none }</style>
</head>
<body bgcolor="#FFFFFF">
<center><h1>我的订单</h1></center>
<%
ddbh=my_request("nodot",0)
page=my_request("page",1)
sql="select id,yqj_realname,yqj_address,yqj_postal,yqj_phone,yqj_email,paymode,content,yqj_money,yqj_cost,zt from buyer where ddbh='"&ddbh&"'"
set rs=conn.execute (sql)
id=rs("id")
yqj_realname=rs("yqj_realname")
yqj_address=rs("yqj_address")
yqj_postal=rs("yqj_postal")
yqj_phone=rs("yqj_phone")
yqj_email=rs("yqj_email")
paymode=rs("paymode")
content=rs("content")
yqj_money=rs("yqj_money")
yqj_cost=rs("yqj_cost")
zt=rs("zt")
rs.close
set rs=nothing%>
<div align="center">
<table border="0" width="920" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" align=right><center class=noprint>
<input onclick="javascript:window.print();" type="button" value="直接打印" style="float: right">
</center></td>
</tr>
<tr>
<td colspan="2">此订单的联系方式</td>
</tr>
<tr>
<td colspan="2">真实姓名：<%=yqj_realname%></td>
</tr>
<tr>
<td colspan="2">联系地址：<%=yqj_address%></td>
</tr>
<tr>
<td colspan="2">邮政编码：<%=yqj_postal%></td>
</tr>
<tr>
<td colspan="2">联系电话：<%=yqj_phone%></td>
</tr>
<tr>
<td width="583" colspan="2">邮件地址：<%=yqj_email%></td>
</tr>
<tr>
<td>支付方式：<%=paymode%></td>
<td>处理状态：<font color=#FF0000><%=zt%></font></td>
</tr>
<tr>
<td>总计金额：<%=yqj_money%></td>
<td>总计费用：<%=yqj_cost%></td>
</tr>
<tr>
<td colspan="2">备注说明：<%=content%></td>
</tr>
<tr>
<td colspan="2">
<hr size="1"></td>
</tr>
<tr>
<td colspan="2" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="6">
<p align="center">此订单的商品详细情况</td>
</tr>
<tr>
<td height="20" width="8%">ID</td>
<td height="20" width="27%">商品名称</td>
<td height="20" width="13%">购买数量</td>
<td height="20" width="18%">所属订单</td>
<td height="20" width="9%">价格</td>
<td height="20" width="23%">购买时间</td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select id,bh,mc,sl,rmb,sj from list where cartbh='"&ddbh&"'"
rs.open sql,conn,1,1
i=1
do while not rs.eof
id=rs("id")
bh=rs("bh")
mc=rs("mc")
sl=rs("sl")
rmb=rs("rmb")
sj=rs("sj")
%>
<tr>
<td height="20" width="8%"><%=i%></td>
<td height="20" width="27%"><a href=../product_list.asp?id=<%=bh%> target=_blank><%=mc%></a></td>
<td height="20" width="13%"><%=sl%></td>
<td height="20" width="18%"><%=ddbh%></td>
<td height="20" width="9%">￥<%=rmb%>元</td>
<td height="20" width="23%"><%=sj%></td>
</tr>
<%
rs.movenext
i=i+1
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -