<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:param name="outputType" />
  <xsl:output method="html" />
  <xsl:template match="/NewDataSet/Table">
    <xsl:choose>
      <xsl:when test="$outputType = 1">
        <xsl:value-of select="TrademarkID"/>
      </xsl:when>
      <xsl:when test="$outputType = 2">
        <xsl:value-of select="TrademarkName"/>
      </xsl:when>
      <xsl:when test="$outputType = 3">
        <xsl:value-of select="TrademarkPhoto"/>
      </xsl:when>
      <xsl:when test="$outputType = 4">
        <xsl:value-of select="ProducerID"/>
      </xsl:when>
      <xsl:when test="$outputType = 5">
        <xsl:value-of disable-output-escaping="yes" select="TrademarkIntro"/>
      </xsl:when>
      <xsl:when test="$outputType = 6">
        <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>
      </xsl:when>
      <xsl:otherwise>
        <font style="color:red">錯誤的參數,無法輸出指定的字段值!</font>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>
</xsl:transform>]]></LabelTemplate>
  <EnabelAjax>False</EnabelAjax>
  <IsXsltSql>false</IsXsltSql>
  <IsXsltCountSql>false</IsXsltCountSql>
  <attributes>
    <name>outputType</name>
    <datatype>supersql</datatype>
    <default>1</default>
    <intro>輸出字段類型{品牌ID:1,名稱:2,圖片:3,廠商ID:4,簡介:5,類型:6}</intro>
  </attributes>
</root>