FastReport绑定数据并进行打印.docxVIP

使用FastReport进行打印C#代码//准备工作: 打开设计器创建一个空的报表LiShiChuFang.frxDataSet FDataSet = new DataSet();//fastreport中的数据源必须为DataSet if (mDtLishiChufang == null||mDtLishiChufang.Rows.Count == 0 ) { MsgHelper.MessageBoxWarning(当前无需要打印的信息); return; }//为DataSet添加表并对表命名以方便区分在fastreport中的数据源绑定 DataTable table = new DataTable(); table.TableName = ChuFang; FDataSet.Tables.Add(table); //为table创建新列 table.Columns.Add(Datetime, typeof(string)); table.Columns.Add(YaoPinName, typeof(string)); table.Columns.Add(ShuLiang, typeof(string)); table.Columns.Add(ZongDanwei, typeof(string)); table.Columns.Add(YongLiang, typeof(string)); table.Columns.Add(DanDanwei, typeof(string)); table.Columns.Add(PinCi, typeof(string)); table.Columns.Add(YongFa, typeof(string)); table.Columns.Add(ChiXuTianShu, typeof(string)); table.Columns.Add(KaiDanRen, typeof(string)); double totleMoney = 0;//对table添加数据 for (int i = 0; i mDtLishiChufang.Rows.Count; i++) { table.Rows.Add(mDtLishiChufang.Rows[i][kaidantime].ToString(), mDtLishiChufang.Rows[i][药品名称].ToString(), mDtLishiChufang.Rows[i][数量].ToString(), mDtLishiChufang.Rows[i][单位].ToString(), mDtLishiChufang.Rows[i][单量].ToString(), mDtLishiChufang.Rows[i][单量单位].ToString(), mDtLishiChufang.Rows[i][频次].ToString(), mDtLishiChufang.Rows[i][用法].ToString(), mDtLishiChufang.Rows[i][持续天数].ToString(), mDtLishiChufang.Rows[i][CaoZuoRenName].ToString()); if (mDtLishiChufang.Rows[i][总价] != null mDtLishiChufang.Rows[i][总价].ToString().Length 0) { totleMoney += Convert.ToDouble(mDtLishiChufang.Rows[i][总价]); } else { continue; } } //实例化FastReport并load需要的模板 FastReport.Report report1 = new FastReport.Report(); report1.Load(Application.StartupPath + \\LiShiChuFang.frx); report1.RegisterData(FDataSet);//在fastreport中显示table的数据以便于进行数据绑定 report1.GetDataSource(ChuFang).Enabled = true; DataTable reportdt = new DataTable();//对于fastreport中的参数进行数据绑定 FastReport.Data.Parameter t1 = report1.GetParameter(JiuZhenBianHao); FastReport.Data.Parameter t2 = report1.GetParameter(KeHuName); FastReport