专题下信息列表.config

动易SiteFactory网上商店系统正式版动易SiteFactory网上商店系统正式版

<root>
  <LabelDataType>sql_sysquery</LabelDataType>
  <LabelType>数据源标签</LabelType>
  <LabelImage>../../Admin/Images/LabelIco/GetPicArticle.gif</LabelImage>
  <LabelIntro>
  </LabelIntro>
  <LabelSqlString>SELECT Top @pagesize C.*,I.SpecialID FROM PE_CommonModel C INNER JOIN PE_SpecialInfos I ON C.GeneralID=I.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM PE_CommonModel IC INNER JOIN PE_SpecialInfos II ON IC.GeneralID=II.GeneralID WHERE II.SpecialID =@specialid AND IC.Status=99 ORDER BY IC.UpdateTime DESC) AND I.SpecialID=@specialid AND C.Status=99 ORDER BY C.UpdateTime DESC
</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="titlelen" />
<xsl:param name="specialid" />
<xsl:output method="xml" />
<xsl:template match="/">
<NewDataSet>
<xsl:for-each select="NewDataSet/Table">
<Table>
<GeneralId>
<xsl:value-of select="GeneralId"/>
</GeneralId>
<Inputer>
<xsl:value-of select="Inputer"/>
</Inputer>
<Hits>
<xsl:value-of select="Hits"/>
</Hits>
<UpdateTime>
<xsl:value-of select="pe:FormatDate(UpdateTime,'yyyy-mm-dd')"/>
</UpdateTime>
<SpecialName>
<xsl:value-of select="pe:GetSpecial($specialid,'name')"/>
</SpecialName>
<Title>
<xsl:value-of disable-output-escaping="yes" select="pe:CutText(pe:EncodeText(Title,'htmldecode'),$titlelen,'...')"/>
</Title>
<InfoPath>
<xsl:value-of select="pe:GetInfoPath(GeneralID)"/>
</InfoPath>
</Table>
</xsl:for-each>
</NewDataSet>
</xsl:template>
</xsl:transform>]]></LabelTemplate>
  <OutType>
  </OutType>
  <CacheTime>0</CacheTime>
  <UsePage>True</UsePage>
  <LabelSqlCount>select count(C.GeneralID) from PE_CommonModel C INNER JOIN PE_SpecialInfos I ON C.GeneralID=I.GeneralID  where I.SpecialID =@specialid and C.Status=99</LabelSqlCount>
  <attributes>
    <name>specialid</name>
    <default>1</default>
    <intro>专题ID</intro>
  </attributes>
  <attributes>
    <name>titlelen</name>
    <default>20</default>
    <intro>标题最多字符数</intro>
  </attributes>
</root>