void Button1Click(object sender, EventArgs e) { //打印当前显示的库存内容 FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\Stock.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = ds1.Tables[0].Clone(); table.TableName = "Stock"; //dataGridView1.SelectAll(); foreach (DataGridViewRow dr in dataGridView1.SelectedRows) { string tsGoodsID = dr.Cells["GoodsID"].Value.ToString(); DataRow[] dr1 = ds1.Tables[0].Select("GoodsID = " + tsGoodsID); //查询 table.ImportRow(dr1[0]); } FDataSet.Tables.Add(table); report1.SetParameterValue("PeriodNo", sPeriodNo); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
void ButtonSCClick(object sender, EventArgs e) { FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\PriceLimit.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = BLL.GoodsTypeBLL.GetAllGoodsType().Tables[0].Copy(); table.TableName = "GoodsType"; FDataSet.Tables.Add(table); table = BLL.RKBLL.GetInStockItems(Convert.ToInt32(comboBoxProject.SelectedValue)).Tables[0].Copy(); table.TableName = "ReceiptItems"; FDataSet.Tables.Add(table); sProjectName = comboBoxProject.Text; report1.SetParameterValue("ProjectName", sProjectName); DataRelation dsdr = new DataRelation("R1", FDataSet.Tables["GoodsType"].Columns["GoodsTypeID"], FDataSet.Tables["ReceiptItems"].Columns["GoodsTypeID"]); FDataSet.Relations.Add(dsdr); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
//----以下是YX01数据采集---- private void GetParaDataPrint_YX02(int tt_itemtype) { //单板打印 if (PrintText != "") { FastReport.Report report = new FastReport.Report(); report.Prepare(); report.Load(Application.StartupPath + "\\LABLE\\YX_2.frx"); report.SetParameterValue("S01", PrintText); report.PrintSettings.ShowDialog = false; //--打印 if (tt_itemtype == 1) { report.Print(); } //--预览 if (tt_itemtype == 2) { report.Design(); } } }
void ButtonPrint1Click(object sender, EventArgs e) { //打印非零库存 FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\Stock.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = ds1.Tables[0].Clone(); DataRow[] drArr = ds1.Tables[0].Select("EndQty <> 0"); //查询 table.TableName = "Stock"; for (int i = 0; i < drArr.Length; i++) { { table.ImportRow(drArr[i]); } } FDataSet.Tables.Add(table); report1.SetParameterValue("PeriodNo", sPeriodNo); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
private byte[] InternalGenerateReport(string reportFile, Dictionary <string, string> parameters) { FastReport.Report report = new FastReport.Report(); report.Load(Path.Combine("Reports", reportFile)); if (string.IsNullOrWhiteSpace(_appSettings.ConnectionString)) { throw new NotSupportedException("Connectionstring não informada"); } report.Dictionary.Connections[0].ConnectionString = _appSettings.ConnectionString; //report.SetParameterValue("initialDate", "2019-01-01"); //report.SetParameterValue("finalDate", "2019-01-07"); foreach (var parameter in parameters) { report.SetParameterValue(parameter.Key, parameter.Value); } report.Prepare(); // report.Parameters[0].Value = 143; //report.Refresh(); PDFSimpleExport export = new PDFSimpleExport(); using (MemoryStream ms = new MemoryStream()) { report.Export(export, ms); ms.Flush(); return(ms.ToArray()); } }
/// <summary> /// FastReports /// </summary> /// <param name="isDesign"></param> private void FastReports(bool isDesign) { System.Data.DataSet printDataDs = new System.Data.DataSet(); try { int[] rownumber = this.gridViewMainData.GetSelectedRows(); DataRow row = this.gridViewMainData.GetDataRow(rownumber[0]); System.Data.DataTable mainData = ToDataTable(row); System.Data.DataTable detailsData = ((DataView)this.gridViewDetailsData.DataSource).ToTable(); if (mainData != null && mainData.Rows.Count > 0) { mainData.TableName = "mainData"; printDataDs.Tables.Add(mainData.Copy()); } if (detailsData != null && detailsData.Rows.Count > 0) { detailsData.TableName = "detailsData"; printDataDs.Tables.Add(detailsData.Copy()); } FastReport.Report report = new FastReport.Report(); Res.LocaleFolder = AppDomain.CurrentDomain.BaseDirectory + "FastReports\\Localization"; Res.LoadLocale(Res.LocaleFolder + @"\Chinese (Simplified).frl"); string FDataTables = "FDataTables"; string filename = @"FastReports\Reports\fx_001.frx"; report.Load(filename); using (Designer designer = new Designer()) { designer.SetModified(this, "EditData"); int i = 0; foreach (DataTable dt in printDataDs.Tables) { FDataTables = "FDataTables" + i.ToString(); printDataDs.Tables[i].TableName = FDataTables; report.RegisterData(printDataDs.Tables[i], FDataTables); report.GetDataSource(FDataTables).Enabled = true; i = i + 1; } Res.LocaleFolder = AppDomain.CurrentDomain.BaseDirectory + "FastReports\\Localization"; Res.LoadLocale(Res.LocaleFolder + @"\Chinese (Simplified).frl"); if (isDesign) { report.Design(); } else { report.SetParameterValue("time", DateTime.Now.Date.ToString("yyyy-MM-dd")); report.Prepare(); report.ShowPrepared(); } } } catch (Exception err) { MessageBox.Show(err.Message); } }
private void Form2_Load(object sender, EventArgs e) { #region 快速报表 FastReport.Report fr = new FastReport.Report(); fr.Load(@"Reports\fastReport1.frx"); fr.Preview = previewControl1; fr.SetParameterValue("Title", "快速报表~~~"); fr.Show(); #endregion }
public static void GenereteReport(ReportParams reportParams) { if (reportParams == null) { throw new ArgumentNullException($"{nameof(reportParams)} cannot be null."); } // create report instance using (FastReport.Report report = new FastReport.Report()) { // load the existing report report.Load(reportParams.FrxPath); // register datasource's if (reportParams.DataSource != null) { foreach (var pair in reportParams.DataSource) { report.RegisterData(pair.Value, pair.Key); } } if (reportParams.Parameters != null) { foreach (var pair in reportParams.Parameters) { report.SetParameterValue(pair.Key, pair.Value); } } // prepare the report report.Prepare(); ExportBase export = null; switch (reportParams.OutputType) { case 0: // export to html export = new HTMLExport(); (export as HTMLExport).Format = HTMLExportFormat.HTML; break; case 1: export = new ImageExport(); (export as ImageExport).ImageFormat = ImageExportFormat.Png; break; default: throw new ArgumentException($"O parametro {reportParams.OutputType} é inválido"); } report.Export(export, reportParams.OutStream); } reportParams.OutStream.Position = 0; }
private void button2_Click(object sender, EventArgs e) { var fileName = Path.Combine(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ReportTemplate"), "收款58mm小票(1).frx"); FastReport.Report report = new FastReport.Report(); report.Load(fileName); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("str1", typeof(string))); dt.Columns.Add(new DataColumn("str2", typeof(string))); dt.Columns.Add(new DataColumn("str3", typeof(string))); dt.Columns.Add(new DataColumn("str4", typeof(string))); for (var i = 0; i < 6; i++) { dt.Rows.Add(i.ToString(), i.ToString() + "单位", i.ToString(), i.ToString() + "Q"); } report.RegisterData(dt, "list"); //注册数据源,单表 report.SetParameterValue("company", "公司"); report.SetParameterValue("patientName", "张三"); report.SetParameterValue("cardNum", "123456789"); report.SetParameterValue("seeDoctoeNumber", "123"); report.SetParameterValue("heji", "99"); report.SetParameterValue("pa", "1"); report.SetParameterValue("relPay", "1"); report.SetParameterValue("payType", "支付宝"); report.SetParameterValue("userDataName", "189"); report.SetParameterValue("phone", "18930037387"); report.PrintSettings.ShowDialog = false; //report.PrintPrepared(); report.Report.Prepare(); //根据模板名称,查询对应打印机 try { report.Print(); } catch (Exception) { MessageBox.Show("无法连接打印机,请检查打印机驱动或更换默认打印机。"); } }
private void simpleButtonPesan_Click(object sender, EventArgs e) { var nomer = 1; var indexSurat = (DbSurat.IndexSurat)lookUpEditIndexSurat.GetSelectedDataRow(); var keperluan = memoEditKeperluan.Text.Trim(); var tanggal = dateEditTanggal.DateTime; var allSuratByIndex = from dataSurat in new XPQuery <DbSurat.Surat>(XpoDefault.Session) where dataSurat.IndexSurat.ID == indexSurat.ID orderby dataSurat.NoSurat select dataSurat; if (allSuratByIndex.Count() > 0) { nomer = allSuratByIndex.LastOrDefault().NoSurat + 1; } DbSurat.Surat surat = new DbSurat.Surat(XpoDefault.Session) { IndexSurat = indexSurat, Tanggal = tanggal, Keperluan = keperluan, NoSurat = nomer, Pemesan = (DbSurat.Pegawai)lookUpEditPemesan.GetSelectedDataRow() }; surat.Save(); if (File.Exists("PrintSurat.frx")) { _report.Load("PrintSurat.frx"); } var stringNomer = indexSurat.Index + " / " + nomer + " / " + tanggal.Year; _report.SetParameterValue("ParameterNoSurat", stringNomer); _report.SetParameterValue("ParameterTanggalSurat", tanggal.ToString("dd/MM/yyyy")); _report.SetParameterValue("ParameterkeperluanSurat", keperluan); _report.Print(); }
private void DisplayReporteEtiquetas() { try { var movimientoEtiquetas = Datos.GetListOf <MovimientoInventarioEtiquetasView>(l => l.MovimientoInventarioID.Equals(oID)); var listaEtiquetas = new List <Etiquetas>(); var cont = 0; foreach (var etiqueta in movimientoEtiquetas) { for (var x = 0; x < etiqueta.NumeroEtiquetas; x++) { cont += 1; var e = new Etiquetas() { MovimientoInventarioEtiquetaID = cont, MovimientoInventarioID = oID, ParteID = etiqueta.ParteID, sParteID = etiqueta.ParteID.ToString("D8"), NumeroParte = etiqueta.NumeroParte, CodigoBarra = etiqueta.CodigoBarra, NumeroEtiquetas = 1, NombreParte = etiqueta.NombreParte //NombreParte = etiqueta.ParteID.ToString("D8") }; listaEtiquetas.Add(e); } } // Se obtiene el folio de la factura, para mandarlo al reporte var oMov = Datos.GetEntity <MovimientoInventario>(c => c.MovimientoInventarioID == oID); IEnumerable <Etiquetas> detalleE = listaEtiquetas; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEtiquetas.frx")); report.RegisterData(detalleE, "etiquetas", 3); report.SetParameterValue("FolioFactura", oMov.FolioFactura); report.GetDataSource("etiquetas").Enabled = true; report.Show(true); //report.Design(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
protected static void SetParameters <T, H>(T entity, IList <H> details, FastReport.Report report, string dataSourceName) { System.Reflection.PropertyInfo[] properties = entity.GetType().GetProperties(); foreach (System.Reflection.PropertyInfo info in properties) { string name = info.Name; object value = info.GetValue(entity, null); if (report.Parameters.FindByName(name) != null) { report.SetParameterValue(name, value); } } System.Data.DataTable dt = Utility.JsonUtil.ToDataTable <H>(details); report.RegisterData(dt, dataSourceName); }
//getR12036A_Report public ActionResult getR12012_Report(string reqno) { string site = Session["T_SITE_CODE"].ToString(); string lang = Session["T_LANG"].ToString(); DataTable dt = repository.getR12012_Report(reqno, site, lang); DataTable dt_site = repository.GetSite(site); dt.TableName = "R12012"; dt_site.TableName = "R12012_site"; DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.Tables.Add(dt_site); //ds.WriteXmlSchema(Server.MapPath("~/Report/xml/R12012.xml")); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12012.frx")); webReport.Report.RegisterData(dt, "R12012"); webReport.Report.RegisterData(dt_site, "R12012_site"); var HijriDTFI = new CultureInfo("ar-SA", false).DateTimeFormat; HijriDTFI.Calendar = new HijriCalendar(); webReport.SetParameterValue("RequestDate_H", Convert.ToDateTime(dt.Rows[0]["T_REQUEST_DATE"].ToString()).ToString("dd/MM/yyyy", HijriDTFI)); webReport.Report.Prepare(); using (var Report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, Report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(Report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }
void ButtonPrintClick(object sender, EventArgs e) { FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\Stock.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = ds1.Tables[0].Copy(); table.TableName = "Stock"; FDataSet.Tables.Add(table); report1.SetParameterValue("PeriodNo", sPeriodNo); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
void ButtonPrintClick(object sender, EventArgs e) { //打印 using (FastReport.Report report1 = new FastReport.Report()) { report1.Load("Reports\\AccountList.frx"); DataSet FDataSet = BLL.AccountBillBLL.GetAllAccountBillFK(); DataTable table = new DataTable(); table = FDataSet.Tables[0]; table.TableName = "AccountBill"; report1.SetParameterValue("ListType", 1); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); } }
public override void ImprimirEnOtroFormato() { string nombreArchivo = ""; string logoEmpresa = ""; Bitmap imgLogo; double monto = 0; try { nombreArchivo = Environment.CurrentDirectory + @"\Reportes\cajaReciboOtros.frx"; monto = objUtil.GetAsDouble("Monto", DTVistaData.Rows[0]); montoLetras = Numalet.ToCardinal(monto); using (FastReport.Report report = new FastReport.Report()) { report.Load(nombreArchivo); report.RegisterData(DTVistaData, "VCAJAS_RECIBOS"); report.RegisterData(DTOficina, "VEMPRESAS_OFICINAS"); report.SetParameterValue("MONTO_LETRA", montoLetras); //Vamos a asignar el logo logoEmpresa = Environment.CurrentDirectory + @"\images\logo.png"; if (File.Exists(logoEmpresa)) { imgLogo = (Bitmap)Image.FromFile(logoEmpresa); FastReport.PictureObject ptLogo = report.FindObject("ptLogo") as FastReport.PictureObject; ptLogo.Image = imgLogo; } report.PrintSettings.ShowDialog = false; report.PrintSettings.Printer = impresoraDefault; report.Print(); } } catch (Exception) { throw; } }
private void button2_Click(object sender, EventArgs e) { Cargando.Mostrar(); var etiquetas = new List <Etiquetas>(); foreach (DataGridViewRow item in this.dgvExistencias.Rows) { int pID = Util.Entero(item.Cells["ParteID"].Value); var oParte = Datos.GetEntity <Parte>(c => c.ParteID == pID); decimal test = (decimal)item.Cells["Existencia"].Value; for (var x = 0; x < (decimal)item.Cells["Existencia"].Value; x++) { var etiqueta = new Etiquetas() { ParteID = pID, NumeroParte = oParte.NumeroParte, sParteID = oParte.ParteID.ToString("D8"), NombreParte = oParte.NombreParte, CodigoBarra = oParte.CodigoBarra, NumeroEtiquetas = Convert.ToInt32(Math.Round(test, 0)) }; etiquetas.Add(etiqueta); } } Cargando.Cerrar(); IEnumerable <Etiquetas> detalleE = etiquetas; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEtiquetas.frx")); report.RegisterData(detalleE, "etiquetas", 3); report.SetParameterValue("FolioFactura", 0); report.GetDataSource("etiquetas").Enabled = true; report.Show(true); //report.Design(true); } }
private void btnImprimirSugerido_Click(object sender, EventArgs e) { try { // if (this.dgvSugeridos.DataSource == null) return; if (this.tabPedidos.SelectedIndex != 0) return; /* DataTable t = new DataTable(); DataTable dt = new DataTable(); BindingSource bs = (BindingSource)this.dgvSugeridos.DataSource; if (string.IsNullOrEmpty(bs.Filter)) { dt = (DataTable)bs.DataSource; t = dt.AsEnumerable().Where(x => x.Field<Boolean>("Sel") && x.Field<decimal>("Pedido") > 0).CopyToDataTable(); } else { DataView dv = (DataView)bs.List; dt = dv.ToTable(); t = dt.AsEnumerable().Where(x => x.Field<Boolean>("Sel") && x.Field<decimal>("Pedido") > 0).CopyToDataTable(); } */ // Se quitan los que no estén seleccionados y los que no tengan pedido var oPartes = new List<pauPedidosSugeridos_Res>(); foreach (DataGridViewRow oFila in this.dgvSugeridos.Rows) { if (!oFila.Visible || !Util.Logico(oFila.Cells["sug_Sel"].Value) || Util.Decimal(oFila.Cells["sug_Pedido"].Value) <= 0) continue; oPartes.Add(new pauPedidosSugeridos_Res() { ParteID = Util.Entero(oFila.Cells["sug_ParteID"].Value), NumeroParte = Util.Cadena(oFila.Cells["sug_NumeroDeParte"].Value), NombreParte = Util.Cadena(oFila.Cells["sug_Descripcion"].Value), UnidadEmpaque = Util.Decimal(oFila.Cells["sug_UnidadDeEmpaque"].Value), CriterioABC = Util.Cadena(oFila.Cells["sug_AbcDeVentas"].Value), NecesidadMatriz = Util.Decimal(oFila.Cells["sug_NecesidadMatriz"].Value), NecesidadSuc02 = Util.Decimal(oFila.Cells["sug_NecesidadSuc02"].Value), NecesidadSuc03 = Util.Decimal(oFila.Cells["sug_NecesidadSuc03"].Value), Total = Util.Decimal(oFila.Cells["sug_Total"].Value), Pedido = Util.Decimal(oFila.Cells["sug_Pedido"].Value), CostoConDescuento = Util.Decimal(oFila.Cells["sug_CostoConDescuento"].Value), Costo = Util.Decimal(oFila.Cells["sug_CostoTotal"].Value), Observacion = Util.Cadena(oFila.Cells["sug_Observacion"].Value), }); } var oRep = new FastReport.Report(); oRep.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePedidosSugeridos.frx")); oRep.RegisterData(oPartes, "PartesSugeridas"); oRep.SetParameterValue("Proveedor", this.dgvProveedores.CurrentRow.Cells["pro_Proveedor"].Value); oRep.SetParameterValue("Usuario", GlobalClass.UsuarioGlobal.NombreUsuario); // oRep.GetDataSource("PartesSugeridas").Enabled = true; UtilLocal.EnviarReporteASalida("Reportes.Pedidos.Pedido", oRep); } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
/// <summary> /// 导出 /// </summary> private void btnExport_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtCompanyCode.Text)) { MessageBox.Show("请选择公司。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrEmpty(txtFilePath.Text)) { MessageBox.Show("请选择保存路径。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } BaseCompanyTable companyTable = bCompany.GetModel(txtCompanyCode.Text.Trim()); BllOrderHeaderTable orderTable = bOrderH.GetModel(_slipNumber); BaseCustomerTable customerTable = bCustomer.GetModel(orderTable.ENDER_CUSTOMER_CODE); report.Preview = previewControl1; DataTable dt = new DataTable(); dt.TableName = "ds"; dt.Columns.Add("i", System.Type.GetType("System.Decimal")); dt.Columns.Add("SPEC", System.Type.GetType("System.String")); dt.Columns.Add("QUANTITY", System.Type.GetType("System.Decimal")); dt.Columns.Add("PRICE", System.Type.GetType("System.Decimal")); dt.Columns.Add("DISCOUNT", System.Type.GetType("System.Decimal")); dt.Columns.Add("AMOUNT", System.Type.GetType("System.Decimal")); dt.Columns.Add("MATERIAL", System.Type.GetType("System.String")); dt.Columns.Add("MEMO", System.Type.GetType("System.String")); dt.Columns.Add("DESCRIPTION", System.Type.GetType("System.String")); dt.Columns.Add("DESCRIPTION1", System.Type.GetType("System.String")); int j = 1; foreach (BllOrderLineTable lineModel in orderTable.Items) { if (lineModel.PRICE_DISCOUNT.ToString().Equals("0.00")) { object[] rows = { j++, lineModel.SPEC, lineModel.QUANTITY, lineModel.PRICE, null, lineModel.AMOUNT, lineModel.METERIAL, lineModel.MEMO, lineModel.DESCRIPTION, lineModel.DESCRIPTION1 }; dt.Rows.Add(rows); } else { object[] rows = { j++, lineModel.SPEC, lineModel.QUANTITY, lineModel.PRICE, 0 - lineModel.PRICE_DISCOUNT, lineModel.AMOUNT, lineModel.METERIAL, lineModel.MEMO, lineModel.DESCRIPTION, lineModel.DESCRIPTION1 }; dt.Rows.Add(rows); } } DataSet ds = new DataSet(); ds.Tables.Add(dt); string fileName = ""; string amountName = ""; if (CConstant.LANGUAGE_CN.Equals(cboLanguage.SelectedValue)) { fileName = @"Reports\Proforma_Invoice.frx"; amountName = NumberConvert.NumberToEnglish(CConvert.ToString(orderTable.AMOUNT_INCLUDED_TAX), false); } else if (CConstant.LANGUAGE_EN.Equals(cboLanguage.SelectedValue)) { fileName = @"Reports\Order_EN.frx"; amountName = NumberConvert.NumberToEnglish(CConvert.ToString(orderTable.AMOUNT_INCLUDED_TAX), false); } try { if (File.Exists(fileName)) { report.Load(fileName); report.SetParameterValue("CompanyName", companyTable.NAME); report.SetParameterValue("EnglishCompanyName", companyTable.NAME_ENGLISH); report.SetParameterValue("CompanyTel", companyTable.PHONE_NUMBER); report.SetParameterValue("CompanyFax", companyTable.FAX_NUMBER); report.SetParameterValue("CompanyAddress", companyTable.ADDRESS_MIDDLE); report.SetParameterValue("CompanyUrl", companyTable.URL); report.SetParameterValue("CompanyEmail", companyTable.EMAIL); report.SetParameterValue("SlipNumber", _slipNumber); report.SetParameterValue("SlipDate", CConvert.ToDateTime(orderTable.SLIP_DATE).ToString("yyyy/MM/dd")); report.SetParameterValue("Currency", orderTable.CURRENCY_NAME); report.SetParameterValue("CustomerName", customerTable.NAME); int COUNT = 0; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["DISCOUNT"].ToString() != "") { COUNT++; } } if (COUNT > 0) { report.SetParameterValue("DISCOUNT", "Discount"); } if (customerTable.PHONE_NUMBER.ToString() != "") { report.SetParameterValue("CustomerTel", "Tel:" + customerTable.PHONE_NUMBER); } if (customerTable.FAX_NUMBER.ToString() != "") { report.SetParameterValue("CustomerFax", "Fax:" + customerTable.FAX_NUMBER); } if (customerTable.ADDRESS_FIRST.ToString() != "") { report.SetParameterValue("CustomerAddress", "Address:" + customerTable.ADDRESS_FIRST); } report.SetParameterValue("CustomerMessage", txtMessage.Text); report.SetParameterValue("DeliveryTerms", orderTable.DELIVERY_TERMS); report.SetParameterValue("PaymentTerms", orderTable.PAYMENT_TERMS); if (orderTable.DISCOUNT_RATE > 0) { report.SetParameterValue("DiscountRate", "-" + orderTable.DISCOUNT_RATE + "%"); report.SetParameterValue("DiscountAmount", orderTable.AMOUNT_INCLUDED_TAX); } report.SetParameterValue("AmountName", amountName); report.SetParameterValue("FullNameEn", txtBankEn.Text); report.SetParameterValue("DetailEn", rtxtDetail.Text); if (companyTable.COMPANY_PICTURE != null) { MemoryStream ms = new MemoryStream((byte[])companyTable.COMPANY_PICTURE); Image image = Image.FromStream(ms); ((FastReport.PictureObject)report.FindObject("CompanyPicture")).Image = image; } if (companyTable.LOGO != null) { MemoryStream ms1 = new MemoryStream((byte[])companyTable.LOGO); Image image1 = Image.FromStream(ms1); ((FastReport.PictureObject)report.FindObject("Logo")).Image = image1; } report.RegisterData(ds); report.Prepare(); if (fileName.Equals(@"Reports\Proforma_Invoice.frx")) { report.Export(new FastReport.Export.Pdf.PDFExport(), this.txtFilePath.Text + "\\Proforma_Invoice" + _slipNumber + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"); } else { report.Export(new FastReport.Export.Pdf.PDFExport(), this.txtFilePath.Text + "\\Order_" + _slipNumber + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"); } MessageBox.Show("导出成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { Logger.Error("", ex); } }
private void btnGetir_Click(object sender, EventArgs e) { Tutar tutar = new Tutar() { BaslangicTarihi = (deBaslangic.EditValue == null) ? (DateTime?)null : DateTime.Parse(deBaslangic.EditValue.ToString()), BitisTarihi = (deBitis.EditValue == null) ? (DateTime?)null : DateTime.Parse(deBitis.EditValue.ToString()), }; try { if (tutar.BaslangicTarihi == null || tutar.BitisTarihi == null) { MessageBoxes.Error("Boş alan"); } else { FastReport.Report rep = new FastReport.Report(); using (SqlKutuphane lib = new SqlKutuphane()) { DataSet ds1 = lib.SqlBinding_Rapor(string.Format(@"SELECT SUM(Ucret) FROM TServisIslem WHERE DelDate IS NULL AND Ucret != 0 AND GidisTarihi BETWEEN '{0}' AND '{1}'" , tutar.BaslangicTarihi.Value.ToString("yyyy-MM-dd"), tutar.BitisTarihi.Value.ToString("yyyy-MM-dd"))); rep.RegisterData(ds1, "ServisIslem"); DataSet ds2 = lib.SqlBinding_Rapor(string.Format(@"SELECT SUM(Toplam) FROM TServiseGelenCihaz WHERE DelDate IS NULL AND Toplam != 0 AND GidisTarihi BETWEEN '{0}' AND '{1}'" , tutar.BaslangicTarihi.Value.ToString("yyyy-MM-dd"), tutar.BitisTarihi.Value.ToString("yyyy-MM-dd"))); rep.RegisterData(ds2, "ServiseGelen"); DataSet ds3 = lib.SqlBinding_Rapor(string.Format(@"SELECT SUM(Toplam) FROM TServiseGelenCihaz_M WHERE DelDate IS NULL AND Toplam != 0 AND GidisTarihi BETWEEN '{0}' AND '{1}'" , tutar.BaslangicTarihi.Value.ToString("yyyy-MM-dd"), tutar.BitisTarihi.Value.ToString("yyyy-MM-dd"))); rep.RegisterData(ds3, "ServiseGelen_M"); rep.Load(dosya); rep.SetParameterValue("Baslangic", tutar.BaslangicTarihi); rep.SetParameterValue("Bitis", tutar.BitisTarihi); rep.Show(true); } } } catch (Exception ex) { MessageBoxes.Error(ex.Message); } }
private void InitCommands() { CommandBindings.Add(new CommandBinding(MyCommands.ReportNeu, (sen, erg) => { Fenster.FormAuswertungBearbeiten form = new Fenster.FormAuswertungBearbeiten(null); if (form.ShowDialog() ?? false) { string username = Helper.Benutzer; form.Auswertung.FilterAuswertung = JgMaschineData.EnumFilterAuswertung.Allgemein; form.Auswertung.ErstelltDatum = DateTime.Now; form.Auswertung.ErstelltName = username; form.Auswertung.GeaendertName = form.Auswertung.ErstelltName; form.Auswertung.GeaendertDatum = form.Auswertung.ErstelltDatum; _Auswertungen.Add(form.Auswertung); _Report.Clear(); _Report.SetParameterValue("SqlVerbindung", Properties.Settings.Default.DatenbankVerbindungsString); _Report.Design(); } })); CommandBindings.Add(new CommandBinding(MyCommands.ReportAnzeigen, ExceReportAnzeigenDruck, CanExecReportVorhandenAndNull)); CommandBindings.Add(new CommandBinding(MyCommands.ReportDrucken, ExceReportAnzeigenDruck, CanExecReportVorhandenAndNull)); CommandBindings.Add(new CommandBinding(MyCommands.ReportBearbeiten, ExceReportAnzeigenDruck, CanExecReportVorhanden)); CommandBindings.Add(new CommandBinding(MyCommands.ReportAusDateiLaden, (sen, erg) => { Microsoft.Win32.OpenFileDialog dia = new Microsoft.Win32.OpenFileDialog(); dia.Filter = "Fastreport (*.frx)|*.frx|Alle Dateien (*.*)|*.*"; dia.FilterIndex = 1; if (dia.ShowDialog() ?? false) { MemoryStream mem = new MemoryStream(); using (Stream f = File.OpenRead(dia.FileName)) { f.CopyTo(mem); } _Auswertungen.Current.Report = mem.ToArray(); _Auswertungen.DsSave(); _Auswertungen.Refresh(); } }, CanExecReportVorhanden)); CommandBindings.Add(new CommandBinding(MyCommands.ReportOptionen, (sen, erg) => { Fenster.FormAuswertungBearbeiten form = new Fenster.FormAuswertungBearbeiten(_Auswertungen.Current); if (form.ShowDialog() ?? false) { string username = System.Security.Principal.WindowsIdentity.GetCurrent().Name; form.Auswertung.GeaendertName = username; form.Auswertung.GeaendertDatum = form.Auswertung.ErstelltDatum; _Auswertungen.DsSave(); } else { _Auswertungen.Reload(); } }, CanExecReportVorhanden)); CommandBindings.Add(new CommandBinding(MyCommands.ReportInDateiSpeichern, (sen, erg) => { Microsoft.Win32.SaveFileDialog dia = new Microsoft.Win32.SaveFileDialog(); dia.Filter = "Fastreport (*.frx)|*.frx|Alle Dateien (*.*)|*.*"; dia.FilterIndex = 1; if (dia.ShowDialog() ?? false) { MemoryStream mem; mem = new MemoryStream(_Auswertungen.Current.Report); using (Stream f = File.Create(dia.FileName)) { mem.CopyTo(f); } } }, CanExecReportVorhandenAndNull)); }
private void DisplayReporteEtiquetas() { try { var movimientoEtiquetas = Datos.GetListOf<MovimientoInventarioEtiquetasView>(l => l.MovimientoInventarioID.Equals(oID)); var listaEtiquetas = new List<Etiquetas>(); var cont = 0; foreach (var etiqueta in movimientoEtiquetas) { for (var x = 0; x < etiqueta.NumeroEtiquetas; x++) { cont += 1; var e = new Etiquetas() { MovimientoInventarioEtiquetaID = cont, MovimientoInventarioID = oID, ParteID = etiqueta.ParteID, NumeroParte = etiqueta.NumeroParte, CodigoBarra = etiqueta.CodigoBarra, NumeroEtiquetas = 1, NombreParte = etiqueta.NombreParte }; listaEtiquetas.Add(e); } } // Se obtiene el folio de la factura, para mandarlo al reporte var oMov = Datos.GetEntity<MovimientoInventario>(c => c.MovimientoInventarioID == oID); IEnumerable<Etiquetas> detalleE = listaEtiquetas; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEtiquetas.frx")); report.RegisterData(detalleE, "etiquetas", 3); report.SetParameterValue("FolioFactura", oMov.FolioFactura); report.GetDataSource("etiquetas").Enabled = true; report.Show(true); //report.Design(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
private void BtnDrucken_Click(object sender, RoutedEventArgs e) { _Report.Clear(); var vorgang = Convert.ToInt32((sender as Button).Tag); // 1 - Anzeigen, 2 - Drucken, 3 - Design, 4 - Neuer Report, 5 - Report Exportieren, 6 - Löschen var auswahl = EnumFilterAuswertung.Arbeitszeit; if (tcArbeitszeit.SelectedIndex == 1) { auswahl = EnumFilterAuswertung.ArbeitszeitAuswertung; } if (vorgang != 4) { switch (auswahl) { case EnumFilterAuswertung.Arbeitszeit: _AktuellerReport = _ListeReporteArbeitszeiten.Current; break; case EnumFilterAuswertung.ArbeitszeitAuswertung: _AktuellerReport = _ListeReporteAuswertung.Current; break; } if (_AktuellerReport == null) { MessageBox.Show("Es wurde kein Report ausgewählt.", "Fehler !", MessageBoxButton.OK, MessageBoxImage.Information); return; } switch (vorgang) { case 0: // Reportname ändern var formNeu = new Fenster.FormReportName(_AktuellerReport.ReportName); if (formNeu.ShowDialog() ?? false) { _AktuellerReport.AnzeigeReportname = formNeu.ReportName; _ListeReporteArbeitszeiten.DsSave(); } return; case 5: // Exportieren SaveFileDialog dia = new SaveFileDialog() { FileName = _AktuellerReport.ReportName, Filter = "Fastreport (*.frx)|*.frx|Alle Dateien (*.*)|*.*", FilterIndex = 1 }; if (dia.ShowDialog() ?? false) { _Report.Save(dia.FileName); MemoryStream mem; mem = new MemoryStream(_AktuellerReport.Report); using (Stream f = File.Create(dia.FileName)) { mem.CopyTo(f); } } return; case 6: // Report löschen var mb = MessageBox.Show($"Report {_AktuellerReport.ReportName} löschen ?", "Löschabfrage", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.None); if (mb == MessageBoxResult.Yes) { _AktuellerReport.DatenAbgleich.Geloescht = true; switch (auswahl) { case EnumFilterAuswertung.Arbeitszeit: _ListeReporteArbeitszeiten.Remove(_AktuellerReport); break; case EnumFilterAuswertung.ArbeitszeitAuswertung: _ListeReporteAuswertung.Remove(_AktuellerReport); break; } } return; } if (_AktuellerReport.Report == null) { vorgang = 3; } else { var mem = new MemoryStream(_AktuellerReport.Report); _Report.Load(mem); } } switch (auswahl) { case EnumFilterAuswertung.Arbeitszeit: var bediener = _ListeArbeitszeitenAuswahl.Daten.Select(s => s.eBediener).Distinct().ToList(); _Report.RegisterData(bediener.Select(s => new { s.Id, s.Name }).ToList(), "Bediener"); var dat = _DzArbeitszeitBis.AnzeigeDatumZeit; var db = _ListeArbeitszeitenAuswahl.Db; var sollStunden = JgZeit.StringInZeit(db.tabSollStundenSet.FirstOrDefault(w => (w.Jahr == dat.Year) && (w.Monat == dat.Month) && !w.DatenAbgleich.Geloescht).SollStunden, TimeSpan.Zero); var lFeiertage = db.tabFeiertageSet.Where(w => (w.Datum.Year == dat.Year) && (w.Datum.Month == dat.Month) && !w.DatenAbgleich.Geloescht).ToList(); var lPausen = db.tabPausenzeitSet.Where(w => !w.DatenAbgleich.Geloescht).ToList(); var listeAuswertungen = new List <ArbeitszeitBediener>(); foreach (var bedAusw in bediener) { var ds = new ArbeitszeitBediener(_Erstellung.Db, _AzRunden); ds.BedienerBerechnen(bedAusw, (short)dat.Year, (byte)dat.Month, sollStunden, lFeiertage, lPausen); listeAuswertungen.Add(ds); } _Report.RegisterData(listeAuswertungen, "Auswertungen"); _Report.RegisterData(_ListeArbeitszeitenAuswahl.Daten, "Stechzeiten"); _Report.SetParameterValue("Zeitraum.DatumVon", _DzArbeitszeitVon.AnzeigeDatumZeit); _Report.SetParameterValue("Zeitraum.DatumBis", _DzArbeitszeitBis.AnzeigeDatumZeit); break; case EnumFilterAuswertung.ArbeitszeitAuswertung: var aktStandort = _Erstellung.AktuellerBediener.eStandort; var bedienerImStandort = _Erstellung.ListeBediener.Daten.Where(w => w.fStandort == aktStandort.Id).ToList(); var listeAuswertung = new List <ArbeitszeitBediener>(); foreach (var bedAusw in bedienerImStandort) { var ds = new ArbeitszeitBediener(_Erstellung.Db, _AzRunden); ds.BedienerBerechnen(bedAusw, _Erstellung.Jahr, _Erstellung.Monat, _Erstellung.SollStundenMonat, _Erstellung.ListeFeiertageMonat, _Erstellung.ListePausen.Daten); listeAuswertung.Add(ds); } _Report.RegisterData(bedienerImStandort.Select(s => new { s.Id, s.Name }).ToList(), "Bediener"); _Report.RegisterData(listeAuswertung, "ListeAuswertung"); _Report.SetParameterValue("Auswertung.Monat", (JgZeitHelper.JgZeit.Monate)_Erstellung.Monat); _Report.SetParameterValue("Auswertung.Jahr", _Erstellung.Jahr); break; default: break; } if (vorgang == 4) // Neuer Report { var repName = ""; var formNeu = new Fenster.FormReportName(); if (!formNeu.ShowDialog() ?? false) { return; } repName = formNeu.ReportName; string username = System.Security.Principal.WindowsIdentity.GetCurrent().Name; _AktuellerReport = new tabAuswertung() { Id = Guid.NewGuid(), FilterAuswertung = auswahl, ReportName = repName, ErstelltDatum = DateTime.Now, ErstelltName = username, GeaendertDatum = DateTime.Now, GeaendertName = username, }; switch (auswahl) { case EnumFilterAuswertung.Arbeitszeit: _ListeReporteArbeitszeiten.Add(_AktuellerReport); break; case EnumFilterAuswertung.ArbeitszeitAuswertung: _ListeReporteAuswertung.Add(_AktuellerReport); break; } _Report.Design(); } else { switch (vorgang) { case 1: try { _Report.Show(); } catch (Exception ex) { Helper.InfoBox("Fehler beim Aufruf der Auswertung", ex); } break; case 2: try { _Report.Print(); } catch (Exception ex) { Helper.InfoBox("Fehler beim Drucken der Auswertung", ex); } break; case 3: try { _Report.Design(); } catch { } break; } } }
//----以下是MP01数据采集---- private void GetParaDataPrint_MP01(int tt_itemtype) { //第一步数据准备 DataSet dst = new DataSet(); DataTable dt = new DataTable(); dst.Tables.Add(dt); dt.Columns.Add("参数"); dt.Columns.Add("名称"); dt.Columns.Add("内容"); DataRow row1 = dt.NewRow(); row1["参数"] = "S01"; row1["名称"] = "产品型号"; row1["内容"] = this.label29.Text; dt.Rows.Add(row1); DataRow row2 = dt.NewRow(); row2["参数"] = "S02"; row2["名称"] = "COMITID"; row2["内容"] = this.label61.Text; dt.Rows.Add(row2); DataRow row3 = dt.NewRow(); row3["参数"] = "S03"; row3["名称"] = "GPSN"; row3["内容"] = this.label9.Text; dt.Rows.Add(row3); DataRow row4 = dt.NewRow(); row4["参数"] = "S04"; row4["名称"] = "物料编码"; row4["内容"] = this.label49.Text; dt.Rows.Add(row4); DataRow row5 = dt.NewRow(); row5["参数"] = "S05"; row5["名称"] = "短MAC"; row5["内容"] = this.label7.Text; dt.Rows.Add(row5); DataRow row6 = dt.NewRow(); row6["参数"] = "S06"; row6["名称"] = "长MAC"; row6["内容"] = this.label8.Text; dt.Rows.Add(row6); this.dataGridView2.DataSource = null; this.dataGridView2.Rows.Clear(); this.dataGridView2.DataSource = dst.Tables[0]; this.dataGridView2.Update(); this.dataGridView2.Columns[0].Width = 60; this.dataGridView2.Columns[1].Width = 80; this.dataGridView2.Columns[2].Width = 200; //第四步 打印或预览 //单板打印 if (dst.Tables.Count > 0 && dst.Tables[0].Rows.Count > 0 && tt_itemtype > 0) { FastReport.Report report = new FastReport.Report(); report.Prepare(); report.Load(tt_path); report.SetParameterValue("S01", dst.Tables[0].Rows[0][2].ToString()); report.SetParameterValue("S02", dst.Tables[0].Rows[1][2].ToString()); report.SetParameterValue("S03", dst.Tables[0].Rows[2][2].ToString()); report.SetParameterValue("S04", dst.Tables[0].Rows[3][2].ToString()); report.SetParameterValue("S05", dst.Tables[0].Rows[4][2].ToString()); report.SetParameterValue("S06", dst.Tables[0].Rows[5][2].ToString()); report.PrintSettings.ShowDialog = false; //--打印 if (tt_itemtype == 1) { report.Print(); PutLableInfor("打印完毕"); } //--预览 if (tt_itemtype == 2) { report.Design(); PutLableInfor("预览完毕"); } setRichtexBox("99、打印或预览完毕,请检查铭牌,OK"); } else { setRichtexBox("99、获取信息失败,或不是单板扫描状态,不能打印,over"); PutLableInfor("获取信息失败,或不是单板扫描状态,不能打印"); } }
internal void PrintOrder(OrderInfo order, bool preview = false) { string fileName = Path.Combine(Environment.CurrentDirectory, "steelorder.frx"); FastReport.Report report = new FastReport.Report(); report.Load(fileName); report.SetParameterValue("orderno", order.orderno); report.SetParameterValue("orderid", order.orderid); report.SetParameterValue("customer", order.customer); report.SetParameterValue("phone", order.phone); report.SetParameterValue("addr", order.addr); report.SetParameterValue("orderdate", order.orderdate); string detailno = "0", guage = "", number = "", acreage = "", price = "", money = "", note = ""; for (int i = 1; i < 6; i++) { detailno = "detailno" + i.ToString(); guage = "guage" + i.ToString(); number = "number" + i.ToString(); acreage = "acreage" + i.ToString(); price = "price" + i.ToString(); money = "money" + i.ToString(); note = "note" + i.ToString(); if (i <= order.Detail.Count) { report.SetParameterValue(detailno, order.Detail[i - 1].XH); report.SetParameterValue(guage, order.Detail[i - 1].GG); report.SetParameterValue(number, (order.Detail[i - 1].SL.ToString())); report.SetParameterValue(acreage, (order.Detail[i - 1].MJ.ToString())); report.SetParameterValue(price, (order.Detail[i - 1].DJ.ToString())); report.SetParameterValue(money, (order.Detail[i - 1].JE.ToString())); report.SetParameterValue(note, order.Detail[i - 1].BZ); } else { report.SetParameterValue(detailno, i.ToString()); report.SetParameterValue(guage, ""); report.SetParameterValue(number, ""); report.SetParameterValue(acreage, ""); report.SetParameterValue(price, ""); report.SetParameterValue(money, ""); report.SetParameterValue(note, ""); } } report.SetParameterValue("sumnumber", (order.sumnumber.ToString())); report.SetParameterValue("sumacreage", order.sumacreage.ToString()); report.SetParameterValue("summoney", (order.summoney.ToString())); report.SetParameterValue("dxje", RMBUtils.CmycurD(Convert.ToDecimal(order.summoney))); report.SetParameterValue("operation", order.operation); report.SetParameterValue("sign", order.sign); report.SetParameterValue("lxdz", order.lxdz); report.SetParameterValue("lxdh", order.lxdh); report.SetParameterValue("bz", order.bz); report.PrintSettings.ShowDialog = false; //FastReport环境变量设置(打印时不提示 "正在准备../正在打印..",一个程序只需设定一次,故一般写在程序入口) (new FastReport.EnvironmentSettings()).ReportSettings.ShowProgress = false; if (preview) { report.Prepare(); report.ShowPrepared(); } else { report.Print(); } }
private void BtnDrucken_Click(object sender, RoutedEventArgs e) { var vorgang = Convert.ToInt32((sender as Button).Tag); // 1 - Anzeigen, 2 - Drucken, 3 - Design, 4 - Neuer Report, 5 - Report Exportieren, 6 - Löschen if (vorgang != 4) { switch (_Auswahl) { case EnumFilterAuswertung.Anmeldung: _AktAuswertung = (tabAuswertung)_ListeReporteAnmeldung.Current; break; case EnumFilterAuswertung.Bauteil: _AktAuswertung = (tabAuswertung)_ListeReporteBauteil.Current; break; case EnumFilterAuswertung.Reparatur: _AktAuswertung = (tabAuswertung)_ListeReporteReparatur.Current; break; } if (_AktAuswertung == null) { MessageBox.Show("Es wurde kein Report ausgewählt.", "Fehler !", MessageBoxButton.OK, MessageBoxImage.Information); return; } switch (vorgang) { case 5: // Exportieren SaveFileDialog dia = new SaveFileDialog() { Filter = "Fastreport (*.frx)|*.frx|Alle Dateien (*.*)|*.*", FilterIndex = 1 }; if (dia.ShowDialog() ?? false) { _Report.Save(dia.FileName); MemoryStream mem; mem = new MemoryStream(_AktAuswertung.Report); using (Stream f = File.Create(dia.FileName)) { mem.CopyTo(f); } } return; case 6: // Report löschen var mb = MessageBox.Show($"Report {_AktAuswertung.ReportName} löschen ?", "Löschabfrage", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.None); if (mb == MessageBoxResult.Yes) { switch (_Auswahl) { case EnumFilterAuswertung.Anmeldung: _ListeReporteAnmeldung.Delete(_AktAuswertung); break; case EnumFilterAuswertung.Bauteil: _ListeReporteBauteil.Delete(_AktAuswertung); break; case EnumFilterAuswertung.Reparatur: _ListeReporteReparatur.Delete(_AktAuswertung); break; } } return; } _Report.Clear(); if (_AktAuswertung.Report == null) { vorgang = 3; } else { var mem = new MemoryStream(_AktAuswertung.Report); _Report.Load(mem); } } switch (_Auswahl) { case JgMaschineData.EnumFilterAuswertung.Anmeldung: if (tcAnmeldung.SelectedIndex == 0) { _Report.RegisterData(_ListeAnmeldungen.Daten, "Daten"); } else { _Report.RegisterData(_ListeAnmeldungAuswahl.Daten, "Daten"); _Report.SetParameterValue("DatumVon", _DzAnmeldungVon.AnzeigeDatumZeit); _Report.SetParameterValue("DatumBis", _DzAnmeldungBis.AnzeigeDatumZeit); } _Report.SetParameterValue("IstAktuell", tcAnmeldung.SelectedIndex == 0); break; case EnumFilterAuswertung.Bauteil: if (_Maschine == null) { MessageBox.Show("Wählen Sie eine Maschine aus."); return; } _Report.RegisterData(_ListeBauteilAuswahl.Daten, "Daten"); _Report.SetParameterValue("MaschinenName", _Maschine.MaschinenName); _Report.SetParameterValue("DatumVon", _DzBauteilVon.AnzeigeDatumZeit); _Report.SetParameterValue("DatumBis", _DzBauteilBis.AnzeigeDatumZeit); break; case EnumFilterAuswertung.Reparatur: if (tcReparatur.SelectedIndex == 0) { _Report.RegisterData(_ListeReparaturen.Daten, "Daten"); } else { _Report.RegisterData(_ListeReparaturAuswahl.Daten, "Daten"); _Report.SetParameterValue("DatumVon", _DzReparaturVon.AnzeigeDatumZeit); _Report.SetParameterValue("DatumBis", _DzReparaturBis.AnzeigeDatumZeit); } _Report.SetParameterValue("IstAktuell", tcReparatur.SelectedIndex == 0); break; default: break; } if (vorgang == 4) // Neuer Report { var repName = ""; var formNeu = new Fenster.FormNeuerReport(); if (!formNeu.ShowDialog() ?? false) { return; } repName = formNeu.ReportName; string username = System.Security.Principal.WindowsIdentity.GetCurrent().Name; _AktAuswertung = new tabAuswertung() { Id = Guid.NewGuid(), FilterAuswertung = _Auswahl, ReportName = repName, ErstelltDatum = DateTime.Now, ErstelltName = username, GeaendertDatum = DateTime.Now, GeaendertName = username }; switch (_Auswahl) { case EnumFilterAuswertung.Anmeldung: _ListeReporteAnmeldung.Add(_AktAuswertung); break; case EnumFilterAuswertung.Bauteil: _ListeReporteBauteil.Add(_AktAuswertung); break; case EnumFilterAuswertung.Reparatur: _ListeReporteReparatur.Add(_AktAuswertung); break; } _Report.Design(); } else { switch (vorgang) { case 1: _Report.Show(); break; case 2: _Report.Print(); break; case 3: _Report.Design(); break; } } }