create_listingcls.asp

来自「多用户管理分权限发布、管理软件信息； 自由选择系统默认为静态HTML或动态A」· ASP 代码 · 共 787 行 · 第 1/3 页

<%
Class Create_Listing_Cls
	Private ErrMsg
	Private SucMsg
	Private Founderr
	Private NC_Admin
	Private id, classid, rootid, depth, ClassName, ParentID, strParent, Child
	Private CurrentPage, maxperpage, totalnumber, bookmark, Pcount
	Private order_name, strOrder, ShowPageHtml, HtmlTemplate
	Private NewCloud_Ads
	Private action, d
	Private Sub Class_Initialize()
		Founderr = False
		d = Timer()
		Set NewCloud_Ads = New Adcolumn_Cls
		Newasp.LoadTemplates ("listing")
		maxperpage = Newasp.TempSet(0)
	End Sub

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

	Public Sub Init_CreateHtml()
		Set NC_Admin = New Check
		NC_Admin.AdminChk = "34"
		NC_Admin.Check
		Newasp.admin_header
		If CInt(Newasp.Setting(5)) = 1 Then
		NC_Admin.Error_Msg ("对不起!你选择动态ASP程序,不能生成HTML文件,请在基本设置修改成静态HTML方能生成THML文件。")
		Exit Sub
		End If
		action = Trim(Request("action"))
		Select Case action
			Case "Create"
				Call CreateListingHtml
			Case Else
				Call CreateMain
		End Select
		Newasp.admin_footer
	End Sub

	Public Sub ArticleList()
		Dim Rs, SQL
		Set Rs = Server.CreateObject("adodb.recordset")
		If Not IsNumeric(Request("classid")) And Request("classid") <> "" Then
			Response.Write"错误的系统参数!ID必须是数字"
			Exit Sub
			Response.End
		Else
			ClassID = CLng(Request("classid"))
		End If
		If Not IsEmpty(Request("page")) Then
			CurrentPage = Request("page")
		Else
			CurrentPage = 1
		End If
		If ClassID <> "" Then
			SQL = "select classid,ClassName,rootid,depth,ParentID,strParent,Child from [NC_Class] where classid = " & CLng(Request("classid"))
			Rs.Open SQL, Conn, 1, 1
			If Rs.bof And Rs.EOF Then
				Response.Write "Sorry！没有找到任何文章信息。或者您选择了错误的系统参数!"
				Response.End
			Else
				ClassName = Rs("ClassName")
				ClassID = Rs("ClassID")
				rootid = Rs("rootid")
				depth = Rs("depth")
				ParentID = Rs("ParentID")
				strParent = Rs("strParent")
				Child = Rs("Child")
			End If
			Rs.Close
		Else
			classid = ""
			ParentID = ""
			strParent = 0
			Child = ""
			depth = ""
			rootid = ""
			ClassName = Newasp.TempSet(11)
		End If
		order_name = Request("order")
		strOrder = Request("order")
		Select Case order_name
			Case "Title"
				order_name = "title"
			Case "Indate"
				order_name = "InfoTime"
			Case "Hits"
				order_name = "Hits"
			Case Else
				order_name = "InfoTime"
				strOrder = "Indate"
		End Select
		Dim temphtml, NowStats, HtmlTitle, ArticleIndex
		Dim TempTopStr, TempFootStr, Style_CSS
		ArticleIndex = "<A HREF='" & Newasp.SetupDir & "Article_Index.Asp'>" & Newasp.TempSet(10) & "</A>→"
		If Len(classid) = 0 Then
			NowStats = ArticleIndex & ClassName
		Else
			NowStats = ArticleIndex & NowStation(classid, ClassName, ParentID, strParent)
		End If
		HtmlTitle = ClassName
		If Len(Newasp.temphtml(0)) < 50 Then
			TempTopStr = Newasp.mainhtml(0) & Newasp.mainhtml(1) & Newasp.mainhtml(2) & Newasp.mainhtml(3)
		Else
			TempTopStr = Newasp.temphtml(0)
		End If
		If Len(Newasp.temphtml(4)) = 0 Then
			TempFootStr = Newasp.mainhtml(4)
		Else
			TempFootStr = Newasp.temphtml(5)
		End If
		temphtml = TempTopStr & Newasp.temphtml(1) & Newasp.temphtml(2) & Newasp.temphtml(3) & TempFootStr
		temphtml = Replace(temphtml, "{$NavMenu}", Newasp.ClassMenu)
		temphtml = Replace(temphtml, "{$Width}", Newasp.mainset(0))
		temphtml = Replace(temphtml, "{$TopMeun}", Newasp.mainset(10))
		temphtml = Replace(temphtml, "{$FootMeun}", Newasp.mainset(11))
		temphtml = Replace(temphtml, "{$Style_CSS}", Newasp.Style_CSS)
		temphtml = Replace(temphtml, "{$NowStats}", NowStats)
		temphtml = Replace(temphtml, "{$Title}", HtmlTitle)
		temphtml = Replace(temphtml, "{$ClassID}", classid)
		temphtml = Replace(temphtml, "{$ArticleClass}", ArticleClass(classid, ParentID, Child))
		temphtml = Replace(temphtml, "{$BestArticle}", BestArticle)
		temphtml = Replace(temphtml, "{$PicNews}", PictureNews)
		temphtml = Replace(temphtml, "{$NewPic}", SingleImage("InfoTime"))
		temphtml = Replace(temphtml, "{$HotPic}", SingleImage("Hits"))
		temphtml = Replace(temphtml, "{$ArticleList}", ArticleClassList(classid, rootid, depth, ClassName, order_name, maxperpage, CurrentPage, strOrder))
		temphtml = Replace(temphtml, "{$Adcolumn(0)}", NewCloud_Ads.RunScriptAds(5))
		temphtml = Replace(temphtml, "{$Adcolumn(1)}", NewCloud_Ads.BannerAds(5))
		temphtml = Replace(temphtml, "{$Adcolumn(2)}", NewCloud_Ads.AdsColumn(5, 2))
		temphtml = Replace(temphtml, "{$Adcolumn(3)}", NewCloud_Ads.AdsColumn(5, 3))
		temphtml = Replace(temphtml, "{$Adcolumn(6)}", NewCloud_Ads.AdsColumn(5, 7))
		temphtml = Replace(temphtml, "{$Adcolumn(4)}", NewCloud_Ads.ScriptFloatAds(5))
		temphtml = Replace(temphtml, "{$Adcolumn(5)}", NewCloud_Ads.ScriptFixedAds(5))
		Response.Write temphtml
	End Sub
	'*************************************************************
	'函数作用：文章列表
	'*************************************************************
	Private Function ArticleClassList(classid, rootid, depth, ClassName, order_name, maxperpage, CurrentPage, strOrder)
		Dim Rs, SQL
		Dim HtmlString, i, Icon, isCommend
		Dim Title, InfoTime, j
		Set Rs = Server.CreateObject("adodb.recordset")
		If Len(classid) = 0 Then
			SQL = "select * from NC_Article where isLock=0 order by isTop Desc, InfoTime Desc, ID Desc"
		Else
			If depth = 0 Then
				SQL = "select * from NC_Article where isLock=0 and rootid = " & rootid & " order by isTop Desc, " & order_name & " Desc, ID Desc"
			Else
				Dim Rs_c, AllClassID, ParentStr
				Set Rs_c = Newasp.Execute("select * from NC_Class where strParent like '%"& classid &"%'")
				If Rs_c.EOF And Rs_c.bof Then
					AllClassID = classid
				Else
					Do While Not Rs_c.EOF
						ParentStr = Split(Rs_c("strParent"), ",")
						For i = 0 To UBound(ParentStr)
							If CLng(ParentStr(i)) = classid Then
								ParentStr = ParentStr & Rs_c("classid") &","
							End If
						Next
						Rs_c.movenext
					Loop
					AllClassID = AllClassID & classid
				End If
				Rs_c.Close
				 Set Rs_c = Nothing
				SQL = "select * from NC_Article where isLock=0 and classid in (" & AllClassID & ") order by isTop Desc, " & order_name & " Desc, ID Desc"
			End If
		End If
		Rs.Open SQL, Conn, 1, 1
		If CInt(Newasp.Setting(5)) = 0 Then
			HtmlString = Newasp.TempSet(12)
		Else
			HtmlString = Newasp.TempSet(13)
		End If
		HtmlString = Replace(HtmlString, "{$ClassID}", classid)
		If Rs.bof And Rs.EOF Then
			HtmlString = HtmlString & "<p align=center>还没有找到任何文章！</p>"
		Else
			totalnumber = Rs.recordcount
			If (totalnumber Mod maxperpage) = 0 Then
				Pcount = totalnumber \ maxperpage
			Else
				Pcount = totalnumber \ maxperpage + 1
			End If
			Rs.MoveFiRst
			If CurrentPage > Pcount Then CurrentPage = Pcount
			If CurrentPage < 1 Then CurrentPage = 1
			If CurrentPage = Empty Then CurrentPage = 1
			Rs.Move (CurrentPage - 1) * maxperpage
			bookmark = Rs.bookmark
			i = 0
			j = (CurrentPage - 1) * maxperpage + 1
			Do While Not Rs.EOF And i < CInt(maxperpage)
				HtmlString = HtmlString & Newasp.TempSet(14)
				If CInt(Rs("isTop")) = 1 Then
					Icon = "<img src='" & Newasp.SetupDir & "images/isTop.gif' align='absmiddle'>"
				Else
					Icon = "<img src='" & Newasp.SetupDir & Newasp.TempDir & "icon2.gif' align='absmiddle'>"
				End If
				If CInt(Rs("isCommend")) = 0 Then
					isCommend = ""
				Else
					isCommend = Newasp.TempSet(16)
				End If
				If CInt(Newasp.Setting(5)) = 0 Then
					Title = "<A HREF='" & Newasp.SetupDir & "Article/Catalog" & Rs("classid") & "/" & Rs("ID") & ".html'>" & Trim(Rs("Title")) & "</a> "
				Else
					Title = "<A HREF='" & Newasp.SetupDir & "Article.Asp?id=" & Rs("ID") & "'>" & Trim(Rs("Title")) & "</a> "
				End If
				If Rs("InfoTime") >= Date Then
					InfoTime = "<FONT color=red>" & FormatDateTime(Rs("InfoTime"), 2) & "</FONT >"
				Else
					InfoTime = FormatDateTime(Rs("InfoTime"), 2)
				End If
				HtmlString = Replace(HtmlString, "{$Title}", Title)
				HtmlString = Replace(HtmlString, "{$InfoTime}", InfoTime)
				HtmlString = Replace(HtmlString, "{$Hits}", Rs("Hits"))
				HtmlString = Replace(HtmlString, "{$Commend}", isCommend)
				HtmlString = Replace(HtmlString, "{$Icon}", Icon)
				HtmlString = Replace(HtmlString, "{$Sequence}", j)
				Rs.movenext
				i = i + 1
				j = j + 1
			Loop
		End If
		Rs.Close
		Set Rs = Nothing
		HtmlString = HtmlString & Newasp.TempSet(15)
		HtmlString = Replace(HtmlString, "{$ShowPage}", AspShowPage(ClassName, maxperpage, CurrentPage, totalnumber))
		ArticleClassList = HtmlString
	End Function
	'*************************************************************
	'函数作用：文章列表
	'*************************************************************
	Private Function CreateArticleList(classid, orders)
		Dim Rs, SQL
		Dim HtmlString, i, Icon, isCommend
		Dim Title, InfoTime, j, HtmlTemplate, ShowPageHtml
		Set Rs = Server.CreateObject("adodb.recordset")
		SQL = "select classid,ClassName,rootid,depth,ParentID,strParent,Child from [NC_Class] where classid = " & classid
		Rs.Open SQL, Conn, 1, 1
		If Rs.bof And Rs.EOF Then
			Response.Write "Sorry！没有找到任何文章信息。或者您选择了错误的系统参数!"
			Response.End
		Else
			ClassName = Rs("ClassName")
			classid = Rs("classid")
			rootid = Rs("rootid")
			depth = Rs("depth")
			ParentID = Rs("ParentID")
			strParent = Rs("strParent")
			Child = Rs("Child")
			CreateNewFolder (classid)