227 lines
7.1 KiB
XML
227 lines
7.1 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<root>
|
|
<LabelType>百科类</LabelType>
|
|
<LabelIntro>
|
|
</LabelIntro>
|
|
<OutType>sin</OutType>
|
|
<LabelDataType>static</LabelDataType>
|
|
<EnabelAjax>False</EnabelAjax>
|
|
<Version officialVersion="" modifiedVersions="4721" compatibleVersion="" />
|
|
<attributes>
|
|
<name>titleLength</name>
|
|
<datatype>int</datatype>
|
|
<default>20</default>
|
|
<intro>标题长度</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>linkOpenType</name>
|
|
<datatype>string</datatype>
|
|
<default>_blank</default>
|
|
<intro>链接打开方式</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>outputQty</name>
|
|
<datatype>supersql</datatype>
|
|
<default>20</default>
|
|
<intro>输出记录数</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>bindStyle</name>
|
|
<datatype>string</datatype>
|
|
<default>普通式</default>
|
|
<intro>样式标签名称</intro>
|
|
</attributes>
|
|
<IsXsltSql>false</IsXsltSql>
|
|
<IsXsltCountSql>false</IsXsltCountSql>
|
|
<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="linkOpenType" />
|
|
<xsl:param name="titleLength" />
|
|
<xsl:param name="outputQty" />
|
|
<xsl:param name="bindStyle" />
|
|
<xsl:param name="title" />
|
|
<xsl:param name="isUsePage" />
|
|
<xsl:param name="docType" />
|
|
<xsl:param name="listOrderType"/>
|
|
<xsl:param name="inputer"/>
|
|
<xsl:param name="letter"/>
|
|
<xsl:param name="cid"/>
|
|
<xsl:param name="dayDiff"/>
|
|
<xsl:param name="type"/>
|
|
<xsl:param name="keyword"/>
|
|
<xsl:param name="hasImages"/>
|
|
|
|
<xsl:template name="_constraint">
|
|
<xsl:param name="_doubleApos"/>
|
|
<xsl:choose>
|
|
<xsl:when test="pe:GetLoginedUserInfo('UserName') = $inputer and $inputer != ''">
|
|
E.Status >= 0
|
|
</xsl:when>
|
|
<xsl:otherwise>
|
|
E.Status > 0
|
|
</xsl:otherwise>
|
|
</xsl:choose>
|
|
<xsl:if test="$docType > 0">
|
|
AND E.RecommendLevel = <xsl:value-of select="$docType" />
|
|
</xsl:if>
|
|
<xsl:if test="$cid != ''">
|
|
AND E.EntryId IN (SELECT EntryId FROM PE_EN_Entry_Category WHERE EntryId = E.EntryId AND CategoryId IN (<xsl:value-of select="$cid" />))
|
|
</xsl:if>
|
|
<xsl:if test="$dayDiff > 0">
|
|
AND DATEDIFF(DD,E.EditTime,GETDATE()) <= <xsl:value-of select="$dayDiff" />
|
|
</xsl:if>
|
|
<xsl:if test="$hasImages = 'true'">
|
|
AND DATALENGTH(E.Images) > 0
|
|
</xsl:if>
|
|
<xsl:choose>
|
|
<xsl:when test="$_doubleApos = 'true'">
|
|
<xsl:if test="$title != ''">
|
|
AND E.EntryName LIKE ''%<xsl:value-of select="$title" />%''
|
|
</xsl:if>
|
|
<xsl:if test="$inputer != ''">
|
|
AND E.Inputer LIKE ''%<xsl:value-of select="$inputer" />%''
|
|
</xsl:if>
|
|
<xsl:if test="$letter != ''">
|
|
AND E.FirstLetter = ''<xsl:value-of select="$letter" />''
|
|
</xsl:if>
|
|
<xsl:if test="$keyword != ''">
|
|
<xsl:if test="$type = 1">
|
|
AND E.EntryName LIKE ''%<xsl:value-of select="$keyword" />%''
|
|
</xsl:if>
|
|
<xsl:if test="$type = 2">
|
|
AND E.Tag LIKE ''%<xsl:value-of select="$keyword" />%''
|
|
</xsl:if>
|
|
<xsl:if test="$type = 3">
|
|
AND E.Content LIKE ''%<xsl:value-of select="$keyword" />%''
|
|
</xsl:if>
|
|
</xsl:if>
|
|
|
|
</xsl:when>
|
|
<xsl:otherwise>
|
|
<xsl:if test="$title != ''">
|
|
AND E.EntryName LIKE '%<xsl:value-of select="$title" />%'
|
|
</xsl:if>
|
|
<xsl:if test="$inputer != ''">
|
|
AND E.Inputer LIKE '%<xsl:value-of select="$inputer" />%'
|
|
</xsl:if>
|
|
<xsl:if test="$letter != ''">
|
|
AND E.FirstLetter = '<xsl:value-of select="$letter" />'
|
|
</xsl:if>
|
|
<xsl:if test="$keyword != ''">
|
|
<xsl:if test="$type = 1">
|
|
AND E.EntryName LIKE '%<xsl:value-of select="$keyword" />%'
|
|
</xsl:if>
|
|
<xsl:if test="$type = 2">
|
|
AND E.Tag LIKE '%<xsl:value-of select="$keyword" />%'
|
|
</xsl:if>
|
|
<xsl:if test="$type = 3">
|
|
AND E.Content LIKE '%<xsl:value-of select="$keyword" />%'
|
|
</xsl:if>
|
|
</xsl:if>
|
|
|
|
</xsl:otherwise>
|
|
</xsl:choose>
|
|
</xsl:template>
|
|
|
|
<xsl:output method="html" />
|
|
<xsl:template match="/">
|
|
<!--内容列表排序、此变量节请勿修改-->
|
|
<xsl:variable name="_listOrderValue">
|
|
<xsl:choose>
|
|
<xsl:when test="$listOrderType = 0">E.CreateTime DESC</xsl:when>
|
|
<xsl:when test="$listOrderType = 1">E.EntryId DESC</xsl:when>
|
|
<xsl:when test="$listOrderType = 2">E.EntryId ASC</xsl:when>
|
|
<xsl:when test="$listOrderType = 3">E.Hits DESC,E.EntryId DESC</xsl:when>
|
|
<xsl:when test="$listOrderType = 4">E.EditTime DESC</xsl:when>
|
|
<xsl:when test="$listOrderType = 5">E.EditTime ASC</xsl:when>
|
|
<xsl:when test="$listOrderType = 6">E.Hits ASC,E.EntryId ASC</xsl:when>
|
|
<xsl:otherwise>E.CreateTime DESC</xsl:otherwise>
|
|
</xsl:choose>
|
|
</xsl:variable>
|
|
|
|
<xsl:variable name="_tableName">PE_EN_Entry E</xsl:variable>
|
|
|
|
{PE.Label id="互动百科_通用词条列表_<xsl:value-of select="$bindStyle" />" page="<xsl:value-of select="$isUsePage" />" pageid="@RequestInt_page" pagesize="<xsl:value-of select="$outputQty" />" linkOpenType="<xsl:value-of select="$linkOpenType"/>" titleLength="<xsl:value-of select="$titleLength"/>"
|
|
sqlString="EXEC [dbo].[PR_Common_PagingLarge] '<xsl:value-of select="$_tableName" />','E.EntryId','E.*',<xsl:value-of select="$outputQty" />,@startrow ,'<xsl:call-template name="_constraint">
|
|
<xsl:with-param name="_doubleApos" select="'true'"/>
|
|
</xsl:call-template>','','<xsl:value-of select="$_listOrderValue" />'"
|
|
sqlCount="select count(E.EntryId) from <xsl:value-of select="$_tableName" /> WHERE <xsl:call-template name="_constraint">
|
|
<xsl:with-param name="_doubleApos" select="'false'"/>
|
|
</xsl:call-template>" /}
|
|
|
|
</xsl:template>
|
|
</xsl:stylesheet>]]></LabelTemplate>
|
|
<attributes>
|
|
<name>title</name>
|
|
<datatype>string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>查询条件-标题</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>isUsePage</name>
|
|
<datatype>string</datatype>
|
|
<default>true</default>
|
|
<intro>是否分页</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>docType</name>
|
|
<datatype>int</datatype>
|
|
<default>0</default>
|
|
<intro>0无，1推荐，2精彩，3热门</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>listOrderType</name>
|
|
<datatype>int</datatype>
|
|
<default>0</default>
|
|
<intro>排序方式</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>inputer</name>
|
|
<datatype>string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>查询条件-创建者</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>letter</name>
|
|
<datatype>string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>查询条件-词条首字母</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>cid</name>
|
|
<datatype>string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>词条分类ID列表，为空表示所有</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>dayDiff</name>
|
|
<datatype>int</datatype>
|
|
<default>0</default>
|
|
<intro>查询条件-时间之内（天数）</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>type</name>
|
|
<datatype>int</datatype>
|
|
<default>0</default>
|
|
<intro>0无，1词条名，2标签，3内容</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>keyword</name>
|
|
<datatype>string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>搜索关键字</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>hasImages</name>
|
|
<datatype>string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>true为必须有图片，否则图片不限</intro>
|
|
</attributes>
|
|
</root> |