searchsc.asp
来自「国内第一数字点卡销售程序。功能强大。 完整无错!数据文件经MD5加密!经严格测」· ASP 代码 · 共 100 行
ASP
100 行
<%@language="vbscript" %>
<!--#include file="conn.asp"-->
<%
if session("admin_rank")<>1 and session("admin_rank")<>4 then
response.write("<script>alert('您无权查看本页,SORRY!');window.location=('login.asp')</script>")
response.end
end if
%>
<%set rs=server.createobject("adodb.recordset")
%>
<body style="background-color: #F0FBF1" topmargin="0">
<link rel="stylesheet" type="text/css" href="css.css">
<%
mm=month(date())
dd=day(date())
yy=year(date())
%>
<div align="center">
<table cellPadding="0" width="95%" border="1" bordercolorlight="#339933" cellspacing="0" bordercolordark="#F0FBF1" height="198">
<form name="AccountDetail" method="post" action="searchpasssave_sc.asp">
<tr>
<td height="39"> 卡名称: <select name="cardname">
<option></option>
<%sql="select * from hw"
rs.open sql,conn,3,3
do while not rs.eof%>
<option><%=rs("hw_name")%></option>
<%rs.movenext
loop
rs.close%>
</select> 注:不选择卡号,查询所有的上卡记录,选择卡,则查相应的上卡记录!</td>
</tr>
<tr>
<td noWrap height="39"> 日期从 <select name="YearFrom">
<%for i=2000 to 2050
if i=yy then%>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>"><%=i%></option>
<%end if
next%>
</select>年 <select name="MonthFrom">
<%for i=1 to 12
if i=mm then%>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>"><%=i%></option>
<%end if
next%>
</select>月 <select name="DayFrom">
<%for i=1 to 31
if i=dd then%>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>"><%=i%></option>
<%end if
next%>
</select>日 </td>
</tr>
<tr>
<td noWrap height="40"> 日期至 <select name="YearTo">
<%for i=2000 to 2050
if i=yy then%>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>"><%=i%></option>
<%end if
next%>
</select>年 <select name="MonthTo">
<%for i=1 to 12
if i=mm then%>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>"><%=i%></option>
<%end if
next%>
</select>月 <select name="DayTo">
<%for i=1 to 31
if i=dd then%>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>"><%=i%></option>
<%end if
next%>
</select>日
</td>
</tr>
<tr>
<td noWrap height="40">
<p align="center"> <input type="submit" value="查询" name="B1"></td>
</tr>
</form>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?