<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 tradeinfo_type2 from [Websen_worldec_Temp] where yx_selected=1"),conn,1,1
	    If Not rs.Eof Then
 	     pencat=rs("tradeinfo_type2")        
	    End If
	 Set rs=Server.CreateObject("adodb.recordset")
		rs.Open ("SELECT * FROM Websen_class_3 where typeid_2="&id&""),conn,1,1
 	 If not rs.Eof Then
		 ttid=rs("typeid_2")   '第三类别
		  tytid=rs("typeID")   '第二类别
		  sttid=rs("sortID")   '第三类别
	   End If
	 rs.Close
		 If ttid="" Then 
		 ttid=0
		 End If 
		 If tytid="" Then 
		 tytid=0 
		 End If 
		 If sttid="" Then 
		 sttid=0
		 End If 
 		'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
     msg_per_page=15
 	 '查出详细信息只属于该二级分类的产品 ^^^^^^^^^^^^^^^^^^^^^
	 Set rs=Server.CreateObject("adodb.recordset")
 		rs.Open ("select Websen_info.*,Websen_corporation.id,Websen_corporation.msn,Websen_corporation.msn,Websen_corporation.flag as corflag,Websen_corporation.qymc,Websen_corporation.tm,Websen_corporation.gradeid,Websen_corporation.[user],Websen_corporation.country,Websen_corporation.sf,Websen_corporation.city,Websen_corporation.web,Websen_corporation.url,Websen_corporation.trust_score from Websen_Info,Websen_corporation where Websen_info.typeid_2="&ttid&" and Websen_info.type='卖' and Websen_corporation.id=Websen_info.gsid and Websen_info.flag=1 order by Websen_corporation.trust_score desc,Websen_info.dateandtime 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="&tytid&""),conn,1,1
 		Set rssort2=Server.CreateObject("adodb.recordset")
		rssort2.Open ("select * from Websen_class_3 where typeID_2="&ttid&""),conn,1,1
           i=1
  	        HOPE_body=HOPE_body&"<SCRIPT language=javascript>function killErrors(){return true;}window.onerror = killErrors;</SCRIPT>"
 		If rs.Eof Then
		    HOPE_body=HOPE_body&"<br><br><div align='center' class='s'>暂无此类具体供应信息</div><br>"
		Else
	    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
		
	     	HOPE_body=HOPE_body&"<TABLE width='100%' height=85 border=0 align=center cellPadding=0 cellSpacing=0>"&vbCrlf
		    HOPE_body=HOPE_body&"<TBODY>"&vbCrlf
		    HOPE_body=HOPE_body&"<TR ID=compareColor"&i&""
		If icolor=0 Then 
		    HOPE_body=HOPE_body&" bgColor=#ffffff" 
		Else 
		    HOPE_body=HOPE_body&" bgColor=#f6f6f6" 
		End If
		
		   HOPE_body=HOPE_body&">"&vbCrlf
		   HOPE_body=HOPE_body&"<TD align=middle width='5%' class='peyen'>"&vbCrlf 
		   HOPE_body=HOPE_body&"<TABLE height=64 cellSpacing=0 cellPadding=0 width=64 border=0>"&vbCrlf
		   HOPE_body=HOPE_body&"<TBODY>"&vbCrlf
		   HOPE_body=HOPE_body&"<TR>"&vbCrlf 
		   HOPE_body=HOPE_body&"<TD align=middle>"&vbCrlf 
			
			
		If rs("draw")<>"" Then
		
		   HOPE_body=HOPE_body&"<A href="&HOPE_InstallDir&"tradeinfo/offerdetail/"&rs("sortid")&"-"&rs("typeid")&"-"&rs("typeid_2")&"-"&rs("info_id")&".html target=_blank>" 
		  HOPE_body=HOPE_body&"<IMG src='"&HOPE_InstallDir&"Vipcom/"&rs("user")&"/"&rs("draw")&"'  width='100' height='100'  border=0> </A>" 
		Else
		  HOPE_body=HOPE_body&<div class='bick_photo'>无图</div>
		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></TD>"&vbCrlf
		  HOPE_body=HOPE_body&"<TD width='3%' class='peyen'>&nbsp;</TD>"&vbCrlf
		HOPE_body=HOPE_body&"<TD width='40%' valign='top' style=' line-height:160%; padding-top: 12px' class='peyen'><A href="&HOPE_InstallDir&"tradeinfo/offerdetail/"&rs("sortid")&"-"&rs("typeid")&"-"&rs("typeid_2")&"-"&rs("info_id")&".html target=_blank class=b>"&Left(rs("showname"),20)&"</A>&nbsp;<FONT color=#000000>["&rs("dateandtime")&"]</FONT><BR>[摘要]"&Left(RemoveHTML(rs("content")),40)&"......<br>"&vbCrlf
 '--是否使用的名片页------------------------------------------------------------
	   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 class=s>"&rs("qymc")&"</A>"
	Else
		HOPE_body=HOPE_body&"<A href='"&HOPE_InstallDir&"vipcom/"&rs("user")&"/'  target=_blank class=s>"&rs("qymc")&"</A>"
	End If
		Else
	
		HOPE_body=HOPE_body&"<A href='"&HOPE_InstallDir&"Ptcom/"&rs("user")&".html'   target=_blank class=s>"&rs("qymc")&"</A>"
	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
	   if instr(rsmp1("rolelist"),"qw")>0 then			
	   '用于二级域名处理^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

	end if
	rsmp1.close
	end if
	'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   

        HOPE_body=HOPE_body&"<br><a href='#HOPE_InstallDir#member/getprice/message.asp?info_id="&rs("info_id")&"' target='_blank'><img src='#HOPE_InstallDir#images/wansen_xj.gif' width='69' height='21' border='0' /></a>&nbsp;<a href='#HOPE_InstallDir#Vipcom/"&rs("user")&"/Contact.htm' target='_blank'><img src='#HOPE_InstallDir#images/wansen_lx.gif' width='69' height='21' border='0' /></a></TD>"&vbCrlf
       HOPE_body=HOPE_body&"<TD width=""15%"" style=' text-align: right' class='peyen'><img border=""0"" src=""../../UploadFile/vipgrade/"&FileFlag&""" width=20></td>"
 		HOPE_body=HOPE_body&"<TD width=""13%"" align=center style="" padding-right: 10px"">"&vbCrlf
		HOPE_body=HOPE_body&"<img src=""../../images/trust.gif"" width=22 height=14 border=0><br>"&rs("trust_score")&"<br> "
		HOPE_body=HOPE_body&"</TD>"&vbCrlf
		HOPE_body=HOPE_body&"<TD align=middle width='17%' valign='top' class='peyen'>"&vbCrlf
		HOPE_body=HOPE_body&"<div style='padding-top: 15px; text-align: right'>"&vbCrlf
		
    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>"
    End if
	
	If rs("country")="中国" Then 
		HOPE_body=HOPE_body&""&rs("sf")&"省-"&rs("city")&"市" 
	Else 
		HOPE_body=HOPE_body&""&rs("country")&"" 
	End If
	
		HOPE_body=HOPE_body&"</div></TD>"&vbCrlf
		HOPE_body=HOPE_body&"<TD class=text13 align=middle width='5%' > "&vbCrlf
		HOPE_body=HOPE_body&"</TD></TR>"&vbCrlf
		HOPE_body=HOPE_body&"</TBODY>"&vbCrlf
		HOPE_body=HOPE_body&"</TABLE>"&vbCrlf
	    i=i+1
 	   icolor=icolor+1
	If icolor>1 Then icolor=0
	   rowcount=rowcount-1
	rs.Movenext
	loop
	End If
		 
'进行分页处理^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^		
			HOPE_body=HOPE_body&"<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="&sortid&"-p"&blockPage&".html onclick=AjaxSearchtrp("&sortid&","&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("&sortid&",this.options[this.selectedIndex].index+1);location.href=this.options[this.selectedIndex].value;}>"
		for i=1 to totalpage
			HOPE_body=HOPE_body&"<option value="&sortid&"-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="&sortid&"-p"&blockPage&".html onclick=AjaxSearchtrp("&sortid&","&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("&sortid&",this.options[this.selectedIndex].index+1);location.href=this.options[this.selectedIndex].value;}>"
		for i=1 to totalpage
			HOPE_body=HOPE_body&"<option value="&sortid&"-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
			
			'Startinfo=((gopage-1)*msg_per_page)+1
			'Endinfo=gopage*msg_per_page
		'If Endinfo>totalrec Then Endinfo=totalrec
		   
		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/trade_3_page.asp' />"&vbCrlf
                HOPE_Title=rssort2("typename_2")&""      '网页标题头
                HOPE_Sort="<a href='"&HOPE_InstallDir&"tradeinfo/trade/"&rssort1("SortID")&".html'>"&rssort1("sort")&"</a>"
                HOPE_Type="<a href='"&HOPE_InstallDir&"tradeinfo/trade/"&rssort1("SortID")&"-"&rssort("typeid")&".html'>"&rssort("typename")&"</a>"           
    	        If totalrec="" Then
		      totalrec=0 
			End If	
             HOPE_TotalRec="(<font color=red>"&totalrec&"</font>)" 
    	  HOPE_TradeGo="<a href='"&HOPE_InstallDir&"'>首页</a> <small>></small> <a href='"&HOPE_InstallDir&"tradeinfo/index.html'>我要采购 </a><span class=S><small>></small> "&HOPE_Sort&" <small>></small> "&HOPE_Type&" <small>> </small>"&HOPE_Title&""
     '属于该行业的推荐的网盛通会员的供应信息^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
	Set rstjy=Server.CreateObject("ADODB.Recordset")
	 sqltjy="select  top  15   Websen_Info.showname,Websen_Info.Info_ID,Websen_Info.sortid,Websen_Info.typeid,Websen_Info.typeid_2 from Websen_Info,Websen_corporation where Websen_Info.Gsid=Websen_corporation.id and Websen_corporation.Tjbz like '%0%' and Websen_corporation.flag=1  and Websen_Info.sortid="&sttid&" and Websen_Info.typeid="&tytid&" and Websen_Info.typeid_2="&ttid&" and Websen_Info.type='卖' order by trust_score desc,Websen_info.dateandtime 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&"．<a href='"&HOPE_InstallDir&"tradeinfo/offerdetail/"&rstjy("sortid")&"-"&rstjy("typeid")&"-"&rstjy("typeid_2")&"-"&rstjy("Info_ID")&".html' target=_blank>"&rstjy("showname")&"</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
	 rssort2.Close
     '取出模版页和对标签赋值^^^^^^^^^^^^^^^^^^^^^^  end  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  		  If fso.FileExists(server.MapPath(HOPE_InstallDir&"tradeinfo/offerlist/"&sttid&"-"&tytid&"-"&ttid&".html")) Then
		  If kindtime<>"0" then 
     		Set fmodify = fso.GetFile(server.MapPath(HOPE_InstallDir&"tradeinfo/offerlist/"&sttid&"-"&tytid&"-"&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&"tradeinfo/offerlist/"&sttid&"-"&tytid&"-"&ttid&".html"))
				'如果文件存在就按时间进行更新^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
				fout.Write pencat&"<script src='"&HOPE_InstallDir&"autokind/trade_3.asp?id="&id&"'></script>"
				fout.Close
			  End If
			 End If  
  		  Else
           pencat=Hope_HtmlResult(pencat)
  		   Set foutc = fso.CreateTextFile(Server.Mappath(HOPE_InstallDir&"tradeinfo/offerlist/"&sttid&"-"&tytid&"-"&ttid&".html"))
		   '如果文件存在就按时间进行更新^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 		   foutc.Write pencat&"<script src='"&HOPE_InstallDir&"autokind/trade_3.asp?id="&id&"'></script>"
		   foutc.Close
 		 End If	
	  Set fso = nothing
      conn.Close
     Set conn=nothing
  End If
%>