📄 save.asp
字号:
<!--#include file="conn.asp"-->
<%
'记得数据类型一定要相对,字符型在两连加单引号,如果是数字型的就没有
Conn.Execute("Update tuyun Set area = '"& Request.Form("cc") &"'," _
& "number3 = '"& Request.Form("qq") &"',price="& request.form("mm") &"," _
& "price1="&request.form("mm1")&",price2="& request.form("mm2") &"," _
& "price3="&request.form("mm3")&",number4='"& request.form("rr") &"',"_
& "number5='"&request.form("rr1")&"',number6='"&request.form("rr2")&"',"_
& "number7='"&request.form("rr3")&"',"_
& "number8='"&request.form("rr4")&"',number9='"&request.form("rr5")&"',"_
&"number10='"&request.form("rr6")&"',number11='"&request.form("rr7")&"',"_
&"number12='"&request.form("rr8")&"',number13='"& request.form("rr9")&"',"_
&"number14='"&request.form("rr10")&"',number15='"&request.form("rr11")&"' Where ID ="& Request("ID") &" ")
%>
<%
set rs1=server.CreateObject("adodb.recordset")
set rs1=conn.execute("Select * from tuyun Where number4='"&request.form("rr")&"'")
' sql="select * from tuyun where number3="&request.form("qq")&" order by id asc "
' rs1.open sql,conn,3,3
%>
<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>
<div id="Layer2" style="position:absolute; width:183px; height:26px; z-index:2; left: 385px; top: 578px;"><%=rs1("year")%> <%=rs1("month")%> <%=rs1("date1")%></div>
<div id="Layer3" style="position:absolute; width:210px; height:23px; z-index:3; left: 151px; top: 220px;"><%=rs1("accept_people")%></div>
<div id="Layer3" style="position:absolute; width:200px; height:23px; z-index:3; left: 152px; top: 192px;"><%=rs1("send_address") %></div>
<div id="Layer4" style="position:absolute; width:75px; height:106px; z-index:4; left: 125px; top: 294px;"> <%=rs1("goods")%><br>
<br>
<%=rs1("goods1")%><br>
<br>
<%=rs1("goods2")%></div>
<div id="Layer5" style="position:absolute; width:50px; height:109px; z-index:5; left: 281px; top: 296px;"> <%=rs1("box")%><br>
<br>
<%=rs1("box1")%><br>
<br>
<%=rs1("box2")%><br>
</div>
<div id="Layer5" style="position:absolute; width:65px; height:109px; z-index:5; left: 215px; top: 292px;">
<p><%=rs1("num")%> <br>
<br>
<%=rs1("num1")%><br>
<br>
<%=rs1("num2")%></p>
<p><br>
<%=rs1("num3")%> </p>
</div>
<div id="Layer5" style="position:absolute; width:53px; height:159px; z-index:5; left: 418px; top: 292px;">
<p><%=rs1("kg")%><Br>
<br>
<%=rs1("kg1")%><br>
<br>
<%=rs1("kg2")%></p>
<p><br>
<%=rs1("kg3")%><br>
</p>
</div>
<p> </p>
<div id="Layer3" style="position:absolute; width:202px; height:23px; z-index:3; left: 152px; top: 164px;"><%=rs1("send_people")%></div>
<div id="Layer3" style="position:absolute; width:200px; height:23px; z-index:3; left: 150px; top: 247px;"><%=rs1("accept_address") %></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 396px; top: 192px;"><%=rs1("send_tel")%></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 396px; top: 243px;"><%=rs1("accept_tel")%></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 341px; top: 108px;"><%=rs1("send_last")%></div>
<div id="Layer8" style="position:absolute; width:257px; height:50px; z-index:8; left: 607px; top: 241px;"><%=rs1("number4")%> <%=rs1("number5")%> <%=rs1("number6")%> <%=rs1("number7")%> <%=rs1("number8")%> <%=rs1("number9")%> <%=rs1("number10")%> <%=rs1("number11")%> <%=rs1("number12")%> <br>
<%=rs1("number13")%> <%=rs1("number14")%> <%=rs1("number15")%></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 127px; top: 108px;"><%=rs1("send_first")%></div>
<p> </p>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 607px; top: 130px;"><%=rs1("number3")%></div>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer5" style="position:absolute; width:65px; height:109px; z-index:5; left: 341px; top: 297px;">
<p><%=rs1("price")%><br>
<br>
<%=rs1("price1")%><br>
<br>
<%=rs1("price2")%></p>
<p><br>
<%=rs1("price3")%></p>
</div>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer8" style="position:absolute; width:234px; height:24px; z-index:8; left: 218px; top: 137px;"><%=rs1("area")%></div>
<div id="Layer8" style="position:absolute; width:118px; height:24px; z-index:8; left: 264px; top: 480px;"><%=rs1("baoxian")%></div>
<p> </p>
<div id="Layer8" style="position:absolute; width:125px; height:32px; z-index:8; left: 306px; top: 12px;"><%=rs1("number")%></div>
<div id="Layer10" style="position:absolute; width:74px; height:21px; z-index:10; left: 434px; top: 22px;">
<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 + -