📄 jiaofei.asp
字号:
<!--#include file="conn.asp"-->
<%
dim rs
dim sql
userid=replace(trim(request("userid")),"'","")
password=replace(trim(Request("password")),"'","")
if session("userid")=""then
response.write"<script>alert('非法操作！');</Script>"
response.write"<script Language=Javascript>location.href = 'index.asp';</script>"
response.end
end if
%>
<HTML><HEAD><TITLE>网趣数字卡在线销售系统</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="images/css.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
.style4 {color: #0000FF}
.style7 {color: #6600FF}
.style8 {color: #000000}
-->
</style>
</HEAD>
<%
userid=session("userid")
set rs=server.createobject("adodb.recordset")
sql="select * from users where userid='"&userid&"' "
rs.open sql,conn,1,1%>
<body topmargin="0" leftmargin="0" bgcolor="#336699">
<%
userid=session("userid")
set rs1=server.createobject("adodb.recordset")
sql="select * from jf where name='"&userid&"'"
rs1.open sql,conn,1,1
if rs1.eof then
response.write"<script>alert('您还没有交费记录！');history.back();</Script>"
response.end
end if %>
<!--#include file="top.asp"-->
<TABLE cellSpacing=0 cellPadding=0 width=735 border=0 align=center>
<TR>
<TD vAlign=top width=196 bgcolor="#EDDEA0" align="center"> </TD>
<TD width=266 bgcolor="#FFFFFF"><img src="images/ico.gif" width="18" height="15"></TD>
<TD width=267 bgcolor="#FFFFFF" align="right"><img src="images/ico1.gif" width="18" height="15"></TD>
<TD vAlign=top width=6 align="center" bgcolor="#EDDEA0"> </TD>
</TR>
<TBODY>
<TR>
<TD vAlign=top width=196 bgcolor="#EDDEA0" align="center">
<table width="168" cellspacing="0" cellpadding="0">
<tr>
<td background="images/b_bg.gif">
<table cellspacing=0 cellpadding=0 width="100%" border=0 align=center>
<tr>
<td height=7 colspan="2"><img src="images/b_top.gif" width="168" height="7"></td>
</tr>
<tr align="center">
<td colspan="2"><img src="images/zx.gif" width="123" height="39"></td>
</tr>
<tbody>
<tr>
<td align=right height="20"> 用户名：</td>
<td height="20"><font color="#3333CC"><strong><%=rs("name")%></strong></font></td>
</tr>
<tr>
<td width="50%" align="right" height="20">用户ID：</td>
<td height="20"><font color=#999900><%=rs("id")%></font></td>
</tr>
<tr>
<td align="right" height="20">用户级别：</td>
<td height="20">
<%if rs("oklook")=0 then
oklook="未审核"
elseif rs("oklook")=1 then
oklook="普通会员"
elseif rs("oklook")=2 then
oklook="VIP会员"
end if
%>
<font color=green><%=oklook%></font></td>
</tr>
<tr>
<td align="right" height="20">帐户存款：</td>
<td height="20"><font color=#ff0000><%=rs("qian")%></font> 元</td>
</tr>
<tr>
<td align="center" colspan="2"> </td>
</tr>
<tr>
<td align="center" colspan="2" height="20">
<table width="132" cellspacing="0" cellpadding="0">
<tr>
<td height="24" background="images/jxinfo_button.gif" align="center">请注意帐号安全！</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" colspan="2"> </td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="cuser.asp" >商品列表</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="edit_info.asp" >修改资料</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="jiaofei.asp" >存款记录</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="mylog.asp?lb=<%=session("userid")%>" >购物记录</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="tousu.asp" >投诉意见</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="lianxi.asp" >联系我们</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="tongzhi.asp" >汇款通知</a>]</td>
</tr>
<tr>
<td colspan="2" align="center" height="20">[<a href="out.ASP">安全退出</a>]</td>
</tr>
<tr>
<td align="center" colspan="2"> </td>
</tr>
<tr>
<td colspan="2" align="center" height="20"><img src=images/wa1.gif></td>
</tr>
<tr>
<td height=8 colspan="2" background="images/dh_bottom.gif"></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td align="center" colspan="2"> </td>
</tr>
</table>
</TD>
<TD vAlign=top width=533 align="center" bgcolor="#FFFFFF" colspan="2">
<TABLE cellSpacing=0 cellPadding=0 width=513 border=0>
<TBODY>
<TR>
<TD width=533 height="30">当前位置：我的存款记录</TD>
</TR>
<TR>
<TD width="533"> <br>
<table border="0" cellpadding="0" cellspacing="1" width="500" align="center" bgcolor="#666666">
<tr bgcolor="#EDDEA0" align="center">
<td width="33%" height="25"> <font color="#BB5E00"><b>用户名</b></font></td>
<td width="33%" height="25"> <font color="#BB5E00"><b>交费金额</b></font></td>
<td width="34%" height="25"> <font color="#BB5E00"><b>交费时间</b></font></td>
</tr>
<%
shownum=10
totalrecord=rs1.recordcount
rs1.pagesize=shownum
maxpage=rs1.pagecount
requestpage=clng(request.querystring("page"))
if requestpage="" or requestpage=0 then
requestpage=1
end if
if resquestpage>maxpage then
resquestpage=maxpage
end if
if not requestpage=1 then
rs1.move (requestpage-1)*rs1.pagesize
end if
for i=1 to rs1.pagesize and not rs1.bof%>
<tr bgcolor="#FFFFFF" align="center">
<td width="33%" height="25"> <%=rs1("name")%> </td>
<td width="33%" height="25"> <%=rs1("qian")%> 元</td>
<td width="34%" height="25"> <%=rs1("riqi")%> </td>
</tr>
<%
rs1.movenext
if rs1.eof then exit for
next
%>
<tr bgcolor="#FFFFFF" align="center">
<td colspan="3" height="25">
<%
if requestpage-1 mod 10=0 then
p=(requestpage-1) \ 10
else
p=(requestpage-1) \ 10
end if
if requestpage=1 then
response.write " <font face=webdings color=""#FF0000"">9</font> "
else
response.write " <a href=jiaofei.asp?name="&userid&"&page=1 title=首页> <font face=webdings>9</font></a> "
end if
if p*10>0 then response.write " <a href=jiaofei.asp?name="&userid&"&page="&p*10&" title=上十页> <font face=webdings>7</font></a> "
response.write "<b>"
for ii=p*10+1 to P*10+10
if ii=requestpage then
response.write " <font color=""#FF0000"">"&ii&"</font> "
else
response.write " <a href=jiaofei.asp?name="&userid&"&page="&ii&">"&ii&"</a> "
end if
if ii=maxpage then exit for
next
response.write "</b>"
if ii<maxpage then response.write " <a href=jiaofei.asp?name="&userid&"&page="&ii&" title=下十页> <font face=webdings>8</font></a> "
if requestpage=maxpage then
response.write " <font face=webdings color=""#FF0000"">:</font> "
else
response.write " <a href=jiaofei.asp?name="&userid&"&page="&maxpage&" title=尾页> <font face=webdings>:</font></a>"
end if
response.write" 总共有 "&maxpage&" 页 共 "&totalrecord&" 条信息"
%>
</td>
</tr>
</table>
</TD>
</TR>
</TBODY>
</TABLE>
<br>
<br>
</TD>
<TD vAlign=top width=6 align="center" bgcolor="#EDDEA0"> </TD>
</TR>
<TR>
<TD vAlign=top width=196 bgcolor="#EDDEA0" align="center"> </TD>
<TD width=266 bgcolor="#FFFFFF"><img src="images/ico_l.gif" width="18" height="15"></TD>
<TD width=267 bgcolor="#FFFFFF" align="right"><img src="images/ico_r.gif" width="18" height="15"></TD>
<TD vAlign=top width=6 align="center" bgcolor="#EDDEA0"> </TD>
</TR>
</TBODY>
</TABLE>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<!--#include file="bott.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -