ZLPMS/PMS.WebUI/Reports/渠道产品信息查询.mrt

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <zldms Ref="2" type="Stimulsoft.Report.Dictionary.StiOracleODPDatabase" isKey="true">
        <Alias>zldms</Alias>
        <ConnectionStringEncrypted>5UZljGJccwVyeG2Nc9C1Q+NscQLJBUnw8U0hyXrYNJf/7JkCW0rSXXJ/qIH6STRu4xK7bMZ9QxlxEd3xd1gtu4g4leLvW1Gc8kXZBHmArGfpIGmDWFT6RUYG6A==</ConnectionStringEncrypted>
        <Name>zldms</Name>
      </zldms>
    </Databases>
    <DataSources isList="true" count="3">
      <产品 Ref="3" type="Stimulsoft.Report.Dictionary.StiOracleODPSource" isKey="true">
        <Alias>产品</Alias>
        <Columns isList="true" count="2">
          <value>ID,System.String</value>
          <value>名称,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>产品</Name>
        <NameInSource>zldms</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select 名称,ID from 产品系统配置 where 状态=1 ORDER  BY SORT_NO</SqlCommand>
      </产品>
      <项目产品 Ref="4" type="Stimulsoft.Report.Dictionary.StiOracleODPSource" isKey="true">
        <Alias>项目产品</Alias>
        <Columns isList="true" count="3">
          <value>数量,System.Decimal</value>
          <value>渠道名称,System.String</value>
          <value>产品名称,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>项目产品</Name>
        <NameInSource>zldms</NameInSource>
        <Parameters isList="true" count="2">
          <value>qdid,qdid,126,0</value>
          <value>cpid,cpid,126,0</value>
        </Parameters>
        <SqlCommand>SELECT * from(
select (q.名称)渠道名称 ,t.名称 产品名称,count(1) 数量
	from 渠道信息 q , 项目信息 x  ,项目产品模块 c,产品系统配置 t 
	where  q.id=x.渠道id  and   c.项目id=x.id 
	and t.id=c.产品id 
    {cpid.Length&gt;0?" and t.id=:cpid " :" and t.id is not null "}
    {qdid.Length&gt;0?" and q.id=:qdid " :" and q.id is not null "}
	GROUP  BY  q.名称,t.名称 
 ) t
order by t.渠道名称,t.产品名称 
</SqlCommand>
      </项目产品>
      <渠道 Ref="5" type="Stimulsoft.Report.Dictionary.StiOracleODPSource" isKey="true">
        <Alias>渠道</Alias>
        <Columns isList="true" count="2">
          <value>ID,System.String</value>
          <value>名称,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>渠道</Name>
        <NameInSource>zldms</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select 名称,ID from 渠道信息 where 状态=1 ORDER  BY SORT_NO</SqlCommand>
      </渠道>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="2">
      <value>,qdid,渠道,,System.String,qdid,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_渠道.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_渠道.名称_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_</value>
      <value>,cpid,产品,,System.String,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_产品.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_产品.名称_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="6" type="Page" isKey="true">
      <Border>All;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <Header项目产品 Ref="7" type="HeaderBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <Header项目产品_渠道名称 Ref="8" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Header项目产品_渠道名称</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>渠道名称</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Header项目产品_渠道名称>
            <Header项目产品_产品名称 Ref="9" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>6.4,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Header项目产品_产品名称</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>产品名称</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Header项目产品_产品名称>
            <Header项目产品_数量 Ref="10" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>12.8,0,6.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Header项目产品_数量</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>数量</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Header项目产品_数量>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Header项目产品</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
        </Header项目产品>
        <Data项目产品 Ref="11" type="DataBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <Data项目产品_渠道名称 Ref="12" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Data项目产品_渠道名称</Name>
              <Page isRef="6" />
              <Parent isRef="11" />
              <Text>{项目产品.渠道名称}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Data项目产品_渠道名称>
            <Data项目产品_产品名称 Ref="13" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>6.4,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Data项目产品_产品名称</Name>
              <Page isRef="6" />
              <Parent isRef="11" />
              <Text>{项目产品.产品名称}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Data项目产品_产品名称>
            <Data项目产品_数量 Ref="14" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>12.8,0,6.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Data项目产品_数量</Name>
              <Page isRef="6" />
              <Parent isRef="11" />
              <Text>{项目产品.数量}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Data项目产品_数量>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>项目产品</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>Data项目产品</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </Data项目产品>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>5aa0e05b0dab4aeb8203780b4f97cb7a</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="15" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="16" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>5/9/2024 10:50:51 PM</ReportChanged>
  <ReportCreated>11/12/2019 6:11:48 PM</ReportCreated>
  <ReportFile>D:\code\中联\其他\问题管理系统\报表制作\渠道产品信息查询.mrt</ReportFile>
  <ReportGuid>bfc3051eb7ad4b3b96212e61f5f2a05a</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2014.3.0</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
		#endregion StiReport Designer generated code - do not modify
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="1">
    <样式1 Ref="17" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,8</Font>
      <Name>样式1</Name>
      <TextBrush>Black</TextBrush>
    </样式1>
  </Styles>
</StiSerializer>