专题类别下的专题_数据源.config

来自「BizIdea 是基于.net开发平台全新研发的企业级电子商务平台系统」· CONFIG 代码 · 共 44 行

<root>
  <LabelDataType>sql_sysquery</LabelDataType>
  <LabelType>专题类</LabelType>
  <LabelImage>../../Admin/Images/LabelIco/GetPicArticle.gif</LabelImage>
  <LabelIntro>数据源模式</LabelIntro>
  <LabelSqlString>SELECT TOP @pagesize T.SpecialID,T.SpecialName FROM PE_Specials T WHERE T.SpecialID NOT IN (SELECT TOP @startrow IT.SpecialID FROM PE_Specials IT WHERE IT.SpecialCategoryID=@specialCategoryId) AND T.SpecialCategoryID = @specialCategoryId</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:output method="xml" />
  <xsl:template match="/">
    <NewDataSet>
      <xsl:for-each select="NewDataSet/Table">
        <Table>
          <SpecialID>
            <xsl:value-of select="SpecialID"/>
          </SpecialID>
          <SpecialName>
            <xsl:value-of select="SpecialName"/>
          </SpecialName>
          <SpecialPath>
            &lt;a href="<xsl:value-of select="pe:GetSpecialPath(SpecialID)"/>"&gt;<xsl:value-of select="SpecialName"/>&lt;/a&gt;
          </SpecialPath>
          <SpecialLink>
            <xsl:value-of select="pe:GetSpecialPath(SpecialID)"/>
          </SpecialLink>
        </Table>
      </xsl:for-each>
    </NewDataSet>
  </xsl:template>
</xsl:transform>]]></LabelTemplate>
  <OutType>
  </OutType>
  <CacheTime>0</CacheTime>
  <UsePage>True</UsePage>
  <LabelSqlCount>SELECT COUNT(IT.SpecialID) FROM PE_Specials IT WHERE IT.SpecialCategoryID = @specialCategoryId</LabelSqlCount>
  <attributes>
    <name>specialCategoryId</name>
    <default>1</default>
    <intro>专题类别ID</intro>
  </attributes>
  <EnabelAjax>False</EnabelAjax>
  <IsXsltSql>false</IsXsltSql>
  <IsXsltCountSql>false</IsXsltCountSql>
</root>