幻灯片效果显示商品图片_查询条件.config

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

            <!-- 查询所有内容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 PE_CommonProduct T ON C.ItemID=T.ProductID WHERE T.EnableSale=1 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) 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" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />"  strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID WHERE T.EnableSale=1 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
                <!-- 日期范围查询datenum>0 -->
                <xsl:if test="$datenum&gt;0">
                  <!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID WHERE T.EnableSale=1 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND Datediff(d,C.UpdateTime,getdate())<=@datenum AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) 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" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />"  strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID WHERE T.EnableSale=1 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
              </xsl:if>
            </xsl:if>
          </xsl:otherwise>
        </xsl:choose>

      </xsl:otherwise>
    </xsl:choose>

  </xsl:template>
</xsl:transform>]]></LabelTemplate>
  <attributes>
    <name>iselite</name>
    <default>false</default>
    <intro>是否是推荐文章</intro>
  </attributes>
  <attributes>
    <name>datenum</name>
    <default>0</default>
    <intro>日期范围</intro>
  </attributes>
  <attributes>
    <name>ordertype</name>
    <default>1</default>
    <intro>排序方式</intro>
  </attributes>
  <attributes>
    <name>imgwidth</name>
    <default>150</default>
    <intro>图片宽度</intro>
  </attributes>
  <attributes>
    <name>imgheight</name>
    <default>150</default>
    <intro>图片高度</intro>
  </attributes>
  <attributes>
    <name>titlelen</name>
    <default>20</default>
    <intro>标题最多字符数</intro>
  </attributes>
  <attributes>
    <name>timeout</name>
    <default>5000</default>
    <intro>效果变换间隔时间，以毫秒为单位</intro>
  </attributes>
  <attributes>
    <name>effectid</name>
    <default>23</default>
    <intro>图片转换效果，0至22指定某一种特效，23表示随机效果</intro>
  </attributes>
  <attributes>
    <name>hits</name>
    <default>0</default>
    <intro>热门最小点击数</intro>
  </attributes>
  <attributes>
    <name>elitelevel</name>
    <default>0</default>
    <intro>推荐优先级</intro>
  </attributes>
  <attributes>
    <name>tablename</name>
    <default>PE_U_Article</default>
    <intro>所属表名</intro>
  </attributes>
  <attributes>
    <name>sqlordertype</name>
    <default>C.UpdateTime DESC</default>
    <intro>指定排序字段与排序方式</intro>
  </attributes>
  <attributes>
    <name>sqlinnerordertype</name>
    <default>IC.UpdateTime DESC</default>
    <intro>指定分页查询中排序字段与排序方式</intro>
  </attributes>
</root>