📄 member_uphostmoney.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
%>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../index.css" rel="stylesheet" type="text/css">
</head>
<body>
<span style="font-size: 9pt">
<%
id=request.form("id")
user_name=request.form("user_name")
usertyp=request.form("usertyp")
user_id=request.form("user_id")
years=request.form("years")
sales=request.form("sales")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from hostshopping where id="&id&""
rs.open sql,conn,3,3
money=cint(rs("hostonemoney"))
oldyears=cint(rs("years"))
newmoney=cint(money * years)
rs("money")=cint(newmoney+money)
rs("years")=cint(oldyears+years)
rs.update
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select savemoney from savemoney where user_name='"&user_name&"'"
rs.open sql,conn,3,3
if rs.eof then
response.Write("<div align=center class=f1>您还没有存款！</div>")
else
savemoney=cint(rs("savemoney"))
if savemoney=0 or savemoney < newmoney then
response.Write("<div align=center class=f1>您的存款金额不足！</div>")
else
newmoney2=cint(savemoney-newmoney)
rs("savemoney")=newmoney2
rs.update
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from member_uphostmoney"
rs.open sql,conn,3,3
rs.addnew
rs("user_name")=user_name
rs("usertyp")=usertyp
rs("hostid")=id
rs("years")=years
rs("money")=newmoney
rs("sales")=sales
rs("date")=date()
rs.update
response.Write("<div align=center class=f1><br><br>续 费 成 功！</div>")
end if
end if
%>
</span>
</body>
</html>
<%
end if
rs.close
set rs=nothing
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -