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

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

                <!-- 日期范围查询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' 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' 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 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()) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
              </xsl:if>
            </xsl:if>
            <!-- 指定专题 -->
            <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 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)) 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 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)) 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 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)) 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 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)) 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 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)) 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)) 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)) 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)) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
              </xsl:if>
            </xsl:if>


          </xsl:when>
          <!-- 指定栏目 -->
          <xsl:otherwise>
            <!-- 所有专题 -->
            <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 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.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 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.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 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.NodeID IN(@arrnodeid) 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 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.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 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.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.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.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.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
                </xsl:if>
              </xsl:if>
            </xsl:if>
            <!-- 指定专题 -->
            <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 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 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 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 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>