📄 按厂商id取得品牌信息_数据源.config
字号:
<root>
<LabelType>品牌类</LabelType>
<LabelIntro>数据源模式</LabelIntro>
<OutType>sin</OutType>
<LabelDataType>sql_sysquery</LabelDataType>
<attributes>
<name>producerId</name>
<datatype>supersql</datatype>
<default>1</default>
<intro>品牌名称</intro>
</attributes>
<LabelSqlString>SELECT *
FROM
PE_Trademark CT
WHERE
CT.Passed = 1 AND
CT.ProducerID = @producerId</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="html" />
<xsl:template match="/NewDataSet/Table">
<Root>
<TrademarkID>
<xsl:value-of select="TrademarkID"/>
</TrademarkID>
<TrademarkName>
<xsl:value-of select="TrademarkName"/>
</TrademarkName>
<TrademarkPhoto>
<xsl:value-of select="TrademarkPhoto"/>
</TrademarkPhoto>
<ProducerID>
<xsl:value-of select="ProducerID"/>
</ProducerID>
<TrademarkIntro>
<xsl:value-of disable-output-escaping="yes" select="TrademarkIntro"/>
</TrademarkIntro>
<TrademarkType>
<xsl:choose>
<xsl:when test="TrademarkType=1">大陆品牌</xsl:when>
<xsl:when test="TrademarkType=2">港台品牌</xsl:when>
<xsl:when test="TrademarkType=3">日韩品牌</xsl:when>
<xsl:when test="TrademarkType=4">欧美品牌</xsl:when>
<xsl:otherwise>其他品牌</xsl:otherwise>
</xsl:choose>
</TrademarkType>
</Root>
</xsl:template>
</xsl:transform>]]></LabelTemplate>
<EnabelAjax>False</EnabelAjax>
<IsXsltSql>false</IsXsltSql>
<IsXsltCountSql>false</IsXsltCountSql>
</root>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -