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;
}
}
}
