<!--#include virtual="/conn/conn.asp"-->
<!--#include virtual="/inc/safe.asp"-->
<!--#include virtual="/inc/classcount.asp"-->
<%
if Chkrequest(request("typeid")) then
typeid=request("typeid")
else
Response.Redirect ("../../login/chklogin.asp?login=4")
end if

show=replace_text(request("show"))
country=Replace_Text(request("country1"))
sf=Replace_Text(request("province"))
city=Replace_Text(request("city"))
datetime=replace_text(request("datetime"))

%>
<%
sql="select productshow.*,corporation.id as corid,corporation.flag as corflag,corporation.qymc,corporation.country,corporation.sf,corporation.city,corporation.web,corporation.url,corporation.trust_score from productshow,corporation where productshow.typeid="&typeid&" and corporation.id=productshow.gsid and productshow.flag=1"
if country>"" then sql=sql&" and corporation.country='"&country&"'"
if sf>"" then sql=sql&" and corporation.sf='"&sf&"'"
if city>"" then sql=sql&" and corporation.city='"&city&"'"

if datetime="1" then sql=sql&" and productshow.idate>=date()-1"

if show="trust_score" then
sql=sql&" order by corporation.trust_score desc"
else
sql=sql&" order by productshow.id desc"
end if

Set rs= Server.CreateObject("ADODB.Recordset") 
rs.open sql,conn,1,1 

msg_per_page=20 '定义每页显示记录条数
%>
<!--#include virtual="/inc/headpage.asp"-->
<style type="text/css">
<!--
.searchbar1 {BORDER-TOP: #f1f1f1 3px solid;  FONT-WEIGHT: bold; BACKGROUND: #e7e7e7; BORDER-BOTTOM: #bebebe 3px solid; FONT-FAMILY: 宋体; padding-top:3px}
.companybar1 {background:url("/seller/images/search_bg.gif");border:#999999 solid;border-width:1 1 0 1;height:29px;border-bottom:#666666 3 solid;text-align:center;font:bold 14px;padding-top:4px;}
.orangeborder {border:#CC3300 2 solid;padding-left: 15px}
.cate {padding-left: 14px;font-size:12px;LINE-HEIGHT: 150%;}
.orangeborder2 {border:#cc3300 1 solid;padding-left: 15px}
-->
</style>
<!--#include virtual="/productshow/head.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TABLE cellSpacing=2 cellPadding=2 width="98%" align=center border=0>
  <TBODY>
  <TR>
    <TD class=s>您当前的位置： <a href="/" class=s><%=webname%>首页</a> <small>></small> <a href="/tradeinfo/index.asp" class=s>我要采购</a> <small>></small> <a href="/tradeinfo/index.asp">查看供应信息</a> <small>></small>
  <%
sorttype="select class_2.typeid,class_2.typename,class_1.* from class_2,class_1 where class_2.typeid="&typeid&" and class_1.sortid=class_2.sortid"
set rssorttype=conn.execute(sorttype) 
response.write"<a href='../trade/trade.asp?sortid="&rssorttype("sortid")&"' class=s>"&rssorttype("sort")&"</a>"
response.write" <small>></small> "
response.write"<strong>"&rssorttype("typename")&"</strong>"
%>
</TD></TR></TBODY></TABLE>

<TABLE width="98%" border=0 align="center" cellPadding=0 cellSpacing=0 class="outborder">
  <TBODY>
    <TR>
      <FORM name=searchForm action="/select.asp" 
    onsubmit="javascript:if(doSearch()==false) return false;" method=post>
        <td height=40  valign=middle class="searchbar"><table width="80%"  border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td><img src="/seller/images/img_search.gif" width=86 height=21 align=absmiddle>　
                  <input size=25 name="keywords">
                  <select class=text13 name=categoryId>
                    <option value="" selected>在所有行业</option>
                    <option 
      value="<%=sortid%>"><%=rssort("sort")%></option>
                  </select>
                  <select class=TEXT13 name="which">
                    <option value="all">供求信息</option>
                    <option value="sale">供应信息</option>
                    <option value="buy">求购信息</option>
                    <option value="productshow" selected>产品目录</option>
                    <option value="corporation">公司库</option>
                    <option value="news">行业资讯</option>
                  </select>
&nbsp;
                <input name="imageField" type="image" src="/images/serch.gif" align="top" width="65" height="22" border="0">
              　</td>
              <td><img src="/images/icon_point.gif" width="18" height="19" align="absmiddle"> <a href="/help/Search_Answer.asp" target=_blank>如何搜索</a></td>
            </tr>
        </table></TD>
      </FORM>
      <SCRIPT LANGUAGE='JavaScript' SRC='/js/search.js' TYPE='text/javascript'></script>
    </TR>
  </TBODY>
</TABLE>
<SCRIPT LANGUAGE='JavaScript' SRC='/js/search.js' TYPE='text/javascript'></script>
  <BR>
  
  <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" class="downborder">
    <tr>
      <td width="97" class="buttonbar"  onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/offerlist/list.asp?typeid=<%=typeid%>'"><img src="/images/icon_black_45down.gif" border=0 align=absmiddle width=20 height=20><span class=head>供应商机</span></td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../seller/offerlist/list.asp?typeid=<%=typeid%>'">采购信息</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/trade/trade.asp?sortid=30'">代理商机</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/trade/trade.asp?sortid=25'">加工商机</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/trade/trade.asp?sortid=31'">库存产品</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/trade/trade.asp?sortid=33'">二手设备</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/trade/trade.asp?sortid=32'">项目合作</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td width="75" class="companybar" onMouseOver="this.style.cursor='hand'" OnClick="location.href='../../tradeinfo/trade/trade.asp?sortid=12'">商务服务</td>
      <td width="3" class="midbar">&nbsp;</td>
      <td class="midbar">&nbsp;</td>
    </tr>
</table>
  <table width="98%"  border="0" align="center" cellpadding="10" cellspacing="0" class=outborder>
    <tr>
      <td bgcolor="E7E7E7">
        <table width="100%"  border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td> <b>“<font color=red><%=rssorttype("typename")%></font>”的相关产品共 <%if totalrec>0 then response.write"("&totalrec&")" else response.write"(0)" end if%> 条</b><br>            </td>
            <td align=right class=S> <a href="/staric/index.asp"><img src="/images/trust.gif" width=22 height=14 border=0  align=absmiddle></a> <font color=939393>商贸通会员 | <img src="/images/brand.gif" width=21 height=23 align=absmiddle> 网上有名</font>   
          </tr>
        </table>
        <table width="100%"  border="0" cellspacing="0" cellpadding="3">
          <tr>
            <td width=165 class="nobianbuttonborder M blackbordernobottom"  nowrap>
              <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td>&nbsp;</td>
                  <td><div align="left"> <b><a href="../../tradeinfo/offerlist/list.asp?typeid=<%=typeid%>">供应信息</a></b> <b>(<%=listcount_sale%>)</b></div></td>
                </tr>
            </table></td>
            <td rowspan=3 class=orangeborder bgcolor=#FFFFFF>
              <table width="100%"  border="0" cellspacing="0" cellpadding="7">
                <tr>
                  <td><span class="text13"> <img src="/images/icon_point.gif" border=0 width=18 height=19  align=absmiddle>  
                    <%if datetime="1" then
		    response.write"<A href='list.asp?typeid="&typeid&"'>所有产品</a>"
		    else
		    response.write" "
			end if%>
                    <%if datetime="1" then
		    response.write" "
		    else			
			response.write"<A href='list.asp?typeid="&typeid&"&datetime=1&show="&show&"'>今日最新产品</A>"
			end if%>
<img src="/images/icon_point.gif" border=0 width=18 height=19 align=absmiddle> <b><a 
            href="/member/productshow/edit.asp">管理产品</a> <img src="/images/icon_point.gif" border=0 width=18 height=19  align=absmiddle> <a 
            href="/member/productshow/add_product.asp">发布产品</a>　<b><img src="/images/icon_point.gif" border=0 width=18 height=19  align=absmiddle></b> <a 
            href="/member/myemail/orderbegin.asp" style="color: #CC3300">按关键字订阅商讯</a></b> </span></td>
                </tr>
                <tr>
                  <td><TABLE cellSpacing=0 cellPadding=0 border=0>
                    <FORM name=frmAreaSearch action="list.asp?typeid=<%=typeid%>&datetime=<%=datetime%>" method=post>
                      <TR>
                        <TD class=text13 noWrap>过滤信息： 地区
                            <SELECT style="WIDTH: 90px" 
            onchange=javascript:changeCountry1(this); name=country1>
                            </SELECT>
                            <SELECT style="WIDTH: 60px" 
            onchange=changeProvince(this); name=province>
                              <OPTION value="" 
              selected>省份</OPTION>
                            </SELECT>
                            <SELECT name=city>
                              <OPTION value="" 
              selected>地级</OPTION>
                            </SELECT>
                            <input name="imageField2" type="image" src="/seller/images/search.gif" align="top" width="65" height="22" border="0">
</TD>
                      </TR>
                    </FORM>
                  </TABLE>
				  <SCRIPT language=javascript src="/js/area.js"    
      purpose="INITIALIZER"></SCRIPT>
	  <SCRIPT language=javascript>
<!--
    //设置国家1的缺省值
    for (var i=0;i<5;i++){
	    if (country1Form1.options[i].value == '<%=country%>'){
		    country1Form1.options[i].selected=true;
		}
	}

    for (var i=0;i<catArr1.length;i++) {
		catForm1.options[i+1]=new Option(catArr1[i].title,catArr1[i].id);
		//设置省选择框的选择值
		if(catForm1.options[i+1].value == '<%if country="中国" then response.write""&sf&""%>'){
	        	catForm1.options[i+1].selected=true;
	        }
	}
	changeProvince(catForm1);
	var len = boardForm1.options.length;
	for (var i=0;i<len;i++) {
		//设置城市选择框的选择值
		if(boardForm1.options[i].value == '<%if country="中国" then response.write""&city&""%>') {
		    boardForm1.options[i].selected=true;
		}
	}
	
    if (country1Form1.options[country1Form1.selectedIndex].value!='中国') {
	    catForm1.style.display = 'none';
	    boardForm1.style.display = 'none';
		}
-->
</SCRIPT>				
				  </td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td class="buttoncolor M" nowrap><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td>&nbsp;</td>
                  <td><b>
                  <div align="left"><img src="/image/icon_point_red_16.gif" width="16" height="16" align="top"> <font color=#FFFFFF>产品目录 </font><font color=#ffffff><b>
                    <%if totalrec>0 then response.write"("&totalrec&")" else response.write"(0)" end if%>
                  </b></font><font color=#FFFFFF>                   </font></div>
                  </b> </td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td class="nobianbuttonborder M blackbordernobottom"  nowrap>
              <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td>&nbsp;</td>
                  <td><div align="left"> <b><a href="../../corporation/offerlist/list.asp?typeid=<%=typeid%>">相关公司</a></b> <b>(<%=listcount_cor%>)</b></div></td>
                </tr>
            </table></td>
          </tr>
      </table></td>
    </tr>
</table>
<Br>
<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="180" vAlign=top><table width="180"  border="0" cellspacing="1" cellpadding="0">
        <tr>
          <td class="buttoncolor" nowrap> <b><font color=FFFFFF class=M>推荐企业 </font></b><a href="/help/index.asp" target="_blank"><font color="#ffffff">如何获得推荐？</font></a></td>
          <td width=3></td>
        </tr>
      </table>
	  <br>
	  <table width="173"  border="0" cellspacing="0" cellpadding="5" height=85>         
          <tr>
            <td class="orangeborder2 lh13" bgcolor=FCF3EC style="padding-right:10px">

          <a href="#" target="_blank">相关推荐公司展示</a><br> 
          <font color="#666666" class=s>主营产品/服务:</font>
          </td>
        </tr>
	  </table>
</td>
    <td>
<table width="100%"  border="0" cellspacing="0" cellpadding="0" >
       <tr><td class="s" height="25" >
          <b>选择排序方式：</b>
          <img src="/images/icon_9x12_arrow.gif" width="9" height="12" align="absmiddle">
		  <%if show="trust_score" then
			 response.write"<a href=list.asp?typeid="&typeid&"&country1="&country&"&province="&sf&"&city="&city&"&datetime="&datetime&">按信息发布日期排序</a>&nbsp;&nbsp;"
			 response.write"<img src=""/images/icon_9x12_arrow.gif"" width=9 height=12 align=absmiddle>&nbsp;<font color=cc3300>按商贸通指数排序</font>"
			 else
			 response.write"<font color=cc3300>按信息发布日期排序</font>&nbsp;&nbsp;"
			 response.write"<img src=""/images/icon_9x12_arrow.gif"" width=9 height=12 align=absmiddle>&nbsp;<a href=list.asp?typeid="&typeid&"&country1="&country&"&province="&sf&"&city="&city&"&datetime="&datetime&"&show=trust_score>按商贸通指数排序</a>"
			end if%>
			</td>
       </tr>
        </table>
<TABLE width="100%" height=40 border="0" align="center" cellpadding="0" cellspacing="1">
  <TBODY>
    <TR>
      <TD bgcolor=E7E7E7 align=center width=15% class=S><IMG src='/images/arrow_19X19.gif' width="19" height="19" align="top"><font color=#666666>图片</font></TD>
      <TD bgcolor=E7E7E7 align=center width=40% class=S><font color=#666666>产品/公司</font></TD>
      <TD bgcolor=E7E7E7 align=center width=10% class=S>
        <table border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td><a href="javascript:win=window.open('../help/trust_score.asp','contact','width=550,height=450,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no');win.focus();"><img src="/images/icon_trust_score_help.gif" alt="什么是商贸通指数" width="19" height="19" border="0"></a></td>
            <td>
              <%response.write"<A href='list.asp?typeid="&typeid&"&country1="&country&"&province="&sf&"&city="&city&"&datetime="&datetime&"&show=trust_score' class=S><font color=#666666>按商贸通<br>指数排序</font></A>"%>
           </td>
          </tr>
      </table></TD>
      <TD bgcolor=E7E7E7 align=center width=15% class=S><font color=#666666>产地</font></TD>
      <TD bgcolor=E7E7E7 align=center width=15% class=S><font color=#666666>规格/型号</font></TD>
    </TR>
  </TBODY>
</TABLE>
<%
if rs.eof then
response.Write"<br><br><div align='center'>暂无此类产品信息</div><br><br>"
else
%>
<%do while not rs.eof and rowcount > 0%>
<TABLE width="100%" height=85 border=0 align="center" cellPadding=0 cellSpacing=1>
  <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=15%>
      <TABLE class=porductborder height=64 cellSpacing=0 cellPadding=0 width=64 
      border=0>
        <TBODY>
        <TR>
          <TD align=middle>
		  <%if rs("picture")<>"nopicture.gif" then%><A class=s 
      href="../show_product.asp?id=<%=rs("id")%>" 
      target=_blank><IMG src="../../picture/<%=rs("picture")%>" onload="javascript:if(this.height>this.width){this.height=64}else{this.width=64}" border=0> </A>
				<%else%>
	  <FONT class=C 
      color=#cecfce>无图</FONT><%end if%></TD></TR></TBODY></TABLE></TD>
      <TD width="40%" class=cate><A class=M 
      href="../show_product.asp?id=<%=rs("id")%>" 
      target=_blank><SPAN class=lh15><%=rs("cpmc")%></SPAN></A><BR>
        <FONT 
      color=#009900><%if rs("corflag")=1 then%><A href="../<%=rs("url")%>" target=_blank><FONT color=#666666><%=rs("qymc")%></font></A><%else%><A href="/noshinecompany/index.asp?id=<%=rs("id")%>" target=_blank><FONT color=#666666><%=rs("qymc")%></font></A><%end if%> 
	  <%if rs("corflag")=1 then%> <IMG height=25 src="/productshow/images/brand.gif" width=21 align=absMiddle border=0><%end if%> <FONT color=#666666><BR>
	  <%if rs("corflag")=1 then%>
	  <A href="../<%=replace(rs("url"),"index","product")%>" target=_blank><FONT color=#666666>该会员所有产品</FONT></A><%end if%> </FONT></FONT></TD>
      <TD align=middle width=10%><%if rs("corflag")=1 then%>
      <IMG height=14 alt=商贸通指数 
      src="/images/trust1.gif" width=22 align=absMiddle 
      border=0><BR>
      <a href=/trustadv/rempost.asp?id=<%=rs("id")%> target=_blank><FONT 
      style="FONT-WEIGHT: bold; FONT-SIZE: 13px; FONT-FAMILY: Verdana"><%=rs("trust_score")%></FONT></A>
      <%end if%>
      <%if rs("corflag")=0 then%>
      <%end if%></TD>
    <TD class=s align=middle width=15%><div align="center">
          <%if rs("country")="中国" then response.write""&rs("sf")&""&rs("city")&"" else response.write""&rs("country")&"" end if%> 
      </div></TD>
	<td  align=center width=15% class=s><%=rs("cpgg")%></td>
</TR></TBODY></TABLE><br>
<%
icolor=icolor+1
if icolor>1 then icolor=0
rowcount=rowcount-1
rs.movenext
loop
end if
%>
<TABLE width=100% border=0 align="center" cellPadding=1 cellSpacing=0 style="BORDER-TOP: #9C9A9C 1px solid;BORDER-Bottom: #9C9A9C 1px solid">
  <TBODY>
    <TR> 
      <TD> <TABLE cellSpacing=0 cellPadding=4 width="100%" 
        border=0>
          <TBODY>
            <TR> 
              <TD class=M noWrap align=middle><%=listPages("list.asp?typeid="&typeid&"&country1="&country&"&province="&sf&"&city="&city&"&datetime="&datetime&"&show="&show&"")%> </TD>
            </TR>
          </TBODY>
        </TABLE></TD>
    </TR>
  </TBODY>
</TABLE></td>
  </tr>
</table>
<!--#include virtual="/inc/end.asp"-->
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>