商品信息列表_查询条件.config

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

<xsl:param name="showauthor"/>
<xsl:param name="showdatetype"/>
<xsl:param name="showhits"/>
<xsl:param name="showhotsign"/>
<xsl:param name="shownewsign"/>
<xsl:param name="showtips"/>
<xsl:param name="showcommentlink"/>
<xsl:param name="usepage"/>
<xsl:param name="opentype"/>
<xsl:param name="cols"/>
<xsl:param name="hits"/>
<xsl:param name="elitelevel"/>
<xsl:param name="tablename"/>
<xsl:param name="mypage"/>
<xsl:param name="mypagesize"/>
<xsl:param name="myurlpage"/>
<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="$usepage='true'">
				<xsl:choose>
					<!-- 所有栏目 -->
					<xsl:when test="$arrnodeid=0">
						<!-- 所有专题 -->
						<xsl:if test="$specialid=0">
							<!-- 日期范围查询datenum=0 -->
							<xsl:if test="$datenum=0">
								<!-- 不指定作者姓名查询inputername='' -->
								<xsl:if test="$inputername=''">

								<!-- SELECT Top @pagesize C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ProductID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM PE_CommonModel IC INNER JOIN @tablename IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' order by @sqlinnerordertype) AND C.NodeID IN(@arrnodeid) AND C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' order by @sqlordertype -->

								<!-- SELECT COUNT(IC.GeneralID) FROM PE_CommonModel IC INNER JOIN @tablename IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' -->

								<!-- arrnodeid=0 specialid=0 datenum=0-->

								{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" />" urltype="<xsl:value-of select="$urltype" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" inputername="<xsl:value-of select="$inputername" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" showtype="<xsl:value-of select="$showtype" />" titlelen="<xsl:value-of select="$titlelen" />" contentlen="<xsl:value-of select="$contentlen" />" shownodename="<xsl:value-of select="$shownodename" />" showpropertytype="<xsl:value-of select="$showpropertytype" />" showincludepic="<xsl:value-of select="$showincludepic" />" showauthor="<xsl:value-of select="$showauthor" />" showdatetype="<xsl:value-of select="$showdatetype" />" showhits="<xsl:value-of select="$showhits" />" showhotsign="<xsl:value-of select="$showhotsign" />" shownewsign="<xsl:value-of select="$shownewsign" />" showtips="<xsl:value-of select="$showtips" />" showcommentlink="<xsl:value-of select="$showcommentlink" />" usepage="<xsl:value-of select="$usepage" />" opentype="<xsl:value-of select="$opentype" />" cols="<xsl:value-of select="$cols" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" mypage="<xsl:value-of select="$mypage"/>" mypagesize="<xsl:value-of select="$mypagesize"/>" myurlpage="<xsl:value-of select="$myurlpage"/>" modelname="<xsl:value-of select="pe:GetModelName($tablename)" />" strsql="SELECT Top @pagesize C.*,T.* FROM PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' order by   <xsl:value-of select="$sqlinnerordertype" />) AND C.NodeID IN(@arrnodeid) AND C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' order by   <xsl:value-of select="$sqlordertype" />" sqlcount="SELECT COUNT(IC.GeneralID) FROM PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename'" /}
								</xsl:if>

								<!-- 指定作者姓名查询 -->
								<xsl:if test="$inputername!=''">
								<!-- SELECT Top @pagesize C.*,T.* FROM PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND IC.Inputer='@inputername' order by @sqlinnerordertype) AND C.NodeID IN(@arrnodeid) AND C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.Inputer='@inputername'  order by @sqlordertype -->

								<!-- SELECT COUNT(IC.GeneralID) FROM PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND IC.Inputer='@inputername' -->

								<!-- arrnodeid=0 specialid=0 datenum=0 inputername-->

								{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" />" urltype="<xsl:value-of select="$urltype" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" inputername="<xsl:value-of select="$inputername" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" showtype="<xsl:value-of select="$showtype" />" titlelen="<xsl:value-of select="$titlelen" />" contentlen="<xsl:value-of select="$contentlen" />" shownodename="<xsl:value-of select="$shownodename" />" showpropertytype="<xsl:value-of select="$showpropertytype" />" showincludepic="<xsl:value-of select="$showincludepic" />" showauthor="<xsl:value-of select="$showauthor" />" showdatetype="<xsl:value-of select="$showdatetype" />" showhits="<xsl:value-of select="$showhits" />" showhotsign="<xsl:value-of select="$showhotsign" />" shownewsign="<xsl:value-of select="$shownewsign" />" showtips="<xsl:value-of select="$showtips" />" showcommentlink="<xsl:value-of select="$showcommentlink" />" usepage="<xsl:value-of select="$usepage" />" opentype="<xsl:value-of select="$opentype" />" cols="<xsl:value-of select="$cols" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" mypage="<xsl:value-of select="$mypage"/>" mypagesize="<xsl:value-of select="$mypagesize"/>" myurlpage="<xsl:value-of select="$myurlpage"/>" modelname="<xsl:value-of select="pe:GetModelName($tablename)" />" strsql="SELECT Top @pagesize C.*,T.* FROM PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND IC.Inputer='@inputername' order by   <xsl:value-of select="$sqlinnerordertype" />) AND C.NodeID IN(@arrnodeid) AND C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.Inputer='@inputername' order by   <xsl:value-of select="$sqlordertype" />" sqlcount="SELECT COUNT(IC.GeneralID) FROM PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND IC.Inputer='@inputername'" /}
								</xsl:if>
							</xsl:if>

							<!-- 日期范围查询:最近几天内更新的文章datenum>0 -->
							<xsl:if test="$datenum&gt;0">
								<!-- 不指定作者姓名查询inputername='' -->
								<xsl:if test="$inputername=''">