67 lines
3.2 KiB
Plaintext
67 lines
3.2 KiB
Plaintext
<root>
|
|
<LabelDataType>sql_sysquery</LabelDataType>
|
|
<LabelType>人员良好行为记录信息</LabelType>
|
|
<LabelImage>../../Admin/Images/LabelIco/GetPicArticle.gif</LabelImage>
|
|
<LabelIntro>
|
|
</LabelIntro>
|
|
<LabelSqlString>SELECT TOP 1 CM.*, UT.*, UP.ProjectNum, UP.ProjectName 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 INNER JOIN PE_PPI_U_Enterprise UE ON Uper.LicenseRegNum = UE.LicenseRegNum INNER JOIN PE_PPI_U_Project UP ON (UE.LicenseRegNum = UP.ProjectOrgNum) WHERE CM.GeneralID = @itemId AND CM.Status=1</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:param name="itemId"/>
|
|
<xsl:template match="/">
|
|
<root>
|
|
<!--FieldTipsStart-->
|
|
<GeneralID>
|
|
<xsl:value-of select="/NewDataSet/Table/GeneralID"/>
|
|
</GeneralID>
|
|
<NodeID>
|
|
<xsl:value-of select="/NewDataSet/Table/CatalogId"/>
|
|
</NodeID>
|
|
<Title>
|
|
<xsl:value-of select="/NewDataSet/Table/Title"/>
|
|
</Title>
|
|
<UpdateTime>
|
|
<xsl:value-of select="pe:FormatDate(/NewDataSet/Table/UpdateTime,'yyyy年mm月dd日')"/>
|
|
</UpdateTime>
|
|
<Hits>
|
|
<script language="JavaScript" type="text/JavaScript" src="<xsl:value-of select="pe:InstallDir()" />Common/GetHits.aspx?id=<xsl:value-of select="/NewDataSet/Table/GeneralID"/>"></script>
|
|
</Hits>
|
|
<DayHits>
|
|
<script language="JavaScript" type="text/JavaScript" src="
|
|
<xsl:value-of select="pe:InstallDir()"/>Common/GetHits.aspx?hitstype=1&id=<xsl:value-of select="/NewDataSet/Table/GeneralID"/>
|
|
"></script>
|
|
</DayHits>
|
|
<WeekHits>
|
|
<script language="JavaScript" type="text/JavaScript" src="
|
|
<xsl:value-of select="pe:InstallDir()"/>Common/GetHits.aspx?hitstype=2&id=<xsl:value-of select="/NewDataSet/Table/GeneralID"/>
|
|
"></script>
|
|
</WeekHits>
|
|
<MonthHits>
|
|
<script language="JavaScript" type="text/JavaScript" src="
|
|
<xsl:value-of select="pe:InstallDir()"/>Common/GetHits.aspx?hitstype=3&id=<xsl:value-of select="/NewDataSet/Table/GeneralID"/>
|
|
"></script>
|
|
</MonthHits>
|
|
<IdentityCertificateNum><xsl:value-of select="/NewDataSet/Table/IdentityCertificateNum"/></IdentityCertificateNum>
|
|
<HonourNum><xsl:value-of select="/NewDataSet/Table/HonourNum"/></HonourNum>
|
|
<HonourContent><xsl:value-of disable-output-escaping="yes" select="/NewDataSet/Table/HonourContent"/></HonourContent>
|
|
<HonourTime><xsl:value-of select="pe:FormatDate(/NewDataSet/Table/HonourTime,'yyyy-mm-dd')"/></HonourTime>
|
|
<HonourOrg><xsl:value-of select="/NewDataSet/Table/HonourOrg"/></HonourOrg>
|
|
<ProjectNum><xsl:value-of select="/NewDataSet/Table/ProjectNum"/></ProjectNum>
|
|
<ProjectName><xsl:value-of select="/NewDataSet/Table/ProjectName"/></ProjectName>
|
|
<!--FieldTipsEnd-->
|
|
</root>
|
|
</xsl:template>
|
|
</xsl:transform>]]>
|
|
</LabelTemplate>
|
|
<attributes>
|
|
<name>itemId</name>
|
|
<default>1</default>
|
|
<intro>公开信息ID</intro>
|
|
</attributes>
|
|
<OutType>
|
|
</OutType>
|
|
<CacheTime>0</CacheTime>
|
|
</root>
|