📄 tuyun1_save.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 tuyun1 Where code='"& CheckCode&"' "
Set Rs=Conn.Execute(Sql)
If Not Rs.eof Or Not Rs.bof then errorMsg("已经存在该随机码，请刷新页面后重新填写表单！")
%>
<% 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")
vv1=request.form("vv1")
vv2=request.form("vv2")
vv3=request.form("vv3")
vv4=request.form("vv4")
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=server.HTMLEncode(request.form("ppp"))
names=request.form("names")
car=request.form("car")
poo=request.form("poo")
code=request.form("Check")
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")=null
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")=null
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("vv1")="" then
rs("tuyunfei")="0"
else
rs("tuyunfei")=request("vv1")
end if
if request("vv2")="" then
rs("tuyunfei1")="0"
else
rs("tuyunfei1")=request("vv2")
end if
if request("vv3")="" then
rs("tuyunfei2")=null
else
rs("tuyunfei2")=request("vv3")
end if
if request("ww1")="" then
rs("car_fei")="0"
else
rs("car_fei")=request("ww1")
end if
if request("ww2")="" then
rs("war_fei")="0"
else
rs("war_fei")=request("ww2")
end if
if request("ww3")="" then
rs("server_fei")="0"
else
rs("server_fei")=request("ww3")
end if
if request("ww4")="" then
rs("cailao_fei")="0"
else
rs("cailao_fei")=request("ww4")
end if
if request("ww5")="" then
rs("baoxian_fei")="0"
else
rs("baoxian_fei")=request("ww5")
end if
if request("ww6")="" then
rs("sonhuo_fei")="0"
else
rs("sonhuo_fei")=request("ww6")
end if
if request("ww7")="" then
rs("post_fei")="0"
else
rs("post_fei")=request("ww7")
end if
if request("ww8")="" then
rs("other_fei")="0"
else
rs("other_fei")=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")="无"
else
rs("car_number")=request("car")
end if
if request("vv4")="" then
rs("hotal")="0"
else
rs("hotal")=request("vv4")
end if
rs("company")=poo
if request("Check")="" then
rs("code")=null
else
rs("code")=request("Check")
end if
'rs("people")="江丽华"
rs.update
rs.close
%>
<%
set rs1=server.createobject("adodb.recordset")
set rs1=conn.execute("Select * from tuyun1 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>
</head>
<body>
<div id="Layer2" style="position:absolute; width:104px; height:23px; z-index:2; left: 98px; top: 26px;"><%=rs1("year")%> <%=rs1("month")%> <%=rs1("date")%></div>
<div id="Layer3" style="position:absolute; width:105px; height:23px; z-index:3; left: 201px; top: 62px;"><%=rs1("accept_add1")%></div>
<div id="Layer4" style="position:absolute; width:67px; height:72px; z-index:4; left: 14px; top: 180px;"> <%=rs1("goods")%><br>
<%=rs1("goods2")%> <br>
<br>
<%=rs1("goods1")%> </div>
<div id="Layer5" style="position:absolute; width:50px; height:76px; z-index:5; left: 82px; top: 181px;">
<%=rs1("baozhuan")%><br>
<%=rs1("baozhuan2")%> <br>
<%=rs1("baozhuan1")%> </div>
<div id="Layer5" style="position:absolute; width:49px; height:77px; z-index:5; left: 133px; top: 181px;">
<%=rs1("jie")%><br>
<%=rs1("jie2")%> <br>
<%=rs1("jie1")%> </div>
<div id="Layer5" style="position:absolute; width:53px; height:79px; z-index:5; left: 377px; top: 178px;">
<%=rs1("jifei")%><br>
<%=rs1("jifei2")%> <br>
<%=rs1("jifei1")%> </div>
<div id="Layer7" style="position:absolute; width:65px; height:80px; z-index:7; left: 436px; top: 176px;">
<%=rs1("tuyunfei")%><br>
<%=rs1("tuyunfei2")%> <br>
<%=rs1("tuyunfei1")%> </div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 383px; top: 59px;"><%=rs1("number")%></div>
<p> </p>
<div id="Layer3" style="position:absolute; width:73px; height:24px; z-index:3; left: 54px; top: 60px;"><%=rs1("send_add")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 334px; top: 85px;"><%=rs1("accept_tel")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 469px; top: 83px;"><%=rs1("accept_cell")%></div>
<p> </p>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 118px; top: 86px;"><%=rs1("accept_name")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 119px; top: 132px;"><%=rs1("send_name") %></div>
<div id="Layer2" style="position:absolute; width:186px; height:26px; z-index:2; left: 120px; top: 109px;"><%=rs1("accept_add")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 468px; top: 131px;"><%=rs1("send_cell")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 334px; top: 129px;"><%=rs1("send_tel")%></div>
<div id="Layer2" style="position:absolute; width:104px; height:26px; z-index:2; left: 468px; top: 107px;"><%=rs1("post")%></div>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer6" style="position:absolute; width:63px; height:115px; z-index:11; left: 537px; top: 167px;">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" rowspan="9"><div align="center"></div>
</td>
<td><div align="center"><%=rs1("car_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("war_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("server_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("cailao_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("baoxian_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("sonhuo_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("post_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("other_fei")%></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("hotal")%></div></td>
</tr>
</table>
</div>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 108px; top: 253px;"><%=rs1("baoxian")%></div>
<div id="Layer8" style="position:absolute; width:144px; height:24px; z-index:8; left: 46px; top: 346px;"><%=rs1("beizhu")%></div>
<div id="Layer8" style="position:absolute; width:228px; height:24px; z-index:8; left: 121px; top: 372px;"><%=rs1("total1")%></div>
<p> </p>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 64px; top: 394px;"><%=rs1("kaipiaoren")%></div>
<div id="Layer10" style="position:absolute; width:74px; height:21px; z-index:10; left: 296px; top: 4px;">
<input name="Submit" type="submit" class="button" onClick='this.className="hidden";window.print();' value="打印发票">
</div>
<div id="Layer8" style="position:absolute; width:144px; height:24px; z-index:8; left: 481px; top: 366px;"><%=rs1("money")%></div>
<p align="center" class="button"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -