📄 priter.asp
字号:
<!--#include file="function1.asp" -->
<%
On Error Resume Next
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../../../data.mdb")
CheckCode=ReplaceBadChar(trim(request.form("Check")))
if CheckCode<>CStr(session("CheckCode")) then
ErrorMsg("您输入的随机码和系统产生的不一致，请重新输入。")
end if
Sql="Select code from tuyun Where code='"& CheckCode&"' "
Set Rs=Conn.Execute(Sql)
If Not Rs.eof Or Not Rs.bof then errorMsg("已经存在该随机码，请刷新页面后重新填写表单！")
%>
<% ziqi =request.Form("ziqi")
'aa=request.Form("aa")
'bb=request.Form("bb")
'cc=request.Form("cc")
dd=request.Form("dd")
ee=request.Form("ee")
ff=request.Form("ff")
gg=request.Form("gg")
hh=request.Form("hh")
ii=request.Form("ii")
jj=request.Form("jj")
kk=request.Form("kk")
ll=request.Form("ll")
mm=request.Form("mm")
nn=request.Form("nn")
oo=request.Form("oo")
pp=request.Form("pp")
qq=request.Form("qq")
rr=request.Form("rr")
ss=request.Form("ss")
tt=request.Form("tt")
uu=server.HTMLEncode(request.Form("uu"))
goods=request.form("goods")
goods1=request.form("goods1")
goods2=request.form("goods2")
goods3=request.form("good3")
box=request.form("box")
box1=request.form("box1")
box2=request.form("box2")
box3=request.form("box3")
num=request.form("num")
num1=request.form("num1")
num2=request.form("num2")
num3=request.form("num3")
kg=request.form("kg")
kg1=request.form("kg1")
kg2=request.form("kg2")
kg3=request.form("kg3")
body=request.form("body")
body1=request.form("body1")
body2=request.form("body2")
body3=request.form("body3")
count0=request.form("count0")
count1=request.form("count1")
count2=request.form("count2")
count3=request.form("count3")
poo=request.form("poo")
car=request.form("car")
code=request.form("check")
cellphone=request.form("cellphone")
set rs=server.CreateObject("adodb.recordset")
sql="select * from tuyun "
rs.open sql,conn,3,3
rs.addnew
if request("ziqi") ="" then
rs("ziqi") = null
else
rs("ziqi") = request("ziqi")
end if
'rs("year")=aa
' rs("month")=bb
'rs("date1")=cc
rs("send_people")=dd
rs("send_address")=ee
if request("hh")="" then
rs("send_tel")=null
else
rs("send_tel")=request("hh")
end if
if request("ff")="" then
rs("send_first")=null
else
rs("send_first")=request("ff")
end if
if request("gg")="" then
rs("send_last")=null
else
rs("send_last")=request("gg")
end if
rs("accept_people")=mm
rs("accept_address")=oo
if request("qq")="" then
rs("accept_tel")=null
else
rs("accept_tel")=request("qq")
end if
if request("ss")="" then
rs("accept_post")=null
else
rs("accept_post")=request("ss")
end if
if request("num")="" then
rs("num")=null
else
rs("num")=request("num")
end if
if request("num1")="" then
rs("num1")=null
else
rs("num1")=request("num1")
end if
if request("num2")="" then
rs("num2")=null
else
rs("num2")=request("num2")
end if
if request("num3")="" then
rs("num3")=null
else
rs("num3")=request("num3")
end if
if request("goods")="" then
rs("goods")=null
else
rs("goods")=request("goods")
end if
if request("goods1")="" then
rs("goods1")=null
else
rs("goods1")=request("goods1")
end if
if request("goods2")="" then
rs("goods2")=null
else
rs("goods2")=request("goods2")
end if
if request("goods3")="" then
rs("goods3")=null
else
rs("goods3")=request("goods3")
end if
if request("box")="" then
rs("box")=null
else
rs("box")=request("box")
end if
if request("box1")="" then
rs("box1")=null
else
rs("box1")=request("box1")
end if
if request("box2")="" then
rs("box2")=null
else
rs("box2")=request("box2")
end if
if request("box3")="" then
rs("box3")=null
else
rs("box3")=request("box3")
end if
if request("kg")="" then
rs("kg")=null
else
rs("kg")=request("kg")
end if
if request("kg1")="" then
rs("kg1")=null
else
rs("kg1")=request("kg1")
end if
if request("kg2")="" then
rs("kg2")=null
else
rs("kg2")=request("kg2")
end if
if request("kg3")="" then
rs("kg3")=null
else
rs("kg3")=request("kg3")
end if
if request("body")="" then
rs("body")=null
else
rs("body")=request("body")
end if
if request("body1")="" then
rs("body1")=null
else
rs("body1")=request("body1")
end if
if request("body2")="" then
rs("body2")=null
else
rs("body2")=request("body2")
end if
if request("body3")="" then
rs("body3")=null
else
rs("body3")=request("body3")
end if
if request("count0")="" then
rs("count0")=null
else
rs("count0")=request("count0")
end if
if request("count1")="" then
rs("count1")=null
else
rs("count1")=request("count1")
end if
if request("count2")="" then
rs("count2")=null
else
rs("count2")=request("count2")
end if
if request("count3")="" then
rs("count3")=null
else
rs("count3")=request("count3")
end if
if request("uu")="" then
rs("main")=null
else
rs("main")=request("uu")
end if
if request("kk")="" then
rs("post_fen")=null
else
rs("post_fen")=request("kk")
end if
if request("jj")="" then
rs("post_jie")=null
else
rs("post_jie")=request("jj")
end if
if request("ii")="" then
rs("number")=null
else
rs("number")=request("ii")
end if
if request("ll")="" then
rs("baoxian")=null
else
rs("baoxian")=request("ll")
end if
if request("nn")="" then
rs("chanwei")=null
else
rs("chanwei")=request("nn")
end if
if request("pp")="" then
rs("yanshouyuan")=null
else
rs("yanshouyuan")=request("pp")
end if
if request("rr")="" then
rs("date")=null
else
rs("date")=request("rr")
end if
if request("tt")="" then
rs("number1")=null
else
rs("number1")=request("tt")
end if
if request("oo")="" then
rs("accept_address")=null
else
rs("accept_address")=request("oo")
end if
if request("poo")="" then
rs("company")=null
else
rs("company")=request("poo")
end if
if request("car")="" then
rs("car")=null
else
rs("car")=request("car")
end if
if request("Check")="" then
rs("code")=null
else
rs("code")=request("Check")
end if
if request("cellphone")="" then
rs("cellphone")=null
else
rs("cellphone")=request("cellphone")
end if
rs.update
rs.close
'response.redirect"../tuyun1.asp"
%>
<%
set rs1=server.createobject("adodb.recordset")
set rs1=conn.execute("Select * from tuyun Where code='"&request.form("Check")&"'")
'whole=rs1("car_fei")+rs1("war_fei")+rs1("server_fei")+rs1("cailao_fei")+rs1("sonhuo_fei")+rs1("baoxian")+ rs1("sonhuo_fei")+rs1("post_fei")+rs1("other_fei")
'total=rs1("tuyunfei")+rs1("tuyunfei1")+rs1("tuyunfei2")
'total1=rs1("hotal")+total
%>
<html>
<head>
<link href="appmain.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>丽水市公铁联运有限公司托运单</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<style type="text/css">
<!--
.style1 {font-size: small}
-->
</style>
</head>
<body>
<div id="Layer2" style="position:absolute; width:141px; height:26px; z-index:2; left: 518px; top: 1px;"><font size="4"><%=rs1("ziqi")%></font></div>
<div id="Layer3" style="position:absolute; width:317px; height:23px; z-index:3; left: 381px; top: 37px;"><font size="3"><%=rs1("accept_people")%></font></div>
<div id="Layer3" style="position:absolute; width:212px; height:23px; z-index:3; left: 64px; top: 65px;"><font size="3"><%=rs1("send_address") %></font></div>
<div id="Layer4" style="position:absolute; width:75px; height:106px; z-index:4; left: 19px; top: 167px;"><font size="3"><%=rs1("goods")%></font><br><br>
<font size="3"><%=rs1("goods1")%></font><br>
<br>
<%=rs1("goods2")%><font></font></div>
<div id="Layer5" style="position:absolute; width:55px; height:109px; z-index:5; left: 113px; top: 162px;"><span class="style1"><font size="2"><%=rs1("box")%></font><br>
</span><br>
<span class="style1"><font size="2"><%=rs1("box1")%></font><br>
</span><br>
<font size="2"><%=rs1("box2")%></font><br>
</div>
<div id="Layer5" class="style1" style="position:absolute; width:43px; height:109px; z-index:5; left: 160px; top: 159px;"><%=rs1("num")%><br><br>
<%=rs1("num1")%><br>
<%=rs1("num2")%><br><br>
<%=rs1("num3")%> </div>
<div id="Layer5" class="style1" style="position:absolute; width:53px; height:109px; z-index:5; left: 224px; top: 160px;"><%=rs1("kg")%><br>
<%=rs1("kg1")%><br>
<%=rs1("kg2")%><br><br><br><%=rs1("kg3")%><br>
</div>
<div id="Layer7" style="position:absolute; width:65px; height:109px; z-index:7; left: 322px; top: 153px;"><%=rs1("body")%><br>
<br>
<%=rs1("body1")%><br>
<br>
<%=rs1("body2")%><br>
<%=rs1("body3")%> </div>
<p> </p>
<div id="Layer3" style="position:absolute; width:312px; height:23px; z-index:3; left: 63px; top: 39px;"><font size="3"><%=rs1("send_people")%></font></div>
<div id="Layer3" style="position:absolute; width:375px; height:23px; z-index:3; left: 382px; top: 64px;"><font size="2"><%=rs1("accept_address") %></font></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 229px; top: 66px;">
<div align="left"><font size="3"><%=rs1("send_tel")%></font></div>
</div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 381px; top: 107px;"><font size="3"><%=rs1("accept_tel")%></font></div>
<p> </p>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 52px; top: 100px;"><font size="3"><%=rs1("send_first")%></font></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 555px; top: 97px;"><font size="3"><%=rs1("accept_post")%></font></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 382px; top: 93px;"><font size="3"><%=rs1("cellphone")%></font></div>
<p> </p>
<div id="Layer7" style="position:absolute; width:65px; height:109px; z-index:7; left: 419px; top: 149px;"><%=rs1("count0")%><br>
<br>
<%=rs1("count1")%><br><br>
<%=rs1("count2")%><br>
<%=rs1("count3")%><br>
</div>
<div id="Layer9" style="position:absolute; width:124px; height:35px; z-index:9; left: 545px; top: 149px;"><font size="3"><%=rs1("chanwei")%></font></div>
<div id="Layer9" style="position:absolute; width:124px; height:32px; z-index:9; left: 548px; top: 185px;"><font size="3"><%=rs1("yanshouyuan")%></font></div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer8" style="position:absolute; width:118px; height:31px; z-index:8; left: 545px; top: 285px;"><%=rs1("number1")%></div>
<p> </p>
<div id="Layer9" style="position:absolute; width:124px; height:32px; z-index:9; left: 547px; top: 226px;"><font size="3"><%=rs1("date")%></font></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 212px; top: 99px;"><font size="3"><%=rs1("send_last")%></font></div>
<div id="Layer8" style="position:absolute; width:75px; height:62px; z-index:8; left: 423px; top: 275px;">
<table width="86" height="64" cellpadding="0" cellspacing="0">
<tr>
<td width="145"><font size="3"><%=rs1("post_fen")%></font></td>
</tr>
<tr>
<td><font size="3"><%=rs1("post_jie")%></font></td>
</tr>
</table>
</div>
<div id="Layer8" style="position:absolute; width:479px; height:55px; z-index:8; left: 66px; top: 410px;"><font size="3"><%=rs1("main")%></font></div>
<p> </p>
<div id="Layer8" style="position:absolute; width:90px; height:32px; z-index:8; left: 306px; top: 303px;"><%=rs1("number")%></div>
<div id="Layer10" style="position:absolute; width:79px; height:21px; z-index:10; left: 145px; top: 4px;">
<input name="Submit" type="submit" class="button" onClick='this.className="hidden";window.print();' value="打印发票">
</div>
<div id="Layer8" style="position:absolute; width:90px; height:32px; z-index:8; left: 112px; top: 316px;"><font size="3"><%=rs1("baoxian")%></font></div>
<p align="center" class="button"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -