33 lines
1.5 KiB
XML
33 lines
1.5 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<root>
|
|
<LabelType>政务督查</LabelType>
|
|
<LabelIntro>
|
|
</LabelIntro>
|
|
<OutType>sin</OutType>
|
|
<LabelDataType>sql_sysquery</LabelDataType>
|
|
<EnabelAjax>False</EnabelAjax>
|
|
<Version officialVersion="" modifiedVersions="3002" compatibleVersion="" />
|
|
<UsePage>True</UsePage>
|
|
<IsXsltSql>false</IsXsltSql>
|
|
<IsXsltCountSql>false</IsXsltCountSql>
|
|
<LabelSqlString>SELECT TOP @pagesize PE_GV_Committee.*,PE_GV_Meeting.* FROM PE_GV_Committee INNER JOIN PE_GV_Meeting ON PE_GV_Committee.MeetingId = PE_GV_Meeting.MeetingId WHERE MeetingType= 1 AND PE_GV_Committee.CommitteeId NOT IN(SELECT TOP @startrow PE_GV_Committee.CommitteeId FROM PE_GV_Committee INNER JOIN PE_GV_Meeting ON PE_GV_Committee.MeetingId = PE_GV_Meeting.MeetingId WHERE MeetingType= 1) ORDER BY CommitteeId DESC</LabelSqlString>
|
|
<LabelSqlCount>SELECT count(*) FROM PE_GV_Committee INNER JOIN PE_GV_Meeting ON PE_GV_Committee.MeetingId = PE_GV_Meeting.MeetingId WHERE MeetingType=1</LabelSqlCount>
|
|
<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:output method="html" />
|
|
<xsl:template match="/">
|
|
<xsl:for-each select="NewDataSet/Table">
|
|
<tr>
|
|
<td class="osName">
|
|
<xsl:value-of select="TrueName"/>
|
|
</td>
|
|
<td>
|
|
{PE.Label id="获取代表团界别" GroupId="<xsl:value-of select="GroupId"/>" GroupType="1" /}
|
|
|
|
</td>
|
|
</tr>
|
|
</xsl:for-each>
|
|
</xsl:template>
|
|
</xsl:stylesheet>]]></LabelTemplate>
|
|
</root> |