📄 cashsave.asp
字号:
<!--#include file="conn.asp"--><head>
<script language="JavaScript">
<!--
if (parent.frames.length > 0) {
parent.location.href = location.href;
}
function form1_onsubmit() {
if (document.form1.sub_to.value=="")
{
alert("Invalid name entered. Please try again.")
document.form1.sub_to.focus()
return false
}
else if(document.form1.sub_adds.value=="")
{
alert("Invalid address entered. Please try again.")
document.form1.sub_adds.focus()
return false
}
else if(document.form1.sub_post.value=="")
{
alert("Invalid zipcode entered. Please try again.")
document.form1.sub_post.focus()
return false
}
else if(document.form1.sub_tel.value=="")
{
alert("Invalid tel entered. Please try again.")
document.form1.sub_tel.focus()
return false
}
else if(document.form1.sub_mail.value=="")
{
alert("Invalid email entered. Please try again.")
document.form1.sub_mail.focus()
return false
}
}
// -->
</script>
<link href=img/css.css rel=STYLESHEET type=text/css>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<title>Order success！Please input you infomation:</title>
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0">
<font color="#FFFFFF"><b>
<%
if session("user_name")="" then
response.write "<br>"
response.write "<center>"
response.write "1.Already our member, Please Login First!"
response.write "<br>"
response.write "<br>2.New to our, If you want to login, you'll need to register first.<a href=reg.asp target=_blank><font color=#FF0000> register </font></a>!"
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 "the product is not found."
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")
rs("isbn")=request("isbn")
rs("user_type")=request("user_type")
else
rs("basket_count")=int(rs("basket_count"))+int(count)
end if
rs.update
rs.close
%>
</b></FONT>
<%end if%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td valign="top" height="120">
<div align="center">
<table border="0" width="400" cellspacing="0" cellpadding="0" height="5">
<%if session("user_name")="" then
response.redirect "index.asp"
else
user_name=session("user_name")
end if
sql="select * from basket where user_name='"&user_name&"' and basket_check=false"
rs.open sql,conn,3,3
if rs.eof then
response.write "No product in your cart."
response.end
else
on error resume next
sub_number=user_name&now()
sub_number=replace(sub_number,"-","")
sub_number=replace(sub_number," ","")
sub_number=replace(sub_number,":","")
do while not rs.eof
rs("basket_check")=true
rs("sub_number")=sub_number
hw_id=rs("hw_id")
sql1="select * from hw where hw_id="&int(hw_id)
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,3,3
rs1("hw_buys")=rs1("hw_buys")+rs("basket_count")
rs1.update
rs1.close
set rs1=nothing
rs.movenext
loop
rs.update
end if
rs.close
sql="select * from sub"
rs.open sql,conn,3,3
rs.addnew
rs("user_name")=user_name
rs("sub_number")=sub_number
rs.update
rs.close
%>
<tr>
<td>
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td height="17" bgcolor="#DBC2B0" align="center">
<font color="#F5EFE7"><b>Thank you ! Your order number:<%=sub_number%></b></font></td>
</tr>
<tr>
<td> <form method="POST" language="javascript" onsubmit="return form1_onsubmit()" name="form1" action="saveto.asp?sub_number=<%=sub_number%>">
<% dim sql2
sql2="select * from [user] where username='"&session("user_name")&"'"
rs.open sql2,conn,3,3
%><table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td><table width="100%" height="34" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="398" height="120" valign="bottom" bgcolor="#F5EFE7" >
<div align="center">
<center>
<table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" height="243">
<tr background="img/tile_bg.gif">
<td height="25" colspan="2"><b>Consignee information:</b></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="25" bgcolor="#F5EFE7">
<div align="right">Name:</div>
</td>
<td width="81%" height="25" bgcolor="#F5EFE7"><input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="sub_to" size="20" class=input value="<%=rs("username")%>">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="25" bgcolor="#F5EFE7">
<div align="right">Address:</div>
</td>
<td height="25" bgcolor="#F5EFE7"><input style="FONT-SIZE: 12px; WIDTH: 210px" type="text" name="sub_adds" size="40" class=input value="<%=rs("user_adds")%>">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="25" bgcolor="#F5EFE7">
<div align="right">Zip code:</div>
</td>
<td height="25" bgcolor="#F5EFE7"><input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="sub_post" size="10" class=input value="<%=rs("user_postcode")%>">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="25" bgcolor="#F5EFE7">
<div align="right">Phone number:</div>
</td>
<td height="25" bgcolor="#F5EFE7"><input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="sub_tel" size="20" class=input value="<%=rs("usertel")%>">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="25" bgcolor="#F5EFE7">
<div align="right">Email:</div>
</td>
<td height="25" bgcolor="#F5EFE7"><input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="sub_mail" size="20" class=input value="<%=rs("usermail")%>">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="19" bgcolor="#F5EFE7">
<div align="right">Payment:</div>
</td>
<td height="19" bgcolor="#F5EFE7"><select size="1" name="qian">
<option value="Cash on Delivery">Cash on Delivery</option>
<option value="Pay on line">Pay on line</option>
<option value="Bank Remittance">Bank Remittance</option>
<option value="Postal Remittance">Postal Remittance</option>
</select>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="39" bgcolor="#F5EFE7">
<div align="right">Other:<br>
(100 bytes) </div>
</td>
<td height="39" bgcolor="#F5EFE7"><textarea style="FONT-SIZE: 12px; WIDTH: 250px" name="other" cols="30" class="input" rows="3"></textarea>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="35" colspan="2" bgcolor="#F5EFE7">
<table width="40%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<div align="center">
<input
align=absMiddle alt=submit cache name="B1"
src="img/ok.gif" type=image tppabs="" width="45" height="20">
</div>
</td>
<td>
<div align="center">
<input type="reset" value="reset" name="B2" class=input>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div></td>
</tr>
</table> </td>
</tr>
</table>
<%
rs.close
%>
</form></td>
</tr>
</table></div>
</td>
</tr>
</table>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -