通用信息列表

1、!-通用信息列表 !-定義了輸出文檔的格式、 是頂層元素(top-level element)，必須是 或 的子節(jié)點(diǎn)。定義輸出的格式html、設(shè)置輸出格式的W3C版本號(僅在method=html or method=xml時(shí)使用)、設(shè)置輸出中編碼屬性的值、在輸出結(jié)果樹時(shí)是否要增加空白-輸出的項(xiàng)目數(shù)量由節(jié)點(diǎn)配置取代-可選擴(kuò)展查詢約束條件（啟用分頁時(shí)，請匆用）-!-!-!- SQL查詢約束條件將增加該項(xiàng)約束條件，注：CM是PE_CommonModel的別名，以下出現(xiàn)的CM就是代表AND CM.LinkType = 0PE_CommonModel 表-AND SI.SpecialID IN ()A

2、ND CM.ModelID IN ()AND CM.GeneralID IN ()AND CM.EliteLevel = AND CM.Priority = AND CM.Hits = AND CM.DayHits = AND CM.WeekHits = AND CM.MonthHits = AND DATEDIFF(d,CM.UpdateTime,GETDATE() = 定了應(yīng)在日期的哪一部分計(jì)算差額的參數(shù),如計(jì)算多少日(d),開始日期，結(jié)束日期-!-如果-!- DATEDIFF返回跨兩個(gè)指定日期的日期和時(shí)間邊界數(shù),DATEDIFF ( datepart , startdate , endd

3、ate ) ,datepart是規(guī)AND CM.DefaultPicUrl !=AND CM.Inputer = AND CM.Editor = AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) = ) AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) = )AND IncludePic LIKE %圖文% AND CM.DefaultPicUrl !=AND CM.DefaultPicUrl !=AND CM.Inputer = AND CM.Inputer = AND CM.Editor = AND

4、 (CONVERT(varchar(10) , CM.UpdateTime, 120 ) = ) AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) = )AND IncludePic LIKE %圖文% !-可選擴(kuò)展查詢約束條件，啟用分頁時(shí)titleLength= linkOpenType= nodes= displayCommentLink= displayEditor= displayPropertyPrefix= displayDateTime= displayTitlePrefix= displayHits= displayTips= di

5、splayInputer= displayNodeName= display HotSign= displayNewSign= optionalExtend=通用信息列表 _!-!-定義一個(gè)變量CM.GeneralID DESCCM.GeneralID ASCCM.UpdateTime DESC,CM.GeneralID DESCCM.UpdateTime ASC,CM.GeneralID DESCCM.Hits DESC,CM.GeneralID DESCCM.Hits ASC,CM.GeneralID DESCCM.CommentAudited DESC,CM.GeneralID DESC

6、CM.CommentAudited ASC,CM.GeneralID DESCCM.DayHits DESC,CM.GeneralID DESCCM.DayHits ASC,CM.GeneralID DESCCM.WeekHits DESC,CM.GeneralID DESCCM.WeekHits ASC,CM.GeneralID DESCCM.MonthHits DESC,CM.GeneralID DESCCM.MonthHits ASC,CM.GeneralID DESCCM.EliteLevel DESC,CM.GeneralID DESCCM.EliteLevel ASC,CM.Gen

7、eralID DESCCM.Priority DESC,CM.GeneralID DESCCM.Priority ASC,CM.GeneralID DESCCM.Hits DESC,CM.UpdateTime DESC,CM.GeneralID DESCCM.EliteLevel DESC,CM.UpdateTime DESC,CM.GeneralID DESCCM.Priority DESC,CM.UpdateTime DESC,CM.GeneralID DESC CM.CommentAudited DESC,CM.UpdateTime DESC,CM.GeneralID DESC CM.U

8、pdateTime DESC,CM.GeneralID DESC 0 0 xsl:when test=$includeChildNodes = false,!-每循環(huán)某一個(gè)節(jié)點(diǎn)下的所有子節(jié)點(diǎn)就在后面加一個(gè)逗號00!-定義一個(gè)變量INNER JOIN PE_SpecialInfos SI ON (CM.ItemID = SI.GeneralID)PE.Label id= queryCond=EXEC dbo.PR_Common_PagingLarge PE_CommonModel CM , CM.GeneralID, *, pagesize, startrow,CM.Status = 99 AN

9、D CM.NodeID IN (),;queryCount=SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM WHERE CM.Status = 99 AND CM.NodeID IN ()page=true pagesize= urlpage=true /PE.Label id= queryCond=SELECT TOP * FROM PE_CommonModel CM WHERE CM.Status = 99 AND CM.NodeID IN ()ORDER BY page=false /PE.Label id= queryCond=EXEC dbo.PR_Common_PagingLarge PE_CommonModel CM , CM.GeneralID, *, pagesize, startrow, CM.Status = 99 , , ; queryCount=SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM WHERECM.Status = 99 p