📄 tuyun_save.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")
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")
set rs=server.CreateObject("adodb.recordset")
sql="select * from tuyun "
rs.open sql,conn,3,3
rs.addnew
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("sccept_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")="0"
else
rs("num")=request("num")
end if
if request("num1")="" then
rs("num1")="0"
else
rs("num1")=request("num1")
end if
if request("num2")="" then
rs("num2")="0"
else
rs("num2")=request("num2")
end if
if request("num3")="" then
rs("num3")="0"
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")="0"
else
rs("kg")=request("kg")
end if
if request("kg1")="" then
rs("kg1")="0"
else
rs("kg1")=request("kg1")
end if
if request("kg2")="" then
rs("kg2")="0"
else
rs("kg2")=request("kg2")
end if
if request("kg3")="" then
rs("kg3")="0"
else
rs("kg3")=request("kg3")
end if
if request("body")="" then
rs("body")="0"
else
rs("body")=request("body")
end if
if request("body1")="" then
rs("body1")="0"
else
rs("body1")=request("body1")
end if
if request("body2")="" then
rs("body2")="0"
else
rs("body2")=request("body2")
end if
if request("body3")="" then
rs("body3")="0"
else
rs("body3")=request("body3")
end if
if request("count0")="" then
rs("count0")="0"
else
rs("count0")=request("count0")
end if
if request("count1")="" then
rs("count1")="0"
else
rs("count1")=request("count1")
end if
if request("count2")="" then
rs("count2")="0"
else
rs("count2")=request("count2")
end if
if request("count3")="" then
rs("count3")="0"
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
rs("company")=poo
if request("car")="" then
rs("car")=null
else
rs("car")=request("car")
end if
rs.update
rs.close
'response.redirect"../tuyun1.asp"
%>
<%
set rs1=server.createobject("adodb.recordset")
set rs1=conn.execute("Select * from tuyun Where send_people='"&request.form("dd")&"'")
box4=rs1("box")+rs1("box1")+rs1("box2")+rs1("box3")
num4=rs1("num")+rs1("num1")+rs1("num2")+rs1("num3")
kg4=rs1("kg")+rs1("kg1")+rs1("kg2")+rs1("kg3")
body4=rs1("body")+rs1("body1")+rs1("body2")+rs1("body3")
count4=rs1("count0")+rs1("count1")+rs1("count2")+rs1("count3")
%><html>
<head>
<link href="../../appmain.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>save</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<body>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr bgcolor="#99CC99" background="../image/titlebg.gif">
<td colspan="2"> <div align="center"><font color="#FF0000">丽水市公铁联运有限公司丽水货运站货物托运单</font></div></td>
</tr>
<tr>
<td width="9%">托运日期 </td>
<td width="91%"><%=rs1("year") %><%= rs1("month") %>月<%= rs1("date1") %>日</td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td width="2%" rowspan="4"><font color="#FF0000">托运人信息</font></td>
<td width="10%"><div align="center">托运单位</div></td>
<td width="42%"><%=rs1("send_people") %></td>
<td width="9%">详细地址</td>
<td width="37%"><%= rs1("send_address") %> </td>
</tr>
<tr>
<td><div align="center">起 站</div></td>
<td><%=rs1("send_first") %></td>
<td><div align="center">到 站</div></td>
<td><%=rs1("send_last") %></td>
</tr>
<tr>
<td><div align="center">电 话</div></td>
<td><%=rs1("send_tel") %></td>
<td>货票号码</td>
<td><%=rs1("number") %></td>
</tr>
<tr>
<td height="23">附送证单</td>
<td> <%= rs1("post_jie") %>件 <%= rs1("post_fen") %>份</td>
<td><div align="center">保 险</div></td>
<td> <%=rs1("baoxian") %>元</td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td width="2%" rowspan="4"><font color="#FF0000">收货人信息</font></td>
<td width="10%"><div align="center">收货单位</div></td>
<td width="39%"><%=rs1("accept_people") %> </td>
<td width="3%" rowspan="4"><font color="#FF0000">其它信息</font></td>
<td width="11%">堆放仓位</td>
<td width="35%"><%= rs1("chanwei") %></td>
</tr>
<tr>
<td><div align="center">详细地址</div></td>
<td><%= rs1("accept_address") %></td>
<td>仓库验收员</td>
<td><%= rs1("yanshouyuan") %></td>
</tr>
<tr>
<td><div align="center">电 话</div></td>
<td><%= rs1("accept_tel") %></td>
<td>收货日期</td>
<td><%= rs1("date") %></td>
</tr>
<tr>
<td><div align="center">邮 编</div></td>
<td><%= rs1("accept_post") %></td>
<td>票签号码</td>
<td><%= rs1("number1") %></td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td width="17%" height="25"> <div align="center">货 名</div></td>
<td width="15%"><div align="center">包装</div></td>
<td width="11%"><div align="center">件数</div></td>
<td width="15%"><div align="center">实际重量(KG)</div></td>
<td width="26%"><div align="center">体积[(长*宽*高)(立方)]</div></td>
<td width="16%"><div align="center">计费重量(KG)</div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("goods") %></div></td>
<td><div align="center"><%=rs1("box") %></div></td>
<td><div align="center"><%=rs1("num") %></div></td>
<td><div align="center"><%=rs1("kg") %></div></td>
<td><div align="center"><%=rs1("body") %></div></td>
<td><div align="center"><%=rs1("count0") %></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("goods1") %></div></td>
<td><div align="center"><%=rs1("box1") %></div></td>
<td><div align="center"><%=rs1("num1") %></div></td>
<td><div align="center"><%=rs1("kg1") %></div></td>
<td><div align="center"><%=rs1("body1") %></div></td>
<td><div align="center"><%=rs1("count1") %></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("goods2") %></div></td>
<td><div align="center"><%=rs1("box2") %></div></td>
<td><div align="center"><%=rs1("num2") %></div></td>
<td><div align="center"><%=rs1("kg2") %></div></td>
<td><div align="center"><%=rs1("body2") %></div></td>
<td><div align="center"><%=rs1("count2") %></div></td>
</tr>
<tr>
<td><div align="center"><%=rs1("goods3") %></div></td>
<td><div align="center"><%=rs1("box3") %></div></td>
<td><div align="center"><%=rs1("num3") %></div></td>
<td><div align="center"><%=rs1("kg3") %></div></td>
<td><div align="center"><%=rs1("body3") %></div></td>
<td><div align="center"><%=rs1("count3") %></div></td>
</tr>
<tr>
<td><div align="center"> 合 计</div></td>
<td><div align="center"><%=box4%></div></td>
<td><div align="center"><%=num4%></div></td>
<td><div align="center"><%=kg4%></div></td>
<td><div align="center"><%=body4 %></div></td>
<td><div align="center"><%=count4 %></div></td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td width="7%">货主特约事项</td>
<td width="93%"><%= rs1("main") %></td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td width="7%"><font color="#FF0000">货主注意事项</font></td>
<td width="93%"><font color="#FF0000">1、细线内各项由货主填写，保险栏如保额不足，出险后不足部份托运人自负。<br>
2、托运货物必须按规定包装完好， 捆扎牢固，并附税务发票、随货同行联及有关单据。<Br>
3、不得捏报货名，不得在货物中夹带危险、禁运等物品，否则一切损失，由托运人负责。</font></td>
</tr>
</table>
<form name="form1" method="post" action="priter.asp">
<div align="center">
<input name="Submit2" type="submit" class="tabback" value="打印发票">
</div>
</form>
<p> </p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -