<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%
  data_path="../" 'ACC连接数据库路径，对SQL无效
 %>
<!--#include file="../conn/conn.asp"-->
<!--#include file="../inc/safe.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=WebName%>_产品报价 </title>
<link href="<%=HOPE_InstallDir%>hc360/hcB2B.css" rel="stylesheet" type="text/css">
<SCRIPT language=JavaScript src="<%=HOPE_InstallDir%>mall.js"  type=text/JavaScript></SCRIPT>
  
<%
      seakind=Replace_Text(request("seakind"))
   	 '^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
	'处理种类的id号 
  	sortid=Replace_Text(request("p_z_Z_RootCategory")) 
	if   Replace_Text(request("p_z_Z_CategoryId1"))<>"" then
  	   CategoryId=split(Replace_Text(request("p_z_Z_CategoryId1")),",")
 	 typeid=CategoryId(0)                                                                 '第二类
 	 if ubound(CategoryId)>=1 then
	 typeid_2=CategoryId(1)                                                               '第三类     
		else
	 typeid_2=0
		end if
 		if typeid="" then
		typeid=0
		end if
		if typeid_2="" then
		typeid_2=0
		end if
	  end if
	  if Replace_Text(request("sortid"))<>"" then
	  sortid=Replace_Text(request("sortid"))
	  typeid=Replace_Text(request("typeid"))
	  typeid_2=Replace_Text(request("typeid_2"))
	  End if 
	'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 	keywords=replace_text(request("keywords"))
 	proadd=replace_text(request("proadd"))
	'propri=replace_text(request("propri"))
 	country=Replace_Text(request("country1"))
	sf=Replace_Text(request("province"))
	city=Replace_Text(request("city"))
	DateTime=replace_text(request("DateTime"))
 	priceStart=Replace_Text(request("priceStart")) 
	priceEnd=Replace_Text(request("priceEnd"))
	biztype=Replace_Text(request("biztype"))
if priceStart<>"" then
if not isnumeric(priceStart)  then
priceStart=""
end if
end if
if priceEnd<>"" then
if not isnumeric(priceEnd) then
priceEnd=""
end if
end if
	'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

sql="select Websen_productshow.*,Websen_corporation.id as corid,Websen_corporation.gradeid,Websen_corporation.flag as corflag,Websen_corporation.qymc,Websen_corporation.tm,Websen_corporation.[user],Websen_corporation.country,Websen_corporation.sf,Websen_corporation.city,Websen_corporation.web,Websen_corporation.url,Websen_corporation.trust_score from Websen_productshow,Websen_corporation where Websen_corporation.id=Websen_productshow.gsid and Websen_productshow.flag=1 and Websen_productshow.iscpbj=1 and Websen_corporation.flag=1 "
	if Chkrequest(sortid)   then
	if sortid<>0 then
	 sql=sql&"  and Websen_productshow.SortID="&sortid
 	if Chkrequest(typeid) then 
	sql=sql&" and Websen_productshow.TypeID="&typeid
	end if
	if Chkrequest(typeid_2) then 
	sql=sql&" and Websen_productshow.typeid_2="&typeid_2
	 end if
	 end if
	 end if
	 if priceStart<>"" then 
	 sql=sql&" and Websen_productshow.proprice>="&priceStart&""
	 end if 
	 if priceEnd<>"" then 
	  sql=sql&" and Websen_productshow.proprice<="&priceEnd&""
	 end if 
if keywords<>"" then
 sql=sql&" and (Websen_productshow.keywords like '%"&keywords&"%' or Websen_productshow.Cpmc like '%"&keywords&"%' or Websen_productshow.xxsm like '%"&keywords&"%'   )"
 end if
 if biztype<>"" then sql=sql&" and Websen_corporation.qylb like '%"&biztype&"%'"
if country<>"" then sql=sql&" and Websen_corporation.country='"&country&"'"
if sf<>"" then sql=sql&" and Websen_corporation.sf='"&sf&"'"
if city<>"" then sql=sql&" and Websen_corporation.city='"&city&"'"
'if propri<>"" then sql=sql&" and (Websen_productshow.proprice >= "&propri&" or Websen_productshow.proprice <= "&propri&")"
if proadd<>"" Then sql=sql&" and Websen_productshow.cpcd like '%"&proadd&"%'"
	if datetime<>"" then
	  if datetime<>"all" then
 		If Database_type=1 Then
			if datetime="no" then 
			sql=sql&" and Websen_productshow.idate<getdate()-90"
			else
			sql=sql&" and Websen_productshow.idate>=getdate()-"&datetime&""
			end if
  		else
			if datetime="no" then 
			sql=sql&" and Websen_productshow.idate<date()-90"
			else
			sql=sql&" and Websen_productshow.idate>=date()-"&datetime&""
			end if
		end if
	 end if
  end if
 sql=sql&" order by Websen_corporation.trust_score desc"
   Set rs= Server.CreateObject("ADODB.Recordset") 
rs.open sql,conn,1,1 
num=rs.recordcount
msg_per_page=15 '定义每页显示记录条数
%>

<div align="center"> 
  <!--#include file="../inc/head.asp"-->
   <!--#include file="../inc/headpage.asp"-->
 <DIV id=popImageLayer 
style=" background-color:#F6F6F6;BORDER-RIGHT: orange 1pt none; BORDER-TOP: orange 1pt none; VISIBILITY: hidden; BORDER-LEFT: orange 1pt none; WIDTH: 180px; CURSOR: hand; BORDER-BOTTOM: orange 1pt none; POSITION: absolute; HEIGHT: 180px" 
align=center calss="" name="popImageLayer"></DIV><table width="930" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="5"></td>
  </tr>
</table>
 <div id='yabock'>
   <div class='mulur'><A href="/index.html">网站首页</A> &gt; 产品报价 (共有
     <strong><%=num%></strong> 条 <strong><%=quo%></strong> 的价格信息)</div>
   <div class='fenli'>
     <table cellspacing="0" cellpadding="0" border="0">
       <tbody>
         <tr>
           <td align="center"><form  action="Productprice.asp"  method="get" name="form" id="form"  style="margin:0px;">
               <img height="10" src="/images/list_mid_search_title.gif" width="11" /><strong> 缩小搜索范围</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class="STYLE7">筛选</span>:</b><strong>单价</strong>从&nbsp;
               <input name="priceStart" type="text" value="<%=priceStart%>" size="10" maxlength="10"   style="border-width:1px; border-style:solid; border-collapse:collapse; border-color:#cccccc;width:50;height:19" />
             元 至&nbsp;
             <input name="priceEnd" type="text" value="<%=priceEnd%>" size="10" maxlength="10"   style="border-width:1px; border-style:solid; border-collapse:collapse; border-color:#cccccc;width:50;height:19"/>
             元 <strong>公司经营模式</strong>
             <select  name="biztype" m_title="选择公司经营模式" value="0" onchange="changeStatus(this,'biztypeId');">
               <option  value="" >不限</option>
               <option  value="生产型" >生产型</option>
               <option  value="贸易型" >贸易型</option>
               <option  value="服务型" >服务型</option>
               <option  value="政府或其他机构" >政府或其他机构</option>
             </select>
             <strong>调整关键字</strong>
             <input name="keywords" type="text" size="18" maxlength="10"  style="border-width:1px; border-style:solid; border-collapse:collapse; border-color:#cccccc;width:140;height:19" />
             <input type="submit" name="Submit2" class="s" value=" 筛  选 " style="background-color:#C9C9C9" />
             &nbsp;
           </form></td>
         </tr>
       </tbody>
     </table>
   </div>
   <div class="kokgn"></div>
 </div>
 <div id="stecy">
  <div class="bodyet">
	 <div class="titep">
      <div class="zlu"></div>
      <div class="zle">产品报价列表</div>
      <div class="zla"></div>
    </div>
       <div id="lacket">
         <div class="Sclass1"></div>
         <div class="Sclass2">&nbsp;[<%=quo%>]价格行情</div>
         <div class="Sclass3">网胜通指数</div>
         <div class="Sclass4">产品报价</div>
         <div class="Sclass5"><a href="<%=HOPE_InstallDir%>member/">发布价格</a></div>
       </div>
   <div class="lacket_PRO">
     <table width="100%" border="0" cellpadding="0"cellspacing="0" >
       <tr>
         <td width="54%" height="107" align="left" valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0" align="center">
             <tr>
               <td valign="top"><%
if rs.eof then
response.Write"<table width=""100%""  border=""0"" cellspacing=""0"" cellpadding=""0"">"
response.Write"<tr><td class=buttoncolor2 align=left>"
response.Write"<br><b>&nbsp;您查找的<font color=red>“"&keywords&"”</font>的信息暂时没有找到</b><br><br>"
response.Write"</tr></table>"
response.Write"<table width=""100%""  border=""0"" cellspacing=""0"" cellpadding=""0"" class=blackborder>"
response.Write"<tr><td class=""lh17 c"">"
response.Write"· 缩短或更换产品名后重新搜索<span class=""S""><font color=""#666666"">（例：将“彩色电视机”改为“电视机”后重新搜索）,对类别和范围做调整查询！</font></span>；<br><br>" 
response.Write"· 您也可以<input name=""postOffer"" type=""button"" value=""立即发布供求信息"" onclick=location.href="""&HOPE_InstallDir&"member/index.asp"" style='background-color:#E7E7E7;color:#E64413;border:solid;border-color:#E7E7E7'>告诉客户您需要什么，让他们找上门！<br><br><br> </td>"
response.Write"</tr></table>"
else
%>
                   <%
do while not rs.eof and rowcount > 0
%>
                   <table width="100%" height="85" border="0" align="center" cellpadding="0" cellspacing="0">
                     <tbody>
                       <tr <%if icolor=0 then response.write"bgColor=#ffffff" else response.write"bgColor=#f6f6f6" end if%> onmouseover="this.style.backgroundColor='#FFF8F4'" onmouseout="this.style.backgroundColor='<%if icolor=0 then response.write"#ffffff" else response.write"#f6f6f6" end if%>'">
                         <td align="middle" width="12%"><table class="porductborder" height="64" cellspacing="0" cellpadding="0" width="64" 
      border="0">
                             <tbody>
                               <tr>
                                 <td align="middle"><%
if rs("picture")<>"../../UploadFile/nopicture.gif" then%>
                                     <%
	  response.write"<A class=M href='"&HOPE_InstallDir&"productshow/offerdetail/"&rs("sortid")&"-"&rs("typeid")&"-"&rs("typeid_2")&"-"&rs("id")&".html' target=_blank>"
%>
                                     <img    onmouseover="popImage(this,'<%=HOPE_InstallDir%>Vipcom/<%=rs("user")%>/<%=rs("picture")%>','<%=HOPE_InstallDir%>productshow/offerdetail/<%=rs("sortid")%>-<%=rs("typeid")%>-<%=rs("typeid_2")%>-<%=rs("id")%>.html');"   src="<%=HOPE_InstallDir%>Vipcom/<%=rs("user")%>/<%=rs("picture")%>"  width="100" height="100"    border="0" />
                                     <%else%>
                                     <font class="C" color="#cecfce">无图</font>
                                     <%end if%>
                                 </td>
                               </tr>
                             </tbody>
                         </table></td>
                         <td width="52%" valign="top" class="cate" style=" padding-left: 10px"><a class="b"   href="<%=HOPE_InstallDir%>productshow/offerdetail/<%=rs("sortid")%>-<%=rs("typeid")%>-<%=rs("typeid_2")%>-<%=rs("id")%>.html"  target="_blank">
                           <%
   Set re = New RegExp
re.Pattern ="("&keywords&")"
re.IgnoreCase = True
re.Global=True
result = re.Replace(rs("cpmc"), "<font color=red>$1</font>")%>
                           <%=result%></a><br />
                           <%=Left(noHtml(rs("xxsm")),55)%>...<br />
                           <%
				set rsb=server.CreateObject("adodb.recordset")
				sqlb="select * from Websen_vipgrade where roleid="&rs("gradeid")
				rsb.open sqlb,conn,1,1
				if not rsb.eof then
				if instr(rsb("rolelist"),"qw")>0 then
 				if is2weburl=1 then
				%>
                           <a href="http://<%=rs("user")%>.<%=weburl1%>"   target="_blank"><font color="#666666"><u><%=rs("qymc")%></u></font></a>
                           <%
	  else
	  %>
                           <a href="<%=HOPE_InstallDir%>vipcom/<%=rs("user")%>/"  target="_blank"><font color="#666666"><u><%=rs("qymc")%></u></font></a>
                           <%
        end if
       else%>
                           <a href="<%=HOPE_InstallDir%>Ptcom/<%=rs("user")%>.html" target="_blank"><font color="#666666"><u><%=rs("qymc")%></u></font></a>
                           <%end if
  				rsb.close
				end if
 				%>
                           <br />
                         </td>
                         <td width="3%" valign="top" class="cate" style=" padding-left: 10px">&nbsp;</td>
                         <td align="middle" width="10%"><div align="center"> <font color="red"> <u><%=rs("trust_score")%> </u> </font> </div></td>
                         <td class="s" align="middle" width="23%"><div align="center"> <font color="red"><strong><%=rs("proprice")%></strong></font>元 </div></td>
                       </tr>
                     </tbody>
                   </table>
                 <br />
                   <%
icolor=icolor+1
if icolor>1 then icolor=0
rowcount=rowcount-1
rs.movenext
loop
end if
%>
                   <br />
                   <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" style="BORDER-TOP: #9C9A9C 1px solid;BORDER-Bottom: #9C9A9C 1px solid">
                     <tr>
                       <td><table cellspacing="0" cellpadding="4" width="100%"   border="0">
                           <tr>
                             <td   align="middle"><%=listPages(""&HOPE_InstallDir&"productshow/Productprice.asp?sortid="&sortid&"&typeid="&typeid&"&typeid_2="&typeid_2&"&keywords="&keywords&"&country1="&country&"&province="&sf&"&city="&city&"&datetime="&datetime&"&priceStart="&priceStart&"&priceEnd="&priceEnd&"&biztype="&biztype&"")%></td>
                           </tr>
                       </table></td>
                     </tr>
                 </table></td>
             </tr>
         </table></td>
       </tr>
     </table>
   </div>
   </div>
	 <div class="bodyat">
     <div class="zhanwei"></div>
    <div class="guangao">
       <p>
         <script src="/ads/JS/200817142139.js"></script>
       </p>
       <p>
         <script src="/ads/JS/20081491217.js"></script>
       </p>
       <p>
         <script src="/ads/JS/200814151336.js"></script>
       </p>
     </div>
   </div>
</div>
 <!--#include file="../inc/end.asp"-->
 </body>
</html>