SiteFactory正式版

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