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

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

									{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()) AND C.Inputer='@inputername' ORDER BY <xsl:value-of select="$sqlordertype" />" /}

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

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

									<!-- SELECT TOP @shownum 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 TOP @shownum 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 TOP @shownum 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 TOP @shownum 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 TOP @shownum 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 TOP @shownum 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 TOP @shownum 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-->

									{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  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()) AND C.Inputer='@inputername' order by <xsl:value-of select="$sqlordertype" />" /}

									</xsl:if>

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

						</xsl:otherwise>
						<!-- 不分页显示内容结束 -->
					</xsl:choose>
				</xsl:when>

				<!-- 指定的栏目没有内容 -->
				<xsl:otherwise>
					<li>
					指定的栏目还没内容!
					</li>
				</xsl:otherwise>
			</xsl:choose>
	</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.*