예제 #1
0
 public ReportTable(IReportTablePackage package)
 {
     this.parent = package;
     this.columns = new List<IReportTableColumn>();
 }
        public OpportunityVirtualTable(IReportTablePackage package)
            : base(package)
        {
            _logger = OSCLogService.GetLog();

            this.Name        = OSCOpportunitiesTableMetadata.Name;
            this.Label       = OSCOpportunitiesTableMetadata.Label;
            this.Description = OSCOpportunitiesTableMetadata.Description;

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.KeyContactId,
                Name        = OSCOpportunitiesTableColumnNames.KeyContactId,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.KeyContactId
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.PrimaryContactPartyName,
                Name        = OSCOpportunitiesTableColumnNames.PrimaryContactPartyName,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.PrimaryContactPartyName
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.SalesAccountId,
                Name        = OSCOpportunitiesTableColumnNames.SalesAccountId,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesAccountId
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.TargetPartyName,
                Name        = OSCOpportunitiesTableColumnNames.TargetPartyName,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.TargetPartyName
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.OptyId,
                Name        = OSCOpportunitiesTableColumnNames.OptyId,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.OptyId
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.OptyNumber,
                Name        = OSCOpportunitiesTableColumnNames.OptyNumber,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.OptyNumber
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.PartyName1,
                Name        = OSCOpportunitiesTableColumnNames.PartyName1,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.PartyName1
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.EmailAddress,
                Name        = OSCOpportunitiesTableColumnNames.EmailAddress,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.EmailAddress
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.Name,
                Name        = OSCOpportunitiesTableColumnNames.Name,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.Name
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.Description,
                Name        = OSCOpportunitiesTableColumnNames.Description,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.Description
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.StatusCode,
                Name        = OSCOpportunitiesTableColumnNames.StatusCode,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.StatusCode
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.SalesMethod,
                Name        = OSCOpportunitiesTableColumnNames.SalesMethod,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesMethod
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.SalesStage,
                Name        = OSCOpportunitiesTableColumnNames.SalesStage,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesStage
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.SalesChannelCd,
                Name        = OSCOpportunitiesTableColumnNames.SalesChannelCd,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesChannelCd
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.CurrencyCode,
                Name        = OSCOpportunitiesTableColumnNames.CurrencyCode,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.CurrencyCode
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.Revenue,
                Name        = OSCOpportunitiesTableColumnNames.Revenue,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.Revenue
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.WinProb,
                Name        = OSCOpportunitiesTableColumnNames.WinProb,
                CanDisplay  = true,
                CanFilter   = true,
                Description = OSCOpportunitiesTableColumnDesc.Revenue
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.ForecastedCloseDate,
                Name        = OSCOpportunitiesTableColumnNames.ForecastedCloseDate,
                CanDisplay  = true,
                Description = OSCOpportunitiesTableColumnDesc.ForecastedCloseDate
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.CreatedBy,
                Name        = OSCOpportunitiesTableColumnNames.CreatedBy,
                CanDisplay  = true,
                Description = OSCOpportunitiesTableColumnDesc.CreatedBy
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType    = ReportColumnType.String,
                Label       = OSCOpportunitiesTableColumnLabels.CreationDate,
                Name        = OSCOpportunitiesTableColumnNames.CreationDate,
                CanDisplay  = true,
                Description = OSCOpportunitiesTableColumnDesc.CreationDate
            });
        }
        public OpportunityVirtualTable(IReportTablePackage package)
            : base(package)
        {
            _logger = OSCLogService.GetLog();

            this.Name = OSCOpportunitiesTableMetadata.Name;
            this.Label = OSCOpportunitiesTableMetadata.Label;
            this.Description = OSCOpportunitiesTableMetadata.Description;

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.KeyContactId,
                Name = OSCOpportunitiesTableColumnNames.KeyContactId,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.KeyContactId
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.PrimaryContactPartyName,
                Name = OSCOpportunitiesTableColumnNames.PrimaryContactPartyName,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.PrimaryContactPartyName
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.SalesAccountId,
                Name = OSCOpportunitiesTableColumnNames.SalesAccountId,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesAccountId
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.TargetPartyName,
                Name = OSCOpportunitiesTableColumnNames.TargetPartyName,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.TargetPartyName
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.OptyId,
                Name = OSCOpportunitiesTableColumnNames.OptyId,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.OptyId
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.OptyNumber,
                Name = OSCOpportunitiesTableColumnNames.OptyNumber,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.OptyNumber
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.PartyName1,
                Name = OSCOpportunitiesTableColumnNames.PartyName1,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.PartyName1
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.EmailAddress,
                Name = OSCOpportunitiesTableColumnNames.EmailAddress,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.EmailAddress
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.Name,
                Name = OSCOpportunitiesTableColumnNames.Name,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.Name
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.Description,
                Name = OSCOpportunitiesTableColumnNames.Description,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.Description
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.StatusCode,
                Name = OSCOpportunitiesTableColumnNames.StatusCode,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.StatusCode
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.SalesMethod,
                Name = OSCOpportunitiesTableColumnNames.SalesMethod,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesMethod
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.SalesStage,
                Name = OSCOpportunitiesTableColumnNames.SalesStage,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesStage
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.SalesChannelCd,
                Name = OSCOpportunitiesTableColumnNames.SalesChannelCd,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.SalesChannelCd
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.CurrencyCode,
                Name = OSCOpportunitiesTableColumnNames.CurrencyCode,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.CurrencyCode
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.Revenue,
                Name = OSCOpportunitiesTableColumnNames.Revenue,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.Revenue
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.WinProb,
                Name = OSCOpportunitiesTableColumnNames.WinProb,
                CanDisplay = true,
                CanFilter = true,
                Description = OSCOpportunitiesTableColumnDesc.Revenue
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.ForecastedCloseDate,
                Name = OSCOpportunitiesTableColumnNames.ForecastedCloseDate,
                CanDisplay = true,
                Description = OSCOpportunitiesTableColumnDesc.ForecastedCloseDate
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.CreatedBy,
                Name = OSCOpportunitiesTableColumnNames.CreatedBy,
                CanDisplay = true,
                Description = OSCOpportunitiesTableColumnDesc.CreatedBy
            });

            this.Columns.Add(new ReportColumn()
            {
                DataType = ReportColumnType.String,
                Label = OSCOpportunitiesTableColumnLabels.CreationDate,
                Name = OSCOpportunitiesTableColumnNames.CreationDate,
                CanDisplay = true,
                Description = OSCOpportunitiesTableColumnDesc.CreationDate
            });
        }
예제 #4
0
 public ReportTable(IReportTablePackage package)
 {
     this.parent  = package;
     this.columns = new List <IReportTableColumn>();
 }