67 lines
2.9 KiB
XML
67 lines
2.9 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<root>
|
|
<LabelType>项目信息公开</LabelType>
|
|
<LabelIntro>人员良好行为记录信息详细内容</LabelIntro>
|
|
<OutType>sin</OutType>
|
|
<LabelDataType>sql_sysquery</LabelDataType>
|
|
<EnabelAjax>True</EnabelAjax>
|
|
<Version officialVersion="" modifiedVersions="4508" compatibleVersion="" />
|
|
<attributes>
|
|
<name>generalId</name>
|
|
<datatype>sql.int</datatype>
|
|
<default>0</default>
|
|
<intro>PE_CommonModel表的编号</intro>
|
|
</attributes>
|
|
<IsXsltSql>false</IsXsltSql>
|
|
<IsXsltCountSql>false</IsXsltCountSql>
|
|
<LabelSqlString><![CDATA[SELECT TOP 1 CM.*, UT.* FROM PE_PPI_CommonModel CM INNER JOIN PE_PPI_U_PersonnelGood UT ON (CM.ItemID = UT.ID AND CM.TableName='PE_PPI_U_PersonnelGood') INNER JOIN PE_PPI_U_Personnel UPer ON UT.IdentityCertificateNum = Uper.IdentityCertificateNum WHERE CM.GeneralID = @generalId AND CM.Status=1]]></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="ProjectName" />
|
|
<xsl:param name="ProjectNum" />
|
|
<xsl:output method="html" />
|
|
<xsl:template match="/NewDataSet/Table">
|
|
<table class="c_content" cellpadding="0" cellspacing="0">
|
|
<tbody>
|
|
<tr>
|
|
<td>身份证号</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="IdentityCertificateNum"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>县级以上的荣誉文书编号</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="HonourNum"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>荣誉内容</td>
|
|
<td class="txt">
|
|
<xsl:value-of disable-output-escaping="yes" select="HonourContent"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>荣誉认定日期</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="pe:FormatDate(HonourTime,'yyyy-mm-dd')"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>颁发机构</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="HonourOrg"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>发布机构</td>
|
|
<td class="txt">
|
|
{PE.Label id="Monster_根据部门ID得到部门名称 " departmentId="<xsl:value-of select="DepartmentId"/>" /}
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</xsl:template>
|
|
</xsl:stylesheet>]]></LabelTemplate>
|
|
</root> |