create_pagesort.asp

大型黄页系统,精美黄页flash演示,10m

<!--#include file="setup.asp"-->
<meta http-equiv="address-Type" address="text/html; charset=gb2312">
<%
	Dim SoftType,ii
	SoftType = Split(DownsysClass.Setting(35), ",")
	if Trim(Request("ado"))<>"" then
	 ii = Trim(Request("ado"))
	 else
	 ii = ""
	 end if

Dim DownloadClass
Set DownloadClass = New Create_PageSort_Cls
DownloadClass.PageSortHtml
Set DownloadClass = Nothing
CloseConn

Class Create_PageSort_Cls
	Private DownloadClass_Ads,K
	Private userid, sortid, rootid, depth, SortName, ParentID,SoftNum, strParent, Child
	Private CurrentPage, maxperpage, totalnumber, bookmark, Pcount
	Private order_name, strOrder, ShowPageHtml, HtmlTemplate
	Private action, d
	Private TotalPageNum,WhereSQL
	Private SQL, Rs, Rs1, SQL1, CreateHtml, FSO, total, NewFolderPath, objFSO
	Private temphtml, NowStats,NowStats1, HtmlTitle
	Private TempTopStr, TempFootStr, Style_CSS


	Private Sub Class_Initialize()
		DownsysClass.LoadTemplates ("PageSort")
		Set DownloadClass_Ads = New Adcolumn_Cls
		maxperpage = CInt(DownsysClass.TempSet(0)) '###每页显示数
	End Sub

	Private Sub Class_Terminate()
		If IsObject(Conn) Then
			Conn.Close
			Set Conn = Nothing
		End If
		If IsObject(DownloadClass_Ads) Then
			Set DownloadClass_Ads = Nothing
		End If
	End Sub

	Public Sub PageSortHtml()
		On Error Resume Next
		Server.ScriptTimeout = 99999
		Set NC_Admin = New Check
		NC_Admin.AdminChk = "47"
		NC_Admin.Check
		DownsysClass.admin_header
		If Not(DownsysClass.IsObjectFSO(DownsysClass.Script_FSO) And CInt(DownsysClass.Setting(5)) = 0 ) Then
			NC_Admin.Error_Msg ("<b><font color=red>你的服务器不支持 FSO(Scripting.FileSystemObject)或你后台没有选择为html方式</font></b>")
			DownsysClass.admin_footer
			Response.End
		End If
		Response.Write "<table width=""400"" border=""0"" cellspacing=""1"" cellpadding=""1"">" & vbCrLf
		Response.Write "<tr> " & vbCrLf
		Response.Write "<td bgcolor=000000>" & vbCrLf
		Response.Write " <table width=""400"" border=""0"" cellspacing=""0"" cellpadding=""1"">" & vbCrLf
		Response.Write "<tr> " & vbCrLf
		Response.Write "<td bgcolor=ffffff height=9><img src=""images/bar9.gif"" width=0 height=16 id=img2 name=img2 align=absmiddle></td></tr></table>" & vbCrLf
		Response.Write "</td></tr></table></td></tr><tr> " & vbCrLf
		Response.Write "<td align=center bgcolor=000000> <span id=txt2 name=txt2 style=""font-size:9pt"">0</span><span style=""font-size:9pt"">%</span>  <span id=txt3 name=txt3 style=""font-size:9pt"">0</span></td></tr>" & vbCrLf
		Response.Write "</table>" & vbCrLf
		Response.Flush
		Set Rs1 = Server.CreateObject("adodb.recordset")
		SQL1 = "select * from [NC_softsort] "
		Rs1.Open SQL1, Conn, 1, 1
		total = Rs1.recordcount
		Rs1.MoveFiRst
		sortid =Rs1(0)
		K = 1
		Set Rs = Server.CreateObject("adodb.recordset")
		Do While Not Rs1.EOF
			SQL = "select sortid,sortname,rootid,depth,ParentID,strParent,Child,SoftNum from [NC_softsort] where depth = 0 and sortid = " & sortid & ""
			Rs.Open SQL, Conn, 1, 1
			If Rs.bof And Rs.EOF Then
				Response.Write "Sorry！没有找到任何信息信息。或者您选择了错误的系统参数!"
				'Response.End
			Else
				SortName = Rs("sortname")
				sortid = Rs("sortid")
				rootid = Rs("rootid")
				depth = Rs("depth")
				ParentID = Rs("ParentID")
				SoftNum = Rs("SoftNum")
				strParent = Rs("strParent")
				Child = Rs("Child")
			End If
			Rs.Close
		'###################################################
		TotalPageNum = CInt(TotalNumber / maxperpage)  '得到总页数
		If TotalPageNum < TotalNumber / maxperpage Then TotalPageNum = TotalPageNum + 1
		CurrentPage = 1
		'#####################################################################
		Dim keyword
		order_name = "regtime"
		strOrder = "Indate"
		Do
		If Len(sortid) = 0 Then
			NowStats = SortName
			NowStats1 = SortName
		Else
			NowStats = NowStation(sortid, SortName, ParentID, strParent)
			NowStats1 = NowStation1(sortid, SortName, SoftNum, strParent)
		End If
		HtmlTitle = SortName
		If depth < 2  Then
			TempTopStr = DownsysClass.mainhtml(0) & DownsysClass.TempHtml(5) & DownsysClass.mainhtml(2) 
		Else
			TempTopStr = DownsysClass.mainhtml(0) & DownsysClass.TempHtml(5) & DownsysClass.mainhtml(2) 
		End If
			TempFootStr = DownsysClass.mainhtml(4)
		Style_CSS = Replace(Replace(DownsysClass.Style_CSS, "{$SetupDir}", DownsysClass.SetupDir), "{$PicUrl}", DownsysClass.TempDir)
		if depth < 2 then
			if depth = 0 then
				temphtml = TempTopStr & DownsysClass.mainhtml(3) & DownsysClass.temphtml(0) & DownsysClass.temphtml(2) & DownsysClass.temphtml(3) & TempFootStr
			else
				temphtml = TempTopStr & DownsysClass.mainhtml(3) & DownsysClass.temphtml(1) & DownsysClass.temphtml(0) & DownsysClass.temphtml(2) & DownsysClass.temphtml(3) & TempFootStr
			end if
		else
		temphtml = TempTopStr & DownsysClass.mainhtml(3) & DownsysClass.temphtml(0) & DownsysClass.temphtml(2) & DownsysClass.temphtml(3) & TempFootStr
		end if
		temphtml = Replace(temphtml, "{$NavMenu}", DownsysClass.PageSortMenu)
		temphtml = Replace(temphtml, "{$Width}", DownsysClass.mainset(0))
		temphtml = Replace(temphtml, "{$Style_CSS}", Style_CSS)
		temphtml = Replace(temphtml, "{$TopMeun}", DownsysClass.mainset(9))
		temphtml = Replace(temphtml, "{$FootMeun}", DownsysClass.mainset(44))
		temphtml = Replace(temphtml, "{$NowStats}", NowStats)
		temphtml = Replace(temphtml, "{$NowStats1}", NowStats1)
		temphtml = Replace(temphtml, "{$Title}", HtmlTitle)
		temphtml = Replace(temphtml, "{$SortID}", sortid)
		temphtml = Replace(temphtml, "{$PageSort}", SoftPageSort(sortid, ParentID, Child))
		temphtml = Replace(temphtml, "{$PageSorts}", PageSorts)
		temphtml = Replace(temphtml, "{$ShowPage1}", ShowPage1(sortid, rootid, depth, SortName, order_name, maxperpage, CurrentPage, strOrder))
		temphtml = Replace(temphtml, "{$KeyWord}", SortName)
		temphtml = Replace(temphtml, "{$hangye}", hangye)
		temphtml = Replace(temphtml, "{$sousuo}", sousuo)
		temphtml = Replace(temphtml, "{$liebiao}", liebiao)
		temphtml = Replace(temphtml, "{$sousuolei}", sousuolei)
		temphtml = Replace(temphtml, "{$liebiaoname}", liebiaoname)
		temphtml = Replace(temphtml, "{$PageSortList}", SoftPageSortList(sortid, rootid, depth, SortName, order_name, maxperpage, CurrentPage, strOrder))
		temphtml = Replace(temphtml, "{$Adcolumn(0)}", DownloadClass_Ads.RunScriptAds(2))
		temphtml = Replace(temphtml, "{$Adcolumn(1)}", DownloadClass_Ads.BannerAds(2))
		temphtml = Replace(temphtml, "{$Adcolumn(2)}", DownloadClass_Ads.AdsColumn(2, 2))
		temphtml = Replace(temphtml, "{$Adcolumn(3)}", DownloadClass_Ads.AdsColumn(2, 3))
		temphtml = Replace(temphtml, "{$Adcolumn(6)}", DownloadClass_Ads.AdsColumn(2, 7))
		temphtml = Replace(temphtml, "{$Adcolumn(7)}", DownloadClass_Ads.AdsColumn(2, 8))
		temphtml = Replace(temphtml, "{$Adcolumn(4)}", DownloadClass_Ads.ScriptFloatAds(2))
		temphtml = Replace(temphtml, "{$Adcolumn(5)}", DownloadClass_Ads.ScriptFixedAds(2))

		NewFolderPath = Server.MapPath(DownsysClass.SetupDir & "PageSort"& ii &"/Catalog" & sortid)
		Set objFSO = Server.CreateObject(DownsysClass.Script_FSO)
		If Not objFSO.FolderExists(NewFolderPath) Then
			objFSO.CreateFolder (NewFolderPath)
		End If
		objFSO.Close
		Set objFSO = Nothing

		If CurrentPage < 1 Then
			CreateHtml = Server.MapPath(DownsysClass.SetupDir & "PageSort"& ii &"/Catalog" & sortid & "/PageSort_Indate_Desc_1.html")
		Else
			CreateHtml = Server.MapPath(DownsysClass.SetupDir & "PageSort"& ii &"/Catalog" & sortid & "/PageSort_Indate_Desc_" & CurrentPage & ".html")
		End If
		Set FSO = Server.CreateObject("ADODB.STREAM")
		With FSO
			.Open
			.Charset = "GB2312"
			.WriteText temphtml
			.SaveToFile CreateHtml,2
			.Close
		End With
		Set FSO = Nothing
		CurrentPage = CurrentPage + 1
		Loop While CurrentPage <= TotalPageNum
		Response.Write "<script>img2.width=" & Fix((K / total) * 400) & ";" & vbCrLf
		Response.Write "txt2.innerHTML=""生成进度:" & FormatNumber(K / total * 100, 4, -1) & """;" & vbCrLf
		Response.Write "txt3.innerHTML=""共有 <B><font color=RED>" & total & "</font></B> 个 正在生成第 " & K & " 个"";" & vbCrLf
		Response.Write "img2.title=""(" & K & ")"";</script>" & vbCrLf
		Response.Flush
		Rs1.movenext
		sortid  = Rs1(0)
		K = K + 1
		Loop
		Rs1.Close
		Set Rs1 = Nothing
		Response.Write "<script>img2.width=400;txt2.innerHTML=""100"";</script>"
		NC_Admin.Succeed_Msg ("生成信息列表页完成!")
		DownsysClass.admin_footer
	End Sub
	'*************************************************************
	'函数作用：信息列表
	'*************************************************************
	Private Function SoftPageSortList(sortid, rootid, depth, SortName, order_name, maxperpage, CurrentPage, strOrder)
		Dim Rs, SQL, HtmlString, i, TopImg, isCommend, Grade, usertel,Rs1, SQL1, Rs5, SQL5, Rs6, SQL6
		Dim truename, SoftReadme, regtime, SoftSize
		Dim thiscolor, Company, MaterialClassCode
		Set Rs = Server.CreateObject("adodb.recordset")
		Set Rs1 = Server.CreateObject("adodb.recordset")
		If Len(sortid) = 0 Then
			WhereSQL = "where isLock=0 "
		Else
				Dim Rss, AllSortID, ParentStr
				Set Rss = DownsysClass.Execute("select * from NC_SoftSort where strParent like '%"& sortid &"%'")
				If Rss.EOF And Rss.bof Then
					AllSortID = sortid
				Else
					Do While Not Rss.EOF
						ParentStr = Split(Rss("strParent"), ",")
						For i = 0 To UBound(ParentStr)
							If CLng(ParentStr(i)) = sortid Then
								AllSortID = AllSortID & Rss("sortid") &","
								Exit For
							End If
						Next
						Rss.movenext
					Loop
					AllSortID = AllSortID & sortid
				End If
				Rss.Close
				Set Rss = Nothing
				WhereSQL = "where isLock=0 and CategoryId in (" & AllSortID & ")"
		End If
		TotalNumber = Conn.Execute("Select count(userid) from [NC_user] "& WhereSQL &"")(0)
		TotalPageNum = CInt(TotalNumber / maxperpage)  '得到总页数
		If TotalPageNum < TotalNumber / maxperpage Then TotalPageNum = TotalPageNum + 1
		If CurrentPage < 1 Then CurrentPage = 1
		If CurrentPage > TotalPageNum Then CurrentPage = TotalPageNum
		SQL = "select * from NC_user "& WhereSQL &" order by userid Desc"
		Rs.Open SQL, Conn, 1
		HtmlString = DownsysClass.TempSet(8)
		HtmlString = Replace(HtmlString, "{$SortID}", sortid)

		
		If Rs.bof And Rs.EOF Then
			HtmlString = HtmlString & "<p align=center>还没有找到任何信息！</p>"
		Else
			If TotalPageNum > 1 then Rs.Move (CurrentPage - 1) * maxperpage
			i = 0
			Do While Not Rs.EOF And i < CInt(maxperpage)
				HtmlString = HtmlString & DownsysClass.TempSet(10)

				    If i mod 2 = 0 then
				    thiscolor = "#FFFFFF"
					Else
				    thiscolor = "#F6F6F6"
				    End If
				
				truename = "" & Trim(Rs("truename")) & " "
				IF Rs("Grade") = 2 then 
						Grade = "VIP会员"
				Else
						Grade = "普通会员"
				End if
				 
				If Rs("regtime") >= Date Then
					regtime = "<FONT color=red>" & FormatDateTime(Rs("regtime"), 2) & "</FONT >"
				Else
					regtime = FormatDateTime(Rs("regtime"), 2)
				End If
				If Not IsNull(Trim(Rs("usertel"))) And Trim(Rs("usertel")) <> "" Then
				
					usertel = "" & Rs("PhoneCountry") & "-" & Rs("PhoneArea") & "-" & Rs("usertel") & " "
				Else
					usertel = "" & Rs("PhoneCountry") & "-" & Rs("PhoneArea") & "-" & Rs("usertel") & " "
				End If
				
				IF Rs("Company") <> "" then 
						Company = "<a class=M HREF='" & DownsysClass.SetupDir & "Pageware/" & Rs("MaterialClassCode") &"/" & Rs("userid") & ".html' target=_blank >"& Rs("Company") &"</a>"
				Else
						Company = "信息不详"
				End if
				IF Rs("MaterialClassCode") <> "" then 
						Set Rs5 = CreateObject("Adodb.recordset")
						SQL5 = "select * from MaterialClass where MaterialClassCode = "&(Left((Rs("MaterialClassCode")), 4)) &""
						Rs5.Open SQL5, Conn, 1, 1
						Set Rs6 = CreateObject("Adodb.recordset")
						SQL6 = "select * from MaterialClass where MaterialClassCode = "& Rs("MaterialClassCode") &""
						Rs6.Open SQL6, Conn, 1, 1
						MaterialClassCode = ""& Rs5("Description") &"-"& Rs6("Description") &""
				Else
						MaterialClassCode = "信息不详"
				End if
		Rs5.Close
		Rs6.Close
				SoftReadme = DownsysClass.CutString(Rs("address"), CInt(DownsysClass.TempSet(7)))
				HtmlString = Replace(HtmlString, "{$truename}", truename)
				HtmlString = Replace(HtmlString, "{$regtime}", regtime)
				HtmlString = Replace(HtmlString, "{$usertel}", usertel)
				HtmlString = Replace(HtmlString, "{$thiscolor}", thiscolor)
				HtmlString = Replace(HtmlString, "{$MaterialClassCode}", MaterialClassCode)
				HtmlString = Replace(HtmlString, "{$SaleKeywords}", Rs("SaleKeywords"))
				HtmlString = Replace(HtmlString, "{$Grade}", Grade)
				HtmlString = Replace(HtmlString, "{$Company}", Company)
				
				Rs.movenext
				i = i + 1
			Loop
		End If
		Rs.Close
		HtmlString = HtmlString & DownsysClass.TempSet(11)
		HtmlString = Replace(HtmlString, "{$ShowPage}", AspShowPage(SortName, maxperpage, CurrentPage, totalnumber))
		SoftPageSortList = HtmlString
	End Function
	'*************************************************************
	'函数作用：Html分页
	'*************************************************************
Private Function AspShowPage(SortName, maxperpage, CurrentPage, totalnumber)
	Dim ii
	Dim n
	dim page
	dim page1
	Dim HtmlShowPage
	If totalnumber Mod maxperpage = 0 Then
		n = totalnumber \ maxperpage
	Else
		n = totalnumber \ maxperpage + 1
	End If
	


	HtmlShowPage =  "</td></tr></table><TABLE cellSpacing=0 cellPadding=0 width=""100%"" border=0><TR><TD style=""PADDING-TOP: 15px"" vAlign=top align=left bgColor=#f4f4f4>&nbsp;</TD></TR></TABLE></td></tr></table><TABLE width='98%' border=0 align='center' cellPadding=2 cellSpacing=0 style='BORDER-TOP: #9c9a9c 1px solid; BORDER-BOTTOM: #9c9a9c 1px solid'><tr><td align=center> " & vbCrLf
	If CurrentPage < 2 Then
		HtmlShowPage = HtmlShowPage & " 首 页&nbsp;&nbsp;上一页&nbsp;&nbsp;&nbsp;"
	Else
		HtmlShowPage = HtmlShowPage & "<a href=PageSort_Indate_Desc_1.html>首 页</a>&nbsp;&nbsp;"
		HtmlShowPage = HtmlShowPage & "<a href=PageSort_Indate_Desc_" & CurrentPage - 1 & ".html>上一页</a>&nbsp;&nbsp;&nbsp;"
	End If
if n>10 then
	if CurrentPage>5 then