通用信息列表(解释版)

作者:cicna 来源:本站原创 点击数: 发布时间:2010年06月22日
通用信息列表




























































































'

''










AND CM.LinkType = 0





AND SI.SpecialID IN ()






AND 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()) <=













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.Inputer = ''





AND CM.Editor = ''





AND (CONVERT(varchar(10) , CM.UpdateTime, 120 )>= '') AND (CONVERT(varchar(10) , CM.UpdateTime, 120 )<= '')



AND IncludePic LIKE '%[图文]%'


































titleLength="" linkOpenType="" nodes="" displayCommentLink="" displayEditor="" displayPropertyPrefix="" displayDateTime="" displayTitlePrefix="" displayHits="" displayTips="" displayInputer="" displayNodeName="" displayHotSign="" displayNewSign="" optionalExtend=""







通用信息列表_



















































CM.GeneralID DESC


CM.GeneralID ASC

CM.UpdateTime DESC,CM.GeneralID DESC

CM.UpdateTime ASC,CM.GeneralID DESC

CM.Hits DESC,CM.GeneralID DESC

CM.Hits ASC,CM.GeneralID DESC

CM.CommentAudited DESC,CM.GeneralID DESC

CM.CommentAudited ASC,,CM.GeneralID DESC

CM.DayHits DESC,CM.GeneralID DESC


CM.DayHits ASC,CM.GeneralID DESC

CM.WeekHits DESC,CM.GeneralID DESC

CM.WeekHits ASC,CM.GeneralID DESC

CM.MonthHits DESC,CM.GeneralID DESC

CM.MonthHits ASC,CM.GeneralID DESC

CM.EliteLevel DESC,CM.GeneralID DESC

CM.EliteLevel ASC,CM.GeneralID DESC

CM.Priority DESC,CM.GeneralID DESC

CM.Priority ASC,CM.GeneralID DESC

CM.Hits DESC,CM.UpdateTime DESC,CM.GeneralID DESC

CM.EliteLevel DESC,CM.UpdateTime DESC,CM.GeneralID DESC

CM.Priority DESC,CM.UpdateTime DESC,CM.GeneralID DESC

CM.CommentAudited DESC,CM.UpdateTime DESC,CM.GeneralID DESC

CM.UpdateTime DESC,CM.GeneralID DESC



































































,

0
















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 AND 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_CommonModelCM', 'CM.GeneralID', '*', @pagesize, @startrow, 'CM.Status = 99



', '', '' ;" queryCount="SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM WHERE CM.Status = 99



" page="true" pagesize="" urlpage="true" /}





{PE.Label id="" queryCond="SELECT TOP * FROM PE_CommonModelCM WHERE CM.Status = 99



ORDER BY " page="false" /}













指定了不存在的栏目ID或栏目数组!
















 

word版 附件:通用信息列表(解释版)