📄 searchb.asp
字号:
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<title></title>
<script language=javascript>
function onload(){ //this function to adjust the date time when load
var curdate=new Date();
// alert ("onload body!");
document.forms["quary"].fmonth.value=curdate.getMonth()+1;
// alert(curdate.getMonth());
document.forms["quary"].fday.value=curdate.getDate();
document.forms["quary"].tmonth.value=curdate.getMonth()+1;
document.forms["quary"].tday.value=curdate.getDate();
}
function check(){
if (document.forms["quary"].city.value=="其它" && document.forms["quary"].ocity.value==""){
alert("请输入城市名称。");
document.forms["quary"].ocity.focus()
return false;
}
}
</script>
<link rel="stylesheet" href="../html/3508.css">
<style type="text/css">
<!--
.botton { color: #000000; font-size: 12px; background-color: #FFFFEC}
-->
</style>
</head>
<body onload="return onload()" background="../images/bg1.gif">
<object runat=server progid=ADODB.Connection id=con1>
</object> <object runat=server progid=ADODB.recordset id=rs>
</object>
<table width="740" border="0" cellspacing="0" cellpadding="0" align="center" height="40">
<tr>
<td width="217" height="39" align="center" valign="bottom"><img src="../images/smallmark.gif" width="120" height="25"></td>
<td width="523" valign="bottom" height="39"><a href="../default.asp">本站首页</a>
>> 浏览二手信息</td>
</tr>
<tr>
<td colspan="2" height="1" bgcolor="006600"></td>
</tr>
</table>
<form method="post" action="quary.asp" name="quary" onsubmit="return check()" >
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="2" height="15"> </td>
<td width="460" height="15" align="right" valign="top"> </td>
<td width="244" height="15" valign="top" align="right">【<a href="selcat.asp?itype=供" >登记销售信息</a>】【<a href="selcat.asp?itype=%C7%F3" >登记购买信息】</a></td>
</tr>
<tr>
<td height="6" align="right" colspan="2" nowrap>请选择日期范围：</td>
<td height="6" colspan="2">
<table border="0" cellspacing="0" cellpadding="0" width="531">
<tr valign="top">
<td width="248">从
<input type=text name=fyear value=2000 class="botton" size="6">
年
<select name=fmonth class="botton">
<% for i=1 to 12 %>
<option value=<% =i%>> <% =i %> </option>
<%next%>
</select>
月
<select name=fday class="botton">
<% for i=1 to 31 %>
<option value=<% =i %>> <% =i%> </option>
<%next%>
</select>
日</td>
<td width="283"><input type=text name=tyear value=2000 class="botton" size="6">
年
<select name=tmonth class="botton">
<% for i=1 to 12 %>
<option value=<% =i%>> <% =i %> </option>
<%next%>
</select>
月
<select name=tday class="botton">
<% for i=1 to 31 %>
<option value=<% =i %>> <% =i%> </option>
<%next%>
</select>
日</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="4" align="left" valign="top" height="2166" rowspan="2" width="712">
<table width="75%" border="0" cellspacing="0" cellpadding="0" align="left">
<tr>
<td height="323" colspan="2">
<table cellspacing=0 cellpadding=0 width="586" align="left" border="0" >
<tr>
<td colspan="6" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="left">
<tr align="left">
<td colspan="5" height="23">请选择城市： </td>
<td width="68%" height="23">
<select name=city class="botton" >
<%
'response.write(application("DBCon_ConnectionString"))
con1.open application("DBCon_ConnectionString")
sqlstr="select * from city"
rs.open sqlstr,con1
if not (rs.eof) then
%>
<option value=所有 selected>所有 <%
while not (rs.eof)
%>
<option value = <%=rs("cname")%>><%=rs("cname")%>
<%rs.movenext
wend
end if
%>
</select>
</td>
</tr>
<tr align="left">
<td colspan="5">或输入你所要查询的城市：</td>
<td width="68%">
<input type=text name=ocity class="botton" >
</td>
</tr>
<tr align="left">
<td colspan="6">选定查询类别：</td>
</tr>
<tr align="left">
<td colspan="6" height="21">
<p>
<input type="radio" name=radio1 value=0000000000 checked>
所有
<input type="radio" name=radio1 value=0010000000 >
计算机产品
<input type="radio" name=radio1 value=0020000000>
车类
<input type="radio" name=radio1 value=0030000000>
家用电器
<input type="radio" name=radio1 value=0040000000>
房屋租售 </p>
</td>
</tr>
<tr align="left">
<td colspan="6">
<input type="radio" name=radio1 value=0050000000>
通讯器材
<input type="radio" name=radio1 value=0060000000>
书籍报刊
<input type="radio" name="radio1" value="0060000000">
服务</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="6" bgcolor="#FFFFE0">电脑产品</td>
</tr>
<tr>
<td width="54"> </td>
<td colspan="5">硬件 </td>
</tr>
<tr>
<td width="54" > </td>
<td width="106">
<input value=0010010011 type=radio name=radio1>
台式机</td>
<td width="114">
<input value=0010010012 type=radio name=radio1>
笔记本</td>
<td width="101">
<input value=0010010013 type=radio name=radio1>
服务器</td>
<td width="100">
<input value=0010010014 type=radio name=radio1>
工作站</td>
<td width="105">
<input value=0010010015 type=radio name=radio1>
打印机</td>
</tr>
<tr>
<td width="54" > </td>
<td width="106">
<input value=0010010001 type=radio name=radio1>
主板</td>
<td width="114">
<input value=0010010002 type=radio name=radio1>
内存</td>
<td width="101">
<input value=0010010003 type=radio name=radio1>
CPU</td>
<td width="100">
<input value=0010010004 type=radio name=radio1>
硬盘</td>
<td width="105">
<input value=0010010005 type=radio name=radio1>
光驱</td>
</tr>
<tr>
<td width="54" > </td>
<td width="106">
<input value=0010010006 type=radio name=radio1>
显卡</td>
<td width="114">
<input value=0010010007 type=radio name=radio1>
声卡</td>
<td width="101">
<input value=0010010008 type=radio name=radio1>
显示器</td>
<td width="100">
<input value=0010010009 type=radio name=radio1>
机箱</td>
<td width="105">
<input value=0010010010 type=radio name=radio1>
软驱</td>
</tr>
<tr>
<td height="22" width="54" > </td>
<td height="22" width="106">
<input value=0010010016 type=radio name=radio1>
耗材</td>
<td height="22" width="114">
<input value=0010010017 type=radio name=radio1>
存储介质</td>
<td height="22" width="101">
<input value=0010010018 type=radio name=radio1>
耳机、麦克</td>
<td height="22" width="100">
<input value=0010010019 type=radio name=radio1>
音箱</td>
<td height="22" width="105">
<input value=0010010020 type=radio name=radio1>
网络设备</td>
</tr>
<tr>
<td height="22" width="54" > </td>
<td height="22" width="106">
<input type="radio" name="radio1" value="0010010021">
其它 </td>
<td height="22" width="114"> </td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -