栏目循环列表_数据源.config

BizIdea 是基于.net开发平台全新研发的企业级电子商务平台系统

<root>
  <LabelDataType>sql_sysquery</LabelDataType>
  <LabelType>栏目类</LabelType>
  <LabelImage>../../Admin/Images/LabelIco/GetPicArticle.gif</LabelImage>
  <LabelIntro>
  </LabelIntro>
  <LabelSqlString>SELECT TOP @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes WHERE ParentID = @parentId AND NodeType=1 AND ShowOnList_Parent=1  AND PurviewType != 3  ORDER BY OrderID) AND (ParentID = @parentId) AND NodeType=1 AND ShowOnList_Parent=1 AND PurviewType != 3  ORDER BY OrderID</LabelSqlString>
  <LabelTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pe="labelproc" exclude-result-prefixes="pe">
 <xsl:param name="parentId"/>
 <xsl:output method="xml" />
 <xsl:template match="/">
  <NewDataSet>
   <xsl:for-each select="NewDataSet/Table">
    <Table>
     <NodeID>
      <xsl:value-of select="NodeID"/>
     </NodeID>
     <NodeName>
      <xsl:value-of select="NodeName"/>
     </NodeName>
     <MoreLink>
      &lt;a href="<xsl:value-of select="pe:GetNodePath('true',NodeID)"/>" target="_blank"&gt;[更多] &lt;/a&gt;
     </MoreLink>
     <NodeLink>
      &lt;a href="<xsl:value-of select="pe:GetNodePath('true',NodeID)"/>" target="_blank"&gt;<xsl:value-of select="pe:GetNode(NodeID,'name')"/> &lt;/a&gt;
     </NodeLink>
     <ParentNodePath>
      &lt;a href="<xsl:value-of select="pe:GetNodePath('true',$parentId)"/>"&gt;<xsl:value-of select="pe:GetNode($parentId,'name')"/>&lt;/a&gt;
     </ParentNodePath>
    </Table>
   </xsl:for-each>
  </NewDataSet>
 </xsl:template>
</xsl:transform>]]></LabelTemplate>
  <OutType>sin</OutType>
  <CacheTime>0</CacheTime>
  <attributes>
    <name>parentId</name>
    <default>1</default>
    <intro>父栏目ID</intro>
  </attributes>
  <UsePage>True</UsePage>
  <LabelSqlCount>SELECT COUNT(*) FROM PE_Nodes WHERE ParentID = @parentId AND NodeType=1 AND ShowOnList_Parent=1 AND PurviewType != 3 </LabelSqlCount>
  <EnabelAjax>False</EnabelAjax>
  <IsXsltSql>false</IsXsltSql>
  <IsXsltCountSql>false</IsXsltCountSql>
</root>