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
没有合适的资源?快使用搜索试试~ 我知道了~
动易SiteFactory专业版_3.1.6.0-3.5.0.0 升级包
共1066个文件
config:393个
gif:153个
aspx:138个
5星 · 超过95%的资源 需积分: 9 5 下载量 150 浏览量
2010-04-29
11:46:11
上传
评论
收藏 5.97MB RAR 举报
温馨提示
动易SiteFactory专业版_3.1.6.0-3.5.0.0 升级包
资源推荐
资源详情
资源评论
收起资源包目录
动易SiteFactory专业版_3.1.6.0-3.5.0.0 升级包 (1066个子文件)
Global.asax 2KB
CodeSnippetPanel.ascx 24KB
LiaisonInformation.ascx 15KB
LiaisonInformation.ascx 14KB
IPLock.ascx 3KB
SpecialType.ascx 3KB
SpecialType.ascx 3KB
FloatingDialog.ascx 2KB
ScoreControl.ascx 2KB
ColorType.ascx 967B
ColorType.ascx 961B
widget.ascx 624B
FrontPageTemplateConfig.aspx 123KB
Field.aspx 108KB
Category.aspx 106KB
PayOnline.aspx 64KB
CategoryBatchSet.aspx 62KB
Special.aspx 43KB
Single.aspx 34KB
ADZone.aspx 33KB
UserConfig.aspx 32KB
Default.aspx 28KB
FieldRule.aspx 26KB
UpLoadFilesConfig.aspx 23KB
ConfigStep2.aspx 21KB
IndexConfigs.aspx 20KB
SiteOption.aspx 20KB
Content.aspx 20KB
StatConfig.aspx 19KB
SmsConfig.aspx 19KB
NodePermissions.aspx 17KB
QAConfig.aspx 17KB
PaymentAction.aspx 17KB
Vote.aspx 17KB
SetSearchConfig.aspx 15KB
ThumbConfig.aspx 15KB
UserManage.aspx 14KB
Index.aspx 14KB
ContentManage.aspx 14KB
LabelProperty.aspx 13KB
Template.aspx 11KB
LabelTemplate.aspx 11KB
SurveyManage.aspx 11KB
SoftPreview.aspx 10KB
MailConfig.aspx 10KB
Question.aspx 10KB
Administrator.aspx 10KB
PayResultTenpayMed.aspx 9KB
Survey.aspx 9KB
VoteManage.aspx 9KB
PhotoPreview.aspx 9KB
LabelLevelAnalay.aspx 9KB
SiteGroupOption.aspx 9KB
VoteShow.aspx 8KB
PayResultAlipay.aspx 8KB
UserNameList.aspx 8KB
ShowUploadFiles.aspx 8KB
ShowVote.aspx 8KB
NavContent.aspx 8KB
UserList.aspx 8KB
Department.aspx 8KB
DepartmentManage.aspx 8KB
WorkManage.aspx 8KB
WorkCategory.aspx 7KB
PayResultAlipayInstant.aspx 7KB
RedirectUrlManage.aspx 7KB
LabelManage.aspx 7KB
SpecialCategory.aspx 6KB
ShowResult.aspx 6KB
Message.aspx 6KB
PayResult99bill.aspx 6KB
PayResultAlipayGuarantee.aspx 6KB
PointLogManage.aspx 6KB
PayResultTenpayMedShow.aspx 6KB
PayResult99billSzx.aspx 6KB
IPLockConfig.aspx 6KB
InsideLink.aspx 6KB
OutLink.aspx 6KB
DepartmentMembers.aspx 5KB
Signin.aspx 5KB
CustomFormManage.aspx 5KB
SiteInfo.aspx 5KB
AdminList.aspx 5KB
LogManager.aspx 5KB
VoteTreeIndex.aspx 5KB
PayResultCncard.aspx 5KB
MailSubscriptionConfig.aspx 5KB
ShareDataConfigAdd.aspx 5KB
ShareDataManage.aspx 5KB
IndexGuide.aspx 5KB
IPManage.aspx 5KB
Login.aspx 5KB
VoteTreeManage.aspx 5KB
ContentList.aspx 4KB
S.aspx 4KB
PayResultYeepay.aspx 4KB
ConfigStep3.aspx 4KB
MyComment.aspx 4KB
ShareDataView.aspx 4KB
RedirectUrl.aspx 4KB
共 1066 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
- jouzz2014-03-07已经很难找了,动易都不提供了,真不厚道!
gdccna
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功