带图片内容列表_查询条件.config

动易SiteFactory网上商店系统正式版动易SiteFactory网上商店系统正式版

<root>
  <LabelType>系统标签</LabelType>
  <LabelImage>../../Admin/Images/LabelIco/GetArticleCustom.gif</LabelImage>
  <LabelIntro>
  </LabelIntro>
  <OutType>sin</OutType>
  <CacheTime>0</CacheTime>
  <LabelDataType>sql_sysquery</LabelDataType>
  <attributes>
    <name>parentid</name>
    <default>1</default>
    <intro>父栏目ID</intro>
  </attributes>
  <attributes>
    <name>arrnodeid</name>
    <default>0</default>
    <intro>栏目ID数组</intro>
  </attributes>
  <attributes>
    <name>includechild</name>
    <default>false</default>
    <intro>是否包含子栏目</intro>
  </attributes>
  <attributes>
    <name>specialid</name>
    <default>0</default>
    <intro>专题ID</intro>
  </attributes>
  <attributes>
    <name>shownum</name>
    <default>10</default>
    <intro>文章数</intro>
  </attributes>
  <attributes>
    <name>ishot</name>
    <default>false</default>
    <intro>是否是热门文章</intro>
  </attributes>
  <LabelSqlString>SELECT NodeID,NodeName,arrChildID,ParentPath FROM PE_Nodes WHERE NodeID=@parentid</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:output method="html" />
  <!-- 参数 -->
  <xsl:param name="parentid"/>
  <xsl:param name="arrnodeid"/>
  <xsl:param name="includechild"/>
  <xsl:param name="specialid"/>
  <xsl:param name="shownum"/>
  <xsl:param name="ishot"/>
  <xsl:param name="iselite"/>
  <xsl:param name="datenum"/>
  <xsl:param name="ordertype"/>
  <xsl:param name="imgwidth"/>
  <xsl:param name="imgheight"/>
  <xsl:param name="titlelen"/>
  <xsl:param name="contentlen"/>
  <xsl:param name="showtips"/>
  <xsl:param name="urltype"/>
  <xsl:param name="cols"/>
  <xsl:param name="hits"/>
  <xsl:param name="elitelevel"/>
  <xsl:param name="tablename"/>
  <xsl:param name="picurlfieldname"/>
  <xsl:param name="sqlordertype"/>
  <xsl:param name="sqlinnerordertype"/>
  <xsl:template match="/NewDataSet/Table">
    <xsl:choose>
      <xsl:when test="count(/NewDataSet/Table) = 0">
        <li>
          指定的栏目还没内容!
        </li>
      </xsl:when>
      <xsl:otherwise>
        <xsl:choose>
          <!-- 所有栏目 -->
          <xsl:when test="$arrnodeid=0">
            <!-- 所有专题 -->
            <xsl:if test="$specialid='0'">
              <!-- 查询所有内容shownum=0 -->
              <xsl:if test="$shownum=0">
                <!-- 日期范围查询datenum=0 -->
                <xsl:if test="$datenum=0">
                  <!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND @picurlfieldname!='' ORDER BY @sqlordertype -->
                  {PE.Label id="显示带图片内容列表" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />"  datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />"  imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" contentlen="<xsl:value-of select="$contentlen" />" showtips="<xsl:value-of select="$showtips" />" urltype="<xsl:value-of select="$urltype" />" cols="<xsl:value-of select="$cols" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" picurlfieldname="<xsl:value-of select="$picurlfieldname" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND @picurlfieldname!='' AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
                <!-- 日期范围查询datenum>0 -->
                <xsl:if test="$datenum&gt;0">
                  <!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND @picurlfieldname!='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum ORDER BY @sqlordertype -->
                  {PE.Label id="显示带图片内容列表" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />"  datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />"  imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" contentlen="<xsl:value-of select="$contentlen" />" showtips="<xsl:value-of select="$showtips" />" urltype="<xsl:value-of select="$urltype" />" cols="<xsl:value-of select="$cols" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" picurlfieldname="<xsl:value-of select="$picurlfieldname" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND @picurlfieldname!='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
              </xsl:if>
              <!-- 查询所有内容shownum>0 -->
              <xsl:if test="$shownum>0">
                <!-- 日期范围查询datenum=0 -->
                <xsl:if test="$datenum=0">
                  <!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND @picurlfieldname!='' ORDER BY @sqlordertype -->