创力网站管理系统-首页最新文章列表文字之间加分隔线效果!
导航:返回上一页
创力网站管理系统-首页最新文章列表文字之间加分隔线效果!
修改INC目录下的Cl_Function_Article.asp文件中的
过程:ShowArticle
以下内容为程序代码:
'过程:ShowArticle(sChannelID,sClassID,sSpecialID,TopNum,TitleLen,ShowClassName,ShowProperty,
ShowPrefix,ShowAuthor,ShowDateType,ShowHits,ShowHot,IsElite,IsHot,UserName,CssStyle)
'参数:
' sChannelID ------ 频道ID
' sClassID ------ 栏目ID(0为全部,如果大于0,则调用指定栏目及其子栏目)
' sSpecialID ------ 专题ID(0为全部,如果大于0,刚调用指定专题)
' TopNum ------ 最多记录数,0为全部(用于分页显示)
' TitleLen ------ 标题最多字符数
' ShowClassName ------ 是否显示栏目名称(True为显示,False为不显示)
' ShowProperty ------ 是否显示文章属性(固顶/推荐/普通),(True为显示,False为不显示)
' ShowPrefix ------ 是否显示前缀如:[推荐][图文][注意]字样(True为显示,False为不显示)
' ShowAuthor ------ 是否显示文章作者,True为显示,False为不显示)
' ShowDateType ------ 显示更新日期的样式
' ---- 0(不显示)
' ---- 1(2004-10-01 23:45:45)
' ---- 2(年-月-日 时:分:秒)
' ---- 3(10-01 23:45)
' ---- 4(2004-10-01)
' ---- 5(2004年10月01日)
' ---- 6(10-01)
' ---- 7(20041001234545)
' ShowHits ------ 是否显示文章点击数(True为显示,False为不显示)
' ShowHot ------ 是否显示热门文章标志(True为显示,False为不显示)
' IsElite ------ 是否推荐(True为是,False为否)
' IsHot ------ 是否热门(True为是,False为否)
' UserName ------ 指定某用户(不指定请留空值或0)
' CssStyle ------ CSS样式
'==================================================================================================== Function ShowArticle(sChannelID,sClassID,sSpecialID,TopNum,TitleLen,ShowClassName,S howProperty,ShowPrefix,ShowAuthor,ShowDateType,ShowHits,ShowHot,IsElite, IsHot,UserName,CssStyle) sChannelID = Cl.ChkClng(sChannelID) : sClassID = Cl.ChkClng(sClassID) sSpecialID = Cl.ChkClng(sSpecialID) : TopNum = Cl.ChkClng(TopNum) TitleLen = Cl.ChkClng(TitleLen) : ShowClassName = Cl.ChkCBool(ShowClassName) ShowProperty = Cl.ChkCBool(ShowProperty) : ShowPrefix = Cl.ChkCBool(ShowPrefix) ShowAuthor = Cl.ChkCBool(ShowAuthor) : ShowDateType = Cl.ChkClng(ShowDateType) ShowHits = Cl.ChkCBool(ShowHits) : ShowHot = Cl.ChkCBool(ShowHot) IsHot = Cl.ChkCBool(IsHot) : IsElite = Cl.ChkCBool(IsElite) UserName = Trim(UserName) : CssStyle = Trim(CssStyle) Cl.GetChannelSetting(sChannelID) if TopNum=0 then SqlInfo="Select " else SqlInfo="Select Top "&TopNum&" " end if SqlInfo = SqlInfo & "A.ArticleID,A.ClassID,C.ClassName,C.ParentPath,C.ClassDir, C.ParentDir,A.Title,A.Author,A.CopyFrom,A.UpdateTime,A.Editor, A.TitleFontColor,A.TitleFontType,A.Hits,A.OnTop,A.Hot,A.Elite, A.Passed,A.Prefixion,A.Stars,A.PaginationType,A.ReadLevel, A.ReadPoint,A.DefaultPicUrl,A.IsHtml,A.HtmlFileUrl, Intro from Cl_Article A Inner Join Cl_Class C On A.ClassID=C.ClassID where A.Deleted="&FalseType&" and A.Passed="&TrueType&" and A.ChannelID="&sChannelID&" " if sClassID>0 then Dim tClass Set tClass=Cl.Execute("select ClassID,Child,ParentPath,arrChildID from Cl_Class where ChannelID="&sChannelID&" and ClassID=" & sClassID) if not(tClass.bof and tClass.eof) then if tClass(1)>0 then SqlInfo=SqlInfo & " and A.ClassID in (" & tClass(3) & ")" else SqlInfo=SqlInfo & " and A.ClassID=" & sClassID end if else SqlInfo=SqlInfo & " and A.ClassID=" & sClassID end if Set tClass=Nothing end if if sSpecialID>0 then SqlInfo=SqlInfo & " and A.SpecialID=" & sSpecialID if IsElite=True then SqlInfo=SqlInfo & " and A.Elite="&TrueType if IsHot=True then SqlInfo=SqlInfo & " and A.Hits>=" & Clng(Cl.Web_Setting(14)) if UserName<>"" and UserName<>"0" then SqlInfo=SqlInfo & " and A.Editor='" & UserName & "'" SqlInfo=SqlInfo & " order by A.OnTop,A.UpdateTime desc,A.ArticleID desc" Set rsInfo= Server.CreateObject("ADODB.Recordset") OpenConn : rsInfo.open SqlInfo,Conn,1,1 if rsInfo.bof and rsInfo.eof then TotalPut=0 ShowArticle="<br><li>没有任何"&Cl.Channel_Setting(2)&"</li>" rsInfo.close:set rsInfo=Nothing : Exit Function End if TotalPut=rsInfo.recordcount if TopNum>0 then SqlInfo=rsInfo.GetRows(-1) else if (TotalPut mod MaxPerPage)=0 then TotalPages = TotalPut \ MaxPerPage else TotalPages = TotalPut \ MaxPerPage + 1 end if if CurrentPage > TotalPages then CurrentPage=TotalPages if CurrentPage < 1 then CurrentPage=1 rsInfo.move (CurrentPage-1)*MaxPerPage SqlInfo=rsInfo.GetRows(MaxPerPage) end if rsInfo.close:set rsInfo=Nothing dim strTemp,Linkurl,i dim TitleStr,Author,AuthorName,AuthorEmail,sTitleLen i=0:strTemp = "<table width=100% border=0 cellpadding=0 cellspacing=0 class="""&CssStyle&""">" For i=0 to Ubound(SqlInfo,2) sTitleLen = TitleLen strTemp = strTemp & "<tr><td align=""left""> " if ShowProperty=True then if SqlInfo(14,i)=True then strTemp = strTemp & "<img src=""" & Cl.mainpic(13) & """ alt=""固顶""> " elseif SqlInfo(16,i)=True then strTemp = strTemp & "<img src=""" & Cl.mainpic(12) & """ alt=""推荐""> " else strTemp = strTemp & "<img src=""" & Cl.mainpic(11) & """ alt=""普通""> " end if end if if ShowClassName=True and SqlInfo(1,i)<>ClassID then strTemp=strTemp & "[<a href=""" & Cl.WebDir & Cl.GetClassUrl(Clng(Cl.Channel_Setting (11)),Cl.HtmlDir,Cl.Channel_Setting(4),SqlInfo(3,i),SqlInfo(1,i), SqlInfo(5,i),SqlInfo(4,i),Clng(Cl.Channel_Setting(10)), Cl.Channel_Setting(13)) & """>" & SqlInfo(2,i) & "</a>] " sTitleLen=sTitleLen-Len(SqlInfo(2,i))-1 end if if ShowPrefix=True and SqlInfo(18,i)<>"" then strTemp = strTemp & "<font color=blue>"&SqlInfo(18,i)&"</font>" sTitleLen=sTitleLen-Len(SqlInfo(18,i))-2 end if if Instr(SqlInfo(7,i),"|")>0 then Author=Split(SqlInfo(7,i),"|") AuthorName=Author(0) AuthorEmail=Author(1) else AuthorName=SqlInfo(7,i) AuthorEmail="Aspoo@126.com" end if if SqlInfo(24,i)=True and Clng(Cl.Channel_Setting(10))=1 then LinkUrl=Cl.WebDir & SqlInfo(25,i) else LinkUrl=Cl.WebDir & Cl.Channel_Setting(4) & "/ArticleShow.asp?ArticleID="&SqlInfo(0,i) end if strTemp = strTemp & "<a href=""" & LinkUrl & """ title=""标题:" & SqlInfo(6,i) & vbcrlf & "作者:" & AuthorName & vbcrlf & "更新:" & SqlInfo(9,i) & vbcrlf & "点击:" & SqlInfo(13,i) & """ target=""_blank"">" TitleStr=Cl.GotTopic(SqlInfo(6,i),sTitleLen) TitleStr=Cl.GetTitleFont(TitleStr,SqlInfo(12,i)) TitleStr=Cl.FormatColor(TitleStr,SqlInfo(11,i)) strTemp=strTemp & TitleStr & "</a></td><td align=right>" if ShowHot=True then if CDate(SqlInfo(9,i))=date() then strTemp= strTemp & "<img src=""" & Cl.mainpic(7) & """ alt=""最新"">" elseif SqlInfo(13,i)>=Clng(Cl.Web_Setting(14)) then strTemp= strTemp & "<img src=""" & Cl.mainpic(8) & """ alt=""热门"">" end if end if if ShowAuthor=True or ShowHits=True or ShowDateType>0 then strTemp = strTemp & "(" if ShowAuthor=True then strTemp=strTemp & "<a href=""mailto:" & AuthorEmail & """>" & AuthorName & "</a>" end if if ShowHits=True then if ShowAuthor=True then strTemp=strTemp & "," end if strTemp=strTemp & Cl.FormatColor(SqlInfo(13,i),"#ff0033") end if if ShowDateType>0 then if ShowHits=True or ShowAuthor=True then strTemp=strTemp & "," end if if CDate(SqlInfo(9,i))=date() then strTemp = strTemp & "<font color=red>" else strTemp = strTemp & "<font color=#999999>" end if strtemp = strtemp & Cl.Format_Time(SqlInfo(9,i),ShowDateType) & "</font>" end if strTemp = strTemp & ")</td></tr>" end if strTemp= strTemp & "<tr><td height=""1"" background=""/images/title_bottom_line.gif""></td><td height=""1"" background=""/images/title_bottom_line.gif""></td></tr>" Next ShowArticle=strTemp & "</table>" SqlInfo="" end Function