ningbo/动易的标签库/标签库/网上信访/信件列表标签.config

<?xml version="1.0" encoding="utf-8"?>
<root>
  <LabelType>网上信访</LabelType>
  <LabelIntro>信件列表标签</LabelIntro>
  <OutType>sin</OutType>
  <LabelDataType>sql_sysquery</LabelDataType>
  <EnabelAjax>False</EnabelAjax>
  <attributes>
    <name>LetterTypeId</name>
    <datatype>supersql</datatype>
    <default>0</default>
    <intro>信件类型Id</intro>
  </attributes>
  <IsXsltSql>true</IsXsltSql>
  <IsXsltCountSql>true</IsXsltCountSql>
  <LabelSqlString><![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">
<!--要使用上一步定义的自定义参数，要作为XSLT参数使用，务必要在这里声明。如：<xsl:param name="myPara" />.引用该参数：$myPara -->
<xsl:output method="xml" />
<xsl:param name="LetterTypeId" />
<xsl:param name="Title" />
<xsl:param name="searchType" />
<xsl:template match="/">
<!--请按提示编辑，保持该模板结构的正确性-->
<root>
<sql>
<!--请在这里编写你的SQL语句-->
SELECT Top @pagesize PE_GV_Letters.*, PE_GV_LetterType.LetterTypeName, PE_Department.DepartmentName FROM PE_GV_Letters, PE_GV_LetterType, PE_Department WHERE PE_GV_Letters.LetterTypeId=PE_GV_LetterType.LetterTypeId AND PE_GV_Letters.DepartmentId=PE_Department.DepartmentId  AND PE_GV_Letters.IsPublic=1 AND PE_GV_Letters.Status>-1 
<xsl:if test="$LetterTypeId != 0">
   AND PE_GV_Letters.LetterTypeId=@LetterTypeId
</xsl:if>
<xsl:if test="$searchType = 1"><xsl:if test="$Title != ''"> AND PE_GV_Letters.Title like '%@Title%'</xsl:if></xsl:if>
<xsl:if test="$searchType = 2"><xsl:if test="$Title != ''"> AND PE_Department.DepartmentName like '%@Title%'</xsl:if></xsl:if>
AND PE_GV_Letters.LetterId NOT IN(SELECT Top @startrow PE_GV_Letters.LetterId FROM PE_GV_Letters, PE_GV_LetterType, PE_Department WHERE PE_GV_Letters.LetterTypeId=PE_GV_LetterType.LetterTypeId AND PE_GV_Letters.DepartmentId=PE_Department.DepartmentId AND PE_GV_Letters.IsPublic=1 AND PE_GV_Letters.Status>-1 
<xsl:if test="$LetterTypeId != 0">
   AND PE_GV_Letters.LetterTypeId=@LetterTypeId
</xsl:if>
<xsl:if test="$searchType = 1"><xsl:if test="$Title!= ''">  AND PE_GV_Letters.Title like '%@Title%' </xsl:if></xsl:if>
<xsl:if test="$searchType = 2"><xsl:if test="$Title != ''"> AND PE_Department.DepartmentName like '%@Title%' </xsl:if></xsl:if>
ORDER BY InputTime DESC)
 ORDER BY InputTime DESC
</sql>
<sqlpage>
<!--请在这里编写你的SQL分页查询语句，只有下面启用了分页SQL的XSLT编程支持这里才有效-->
</sqlpage>
<countsql>
<!--请在这里编写你的分页SQL语句，只有下面启用了分页SQL的XSLT编程支持这里才有效-->
SELECT COUNT(*) FROM PE_GV_Letters, PE_GV_LetterType, PE_Department WHERE PE_GV_Letters.LetterTypeId=PE_GV_LetterType.LetterTypeId AND PE_GV_Letters.DepartmentId=PE_Department.DepartmentId AND PE_GV_Letters.IsPublic=1  AND PE_GV_Letters.Status>-1 
<xsl:if test="$LetterTypeId != 0">
   AND PE_GV_Letters.LetterTypeId=@LetterTypeId
</xsl:if>
<xsl:if test="$searchType = 1"><xsl:if test="$Title!= ''">  AND PE_GV_Letters.Title like '%@Title%' </xsl:if></xsl:if>
<xsl:if test="$searchType = 2"><xsl:if test="$Title != ''"> AND PE_Department.DepartmentName like '%@Title%' </xsl:if></xsl:if>
</countsql>
</root>
</xsl:template>
</xsl:transform>]]></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:pe="labelproc" exclude-result-prefixes="pe">
<xsl:param name="LetterTypeId" />
<xsl:output method="html" />
<xsl:template match="/">
   <table width="100%" border="0" cellspacing="1" cellpadding="0" class="online_list">
      <tr class="online_listtit">
         <td>编号</td>
         <td>主题</td>
         <td>类型</td>
         <td>办理情况</td>
         <td>来信时间</td>
         <td>承办单位</td>
      </tr>
      <xsl:for-each select="NewDataSet/Table">
         <tr>
              <td>
<xsl:value-of select="LetterId"/>
</td>
<td class="onlineTitle">
              <a>
   <xsl:attribute name="href">
      {PE.SiteConfig.ApplicationPath/}Government/Letter/LetterView.aspx?LetterId=<xsl:value-of select="LetterId" />
   </xsl:attribute>
   <xsl:attribute name="title">
      <xsl:value-of select="Title"/>
   </xsl:attribute>
   <xsl:value-of select="Title"/>
</a>
</td>
<td>
<xsl:value-of select="LetterTypeName"/>
</td>
              <td>
                 <xsl:choose>
                    <xsl:when test="Status=0">
                       待受理
                    </xsl:when>
                    <xsl:when test="Status=1">
                       已转交
                    </xsl:when>
                    <xsl:when test="Status=2">
                       处理中
                    </xsl:when>
                    <xsl:when test="Status=3">
                       已处理完
                    </xsl:when>
                    <xsl:otherwise>
                       过期未处理
                    </xsl:otherwise>
                 </xsl:choose>
              </td>
              <td>
<xsl:value-of select="pe:FormatDate(InputTime,'yyyy-mm-dd')"/>
</td>
              <td>
<xsl:value-of select="DepartmentName"/>
</td>
            </tr>
      </xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>]]></LabelTemplate>
  <UsePage>True</UsePage>
  <LabelSqlCount><![CDATA[请在上面的<countsql></countsql>标记之间写分页SQL查询语句
select count(id) from database]]></LabelSqlCount>
  <LabelSqlPage>
  </LabelSqlPage>
  <Version officialVersion="" modifiedVersions="3503" compatibleVersion="" />
  <attributes>
    <name>Title</name>
    <datatype>supersql</datatype>
    <default>
    </default>
    <intro>信件主题</intro>
  </attributes>
  <attributes>
    <name>searchType</name>
    <datatype>int</datatype>
    <default>1</default>
    <intro>1标题，2部门</intro>
  </attributes>
</root>