<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<%dim action,searchkey,categoryid,jiage,dijiage
if Not isNumeric(request.form("dijiage")) then
dijiage = 0
end if
if Not isNumeric(request.form("jiage")) then
jiage = 0
end if
jiage = 0
dijiage = 0
categoryid=Cint(request.form("categoryid"))
jiage= FormatSQL(SafeRequest("jiage",1))
dijiage= FormatSQL(SafeRequest("dijiage",1))
action= FormatSQL(SafeRequest("action",1))
searchkey=FormatSQL(SafeRequest("searchkey",0))
If dijiage > jiage Then
conn.close
set conn = nothing
response.Write "<script language='javascript'>alert('搜索价格下限大于价格上限，请正确输入！');history.go(-1);</script>"
response.End
end if
if categoryid="" then categoryid= FormatSQL(SafeRequest("categoryid",1))
if action="" then action=Cint(request.form("action"))
if searchkey="" then searchkey=trim(request.form("searchkey"))%>
<%call sss()%>
<title><%=webname%>--商品搜索结果--</title>
<meta name="description" content="网域电子商务网站,公司企业网站管理系统中英繁，仿阿里巴巴商贸通商务网,商城购物系统程序,源码下载，多用户商城,客隆电子商务网站管理系统,装饰,家具,旅社社旅游网站建设，程序开发,网站开发，网站推广,商城代码,系统销售,网络营销,企业商务,整站程序,ASP代码销售,企业电子商务平台,电子政务，官方站点：http://www.wygk.cn">
<meta name="keywords" content="网域电子商务网站,公司企业网站管理系统中英繁，仿阿里巴巴商贸通商务网,商城购物系统程序,源码下载，多用户商城,客隆电子商务网站管理系统,装饰,家具,旅社社旅游网站建设，程序开发,网站开发，网站推广,商城代码,系统销售,网络营销,企业商务,整站程序,ASP代码销售,企业电子商务平台,电子政务，官方站点：http://www.wygk.cn">
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK 
href="img/code43.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2800.1505" name=GENERATOR></HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="image/bg.gif" marginwidth="0" marginheight="0" >
<!--#include file="include/header.asp"--><table id="__01" width="1003" height="446" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top"> <img src="image/images/about_01.gif" width="29" height="338" alt=""></td>
    <td rowspan="3" width="212" height="446" valign="top"> 
      <table id="__01" width="212" height="200" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td> <img src="image/images/left_01.gif" width="212" height="74" alt=""></td>
        </tr>
        <tr> 
          <td background="image/images/left_02.gif" width="212" height="127"> 
            <!-- #include file="login.asp"-->
          </td>
        </tr>
        <tr> 
          <td width="212"  valign="top"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="4"></td>
              </tr>
            </table>
            <a href="procat.asp"><img src="image/HELPLEFT.gif" width="212" height="43" border="0"></a> 
            <table width="100%" align=center>
              <tbody> 
              <tr> 
                <td class=mm> 
                  <table width="160" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href="help.asp?action=process"><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>购物流程</a> </td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href="help.asp?action=feiyong"><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>送货方式及费率</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href="help.asp?action=fukuan"><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>付款方式</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=tiaokuan><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>交易条款</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=transport><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>运输说明</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=secret><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>保密安全</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=businesstime><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>工作时间</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=support><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>商品销售和售后服务</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=law><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>适用法律和版权声明</a></td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=# onClick="javascript:window.open('vip.asp?action=vipscore','','width=400,height=200,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes')";return false;><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>关于VIP会员</a> </td>
                    </tr>
                    <tr> 
                      <td style="padding-left:10px" height="25" class=table-youxia><a href=help.asp?action=faq><img height=11 src="image/icon_notice.gif" 
                  width=17 align=absMiddle border=0>常见问题</a></td>
                    </tr>
                  </table>
                </td>
              </tr>
              </tbody> 
            </table>
            <% if left1<>"" then %>
            <a href=<%=left1url%> target="_blank"><img src=<%=left1%> border="0"></a> 
            <% end if %>
            <!--左侧-->
            <br>
            <% if left2<>"" then %>
            <a href=<%=left2url%> target="_blank"><img src=<%=left2%> border="0"></a> 
            <% end if %>
            <!--左侧-->
          </td>
        </tr>
      </table>
      <table height=43 cellspacing=0 cellpadding=0 
                        width="100%" align=center 
                        background=img/contact.gif 
border=0>
        <tbody> 
        <tr> 
          <td  valign=top> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="5"></td>
              </tr>
            </table>
            <table cellspacing=0 cellpadding=0 width="100%" 
                              border=0 height="35">
              <tbody> 
              <tr> 
                <td 
                                style="PADDING-LEFT: 18px; FONT-SIZE: 8pt; FONT-FAMILY: tahoma" 
                                valign=top><img 
                                src="img/left_customer_01.gif" 
                                align=absMiddle width="21" height="14">020-34506590</td>
              </tr>
              <tr> 
                <td 
                                style="PADDING-LEFT: 18px; FONT-SIZE: 8pt; FONT-FAMILY: tahoma" 
                                valign=top height=10><img 
                                src="img/left_customer_02.gif" 
                                align=absMiddle width="21" height="14"><b><font color=#81B902><%=webemail%></font></b></td>
              </tr>
              </tbody> 
            </table>
          </td>
        </tr>
        </tbody> 
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="4"></td>
        </tr>
      </table>
      <table cellspacing=0 cellpadding=0 width="100%" 
border=0>
        <tbody></tbody> 
      </table>
      <table height=51 cellspacing=0 cellpadding=0 
                        width="100%" align=center 
                        background=img/time.gif border=0>
        <form name=frmTime3><tbody>
          <tr> 
            <td style="PADDING-LEFT: 38px; PADDING-TOP: 28px" 
                            valign=top> 
              <input 
                              style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; FONT: 9pt 宋体; BORDER-LEFT: 0px; WIDTH: 150px; COLOR: #585858; BORDER-BOTTOM: 0px; HEIGHT: 18px; BACKGROUND-COLOR: transparent" 
                              readOnly name=disp>
            </td>
          </tr>
        </form>
        <script>TO=setTimeout('TOfunc()',1000);</script></TBODY>
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="4"></td>
        </tr>
      </table>
      <table height=51 cellspacing=0 cellpadding=0 
                        width="100%" align=center 
                        background=img/conter.gif 
                          border=0>
        <tbody> 
        <tr> 
          <td style="PADDING-LEFT: 38px; PADDING-TOP: 24px" 
                            valign=top> 
            <script src="count/index2.asp?tye=num"></script>
          </td>
        </tr>
        </tbody> 
      </table>
    </td>
    <td rowspan="3" width="747" valign="top"> 
      <table width="747" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td> 
            <!-- #include file="ad.asp"-->
          </td>
        </tr>
        <tr> 
          <td height="57" background="image/special.gif"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="12%">&nbsp;</td>
                <td width="88%" align="left"> 
                  <div align="left"><b><font face="Arial"><font color="#3399CC"><a href="index.asp"><%=webname%></a>&nbsp;-&gt;&nbsp;商品搜索结果</font></font></b></div>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <table width="50%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="3"></td>
        </tr>
      </table>
      <table cellspacing=0 cellpadding=0 width="747" border=0 height="590">
        <tbody> 
        <tr> 
          <td class=ml width="11"></td>
          <td class=ml width="1" background="image/line.gif"></td>
          <td class=ml width="10"></td>
          <td align=left width="716" valign="top"> 
            <table cellspacing=0 cellpadding=0 width=100% border=0 align="center">
              <tbody> 
              <tr> 
                <td colspan=2 height=6 rowspan=2><img height=6 
                        src="img/rnd_subCon01.gif" 
                        width=6></td>
                <td bgcolor=#cccccc height=1></td>
                <td colspan=2 height=6 rowspan=2><img height=6 
                        src="img/rnd_subCon02.gif" 
                        width=6></td>
              </tr>
              <tr> 
                <td height=5></td>
              </tr>
              <tr> 
                <td width=5></td>
                <td valign=top align=middle width=100%> 
                  <table cellspacing=0 cellpadding=0 width="100%" border=0 align="center">
                    <tbody> 
                    <tr> 
                     
                      <td align=left> 
                        <TABLE width="100%" align=center>
                    <TBODY>
                    <TR>
                      
                                      <TD class=mm>

<%if searchkey="" then
	response.write "对不起，请您输入查询关键字"
	response.End
	else
	response.write "您查询的关健字是：<font color=red>"&searchkey&"</font>"
	end if%> <%'开始分页
				Const MaxPerPage=20
   				dim totalPut   
   				dim CurrentPage
   				dim TotalPages
   				dim j
   				dim sql
    				if Not isempty(request("page")) then
      				currentPage=Cint(request("page"))
   				else
      				currentPage=1
   				end if 
				
set rs=server.CreateObject("adodb.recordset")
if jiage=0 then  '//普通查询
select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where name like '%"&searchkey&"%' ",conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where mark like '%"&searchkey&"%' ",conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where introduce like '%"&searchkey&"%' ",conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,productdate,detail from product where detail like '%"&searchkey&"%' ",conn,1,1
end select
else
'//高级查询
if categoryid<>0 then  '//判断查询分类,分类不为空。  
select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where name like '%"&searchkey&"%' and price2> "&dijiage&" price2 < "&jiage&" and categoryid="&categoryid,conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where mark like '%"&searchkey&"%' and price2> "&dijiage&" and price2< "&jiage&" and categoryid="&categoryid,conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where introduce like '%"&searchkey&"%'  and price2> "&dijiage&"and price2< "&jiage&" and categoryid="&categoryid,conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,productdate,detail from product where detail like '%"&searchkey&"%' and price2> "&dijiage&" and price2=< "&jiage&" and categoryid="&categoryid,conn,1,1
end select
else
'//分类为空。
select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where name like '%"&searchkey&"%' and price2> "&dijiage&" and price2< "&jiage,conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where mark like '%"&searchkey&"%' and price2> "&dijiage&" and price2< "&jiage,conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,productdate from product where introduce like '%"&searchkey&"%' and price2> "&dijiage&" and price2< "&jiage,conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,productdate,detail from product where detail like '%"&searchkey&"%' and price2> "&dijiage&"and price2< "&jiage,conn,1,1
end select
end if
end if
				
  				if rs.eof And rs.bof then
       				Response.Write "<p align='center' > 对不起，没有查询到您需要的商品！</p>"
   				else
	  				totalPut=rs.recordcount

      				if currentpage<1 then
          				currentpage=1
      				end if

      				if (currentpage-1)*MaxPerPage>totalput then
	   					if (totalPut mod MaxPerPage)=0 then
	     					currentpage= totalPut \ MaxPerPage
	   					else
	      					currentpage= totalPut \ MaxPerPage + 1
	   					end if
      				end if

       				if currentPage=1 then
            			showContent
            			showpage totalput,MaxPerPage,"research.asp"
       				else
          				if (currentPage-1)*MaxPerPage<totalPut then
            				rs.move  (currentPage-1)*MaxPerPage
            				dim bookmark
            				bookmark=rs.bookmark
            				showContent
             				showpage totalput,MaxPerPage,"research.asp"
        				else
	        				currentPage=1
           					showContent
           					showpage totalput,MaxPerPage,"research.asp"
	      				end if
	   				end if
   				   				end if

   				sub showContent
       			dim i
	   			i=0

			%> 
                              <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#EFEFEF">
                                <tr align="center" height=30> 
                                  <td width="185" class=table-youxia background="image/bgfoot.gif" height="25"><FONT COLOR="#FF6600">商品名称</FONT></td>
                                  <td width="100"class=table-youxia background="image/bgfoot.gif" height="25"><FONT COLOR="#FF6600">商品品牌</FONT></td>
                                  <td width="180" class=table-youxia background="image/bgfoot.gif" height="25"><FONT COLOR="#FF6600">上货日期</FONT></td>
                                  <td width="65" class=table-youxia background="image/bgfoot.gif" height="25"><FONT COLOR="#FF6600">市场价</FONT></td>
                                  <td width="65" class=table-youxia background="image/bgfoot.gif" height="25"><FONT COLOR="#FF6600">会员价</FONT></td>
                                  <td width="100" class=table-xia background="image/bgfoot.gif" height="25"><FONT COLOR="#FF6600">购买/收藏</FONT></td>
                                </tr>
                                <%do while not rs.eof%>
                                <tr align="center" height=30 bgcolor="#FFFFFF"> 
                                  <%Dim num1 '//判断数字奇偶
num1 = Num1+1
If num1 Mod 2 = 0 Then%>
                                  <td  style="padding-left:6px" align="left" class=table-youxia><font color="#006666"> 
                                    <%response.write "<a href=product.asp?id="&trim(rs("id"))&" target=_blank>"&trim(rs("name"))&"</a>"%>
                                    </font></td>
                                  <td class=table-youxia><font color="#006666"><%=trim(rs("mark"))%></font></td>
                                  <td v> <font color="#006666"><%=trim(rs("productdate"))%></font></td>
                                  <td class=table-youxia><font color="#006666"><%=rs("price1")%>元</font></td>
                                  <td class=table-youxia><font color="#006666"><%=rs("price2") %>元</div></font></td>
                                  <td class=table-xia><a href="check.asp?ProdId=<% = rs("id") %>" target="_blank"><font color="#006666"><img src=images/skin/default/addto.gif align=absmiddle border=0></font></a></td>
                                  <%else%>
                                  <td  style="padding-left:6px" align="left" class=table-youxia><font color="#006666"> 
                                    <%response.write "<a href=product.asp?id="&trim(rs("id"))&" target=_blank>"&trim(rs("name"))&"</a>"%>
                                    </font></td>
                                  <td class=table-youxia><font color="#006666"><%=trim(rs("mark"))%></font></td>
                                  <td class=table-youxia><font color="#006666"><%=trim(rs("productdate"))%></font></td>
                                  <td class=table-youxia><font color="#006666"><%=rs("price1")%>元</font></td>
                                  <td class=table-youxia><font color="#006666"><%=rs("price2")%>元</font></td>
                                  <td class=table-xia><a href="check.asp?ProdId=<% = rs("id") %>" target="_blank"><font color="#006666"><img src=images/skin/default/addto.gif align=absmiddle border=0></font></a></td>
                                  <%end if%>
                                </tr>
                                <%i=i+1
		if i>=MaxPerPage then Exit Do
		rs.movenext
  loop
  rs.close
  set rs=nothing%>
                              </table>
                              <%  
				End Sub   
  
				Function showpage(totalnumber,maxperpage,filename)  
  				Dim n
  				
				If totalnumber Mod maxperpage=0 Then  
					n= totalnumber \ maxperpage  
				Else
					n= totalnumber \ maxperpage+1  
				End If %>
				
				<form method=Post action=<% = filename %>?searchkey=<% = searchkey %>&action=<% = action %>&categoryid=<% = categoryid %>&jiage=<% = jiage %>>
	    		<%	If CurrentPage<2 Then  %>
				<div align="center">首 页 上一页
				<% Else  %>
				<div align="center"><a href=<% = filename %>?page=1&searchkey=<% = searchkey %>&action=<% = action %>&categoryid=<% = categoryid %>&jiage=<% = jiage %>>首 页</a>
				<a href=<% = filename %>?page=<% = CurrentPage-1 %>&searchkey=<% = searchkey %>&action=<% = action %>&categoryid=<% = categoryid %>&jiage=<% = jiage %>>上一页</a>
				<%	End If
				If n-currentpage<1 Then  %>
				下一页 末 页
				
				<%	Else  %>
				<a href=<% = filename %>?page=<% = (CurrentPage+1) %>&searchkey=<% = searchkey %>&action=<% = action %>&categoryid=<% = categoryid %>&jiage=<% = jiage %>>下一页</a> 
				<a href=<% = filename %>?page=<% = n %>&searchkey=<% = searchkey %>&action=<% = action %>&categoryid=<% = categoryid %>&jiage=<% = jiage %>>末 页</a>
				<%	End If  %>
				 第&nbsp;<b><% = CurrentPage %></b>&nbsp;页 共&nbsp;<b><% = n %></b>&nbsp;页
				 共查询到&nbsp;<b><% = totalnumber %></b>&nbsp;件商品
				转到第<input type="text" name="page" size=2 maxlength=10 value=<% = currentpage %>>
				页<input type='submit'  class='contents' value='跳转' name='cndok'></div></form>
				<%
				End Function  
sub sss() 
if action="1" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from keyname where keyname='"&searchkey&"' ",conn,1,3
if rs.eof and rs.bof then
rs.close
rs.open "select * from keyname",conn,1,3
rs.addnew
rs("keyname")=searchkey
rs("keyorder")=1
rs.update
rs.close
set rs=nothing
else
rs("keyorder")=rs("keyorder")+1
rs.update
rs.close
set rs=nothing
end if
end if
end sub%></TD>
            </TR></TBODY></TABLE></td>
                    </tr>
                  </table>
                </td>
                <td class=mr></td>
              </tr>
            </table>
            </td>
        
        </tr>
         
      </table>
    </td>
    <td rowspan="3" width="15">&nbsp; </td>
  </tr>
  <tr> 
    <td width="29" height="48">&nbsp; </td>
  </tr>
  <tr> 
    <td height="29"> 
      <p>&nbsp;</p>
      <p>&nbsp; </p>
    </td>
  </tr>
</table>
<!--#include file="include/footer.asp"--></BODY></HTML>
