create_sorting.asp

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

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

Dim DownloadClass
Set DownloadClass = New Create_Sorting_Cls
DownloadClass.SortingHtml
Set DownloadClass = Nothing
CloseConn

Class Create_Sorting_Cls
	Private DownloadClass_Ads,K
	Private softid, 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 ("Sorting")
		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 SortingHtml()
		On Error Resume Next
		Server.ScriptTimeout = 99999
		Set NC_Admin = New Check
		NC_Admin.AdminChk = "37"
		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 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 = "SoftTime"
		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.mainhtml(1) & DownsysClass.mainhtml(2) 
		Else
			TempTopStr = DownsysClass.mainhtml(0) & DownsysClass.mainhtml(1) & 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.temphtml(4) & 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.SortingMenu)
		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, "{$Sorting}", SoftSorting(sortid, ParentID, Child))
		temphtml = Replace(temphtml, "{$Sortings}", Sortings)
		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, "{$SortingList}", SoftSortingList(sortid, rootid, depth, SortName, order_name, maxperpage, CurrentPage, strOrder))
		temphtml = Replace(temphtml, "{$Adcolumn(0)}", DownloadClass_Ads.BannerAds(1))
		temphtml = Replace(temphtml, "{$Adcolumn(1)}", DownloadClass_Ads.tuijianAds(1))
		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 & "Sorting"& 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 & "Sorting"& ii &"/Catalog" & sortid & "/Sorting_Indate_Desc_1.html")
		Else
			CreateHtml = Server.MapPath(DownsysClass.SetupDir & "Sorting"& ii &"/Catalog" & sortid & "/Sorting_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 SoftSortingList(sortid, rootid, depth, SortName, order_name, maxperpage, CurrentPage, strOrder)
		Dim Rs, SQL, HtmlString, i, TopImg, isCommend, SoftImg,Rs1, SQL1
		Dim SoftName, SoftReadme, SoftTime, SoftSize
		Dim thiscolor

		Set Rs = Server.CreateObject("adodb.recordset")
		Set Rs1 = Server.CreateObject("adodb.recordset")
		If Len(sortid) = 0 Then
			WhereSQL = "where isLock=0 and SoftType like '%" & Trim(SoftType(ii)) & "%'"
		Else
			If depth = 0 Then
				WhereSQL = "where isLock=0 and SoftType like '%" & Trim(SoftType(ii)) & "%' and rootid = " & rootid & ""
			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 SoftType like '%" & Trim(SoftType(ii)) & "%' and sortid in (" & AllSortID & ")"
			End If
		End If
		TotalNumber = Conn.Execute("Select count(softid) from [NC_SoftInfo] "& 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_SoftInfo "& WhereSQL &" order by isTop Desc, " & order_name & " Desc, softid 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 CInt(Rs("isTop")) = 1 Then
					TopImg = "<img src='" & DownsysClass.SetupDir & "images/isTop.gif' align='absmiddle'>"
				Else
					TopImg = "<img src='" & DownsysClass.SetupDir & "images/arrow.gif' align='absmiddle'>"
				End If

				    If i mod 2 = 0 then
				    thiscolor = "#FFFFFF"
					Else
				    thiscolor = "#F6F6F6"
				    End If
				
				SoftName = "" & TopImg & " <A HREF='" & DownsysClass.SetupDir & "Software/Catalog" & Rs("sortid") &"/" & Rs("softid") & ".html'>" & Trim(Rs("softname")) & " " & Trim(Rs("softver")) & "</a> " & isCommend & ""
				If Rs("SoftTime") >= Date Then
					SoftTime = "<FONT color=red>" & FormatDateTime(Rs("SoftTime"), 2) & "</FONT >"
				Else
					SoftTime = FormatDateTime(Rs("SoftTime"), 2)
				End If
				If Not IsNull(Trim(Rs("softimg"))) And Trim(Rs("softimg")) <> "" Then
				
					SoftImg = "<TABLE class=picstyle cellSpacing=0 cellPadding=0 width=64  border=0><TBODY><TR><TD align=middle height=64><A class=M HREF='" & DownsysClass.SetupDir & "Software/Catalog" & Rs("sortid") &"/" & Rs("softid") & ".html'><img src='" & Rs("softimg") & "'  onload='javascript:if(this.height>this.width){this.height=" & DownsysClass.mainset(42) & "}else{this.width=" & DownsysClass.mainset(41) & "}'  border='0'></a></TD></TR></TBODY></TABLE></TD> "
				Else
					SoftImg = "<TABLE class=picstyle cellSpacing=0 cellPadding=0 width=64  border=0><TBODY><TR><TD align=middle height=64><img src='" & DownsysClass.SetupDir & "images/NoPic.jpg'  onload='javascript:if(this.height>this.width){this.height=" & DownsysClass.mainset(42) & "}else{this.width=" & DownsysClass.mainset(41) & "}'  border='0'></TD></TR></TBODY></TABLE></TD>"
				End If
				SoftReadme = DownsysClass.CutString(Rs("content"), CInt(DownsysClass.TempSet(7)))
				HtmlString = Replace(HtmlString, "{$SoftName}", SoftName)
				HtmlString = Replace(HtmlString, "{$SoftTime}", SoftTime)
				HtmlString = Replace(HtmlString, "{$SoftImg}", SoftImg)
				HtmlString = Replace(HtmlString, "{$thiscolor}", thiscolor)
				HtmlString = Replace(HtmlString, "{$MaterialClassCode}", Rs("MaterialClassCode"))
				HtmlString = Replace(HtmlString, "{$Grade}", Rs("Grade"))
				HtmlString = Replace(HtmlString, "{$Company}", Rs("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))
		SoftSortingList = 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=Sorting_Indate_Desc_1.html>首 页</a>&nbsp;&nbsp;"
		HtmlShowPage = HtmlShowPage & "<a href=Sorting_Indate_Desc_" & CurrentPage - 1 & ".html>上一页</a>&nbsp;&nbsp;&nbsp;"
	End If
if n>10 then
	if CurrentPage>5 then
	 page=CurrentPage-5
	else
	page=1
	end if
	if CurrentPage<5 then
	page1=10
	else
		if CurrentPage+5>n then
		page1=n
		else
		page1=CurrentPage+5
		end if
	end if