91 lines
3.7 KiB
XML
91 lines
3.7 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="4507" compatibleVersion="" />
|
|
<attributes>
|
|
<name>generalId</name>
|
|
<datatype>sql.int</datatype>
|
|
<default>0</default>
|
|
<intro>PE_CommonModel表的编号</intro>
|
|
</attributes>
|
|
<IsXsltSql>false</IsXsltSql>
|
|
<IsXsltCountSql>false</IsXsltCountSql>
|
|
<LabelSqlString>SELECT TOP 1 CM.*, UT.* FROM PE_PPI_CommonModel CM INNER JOIN PE_PPI_U_Certification UT ON (CM.ItemID = UT.ID AND CM.TableName='PE_PPI_U_Certification') 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="CertificateName"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>证书编号</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="CertificateNum"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>资质类别</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="CertificateType"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>有效起始日期</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="pe:FormatDate(BeginTime,'yyyy-mm-dd')"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>有效到期日期</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="pe:FormatDate(EndTime,'yyyy-mm-dd')"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>证书核发日期</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="pe:FormatDate(IssuanceDate,'yyyy-mm-dd')"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>证书核发机关</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="IssuingAuthority"/>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>证书状态</td>
|
|
<td class="txt">
|
|
<xsl:value-of select="CertificateState"/>
|
|
</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> |