📄 tuyun1_save88.asp
字号:
<%
On Error Resume Next
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../../data.mdb")
%>
<% aa=request.Form("aa")
bb=request.Form("bb")
cc=request.Form("cc")
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")
pp1=request.Form("pp1")
pp2=request.Form("pp2")
qq=request.Form("qq")
qq1=request.Form("qq1")
qq2=request.Form("qq2")
rr=request.Form("rr")
rr1=request.Form("rr1")
rr2=request.Form("rr2")
ss=request.Form("ss")
ss1=request.Form("ss1")
ss2=request.Form("ss2")
tt=request.Form("tt")
tt1=request.Form("tt1")
tt2=request.Form("tt2")
uu=request.form("uu")
uu1=request.form("uu1")
uu2=request.form("uu2")
vv=request.form("vv")
vv1=request.form("vv1")
vv2=request.form("vv2")
ww=request.form("ww")
ww1=request.form("ww1")
ww2=request.form("ww2")
ww3=request.form("ww3")
ww4=request.form("ww4")
ww5=request.form("ww5")
ww6=request.form("ww6")
ww7=request.form("ww7")
ww8=request.form("ww8")
ww9=server.HTMLEncode(request.form("ww9"))
ww10=request.form("ww10")
ww11=request.form("ww11")
ww12=request.form("ww12")
ppp=request.form("ppp")
names=request.form("names")
car=request.form("car")
poo=request.form("poo")
set rs=server.CreateObject("adodb.recordset")
sql="select * from tuyun1 "
rs.open sql,conn,3,3
rs.addnew
rs("year")=aa
rs("month")=bb
rs("date")=cc
if request("ee")="" then
rs("send_add")=null
else
rs("send_add")=request("ee")
end if
if request("ff")="" then
rs("accept_add1")=null
else
rs("accept_add1")=request("ff")
end if
if request("gg")="" then
rs("number")=null
else
rs("number")=request("gg")
end if
if request("hh")="" then
rs("accept_name")=null
else
rs("accept_name")=request("hh")
end if
if request("ii")="" then
rs("accept_tel")=null
else
rs("accept_tel")=request("ii")
end if
if request("jj")="" then
rs("accept_cell")=null
else
rs("accept_cell")=request("jj")
end if
if request("kk")="" then
rs("accept_add")=null
else
rs("accept_add")=request("kk")
end if
if request("ll")="" then
rs("post")=null
else
rs("post")=request("ll")
end if
if request("mm")="" then
rs("send_name")=null
else
rs("send_name")=request("mm")
end if
if request("nn")="" then
rs("send_tel")=null
else
rs("send_tel")=request("nn")
end if
if request("oo")="" then
rs("send_cell")=null
else
rs("send_cell")=request("oo")
end if
if request("pp")="" then
rs("goods")=null
else
rs("goods")=request("pp")
end if
if request("pp1")="" then
rs("goods1")=null
else
rs("goods1")=request("pp1")
end if
if request("pp2")="" then
rs("goods2")=null
else
rs("goods2")=request("pp2")
end if
if request("qq")="" then
rs("baozhuan")=null
else
rs("baozhuan")=request("qq")
end if
if request("qq1")="" then
rs("baozhuan1")=null
else
rs("baozhuan1")=request("qq1")
end if
if request("qq2")="" then
rs("baozhuan2")=null
else
rs("baozhuan2")=request("qq2")
end if
if request("rr")="" then
rs("jie")="0"
else
rs("jie")=request("rr")
end if
if request("rr1")="" then
rs("jie1")="0"
else
rs("jie1")=request("rr1")
end if
if request("rr2")="" then
rs("jie2")="0"
else
rs("jie2")=request("rr2")
end if
if request("ss")="" then
rs("body")="0"
else
rs("body")=request("ss")
end if
if request("ss1")="" then
rs("body1")="0"
else
rs("body1")=request("ss1")
end if
if request("ss2")="" then
rs("body2")="0"
else
rs("body2")=request("ss2")
end if
if request("tt")="" then
rs("kg")="0"
else
rs("kg")=request("tt")
end if
if request("tt1")="" then
rs("kg1")="0"
else
rs("kg1")=request("tt1")
end if
if request("tt2")="" then
rs("kg2")="0"
else
rs("kg2")=request("tt2")
end if
if request("uu")="" then
rs("jifei")="0"
else
rs("jifei")=request("uu")
end if
if request("uu1")="" then
rs("jifei1")="0"
else
rs("jifei1")=request("uu1")
end if
if request("uu2")="" then
rs("jifei2")="0"
else
rs("jifei2")=request("uu2")
end if
if request("vv")="" then
rs("tuyunfei")="0"
else
rs("tuyunfei")=request("vv")
end if
if request("vv1")="" then
rs("tuyunfei1")="0"
else
rs("tuyunfei1")=request("vv1")
end if
if request("vv2")="" then
rs("tuyunfei2")="0"
else
rs("tuyunfei2")=request("vv2")
end if
if request("ww")="" then
rs("car_fei")="0"
else
rs("car_fei")=request("ww")
end if
if request("ww1")="" then
rs("war_fei")="0"
else
rs("war_fei")=request("ww1")
end if
if request("ww2")="" then
rs("server_fei")="0"
else
rs("server_fei")=request("ww2")
end if
if request("ww3")="" then
rs("cailao_fei")="0"
else
rs("cailao_fei")=request("ww3")
end if
if request("ww4")="" then
rs("baoxian_fei")="0"
else
rs("baoxian_fei")=request("ww4")
end if
if request("ww5")="" then
rs("sonhuo_fei")="0"
else
rs("sonhuo_fei")=request("ww5")
end if
if request("ww6")="" then
rs("post_fei")="0"
else
rs("post_fei")=request("ww6")
end if
if request("ww7")="" then
rs("other_fei")="0"
else
rs("other_fei")=request("ww7")
end if
if request("ww8")="" then
rs("hotal")="0"
else
rs("hotal")=request("ww8")
end if
if request("ww9")="" then
rs("beizhu")=null
else
rs("beizhu")=request("ww9")
end if
if request("ww10")="" then
rs("total1")=null
else
rs("total1")=request("ww10")
end if
if request("ww11")="" then
rs("money")=null
else
rs("money")=request("ww11")
end if
if request("ww12")="" then
rs("kaipiaoren")=null
else
rs("kaipiaoren")=request("ww12")
end if
if request("names")="其它费用" then
rs("name")="其它费用"
else
rs("name")=request("names")
end if
if request("ppp")="" then
rs("baoxian")=null
else
rs("baoxian")=request("ppp")
end if
if request("car")="" then
rs("car_number")=null
else
rs("car_number")=request("car")
end if
rs("company")=poo
'rs("people")="江丽华"
rs.update
rs.close
%>
<%
set rs1=server.createobject("adodb.recordset")
set rs1=conn.execute("Select * from tuyun1 Where send_add='"&request.form("ee")&"'")
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")
%>
<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>
</head>
<body>
<div id="Layer1" style="position:absolute; width:86px; height:33px; z-index:1; left: 619px; top: 125px;"><%=rs1("car_number")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 38px; top: 36px;"><%=rs1("year")%>
<%=rs1("month")%> <%=rs1("date")%></div>
<div id="Layer3" style="position:absolute; width:289px; height:23px; z-index:3; left: 434px; top: 67px;"><%=rs1("company")%></div>
<div id="Layer3" style="position:absolute; width:200px; height:23px; z-index:3; left: 77px; top: 118px;"><%=rs1("send_name") %></div>
<div id="Layer3" style="position:absolute; width:169px; height:51px; z-index:3; left: 436px; top: 121px;">
<table width="100%">
<tr>
<td><%=rs1("send_add")%></td>
</tr>
<tr>
<td><%=rs1("accept_add")%></td>
</tr>
</table>
</div>
<div id="Layer4" style="position:absolute; width:91px; height:106px; z-index:4; left: 14px; top: 218px;"><%=rs1("goods")%><br><br>
<%=rs1("goods1")%><br><br>
<%=rs1("goods2")%></div>
<div id="Layer5" style="position:absolute; width:42px; height:109px; z-index:5; left: 128px; top: 216px;"><%=rs1("jie")%><br><br><%=rs1("jie1")%><br><br><%=rs1("jie2")%></div>
<div id="Layer5" style="position:absolute; width:33px; height:109px; z-index:5; left: 209px; top: 217px;"><%=rs1("kg")%><br><br><%=rs1("kg1")%><br><br><%=rs1("kg2")%></div>
<div id="Layer5" style="position:absolute; width:43px; height:109px; z-index:5; left: 283px; top: 217px;"><%=rs1("baozhuan")%><Br><br><%=rs1("baozhuan1")%><br><br><%=rs1("baozhuan")%></div>
<div id="Layer6" style="position:absolute; width:44px; height:108px; z-index:6; left: 357px; top: 218px;"><%=rs1("jifei")%><br><br><%=rs1("jifei1")%><br><br><%=rs1("jifei2")%></div>
<div id="Layer7" style="position:absolute; width:49px; height:109px; z-index:7; left: 435px; top: 217px;"><%=rs1("tuyunfei")%><br><br><%=rs1("tuyunfei1")%><br><br><%=rs1("tuyunfei2")%></div>
<p> </p>
<div id="Layer3" style="position:absolute; width:202px; height:23px; z-index:3; left: 76px; top: 70px;"><%=rs1("accept_name")%></div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer9" style="position:absolute; width:124px; height:27px; z-index:9; left: 573px; top: 348px;"><%=rs1("hotal") %></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 110px; top: 342px;"><%=total %></div>
<div id="Layer8" style="position:absolute; width:144px; height:24px; z-index:8; left: 107px; top: 389px;"><%=rs1("total1")%></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 597px; top: 391px;"><%=rs1("money") %></div>
<p> </p>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 321px; top: 428px;"><%=rs1("kaipiaoren")%></div>
<div id="Layer10" style="position:absolute; width:74px; height:21px; z-index:10; left: 533px; top: 10px;">
<input name="Submit" type="submit" class="button" onClick='this.className="hidden";window.print();' value="打印发票">
</div>
<p align="center" class="button"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -