<title>生成产品二级分类</title><!--#include file="inc.asp"-->
<%

'过滤内容中出现的html代码，引用时用 “RemoveHTML(调用内容)”

Function RemoveHTML(strHTML) 
Dim objRegExp, Match, Matches 
Set objRegExp = New Regexp 
objRegExp.IgnoreCase = True 
objRegExp.Global = True 
'取闭合的<> 
objRegExp.Pattern = "<.+?>" 
'进行匹配 
Set Matches = objRegExp.Execute(strHTML) 
' 遍历匹配集合，并替换掉匹配的项目 
For Each Match in Matches 
strHtml=Replace(strHTML,Match.Value,"") 
Next 
RemoveHTML=strHTML 
Set objRegExp = Nothing 
End Function

'定义结束。


    '接受xmlhttp对象传过来的值^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
     id=Replace_Text(Request("id"))     '接受xmlhttp对象传过来的值
     If id<>"" Then
      '取出模版页和对标签赋值^^^^^^^^^^^^^^^^^^^^^^  start ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
     Dim fso,fmodify
 	 Set fso = YXFSO
 		Set rs=Server.CreateObject("adodb.recordset")
		rs.Open ("select productshow_type from [Websen_worldec_Temp] where yx_selected=1"),conn,1,1
	    If Not rs.Eof Then
 	     pencat=rs("productshow_type")        
	    End If
	 Set rs=Server.CreateObject("adodb.recordset")
		rs.Open ("SELECT * FROM Websen_class_2 where typeID="&id&""),conn,1,1
 	 If not rs.Eof Then
		 ttid=rs("typeID")
		 sttid=rs("sortID")
	   End If
	 rs.Close
	 If ttid="" Then 
	    ttid=0
	 End If
	 If sttid="" Then
	   sttid=0
	  End If
 		'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
		 
		 '商品比较标签#HOPE_BJ(typeid)#^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
		 '参数：typeid----1 为横向分单元格显示；0--为纵向分行显示
		 Function  HOPE_BJ(typeid)
			 If typeid<=0 Then 
			 typeid=0
			 Else
			 typeid=1
			 End If
			 strs=""
			 strs=" <script type='text/javascript' src='"&HOPE_InstallDir&"compare.js'></script><script language='javascript' >function zhu(str){ if(str.checked){ document.getElementById('searchwordb').value= document.getElementById('searchwordb').value+str.value; }else{ document.getElementById('searchwordb').value=document.getElementById('searchwordb').value.replace(str.value,''); } } </script> <div> <input type='text' id='searchwordb'  style='display:none'  value=''/><input type='text' id='installurlb'  style='display:none; width:12;height:1'  value="&HOPE_InstallDir&" />  <input type='text' id='typeid'  style='display:none; width:12;height:1'  value="&typeid&" /> </div> <div id='search_resultb'></div>"
			   HOPE_BJ=strs
		 End Function
		 '^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
     msg_per_page=15
 	 '查出详细信息只属于该二级分类的产品 ^^^^^^^^^^^^^^^^^^^^^
	Set rs=Server.CreateObject("adodb.recordSet")
     rs.Open ("select Websen_productshow.*,Websen_corporation.id as corid,Websen_corporation.flag as corflag,Websen_corporation.qymc,Websen_corporation.tm,Websen_corporation.[user],Websen_corporation.msn,Websen_corporation.gradeid,Websen_corporation.tm,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_productshow.typeid="&ttid&" and  Websen_corporation.id=Websen_productshow.gsid  and Websen_productshow.flag=1 order by Websen_corporation.trust_score,Websen_productshow.idate desc"),conn,1,1
    	 '对具体的供应信息进行分页^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
     If not rs.Eof Then
	   totalrec=RS.RecordCount'总记录条数
       rs.Pagesize=msg_per_page  '每页数
       mpage2=rs.Pagecount     '得到总页数
	   rowcount=msg_per_page
      End If
	 '^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 %>
     <!--#include file="../inc/headpage_html.asp"-->
<%
 	Set rssort1=Server.CreateObject("adodb.recordSet")
		rssort1.Open ("select * from Websen_class_1 where sortID="&sttid&""),conn,1,1
 		Set rssort=Server.CreateObject("adodb.recordSet")
		rssort.Open ("select * from Websen_class_2 where typeID="&ttid&""),conn,1,1
 		Set rstype=Server.CreateObject("adodb.recordSet")
		rstype.Open ("select * from Websen_class_3 where typeid="&ttid&""),conn,1,1
		If rstype.Eof Then
  		'^下级类别导航^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
		HOPE_Type=HOPE_Type&""
		Else
	    HOPE_type=HOPE_type&"<script src='"&HOPE_InstallDir&"autokind/autokind.js'></script><input type='text' id='installurltr'  style='display:none; width:12;height:1'  value="&HOPE_InstallDir&"autokind/pro_3.asp>"
		HOPE_Type=HOPE_Type&"<div class='yoleft'><img src='#HOPE_InstallDir#images/indexpoint.gif' width='5' height='9' /> 按<strong>分类</strong>筛选：</div><div class='yorift'><table width='600' border='0' cellspacing='0' cellpadding='0'><tr>"
		
        do while not rstype.Eof
		
		'^查出第三级所含的产品数量^^^^^^^^^^ 
	        If totalrec="" Then
		      totalrec=0 
			End If	
             HOPE_TotalRec="(<font color=red>"&totalrec&"</font>)" 
		'^^^^^^^^^^^^^^^^^^^^^^^^^^ 
		 
		HOPE_Type=HOPE_Type&"<td height=10 valign=top><a class=c href='"&HOPE_InstallDir&"productshow/offerlist/"&rstype("sortid")&"-"&rstype("typeid")&"-"&rstype("typeid_2")&".html' onclick='AjaxSearchtr("&rstype("typeid_2")&")'>"&rstype("typename_2")&"</a>"
		HOPE_Type=HOPE_Type&"<font class=s> "&thiCount&"</font></td>"
		a=a+1
		If a=5 Then
		HOPE_Type=HOPE_Type&"</tr><tr>"
		a=0
		End If
		rstype.movenext
		loop
		rstype.Close
		HOPE_Type=HOPE_Type&"</tr></table></div>"
		End If
		 
		'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
		
		 
		 
		 '^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
		If rs.Eof Then
		HOPE_body=HOPE_body&"<br><br><div align='center' class=s>暂无此类产品信息</div><br>"
		Else
	
		 jjcom=1
		  i=1
		HOPE_body=HOPE_body&"<script type='text/javascript' src='"&HOPE_InstallDir&"autokind/showmsgrole.js'></script><script   language='vbscript'>sub AjaxSearchmsg() end  sub </script><input type='text' id='installurlmsg'   style='display:none; width:12;height:1'  value='"&HOPE_InstallDir&"autokind/showmsgrole.asp'/>"
		do while not rs.Eof  and rowcount > 0
		 jjcom = jjcom + 1
		If jjcom mod 2 =0 Then 
		colors="#FFFFFF"
		Else
		colors="#F6F6F6"
		End If
			HOPE_body=HOPE_body&"<table border=0  width='100%' cellpadding=0 cellspacing=0 ><tr><td><table width=""100%""  border=""0"" cellpadding=""0"" cellspacing=0>"

		HOPE_body=HOPE_body&"<tr bgcolor="&colors&"><TD align=center width='5%' class='peyen'><input type='checkbox' name='id' value='"&rs("id")&",' onclick='zhu(this);' /></td>"
		
		If rs("picture")<>"../../UploadFile/nopicture.gif" or rs("picture")<>"" Then
		HOPE_body=HOPE_body&"<td class='peyen'><A href='"&HOPE_InstallDir&"productshow/offerdetail/"&rs("sortid")&"-"&rs("typeid")&"-"&rs("typeid_2")&"-"&rs("id")&".html' target=_blank ><IMG src='"&HOPE_InstallDir&"Vipcom/"&rs("user")&"/"&rs("picture")&"'  border=0  height=100   width=100 ></A></td>"
		 Else
		HOPE_body=HOPE_body&"<div class='bick_photo'>无图</div>"
		End If
		
		HOPE_body=HOPE_body&"<td width='2%' class='peyen'>&nbsp;</td>"&VbCrLf
		HOPE_body=HOPE_body&"<TD width='50%' valign='top' style=' line-height:160%; padding-top: 5px' class='peyen'>"&VbCrLf
		HOPE_body=HOPE_body&"<a href='"&HOPE_InstallDir&"productshow/offerdetail/"&rs("sortid")&"-"&rs("typeid")&"-"&rs("typeid_2")&"-"&rs("id")&".html' target=_blank class=b>"&left(rs("Cpmc"),20)&"</a>&nbsp;<font color=#C5C8C9>["&year(rs("idate"))&"-"&month(rs("idate"))&"-"&day(rs("idate"))&"]</font><BR>[摘要]"&Left(RemoveHTML(rs("xxsm")),40)&"......<br>" 
		
 '--是否使用的名片页------------------------------------------------------------
	   set rsmp=server.CreateObject("adodb.recordset")
	   sqlmp="select * from Websen_vipgrade where roleid="&rs("gradeid")
	   rsmp.open sqlmp,conn,1,1
	   if not rsmp.eof  then
	   if instr(rsmp("rolelist"),"qw")>0 then	
	   		If is2weburl=1 Then
		HOPE_body=HOPE_body&" <A href='http://"&rs("user")&"."&weburl1&"' target=_blank><b>"&rs("qymc")&"</b></a>"&VbCrLf
		Else
		  HOPE_body=HOPE_body&"   <A href='"&HOPE_InstallDir&"vipcom/"&rs("user")&"/' target=_blank><b>"&rs("qymc")&"</b></a>"&VbCrLf
			End If
			Else
		 HOPE_body=HOPE_body&" <A href='"&HOPE_InstallDir&"Ptcom/"&rs("user")&".html' target=_blank><b>"&rs("qymc")&"</b></a>"&VbCrLf
		End If
 			rsmp.close
		  end if
		  set rsmp1=server.CreateObject("adodb.recordset")
	   sqlmp1="select * from Websen_vipgrade where roleid="&rs("gradeid")
	   rsmp1.open sqlmp1,conn,1,1
	   FileFlag=rsmp1("FileFlag")
	   if not rsmp1.eof  then
	
	rsmp1.close
	end if
		  
	'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
       HOPE_body=HOPE_body&"<TD width=""5%"" align=center class='peyen'>&nbsp;</td>"
 		HOPE_body=HOPE_body&"<TD width=""11%"" style=' padding-left: 10px' class='peyen'>"&vbCrlf
		HOPE_body=HOPE_body&"<img border=""0"" src=""../../UploadFile/vipgrade/"&FileFlag&""" width=20>"
		HOPE_body=HOPE_body&"</TD>"&vbCrlf
	    HOPE_body=HOPE_body&"<td  width='12%' align=center style="" padding-right: 10px""  class='peyen'><img src=""../../images/trust.gif"" width=22 height=14 border=0><br>"&rs("trust_score")&"</td><td width='15%' style=' text-align: right' class='peyen'>"
		
	If rs("tm")<>"" then	
HOPE_body=HOPE_body&"<a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin="&rs("tm")&"Site=www.websen.net&Menu=yes><img border=0 SRC=#HOPE_InstallDir#images/anlineqt.gif alt=点击这里给我发消息></a><BR><BR>"&rs("Cpcd")&""
    End if

		HOPE_body=HOPE_body&"</td></TR>" 
         HOPE_body=HOPE_body&"</table></td></tr></table>"

	    i=i+1
 	   icolor=icolor+1
	If icolor>1 Then icolor=0
	   rowcount=rowcount-1
	rs.Movenext
	loop
	End If
	
	
'进行分页处理^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^		
			HOPE_body=HOPE_body&"<br><TABLE width='100%' border=0 align=center cellPadding=1 cellSpacing=0 style='BORDER-TOP: #9C9A9C 1px solid'><tr><td height='5px'></td></tr><tr><td valign=top><img src='#HOPE_InstallDir#images/list_rt_slt_ico_2.gif' width='14' height='16' />&nbsp;<input type='image' onclick='AjaxSearchb();' src='#HOPE_InstallDir#images/dbcp.gif' width=' 69' height='21' value='我要进行产品比较' />&nbsp;请选择要比较的项</td></tr></table><TABLE cellSpacing=0 cellPadding=0 width='100%' height='30' border=0 class='zheyen'>"&vbCrlf
			HOPE_body=HOPE_body&"<TBODY>"&vbCrlf
			HOPE_body=HOPE_body&"<TR>"&vbCrlf
			HOPE_body=HOPE_body&"<TD  align='right' class='bgeyen'>"&vbCrlf
		If not (rs.Eof and rs.Bof) Then
			gopage=currentpage2
			totalpage=mpage2
			blockPage=Int((gopage-1)/10)*10+1
			HOPE_body=HOPE_body&"&nbsp;&nbsp;共 "&totalrec&" 条信息，每页 "&msg_per_page&" 条信息，共 "&mpage2&" 页，浏览&nbsp;"
		If LCase(Request.ServerVariables("HTTPS")) = "off" Then 
			strTemp = "http://" 
		Else 
			strTemp = "https://" 
		End If 
			strTemp = strTemp & CheckStr(Request.ServerVariables("SERVER_NAME")) 
		If Request.ServerVariables("SERVER_PORT") <> 80 Then strTemp = strTemp & ":" & CheckStr(Request.ServerVariables("SERVER_PORT")) 
			strTemp = strTemp & CheckStr(Request.ServerVariables("URL"))
			lenstrTemp=Len(strTemp)+1	
		If Instr(Left(linkfile,lenstrTemp),"?")>0 Then 
		
		   i=1
	    Do Until i > 10 or blockPage > mpage2
		If blockPage=Int(gopage) Then
		   HOPE_body=HOPE_body&"<font color=#FF0000>"&blockPage&"</font>"
		Else
		   HOPE_body=HOPE_body&" <a href="&sttid&"-"&ttid&"-p"&blockPage&".html onclick=AjaxSearchtrp("&ttid&","&blockPage&")>"&blockPage&"</a> "
		End If
			blockPage=blockPage+1
			i = i + 1
		Loop
			HOPE_body=HOPE_body&" 直接到第 "
			HOPE_body=HOPE_body&"<select onchange=if(this.options[this.selectedIndex].value!=''){AjaxSearchtrp("&ttid&",this.options[this.selectedIndex].index+1);location.href=this.options[this.selectedIndex].value;}>"
		for i=1 to totalpage
			HOPE_body=HOPE_body&"<option value="&sttid&"-"&ttid&"-p"&i&".html"
		If i=gopage Then HOPE_body=HOPE_body&"   selected"
			HOPE_body=HOPE_body&">"&i&"</option>"
		next
			HOPE_body=HOPE_body&"</select>"
			HOPE_body=HOPE_body&" 页"
			
		Else
			
		   i=1
		Do Until i > 10 OR blockPage > mpage2
		If blockPage=int(gopage) Then
		    HOPE_body=HOPE_body&"<font color=#FF0000>"&blockPage&"</font>"
		Else
		    HOPE_body=HOPE_body&" <a href="&sttid&"-"&ttid&"-p"&blockPage&".html onclick=AjaxSearchtrp("&ttid&","&blockPage&")>"&blockPage&"</a> "
		End If
			blockPage=blockPage+1
			i = i + 1
		Loop
			HOPE_body=HOPE_body&" 直接到第 "
			HOPE_body=HOPE_body&"<select onchange=if(this.options[this.selectedIndex].value!=''){AjaxSearchtrp("&ttid&",this.options[this.selectedIndex].index+1);location.href=this.options[this.selectedIndex].value;}>"
		for i=1 to totalpage
			HOPE_body=HOPE_body&"<option value="&sttid&"-"&ttid&"-p"&i&".html"
		If i=gopage Then HOPE_body=HOPE_body&"   selected"
			HOPE_body=HOPE_body&">"&i&"</option>"
		next
			HOPE_body=HOPE_body&"</select>"
			HOPE_body=HOPE_body&" 页"
			
		End If
		    
		End If
		
			HOPE_body=HOPE_body&"</TD>"&vbCrlf
			HOPE_body=HOPE_body&"</TR>"&vbCrlf
			HOPE_body=HOPE_body&"</TBODY>"&vbCrlf
			HOPE_body=HOPE_body&"</TABLE>"&vbCrlf
		HOPE_body=HOPE_body&"<script language='javascript' src="&HOPE_InstallDir&"autokind/autokind_p.js></script><input type='text' id='installurltrp'  style='display:none; width:12;height:1'  value='"&HOPE_InstallDir&"autokind/pro_2_page.asp' />"
    		   HOPE_Title=rssort("typename") '网页标题头
			   HOPE_TradeGo="<a href='"&HOPE_InstallDir&"'>首页</a> > <a href='"&HOPE_InstallDir&"productshow/'>产品库</a> > <a href='"&HOPE_InstallDir&"productshow/trade/"&rssort1("sortid")&".html'>"&rssort1("sort")&"</a> > "&HOPE_Title
		'属于该行业的推荐的网盛通会员的产品^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
			   
		Set rstjy=Server.CreateObject("ADODB.Recordset")
		 sqltjy="select  top  15  Websen_productshow.id,Websen_productshow.sortid,Websen_productshow.typeid,Websen_productshow.typeid_2,Websen_productshow.Cpmc from Websen_productshow,Websen_corporation where Websen_productshow.GsID=Websen_corporation.id and Websen_corporation.Tjbz like '%0%' and Websen_productshow.flag=1  and Websen_productshow.sortid="&sttid&" and  Websen_productshow.typeid="&ttid&" and Websen_productshow.typeid_2=0 and Websen_corporation.flag=1  order by Websen_corporation.trust_score desc,Websen_productshow.idate desc"
  		    rstjy.Open sqltjy,conn,1,1
 		   If rstjy.Eof Then
		   tjcompany="暂无"
		   End If
		   If Not rstjy.Eof Then 
			tjcompany=""
		   End If
		   If Not rstjy.Eof Then 
			tji=1
			tjcompany=""
		   Do While Not rstjy.Eof 
			tjcompany=tjcompany&"&nbsp;．<a href='"&HOPE_InstallDir&"productshow/offerdetail/"&rstjy("sortid")&"-"&rstjy("typeid")&"-"&rstjy("typeid_2")&"-"&rstjy("id")&".html'  target=_blank>"&rstjy("cpmc")&"</a><br>"
		   If tji=15 Then	   Exit Do
		   tji=tji+1
		   rstjy.Movenext
		   Loop
		   rstjy.Close
		   End If 
 		HOPE_TjCom=tjcompany
    	    rs.Close
		rssort.Close
		rssort1.Close
       '取出模版页和对标签赋值^^^^^^^^^^^^^^^^^^^^^^  end  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  		  If fso.FileExists(server.MapPath(HOPE_InstallDir&"productshow/trade/"&sttid&"-"&ttid&".html")) Then
		  If kindtime<>"0" then 
     		Set fmodify = fso.GetFile(server.MapPath(HOPE_InstallDir&"productshow/trade/"&sttid&"-"&ttid&".html"))
 		    ShowDateModified = fmodify.DateLastModified
 		    dtime=DateDiff("s",ShowDateModified,now())
		    mtime=dtime/60
  			  If trim(mtime)>=kindtime then
  				pencat=Hope_HtmlResult(pencat)
				Set fout = fso.CreateTextFile(Server.Mappath(HOPE_InstallDir&"productshow/trade/"&sttid&"-"&ttid&".html"))
				'如果文件存在就按时间进行更新^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
				fout.Write pencat&"<script src='"&HOPE_InstallDir&"autokind/pro_2.asp?id="&id&"'></script>"
				fout.Close
			  End If
			  End If  
  		  Else
           pencat=Hope_HtmlResult(pencat)
  		   Set foutc = fso.CreateTextFile(Server.Mappath(HOPE_InstallDir&"productshow/trade/"&sttid&"-"&ttid&".html"))
		   '如果文件存在就按时间进行更新^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 		   foutc.Write pencat&"<script src='"&HOPE_InstallDir&"autokind/pro_2.asp?id="&id&"'></script>"
		   foutc.Close
 		 End If	
	  Set fso = nothing
      conn.Close
     Set conn=nothing
  End If
%>