?? 專題下信息列表.config
字號:
<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="titleLength" />
<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 select="pe:CutText(Title,$titleLength,'...')"/>
</Title>
<InfoPath>
<xsl:value-of disable-output-escaping="yes" select="pe:GetInfoPath(NodeID,GeneralID,InputTime,PinyinTitle)"/>
</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>titleLength</name>
<default>20</default>
<intro>標題最多字符數</intro>
</attributes>
<IsXsltSql>false</IsXsltSql>
<IsXsltCountSql>false</IsXsltCountSql>
</root>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -