76 lines
2.5 KiB
XML
76 lines
2.5 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<root>
|
|
<LabelType>博客类</LabelType>
|
|
<LabelIntro>
|
|
</LabelIntro>
|
|
<OutType>sin</OutType>
|
|
<LabelDataType>sql_sysquery</LabelDataType>
|
|
<EnabelAjax>False</EnabelAjax>
|
|
<Version officialVersion="" modifiedVersions="2902" compatibleVersion="" />
|
|
<attributes>
|
|
<name>blogId</name>
|
|
<datatype>sql.int</datatype>
|
|
<default>0</default>
|
|
<intro>博客ID</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>outputQty</name>
|
|
<datatype>supersql</datatype>
|
|
<default>7</default>
|
|
<intro>输出评论数</intro>
|
|
</attributes>
|
|
<IsXsltSql>false</IsXsltSql>
|
|
<IsXsltCountSql>false</IsXsltCountSql>
|
|
<LabelSqlString>
|
|
SELECT TOP @outputQty C.LogID,C.UserName CUN,C.Content,C.CreateTime,C.Nickname,L.BlogID,L.UpdateTime,B.BlogID BID FROM PE_BG_Comment C INNER JOIN PE_BG_log L ON C.LogID = L.LogID LEFT JOIN PE_BG_Blog B ON C.UserName=B.UserName WHERE L.BlogID=@blogId AND C.Status = 1 AND L.State = 1 ORDER BY C.CommentID DESC
|
|
</LabelSqlString>
|
|
<LabelTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>
|
|
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pe="labelproc" exclude-result-prefixes="pe">
|
|
<xsl:param name="blogId" />
|
|
<xsl:param name="outputQty" />
|
|
<xsl:param name="contentLength" />
|
|
<xsl:output method="html" />
|
|
<xsl:template match="/">
|
|
<xsl:choose>
|
|
<xsl:when test="count(/NewDataSet/Table)=0">
|
|
<li class="nolistdata" >暂无评论信息！</li>
|
|
</xsl:when>
|
|
<xsl:otherwise>
|
|
<xsl:for-each select="/NewDataSet/Table">
|
|
<li>
|
|
<strong>
|
|
<xsl:choose>
|
|
<xsl:when test="CUN=''">
|
|
<xsl:value-of select="Nickname"/>
|
|
</xsl:when>
|
|
<xsl:otherwise>
|
|
<a title="{Nickname}" href="{pe:InstallDir()}Blog/UserIndex.aspx?id={BID}">
|
|
<xsl:value-of select="Nickname"/>
|
|
</a>
|
|
</xsl:otherwise>
|
|
</xsl:choose>
|
|
</strong>
|
|
<span>
|
|
<xsl:value-of select="pe:FormatDate(CreateTime,'yyyy-mm-dd hh:ff')"/>
|
|
</span>
|
|
<p>
|
|
<a>
|
|
<xsl:attribute name="href">
|
|
<xsl:value-of select="pe:InstallDir()"/>Blog/Item.aspx?id=<xsl:value-of select="BlogID"/>&logId=<xsl:value-of select="LogID"/>#commentform
|
|
</xsl:attribute>
|
|
<xsl:value-of select="pe:CutText(pe:RemoveHtml(Content),$contentLength,'...')"/>
|
|
</a>
|
|
</p>
|
|
</li>
|
|
</xsl:for-each>
|
|
</xsl:otherwise>
|
|
</xsl:choose>
|
|
</xsl:template>
|
|
</xsl:stylesheet>]]></LabelTemplate>
|
|
<attributes>
|
|
<name>contentLength</name>
|
|
<datatype>int</datatype>
|
|
<default>30</default>
|
|
<intro>输出评论内容长度</intro>
|
|
</attributes>
|
|
</root> |