通用信息列表(解释版)
'
''
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版 附件:通用信息列表(解释版)