winform连接锐浪GridReport打印示例

 

 

using grproLib;
using LRTMS.Common;
using LRTMS.DB;
using LRTMS.Report;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WeifenLuo.WinFormsUI.Docking;namespace LRTMS.Forms
{public partial class FrmDeliverPrint : DockContent{string sql = "";string taskId="0", taskNo, carNo, driverName, superCargoName, Taskdate;DataTable dt,dtDetail;//定义Grid++Report报表主对象GridppReport Report = new GridppReport();public FrmDeliverPrint(){InitializeComponent();Report.Initialize += new _IGridppReportEvents_InitializeEventHandler(ReportInitialize);}void ReportInitialize(){if (dataGridView1.Rows.Count < 0) return;int i = dataGridView1.CurrentCell.RowIndex;if (i < 0) return;taskNo = dataGridView1.Rows[i].Cells["TASK_BILL_NO"].Value.ToString();carNo = dataGridView1.Rows[i].Cells["car_number"].Value.ToString();driverName = dataGridView1.Rows[i].Cells["driver_name"].Value.ToString();Taskdate = dataGridView1.Rows[i].Cells["create_time"].Value.ToString();superCargoName = dataGridView1.Rows[i].Cells["SUPERCARGO_NAME"].Value.ToString();taskId = dataGridView1.Rows[i].Cells["task_id"].Value.ToString();Report.LoadFromFile("Report\\pcd.grf");Report.ParameterByName("task_no").AsString = taskNo;//主报表传参Report.ParameterByName("car_no").AsString = carNo;//主报表传参Report.ParameterByName("driver_name").AsString = driverName;//主报表传参Report.ParameterByName("supercargo").AsString = superCargoName;//主报表传参Report.ParameterByName("bill_date").AsString = Taskdate;//主报表传参Report.DetailGrid.Recordset.ConnectionString = "Provider=OraOLEDB.Oracle;" + CommFunc.GetConnString();Report.DetailGrid.Recordset.QuerySQL = "select * from lrtms_task_dtl where task_id=" + taskId;}private void DefineReport(){int Selected = 0;Report.Clear();Report.Printer.PaperOrientation = GRPaperOrientation.grpoLandscape;//<<定义报表头IGRReportHeader Reportheader = Report.InsertReportHeader();Reportheader.Height = 1.38;//插入一个静态文本框,显示报表标题文字IGRStaticBox StaticBox = Reportheader.Controls.Add(GRControlType.grctStaticBox).AsStaticBox;if (Selected == 0)StaticBox.Text = "客户清单打印";elseStaticBox.Text = "产品清单打印";StaticBox.Center = GRCenterStyle.grcsHorizontal; //使部件框在节中水平方向上居中对齐StaticBox.Font.Point = 15;StaticBox.Font.Bold = true;StaticBox.Top = 0.40;StaticBox.Width = 5.64;StaticBox.Height = 0.58;//>>定义报表头//<<根据DataGridView的列信息定义明细网格Report.InsertDetailGrid();Report.DetailGrid.ColumnTitle.Height = 0.58;Report.DetailGrid.ColumnContent.Height = 0.58;IGRRecordset RecordSet = Report.DetailGrid.Recordset;for (int i = 0; i < dataGridView1.ColumnCount; ++i){string ColumnName = dataGridView1.Columns[i].Name;RecordSet.AddField(ColumnName, GRFieldType.grftString);double ReportColumnWidth = Convert.ToDouble(dataGridView1.Columns[i].Width) / 50;Report.DetailGrid.AddColumn(ColumnName, dataGridView1.Columns[i].HeaderText, ColumnName, ReportColumnWidth);}}private void tsbSearchDeliver_Click(object sender, EventArgs e){string deliveryNo = txtDeliverNo.Text.Trim();if (string.IsNullOrEmpty(deliveryNo)){MessageBox.Show("请输入交货单号");return;}Report.PrintPreview(true);}private struct MatchFieldPairType{public IGRField grField;public int MatchColumnIndex;}private void tsbClose_Click(object sender, EventArgs e){this.Close();}/// <summary>/// 将 DataTable 的数据转储到 Grid++Report 的数据集中/// </summary>/// <param name="Report">报表对象</param>/// <param name="dt">DataTable对象</param>public void FillRecordToReport(IGridppReport Report, DataTable dt){MatchFieldPairType[] MatchFieldPairs = new MatchFieldPairType[Math.Min(Report.DetailGrid.Recordset.Fields.Count, dt.Columns.Count)];//根据字段名称与列名称进行匹配，建立DataReader字段与Grid++Report记录集的字段之间的对应关系int MatchFieldCount = 0;for (int i = 0; i < dt.Columns.Count; ++i){foreach (IGRField fld in Report.DetailGrid.Recordset.Fields){if (string.Compare(fld.Name, dt.Columns[i].ColumnName, true) == 0){MatchFieldPairs[MatchFieldCount].grField = fld;MatchFieldPairs[MatchFieldCount].MatchColumnIndex = i;++MatchFieldCount;break;}}}// 将 DataTable 中的每一条记录转储到 Grid++Report 的数据集中去foreach (DataRow dr in dt.Rows){Report.DetailGrid.Recordset.Append();for (int i = 0; i < MatchFieldCount; ++i){var columnIndex = MatchFieldPairs[i].MatchColumnIndex;if (!dr.IsNull(columnIndex)){MatchFieldPairs[i].grField.Value = dr[columnIndex];}}Report.DetailGrid.Recordset.Post();}}void dt_FetchREcord(){FillRecordToReport(Report, dtDetail);}private void tsmFilter_Click(object sender, EventArgs e){}//主表点击事件，根据主表的TASK_ID，显示子表的数据private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e){if (e.RowIndex < 0) return;string taskId = dataGridView1.Rows[e.RowIndex].Cells["task_id"].Value.ToString();dtDetail = DBHelperOracle.GetTable("select * from lrtms_task_dtl where task_id=" + taskId);dataGridView2.DataSource = dtDetail;}//打印按钮private void tsbPrint_Click(object sender, EventArgs e){//最最重要的一句代码，Report.FetchRecord// Report.FetchRecord += dt_FetchREcord;Report.PrintPreview(true);}private void FrmDeliverPrint_Load(object sender, EventArgs e){sql = "select * from lrtms_task_hdr";dt = DBHelperOracle.GetTable(sql);dataGridView1.DataSource = dt;}}
}