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

sql1="select qymc,click,email,phone from corporation where id="&id&" and flag=1" 
set rs1=conn.execute(sql1)
if rs1.eof or rs1.bof then
response.write"<SCRIPT language=JavaScript>alert('对不起，该用户不存在或已非商贸通会员！');"
response.write"javascript:window.close();</SCRIPT>" 
else

conn.execute("update corporation set click=click+1 where id="&id&"") 

bigclassid=replace_text(request("bigclassid"))
smallclassid=replace_text(request("smallclassid"))

sql="select * from productshow where gsid="&id&" and flag=1"
if  Chkrequest(bigclassid) then sql=sql&" and bigclassid="&bigclassid&""
if  Chkrequest(smallclassid) then sql=sql&" and smallclassid="&smallclassid&""
sql=sql&" order by id desc"
Set rs= Server.CreateObject("ADODB.Recordset") 
rs.open sql,conn,1,1

msg_per_page=5 '定义每页显示记录条数

%>
<!--#include file="../../inc/headpage.asp"-->
<html>
<head>
<title><%=rs1("qymc")%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../../css/main.css" rel=stylesheet type=text/css>

<script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/link_3_on.gif','images/link_4_on.gif','images/link_5_on.gif','images/info_1_on.gif')">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td background="images/blue_tile.gif" height="64"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <TD class=x 
          style="FONT-WEIGHT: bold; FILTER: dropshadow(color=#C2C2C2,offx=1,offy=1,positive=-1); COLOR: #FFFFFF; TEXT-DECORATION: none" 
          align=middle height="60"><%=rs1("qymc")%></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td height="18">&nbsp;</td>
          <td height="18">&nbsp;</td>
        </tr>
        <tr align="right"> 
          <td colspan="2"> <table width="627" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="90" valign="bottom"><a href="introduce.asp?id=<%=id%>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','images/link_1_on.gif',1)"><img src="images/link_1.gif" name="Image11" width="90" height="23" border="0"></a></td>
                <td width="90" valign="bottom"><a href="product.asp?id=<%=id%>"><img src="images/link_2_on.gif" width="90" height="23" border="0"></a></td>
                <td width="90" valign="bottom"><a href="tradeinfo.asp?id=<%=id%>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image22','','images/info_1_on.gif',1)"><img src="images/info_1.gif" name="Image22" width="90" height="23" border="0"></a></td>
                <td width="90" valign="bottom"><a href="work.asp?id=<%=id%>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image19','','images/link_3_on.gif',1)"><img src="images/link_3.gif" name="Image19" width="90" height="23" border="0"></a></td>
                <td width="90" valign="bottom"><a href="contact.asp?id=<%=id%>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image20','','images/link_4_on.gif',1)"><img src="images/link_4.gif" name="Image20" width="90" height="23" border="0"></a></td>
                <td width="90" valign="bottom"><a href="link.asp?id=<%=id%>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image21','','images/link_5_on.gif',1)"><img src="images/link_5.gif" name="Image21" width="90" height="23" border="0"></a></td>
                <td width="87" valign="bottom"><a href="index.asp?id=<%=id%>"><img src="images/goindex.gif" width="87" height="23" border="0"></a></td>
              </tr>
            </table></td>
        </tr>
        <tr align="right"> 
          <td height="8" colspan="2" bgcolor="#999999"><img src="images/gray_pix.gif" width="8" height="8"></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td bgcolor="#d6e0f5"> 
      <table width="100%" height="400" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="150" valign="top"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td bgcolor="#000000"> 
                  <p>&nbsp;</p>
                  <p>&nbsp;</p>
                </td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr> 
                <td><a href="introduce.asp?id=<%=id%>"><img src="images/link1_blue.gif" width="150" height="30" border="0"></a></td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr> 
                <td><a href="product.asp?id=<%=id%>"><img src="images/link2_blue_on.gif" width="150" height="30" border="0"></a></td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr> 
                <td><a href="tradeinfo.asp?id=<%=id%>"><img src="images/info_blue.gif" width="150" height="30" border="0"></a></td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr> 
                <td><a href="work.asp?id=<%=id%>"><img src="images/link3_blue.gif" width="150" height="30" border="0"></a></td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr> 
                <td><a href="contact.asp?id=<%=id%>"><img src="images/link4_blue.gif" width="150" height="30" border="0"></a></td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr>
                <td><a href="link.asp?id=<%=id%>"><img src="images/link5_blue.gif" width="150" height="30" border="0"></a></td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" height="1"><img src="images/pixel.gif" width="1" height="1"></td>
              </tr>
              <tr>
                <td><Br><br>
                  <a href="<%=weburl%>" target="_blank"><img src="../../images/clickme.gif" width="150" height="30" border="0"></a></td>
              </tr>
            </table>
            
          </td>
          <td bgcolor="#FFFFFF" valign="top">
<br>
<script language = "JavaScript"> 
sallt=new Array();
<%
Dim ii
ii=0
set rs8=conn.execute("select * from productclass_1 where gsid="&id&"")
do while not rs8.eof
%>
sallt[<%=ii%>]=new Array("<%=rs8("smallclassname")%>","<%=rs8("bigclassid")%>","<%=rs8("smallclassid")%>");
<%
ii=ii+1
rs8.movenext
loop
rs8.close
%>
function changeselect1(selvalue)  
   { 
      document.form.smallclassid.length=0;  
      var selvalue=selvalue;
      var ii;
      for(ii=0;ii<sallt.length;ii++) 
	{
	    if(sallt[ii][1]==selvalue) 
      		{
  	var newOption1=new Option(sallt[ii][0],sallt[ii][2]);
	document.all.smallclassid.add(newOption1);
		}
	}
}
</script> 
<%
if bigclassid>"" and smallclassid>"" then
set rs3=conn.execute("select productclass_1.*,productclass.* from productclass_1,productclass where productclass_1.smallclassid="&smallclassid&" and productclass.bigclassid=productclass_1.bigclassid and productclass.gsid="&id&" and productclass_1.gsid="&id&"")
%>

<TABLE cellSpacing=0 cellPadding=5 width="90%" align=center border=0>
              <FORM name=form action="product.asp?id=<%=id%>" method=post>
        <TBODY>
        <TR>
                    <TD bgColor=#f0f0f0><FONT 
            color=#cc0000><STRONG>按系列查看产品:</STRONG></FONT> 
				<select name="bigclassid" onChange="changeselect1(document.form.bigclassid.options[document.form.bigclassid.selectedIndex].value)" size="1">
<option selected value="<%=rs3("bigclassid")%>"><%=rs3("bigclassname")%></option> 
<%
set rs12=conn.execute("select * from productclass where bigclassid<>"&rs3("bigclassid")&" and gsid="&id&"")
do while not rs12.eof
response.write "<option value='"&rs12("bigclassid")&"'>"&rs12("bigclassname")&"</option>"&chr(13)+chr(10)
rs12.movenext
loop
rs12.close
%>
                            
</select> 
<select name="smallclassid"> 
<option selected value="<%=rs3("smallclassid")%>"><%=rs3("smallclassname")%></option> 
<%
set rs4=conn.execute("select * from productclass_1 where bigclassid="&rs3("bigclassid")&" and smallclassid<>"&rs3("smallclassid")&" and gsid="&id&"")
do while not rs4.eof
response.write "<option value='"&rs4("smallclassid")&"'>"&rs4("smallclassname")&"</option>"&chr(13)+chr(10)
rs4.movenext
loop
rs4.close
rs3.close
%>
</select> <INPUT type=submit value=" 查看 " name=Submit22>
</TD></TR></TBODY></FORM></TABLE>
<%
else
%>

<TABLE cellSpacing=0 cellPadding=5 width="90%" align=center border=0>
              <FORM name=form action="product.asp?id=<%=id%>" method=post>
        <TBODY>
        <TR>
                    <TD bgColor=#f0f0f0><FONT 
            color=#cc0000><STRONG>按系列查看产品:</STRONG></FONT> 
				<select name="bigclassid" onChange="changeselect1(document.form.bigclassid.options[document.form.bigclassid.selectedIndex].value)" size="1"> 
<option selected value="">--请选择产品大类--</option> 
<%
set rs7=conn.execute("select * from productclass where gsid="&id&"")
do while not rs7.eof
response.write "<option value='"&rs7("bigclassid")&"'>"&rs7("bigclassname")&"</option>"&chr(13)+chr(10)
rs7.movenext
loop
rs7.close
%>
</select> 
<select name="smallclassid"> 
<option selected value="">--请选择产品小类--</option> 
</select> <INPUT type=submit value=" 查看 " name=Submit22></TD></TR></TBODY></FORM></TABLE>
<%
end if
%>
<Br>
<TABLE width="90%" border=0 align="center" cellPadding=4 cellSpacing=0>
              <TBODY><TR>
<TD class=M style="BACKGROUND-REPEAT: no-repeat" 
background=images/bg_title.gif>&nbsp;</TD></TR></TBODY></TABLE>
<%
if rs.eof or rs.bof then
response.write"<div align=center>暂未添加产品<div>"
else
do while not rs.eof and rowcount > 0
%>
            
            <TABLE width="90%" 
        border=0 align="center" cellPadding=8 cellSpacing=0 <%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%>'">
              <TBODY>
        <TR>
          <TD vAlign=top width="23%"><BR>

            <TABLE 
            style="BORDER-RIGHT: #cecfce 1px solid; BORDER-TOP: #cecfce 1px solid; BACKGROUND: #cecfce; BORDER-LEFT: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px solid" 
            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="showproduct.asp?id=<%=id%>&bigclassid=<%=bigclassid%>&smallclassid=<%=smallclassid%>&proid=<%=rs("id")%>"> 
                            <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=#ffffff>无图</FONT>
                            <%end if%>
                            
</TD></TR></TBODY></TABLE>
</TD>
          <TD vAlign=top width="77%"><BR><B><A 
            href="showproduct.asp?id=<%=id%>&bigclassid=<%=bigclassid%>&smallclassid=<%=smallclassid%>&proid=<%=rs("id")%>"><%=rs("cpmc")%></A></B><BR>
                    型号：<%=rs("cpgg")%><BR> <%=left(rs("xxsm"),40)%>...<BR><A class=S 
            href="showproduct.asp?id=<%=id%>&bigclassid=<%=bigclassid%>&smallclassid=<%=smallclassid%>&proid=<%=rs("id")%>">[查看详细资料]</A> 
            <BR><BR></TD></TR></TBODY></TABLE>
            <%
icolor=icolor+1
if icolor>1 then icolor=0
rowcount=rowcount-1
rs.movenext
loop
end if
%>
            <TABLE width="90%" border=0 align="center" cellpadding=2 cellspacing=0 style="BORDER-TOP: #9C9A9C 1px solid;BORDER-Bottom: #9C9A9C 1px solid">
              <TBODY>
        <TR>
          <TD class=S align=right bgColor=#f0f0f0><%=listPages2("product.asp?id="&id&"&bigclassid="&bigclassid&"&smallclassid="&smallclassid&"")%>　 
        </TD></TR></TBODY></TABLE>
<Br>		
</td></tr></table>
      
    </td>
  </tr>
</table>

 <table width=100% border=0 cellpadding=2 cellspacing=0 style="BORDER-TOP: #9C9A9C 1px solid;BORDER-Bottom: #9C9A9C 1px solid">
  <tr align="center"> 
    <td bgcolor="D6E0F5"><br>
       您是第 <%=rs1("click")%> 位访客 欢迎您的光临! 最佳显示分辨率 800*600<br>
      <%=rs1("qymc")%>版权所有<BR>
      联系电话:<%=rs1("phone")%>　 Email:<a href="mailto:<%=rs1("email")%>"><%=rs1("email")%></a> 
      <br>
      技术支持：<a href=<%=weburl%> target=_blank><%=webname%></a> 热线电话：<%=hottel%></td>
  </tr></table>
</BODY>
</HTML>
<%
end if
rs2.close
set rs2=nothing
rs1.close
set rs1=nothing
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
