?? 按廠商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 + -