?? qq.asp
字號:
<!--#include file="conn.asp" -->
<html><head><title>訂單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="Robots" content="index,follow">
<link href="Inc/ManageMent.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.STYLE3 {color: #000000}
.STYLE4 {
font-size: 16pt;
font-weight: bold;
}
.STYLE5 {
color: #999999
}
.STYLE7 {color: #000000; font-weight: bold; }
-->
</style>
</head>
<%
ddh=request.QueryString("ddh")
set rs=Server.createobject("adodb.recordset")
sql="select * from bs_ddan Where ddh='"&ddh&"'"
rs.open sql,conn,1,1
set rs1=Server.createobject("adodb.recordset")
sql1="select * from bs_ddanlb Where ddh='"&ddh&"'"
rs1.open sql1,conn,1,1
%>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="20" onLoad="self.focus();">
<table width="621" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="632" height="30"><table width="619" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="111" rowspan="3"><div align="right"><img src=img/edip_logo.jpg alt="1" width="58" height="59"></div></td>
<td colspan="8"><div align="center"><span class="STYLE4"><font style="font-size: 18pt">***** 有 限 公 司 訂 單</font></span> </div></td>
</tr>
<tr>
<td colspan="8"><strong><font style="font-size: 10pt">http://www.*****.com</font></strong></td>
</tr>
<tr>
<td colspan="8"><strong>電話:0595-***** 傳真:0595-*******</strong></td>
</tr>
<tr>
<td> </td>
<td colspan="8"><strong><font style="font-size: 10pt">中國辦事處地址:*****</font></strong></td>
</tr>
<tr>
<td height="20"> </td>
<td width="75"> </td>
<td width="41"> </td>
<td width="118"> </td>
<td width="69"><span class="STYLE3">訂 單 號：</span></td>
<td width="77"><strong><%=request.cookies("ddh")%></strong></td>
<td width="62" colspan="2">結算方式：</td>
<td width="65"><strong><font style="font-size: 9pt"><%=rs1("ausd")%></font></strong></td>
</tr>
<tr>
<td height="20">To:<span style="font-weight: bold"><font style="font-size: 9pt"> <%=rs1("gys")%></font></span></td>
<td> </td>
<td> </td>
<td> </td>
<td><span class="STYLE3">下單日期：</span></td>
<td><strong><font style="font-size: 9pt"><%=rs1("xdrq")%></font></strong></td>
<td colspan="2">交貨日期：</td>
<td><strong><font style="font-size: 9pt"><%=rs1("jhrq")%></font></strong></td>
</tr>
<tr>
<td height="20"><div align="left">From:<span style="font-weight: bold"><font style="font-size: 9pt"><%=rs1("xdr")%></font></span></div></td>
<td height="20"> </td>
<td> </td>
<td> </td>
<td><font style="font-size: 9pt">發 貨 地：</font></td>
<td><span style="font-weight: bold"><font style="font-size: 9pt"><%=rs1("fhd")%></font></span></td>
<td colspan="2"><font style="font-size: 9pt">到 達 地：</font></td>
<td><span style="font-weight: bold"><font style="font-size: 9pt"><%=rs1("daodd")%></font></span></td>
</tr>
</table> </td>
</tr>
<tr><td><table width="619" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td width="44" height="25" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">編號</div>
</div></td>
<td width="91" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">我方名稱</div>
</div></td>
<td width="105" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">廠方名稱</div>
</div></td>
<td width="84" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">規 格</div>
</div></td>
<td width="70" align="center" bgcolor="#CCCCCC"><div align="center"><strong>表面處理</strong></div></td>
<td width="53" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">數量</div>
</div></td>
<td width="54" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">單價</div>
</div></td>
<td width="49" align="center" bgcolor="#CCCCCC"><div align="center" class="STYLE7">
<div align="center">合計</div>
</div></td>
<td width="49" align="center" bgcolor="#CCCCCC"><div align="center"><strong>重量</strong></div></td>
</tr>
<%
i=0
sum=0
while not rs.eof
i=i+1
%>
<tr bgcolor="#FFFFFF">
<td width="44" height="20" align="center"><div align="center"><%=i%></div></td>
<td width="91"><div align="center"><%=rs("cp_id")%></div></td>
<td width="105"><div align="center"><%=rs("cp_cname")%></div></td>
<td width="84"><div align="center"><%=rs("guigei")%></div></td>
<td width="70"><div align="center"><%=rs("bmcl")%></div></td>
<td width="53" align=center> <div align="center"><%=rs("shuliang")%></div></td>
<td width="54" align=center><div align="center"><%=rs("danjia")%></div></td>
<td width="49" align=center><div align="center"><%=formatnumber(rs("danjia")*rs("shuliang"),2)%></div></td>
<td width="49" align=center><%=rs("cpzl")%></td>
</tr>
<%sum=formatnumber(rs("danjia")*rs("shuliang"),2)+sum
rs.movenext
wend
rs.close
%>
<tr bgcolor="#FFFFFF">
<td height="35" rowspan="2" align=left valign="middle"><div align="center"><strong>船公司</strong></div></td>
<td height="35" colspan="4" rowspan="2" align=left valign="middle"><span style="font-weight: bold"><font style="font-size: 9pt"><%=rs1("cgs")%> 聯系電話: 聯系人: 傳真: 郵件:</font></span></td>
<td colspan="4"><div align="center"><span class="STYLE3">總價(<font style="font-size: 9pt"><%=rs1("ausd")%></font>)： <strong><%=formatnumber(sum,2)%>元</strong></span></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="4"><div align="center"><span class="STYLE3">總重：<strong><%=formatnumber(sum,2)%></strong></span><strong>磅</strong></div></td>
</tr>
<tr>
<td bgcolor="#ffffff" height=40 align=center><p>說</p>
<p> </p>
<p>明</p></td>
<td height=40 colspan="8" align=center bgcolor="#ffffff"><p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>
</td></tr></table>
<%rs1.close%>
<div align="center" class="STYLE5">****萬恒石材公司管理系統V2.1 授權合法使用 銷售電話:(0)13685906969</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -