📄 smsloglook.asp
字号:
<%response.expires=0%>
<!--#include file="conn.asp"-->
<%
set conn=opendb("conn")
set rs=server.createobject("adodb.recordset")
sql="select * from companyinfotable"
rs.open sql,conn,1
if rs.eof or rs.bof then
conn.close
set conn=nothing
set rs=nothing
response.write("<script language=""javascript"">")
response.write("alert(""对不起，没有部门名称，请先添加部门名称！"");")
response.write("location.href='companymanager.asp';")
response.write("</script>")
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>手机短信日志查询</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body>
<p align="center"><b><font color="#FF0000" size="3">手机短信日志查询</font></b></p>
<form method="POST" action="lookresult.asp" name="form1">
<div align="center">
<center>
<table border="1" cellpadding="0" width="500" bordercolorlight="#C0C0C0" cellspacing="0" bordercolordark="#FFFFFF" height="153">
<tr>
<td height="25" width="84" align="center" bgcolor="#C0C0C0"><font color="#0000FF">查询方式</font></td>
<td height="25" width="306" align="center" bgcolor="#C0C0C0"><font color="#0000FF">查询条件</font></td>
<td height="25" width="102" align="center" bgcolor="#C0C0C0"><font color="#0000FF">与下一条件的关系</font></td>
</tr>
<tr>
<td height="51" width="84"><input type="checkbox" name="C1" value="ON">按日期查询</td>
<td height="51" width="306">开始日期：<select size="1" name="year1">
<option selected value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
</select>年<select size="1" name="month1">
<option selected value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>月<select size="1" name="day1">
<option selected value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</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>日<br>
<br>
结束日期：<select size="1" name="year2">
<option selected value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
</select>年<select size="1" name="month2">
<option selected value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>月<select size="1" name="day2">
<option selected value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</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>日
<%
nowdate=date()
nowyear=year(nowdate)
nowmonth=month(nowdate)
nowday=day(nowdate)
response.write("<script language=""javascript"">")
response.write("form1.year1.value="&chr(34)&nowyear&chr(34)&";")
response.write("form1.year2.value="&chr(34)&nowyear&chr(34)&";")
response.write("form1.month1.value="&chr(34)&nowmonth&chr(34)&";")
response.write("form1.month2.value="&chr(34)&nowmonth&chr(34)&";")
response.write("form1.day1.value="&chr(34)&nowday&chr(34)&";")
response.write("form1.day2.value="&chr(34)&nowday&chr(34)&";")
response.write("</script>")
%>
</td>
<td height="51" width="102"><input type="radio" value="and" name="R1" checked>与<input type="radio" value="or" name="R1">或</td>
</tr>
<tr>
<td height="23" width="84"><input type="checkbox" name="C2" value="ON">按部门查询</td>
<td height="23" width="306">部 门：<select size="1" name="company">
<%
do while not rs.eof
%>
<option value="<%=rs("companycode")%>"><%=rs("companycode")%></option>
<%
rs.movenext
loop
conn.close
set conn=nothing
set rs=nothing
%>
</select></td>
<td height="23" width="102"><input type="radio" value="and" name="R2" checked>与<input type="radio" value="or" name="R2">或</td>
</tr>
<tr>
<td height="23" width="84"><input type="checkbox" name="C3" value="ON">按用户查询</td>
<td height="23" width="306">用 户 名：<input type="text" name="username" size="20"></td>
<td height="23" width="102"> </td>
</tr>
</table>
</center>
</div>
<p align="center"><input type="submit" value="开始查询" name="findbtn"></p>
</form>
</body>
</html>
<html></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -