📄 showorder.asp
字号:
<!--#include file="../checkuser.asp" -->
<!--#include file="../../Include/db_conn1.asp" -->
<% If request("id")<>"" then
id=request("id")
sql="Select * from ys_order where id="&id&""
Set rs=Server.CreateObject("Adodb.Recordset")
rs.open sql,conn,3,2
If Not rs.eof then
d_year=rs("d_year")
d_month=rs("d_month")
d_day=rs("d_day")
md1=rs("md1")
gd1=rs("gd1")
nu1=rs("nu1")
bz1=rs("bz1")
md2=rs("md2")
gd2=rs("gd2")
nu2=rs("nu2")
bz2=rs("bz2")
md3=rs("md3")
gd3=rs("gd3")
nu3=rs("nu3")
bz3=rs("bz3")
md4=rs("md4")
gd4=rs("gd4")
nu4=rs("nu4")
bz4=rs("bz4")
jhaddr=rs("jhaddr")
fkstyle=rs("fkstyle")
jh_year=rs("jh_year")
jh_month=rs("jh_month")
jh_day=rs("jh_day")
hz=rs("hz")
tel=rs("tel")
email=rs("email")
kfbank=rs("kfbank")
bankid=rs("bankid")
end if
rs.close
Set rs=Nothing
conn.close
Set conn=Nothing
end if %>
<% If request("id")="" then
sql="Select * from ys_order"
Set rs=Server.CreateObject("Adodb.Recordset")
rs.open sql,conn,3,2
If Not rs.eof then
d_year=rs("d_year")
d_month=rs("d_month")
d_day=rs("d_day")
md1=rs("md1")
gd1=rs("gd1")
nu1=rs("nu1")
bz1=rs("bz1")
md2=rs("md2")
gd2=rs("gd2")
nu2=rs("nu2")
bz2=rs("bz2")
md3=rs("md3")
gd3=rs("gd3")
nu3=rs("nu3")
bz3=rs("bz3")
md4=rs("md4")
gd4=rs("gd4")
nu4=rs("nu4")
bz4=rs("bz4")
jhaddr=rs("jhaddr")
fkstyle=rs("fkstyle")
jh_year=rs("jh_year")
jh_month=rs("jh_month")
jh_day=rs("jh_day")
hz=rs("hz")
tel=rs("tel")
email=rs("email")
kfbank=rs("kfbank")
bankid=rs("bankid")
end if
rs.close
Set rs=Nothing
conn.close
Set conn=Nothing
end if %>
<html>
<head>
<title>查看留言</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<link href="../include/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="600" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td><FORM name=submitform action="#" method=post>
<table bordercolor=#0 cellspacing=0 bordercolordark=#ffffff cellpadding=0 width="100%" align=center bordercolorlight=#000000 border=0>
<tbody>
<tr>
<td valign=top height=22> </td>
</tr>
<tr>
<td valign=top height=22> <div align=center>
<input type=hidden value=yuhua@yisharp.com name=sendemail2>
<input type=hidden value=客户订单信息 name=subject2>
订货日期:
<input name=d_year2 value="<%=d_year%>" size=10>
年
<input name=d_month2 value="<%=d_month%>" size=5>
月
<input name=d_day2 value="<%=d_day%>" size=5>
日 </div></td>
</tr>
<tr>
<td height=23> <div align="center"><span><font color=#ff0000>在下表填入产品数据：</font></span></div></td>
</tr>
<tr>
<td height=66> <table cellspacing=0 bordercolordark=#ffffff cellpadding=0 width="100%" bordercolorlight=#000000 border=0>
<tbody>
<tr>
<td width="27%" height=22> <div align=center>型 号</div></td>
<td width="25%" height=22> <div align=center>规 格</div></td>
<td width="22%" height=22> <div align=center>数 量</div></td>
<td width="26%" height=22> <div align=center>备 注</div></td>
</tr>
<tr>
<td width="27%" height=30> <div align=center>
<input name=md12 value="<%=md1%>" size="20">
</div></td>
<td width="25%" height=30> <div align=center>
<input name=gd12 value="<%=gd1%>" size=15>
</div></td>
<td width="22%" height=30> <div align=center>
<input name=nu12 value="<%=nu1%>" size=10>
</div></td>
<td width="26%" height=30> <div align=center>
<input name=bz12 value="<%=bz1%>" size="20">
</div></td>
</tr>
<tr>
<td width="27%" height=30> <div align=center>
<input name=md22 value="<%=md2%>" size="20">
</div></td>
<td width="25%" height=30> <div align=center>
<input name=gd22 value="<%=gd2%>" size=15>
</div></td>
<td width="22%" height=30> <div align=center>
<input name=nu22 value="<%=nu2%>" size=10>
</div></td>
<td width="26%" height=30> <div align=center>
<input name=bz22 value="<%=bz2%>" size="20">
</div></td>
</tr>
<tr>
<td width="27%" height=30> <div align=center>
<input name=md32 value="<%=md3%>" size="20">
</div></td>
<td width="25%" height=30> <div align=center>
<input name=gd32 value="<%=gd3%>" size=15>
</div></td>
<td width="22%" height=30> <div align=center>
<input name=nu32 value="<%=nu3%>" size=10>
</div></td>
<td width="26%" height=30> <div align=center>
<input name=bz32 value="<%=bz3%>" size="20">
</div></td>
</tr>
<tr>
<td width="27%" height=30> <div align=center>
<input name=md42 value="<%=md4%>" size="20">
</div></td>
<td width="25%" height=30> <div align=center>
<input name=gd42 value="<%=gd4%>" size=15>
</div></td>
<td width="22%" height=30> <div align=center>
<input
name=nu42 value="<%=nu4%>" size=10>
</div></td>
<td width="26%" height=30> <div align=center>
<input name=bz42 value="<%=bz4%>" size="20">
</div></td>
</tr>
</tbody>
</table>
<table cellspacing=0 bordercolordark=#ffffff cellpadding=0 width="100%" bordercolorlight=#000000 border=0>
<tbody>
<tr>
<td width="21%" height=30> <div align=center>联系电话：</div></td>
<td width="79%" height=30><font color=#cc0000>
<input name=tel2 value="<%=tel%>" size=50>
</font></td>
</tr>
<tbody>
<tr>
<td width="21%" height=30> <div align=center>电子邮件：</div></td>
<td width="79%" height=30><font color=#cc0000>
<input name=email2 id=email22 value="<%=email%>" size=50>
<font color=#ff0000 size=1>★</font></font></td>
</tr>
<tr>
<td width="21%" height=30> <div align=center>开户银行：</div></td>
<td width="79%" height=30><font color=#cc0000>
<input name=kfbank2 value="<%=kfbank%>" size=50>
</font></td>
</tr>
<tr>
<td width="21%" height=30> <div align=center>银行帐号：</div></td>
<td width="79%" height=30><font color=#cc0000>
<input name=bankid2 value="<%=bankid%>" size=50>
</font></td>
</tr>
</tbody>
</table></td>
</tr>
<tr>
<td> <table cellspacing=0 bordercolordark=#ffffff cellpadding=0 width="100%" bordercolorlight=#000000 border=0>
<tbody>
<tr>
<td width="21%"> <div align=center>交货地址：</div></td>
<td width="79%"><font color=#cc0000>
<input name=jhaddr2 value="<%=jhaddr%>" size=50>
</font></td>
</tr>
<tr>
<td width="21%" height=30> <div align=center>付款方式：</div></td>
<td width="79%"><font color=#cc0000>
<input name=fkstyle2 value="<%=fkstyle%>" size=50>
</font></td>
</tr>
<tr>
<td width="21%" height=30><div align=center>交货日期：</div></td>
<td width="79%" height=30> <input name=jh_year2 value="<%=jh_year%>" size=4>
年<font color=#000099>
<input name=jh_month2 value="<%=jh_month%>" size=2>
</font>月
<input name=jh_day2 value="<%=jh_day%>" size=2>
日</td>
</tr>
<tr>
<td valign=top width="21%"> <div align=center>订单内容：</div></td>
<td width="79%"><font color=#cc0000>
<textarea name=hz cols=50 rows=8 id="hz"><%=hz%></textarea>
</font></td>
</tr>
</tbody>
</table></td>
</tr>
<tr>
<td height=24><div align="center">〖 <a href="javascript:window.close();">关闭本页</a>
〗</div></td>
</tr>
<tr>
<td> <div align=center>
<p> </p>
</div></td>
</tr>
</tbody>
</table>
</FORM></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -