📄 payment.asp
字号:
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
case "ok"
'/////////////////////////////////////////////////
function HTMLEncode2(fString)
fString = Replace(fString, CHR(13), "")
fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
fString = Replace(fString, CHR(10), "<BR>")
HTMLEncode2 = fString
end function
'修改用户的送货信息
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [wq_user] where username='"&request.cookies("cnhww")("username")&"'",conn,1,3
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("sex")=trim(request("shousex"))
rs("useremail")=trim(request("useremail"))
rs("shouhuodizhi")=trim(request("shouhuodizhi"))
rs("youbian")=trim(request("youbian"))
rs("usertel")=trim(request("usertel"))
rs("songhuofangshi")=trim(request("songhuofangshi"))
rs("zhifufangshi")=trim(request("zhifufangshi"))
rs.update
rs.close
set rs=nothing
if session("xiadan")<>minute(now) then
'再判断库存
'未写
dim shijian,dingdan
shijian=now()
'dingdan=year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)&second(shijian)
'response.write bookid
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from wq_action where username='"&request.cookies("cnhww")("username")&"' and zhuangtai=7",conn,1,3
dingdan=year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)&second(shijian)
do while not rs.eof
'得到价格，减库存
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from wq_books where bookid="&rs("bookid"),conn,1,3
if request.Cookies("cnhww")("reglx")=2 then
danjia=rs2("vipjia")
else
danjia=rs2("huiyuanjia")
end if
rs2("chengjiaocount")=rs2("chengjiaocount")+rs("bookcount")
rs2("kucun")=rs2("kucun")-rs("bookcount")
rs2.update
rs2.close
set rs2=nothing
'rs.addnew
'rs("username")=trim(request.cookies("bookshop")("username"))
'rs("bookid")=rs2("bookid")
rs("actiondate")=shijian
'rs("bookcount")=CInt(Request("cnhww"&rs2("bookid")))
if request("zhifufangshi")=7 then '送货上门或预存款支付，直接改为订单完成（已收到款）
rs("zhuangtai")=3
else
rs("zhuangtai")=1
end if
rs("dingdan")=dingdan
rs("youbian")=int(request("youbian"))
rs("shouhuoname")=trim(request("userzhenshiname"))
rs("shouhuodizhi")=trim(request("shouhuodizhi"))
rs("zhifufangshi")=int(request("zhifufangshi"))
rs("songhuofangshi")=int(request("songhuofangshi"))
rs("shousex")=int(request("shousex"))
rs("liuyan")=HTMLEncode2(trim(request("liuyan")))
'rs("zonger")=request("zongji")
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("useremail")=trim(request("useremail"))
rs("usertel")=trim(request("usertel"))
rs("userid")=request("userid")
'新增
if request("fapiao")<>1 then
fapiao=0
else
fapiao=1
end if
rs("fapiao")=fapiao
rs("feiyong")=request("feiyong")
rs("danjia")=danjia
rs.update
'rs.close
'set rs=nothing
'conn.execute "delete from wq_action where username='"&request.cookies("bookshop")("username")&"' and bookid in ("&bookid&") and zhuangtai=6"
rs.movenext
loop
rs.close
set rs=nothing
'再改奖品
z_point=0
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from wq_action_jp where username='"&request.cookies("cnhww")("username")&"' and zhuangtai=7",conn,1,3
do while not rs.eof
rs("actiondate")=shijian
rs("zhuangtai")=5
rs("dingdan")=dingdan
rs("userid")=request("userid")
z_point=z_point+rs("point")
rs.update
rs.movenext
loop
rs.close
set rs=nothing
'减去积分
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [wq_user] where username='"&request.cookies("cnhww")("username")&"'",conn,1,3
rs("point")=rs("point")-z_point
'如果是预付款支付，要扣预存款
if request("zhifufangshi")=7 then
rs("yucun")=rs("yucun")-request("feiyong")-request("zongji")
end if
rs.update
rs.close
set rs=nothing
session("xiadan")=minute(now)
else
response.Write "<center>您不能重复提交！</center>"
response.End
end if
call sendmailuser()
%>
<table width="96%" border="0" cellspacing="0" cellpadding="1" align="center">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
<tr>
<td class="12v" >
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFCC00">
<tr>
<td height="23" bgcolor="FFF9E6">
<div align="center"><font color="#FF6600"><b>您的订单已经成功提交，我们会在第一时间进行处理，请记清您的订单号以备查询。</b></font></div>
</td>
</tr>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>订单号：<font color=red><%=dingdan%></font></td>
</tr>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>订单查询：您可通过“<a href="javascript:;" onclick="javascript:window.open('user.asp?action=myinfo','','')">用户中心</a>”>>“<a href="javascript:;" onclick="javascript:window.open('user.asp?action=myorder','','')">我的订单</a>”查询您的订单处理情况。</td>
</tr>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>关于积分：请收到商品后通过“<a href="javascript:;" onclick="javascript:window.open('user.asp?action=myinfo','','')">用户中心</a>”>>“<a href="javascript:;" onclick="javascript:window.open('user.asp?action=myorder','','')">我的订单</a>”及时更改您的订单状态为“完成”，因为每笔订单的积分只有在订单完成后才能累计到您的购物积分中。
</td>
</tr>
<%if request("zhifufangshi")=7 then %>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>您是通过预存款支付的，我们会尽快地给你发货的！</td>
<script language=javascript>alert('您是通过预存款支付的，我们会尽快地给你发货的！');</script>
</tr>
<%else
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from wq_songhuo where songid="&trim(request("zhifufangshi")),conn,1,1
if trim(rs("subject"))="货到付款" then
rs.close
set rs=nothing%>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>您是选择的“货到付款”，我们会尽快给您送货的！</td>
<script language=javascript>alert('您是选择的“货到付款”，请确认您的订单，我们会尽快给您送货的！');</script>
</tr>
<%else
rs.close
set rs=nothing%>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>请您在一周内依照您选择的支付方式进行汇款，汇款时请注明您的<font color="#FF0000">订单号</font>或通过我们公布的联系方式通知我们您的<font color="#FF0000">订单号</font>！</td>
<script language=javascript>alert('请您在一周内依照您选择的支付方式进行汇款，汇款时请注明您的订单号！');</script>
</tr>
<%end if%>
<%end if%>
<tr>
<td height="22" bgcolor="FFF9E6" style='PADDING-LEFT: 100px'>
<div align="right"><a href="#" onClick=javascript:window.close()>
关闭窗口</a><font color="#999999"> 订单完成
创建时间：<%=shijian%> </font></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
sub sendmailuser()
'发送邮件
set rs=server.CreateObject("adodb.recordset")
rs.Open "select mailaddress,mailusername,mailuserpass,mailname,mailsend from wq_config",conn,1,1
mailaddress=rs("mailaddress")
mailusername=rs("mailusername")
mailuserpass=rs("mailuserpass")
mailname=rs("mailname")
mailsend=rs("mailsend")
rs.close
set rs=nothing
on error resume next
topic="您在" & webname & "的订单信息"
'getpass=trim(request("userpassword"))
mailbody="<html>"
mailbody=mailbody & "<title>订单信息</title>"
mailbody=mailbody & "<body>"
mailbody=mailbody & "<TABLE border=0 width='95%' align=center><TBODY><TR>"
mailbody=mailbody & "<TD valign=middle align=top>"
mailbody=mailbody & trim(request.cookies("cnhww")("username"))&"，您好：<br><br>"
mailbody=mailbody & "欢迎您选购" & webname & "网上商城的商品，我们将提供给您最好的服务！<br>"
mailbody=mailbody & "下面是您在" & webname & "网上商城的订单信息：<br><br>"
mailbody=mailbody & "订单号："&dingdan&"<br>"
mailbody=mailbody & "请您及时按照网站公布的汇款方式付款,以及时为您发货!<br>"
mailbody=mailbody & "<br><br>"
mailbody=mailbody & "<center><font color=red>再次感谢您选购" & webname & "网上商城的商品！</font>"
mailbody=mailbody & "</TD></TR></TBODY></TABLE><br><hr width=95% size=1>"
mailbody=mailbody & "</body>"
mailbody=mailbody & "</html>"
Set JMail=Server.CreateObject("JMail.Message")
JMail.Charset="gb2312"
JMail.ContentType = "text/html"
jmail.from = mailsend
jmail.silent = true
jmail.Logging = true
jmail.FromName = mailname
jmail.mailserverusername = mailusername
jmail.mailserverpassword = mailuserpass
jmail.AddRecipient trim(request("useremail"))
jmail.body=mailbody
JMail.Subject=topic
if not jmail.Send ( mailaddress ) then
SendMail=""
else
SendMail="OK"
end if
end sub
end select
%>
</body>
</html>
<script language=javascript>
<!--
function regInput(obj, reg, inputStr)
{
var docSel = document.selection.createRange()
if (docSel.parentElement().tagName != "INPUT") return false
oSel = docSel.duplicate()
oSel.text = ""
var srcRange = obj.createTextRange()
oSel.setEndPoint("StartToStart", srcRange)
var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
return reg.test(str)
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
//-->
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -