📄 newschannel.asp
字号:
ElseIf Newasp.CheckStr(LCase(Request("order"))) = "topic" Then
strOrder = "order by A.isTop desc, A.title desc ,A.ArticleID desc"
Else
strOrder = "order by A.isTop desc, A.WriteTime desc ,A.ArticleID desc"
End If
TotalNumber = Newasp.Execute("Select Count(ArticleID) from NC_Article where ChannelID = " & ChannelID & " And isAccept > 0 And ClassID in (" & ChildStr & ")")(0)
totalrec = TotalNumber
'-- 如果开启了父分类显示功能,限制显示数
If Child > 0 And TotalNumber > MaxListnum And MaxListnum <> 999 Then
strMaxListop = " TOP " & MaxListnum
TotalNumber = MaxListnum
Else
strMaxListop = vbNullString
End If
TotalPageNum = CLng(TotalNumber / maxperpage) '得到总页数
If TotalPageNum < TotalNumber / maxperpage Then TotalPageNum = TotalPageNum + 1
If CurrentPage < 1 Then CurrentPage = 1
If CurrentPage > TotalPageNum Then CurrentPage = TotalPageNum
Set Rs = CreateObject("ADODB.Recordset")
SQL = "select " & strMaxListop & " A.ArticleID,A.ClassID,A.BriefTopic,A.ColorMode,A.FontMode,A.title,A.content,A.Related,A.Author,A.ComeFrom,A.isTop,A.username,A.star,A.isBest,A.WriteTime,A.Allhits,A.HtmlFileDate,C.ClassName,C.ParentID,C.ParentStr,C.skinid,C.HtmlFileDir,C.ChildStr from [NC_Article] A inner join [NC_Classify] C On A.ClassID=C.ClassID where A.ChannelID=" & ChannelID & " And A.isAccept > 0 And A.ClassID in (" & ChildStr & ") " & strOrder & ""
If isSqlDataBase = 1 Then
Set Rs = Newasp.Execute(SQL)
Else
Rs.Open SQL, Conn, 1, 1
End If
If Rs.BOF And Rs.EOF Then
HtmlContent = Replace(HtmlContent, "{$ReadListPage}", "还没有找到任何" & Newasp.ModuleName & "")
HtmlContent = Replace(HtmlContent, Newasp.CutFixContent(HtmlContent, "[ShowRepetend]", "[/ShowRepetend]", 1), "")
If CreateHtml <> 0 Then
Newasp.CreatPathEx (HtmlFilePath)
HtmlFileName = HtmlFilePath & ReadListPageName(ClassID, CurrentPage)
Newasp.CreatedTextFile HtmlFileName, HtmlContent
If IsShowFlush = 1 Then
Response.Write "<li style=""font-size: 12px;"">生成" & Newasp.ModuleName & "列表HTML完成... <a href=" & HtmlFileName & " target=_blank>" & Server.MapPath(HtmlFileName) & "</a></li>" & vbNewLine
Response.Flush
End If
End If
Else
TotalNumber = totalrec
TempListContent = Newasp.CutFixContent(HtmlContent, "[ShowRepetend]", "[/ShowRepetend]", 1)
If CreateHtml <> 0 Then
Call LoadChildListHtml(n)
Else
Call LoadChildListAsp
End If
End If
Rs.Close: Set Rs = Nothing
End If
If CreateHtml = 0 Then CreateArticleList = HtmlContent
End Function
'================================================
'过程名:ReplaceContent
'作 用:替换模板内容
'================================================
Private Sub ReplaceContent()
On Error Resume Next
HtmlContent = HTML.ReadCurrentStation(HtmlContent, ChannelID, ClassID, strClassName, ParentID, strParent, strFileDir)
HtmlContent = HTML.ReadAnnounceContent(HtmlContent, ChannelID)
HtmlContent = ReadClassMenubar(HtmlContent)
HtmlContent = ReadClassMenu(HtmlContent)
HtmlContent = HTML.ReadArticlePic(HtmlContent)
HtmlContent = HTML.ReadArticleList(HtmlContent)
HtmlContent = HTML.ReadNewsPicAndText(HtmlContent)
HtmlContent = HTML.ReadSoftPicAndText(HtmlContent)
HtmlContent = HTML.ReadPopularArticle(HtmlContent)
HtmlContent = HTML.ReadPopularSoft(HtmlContent)
HtmlContent = HTML.ReadStatistic(HtmlContent)
HtmlContent = Replace(HtmlContent, "{$CurrentClass}", HTML.CurrentClass)
HtmlContent = Replace(HtmlContent, "{$SkinPath}", Newasp.SkinPath)
HtmlContent = Replace(HtmlContent, "{$InstallDir}", strInstallDir)
HtmlContent = Replace(HtmlContent, "{$ChannelID}", ChannelID)
End Sub
'================================================
'过程名:LoadParentList
'作 用:装载父级文章列表
'================================================
Private Sub LoadParentList()
Dim rsClslist, strContent, i, showtree
Dim ClassUrl, ClassNameStr
showtree = Trim(Newasp.HtmlSetting(4))
PageType = 1
On Error Resume Next
TempListContent = Newasp.CutFixContent(HtmlContent, "[ShowRepetend]", "[/ShowRepetend]", 1)
If Not IsNull(TempListContent) Then
SQL = "select Top " & CInt(Newasp.HtmlSetting(5)) & " ClassID,ClassName,HtmlFileDir from [NC_Classify] where ChannelID = " & ChannelID & " And TurnLink = 0 And ParentID=" & ClassID & " order by rootid asc, ClassID asc"
Set rsClslist = Newasp.Execute(SQL)
If rsClslist.BOF And rsClslist.EOF Then
Set rsClslist = Nothing
Exit Sub
Else
If showtree <> "1" Then strContent = "<table width=""100%"" align=center border=0 cellpadding=0 cellspacing=0 class=tablist>" & vbCrLf
Do While Not rsClslist.EOF
If showtree <> "1" Then strContent = strContent & "<tr valign=""top"">" & vbCrLf
For i = 1 To 2
If showtree <> "1" Then strContent = strContent & "<td class=""tdlist"">"
If Not (rsClslist.EOF) Then
strContent = strContent & TempListContent
If CInt(CreateHtml) <> 0 Then
ClassUrl = ChannelRootDir & rsClslist("HtmlFileDir")
Else
ClassUrl = ChannelRootDir & "list.asp?classid=" & rsClslist("ClassID")
End If
ClassNameStr = "<a href=""" & ClassUrl & """ class=""showtitle"">" & rsClslist("ClassName") & "</a>"
strContent = Replace(strContent, "{$ChannelID}", ChannelID)
strContent = Replace(strContent, "{$ClassifyID}", rsClslist("ClassID"))
strContent = Replace(strContent, "{$ClassName}", ClassNameStr)
strContent = Replace(strContent, "{$ClassUrl}", ClassUrl)
If showtree <> "1" Then strContent = strContent & "</td>" & vbCrLf
rsClslist.MoveNext
Else
If showtree <> "1" Then strContent = strContent & "</td>" & vbCrLf
End If
Next
If showtree <> "1" Then strContent = strContent & "</tr>" & vbCrLf
Loop
If showtree <> "1" Then strContent = strContent & "</table>" & vbCrLf
End If
HtmlContent = Replace(HtmlContent, TempListContent, strContent)
HtmlContent = Replace(HtmlContent, "[ShowRepetend]", "")
HtmlContent = Replace(HtmlContent, "[/ShowRepetend]", "")
rsClslist.Close: Set rsClslist = Nothing
End If
End Sub
'================================================
'过程名:LoadChildListHtml
'作 用:装载子级文章列表HTML
'================================================
Private Sub LoadChildListHtml(n)
Dim HtmlFileName
Dim Perownum,ii,w
Perownum = Newasp.ChkNumeric(Newasp.HtmlSetting(8))
If IsNull(TempListContent) Then Exit Sub
On Error Resume Next
'创建分类目录
'Response.Flush
Newasp.CreatPathEx (HtmlFilePath)
For CurrentPage = n To TotalPageNum
Rs.MoveFirst
i = 0
If TotalPageNum > 1 Then Rs.Move (CurrentPage - 1) * maxperpage
ListContent = ""
j = (CurrentPage - 1) * maxperpage + 1
If Perownum > 1 Then
ListContent = Newasp.HtmlSetting(9)
w = FormatPercent(100 / Perownum / 100,0)
End If
Do While Not Rs.EOF And i < CInt(maxperpage)
If Not Response.IsClientConnected Then Response.end
If Perownum > 1 Then
ListContent = ListContent & "<tr valign=""top"">" & vbCrLf
For ii = 1 To Perownum
ListContent = ListContent & "<td width=""" & w & """ class=""shoplistrow"">"
If Not Rs.EOF Then
Call LoadListDetail
Rs.movenext
i = i + 1
j = j + 1
End If
ListContent = ListContent & "</td>" & vbCrLf
Next
ListContent = ListContent & "</tr>" & vbCrLf
Else
Call LoadListDetail
Rs.MoveNext
i = i + 1
j = j + 1
End If
If i >= maxperpage Then Exit Do
Loop
Dim strHtmlFront, strHtmlPage
strHtmlFront = Newasp.HtmlPrefix & Newasp.Supplemental(ClassID, 3) & "_"
strHtmlPage = htmlshowpage(CurrentPage, TotalPageNum, TotalNumber, maxperpage, strHtmlFront, Newasp.HtmlExtName, strClassName)
HtmlTemplate = HtmlContent
HtmlTemplate = Replace(HtmlTemplate, TempListContent, ListContent)
HtmlTemplate = Replace(HtmlTemplate, "{$ReadListPage}", strHtmlPage)
HtmlTemplate = Replace(HtmlTemplate, "[ShowRepetend]", "")
HtmlTemplate = Replace(HtmlTemplate, "[/ShowRepetend]", "")
'开始生成子分类的HTML页
HtmlFileName = HtmlFilePath & ReadListPageName(ClassID, CurrentPage)
Newasp.CreatedTextFile HtmlFileName, HtmlTemplate
If IsShowFlush = 1 Then
Response.Write "<li style=""font-size: 12px;"">生成" & Newasp.ModuleName & "列表HTML完成... <a href=" & HtmlFileName & " target=_blank>" & Server.MapPath(HtmlFileName) & "</a></li>" & vbNewLine
Response.Flush
End If
Next
Exit Sub
End Sub
'================================================
'过程名:LoadChildListAsp
'作 用:装载子级文章列表ASP
'================================================
Private Sub LoadChildListAsp()
If IsNull(TempListContent) Then Exit Sub
Dim Perownum,ii,w
Perownum = Newasp.ChkNumeric(Newasp.HtmlSetting(8))
On Error Resume Next
i = 0
Rs.MoveFirst
If TotalPageNum > 1 Then Rs.Move (CurrentPage - 1) * maxperpage
ListContent = ""
j = (CurrentPage - 1) * maxperpage + 1
If Perownum > 1 Then
ListContent = Newasp.HtmlSetting(9)
w = FormatPercent(100 / Perownum / 100,0)
End If
Do While Not Rs.EOF And i < CInt(maxperpage)
If Not Response.IsClientConnected Then Response.end
If Perownum > 1 Then
ListContent = ListContent & "<tr valign=""top"">" & vbCrLf
For ii = 1 To Perownum
ListContent = ListContent & "<td width=""" & w & """ class=""shoplistrow"">"
If Not Rs.EOF Then
Call LoadListDetail
Rs.movenext
i = i + 1
j = j + 1
End If
ListContent = ListContent & "</td>" & vbCrLf
Next
ListContent = ListContent & "</tr>" & vbCrLf
Else
Call LoadListDetail
Rs.MoveNext
i = i + 1
j = j + 1
End If
If i >= maxperpage Then Exit Do
Loop
Dim strPagination
strPagination = ShowListPage(CurrentPage, TotalPageNum, TotalNumber, maxperpage, ASPCurrentPage(PageType), strClassName)
HtmlContent = Replace(HtmlContent, TempListContent, ListContent)
HtmlContent = Replace(HtmlContent, "[ShowRepetend]", "")
HtmlContent = Replace(HtmlContent, "[/ShowRepetend]", "")
HtmlContent = Replace(HtmlContent, "{$ReadListPage}", strPagination)
End Sub
'================================================
'过程名:LoadArticleList
'作 用:装载文章列表
'================================================
Private Function LoadArticleList(ArticleID, ClassID, title, ColorMode, FontMode, BriefTopic, ClassName, Content, HtmlFileDir, HtmlFileDate, AllHits, UserName, star, isBest)
On Error Resume Next
End Function
'================================================
'过程名:LoadListDetail
'作 用:装载子级文章列表细节
'================================================
Private Sub LoadListDetail()
Dim sTitle, sTopic, ArticleTitle, ListStyle
Dim ArticleContent, ArticleUrl, WriteTime, sClassName
On Error Resume Next
ListContent = ListContent & TempListContent
If (i Mod 2) = 0 Then
ListStyle = 1
Else
ListStyle = 2
End If
If strlen > 0 Then
sTitle = Newasp.GotTopic(Rs("title"),strlen)
Else
sTitle = Rs("title")
End If
sTitle = Newasp.ReadFontMode(sTitle, Rs("ColorMode"), Rs("FontMode"))
sTopic = Newasp.ReadPicTopic(Rs("BriefTopic"))
If CInt(CreateHtml) <> 0 Then
ArticleUrl = ShowChannelPath(Newasp.ChannelPath,Rs("HtmlFileDir")) & Newasp.ShowDatePath(Rs("HtmlFileDate"), Newasp.HtmlPath) & ReadPagination(0)
sClassName = ChannelRootDir & Rs("HtmlFileDir")
Else
ArticleUrl = ChannelRootDir & "show.asp?id=" & Rs("ArticleID")
sClassName = ChannelRootDir & "list.asp?classid=" & Rs("ClassID")
End If
sClassName = "<a href='" & sClassName & "' title='" & Rs("ClassName") & "'>" & Rs("ClassName") & "</a>"
ArticleTitle = "<a href='" & ArticleUrl & "' title='" & Rs("title") & "' class=""showtopic"">" & sTitle & "</a>"
ArticleContent = Replace(Replace(Rs("Content"), "[page_break]", ""), "[InstallDir_ChannelDir]", "")
ArticleContent = Newasp.CutString(ArticleContent, CInt(Newasp.HtmlSetting(3)))
WriteTime = Newasp.ShowDateTime(Rs("WriteTime"), CInt(Newasp.HtmlSetting(2)))
ListContent = Replace(ListContent, "{$ClassifyName}", sClassName)
ListContent = Replace(ListContent, "{$ArticleTitle}", ArticleTitle)
ListContent = Replace(ListContent, "{$ArticleTopic}", sTitle)
ListContent = Replace(ListContent, "{$ArticleUrl}", ArticleUrl)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -