public DataTable ExecReportResult(int titleId, List <object> paramList) { BaseReportTitle title = NewObject <BaseReportTitle>().getmodel(titleId) as BaseReportTitle; string spName = title.ProName; return(oleDb.GetDataTable(spName, paramList.ToArray())); }
public void LookReportDataSource(int titleId, List <object> paramList) { BaseReportTitle title = NewObject <BaseReportTitle>().getmodel(titleId) as BaseReportTitle; string spName = title.ProName; DataTable dt = oleDb.GetDataTable(spName, paramList.ToArray()); (iBaseView["FrmUnitData"] as IfrmUnitData).loadUnitData(dt); (iBaseView["FrmUnitData"] as IfrmUnitData).UnitDataShowDialog(); }
private void toolStripButton1_Click(object sender, EventArgs e) { axGRDisplayViewer1.Stop(); BaseReportTitle reportTitle = (BaseReportTitle)treeView1.SelectedNode.Tag; tPrintTable = (DataTable)InvokeController("ExecReportResult", reportTitle.TitleId, GetReportParamsValue()); string Reportname = reportTitle.RptFileName.Trim() + ".grf"; if (!System.IO.File.Exists(EFWCoreLib.CoreFrame.Init.AppGlobal.AppRootPath + @"Report\" + Reportname)) { Report = new GridppReport(); Report.InsertReportHeader(); Report.InsertDetailGrid(); Report.InsertReportFooter(); Report.DetailGrid.IsCrossTab = true; IGRRecordset RecordSet = Report.DetailGrid.Recordset; foreach (DataColumn col in tPrintTable.Columns) { if (col.DataType == typeof(Int32)) { RecordSet.AddField(col.ColumnName, GRFieldType.grftInteger); } else if (col.DataType == typeof(Decimal) || col.DataType == typeof(Double)) { RecordSet.AddField(col.ColumnName, GRFieldType.grftFloat); } else { RecordSet.AddField(col.ColumnName, GRFieldType.grftString); } } Report.AddParameter("报表名称", GRParameterDataType.grptString); Report.AddParameter("打印时间", GRParameterDataType.grptString); Report.AddParameter("当前科室", GRParameterDataType.grptString); Report.AddParameter("当前人员", GRParameterDataType.grptString); Report.DetailGrid.IsCrossTab = false; Report.SaveToFile(EFWCoreLib.CoreFrame.Init.AppGlobal.AppRootPath + @"Report\" + Reportname); } Report = new GridppReport(); Report.LoadFromFile(EFWCoreLib.CoreFrame.Init.AppGlobal.AppRootPath + @"Report\" + Reportname); Report.ParameterByName("报表名称").AsString = reportTitle.Name; Report.ParameterByName("打印时间").AsString = System.DateTime.Now.ToString(); Report.ParameterByName("当前科室").AsString = ""; Report.ParameterByName("当前人员").AsString = ""; Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(reportPrinter_FetchRecord); axGRDisplayViewer1.Report = Report; axGRDisplayViewer1.Start(); }
private void toolStripButton3_Click(object sender, EventArgs e) { BaseReportTitle reportTitle = (BaseReportTitle)treeView1.SelectedNode.Tag; string Reportname = EFWCoreLib.CoreFrame.Init.AppGlobal.AppRootPath + @"Report\" + reportTitle.RptFileName.Trim() + ".grf"; if (File.Exists(Reportname)) { InvokeController("ReportDesigner", Reportname); } else { MessageBoxEx.Show("此报表文件还没有创建,请先点击查询创建基本的报表文件再进行设计!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void AlterTitle(int titleId) { frmAddReport.loadsp(NewObject <ReportTitle>().GetDbProcedures()); DataTable typerep = new DataTable(); typerep.Columns.Add("id"); typerep.Columns.Add("name"); typerep.Rows.Add(0, "网格"); typerep.Rows.Add(1, "交叉"); typerep.Rows.Add(2, "参数"); frmAddReport.loadreporttype(typerep); BaseReportTitle title = NewObject <BaseReportTitle>().getmodel(titleId) as BaseReportTitle; frmAddReport.currTitle = title; (frmAddReport as Form).Text = "修改报表"; (frmAddReport as Form).ShowDialog(); }
public void NewTitle(int layerId) { frmAddReport.loadsp(NewObject <ReportTitle>().GetDbProcedures()); DataTable typerep = new DataTable(); typerep.Columns.Add("id"); typerep.Columns.Add("name"); typerep.Rows.Add(0, "网格"); typerep.Rows.Add(1, "交叉"); typerep.Rows.Add(2, "参数"); frmAddReport.loadreporttype(typerep); BaseReportTitle title = NewObject <BaseReportTitle>(); title.LayerId = layerId; frmAddReport.currTitle = title; (frmAddReport as Form).Text = "添加报表"; (frmAddReport as Form).ShowDialog(); }
//[AOP(typeof(AopTransaction))] public void InitFields(int titleId) { BaseReportTitle title = NewObject <BaseReportTitle>().getmodel(titleId) as BaseReportTitle; DataTable dt = NewDao <ReportDao>().GetProFields(title.ProName); List <BaseReportField> fields = new List <BaseReportField>(); try { //先删除原来数据 NewDao <ReportDao>().DeleteField(titleId); //循环添加字段 for (int i = 0; i < dt.Rows.Count; i++) { BaseReportField field = NewObject <BaseReportField>(); field.FieldId = 0; field.TitleId = titleId; field.Name = dt.Rows[i]["parmname"].ToString(); field.ColName = dt.Rows[i]["parmname"].ToString(); field.ColLength = Convert.ToInt32(dt.Rows[i]["length"]); field.DataType = dt.Rows[i]["typename"].ToString(); field.UiType = 0; field.DynamicSQL = ""; field.DataUnitId = "-1"; field.IsMust = dt.Rows[i]["rowtype"].ToString() == "P" ? 0 : 1; field.MatchRegular = ""; field.SortId = i; field.save(); } } catch (Exception e) { throw e; } }
private void toolStripButton2_Click(object sender, EventArgs e) { BaseReportTitle reportTitle = (BaseReportTitle)treeView1.SelectedNode.Tag; InvokeController("LookReportDataSource", reportTitle.TitleId, GetReportParamsValue()); }