📄 search.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="script/user_common.asp"-->
<!--#include file="script/trimFunction.asp"-->
<%
strKeyWord = trim_str(String(Request("keyword")));
strCompany = Request("company");
intList = Request("list");
intFrom = Request("_from");
intTo = Request("_to");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>:: Công ty máy tính DTH ::</title>
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" bgcolor="#2D87CD">
<!--#include file="Include/top.asp"-->
<div align="center">
<table width="779" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="129" valign="top">
<!--#include file="Include/inc_top.asp"-->
</td>
</tr>
<tr>
<td valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<!--DWLayoutTable-->
<tr>
<td width="159" rowspan="3" valign="top" style="background-image: url('images/mnleft_bg.gif'); background-repeat: repeat-y; background-position-x: center;">
<!--#include file="Include/inc_menuleft.asp"-->
</td>
<td width="1" rowspan="2" valign="top" bgcolor="#CCCCCC"></td>
<td width="460" rowspan="2" valign="top" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" width="100%">
<!--DWLayoutTable-->
<tr>
<td width="460" height="7" colspan="3" background="images/top_body_bg.gif"></td>
</tr>
<tr>
<td style="padding-left: 10px; padding-right:10; padding-top:3; padding-bottom:0" valign="top">
<marquee behavior="scroll" width="100%" style="color: #0066CC; font-family:Tahoma; font-size:8pt" scrollamount="4" onmouseover="this.stop();" onmouseout="this.start();" scrolldelay="85">
Công ty Máy tính DTH - Xin kính chào quý khách - Địa chỉ: 1A Yết Kiêu, Hoàn Kiếm, Hà Nội - Điện thoại: (04) 8224880 - Fax: (04) 8224881</marquee>
</td>
</tr>
<%
if(strKeyWord!="")
{
var rs=Server.CreateObject("ADODB.Recordset");
var strSQL;
strSQL="Select PID, PName, PImage, PPrice, PWarranty, PDescription, PStatus, PBest, PNew, PCompany From vwProduct Where ";
strSQL+=" (PName LIKE N'%" + strKeyWord + "%' Or PDescription Like N'%" + strKeyWord + "%' ";
strSQL+=" Or PID Like N'%" + strKeyWord + "%') "
if(intList!="0")
{
strSQL+=" AND (SubID=" + parseInt(intList) + ")";
}
if((intFrom!="")&&(intTo!=""))
{
strSQL+=" AND (PPrice BETWEEN " + parseInt(intFrom) + " and " + parseInt(intTo) + ")";
}
if((intFrom!="")&&(intTo==""))
{
strSQL+=" AND (PPrice >=" + parseInt(intFrom) + ")";
}
if((intFrom=="")&&(intTo!=""))
{
strSQL+=" AND (PPrice <=" + parseInt(intTo) + ")";
}
if(strCompany!="")
{
strSQL+=" AND PCompany='" + strCompany + "'";
}
strSQL+=" Order By CatOrder, SOrder, PID";
rs.Open(strSQL,oConn,3,1);
}
%>
<tr>
<td height="78" colspan="3" valign="top" style=" padding-left:3px; padding-right:3px; "><div align="center">
<p><span style="font:arial, tahoma, verdana; font-size: 14px; color:#885B00 ">
Công cụ tìm kiếm trực tuyến của chúng tôi sẽ giúp bạn tìm trong hàng nghìn sản phẩm với tốc độ cao và chính xác nhất.
Hãy kết hợp những điều kiện dưới đây một cách hợp lý để giúp bạn tìm ra được những sản phẩm mong muốn.</span></p>
</div></td>
</tr>
<tr>
<td height="206" colspan="3" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<form name="frmsearch" method="post" action="Search.asp" onSubmit="return checkSearch(this);">
<tr>
<td width="23" height="9"></td>
<td width="8"></td>
<td width="105"></td>
<td width="298"></td>
<td width="8"></td>
<td width="18"></td>
</tr>
<tr>
<td height="23"></td>
<td valign="top" bgcolor="#C7CED8"><img src="images/top_s.gif" width="8" height="7"></td>
<td colspan="2" valign="middle" align="left" bgcolor="#C7CED8"><strong><font color="#006699">Tìm kiếm mở rộng</font></strong></td>
<td valign="top" bgcolor="#C7CED8"><img src="images/top_c.gif" width="8" height="7"></td>
<td></td>
</tr>
<tr>
<td height="30"> </td>
<td colspan="2" valign="middle" align="left" style="padding-left:6px; "><strong><font size="2">Từ khóa</font></strong></td>
<td colspan="2" align="left" valign="middle">
<input type="text" name="keyword" value="<%=strKeyWord%>">
(Ví dụ Main hoặc CPU)
</td>
<td> </td>
</tr>
<tr>
<td height="30"></td>
<td colspan="2" valign="middle" align="left" bgcolor="#e4e8ed" style="padding-left:6px; "><strong><font size="2">Danh mục</font></strong></td>
<td colspan="2" valign="middle" align="left" bgcolor="#e4e8ed">
<select name="list" size="1" class="textbox" id="list">
<option value="0" <%if(parseInt(intList)==0){%> selected <%}%>> - Tất cả</option>
<%
var oRsCat=Server.CreateObject("ADODB.Recordset");
var SQLcat="Select Distinct(CatName), CatOrder, CatID From vwSubCat Order by CatOrder ASC";
oRsCat.Open(SQLcat,oConn,3,1);
while((!oRsCat.BOF)&&(!oRsCat.EOF))
{
%>
<optgroup label="<%=oRsCat.Fields("CatName")%>" style="background-color:#006600; color:#FFFFFF;"></optgroup>
<%
var oRsSub=Server.CreateObject("ADODB.Recordset");
var SQLsub="Select Distinct SubName, SubID, SOrder From vwSubCat Where SCatID=" + oRsCat.Fields("CatID") + " AND SDelete=1 Order by SOrder ASC";
oRsSub.Open(SQLsub,oConn,3,1);
while((!oRsSub.BOF)&&(!oRsSub.EOF))
{
%>
<option value="<%=oRsSub.Fields("SubID")%>" <%if(parseInt(intList)==oRsSub.Fields("SubID")){%>selected<%}%>> + <%=oRsSub.Fields("SubName")%></option>
<%
oRsSub.MoveNext();
}
oRsSub.Close();
%>
<%
oRsCat.MoveNext();
}
oRsCat.Close();
%>
</select>
</td>
<td></td>
</tr>
<tr>
<td height="30"></td>
<td colspan="2" valign="middle" align="left" style="padding-left:6px; "><strong><font size="2">Giá tiền</font></strong></td>
<td colspan="2" align="left" valign="middle" style="padding-left:0px; ">
<input name="_from" type="text" size="5" value="<%=intFrom%>">
đến
<input name="_to" type="text" size="5" value="<%=intTo%>">
(Ví dụ từ 60 đến 150 ) </td>
<td></td>
</tr>
<tr>
<td height="30"></td>
<td colspan="2" align="left" valign="middle" bgcolor="#e4e8ed" style="padding-left:6px; "><strong><font size="2">Nhà sản xuấ</font></strong>t</td>
<td colspan="2" align="left" valign="middle" bgcolor="#e4e8ed"><div align="left">
<input type="text" name="company" value="<%=strCompany%>">
</td>
<td></td>
</tr>
<tr>
<td height="30"></td>
<td colspan="4" valign="middle" style="padding-left:6px; "></td>
<td></td>
</tr>
<tr>
<td height="24"></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -