124 lines
4.6 KiB
XML
124 lines
4.6 KiB
XML
<?xml version="1.0"?>
|
|
<root>
|
|
<LabelType>其他类</LabelType>
|
|
<LabelIntro>
|
|
</LabelIntro>
|
|
<OutType>sin</OutType>
|
|
<LabelDataType>sql_sysquery</LabelDataType>
|
|
<EnabelAjax>False</EnabelAjax>
|
|
<attributes>
|
|
<name>moodId</name>
|
|
<datatype>supersql</datatype>
|
|
<default>1</default>
|
|
<intro>心情指数方案ID</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>outputQty</name>
|
|
<datatype>supersql</datatype>
|
|
<default>10</default>
|
|
<intro>输出多少条项目</intro>
|
|
</attributes>
|
|
<IsXsltSql>false</IsXsltSql>
|
|
<IsXsltCountSql>false</IsXsltCountSql>
|
|
<LabelSqlString>SELECT TOP @outputQty * FROM PE_Mood INNER JOIN PE_CommonModel ON (PE_Mood.GeneralID = PE_CommonModel.GeneralID) WHERE PE_Mood.MoodID = @moodId ORDER BY M@orderType 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="moodId" />
|
|
<xsl:param name="orderType" />
|
|
<xsl:param name="outputQty" />
|
|
<xsl:output method="html" />
|
|
<xsl:template match="/NewDataSet/Table">
|
|
<li>
|
|
<span style="float:right">
|
|
<xsl:call-template name="GetMoodValue">
|
|
<xsl:with-param name="position" select="$orderType"/>
|
|
</xsl:call-template>
|
|
</span>
|
|
<a>
|
|
<xsl:attribute name="href">
|
|
<xsl:value-of select="pe:GetInfoPath(NodeID,GeneralID,InputTime,PinyinTitle,HtmlPageName)"/>
|
|
</xsl:attribute>
|
|
<xsl:attribute name="target">_blank</xsl:attribute>
|
|
<xsl:attribute name="title">标题：<xsl:value-of select="Title"/>
|
|
<xsl:value-of select="'
'" />点击数：<xsl:value-of select="Hits"/>
|
|
<xsl:value-of select="'
'" />发表时间：<xsl:value-of select="pe:FormatDate(UpdateTime, 'yy年mm月dd日')" />
|
|
</xsl:attribute>
|
|
<xsl:value-of select="pe:CutText(Title,50,'…')" />
|
|
</a>
|
|
</li>
|
|
</xsl:template>
|
|
<xsl:template name="GetMoodValue">
|
|
<xsl:param name="position" />
|
|
<xsl:choose>
|
|
<xsl:when test="$position = 0">
|
|
<xsl:value-of select="M0"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 1">
|
|
<xsl:value-of select="M1"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 2">
|
|
<xsl:value-of select="M2"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 3">
|
|
<xsl:value-of select="M3"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 4">
|
|
<xsl:value-of select="M4"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 5">
|
|
<xsl:value-of select="M5"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 6">
|
|
<xsl:value-of select="M6"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 7">
|
|
<xsl:value-of select="M7"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 8">
|
|
<xsl:value-of select="M8"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 9">
|
|
<xsl:value-of select="M9"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 10">
|
|
<xsl:value-of select="M10"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 11">
|
|
<xsl:value-of select="M11"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 12">
|
|
<xsl:value-of select="M12"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 13">
|
|
<xsl:value-of select="M13"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 14">
|
|
<xsl:value-of select="M14"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 15">
|
|
<xsl:value-of select="M15"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 16">
|
|
<xsl:value-of select="M16"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 17">
|
|
<xsl:value-of select="M17"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 18">
|
|
<xsl:value-of select="M8"/>
|
|
</xsl:when>
|
|
<xsl:when test="$position = 19">
|
|
<xsl:value-of select="M19"/>
|
|
</xsl:when>
|
|
</xsl:choose>
|
|
</xsl:template>
|
|
</xsl:stylesheet>]]>
|
|
</LabelTemplate>
|
|
<attributes>
|
|
<name>orderType</name>
|
|
<datatype>supersql</datatype>
|
|
<default>0</default>
|
|
<intro>排序方式M0为第一个选项以此类推</intro>
|
|
</attributes>
|
|
</root> |