213 lines
8.6 KiB
XML
213 lines
8.6 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="3109" compatibleVersion="" />
|
|
<attributes>
|
|
<name>unitname</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>企业名称</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>licenseregnum</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>营业执照注册号</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>licenseregauthority</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>营业执照登记机关</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>orgnum</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>组织机构代码</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>orgregauthority</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>组织机构登记机关</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>enterprisetype</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>企业类型</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>legalrepresentative</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>法定代表人信息</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>businessccope</name>
|
|
<datatype>sql.string</datatype>
|
|
<default>
|
|
</default>
|
|
<intro>经营范围</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>titleLength</name>
|
|
<datatype>int</datatype>
|
|
<default>30</default>
|
|
<intro>标题显示长度</intro>
|
|
</attributes>
|
|
<attributes>
|
|
<name>openType</name>
|
|
<datatype>int</datatype>
|
|
<default>0</default>
|
|
<intro>打开方式{新窗口:1,原窗口:0}</intro>
|
|
</attributes>
|
|
<UsePage>True</UsePage>
|
|
<IsXsltSql>true</IsXsltSql>
|
|
<IsXsltCountSql>true</IsXsltCountSql>
|
|
<LabelSqlString><![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" xmlns:pe.industry="IndustryExtension" exclude-result-prefixes="pe pe.industry">
|
|
<!--要使用上一步定义的自定义参数，要作为XSLT参数使用，务必要在这里声明。如：<xsl:param name="myPara" />.引用该参数：$myPara -->
|
|
<xsl:param name="unitname" />
|
|
<xsl:param name="licenseregnum"/>
|
|
<xsl:param name="licenseregauthority"/>
|
|
<xsl:param name="orgnum"/>
|
|
<xsl:param name="orgregauthority" />
|
|
<xsl:param name="enterprisetype"/>
|
|
<xsl:param name="legalrepresentative"/>
|
|
<xsl:param name="businessccope"/>
|
|
<xsl:output method="xml" />
|
|
<xsl:template match="/">
|
|
<!--请按提示编辑，保持该模板结构的正确性-->
|
|
<root>
|
|
<sql>
|
|
<xsl:variable name="filter">
|
|
<xsl:if test="$unitname != ''">
|
|
AND PE_PPI_U_Enterprise.UnitName LIKE ''%<xsl:value-of select="$unitname"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$licenseregnum != ''">
|
|
AND PE_PPI_U_Enterprise.LicenseRegNum LIKE ''%<xsl:value-of select="$licenseregnum"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$licenseregauthority != ''">
|
|
AND PE_PPI_U_Enterprise.LicenseRegAuthority LIKE ''%<xsl:value-of select="$licenseregauthority"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$orgnum != ''">
|
|
AND PE_PPI_U_Enterprise.OrgNum LIKE ''%<xsl:value-of select="$orgnum"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$orgregauthority != ''">
|
|
AND PE_PPI_U_Enterprise.OrgRegAuthority LIKE ''%<xsl:value-of select="$orgregauthority"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$enterprisetype != ''">
|
|
AND PE_PPI_U_Enterprise.EnterpriseType LIKE ''%<xsl:value-of select="$enterprisetype"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$legalrepresentative != ''">
|
|
AND PE_PPI_U_Enterprise.LegalRepresentative LIKE ''%<xsl:value-of select="$legalrepresentative"/>%''
|
|
</xsl:if>
|
|
<xsl:if test="$businessccope != ''">
|
|
AND PE_PPI_U_Enterprise.BusinessScope LIKE ''%<xsl:value-of select="$businessccope"/>%''
|
|
</xsl:if>
|
|
</xsl:variable>
|
|
EXEC [dbo].[PR_Common_PagingLarge] 'PE_PPI_CommonModel INNER JOIN PE_PPI_U_Enterprise ON PE_PPI_CommonModel.ItemID=PE_PPI_U_Enterprise.ID','PE_PPI_CommonModel.GeneralId','*',@pagesize, @startrow,'PE_PPI_CommonModel.TableName=''PE_PPI_U_Enterprise'' <xsl:value-of select="$filter"/> AND PE_PPI_CommonModel.Status=1','','PE_PPI_CommonModel.GeneralId DESC'
|
|
</sql>
|
|
<sqlpage>
|
|
<!--请在这里编写你的SQL分页查询语句，只有下面启用了分页SQL的XSLT编程支持这里才有效-->
|
|
</sqlpage>
|
|
<countsql>
|
|
<!--请在这里编写你的分页SQL语句，只有下面启用了分页SQL的XSLT编程支持这里才有效-->
|
|
<xsl:variable name="filter">
|
|
<xsl:if test="$unitname != ''">
|
|
AND PE_PPI_U_Enterprise.UnitName LIKE '%<xsl:value-of select="$unitname"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$licenseregnum != ''">
|
|
AND PE_PPI_U_Enterprise.LicenseRegNum LIKE '%<xsl:value-of select="$licenseregnum"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$licenseregauthority != ''">
|
|
AND PE_PPI_U_Enterprise.LicenseRegAuthority LIKE '%<xsl:value-of select="$licenseregauthority"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$orgnum != ''">
|
|
AND PE_PPI_U_Enterprise.OrgNum LIKE '%<xsl:value-of select="$orgnum"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$orgregauthority != ''">
|
|
AND PE_PPI_U_Enterprise.OrgRegAuthority LIKE '%<xsl:value-of select="$orgregauthority"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$enterprisetype != ''">
|
|
AND PE_PPI_U_Enterprise.EnterpriseType LIKE '%<xsl:value-of select="$enterprisetype"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$legalrepresentative != ''">
|
|
AND PE_PPI_U_Enterprise.LegalRepresentative LIKE '%<xsl:value-of select="$legalrepresentative"/>%'
|
|
</xsl:if>
|
|
<xsl:if test="$businessccope != ''">
|
|
AND PE_PPI_U_Enterprise.BusinessScope LIKE '%<xsl:value-of select="$businessccope"/>%'
|
|
</xsl:if>
|
|
</xsl:variable>
|
|
SELECT COUNT(*) FROM PE_PPI_U_Enterprise INNER JOIN PE_PPI_CommonModel ON PE_PPI_CommonModel.ItemID=PE_PPI_U_Enterprise.ID AND PE_PPI_CommonModel.TableName='PE_PPI_U_Enterprise' WHERE 1=1 <xsl:value-of select="$filter"/> AND PE_PPI_CommonModel.Status=1
|
|
</countsql>
|
|
</root>
|
|
</xsl:template>
|
|
</xsl:transform>]]></LabelSqlString>
|
|
<LabelSqlCount><![CDATA[请在上面的<countsql></countsql>标记之间写分页SQL查询语句]]></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:param name="unitname" />
|
|
<xsl:param name="licenseregnum"/>
|
|
<xsl:param name="licenseregauthority"/>
|
|
<xsl:param name="orgnum"/>
|
|
<xsl:param name="orgregauthority" />
|
|
<xsl:param name="enterprisetype" />
|
|
<xsl:param name="legalrepresentative"/>
|
|
<xsl:param name="businessccope"/>
|
|
<xsl:param name="titleLength" />
|
|
<xsl:param name="openType" />
|
|
<xsl:output method="html" />
|
|
<xsl:template match="/">
|
|
<xsl:choose>
|
|
<xsl:when test="count(/NewDataSet/Table) = 0">
|
|
<tr>
|
|
<td colspan="5">没有信息！</td>
|
|
</tr>
|
|
</xsl:when>
|
|
<xsl:otherwise>
|
|
<xsl:for-each select="/NewDataSet/Table">
|
|
<tr>
|
|
<td>
|
|
<a>
|
|
<xsl:attribute name="target">
|
|
<xsl:choose>
|
|
<xsl:when test="$openType = 1">_blank</xsl:when>
|
|
<xsl:when test="$openType = 0">_self</xsl:when>
|
|
<xsl:otherwise>_self</xsl:otherwise>
|
|
</xsl:choose>
|
|
</xsl:attribute>
|
|
<xsl:attribute name="href">PublicInfoShow.aspx?generalId=<xsl:value-of select="GeneralId"/></xsl:attribute>
|
|
<xsl:attribute name="title">
|
|
<xsl:value-of select="UnitName"/>
|
|
</xsl:attribute>
|
|
<xsl:value-of select="pe:CutText(UnitName,$titleLength,'...')"/>
|
|
</a>
|
|
</td>
|
|
<td>
|
|
<xsl:value-of select="LicenseRegNum"/>
|
|
</td>
|
|
<td>
|
|
<xsl:value-of select="EnterpriseType"/>
|
|
</td>
|
|
</tr>
|
|
</xsl:for-each>
|
|
</xsl:otherwise>
|
|
</xsl:choose>
|
|
</xsl:template>
|
|
</xsl:stylesheet>]]></LabelTemplate>
|
|
</root> |