C# Report.RegisterData方法代码示例

    public void RegisterData(Report FReport)
    {
        DataSet FDataSet = new DataSet();
        FDataSet.ReadXml(Request.PhysicalApplicationPath + "App_Data\\nwind.xml");

        FReport.RegisterData(FDataSet, "NorthWind");

        List<Category> list = new List<Category>();
        Category category = new Category("Beverages", "Soft drinks, coffees, teas, beers");
        category.Products.Add(new Product("Chai", 18m));
        category.Products.Add(new Product("Chang", 19m));
        category.Products.Add(new Product("Ipoh coffee", 46m));
        list.Add(category);

        category = new Category("Confections", "Desserts, candies, and sweet breads");
        category.Products.Add(new Product("Chocolade", 12.75m));
        category.Products.Add(new Product("Scottish Longbreads", 12.5m));
        category.Products.Add(new Product("Tarte au sucre", 49.3m));
        list.Add(category);

        category = new Category("Seafood", "Seaweed and fish");
        category.Products.Add(new Product("Boston Crab Meat", 18.4m));
        category.Products.Add(new Product("Red caviar", 15m));
        list.Add(category);

        FReport.RegisterData(list, "Categories BusinessObject", BOConverterFlags.AllowFields, 3);
    }

        private void frmPregledDobavljacaPoTrgovinama_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.F5)
            {
                 try
                    {
                        DataTable artikli = new DataTable();

                        veza.ExecuteQuery("select partner.pa_sifra, partner.pa_naziv, poslovnica.po_naziv from dobavljacposlovnica, partner, poslovnica where dobavljacposlovnica.poslovnica_po_ID = poslovnica.po_ID and dobavljacposlovnica.partner_pa_ID = partner.pa_ID and dobavljacposlovnica.poslovnica_po_ID = "+glDobavljac.EditValue+" order by partner.pa_naziv", ref artikli);

                        if (gridView1.RowCount > 0)
                        {
                            //create dataset
                            DataSet FDataSet = new DataSet();
                            artikli.TableName = "Artikli";
                            FDataSet.Tables.Add(artikli);

                            // create report instance
                            Report report = new Report();

                            // load the existing report
                            System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                            string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                            report.Load(baseDir + "/report/dobavljac_trgovina.frx");

                            // register the dataset
                            report.RegisterData(FDataSet);

                            //dizajn
                            //report.Design();

                            // run the report
                            report.Show();

                            // free resources used by report
                            report.Dispose();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                //string IDposlovnica = glDobavljac.EditValue.ToString();

                //System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                //string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                //report1.Load(baseDir + "/report/dobavljac_trgovina.frx");

                //report1.SetParameterValue("poslovnicaID", IDposlovnica);
                ////report1.Load("C:/Users/IvanS/Documents/Visual Studio 2010/Projects/odobrenja_3.3/Report.frx");
                //report1.Show();
            }
            else if (e.KeyCode == Keys.Escape)
            {
                this.Close();
            }
        }

 public static void PrintPreview(DataTable data, string fileName)
 {
     Report report = new Report();
     report.Load(fileName);
     report.RegisterData(data, fileName);
     //这样就可以预览数据了
     report.Show();
     report.Dispose();
 }

 public void showInfedenceLKK(string id)
 {
     Database dataToReport = new Database();
     DataSet rep = new DataSet();
     rep = dataToReport.getInfedenceLKK (id);
     Report infedence = new Report();
     infedence.Load("infedence.frx");
     infedence.RegisterData(rep);
     infedence.Show();
 }

        private void btnListaUkupno_Click(object sender, EventArgs e)
        {
            if (dgArtikli.Rows.Count > 0)
            {
                try
                {
                    DataTable artikli = new DataTable();
                    artikli = pregled_akcijskih_nabavnih_cijena.Tables["Table"].Copy();
                    string partner = glDobavljac.Text;
                    string datumOD = Convert.ToDateTime(dtpODkada.Text).ToString("dd-MM-yyyy");
                    string datumDO = Convert.ToDateTime(dtpDokada.Text).ToString("dd-MM-yyyy");

                    //pregled_akcijskih_nabavnih_cijena.PregledAkcNabCijena.Copy();
                    //pregled_akcijskih_nabavnih_cijena.PregledAkcNabCijena.CopyToDataTable(artikli,LoadOption.Upsert);

                    //veza.ExecuteQuery("select poslovnica.po_ID, poslovnica.po_sifra, poslovnica.po_naziv, mjesto.mj_naziv, poslovnica.po_asortiman, poslovnica.po_cjenik from poslovnica, mjesto where mjesto.mj_ID = poslovnica.mjesto_mj_ID and poslovnica.po_aktivna = 1 and poslovnica.po_datumZatvaranja is null and (poslovnica.vp_sifra = 300 or  poslovnica.vp_sifra =200) and (poslovnica.po_cjenik <> '' or poslovnica.po_asortiman <> '') order by poslovnica.po_sifra asc", ref artikli);

                    if (dgArtikli.Rows.Count > 0)
                    {
                        //create dataset
                        DataSet FDataSet = new DataSet();
                        artikli.TableName = "Artikli";
                        FDataSet.Tables.Add(artikli);

                        // create report instance
                        Report report = new Report();

                        // load the existing report
                        System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                        string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                        report.Load(baseDir + "/report/PregledAkcNabCijena.frx");

                        // register the dataset
                        report.RegisterData(FDataSet);
                        report.SetParameterValue("Partner", partner);
                        report.SetParameterValue("DatumOD", datumOD);
                        report.SetParameterValue("DatumDO", datumDO);

                        //dizajn
                        //report.Design();

                        // run the report
                        report.Show();

                        // free resources used by report
                        report.Dispose();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// Construtor da classe reponsável pela impressão do DANFE da NFe em Fast Reports
        /// </summary>
        /// <param name="proc">Objeto do tipo nfeProc</param>
        /// <param name="configuracaoDanfeNfe">Objeto do tipo configuracaoDanfeNfe contendo as definições de impressão</param>
        public DanfeFrNfe(nfeProc proc, ConfiguracaoDanfeNfe configuracaoDanfeNfe)
        {
            #region Define as varíaveis que serão usadas no relatório (dúvidas a respeito do fast reports consulte a documentação em https://www.fast-report.com/pt/product/fast-report-net/documentation/)

            Relatorio = new Report();
            Relatorio.RegisterData(new[] { proc }, "NFe", 20);
            Relatorio.GetDataSource("NFe").Enabled = true;
            Relatorio.Load(new MemoryStream(Properties.Resources.NFe));
            ((PictureObject)Relatorio.FindObject("poEmitLogo")).Image = configuracaoDanfeNfe.ObterLogo();

            #endregion
        }

        private void btnIzvjestaj_Click(object sender, EventArgs e)
        {
            if (gridView2.RowCount > 0)
            {
                try
                {
                    DataTable artikli = new DataTable();
                    artikli = dodatnePozicijeZaTrgovinu.DodatneTrgovina.CopyToDataTable();
                    string datOD =  Convert.ToDateTime(dtpDatumOD.Text).ToString("dd-MM-yyyy");
                    string datDO = Convert.ToDateTime(dtpDatumDO.Text).ToString("dd-MM-yyyy");
                    //string skladisteBroj = txtSkladiste.Text;
                    //string brojNarudzbe = txtBrojNarudzbe.Text;

                    //veza.ExecuteQuery("select poslovnica.po_ID, poslovnica.po_sifra, poslovnica.po_naziv, mjesto.mj_naziv, poslovnica.po_asortiman, poslovnica.po_cjenik from poslovnica, mjesto where mjesto.mj_ID = poslovnica.mjesto_mj_ID and poslovnica.po_aktivna = 1 and poslovnica.po_datumZatvaranja is null and (poslovnica.vp_sifra = 300 or  poslovnica.vp_sifra =200) and (poslovnica.po_cjenik <> '' or poslovnica.po_asortiman <> '') order by poslovnica.po_sifra asc", ref artikli);

                    if (gridView2.RowCount > 0)
                    {
                        //create dataset
                        DataSet FDataSet = new DataSet();
                        artikli.TableName = "Artikli";
                        FDataSet.Tables.Add(artikli);

                        // create report instance
                        Report report = new Report();

                        // load the existing report
                        System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                        string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                        report.Load(baseDir + "/report/DogovorenePozicijeTrgovina.frx");
                        report.SetParameterValue("datumod", datOD);
                        report.SetParameterValue("datumdo", datDO);

                        // register the dataset
                        report.RegisterData(FDataSet);

                        //dizajn
                        //report.Design();

                        // run the report
                        report.Show();

                        // free resources used by report
                        report.Dispose();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        public Report PrepareReport(Entity.Resume resume)
        {
            Report report = new Report();

            DataTable personInfo = getResumeInfo(resume);
            DataTable expect = getExpert(resume);
            DataTable eduback = getEduBack(resume);

            report.Load(Environment.CurrentDirectory + @"\Templates\大众通用.frx");
            TextObject txtTitle = report.FindObject("txtTitle") as TextObject;
            txtTitle.Text = resume.ResumeName + "的个人资料";
            PictureObject pictureHead = report.FindObject("pictureHead") as PictureObject;
            pictureHead.ImageLocation = Environment.CurrentDirectory + @"\Templates\logo.png";

            TextObject gender = report.FindObject("gender") as TextObject;
            gender.Text = (personInfo.Rows[0]["person_gender"].ToString() == "0") ? "男" : "女";

            TextObject birth =report.FindObject("birthday")as TextObject;
            IFormatProvider provider = new CultureInfo("zh-CN",true);
            birth.Text = DateTime.Parse(personInfo.Rows[0]["person_birthday"].ToString(),provider).ToShortDateString().ToString();

            report.RegisterData(personInfo, "person_info");
            report.RegisterData(expect, "expect");
            report.RegisterData(eduback, "education_background");
            DataBand db = report.FindObject("Data1") as DataBand;
            db.DataSource = report.GetDataSource("education_background");

            TextObject expectarea = report.FindObject("expectarea") as TextObject;
            expectarea.Text = getAreaByAreaCode(expect.Rows[0]["expect_area1"].ToString()).Rows[0]["area_name"].ToString();

            TextObject living = report.FindObject("living") as TextObject;
            living.Text = getAreaByAreaCode(personInfo.Rows[0]["person_living_area"].ToString()).Rows[0]["area_name"].ToString();

            TextObject belong = report.FindObject("belong")as TextObject;
            belong.Text = getAreaByAreaCode(personInfo.Rows[0]["person_born_area"].ToString()).Rows[0]["area_name"].ToString();

            report.Prepare();
            return report;
        }

        private void btnIspisi_Click(object sender, EventArgs e)
        {
            try
            {
                if (dgPodaci.RowCount > 0)
                {
                    try
                    {
                        DataTable artikli = new DataTable();
                        artikli = slanje_na_knjizenje.SlanjeNaKnjizenje.CopyToDataTable();
                        string datumSlanja = Convert.ToDateTime(dtpPredaja.EditValue).ToString("dd.MM.yyyy");

                        //create dataset
                        DataSet FDataSet = new DataSet();
                        artikli.TableName = "Artikli";
                        FDataSet.Tables.Add(artikli);

                        // create report instance
                        Report report = new Report();

                        // load the existing report
                        System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                        string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                        report.Load(baseDir + "/report/Knjizenje3.frx");
                        report.SetParameterValue("datumSlanja", datumSlanja);

                        // register the dataset
                        report.RegisterData(FDataSet);

                        //dizajn
                        //report.Design();

                        // run the report
                        report.Show();

                        // free resources used by report
                        report.Dispose();
                    }

                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

 public void GenderPDFReport(LisReport lr, string rootPath)
 {
     //DataSet ds = CreateDataSet("ReportTables.frd");
     DataSet ds = GetPrintDataSet("ReportTables.frd");
     FillDataSet(lr, ds);
     Report report = new Report();
     //获取模板
     string modelName = GetReportModelName(lr);
     //获取生成文件全路径
     string fileFullName = GenderFileFullName(lr.ReportInfo, rootPath, lr.OrderNo);
     report.Load(GetReprotModelPath(modelName));
     report.RegisterData(ds);
     report.Prepare();
     PDFExport export = new PDFExport();
     report.Export(export, fileFullName);
     report.Dispose();
 }

        private void btnAsortimanCjenik_Click(object sender, EventArgs e)
        {
            if (gridView2.RowCount > 0)
            {
                try
                {
                    DataTable artikli = new DataTable();
                    veza.ExecuteQuery("select poslovnica.po_ID, poslovnica.po_sifra, poslovnica.po_naziv, mjesto.mj_naziv, poslovnica.po_asortiman, poslovnica.po_cjenik from poslovnica, mjesto where mjesto.mj_ID = poslovnica.mjesto_mj_ID and poslovnica.po_aktivna = 1 and poslovnica.po_datumZatvaranja is null and (poslovnica.vp_sifra = 300 or  poslovnica.vp_sifra =200) and (poslovnica.po_cjenik <> '' or poslovnica.po_asortiman <> '') order by poslovnica.po_sifra asc", ref artikli);

                    if (artikli.Rows.Count > 0)
                    {
                        //create dataset
                        DataSet FDataSet = new DataSet();
                        artikli.TableName = "Artikli";
                        FDataSet.Tables.Add(artikli);

                        // create report instance
                        Report report = new Report();

                        // load the existing report
                        System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                        string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                        report.Load(baseDir + "/report/ListaAsortimanCjenik.frx");

                        // register the dataset
                        report.RegisterData(FDataSet);

                        //dizajn
                        //report.Design();

                        // run the report
                        report.Show();

                        // free resources used by report
                        report.Dispose();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// Construtor da classe reponsável pela impressão do DANFE da NFCe em Fast Reports
        /// </summary>
        /// <param name="proc">Objeto do tipo nfeProc</param>
        /// <param name="configuracaoDanfeNfce">Objeto do tipo ConfiguracaoDanfeNfce contendo as definições de impressão</param>
        public DanfeFrNfce(nfeProc proc, ConfiguracaoDanfeNfce configuracaoDanfeNfce)
        {
            #region Define as varíaveis que serão usadas no relatório (dúvidas a respeito do fast reports consulte a documentação em https://www.fast-report.com/pt/product/fast-report-net/documentation/)

            _relatorio = new Report();
            _relatorio.RegisterData(new[] { proc }, "NFCe", 20);
            _relatorio.GetDataSource("NFCe").Enabled = true;
            _relatorio.Load(new MemoryStream(Properties.Resources.NFCe));
            _relatorio.SetParameterValue("NfceDetalheVendaNormal", configuracaoDanfeNfce.DetalheVendaNormal);
            _relatorio.SetParameterValue("NfceDetalheVendaContigencia", configuracaoDanfeNfce.DetalheVendaContigencia);
            ((PictureObject) _relatorio.FindObject("poEmitLogo")).Image = configuracaoDanfeNfce.ObterLogo();
            ((TextObject)_relatorio.FindObject("txtUrl")).Text = EnderecadorDanfeNfce.ObterUrl(proc.NFe.infNFe.ide.tpAmb, proc.NFe.infNFe.ide.cUF, TipoUrlDanfeNfce.UrlConsulta);
            ((BarcodeObject)_relatorio.FindObject("bcoQrCode")).Text = EnderecadorDanfeNfce.ObterUrlQrCode(proc, configuracaoDanfeNfce);

            //Segundo o Manual de Padrões Padrões Técnicos do DANFE - NFC - e e QR Code, versão 3.2, página 9, nos casos de emissão em contigência deve ser impresso uma segunda cópia como via do estabelecimento
            _relatorio.PrintSettings.Copies = proc.NFe.infNFe.ide.tpEmis == TipoEmissao.teNormal ? 1 : 2;

            #endregion
        }

        public void ispis(string broj)
        {
            try
            {
                DataTable finacijsko = new DataTable();

                veza.ExecuteQuery("select partner.pa_sifra, partner.PA_NAZIV, gratis.gr_datum, gratis.akc_broj, gratis.gr_vrijednostsnizenja, gratis.gr_zapisnik, poslovnica.po_sifra, poslovnica.po_naziv from gratis left join poslovnica on poslovnica.po_id=gratis.poslovnica_PO_ID left join partner on partner.PA_ID=gratis.partneri_PA_ID where gratis.akc_broj ='"+broj+"'", ref finacijsko);

                if (finacijsko.Rows.Count > 0)
                {
                    //create dataset
                    DataSet FDataSet = new DataSet();
                    finacijsko.TableName = "Financijsko";
                    FDataSet.Tables.Add(finacijsko);

                    // create report instance
                    Report report = new Report();

                    // load the existing report
                    System.Reflection.Assembly a = System.Reflection.Assembly.GetEntryAssembly();
                    string baseDir = System.IO.Path.GetDirectoryName(a.Location);

                    report.Load(baseDir + "/report/Financijsko_snizenja.frx");

                    // register the dataset
                    report.RegisterData(FDataSet);
                    report.SetParameterValue("Mjesec", "2");

                    //dizajn
                    //report.Design();

                    // run the report
                    report.Show();

                    // free resources used by report
                    report.Dispose();
                }
            }
            catch (Exception ex)
            {
            }
        }

        public void showReportLKK(string id, DataTable results)
        {
            Report reportLKK = new Report();
            if (Program.status == 0)
            {
                reportLKK.Load("report.frx");
            }
            else
            {
                reportLKK.Load("register.frx");
            }
            reportLKK.RegisterData(results, "resultData");
            if (id != "")
            {
                DataBand dataBand = reportLKK.FindObject("reportData") as DataBand;
                dataBand.Filter = "[resultData.id]==" + id;

            }
            reportLKK.Show();
        }

 public static void Print(DataTable data, string fileName,MemoryStream ms=null)
 {
     //不显示打印进度条
     setting.ReportSettings.ShowProgress = false;
     Report report = new Report();
     report.Load(fileName);
     report.PrintSettings.ShowDialog = false;
     report.RegisterData(data, fileName);
     if (ms != null)
     {
         object obj = report.FindObject("Picture1");
         {
             if(obj!=null)
                 ((PictureObject)obj).Image = System.Drawing.Image.FromStream(ms);
         }
     }
     //这样就可以打印数据了
     report.Print();
     report.Dispose();
 }