selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidorderbyorderid)and(parentid=@parentid)orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid order by OrderID) and (ParentID = @parentid) AND PurviewType < 3 order by OrderID]]>
selectcount(*)frompe_nodeswhereparentid=@parentid
<![CDATA[SELECT count(*) from PE_Nodes where ParentID = @parentid AND PurviewType < 3]]>
selecttop1c.generalid,c.title,c.hits,c.updatetimefromdbo.pe_nodesn,dbo.pe_commonmodelcwherec.generalid>@itemidandcharindex(','+rtrim(c.nodeid)+',',','+cast(@arrnodeidasnvarchar(100))+',')>0andc.status=99andn.parentid=@parentidorderbyc.generalidasc
<![CDATA[SELECT TOP 1 C.GeneralID,C.Title,C.Hits,C.UpdateTime FROM dbo.PE_Nodes N,dbo.PE_CommonModel C WHERE C.GeneralID > @ItemID AND CHARINDEX(',' + RTRIM(C.NodeID) +',',',' + CAST(@arrNodeID AS NVARCHAR(100)) +',') > 0 AND C.Status = 99 AND N.ParentID = @ParentID AND N.PurviewType < 3 ORDER BY C.GeneralID ASC]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,n.nodenamefrompe_commonmodelcleftjoinpe_nodesnonc.nodeid=n.nodeidwherec.status=99andc.elitelevel>=@elitelevelorderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,N.NodeName FROM PE_CommonModel C LEFT JOIN PE_Nodes N ON C.NodeID=N.NodeID WHERE C.Status = 99 AND C.EliteLevel >= @elitelevel AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selectnodeid,nodenamefrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT NodeID,NodeName FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selecttop1*frompe_nodeswherenodeid=@parentid
<![CDATA[SELECT Top 1 * FROM PE_Nodes WHERE NodeID = @parentid AND PurviewType < 3 ]]>
selectn.nodeid,n.nodename,n.parentpath,c.titlefrompe_nodesninnerjoinpe_commonmodelconn.nodeid=c.nodeidwherec.generalid=@itemid
<![CDATA[SELECT N.NodeID,N.NodeName,N.ParentPath,C.Title FROM PE_Nodes N INNER JOIN PE_CommonModel C ON N.NodeID=C.NodeID WHERE C.GeneralID=@itemid AND PurviewType < 3]]>
selectnodeid,nodename,arrchildid,parentpathfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT NodeID,NodeName,arrChildID,ParentPath FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selectrootidfrompe_nodeswherenodeid=(selectnodeidfrompe_commonmodelwheregeneralid=@generalid)
<![CDATA[SELECT rootId from pe_nodes where nodeid=(SELECT nodeid from pe_commonModel where generalid=@generalid) AND PurviewType < 3]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhere(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1orderbyorderid)and((parentid=@parentid)or(nodeid=@parentid))andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where (ParentID = @parentid OR NodeID=@parentid) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID) and ((ParentID = @parentid) OR (NodeID=@parentid)) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID]]>
selectcount(*)frompe_nodeswhere(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1
<![CDATA[SELECT count(*) from PE_Nodes where (ParentID = @parentid OR NodeID=@parentid) AND ShowOnList_Parent=1 AND PurviewType < 3 ]]>
selectnodeid,arrchildidfrompe_nodeswhereparentid=@parentid
<![CDATA[SELECT NodeID,arrChildID FROM PE_Nodes WHERE ParentId=@parentid AND PurviewType < 3 ]]>
selecttop@shownumpe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhere(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1orderbyorderid)and(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @shownum PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where (ParentID = @parentid or NodeID=@parentid) AND ShowOnList_Parent=1 order by OrderID) and (ParentID = @parentid or NodeID=@parentid AND PurviewType < 3 ) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID]]>
selectnodeid,nodename,showonlist_parentfrompe_nodeswherenodeid=@nodeidandnodetype=1orderbyorderidasc
<![CDATA[SELECT nodeId,nodeName,ShowOnList_Parent from pe_nodes where NodeId=@nodeid and NodeType=1 AND PurviewType < 3 ORDER BY OrderID ASC]]>
selectnodeid,nodenamefrompe_nodeswherenodeid=@nodeid
<![CDATA[SELECT NodeID,NodeName From PE_Nodes Where NodeID=@nodeid AND PurviewType < 3 ]]>
selectnodeid,arrchildidfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT NodeID,arrChildID from PE_Nodes where NodeID=@parentid AND PurviewType < 3]]>
selectarrchildidfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT arrchildid from PE_Nodes where NodeID=@parentid AND PurviewType < 3 ]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidandshowonlist_parent=1orderbyorderid)and(parentid=@parentid)andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID) and (ParentID = @parentid) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID]]>
selectcount(*)frompe_nodeswhereparentid=@parentidandshowonlist_parent=1
<![CDATA[SELECT count(*) from PE_Nodes where ParentID = @parentid AND ShowOnList_Parent=1 AND PurviewType < 3 ]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidandshowonlist_parent=1orderbyorderid)and(parentid=@parentid)orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID) and (ParentID = @parentid) AND PurviewType < 3 order by OrderID]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,c.defaultpicurl,n.nodename,t.*from(pe_commonmodelcinnerjoinpe_nodesnonc.nodeid=n.nodeid)innerjoinpe_u_phototonc.itemid=t.idwhere(n.nodeid=@parentidorn.parentid=@parentid)andc.tablename='pe_u_photo'andc.status=99andc.defaultpicurl<>''orderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,C.DefaultPicUrl,N.NodeName,T.* FROM (PE_CommonModel C INNER JOIN PE_Nodes N ON C.NodeID=N.NodeID) INNER JOIN PE_U_Photo T ON C.ItemID=T.ID WHERE (N.NodeID=@parentid OR N.ParentId=@parentid) AND C.TableName='PE_U_Photo' AND C.Status=99 AND C.DefaultPicUrl<>'' AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selecttop@shownumc.generalid,c.nodeid,c.title,c.updatetime,c.defaultpicurl,n.nodename,t.*from(pe_commonmodelcinnerjoinpe_nodesnonc.nodeid=n.nodeid)innerjoinpe_u_phototonc.itemid=t.idwhere(n.nodeid=@parentidorn.parentid=@parentid)andc.tablename='pe_u_photo'andc.status=99andc.defaultpicurl<>''orderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.Title,C.UpdateTime,C.DefaultPicUrl,N.NodeName,T.* FROM (PE_CommonModel C INNER JOIN PE_Nodes N ON C.NodeID=N.NodeID) INNER JOIN PE_U_Photo T ON C.ItemID=T.ID WHERE (N.NodeID=@parentid OR N.ParentId=@parentid) AND C.TableName='PE_U_Photo' AND C.Status=99 AND C.DefaultPicUrl<>'' AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selecttop1nodeid,nodenamefrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT TOP 1 NodeID,NodeName FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selectnodeid,nodename,showonlist_indexfrompe_nodeswhereparentid=@nodeidandnodetype=1andshowonlist_parent=1orderbyorderidasc
<![CDATA[SELECT nodeid,nodename,showonlist_index from pe_nodes where ParentId=@nodeid and NodeType=1 and ShowOnList_Parent=1 and PurviewType < 3 order by OrderID asc]]>
selectnodeid,nodenamefrompe_n
没有合适的资源?快使用搜索试试~ 我知道了~
动易SF3.6_XXX(20101028)
共2000个文件
gif:994个
aspx:690个
config:409个
3星 · 超过75%的资源 需积分: 34 62 下载量 172 浏览量
2011-05-02
17:12:40
上传
评论
收藏 16.58MB RAR 举报
温馨提示
版本以XXX代替,你懂的。绝对值10分,不多说。自己下载看。不骗人。
资源推荐
资源详情
资源评论
收起资源包目录
动易SF3.6_XXX(20101028) (2000个子文件)
Global.asax 2KB
CodeSnippetPanel.ascx 24KB
CommentManage.ascx 20KB
LiaisonInformation.ascx 14KB
LiaisonInformation.ascx 14KB
Company.ascx 10KB
AuthorListControl.ascx 10KB
AuthorListControl.ascx 9KB
Company.ascx 9KB
MultiplePhotoType.ascx 9KB
MultiplePhotoType.ascx 9KB
UserIndividuation.ascx 8KB
CompanyInfo.ascx 7KB
PersonalInformation.ascx 6KB
CompanyInfo.ascx 6KB
PictureType.ascx 6KB
SourceListControl.ascx 6KB
LinkageType.ascx 6KB
FileType.ascx 5KB
LinkageType.ascx 5KB
PictureType.ascx 5KB
PersonalInformation.ascx 5KB
SourceListControl.ascx 5KB
CreateHtmlProgress.ascx 5KB
ShowUserHitHistory.ascx 5KB
MainContacter.ascx 5KB
FileType.ascx 4KB
ShowMessageList.ascx 4KB
ContentManageNavigation.ascx 4KB
ShowMessageListAdmin.ascx 4KB
VoteControl.ascx 4KB
CategoryManagerControl.ascx 4KB
SpecialType.ascx 4KB
CategoryInputerControl.ascx 4KB
ValidLog.ascx 4KB
IPLock.ascx 3KB
Edit.ascx 3KB
PointLog.ascx 3KB
Edit.ascx 3KB
SpecialType.ascx 3KB
ContentSigin.ascx 3KB
CompanyMemberManage.ascx 3KB
RegionType.ascx 3KB
RegionType.ascx 3KB
Edit.ascx 3KB
Edit.ascx 3KB
UserPermissionModify.ascx 3KB
KeywordType.ascx 3KB
ContentType.ascx 3KB
KeywordType.ascx 3KB
ContentType.ascx 3KB
CategoryMonthControl.ascx 3KB
CompanyMemberManage.ascx 2KB
FloatingDialog.ascx 2KB
ShowUserInfo.ascx 2KB
Edit.ascx 2KB
Edit.ascx 2KB
NodeType.ascx 2KB
InputerMonthControl.ascx 2KB
ManagerMonthControl.ascx 2KB
NodeType.ascx 2KB
Region.ascx 2KB
widget.ascx 2KB
Edit.ascx 2KB
Edit.ascx 2KB
ShowUserInfo.ascx 2KB
SelectUser.ascx 2KB
Region.ascx 2KB
ScoreControl.ascx 2KB
SelectUser.ascx 2KB
widget.ascx 2KB
widget.ascx 2KB
widget.ascx 2KB
ScoreControl.ascx 2KB
widget.ascx 2KB
ListBoxType.ascx 2KB
WidgetEdit.ascx 2KB
TitleType.ascx 2KB
ListBoxType.ascx 2KB
AttachFieldControl.ascx 2KB
TitleType.ascx 2KB
WidgetEdit.ascx 2KB
widget.ascx 2KB
widget.ascx 2KB
widget.ascx 2KB
widget.ascx 2KB
widget.ascx 1KB
ContentCharge.ascx 1KB
DateTimeType.ascx 1KB
DateTimeType.ascx 1KB
ChargeTypeSetting.ascx 1KB
NumberType.ascx 1KB
WorkViewTemplateControl.ascx 1KB
SelectUser.ascx 1KB
HorizontalRegion.ascx 1KB
SourceType.ascx 1KB
ContentAdminControl.ascx 1KB
ContentUserControl.ascx 1KB
NumberType.ascx 1KB
WorkViewTemplateControl.ascx 1KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
- zhanglm1192014-11-18资源不错,测试可以用,比cms版的功能强大很多。
- woaichuangyi112012-09-15可以倒是可以 就是有些功能不能实现
- 重庆大彬哥2014-11-22其实就是专业版,郁闷啊,我还以为是好模板呢。
红色传奇
- 粉丝: 7
- 资源: 16
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功