📄 search.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=DataBase/conn.asp-->
<%
selectd=request("select") '获取类别
xinghao=request("xinghao") '获取型号
pinpai=request("pinpai") '获取品牌
if xinghao="" and pinpai="" then '判断接收的值是否都为空
response.Write("<script language=javascript>alert('最少输入一个条件');location='javascript:history.go(-1)'</script>")
else
select case selectd
case "乘用车" '类别是乘用车时
if xinghao="" then '当型号为空时
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from tb_Cars_s where pinpai='"&pinpai&"' "
rs2.open sql2,conn,1,1
elseif pinpai="" then '当品牌为空时
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from tb_Cars_s where xinghao='"&xinghao&"'"
rs2.open sql2,conn,1,1
else
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from tb_Cars_s where pinpai='"&pinpai&"' and xinghao='"&xinghao&"'"
rs2.open sql2,conn,1,1
end if
case "商用车" '类别是商用车时
if xinghao="" then '当型号为空时
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from tb_Cars_sy where pinpai='"&pinpai&"' "
rs2.open sql2,conn,1,1
elseif pinpai="" then '当品牌为空时
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from tb_Cars_sy where xinghao='"&xinghao&"'"
rs2.open sql2,conn,1,1
else
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from tb_Cars_sy where pinpai='"&pinpai&"' and xinghao='"&xinghao&"'"
rs2.open sql2,conn,1,1
end if
end select
%>
<%
'展台中心
set rs1=server.CreateObject("adodb.recordset")
sql1="select * from tb_Cars_s order by id desc"
rs1.open sql1,conn,1,1
'新闻报道
set rs3=server.CreateObject("adodb.recordset")
sql3="select * from tb_News order by id desc"
rs3.open sql3,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>搜索车辆</title>
</head>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
body {
background-image: url(images/FFF.gif);
}
a:link {
color: #FFFFFF;
text-decoration: none;
}
a:visited {
color: #FFFFFF;
text-decoration: none;
}
a:hover {
color: #EAEAEA;
text-decoration: none;
}
a:active {
text-decoration: none;
}
a {
font-size: 12px;
}
body,td,th {
font-size: 12px;
}
.style2 {color: #000000}
-->
</style>
<link href="css/mangage.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style3 {color: #FFFFFF}
.style7 {color: #E30000}
-->
</style>
<body topmargin="0">
<table width="779" height="1201" border="0" align="center" cellpadding="0" cellspacing="0" id="__01">
<tr>
<td colspan="14"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="778" height="270">
<param name="movie" value="images/cars.swf">
<param name="quality" value="high">
<embed src="images/cars.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="778" height="270"></embed>
</object></td>
<td>
<img src="images/分隔符.gif" width="1" height="270" alt="" /></td>
</tr>
<tr>
<td colspan="3">
<img src="images/cars_02.gif" alt="" width="160" height="23" border="0" usemap="#Map" /></td>
<td colspan="3" bgcolor="#5C565B"><div align="center"><a href="zhantai.asp"><span class="style3">展台中心</span></div></td>
<td colspan="8" bgcolor="#4C1818"><table width="100%" border="0">
<tr>
<td><div align="center"><a href="dinggou.asp" ><span class="style3">订购中心</span></a></div></td>
<td><div align="center"><a href="zulin.asp"><span class="style3">租赁中心</span></a></div></td>
<td><div align="center"><a href="zhihuan.asp"><span class="style3">置换中心</span></a></div></td>
<td><div align="center"><a href="kefu.asp"><span class="style3">客服中心</span></a></div></td>
<td><div align="center"><a href="xinwen.asp"><span class="style3">新闻中心</span></a></div></td>
<td><div align="center"><a href="jituan.asp"><span class="style3">关于集团</span></a></div></td>
<td><div align="center"><a href="mailto:mingrisoft@mingrisoft.com "><span class="style3">联系我们</span></a></div></td>
</tr>
</table></td>
<td>
<img src="images/分隔符.gif" width="1" height="23" alt="" /></td>
</tr>
<tr>
<td colspan="12" rowspan="2">
<img src="images/cars_05.gif" width="579" height="50" alt="" /></td>
<td colspan="2">
<img src="images/zhongxindaohang.gif" width="199" height="36" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="36" alt="" /></td>
</tr>
<tr>
<td rowspan="5">
<img src="images/cars_07.gif" width="20" height="122" alt="" /></td>
<td rowspan="5" bgcolor="#C8C8C8">
<p align="center"> <a href="zhantai.asp"><span class="style2">乘 用 车</span></a></p>
<p align="center"><a href="zhantai1.asp"><span class="style2">商 用 车</span></a></p>
<p align="center"><a href="zhantai2.asp"><span class="style2">租 赁 车</span></a></p></td>
<td>
<img src="images/分隔符.gif" width="1" height="14" alt="" /></td>
</tr>
<tr>
<td colspan="12">
<img src="images/zhantai.gif" width="579" height="30" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="30" alt="" /></td>
</tr>
<tr>
<td rowspan="5"> </td>
<td colspan="11">
<img src="images/cars_11.gif" width="564" height="10" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="10" alt="" /></td>
</tr>
<tr>
<td colspan="11" rowspan="14" align="right" valign="top">
<%
shum=5
if not rs2.eof then
tel=rs2.recordcount
rs2.pagesize=shum
maxpage=rs2.pagecount
requestpage=clng(request("p"))
if requestpage="" or requestpage=0 then
requestpage=1
end if
if requestpage>maxpage then
requestpage=maxpage
end if
if not requestpage=1 then
rs2.move (requestpage-1)*rs2.pagesize
end if
for i=1 to rs2.pagesize and not rs2.eof
%>
<table width="90%" border="0" align="center" cellspacing="0" class="dibian">
<tr>
<td width="46%" height="45" rowspan="2" class="bottm"><div align="center"><%if selectd="商用车" then%><img src="Mangage/<%=rs2("jianjietupian")%>" width="140" height="105"><% Else %><img src="Mangage/<%=rs2("tupianjianjie")%>" width="140" height="105"><% End If %></div></td>
<td width="54%" height="18" class="bian">名称：<%=rs2("pinpai")%></td>
</tr>
<tr>
<td valign="top" class="bian"><br>
<%=rs2("wenzijianjie")%></td>
</tr>
<tr>
<td ><div align="center">参考价格：<%=rs2("shoujia")%>（万元）</div></td>
<td class="zuobian" ><div align="right">
<%if selectd="商用车" then%>
<a href="zhantaiopen1.asp?id=<%=rs2("id")%>">详细参数</a>
<% Else %>
<a href="zhantaiopen.asp?id=<%=rs2("id")%>">详细参数</a>
<% End If %>
<a href="javascript:" onClick="window.open('ydinggou.asp?name=<%=rs2("pinpai")%>','','width=500,height=600')">在线订购</a></div></td>
</tr>
</table>
<%
Rs2.MoveNext
if rs2.eof then exit for
next
Rs2.Close
Set Rs2=Nothing
else
response.Write("暂无车辆信息")
end if
%>
</p>
<table width="90%" border="0" align="center">
<tr>
<td align="right"><span class="css">共<%= maxpage %>页 当前页：<%= requestpage %></span>
<a href="search.asp?p=<%=requestpage-1%>&select=<%=selectd%>&xinghao=<%=xinghao%>&pinpai=<%=pinpai%>">上一页</a>
<a href="search.asp?p=<%=requestpage+1%>&select=<%=selectd%>&xinghao=<%=xinghao%>&pinpai=<%=pinpai%>">下一页</a></td>
</tr>
</table>
<p><span class="css"> </span> </p></td>
<td>
<img src="images/分隔符.gif" width="1" height="9" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="1" height="59" alt="" /></td>
</tr>
<tr>
<td colspan="2">
<img src="images/cars_20.gif" width="199" height="36" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="36" alt="" /></td>
</tr>
<tr>
<td rowspan="3">
<img src="images/cars_21.gif" width="20" height="112" alt="" /></td>
<td rowspan="3" bgcolor="#C8C8C8">
<table width="100%" border="0">
<form name="form1" method="post" action="search.asp">
<tr>
<td>品牌：</td>
<td><input name="pinpai" type="text" id="pinpai" size="15"></td>
</tr>
<tr>
<td>型号：</td>
<td><input name="xinghao" type="text" id="xinghao" size="15"></td>
</tr>
<tr>
<td>车类：</td>
<td><select name="select">
<option>乘用车</option>
<option>商用车</option>
</select></td>
</tr>
<tr align="center">
<td colspan="2"><input name="Submit" type="submit" class="input" value=" 查 询 "></td>
</tr>
</form>
</table>
</td>
<td>
<img src="images/分隔符.gif" width="1" height="93" alt="" /></td>
</tr>
<tr>
<td rowspan="10"> </td>
<td>
<img src="images/分隔符.gif" width="1" height="9" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="1" height="10" alt="" /></td>
</tr>
<tr>
<td colspan="2" rowspan="2">
<img src="images/cars_28.gif" width="199" height="39" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="31" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="1" height="8" alt="" /></td>
</tr>
<tr>
<td rowspan="4">
<img src="images/cars_30.gif" width="20" height="182" alt="" /></td>
<td rowspan="4" valign="top" bgcolor="#C8C8C8">
<%
if not rs3.eof then
for i=1 to 8
%>
<table width="100%" border="0" cellspacing="0">
<tr>
<td><span class="style7">☆</span> <a href="javascript:" onClick="window.open('xinwenopen.asp?id=<%=rs3("id")%>','','width=500,height=550,scrollbars=yes')"><%=rs3("title")%></a></td>
</tr>
</table>
<%
rs3.movenext
if rs3.eof then exit for
next
else
response.Write("暂无信息")
end if
%> </td>
<td>
<img src="images/分隔符.gif" width="1" height="52" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="1" height="45" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="1" height="43" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="1" height="42" alt="" /></td>
</tr>
<tr>
<td colspan="2">
<img src="images/cars_36.gif" width="199" height="18" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="18" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/cars_37.gif" width="20" height="243" alt="" /></td>
<td>
<img src="images/cars_38.gif" width="179" height="243" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="243" alt="" /></td>
</tr>
<tr>
<td colspan="14">
<img src="images/cars_39.gif" width="778" height="45" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="45" alt="" /></td>
</tr>
<tr>
<td colspan="14" background="images/cars_40.gif"><p align="center" class="style1">吉林省明日科技有限公司 <a href="Mangage/index.asp"><span class="style1">后台入口</span></a> 客服热线:0431-4972266 <br>
E-mail: <a href="mailto:mingrisoft@mingrisoft.com" ><span class="style1">mingrisoft@mingrisoft.com </span></a><br>
Copyright <span class="style3">©</span> 2005-2008 </p></td>
<td>
<img src="images/分隔符.gif" width="1" height="74" alt="" /></td>
</tr>
<tr>
<td>
<img src="images/分隔符.gif" width="15" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="8" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="137" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="56" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="11" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="10" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="120" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="2" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="1" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="203" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="7" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="9" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="20" height="1" alt="" /></td>
<td>
<img src="images/分隔符.gif" width="179" height="1" alt="" /></td>
<td></td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="37,5,72,18" href="index.asp">
</map>
</body>
</html>
<% End If %>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -