FastReport绑定数据并进行打印 (1).doc

使用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 0) totleMoney += Convert.ToDouble(mDtLishiChufang.Rowsi总价); 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.Data.Parameter t3 = report1.GetParameter(ChongWuName); FastReport.Data.Parameter t4 = report1.GetParameter(KaNumber); FastReport.Data.Parameter t5 = report1.GetParameter(KaYue); FastReport.Data.Parameter t6 = report1.GetParameter(Weight); FastReport.Data.Parameter t7 = report1.GetParameter(TotleMoney); FastReport.Data.Parameter t8 = report1.GetParameter(YsName); FastReport.Data.Parameter t9 = report1.GetParameter(GongSiName); FastReport.Data.Parameter t10 = report1.GetParameter(CSex); FastReport.Data.Parameter t11 = report1.GetParameter(CPinZhong); FastReport.Data.Parameter t12 = report1.GetParameter(YsName); FastReport.Data.Parameter t13 = report1.GetParameter(CompanyName); t1.Value = chongwu.jiuzhenbianhao; t2.Value = chongwu.kehu_name; t3.Value = chongwu.chongwu_name; t6.Value = chongwu.weight; t7.Value = totleMoney.ToString(#0.00); t10.Value = chongwu.chongwusex; t11.Value = chongwu.chongwuleibie; t12.Value = EMPModels.PublicInfo.CurrentUserName; t13.Value = EMPModels.PublicInfo.CompanyName; /打开fastreport编辑器进行可视化绑定数据 /report1.Design();/进行打印预览 report1.Prepare(); report1.ShowPrepared();设计器端1.新建参数2.在设计器中添加控件双击进行数据绑定 表格绑定请双击cell双击需要