コード例 #1
0
        private void getData()
        {
            RptViewer.Reset();
            CommisionReceivableBo CommisionReceivableBo = new CommisionReceivableBo();
            DataTable             dt   = CommisionReceivableBo.GetBranchBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
            DataTable             dt2  = CommisionReceivableBo.GetAssociateBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
            DataTable             dt3  = CommisionReceivableBo.GetProductApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
            DataTable             dt4  = CommisionReceivableBo.GetAssocaiteApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
            ReportDataSource      rds  = new ReportDataSource("BranchDS_SPROC_GetBranchBrokerageReceivable", dt);
            ReportDataSource      rds2 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetAssociateWiseBrokerageReceived", dt2);
            ReportDataSource      rds3 = new ReportDataSource("ProductBrokerageApplicationWise_SPROC_GetProductBrokerageApplicationWise", dt3);
            ReportDataSource      rds4 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetBranchAssociateCommissionPayOuts", dt4);

            RptViewer.LocalReport.DataSources.Add(rds);
            RptViewer.LocalReport.DataSources.Add(rds2);
            RptViewer.LocalReport.DataSources.Add(rds3);
            RptViewer.LocalReport.DataSources.Add(rds4);
            RptViewer.LocalReport.ReportPath = @"Reports\BrokerageMIS.rdlc";
            ReportParameter[] RP = new ReportParameter[] {
                new ReportParameter("Product", product),
                new ReportParameter("Category", productCategory),
                new ReportParameter("FromDate", fromdate),
                new ReportParameter("ToDate", todate),
                new ReportParameter("AMCCode", amcCode.ToString()),
                new ReportParameter("IssueId", issueid.ToString()),
                new ReportParameter("IsReceivable", IsReceivable),
                new ReportParameter("CommissionType", CommissionType),
                new ReportParameter("Channel", "true"),
            };
            RptViewer.LocalReport.SetParameters(RP);
            RptViewer.LocalReport.Refresh();
        }