Files
ningbo/动易的标签库/标签库/政务督查/人大建议数据源标签.config
2026-08-31 16:22:00 +08:00

59 lines
2.1 KiB
XML

<?xml version="1.0" encoding="utf-8"?>
<root>
<LabelType>政务督查</LabelType>
<LabelIntro>
</LabelIntro>
<OutType>
</OutType>
<LabelDataType>sql_sysquery</LabelDataType>
<EnabelAjax>False</EnabelAjax>
<Version officialVersion="" modifiedVersions="2513" compatibleVersion="" />
<attributes>
<name>SuggestionId</name>
<datatype>supersql</datatype>
<default>1</default>
<intro>提案ID</intro>
</attributes>
<IsXsltSql>false</IsXsltSql>
<IsXsltCountSql>false</IsXsltCountSql>
<LabelSqlString><![CDATA[SELECT TOP 1 PE_GV_Meeting.*,PE_GV_Suggestion.* FROM PE_GV_Suggestion,PE_GV_Meeting WHERE PE_GV_Meeting.MeetingId=PE_GV_Suggestion.MeetingId AND SuggestionId = @SuggestionId AND IsPublic = 1 AND Status > 0]]></LabelSqlString>
<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:output method="xml" />
<xsl:template match="/">
<Root>
<SuggestionId>
<xsl:value-of select="/NewDataSet/Table/SuggestionId"/>
</SuggestionId>
<MeetingName>
<xsl:value-of select="/NewDataSet/Table/FullName"/>
</MeetingName>
<SuggestionTitle>
<xsl:value-of select="/NewDataSet/Table/SuggestionTitle"/>
</SuggestionTitle>
<SuggestionContent>
<xsl:value-of disable-output-escaping="yes" select="/NewDataSet/Table/SuggestionContent"/>
</SuggestionContent>
<InputTime>
<xsl:value-of select="pe:FormatDate(/NewDataSet/Table/InputTime,'yyyy-mm-dd')"/>
</InputTime>
<Deputy>
<xsl:value-of select="/NewDataSet/Table/Deputy"/>
</Deputy>
<Category>
{PE.Label id="得到提案类型" categoryId="<xsl:value-of select="/NewDataSet/Table/CategoryId"/>" /}
</Category>
<Inputer>
<xsl:value-of select="/NewDataSet/Table/Inputer"/>
</Inputer>
<DepartmentId>
{PE.Label id="GOV_得到部门名称" departmentId="<xsl:value-of select="/NewDataSet/Table/DepartmentId"/>" /}
</DepartmentId>
<DelegationId>
<xsl:value-of select="/NewDataSet/Table/DelegationId"/>
</DelegationId>
</Root>
</xsl:template>
</xsl:transform>]]></LabelTemplate>
</root>