美文网首页
最简信息列表(不分页)

最简信息列表(不分页)

作者: 吴加明 | 来源:发表于2019-07-07 16:43 被阅读0次
image

SQL部分:

<?xml version="1.0" encoding="utf-8"?>
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" omit-xml-declaration="yes" />
<xsl:param name="nodeid"/>
<xsl:param name="orderno"/>
<xsl:param name="filter"/>
<xsl:template match="/">
<root>
<sql>
select top @outnum CM.* From PE_CommonModel CM where CM.NodeID in (select * From SplitID((select arrChildID from PE_Nodes where NodeID=@nodeid),',')) and Status = 99
<xsl:choose>
<xsl:when test="$orderno=1">
 order by CM.Hits desc
</xsl:when>
<xsl:when test="$orderno=2">
 order by CM.EliteLevel desc, CM.Updatetime desc 
</xsl:when>
<xsl:otherwise>
 order by CM.Updatetime desc
</xsl:otherwise>
</xsl:choose>
</sql>
</root>
</xsl:template>
</xsl:transform>

标签内容:

<?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:output method="html" version="1.0" encoding="utf-8" indent="yes"/>
<xsl:param name="titleLength"/>
<xsl:param name="displayNewSign" />
<xsl:template match="NewDataSet">
<xsl:choose>
<xsl:when test="Table">
<xsl:for-each select="Table">
<li>
<a>
<xsl:attribute name="target">_self</xsl:attribute>
<xsl:attribute name="title">标题:<xsl:value-of select="Title"/> <xsl:value-of select="'&#10;'"/>点击数:<xsl:value-of select="Hits"/> <xsl:value-of select="'&#10;'"/>发表时间:<xsl:value-of select="pe:FormatDate(UpdateTime, 'yy年mm月dd日')"/>
</xsl:attribute>
 <xsl:attribute name="href">
<xsl:value-of select="pe:GetInfoPath(NodeID,GeneralID,InputTime,PinyinTitle,HtmlPageName)"/>
 </xsl:attribute>
<xsl:choose>
<xsl:when test="TitleFontColor != '' or TitleFontType != '字形'">
<span>
<xsl:attribute name="style">
<xsl:if test="TitleFontColor != ''">color:<xsl:value-of select="TitleFontColor"/>;</xsl:if>
<xsl:if test="TitleFontType != '字形'">
<xsl:choose>
<xsl:when test="TitleFontType ='粗体'">font-weight:bold;font-style:normal;</xsl:when>
<xsl:when test="TitleFontType ='斜体'">font-weight:normal ;font-style:italic;</xsl:when>
 <xsl:when test="TitleFontType ='粗+斜'">font-weight:bold;font-style:italic;</xsl:when>
<xsl:otherwise>font-weight:normal ;font-style:normal;</xsl:otherwise>
</xsl:choose>
</xsl:if>
</xsl:attribute>
<xsl:value-of select="pe:CutText(pe:RemoveHtml(pe:EncodeText(Title,'htmldecode')),$titleLength,'…')"/>
 </span>
 </xsl:when>
 <xsl:otherwise>
<xsl:value-of select="pe:CutText(pe:RemoveHtml(pe:EncodeText(Title,'htmldecode')),$titleLength,'…')"/>
</xsl:otherwise>
 </xsl:choose>
</a>
</li>
 </xsl:for-each>
 </xsl:when>
 <xsl:otherwise>
 <span class="missing_data">还没有任何内容!</span>
 </xsl:otherwise>
</xsl:choose>
 </xsl:template>
</xsl:stylesheet>

相关文章

网友评论

      本文标题:最简信息列表(不分页)

      本文链接:https://www.haomeiwen.com/subject/ahxihctx.html