tuyun1_save1.asp

20041230162250801409： 浙江省丽水市公铁联运有限公司OA系统（物流） 开发语言：PHP/ASP/PERL 本系统包括各个部门的管理

   <%
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")
	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("uu12")
		   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 
			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")
%>
<html>
<head>
<link href="../../appmain.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>丽水市公铁联运有限公司托运单</title>
</head>

<body>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td>托运日期: <%=rs1("year")  %><%=rs1("month") %>月<%=rs1("date") %> 日&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;热线电话：[phone] 
      2174666 </td>
  </tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td width="5%" height="25">
<div align="center">起站</div></td>
    <td width="24%"><%=rs1("send_add")%>&nbsp;</td>
    <td width="6%"><div align="center">到站</div></td>
    <td width="30%"><%=rs1("accept_add1")  %>&nbsp;</td>
    <td width="11%"><div align="center">运输号码</div></td>
    <td width="24%"><%=rs1("number")%>&nbsp;</td>
  </tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td width="6%" rowspan="3"><p align="center">托运<br>
        人填</p></td>
    <td width="13%">收货人姓名</td>
    <td width="32%"><%=rs1("accept_name") %>&nbsp;</td>
    <td width="6%"><div align="center">电话</div></td>
    <td width="15%"><%=rs1("accept_tel")%></td>
    <td width="7%"><div align="center">手机</div></td>
    <td width="21%"><%=rs1("accept_cell")%></td>
  </tr>
  <tr> 
    <td>收货人地址</td>
    <td><%=rs1("accept_add")%></td>
    <td><div align="center">邮编</div></td>
    <td><%=rs1("post")%></td>
    <td colspan="2"><div align="center"></div></td>
  </tr>
  <tr> 
    <td>发货人姓名</td>
    <td><%= rs1("send_name") %></td>
    <td><div align="center">电话</div></td>
    <td><%=rs1("send_tel") %></td>
    <td><div align="center">手机</div></td>
    <td><%=rs1("send_cell") %></td>
  </tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td colspan="2"><div align="center">货物名称</div></td>
    <td width="10%"><div align="center">包装</div></td>
    <td width="6%"><div align="center">件数</div></td>
    <td width="7%"><div align="center">体积</div></td>
    <td width="10%"><div align="center">计费重量</div></td>
    <td width="14%"><div align="center">计费：单价</div></td>
    <td width="9%"><div align="center">托运费</div></td>
    <td width="13%"><div align="center">项目</div></td>
    <td width="14%"><div align="center">金额</div></td>
  </tr>
  <tr> 
    <td colspan="2"> <div align="center"><%=rs1("goods") %> </div></td>
    <td> <div align="center"><%=rs1("baozhuan") %></div></td>
    <td> <div align="center"><%=rs1("jie") %></div></td>
    <td><div align="center"><%=rs1("body") %></div></td>
    <td><div align="center"><%=rs1("kg") %></div></td>
    <td><div align="center"><%=rs1("jifei") %></div></td>
    <td><div align="center"><%=rs1("tuyunfei") %></div></td>
    <td><div align="center">汽车运费</div></td>
    <td><div align="center"><%=rs1("car_fei") %></div></td>
  </tr>
  <tr> 
    <td height="23" colspan="2"> <div align="center"><%=rs1("goods1") %> </div></td>
    <td> <div align="center"><%=rs1("baozhuan1") %></div></td>
    <td> <div align="center"><%=rs1("jie1") %></div></td>
    <td><div align="center"><%=rs1("body1") %></div></td>
    <td><div align="center"><%=rs1("kg1") %></div></td>
    <td><div align="center"><%=rs1("jifei1") %></div></td>
    <td><div align="center"><%=rs1("tuyunfei1") %></div></td>
    <td><div align="center">铁路运费</div></td>
    <td><div align="center"><%=rs1("war_fei") %></div></td>
  </tr>
  <tr> 
    <td colspan="2"> <div align="center"><%=rs1("goods2") %> </div></td>
    <td> <div align="center"><%=rs1("baozhuan2") %></div></td>
    <td> <div align="center"><%=rs1("jie2") %></div></td>
    <td><div align="center"><%=rs1("body2") %></div></td>
    <td><div align="center"><%=rs1("kg2") %></div></td>
    <td><div align="center"><%=rs1("jifei2") %></div></td>
    <td><div align="center"><%=rs1("tuyunfei2") %></div></td>
    <td><div align="center">服务费</div></td>
    <td><div align="center"><%=rs1("server_fei") %></div></td>
  </tr>
  <tr> 
    <td colspan="2"><div align="left">保险金额(大写)</div></td>
    <td colspan="6"><div align="left"></div>
      <div align="center"></div>
      <div align="center"></div>
      <div align="center"></div>
      <div align="center"></div>
      <div align="left"><%=rs1("baoxian") %> </div></td>
    <td><div align="center">材料费</div></td>
    <td><div align="center"><%=rs1("cailao_fei") %></div></td>
  </tr>
  <tr> 
    <td width="2%" rowspan="5">托运人须知</td>
    <td colspan="7" rowspan="5">1、托运单由货主填写，保险如保额不足，出其不意险后不足部份托运人自负<br>
      2、不得捏报货名，不得在货物中夹带危险品、禁运等物品，否则一切损失，由托运人负责。</td>
    <td><div align="center">保险费</div></td>
    <td><div align="center"><%=rs1("baoxian_fei") %></div></td>
  </tr>
  <tr> 
    <td><div align="center">送货费</div></td>
    <td><div align="center"><%=rs1("sonhuo_fei") %></div></td>
  </tr>
  <tr> 
    <td><div align="center">邮资费</div></td>
    <td><div align="center"><%=rs1("post_fei") %></div></td>
  </tr>
  <tr> 
    <td><div align="center"><%=rs1("name") %> </div></td>
    <td><div align="center"><%=rs1("other_fei") %></div></td>
  </tr>
  <tr> 
    <td><div align="center">小计</div></td>
    <td><div align="center"><%=whole %></div></td>
  </tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td width="11%"><div align="center">备 注</div></td>
    <td width="89%"><%=rs1("beizhu") %></td>
  </tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td width="18%">合计人民币(大写)</td>
    <td width="65%"><%=rs1("total1") %></td>
    <td width="17%"><font color="#FF0000">￥: <%=rs1("money") %></font></td>
  </tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
  <tr> 
    <td width="18%">开票人： </td>
    <td width="82%"><%=rs1("kaipiaoren") %></td>
  </tr>
</table>
<table width="10%" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div align="center"><a href="javascript:window.print()"><img src="../image/printicon.gif" width="18" height="18">打印发票</a></div></td>
  </tr>
</table>
</body>
</html>