📄 member_balancedomain.asp
字号:
<!--#include file="conn.asp"-->
<%
id=session("userid")
username=session("username")
if id="" or username="" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
if session("usertyp")="企业" then
sql="select * from userentreg where login_name='"& username &"' and id=" & id &""
end if
if session("usertyp")="个人" then
sql="select * from userpersreg where login_name='"& username &"' and id=" & id &""
end if
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
username=session("username")
id=session("userid")
did=request.QueryString("id")
cmd=request.QueryString("cmd")
money=cint(request.QueryString("money"))
bolo="已结算"
%>
<html>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
<body style="font-size: 9pt">
<% if cmd="ok" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select savemoney from savemoney where user_name='"& username &"' and user_id=" & id &""
rs.open sql,conn,3,3
if rs.eof then
response.write"<div align=center class=f1>您的存款不足以结算此订单！</div>"
else
oldmoney=cint(rs("savemoney"))
if oldmoney >= money then
newmoney=cint(oldmoney-money)
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select savemoney from savemoney where user_name='"& username &"' and user_id=" & id &""
rs.open sql,conn,3,3
rs("savemoney")=newmoney
rs.update
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select bolo from domainshopping where id=" & did &""
rs.open sql,conn,3,3
rs("bolo")=bolo
rs.update
response.write"<div align=center class=f1>订单结算成功！</div>"
else
response.write"<div align=center class=f1>您的存款不足以结算此订单！</div>"
end if
end if
end if
if cmd="del" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from domainshopping where id=" & did &""
rs.open sql,conn,3,3
rs.delete
response.write"<div align=center class=f1>订单取消成功！</div>"
end if
%>
</body>
</html>
<%
end if
rs.close
set rs=nothing
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -