成功案例02:C#调用FastReport控件示例

百度上搜索FastReport组件必须的dll文件,如下图:

创建个WinForm项目

引用dll文件

引用dll文件创建FastReport控件工具

创建打印设置From

C#代码:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using FastReport;
using System.Data.SqlClient;

namespace PrintTest001
{
    public partial class FrmPrintDesigner : Form
    {
        public FrmPrintDesigner()
        {
            InitializeComponent();
        }

        private void FrmPrintDesigner_Load(object sender, EventArgs e)
        {
            Report dReport = new Report();   //实例化一个Report报表
            String reportFile = "Report/Report01.frx";
            dReport.Load(reportFile);  //载入报表文件
            this.designerControl1.Report = dReport; //这里不一样的是把Report赋给控件的属性            
            DataSet ds1 = new DataSet();
            ds1 = getDataHz();
            dReport.RegisterData(ds1, "单据汇总");

            DataSet ds2 = new DataSet();
            ds2 = getDataMx();
            dReport.RegisterData(ds2, "单据明细");

            dReport.Prepare();   //准备
            dReport.Design();  //显示
        } 

        private DataSet getDataHz()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.HzSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据汇总");
            conn.Close();
            return ds;
        }
        private DataSet getDataMx()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.MxSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据明细");
            conn.Close();
            return ds;
        }
    }
}

创建打印预览From

C#代码:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using FastReport;
using System.Data.SqlClient;

namespace PrintTest001
{
    public partial class FrmPrintPreview : Form
    {
        public FrmPrintPreview()
        {
            InitializeComponent();
        }

        private void FrmPrintPreview_Load(object sender, EventArgs e)
        {
            Report dReport = new Report();   //实例化一个Report报表
            String reportFile = "Report/Report01.frx";
            dReport.Load(reportFile);  //载入报表文件
            dReport.Preview = previewControl1; //设置报表的Preview控件(这里的previewControl1就是我们之前拖进去的那个)    
            DataSet ds1 = new DataSet();
            ds1 = getDataHz();
            dReport.RegisterData(ds1, "单据汇总");

            DataSet ds2 = new DataSet();
            ds2 = getDataMx();
            dReport.RegisterData(ds2, "单据明细");

            dReport.Prepare();   //准备
            dReport.ShowPrepared();  //显示

        }

        private DataSet getDataHz()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.HzSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据汇总");
            conn.Close();
            return ds;
        }
        private DataSet getDataMx()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.MxSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据明细");
            conn.Close();
            return ds;
        }
    }
}

示例:

 

打印设置效果:

打印预览效果:

  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值