📄 sys_showbb.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")
sql="select * from adminuser where username='"& username &"' and id=" & id &""
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<html>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_callJS(jsStr) { //v2.0
return eval(jsStr)
}
//-->
</script>
<body style="background-color: #D6DFF7">
<% if request.QueryString("cmd")="" then %>
<br>
<br>
<div align="center">
<center>
<table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
<form name="form1" method="post" action="sys_showbb.asp?cmd=search">
<tr>
<td bordercolor="#FFFFFF"><div align="center">
<p class="f1">查询从：
<select name="years" id="years">
<option value="2002" selected>2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
</select>
-
<select name="math" id="math">
<option value="1" selected>01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
-
<select name="days" id="days">
<option value="1" selected>01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
到
<select name="years1" id="years1">
<option value="2002" selected>2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
</select>
-
<select name="math1" id="select2">
<option value="1" selected>01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
-
<select name="days1" id="select3">
<option value="1" selected>01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
的
<select name="typ" id="typ">
<option value="收入" selected>收入</option>
<option value="支出">支出</option>
</select>
报表 <br>
<br>
<input type="submit" name="Submit" value="查询">
</p>
</div></td>
</tr>
</form>
</table>
</center>
</div>
<% end if %>
<%
if request.querystring("cmd")="search" then
years=request.form("years")
math=request.form("math")
days=request.form("days")
years1=request.form("years1")
math1=request.form("math1")
days1=request.form("days1")
typ=request.form("typ")
gan="-"
keyword=years&gan&math&gan&days
keyword1=years1&gan&math1&gan&days1
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from sys_moneyaction where date between #"&keyword&"# and #"&keyword1&"# and actions='"&typ&"'"
rs.open sql,conn,3,3
if rs.eof then
response.write"<div align=center>没 有 您 要 查 询 的 项 目 存 在</div>"
else
%>
<div align="center">
<center>
<table width="90%" border="0" cellspacing="0" cellpadding="3" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td><div align="center">从 <span class="f1"><%=keyword%></span> 到 <span class="f1"><%=keyword1%></span> 的 <span class="f1"><%=typ%></span> 报表如下：</div></td>
<td width="20%"><div align="center">
<input name="Submit2" type="submit" onClick="MM_callJS('javescript:window.print()')" value="打印报表">
</div></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" cellpadding="5" cellspacing="0" bgcolor="#f1f1f1">
<tr>
<td width="10%" class="f1" bgcolor="#EAF1FB">序 号</td>
<td width="15%" class="f1" bgcolor="#EAF1FB">会 员</td>
<td width="15%" class="f1" bgcolor="#EAF1FB">金 额</td>
<td width="15%" class="f1" bgcolor="#EAF1FB">日 期</td>
<td class="f1" bgcolor="#EAF1FB">备 注</td>
</tr>
</table>
<% a=0
do while not rs.eof
a=a+1
%> <table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="10%" height="26"><%=a%></td>
<td width="15%"><%=rs("member_name")%></td>
<td width="15%">￥<span class="f1"><%=rs("savemoney")%></span></td>
<td width="15%"><%=rs("date")%></td>
<td><%=rs("note")%></td>
</tr>
</table>
<% rs.movenext
loop
end if
%> </td>
</tr>
</table>
</center>
</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 + -