ningbo/动易的标签库/标签库/政务公开/公开信息列表.config

<?xml version="1.0" encoding="utf-8"?>
<root>
  <LabelType>政府标签</LabelType>
  <LabelIntro>
  </LabelIntro>
  <OutType>sin</OutType>
  <LabelDataType>static</LabelDataType>
  <EnabelAjax>False</EnabelAjax>
  <Version officialVersion="" modifiedVersions="3505" compatibleVersion="" />
  <LabelTemplate>
    <![CDATA[<?xml version="1.0" encoding="utf-8"?>
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pe="labelproc" exclude-result-prefixes="pe">
  <xsl:param name="IndexNumber"/>
  <xsl:param name="Title"/>
  <xsl:param name="Content"/>
  <xsl:param name="StartDate"/>
  <xsl:param name="EndDate"/>
  <xsl:param name="Keyword"/>
  <xsl:param name="usePage"/>
  <xsl:param name="outputQty"/>
  <xsl:output method="xml" />
  <xsl:template match="/">
    {PE.Label id="公开信息列表查询条件" queryString="SELECT Top <xsl:value-of select="$outputQty"/>  * FROM PE_GV_PublicInformation WHERE Status = 2  AND IsExpired = 0
    <xsl:if test="$IndexNumber != ''">
      AND IndexNumber = '<xsl:value-of select="pe:UrlDecode(pe:ReplaceText($IndexNumber,'_','%'))"/>'
    </xsl:if>
    <xsl:if test="$Title != ''">
      AND Title Like '%<xsl:value-of select="$Title"/>%'
    </xsl:if>
    <xsl:if test="$Content != ''">
      AND Content Like '%<xsl:value-of select="$Content"/>%'
    </xsl:if>
    <xsl:if test="$StartDate != ''">
      AND PublicTime &gt;= '<xsl:value-of select="$StartDate"/>'
    </xsl:if>
    <xsl:if test="$EndDate != ''">
      AND PublicTime &lt;= '<xsl:value-of select="$EndDate"/>'
    </xsl:if>
    <xsl:if test="$Keyword != ''">
      AND Keyword LIKE '%<xsl:value-of select="$Keyword"/>%'
    </xsl:if>
    AND ID not in
    (SELECT Top @startrow ID FROM PE_GV_PublicInformation WHERE Status = 2  AND IsExpired = 0
    <xsl:if test="$IndexNumber != ''">
      AND IndexNumber = '<xsl:value-of select="pe:UrlDecode(pe:ReplaceText($IndexNumber,'_','%'))"/>'
    </xsl:if>
    <xsl:if test="$Title != ''">
      AND Title Like '%<xsl:value-of select="$Title"/>%'
    </xsl:if>
    <xsl:if test="$Content != ''">
      AND Content Like '%<xsl:value-of select="$Content"/>%'
    </xsl:if>
    <xsl:if test="$StartDate != ''">
      AND PublicTime &gt;= '<xsl:value-of select="$StartDate"/>'
    </xsl:if>
    <xsl:if test="$EndDate != ''">
      AND PublicTime &lt;= '<xsl:value-of select="$EndDate"/>'
    </xsl:if>
    <xsl:if test="$Keyword != ''">
      AND Keyword LIKE '%<xsl:value-of select="$Keyword"/>%'
    </xsl:if>
    ORDER BY PublicTime DESC
    ) ORDER BY PublicTime DESC" countString="SELECT Count(ID) FROM PE_GV_PublicInformation WHERE Status = 2  AND IsExpired = 0
    <xsl:if test="$IndexNumber != ''">
      AND IndexNumber = '<xsl:value-of select="pe:UrlDecode(pe:ReplaceText($IndexNumber,'_','%'))"/>'
    </xsl:if>
    <xsl:if test="$Title != ''">
      AND Title Like '%<xsl:value-of select="$Title"/>%'
    </xsl:if>
    <xsl:if test="$Content != ''">
      AND Content Like '%<xsl:value-of select="$Content"/>%'
    </xsl:if>
    <xsl:if test="$StartDate != ''">
      AND PublicTime &gt;= '<xsl:value-of select="$StartDate"/>'
    </xsl:if>
    <xsl:if test="$EndDate != ''">
      AND PublicTime &lt;= '<xsl:value-of select="$EndDate"/>'
    </xsl:if>
    <xsl:if test="$Keyword != ''">
      AND Keyword LIKE '%<xsl:value-of select="$Keyword"/>%'
    </xsl:if>" page="<xsl:value-of select="$usePage"/>" pagesize="<xsl:value-of select="$outputQty"/>"  /}
  </xsl:template>
</xsl:transform>]]></LabelTemplate>
  <attributes>
    <name>IndexNumber</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>公开信息索引号</intro>
  </attributes>
  <attributes>
    <name>Title</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>公开信息标题</intro>
  </attributes>
  <attributes>
    <name>Content</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>公开信息内容</intro>
  </attributes>
  <attributes>
    <name>StartDate</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>公开信息有效期开始时间</intro>
  </attributes>
  <attributes>
    <name>EndDate</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>公开信息有效期结束时间</intro>
  </attributes>
  <attributes>
    <name>Keyword</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>关键字查询</intro>
  </attributes>
  <attributes>
    <name>usePage</name>
    <datatype>supersql</datatype>
    <default>false</default>
    <intro>用户页数</intro>
  </attributes>
  <attributes>
    <name>outputQty</name>
    <datatype>supersql</datatype>
    <default>10</default>
    <intro>输出参数</intro>
  </attributes>
</root>