多模型内容信息列表_查询条件.config

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

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  ORDER BY <xsl:value-of select="$sqlordertype" />" /}

									</xsl:if>

									<!-- 指定作者姓名查询 -->
									<xsl:if test="$inputername!=''">
									<!-- SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND C.Inputer='@inputername' ORDER BY @sqlordertype -->

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND C.Inputer='@inputername' ORDER BY <xsl:value-of select="$sqlordertype" />" /}

									</xsl:if>

								</xsl:if>

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

									<!-- SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND Datediff(d,UpdateTime,getdate())<=@datenum ORDER BY @sqlordertype  -->

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND @datenum>=Datediff(d,UpdateTime,getdate()) ORDER BY <xsl:value-of select="$sqlordertype" />" /}

									</xsl:if>

									<!-- 指定作者姓名查询 -->
									<xsl:if test="$inputername!=''">
									<!-- SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND Datediff(d,UpdateTime,getdate())<=@datenum AND C.Inputer='@inputername' ORDER BY @sqlordertype  -->

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT TOP @shownum C.* FROM PE_CommonModel C  WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND @datenum>=Datediff(d,UpdateTime,getdate()) AND C.Inputer='@inputername' ORDER BY <xsl:value-of select="$sqlordertype" />" /}

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

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

									<!-- SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) order by @sqlordertype -->

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) ORDER BY <xsl:value-of select="$sqlordertype" />" /}
									</xsl:if>

									<!-- 指定作者姓名查询 -->
									<xsl:if test="$inputername!=''">
									<!-- SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) AND C.Inputer='@inputername' order by @sqlordertype -->

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) AND C.Inputer='@inputername' ORDER BY <xsl:value-of select="$sqlordertype" />" /}

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

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

									<!-- SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) AND Datediff(d,UpdateTime,getdate())<=@datenum order by @sqlordertype -->

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

									{PE.Label id="显示多模型内容信息列表" parentid="0" arrnodeid="0" 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" />"  strsql="SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) AND @datenum>=Datediff(d,UpdateTime,getdate()) ORDER BY <xsl:value-of select="$sqlordertype" />" /}

									</xsl:if>

									<!-- 指定作者姓名查询 -->
									<xsl:if test="$inputername!=''">
									<!-- SELECT C.* FROM PE_CommonModel C  INNER JOIN PE_SpecialInfos S ON C.GeneralID=S.GeneralID WHERE  C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel  AND S.SpecialID IN(@specialid) AND Datediff(d,UpdateTime,getdate())<=@datenum AND C.Inputer='@inputername' order by @sqlordertype -->

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