ningbo/动易的标签库/标签库/搜索类/软件高级搜索.config

<?xml version="1.0"?>
<root>
  <LabelType>搜索类</LabelType>
  <LabelIntro>
  </LabelIntro>
  <OutType>sin</OutType>
  <LabelDataType>sql_sysquery</LabelDataType>
  <attributes>
    <name>outputQty</name>
    <default>30</default>
    <intro>每页显示数量</intro>
  </attributes>
  <attributes>
    <name>titleLength</name>
    <default>60</default>
    <intro>内容标题长度,一个汉字占两个字节,如填写"20"则显示10个汉字</intro>
  </attributes>
  <attributes>
    <name>contentLength</name>
    <default>0</default>
    <intro>内容长度,一个汉字占两个字节,如填写"20"则显示10个汉字,为0则不显示</intro>
  </attributes>
  <attributes>
    <name>linkOpenType</name>
    <default>1</default>
    <intro>内容链接的打开方式{原窗口:0,新窗口:1,由节点配置取代:2}</intro>
  </attributes>
  <attributes>
    <name>bindStyle</name>
    <default>普通式</default>
    <intro>内容呈现样式{默认值:普通式,普通式:普通式}</intro>
  </attributes>
  <attributes>
    <name>parentId</name>
    <default>1</default>
    <intro>父栏目ID{默认值:1,传入值:@RequestInt_nodeId}</intro>
  </attributes>
  <attributes>
    <name>lowInfoPoint</name>
    <default />
    <intro>阅读点数{默认值:"",传入值:@RequestInt_lowInfoPoint}</intro>
  </attributes>
  <attributes>
    <name>longInfoPoint</name>
    <default />
    <intro>阅读点数{默认值:"",传入值:@RequestInt_longInfoPoint}</intro>
  </attributes>
  <attributes>
    <name>startDate</name>
    <default />
    <intro>更新日期{默认值:"",传入值:@RequestDate_startDate}</intro>
  </attributes>
  <attributes>
    <name>endDate</name>
    <default />
    <intro>更新日期{默认值:"",传入值:@RequestDate_endDate}</intro>
  </attributes>
  <attributes>
    <name>title</name>
    <default />
    <intro>标题{默认值:"",传入值:@Request_title}</intro>
  </attributes>
  <attributes>
    <name>content</name>
    <default />
    <intro>内容{默认值:"",传入值:@Request_content}</intro>
  </attributes>
  <attributes>
    <name>intro</name>
    <default />
    <intro>简介{默认值:"",传入值:@Request_intro}</intro>
  </attributes>
  <attributes>
    <name>author</name>
    <default />
    <intro>作者{默认值:"",传入值:@Request_author}</intro>
  </attributes>
  <attributes>
    <name>inputer</name>
    <default />
    <intro>录入者{默认值:"",传入值:@Request_inputer}</intro>
  </attributes>
  <attributes>
    <name>keyword</name>
    <default />
    <intro>关键字{默认值:"",传入值:@Request_keyword}</intro>
  </attributes>
  <attributes>
    <name>editor</name>
    <default />
    <intro>编辑{默认值:"",传入值:@Request_editor}</intro>
  </attributes>
  <attributes>
    <name>source</name>
    <default />
    <intro>来源{默认值:"",传入值:@Request_source}</intro>
  </attributes>
  <attributes>
    <name>softVersion</name>
    <default />
    <intro>软件版本{默认值:"",传入值:@Request_softVersion}</intro>
  </attributes>
  <attributes>
    <name>softType</name>
    <default />
    <intro>软件类型{默认值:"",传入值:@Request_softType}</intro>
  </attributes>
  <attributes>
    <name>copyrightType</name>
    <default />
    <intro>授权类型{默认值:"",传入值:@Request_copyrightType}</intro>
  </attributes>
  <LabelSqlString>SELECT NodeID,arrChildID FROM PE_Nodes WHERE NodeID = @parentId</LabelSqlString>
  <LabelTemplate><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ms="urn:schemas-microsoft-com:xslt" xmlns:lewi="http://www.powereasy.net" xmlns:pe="labelproc" exclude-result-prefixes="pe ms lewi">
  <xsl:output method="html" version="1.0" encoding="UTF-8" indent="yes"/>
  <xsl:param name="titleLength" />
  <xsl:param name="contentLength" />
  <xsl:param name="linkOpenType" />
  <xsl:param name="bindStyle" />
  <xsl:param name="usePageSize" />
  <xsl:param name="parentId" />
  <xsl:param name="lowInfoPoint" />
  <xsl:param name="longInfoPoint" />
  <xsl:param name="startDate" />
  <xsl:param name="endDate" />
  <xsl:param name="title" />
  <xsl:param name="content" />
  <xsl:param name="intro" />
  <xsl:param name="author" />
  <xsl:param name="editor" />
  <xsl:param name="inputer" />
  <xsl:param name="source" />
  <xsl:param name="keyword" />
  <xsl:param name="softVersion" />
  <xsl:param name="softType" />
  <xsl:param name="copyrightType" />
  <xsl:param name="oEA" />
  <xsl:param name="oEB" />
  <xsl:param name="oEC" />
  <xsl:param name="oED" />
  <xsl:param name="oEE" />
  <xsl:param name="oEF" />
  <xsl:template match="/">
    {PE.Label id="软件高级搜索_<xsl:value-of select="$bindStyle"/>" oEA="<xsl:value-of select="$oEA"/>" oEB="<xsl:value-of select="$oEB"/>" oEC="<xsl:value-of select="$oEC"/>" oED="<xsl:value-of select="$oED"/>" oEE="<xsl:value-of select="$oEE"/>" oEF="<xsl:value-of select="$oEF"/>" titleLength="<xsl:value-of select="$titleLength"/>" contentLength="<xsl:value-of select="$contentLength"/>" linkOpenType="<xsl:value-of select="$linkOpenType"/>" queryCond="SELECT TOP @pagesize *
    FROM PE_CommonModel CM
    INNER JOIN PE_U_Soft UT ON (CM.ItemID=UT.ID)
    WHERE CM.Status = 99 AND CM.NodeID IN(<xsl:value-of select="/NewDataSet/Table/arrChildID" />)
    <xsl:if test="$title != ''">
      AND CM.Title LIKE '%<xsl:value-of select="$title"/>%'
    </xsl:if>
    <xsl:if test="$content !=''">
      AND UT.Content LIKE '%<xsl:value-of select="$content"/>%'
    </xsl:if>
    <xsl:if test="$intro !=''">
      AND UT.SoftIntro LIKE '%<xsl:value-of select="$intro"/>%'
    </xsl:if>
    <xsl:if test="$author != ''">
      AND UT.Author LIKE '%<xsl:value-of select="$author"/>%'
    </xsl:if>
    <xsl:if test="$editor != ''">
      AND CM.Editor LIKE '%<xsl:value-of select="$editor"/>%'
    </xsl:if>
    <xsl:if test="$inputer != ''">
      AND CM.Inputer LIKE '%<xsl:value-of select="$inputer"/>%'
    </xsl:if>
    <xsl:if test="$source != ''">
      AND UT.CopyFrom LIKE '%<xsl:value-of select="$source"/>%'
    </xsl:if>
    <xsl:if test="$keyword != ''">
      AND UT.Keyword LIKE '%<xsl:value-of select="$keyword"/>%'
    </xsl:if>
    <xsl:if test="$softVersion != ''">
      AND UT.SoftVersion LIKE '%<xsl:value-of select="$softVersion"/>%'
    </xsl:if>
    <xsl:if test="$softType != ''">
      AND UT.SoftType = '<xsl:value-of select="$softType"/>'
    </xsl:if>
    <xsl:if test="$copyrightType != ''">
      AND UT.CopyrightType = '<xsl:value-of select="$copyrightType"/>'
    </xsl:if>
    <xsl:if test="$lowInfoPoint != 0">
      AND CM.GeneralID IN(SELECT CC.GeneralID FROM PE_ContentCharge CC WHERE CC.InfoPoint &gt; <xsl:value-of select="$lowInfoPoint"/> )
    </xsl:if>
    <xsl:if test="$longInfoPoint != 0">
      AND CM.GeneralID IN(SELECT CC.GeneralID FROM PE_ContentCharge CC WHERE CC.InfoPoint &lt; <xsl:value-of select="$longInfoPoint"/>)
    </xsl:if>
    <xsl:if test="$lowInfoPoint != 0 and $longInfoPoint != 0">
      AND CM.GeneralID IN(SELECT CC.GeneralID FROM PE_ContentCharge CC WHERE (CC.InfoPoint BETWEEN <xsl:value-of select="$lowInfoPoint"/> AND <xsl:value-of select="$longInfoPoint"/>))
    </xsl:if>
    <xsl:if test="$startDate != '' and $endDate !=''">
      AND (CM.UpdateTime BETWEEN '<xsl:value-of select="$startDate"/>' AND '<xsl:value-of select="$endDate"/>')
    </xsl:if>
    AND CM.GeneralID NOT IN (
    SELECT TOP @startrow ICM.GeneralID
    FROM PE_CommonModel ICM
    INNER JOIN PE_U_Soft IUT ON (ICM.ItemID=IUT.ID)
    WHERE ICM.Status = 99 AND ICM.NodeID IN(<xsl:value-of select="/NewDataSet/Table/arrChildID" />)
    <xsl:if test="$title != ''">
      AND ICM.Title LIKE '%<xsl:value-of select="$title"/>%'
    </xsl:if>
    <xsl:if test="$content !=''">
      AND IUT.Content LIKE '%<xsl:value-of select="$content"/>%'
    </xsl:if>
    <xsl:if test="$intro !=''">
      AND IUT.SoftIntro LIKE '%<xsl:value-of select="$intro"/>%'
    </xsl:if>
    <xsl:if test="$author != ''">
      AND IUT.Author LIKE '%<xsl:value-of select="$author"/>%'
    </xsl:if>
    <xsl:if test="$editor != ''">
      AND ICM.Editor LIKE '%<xsl:value-of select="$editor"/>%'
    </xsl:if>
    <xsl:if test="$inputer != ''">
      AND ICM.Inputer LIKE '%<xsl:value-of select="$inputer"/>%'
    </xsl:if>
    <xsl:if test="$source != ''">
      AND IUT.CopyFrom LIKE '%<xsl:value-of select="$source"/>%'
    </xsl:if>
    <xsl:if test="$keyword != ''">
      AND IUT.Keyword LIKE '%<xsl:value-of select="$keyword"/>%'
    </xsl:if>
    <xsl:if test="$softVersion != ''">
      AND IUT.SoftVersion LIKE '%<xsl:value-of select="$softVersion"/>%'
    </xsl:if>
    <xsl:if test="$softType != ''">
      AND IUT.SoftType = '<xsl:value-of select="$softType"/>'
    </xsl:if>
    <xsl:if test="$copyrightType != ''">
      AND IUT.CopyrightType = '<xsl:value-of select="$copyrightType"/>'
    </xsl:if>
    <xsl:if test="$lowInfoPoint != 0">
      AND ICM.GeneralID IN(SELECT ICC.GeneralID FROM PE_ContentCharge ICC WHERE ICC.InfoPoint &gt; <xsl:value-of select="$lowInfoPoint"/> )
    </xsl:if>
    <xsl:if test="$longInfoPoint != 0">
      AND ICM.GeneralID IN(SELECT ICC.GeneralID FROM PE_ContentCharge ICC WHERE ICC.InfoPoint &lt; <xsl:value-of select="$longInfoPoint"/>)
    </xsl:if>
    <xsl:if test="$lowInfoPoint != 0 and $longInfoPoint != 0">
      AND ICM.GeneralID IN(SELECT ICC.GeneralID FROM PE_ContentCharge ICC WHERE (ICC.InfoPoint BETWEEN <xsl:value-of select="$lowInfoPoint"/> AND <xsl:value-of select="$longInfoPoint"/>))
    </xsl:if>
    <xsl:if test="$startDate != '' and $endDate !=''">
      AND (ICM.UpdateTime BETWEEN '<xsl:value-of select="$startDate"/>' AND '<xsl:value-of select="$endDate"/>')
    </xsl:if>
    ORDER BY ICM.UpdateTime DESC)
    ORDER BY CM.UpdateTime DESC" queryCount="SELECT COUNT (ICM.GeneralID)
    FROM PE_CommonModel ICM
    INNER JOIN PE_U_Soft IUT ON (ICM.ItemID=IUT.ID)
    WHERE ICM.Status = 99 AND ICM.NodeID IN(<xsl:value-of select="/NewDataSet/Table/arrChildID" />)
    <xsl:if test="$title != ''">
      AND ICM.Title LIKE '%<xsl:value-of select="$title"/>%'
    </xsl:if>
    <xsl:if test="$content !=''">
      AND IUT.Content LIKE '%<xsl:value-of select="$content"/>%'
    </xsl:if>
    <xsl:if test="$intro !=''">
      AND IUT.SoftIntro LIKE '%<xsl:value-of select="$intro"/>%'
    </xsl:if>
    <xsl:if test="$author != ''">
      AND IUT.Author LIKE '%<xsl:value-of select="$author"/>%'
    </xsl:if>
    <xsl:if test="$editor != ''">
      AND ICM.Editor LIKE '%<xsl:value-of select="$editor"/>%'
    </xsl:if>
    <xsl:if test="$inputer != ''">
      AND ICM.Inputer LIKE '%<xsl:value-of select="$inputer"/>%'
    </xsl:if>
    <xsl:if test="$source != ''">
      AND IUT.CopyFrom LIKE '%<xsl:value-of select="$source"/>%'
    </xsl:if>
    <xsl:if test="$keyword != ''">
      AND IUT.Keyword LIKE '%<xsl:value-of select="$keyword"/>%'
    </xsl:if>
    <xsl:if test="$softVersion != ''">
      AND IUT.SoftVersion LIKE '%<xsl:value-of select="$softVersion"/>%'
    </xsl:if>
    <xsl:if test="$softType != ''">
      AND IUT.SoftType = '<xsl:value-of select="$softType"/>'
    </xsl:if>
    <xsl:if test="$copyrightType != ''">
      AND IUT.CopyrightType = '<xsl:value-of select="$copyrightType"/>'
    </xsl:if>
    <xsl:if test="$lowInfoPoint != 0">
      AND ICM.GeneralID IN(SELECT ICC.GeneralID FROM PE_ContentCharge ICC WHERE ICC.InfoPoint &gt; <xsl:value-of select="$lowInfoPoint"/> )
    </xsl:if>
    <xsl:if test="$longInfoPoint != 0">
      AND ICM.GeneralID IN(SELECT ICC.GeneralID FROM PE_ContentCharge ICC WHERE ICC.InfoPoint &lt; <xsl:value-of select="$longInfoPoint"/>)
    </xsl:if>
    <xsl:if test="$lowInfoPoint != 0 and $longInfoPoint != 0">
      AND ICM.GeneralID IN(SELECT ICC.GeneralID FROM PE_ContentCharge ICC WHERE (ICC.InfoPoint BETWEEN <xsl:value-of select="$lowInfoPoint"/> AND <xsl:value-of select="$longInfoPoint"/>))
    </xsl:if>
    <xsl:if test="$startDate != '' and $endDate !=''">
      AND (ICM.UpdateTime BETWEEN '<xsl:value-of select="$startDate"/>' AND '<xsl:value-of select="$endDate"/>')
    </xsl:if>" page="true" pagesize="<xsl:value-of select="$usePageSize"/>" urlpage="true" /}
  </xsl:template>
</xsl:stylesheet>]]></LabelTemplate>
  <EnabelAjax>False</EnabelAjax>
  <IsXsltSql>false</IsXsltSql>
  <IsXsltCountSql>false</IsXsltCountSql>
</root>