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

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

								<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 Datediff(d,IC.UpdateTime,getdate())<=@datenum 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 Datediff(d,C.UpdateTime,getdate())<=@datenum 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 Datediff(d,IC.UpdateTime,getdate())<=@datenum AND IC.Inputer='@inputername'  -->

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

								{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" />" 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 @datenum>=Datediff(d,IC.UpdateTime,getdate()) 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 @datenum>=Datediff(d,C.UpdateTime,getdate()) 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 @datenum>=Datediff(d,IC.UpdateTime,getdate()) AND IC.Inputer='@inputername'" /}

								</xsl:if>

							</xsl:if>
						</xsl:if>

						<!-- 指定专题 -->
						<xsl:if test="$specialid&gt;0">
							<!-- 日期范围查询datenum=0 -->
							<xsl:if test="$datenum=0">
								<!-- 不指定作者姓名查询inputername='' -->
								<xsl:if test="$inputername=''">

								<!-- SELECT Top @pagesize C.*,T.* FROM (PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID) INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) 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 S.SpecialID IN(@specialid) order by @sqlordertype -->

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


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

								{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" />" 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) INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) 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 S.SpecialID IN(@specialid)  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) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID  WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid)" /}

								</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) INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) 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 S.SpecialID IN(@specialid) 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) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID  WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) AND IC.Inputer='@inputername'   -->


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

								{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" />" 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) INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) 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 S.SpecialID IN(@specialid) 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) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID  WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) AND IC.Inputer='@inputername'" /}

								</xsl:if>
							</xsl:if>

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

								<!-- SELECT Top @pagesize C.*,T.* FROM (PE_CommonModel C INNER JOIN PE_CommonProduct T ON C.ItemID=T.ProductID) INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) AND Datediff(d,IC.UpdateTime,getdate())<=@datenum 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 S.SpecialID IN(@specialid) AND Datediff(d,C.UpdateTime,getdate())<=@datenum order by @sqlordertype -->

								<!-- SELECT COUNT(IC.GeneralID) FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID  WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) AND Datediff(d,IC.UpdateTime,getdate())<=@datenum  -->


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

								{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" />" 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) INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE C.GeneralID NOT IN (SELECT Top @startrow IC.GeneralID FROM (PE_CommonModel IC INNER JOIN PE_CommonProduct IT ON IC.ItemID=IT.ProductID) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) AND @datenum>=Datediff(d,IC.UpdateTime,getdate()) 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 S.SpecialID IN(@specialid) AND @datenum>=Datediff(d,C.UpdateTime,getdate()) 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) INNER JOIN PE_SpecialInfos SS ON IC.GeneralID=SS.GeneralID  WHERE IC.NodeID IN(@arrnodeid) AND IC.Status=99 AND IC.Hits>=@hits AND IC.EliteLevel>=@elitelevel AND IC.TableName='@tablename' AND SS.SpecialID IN(@specialid) AND @datenum>=Datediff(d,IC.UpdateTime,getdate())" /}
								</xsl:if>

								<!-- 指定作者姓名查询 -->
								<xsl:if test="$inputername!=''">
								<!-- SELE