带图片商品列表_查询条件.config

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

                  <!-- 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 @picurlfieldname!='' 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="$arrnodeid" />" 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 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 @picurlfieldname!='' 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>contentlen</name>
    <default>50</default>
    <intro>内容最多字符数</intro>
  </attributes>
  <attributes>
    <name>showtips</name>
    <default>false</default>
    <intro>是否显示浮动提示信息</intro>
  </attributes>
  <attributes>
    <name>urltype</name>
    <default>0</default>
    <intro>链接类型</intro>
  </attributes>
  <attributes>
    <name>cols</name>
    <default>1</default>
    <intro>表格式显示行数</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>
  <attributes>
    <name>picurlfieldname</name>
    <default>DefaultPicUrl</default>
    <intro>缩略图字段名</intro>
  </attributes>
</root>