saveto.asp
来自「ASP+ACCESS 产品报价系统 开发环境简单 主要是周杰伦FANs的交互活动」· ASP 代码 · 共 191 行
ASP
191 行
<!--#include file="conn.asp"-->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>购物成功！</title>
<link href=css.css rel=STYLESHEET type=text/css>
</head>
<body leftmargin="0" topmargin="0" marginwidth="00" marginheight="0">
<%
if session("user_name")="" then
response.write "<br>"
response.write "<center>"
response.write "1.你尚未登录!请登录后再订购本站商品!"
response.write "<br>2.第一次来本站，请先注册会员（免费）!"
response.write "<br>"
response.write "<br>"
response.end
end if
dim sql,rs
set rs=server.createobject("adodb.recordset")
if request("action")="buy" then
if request("count")="" then
count=1
else
count=request("count")
end if
if request("hw_id")="" then
response.write "没有此货物!"
else
hw_id=request("hw_id")
end if
sql="select * from basket where hw_id='"&hw_id&"' and user_name='"&session("user_name")&"' and basket_check=false"
rs.open sql,conn,3,3
if rs.eof then
rs.addnew
rs("hw_id")=hw_id
rs("user_name")=session("user_name")
rs("basket_count")=count
rs("basket_date")=now()
rs("hw_name")=request("hw_name")
rs("hw_cash")=request("hw_cash")
else
rs("basket_count")=int(rs("basket_count"))+int(count)
end if
rs.update
rs.close
%>
<%end if%>
<br>
<tr>
<td valign="top">
<tr>
<td valign="top" height="120">
<table width="371" height="5" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
<tr>
<td height="18">
<div align="center">
<TABLE width=380 height="25" border=0
align=center cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD align=middle bgcolor="#fff2d5" height="22">
<%
if request("sub_number")="" then
response.write "没有此订单信息"
else
sub_to=request("sub_to")
sub_adds=request("sub_adds")
sub_mail=request("sub_mail")
sub_tel=request("sub_tel")
sub_post=request("sub_post")
sub_number=request("sub_number")
qian=request("qian")
other=request("other")
sql="select * from sub where sub_number='"&sub_number&"'"
rs.open sql,conn,3,3
rs("sub_to")=sub_to
rs("sub_tel")=sub_tel
rs("sub_post")=sub_post
rs("sub_mail")=sub_mail
rs("sub_adds")=sub_adds
rs("qian")=qian
rs("other")=other
rs.update
rs.close
%>
<b><font color="#990000">购物成功！ 您的订单号是：</font><%=sub_number%></b> </TD>
</TR>
</TBODY>
</TABLE>
</div>
</td>
</tr>
<tr>
<td>
<table width="100%" height="34" border="0" cellpadding="0" cellspacing="0">
<td width="398" height="120" valign="bottom" bgcolor="f7f7f7" ><br>
<font color="#990000">请记牢本订单号，你可以使用本订单号对成交情况进行查询和投诉</font><br> <br>
<div align="center">
<center>
<table width="91%" border="0" cellpadding="0" cellspacing="1" bordercolor="#111111" bgcolor="#CCCCCC" style="border-collapse: collapse">
<tr bgcolor="#FFFFFF">
<td width="26%" height="25">
<div align="right">收货人：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=sub_to%> </div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="26%" height="25">
<div align="right">地址：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=sub_adds%> </div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="26%" height="25">
<div align="right">邮编：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=sub_post%> </div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="26%" height="25">
<div align="right">电话：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=sub_tel%> </div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="26%" height="25">
<div align="right">E-mail：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=sub_mail%> </div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="26%" height="12">
<div align="right">付款方式：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=qian%> </div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="26%" height="12">
<div align="right">备注：</div>
</td>
<td width="74%" height="25">
<div align="center"><%=other%></div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="21" colspan="2">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<p style="word-spacing: 2; line-height: 150%; margin-top: 4; margin-bottom: 6">
<font color="#FF9900"> <font color="#FF3300"> 1.谢谢您在本站购物，如果您选择送货上门服务，请您放心，我们的工作人员会很快将商品送到府上。<br>
2.如果您选择银行转帐方式，请您尽快转帐，并在转帐成功后马上给我们打电话或来Email确认，最快只要1小时就给您发货！</font></font></td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align="center"><a href="javascript:history.go(-1)">返回修改收货人信息</a><br>
<br>
</div>
</td>
</tr>
</table> </td>
<%end if%>
</tr>
</table>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?