📄 my_db.asp
字号:
<% if not session("sel") then
Response.redirect "usdl.asp"
end if
%>
<%
if IsNumeric(request("bh")) AND request("bh")<>"" then
%>
<!--#include file="conn.asp" -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE><%=page_name%> – <%=page_title%></TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="images/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
</HEAD>
<BODY leftMargin=0 background=images/bg.jpg topMargin=0 marginheight="0"
marginwidth="0">
<!--#include file="head.asp" -->
<TABLE height=288 cellSpacing=0 cellPadding=0 width=760 align=center
bgColor=#ffffff border=0>
<TBODY>
<TR>
<TD width=171 height=288 vAlign=top background="images/bg_l_n.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><img src="images/domain_image.gif" width="174" height="119"></div></td>
</tr>
<tr>
<td height="17" bgcolor="#EEEEEE"><div align="center">欢迎: <font color="#FF0000"><strong><%= session("us") %></strong></font> 光临</div></td>
</tr>
<tr>
<% us=session("us")
sql="select * from user where userid='"&us&"'"
rs.open sql,conn,1,1
zje1=rs("je")
%>
<td><p>您的账面存款：</p>
<p align="center"><font color="#FF0000">￥ <%= rs("je") %></font></p>
<p align="center">客户等级: <font color="#FF0000"><%= rs("sf") %>
<% rs.close %>
</font></p></td>
</tr>
<tr>
<td height="1" background="images/2.jpg"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">
<!--#include file="user_inc.asp" -->
</div></td>
</tr>
<tr>
<td><p></td>
</tr>
<tr>
<td height="1" background="images/2.jpg"></td>
</tr>
</table></TD>
<td height="288" valign="top"><table width="573" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="573"><img src="images/mameger.gif" width="437" height="43"></td>
</tr>
<tr>
<td><table width="95%" height="276" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<%
bh=request("bh")
if Trim(Request.QueryString("w"))="sf" then
sql="select * from shop where bh="&bh
rs.open sql,conn,2,3
jg1=rs("jg")
sf1=request("sf")
zsf=jg1*sf1
if zje1<zsf then
%>
<script language="VBScript" type="text/VBScript">
msgbox "对不起您账号上面的余额不足 请及时入账"
</script>
<%
else
zsl=rs("sl")+sf1
rs("sl")=zsl
rs.update
sql="update user set je="&zje1&"-"&zsf&" where userid=('"&session("us")&"')"
conn.execute(sql)
sql="update db_shop set sl="&zsl&" where userid=('"&session("us")&"')"
conn.execute(sql)
sql="insert into memo(userid,je,body,log,zje) values ('"&session("us")&"',"&-zsf&",'订单号:"&bh&"/数据库续费','续费',"&zje1&"-"&zsf&")"
conn.execute(sql)
%>
<script language="VBScript" type="text/VBScript">
msgbox "续费成功"
</script>
<%
end if
rs.close
end if
bh=request("bh")
sql="select * from db_shop where bh="&bh&"and userid='"&session("us")&"'"
rs.open sql,conn,1,1
if not rs.eof then
%>
<td width="20%">订单号：</td>
<td width="80%"><%= rs("bh") %> </td>
</tr>
<tr>
<td>产品名称：</td>
<td><%= rs("mc") %></td>
</tr>
<tr>
<td>用户名称：</td>
<td><%= rs("userid") %></td>
</tr>
<tr>
<td>绑定帐号：</td>
<td><%= rs("uname") %></td>
</tr>
<tr>
<td>帐号密码：</td>
<td><%= rs("upass") %></td>
</tr>
<tr>
<td>注册年限：</td>
<td><%= rs("sl") %></td>
</tr>
<% rs.close
sql="select * from shop where bh="&bh
rs.open sql,conn,1,1
%>
<tr>
<td>应支付金额：</td>
<td><%= rs("je") %></td>
</tr>
<tr>
<td>提交时间：</td>
<td><%= rs("dat") %></td>
</tr>
<tr>
<td>交费是否：</td>
<td><font color="#FF0000"><%= rs("jf") %></font></td>
</tr>
<tr>
<td>生效是否：</td>
<td><font color="#FF0000"><%= rs("sx") %></font></td>
</tr>
<tr bordercolor="#F5F5F5">
<td height="23"><font color="#990000"><strong>管理员答复：</strong></font></td>
<td><font color="#990000"><%= rs("msg") %></font></td>
</tr>
<tr>
<td height="64" colspan="2"><% if rs("sx") then %>
<form name="form2" method="post" action="my_db.asp?w=sf">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="23%" height="36"><strong><font color="#990000">对产品续费：</font></strong></td>
<td width="77%"><select name="sf" id="sf">
<option value="1" selected>1年</option>
<option value="2">2年</option>
<option value="3">3年</option>
<option value="5">5年</option>
<option value="10">10年</option>
</select>
<input name="bh" type="hidden" id="bh" value="<%=request("bh") %>">
</td>
</tr>
<tr>
<td height="25"> </td>
<td><p>
<input type="submit" name="Submit2" value="确定续费">
</p>
<p> </p>
<p><font color="#FF0000">注：在这里续费请确认您的账号上面有足够的余额。</font></p></td>
</tr>
</table>
</form>
<% end if %>
<% else
Response.Write("<p><p><b><td>对不起参数不正确</b>")
end if %>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td><a href="javascript:history.back(1)">返回上页 >>></a></td>
</tr>
</table></td>
</tr>
</table></td>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
<TBODY>
<TR>
<TD bgColor=#999999><IMG height=1 src="images/spacer.gif"
width=1></TD>
</TR>
</TBODY>
</TABLE>
<!--#include file="foot.asp" -->
<%conn.close
set conn= nothing
end if
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -