void PrintSFD(int i_CFID) { DataSet tmpDs = BLL.ChargeBLL.GetSFDs(i_CFID); // FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\SFPrint.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = tmpDs.Tables[0].Copy(); table.TableName = "ChargeF"; FDataSet.Tables.Add(table); tmpDs = BLL.ChargeBLL.GetSFChargeDetail(i_CFID); table = tmpDs.Tables[0].Copy(); table.TableName = "ChargeDetail"; FDataSet.Tables.Add(table); DataRelation dr = new DataRelation("FK_1", FDataSet.Tables["ChargeF"].Columns["CFID"], FDataSet.Tables["ChargeDetail"].Columns["CFID"]); FDataSet.Relations.Add(dr); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
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(); }
void 入库统计ToolStripMenuItemClick(object sender, EventArgs e) { //打印非零库存 FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\IncomeSum.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.ReceiptBLL.GetAllReceiptItems().Tables[0].Copy(); table.TableName = "ReceiptItems"; FDataSet.Tables.Add(table); //report1.SetParameterValue("PeriodNo",sPeriodNo); DataRelation dsdr = new DataRelation("R1", FDataSet.Tables["GoodsType"].Columns["GoodsTypeID"], FDataSet.Tables["ReceiptItems"].Columns["GoodsTypeID"]); FDataSet.Relations.Add(dsdr); CalculateTotal(ref FDataSet); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
private void button1_Click(object sender, EventArgs e) { report1 = new FastReport.Report(); report1.Load(Path.Combine(@"AltAltaVeriYazma.frx")); var kisi = new Kisi(); var kisiList = kisi.getKisiList(); foreach (var data in kisiList) { var rowadaparsel = dataSet1.Tables["Kisi"].NewRow(); rowadaparsel["No"] = data.No; rowadaparsel["Ad"] = data.Ad; rowadaparsel["Soyad"] = data.Soyad; rowadaparsel["TC"] = data.TC; dataSet1.Tables["Kisi"].Rows.Add(rowadaparsel); } report1.RegisterData(dataSet1.Tables["Kisi"], "Kisi"); report1.GetDataSource("Kisi").Enabled = true; (report1.Report.FindObject("Data1") as FastReport.DataBand).DataSource = report1.GetDataSource("Kisi"); report1.Show(); }
private void ExceReportAnzeigenDruck(object sender, ExecutedRoutedEventArgs e) { _Report.Clear(); var dsRep = _Auswertungen.Current; if (dsRep.Report != null) { MemoryStream mem; mem = new MemoryStream(dsRep.Report); _Report.Load(mem); } _Report.SetParameterValue("SqlVerbindung", Properties.Settings.Default.DatenbankVerbindungsString); if (e.Command == MyCommands.ReportAnzeigen) { _Report.Show(); } else if (e.Command == Commands.MyCommands.ReportDrucken) { _Report.Print(); } else if (e.Command == Commands.MyCommands.ReportBearbeiten) { _Report.Design(); } }
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(); }
private void DisplayReporteTraspaso() { try { var movimiento = Datos.GetListOf <MovimientoInventarioView>(m => m.MovimientoInventarioID.Equals(oID)); var detalle = Datos.GetListOf <MovimientoInventarioDetalleView>(d => d.MovimientoInventarioID.Equals(oID)); IEnumerable <MovimientoInventarioView> movimientoE = movimiento; IEnumerable <MovimientoInventarioDetalleView> detalleE = detalle; using (FastReport.Report report = new FastReport.Report()) { if (detalle.Count < 10) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspaso.frx")); } else { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspasosMasDeDiez.frx")); } report.RegisterData(movimientoE, "movimiento", 3); report.RegisterData(detalleE, "detalle", 3); report.GetDataSource("movimiento").Enabled = true; report.GetDataSource("detalle").Enabled = true; report.Show(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
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(); }
private void toolPrint_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(taskid)) { DataSet ds = new DataSet(); DataTable dtPrint = new SqlServerHelper().GetDataTable("View_GroupInfo", "taskid='" + taskid + "'", ""); dtPrint.TableName = "用户报装申请表"; ds.Tables.Add(dtPrint.Copy()); FastReport.Report report1 = new FastReport.Report(); try { // load the existing report report1.Load(Application.StartupPath + @"\PRINTModel\业扩模板\多用户报装申请表.frx"); // register the dataset report1.RegisterData(ds); report1.GetDataSource("用户报装申请表").Enabled = true; // run the report report1.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { // free resources used by report report1.Dispose(); } } }
private void btnImprimir_Click(object sender, EventArgs e) { try { if (this.dgvDatos.DataSource == null) { return; } BindingSource bs = (BindingSource)this.dgvDatos.DataSource; DataTable dt = (DataTable)bs.DataSource; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePartesClasificacionAbc.frx")); report.RegisterData(dt, "PartesClasificacionAbc"); report.GetDataSource("PartesClasificacionAbc").Enabled = true; report.Show(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
//Print private void button1_Click(object sender, EventArgs e) { errorProvider1.Clear( ); int number = 0; bool isOk = true; if (int.TryParse(textBox1.Text, out number) == false) { errorProvider1.SetError(textBox1, "请输入正确的打印数量"); isOk = false; } if (texProduct.Tag == null) { errorProvider1.SetError(texProduct, "品号不可为空"); isOk = false; } if (string.IsNullOrEmpty(texProduct.Text)) { errorProvider1.SetError(texProduct, "品名不可为空"); isOk = false; } if (string.IsNullOrEmpty(texSpec.Text)) { errorProvider1.SetError(texSpec, "规格不可为空"); isOk = false; } if (string.IsNullOrEmpty(textBox3.Text)) { errorProvider1.SetError(textBox3, "型号不可为空"); isOk = false; } if (string.IsNullOrEmpty(comboBox1.Text)) { errorProvider1.SetError(comboBox1, "轴号不可为空"); isOk = false; } if (isOk == false) { return; } numOf( ); if (Save( ) == false) { return; } RDataSet = new DataSet( ); getDataTable( ); FastReport.Report report = new FastReport.Report( ); string path = ""; path = Application.StartupPath; //if ( string . IsNullOrEmpty ( texPack . Text ) ) report.Load(path + "\\PrintBarCode.frx"); //else //report . Load ( path + "\\PrintBarCodeA.frx" ); report.RegisterData(RDataSet); report.Show( ); }
private void btn_storage_Click(object sender, EventArgs e) { try { FastReport.Report report1 = new FastReport.Report(); report1.Load("2.frx"); DataTable dt = new DataTable(); DataSet ds = new DataSet(); dt.Columns.Add("物品名"); dt.Columns.Add("物品数量"); dt.Columns.Add("物品代码"); dt.Columns.Add("物品备注"); dt.Columns.Add("物品价格"); dt.Columns.Add("物品类型"); dt.Columns.Add("物品体积"); dt.Columns.Add("物品重量"); dt.Columns.Add("仓库名称"); dt.Columns.Add("客户名称"); dt.Columns.Add("物品规格"); dt.Columns.Add("入库方式"); dt.Columns.Add("生产日期"); dt.Columns.Add("到期日期"); dt.Columns.Add("批号"); dt.Columns.Add("清单备注"); dt.Columns.Add("操作人员"); dt.Rows.Add(); dt.Rows[0][0] = gm.Goods_name; dt.Rows[0][1] = bm.Goods_amount; dt.Rows[0][2] = gm.Goods_code; dt.Rows[0][3] = gm.Goods_note; dt.Rows[0][4] = bm.Goods_price; dt.Rows[0][5] = gtm.Goods_type; dt.Rows[0][6] = gm.Goods_volume; dt.Rows[0][7] = gm.Goods_wight; dt.Rows[0][8] = wnm.Warehouse_name; dt.Rows[0][9] = cm.Client_name; dt.Rows[0][10] = gm.Specifications; dt.Rows[0][11] = otm.Operation_type; dt.Rows[0][12] = bm.Expiration_date; dt.Rows[0][13] = bm.Manufacture_date; dt.Rows[0][14] = bm.Lot_number; dt.Rows[0][15] = bm.Bill_note; dt.Rows[0][16] = mm.Manager_name; ds.Tables.Add(dt); dt.TableName = "putreport"; report1.RegisterData(ds); report1.GetDataSource("putreport").Enabled = true; report1.Show(); //report1.Design(); //report1.Prepare(); //report1.ShowPrepared(); } catch (Exception ex) { MessageBox.Show(ex.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 }
private void hotSpot1_Click(object sender, EventArgs e) { if (File.Exists(txtREPORTFILE.Text) && (txtREPORTFILE.Text.Length > 0)) { FastReport.Report rpt = new FastReport.Report(); rpt.Load(txtREPORTFILE.Text); rpt.AutoFillDataSet = false; rpt.Dictionary.Connections[0].ConnectionString = string.Format(@"XSDFile={1};XmlFile={0}", txtXMLDataFile.Text, txtXSDSchemaFile.Text); rpt.AutoFillDataSet = true; rpt.Show(); } }
void ButtonPrintClick(object sender, EventArgs e) { string s_CFIDs = ""; foreach (DataGridViewRow drs in dataGridView1.SelectedRows) { s_CFIDs += drs.Cells["CFID"].Value.ToString(); s_CFIDs += ","; } if (s_CFIDs != "") { s_CFIDs = s_CFIDs.Substring(0, s_CFIDs.Length - 1); s_CFIDs = "(" + s_CFIDs + ")"; } else { s_CFIDs = "(0)"; } DataSet tmpDs = BLL.ChargeBLL.GetSFDs(s_CFIDs); // FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\SFPrint.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = tmpDs.Tables[0].Copy(); table.TableName = "ChargeF"; FDataSet.Tables.Add(table); tmpDs = BLL.ChargeBLL.GetSFChargeDetail(s_CFIDs); if (ds2.Tables.Count == 0) { return; } table = tmpDs.Tables[0].Copy(); table.TableName = "ChargeDetail"; FDataSet.Tables.Add(table); DataRelation dr = new DataRelation("FK_1", FDataSet.Tables["ChargeF"].Columns["CFID"], FDataSet.Tables["ChargeDetail"].Columns["CFID"]); FDataSet.Relations.Add(dr); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
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); } }
//导出到Excel void OutPutExcel(DataGridView dgv, string name) { FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\GoodsList1.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = ds1.Tables[0].Copy(); table.TableName = "Goods"; FDataSet.Tables.Add(table); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
void ButtonPrintClick(object sender, EventArgs e) { if (dataGridView1.CurrentRow == null) { return; } DataSet tmpDs = new DataSet(); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); int i_CompanyID = Convert.ToInt32(comboBoxProjectCompany.SelectedValue); int i_ProjectID = Convert.ToInt32(comboBoxProject.SelectedValue); string s_StatementCycle = dataGridView1.CurrentRow.Cells["StatementCycle"].Value.ToString();; LeaseHT tLeaseHT = BLL.LeaseBLL.GetLeaseHT(i_ProjectID, i_CompanyID); tmpDs = BLL.LeaseBLL.GetLeaseAccountDs(i_ProjectID, i_CompanyID, s_StatementCycle); table = tmpDs.Tables[0].Copy(); table.TableName = "LeaseAccount"; FDataSet.Tables.Add(table); int i_BillID = 0; foreach (DataRow drtmp in table.Rows) { i_BillID = Convert.ToInt32(drtmp["BillID"]); } tmpDs = BLL.LeaseBLL.GetLeaseAccountList(i_BillID); table = tmpDs.Tables[0].Copy(); table.TableName = "LeaseAccountList"; FDataSet.Tables.Add(table); tmpDs = BLL.LeaseBLL.GetLeaseAccountList(0, i_BillID); table = tmpDs.Tables[0].Copy(); table.TableName = "LeaseAccountLeft"; FDataSet.Tables.Add(table); //将需要结算的数据填写到报表中的表中 FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\LeaseHisJS.frx"); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
/// <summary> /// 打印预览 /// </summary> /// <param name="dic">打印数据</param> public void DetailPreview(Dictionary <string, DataTable> dic) { if (dic == null) { return; } FastReport.Report report = GetDetailReport(dic); if (report == null) { return; } report.Prepare(); report.Show(); report.Dispose(); dic = null; }
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(); } }
private void toolPrintPreview_Click(object sender, EventArgs e) { #region FastReport.Report report1 = new FastReport.Report(); try { // load the existing report report1.Load(Application.StartupPath + @"\PRINTModel\收据模板\日结明细单模板.frx"); (report1.FindObject("txtYSCOUNT") as FastReport.TextObject).Text = "发票数量:" + intYSCount + "张,收据数量:" + intYSRECEIPRNOCOUNT.ToString() + "张"; (report1.FindObject("txtYSSF") as FastReport.TextObject).Text = "应收水费:" + decBCYS.ToString("F2") + "元"; (report1.FindObject("txtSSSF") as FastReport.TextObject).Text = "实收金额:" + decYSBCSS.ToString("F2") + "元"; (report1.FindObject("txtSSSFXJ") as FastReport.TextObject).Text = "现金:" + decYSBCSSXJ.ToString("F2") + "元"; (report1.FindObject("txtSSSFPOS") as FastReport.TextObject).Text = "POS机:" + decYSBCSSPOS.ToString("F2") + "元"; (report1.FindObject("txtSSSFZHUANZHANG") as FastReport.TextObject).Text = "转账汇款:" + decYSBCSSZHUANZHANG.ToString("F2") + "元"; (report1.FindObject("txtYEZJ") as FastReport.TextObject).Text = "余额增减:" + decYSBCSZ.ToString("F2") + "元"; (report1.FindObject("txtYCCount") as FastReport.TextObject).Text = "收据数量:" + intYCCount + "张"; (report1.FindObject("txtQQYE") as FastReport.TextObject).Text = "前期余额:" + decYCQQYE.ToString("F2") + "元"; (report1.FindObject("txtYCSF") as FastReport.TextObject).Text = "预存收费:" + decYCBCSZ.ToString("F2") + "元"; (report1.FindObject("txtYCSFXJ") as FastReport.TextObject).Text = "现金:" + decYCBCSZXJ.ToString("F2") + "元"; (report1.FindObject("txtYCSFPOS") as FastReport.TextObject).Text = "POS机:" + decYCBCSZPOS.ToString("F2") + "元"; (report1.FindObject("txtYCSFZHUANZHANG") as FastReport.TextObject).Text = "转账汇款:" + decYCBCSZZHUANZHANG.ToString("F2") + "元"; (report1.FindObject("txtJSYE") as FastReport.TextObject).Text = "结算余额::" + decYCJSYE.ToString("F2") + "元"; (report1.FindObject("txtJEZJ") as FastReport.TextObject).Text = "金额总计: " + labBCSS.Text; (report1.FindObject("txtDateTime") as FastReport.TextObject).Text = "统计时间:" + dtpStartSearch.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 至 " + dtpEndSearch.Value.ToString("yyyy-MM-dd HH:mm:ss"); (report1.FindObject("txtWorkerName") as FastReport.TextObject).Text = "收 费 员:" + txtWorkerNameSearch.Text; report1.Show(); } catch (Exception exx) { MessageBox.Show(exx.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { // free resources used by report report1.Dispose(); } #endregion }
public static void PrintCredit(CreditViewModel model, ServiceClient repository) { ReportDataSet dsRep = new ReportDataSet(); ReportDataSet.CreditDTRow dsCreditDtRowRow = dsRep.CreditDT.NewCreditDTRow(); dsCreditDtRowRow.Fio = model.UserName; dsCreditDtRowRow.Data = model.DataStart; dsCreditDtRowRow.SummaFull = model.SummaFull.ToString(); dsCreditDtRowRow.Stavka = model.Stavka.ToString(); dsCreditDtRowRow.TermMonth = model.TermMonth.ToString(); dsCreditDtRowRow.IdCredit = model.Id.ToString(); dsRep.CreditDT.Rows.Add(dsCreditDtRowRow); List <Payment> payments = repository.GetPaymentsByIdCredit(model.Id).ToList(); foreach (var item in payments) { ReportDataSet.PaymentDTRow dsPaymentDtRow = dsRep.PaymentDT.NewPaymentDTRow(); dsPaymentDtRow.IdCredit = model.Id.ToString(); dsPaymentDtRow.NumberMonth = item.NumberMonth.ToString(); dsPaymentDtRow.Data = item.Data; dsPaymentDtRow.LostSumma = item.LostSumma.ToString(); dsPaymentDtRow.MainPay = item.MainPay.ToString(); dsPaymentDtRow.Percent = item.Percent.ToString(); dsPaymentDtRow.SummaMonth = item.SummaMonth.ToString(); dsRep.PaymentDT.Rows.Add(dsPaymentDtRow); } using (FastReport.Report report = new FastReport.Report()) { report.StoreInResources = true; report.Load("Report\\CreditReport.frx"); report.RegisterData((DataTable)dsRep.CreditDT, "CreditInfoList"); report.GetDataSource("CreditInfoList").Enabled = true; report.RegisterData((DataTable)dsRep.PaymentDT, "PaymentList"); report.GetDataSource("PaymentList").Enabled = true; //report.Design(); report.Show(); } }
void ButtonJSPreviewClick(object sender, EventArgs e) { if (CheckFillOK()) { DataSet tmpDs = new DataSet(); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); int i_ProjectID; int i_CompanyID; i_ProjectID = Convert.ToInt32(comboBoxProject.SelectedValue.ToString()); i_CompanyID = Convert.ToInt32(comboBoxCompany.SelectedValue.ToString()); LeaseHT tLeaseHT = BLL.LeaseBLL.GetLeaseHT(i_ProjectID, i_CompanyID); tmpDs = BLL.LeaseBLL.GetLeaseAccountDs(0); //随便取数据,用空结构填充 table = tmpDs.Tables[0].Clone(); table.TableName = "LeaseAccount"; FDataSet.Tables.Add(table); tmpDs = BLL.LeaseBLL.GetLeaseAccountList(0); table = tmpDs.Tables[0].Clone(); table.TableName = "LeaseAccountList"; FDataSet.Tables.Add(table); tmpDs = BLL.LeaseBLL.GetLeaseAccountLeft(0); table = tmpDs.Tables[0].Clone(); table.TableName = "LeaseAccountLeft"; FDataSet.Tables.Add(table); //将需要结算的数据填写到报表中的表中 FillReportData(FDataSet); FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\LeaseJS.frx"); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { string sql = "select * from fastReportForPrint where frxName='frxa.frx'"; DataSet dsa = getDataSet(sql); DataSet FDataSet = new DataSet(); if (dsa.Tables[0].Rows.Count > 0) { sql = dsa.Tables[0].Rows[0]["sqlStr"].ToString() + " where id=1"; FDataSet = getDataSet(sql); FastReport.Report report1 = new FastReport.Report(); try { // load the existing report report1.Load(dsa.Tables[0].Rows[0]["frxName"].ToString()); // register the dataset report1.RegisterData(FDataSet); report1.GetDataSource(dsa.Tables[0].Rows[0]["fromTable"].ToString()).Enabled = true; // run the report report1.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { // free resources used by report report1.Dispose(); } } //DataTable table = new DataTable(); //table.TableName = "S_User"; //FDataSet.Tables.Add(table); //table.Columns.Add("Name", typeof(string)); //table.Columns.Add("Pwd", typeof(string)); //table.Rows.Add("管理员", "19A2854144B63A8F7617A6F225019B12"); //table.Rows.Add("超级管理员", "EBEC10142B9FC9E4E67B0CFD347E23E6"); }
void ButtonPrintJFClick(object sender, EventArgs e) { DataSet tmpDs = BLL.ChargeBLL.GetJFDs(); // FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\JFPrint.frx"); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); table = tmpDs.Tables[0].Copy(); table.TableName = "Charge"; FDataSet.Tables.Add(table); tmpDs = BLL.ChargeBLL.GetCanSFAll(textBoxPeriodNo.Text); table = tmpDs.Tables[0].Copy(); table.TableName = "ChargeDetail"; FDataSet.Tables.Add(table); DataRelation dr = new DataRelation("FK_1", FDataSet.Tables["Charge"].Columns["CID"], FDataSet.Tables["ChargeDetail"].Columns["CID"]); FDataSet.Relations.Add(dr); tmpDs = BLL.CustomersBLL.GetAllCustomers(); table = tmpDs.Tables[0].Copy(); table.TableName = "Customers"; FDataSet.Tables.Add(table); tmpDs = BLL.WyInfosBLL.GetAllWyInfos(); table = tmpDs.Tables[0].Copy(); table.TableName = "WyInfos"; FDataSet.Tables.Add(table); dr = new DataRelation("FK_2", FDataSet.Tables["Customers"].Columns["CustomerID"], FDataSet.Tables["Wyinfos"].Columns["CustomerID"]); FDataSet.Relations.Add(dr); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
/// <summary> /// 入库单生成报表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_print_Click(object sender, EventArgs e) { try { FastReport.Report report1 = new FastReport.Report(); report1.Load("1.frx"); DataTable tb = new DataTable(); tb = ds.Tables[0]; tb.TableName = "putreport"; ds.Tables.Clear(); ds.Tables.Add(tb); report1.RegisterData(ds); report1.GetDataSource("putreport").Enabled = true; report1.Show(); //report1.Design(); //report1.Prepare(); //report1.ShowPrepared(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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); } }
void ButtonPrtRKDClick(object sender, EventArgs e) { //打印入库单 FastReport.Report report1 = new FastReport.Report(); report1.Load("Reports\\RKD.frx"); int i_ReceiptID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["ReceiptID"].Value.ToString()); DataSet FDataSet = new DataSet(); DataTable table = new DataTable(); DataSet ds1 = BLL.RKBLL.GetReceipt1(i_ReceiptID); table = ds1.Tables[0].Copy(); table.TableName = "Receipt"; FDataSet.Tables.Add(table); ds1 = BLL.RKBLL.GetReceiptItems(i_ReceiptID); table = ds1.Tables[0].Copy(); table.TableName = "ReceiptItems"; FDataSet.Tables.Add(table); report1.RegisterData(FDataSet); report1.Show(); report1.Dispose(); }
private void toolPrintPreview_Click(object sender, EventArgs e) { if (dtList.Rows.Count == 0) { toolPrint.Enabled = false; toolPrintPreview.Enabled = false; return; } DataSet ds = new DataSet(); DataTable dtRecordTemp = dtList.Clone(); dtRecordTemp.Columns["收费月份"].DataType = typeof(string); foreach (DataRow dr in dtList.Rows) { dtRecordTemp.ImportRow(dr); } for (int i = 0; i < dtRecordTemp.Rows.Count; i++) { object obj = dtRecordTemp.Rows[i]["收费月份"]; if (Information.IsDate(obj)) { dtRecordTemp.Rows[i]["收费月份"] = Convert.ToDateTime(obj).ToString("yyyy-MM"); } //object objWaterMeterNO = dtRecord.Rows[i]["waterMeterNo"]; //if (objWaterMeterNO != null && objWaterMeterNO != DBNull.Value) // if (objWaterMeterNO.ToString().Length > 7) // dtRecord.Rows[i]["waterMeterNo"] = objWaterMeterNO.ToString().Substring(6, 2); } dtRecordTemp.ImportRow(dtSum.Rows[0]); DataTable dtPrint = dtRecordTemp.Copy(); dtPrint.TableName = "一户式查询模板"; string strWaterUserID = "", strWaterUserName = "", strAddress = ""; object objWaterUser = dtList.Rows[0]["用户编号"]; if (objWaterUser != null && objWaterUser != DBNull.Value) { strWaterUserID = objWaterUser.ToString(); } objWaterUser = dtList.Rows[0]["用户名称"]; if (objWaterUser != null && objWaterUser != DBNull.Value) { strWaterUserName = objWaterUser.ToString(); } objWaterUser = dtList.Rows[0]["地址"]; if (objWaterUser != null && objWaterUser != DBNull.Value) { strAddress = objWaterUser.ToString(); } ds.Tables.Add(dtPrint); FastReport.Report report1 = new FastReport.Report(); try { // load the existing report report1.Load(Application.StartupPath + @"\PRINTModel\收据模板\一户式查询模板.frx"); (report1.FindObject("txtWaterUser") as FastReport.TextObject).Text = "用户编号:" + strWaterUserID + " 用户名称:" + strWaterUserName; (report1.FindObject("txtWaterUserAddress") as FastReport.TextObject).Text = "地 址:" + strAddress; // register the dataset report1.RegisterData(ds); report1.GetDataSource("一户式查询模板").Enabled = true; // run the report report1.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { // free resources used by report report1.Dispose(); } }
private void btnProcesar_Click(object sender, EventArgs e) { try { this.tabPedidos.SelectedIndex = 0; ; if (this.dgvProveedores.CurrentRow == null) { Util.MensajeError("Debe seleccionar a un Proveedor.", GlobalClass.NombreApp); return; } // Se valida que haya al menos una parte seleccionada bool bError = true; foreach (DataGridViewRow oFila in this.dgvSugeridos.Rows) { if (Util.Logico(oFila.Cells["sug_Sel"].Value)) { bError = false; break; } } // if (this.dgvSugeridos.DataSource == null) if (bError) { Util.MensajeError("Debe seleccionar al menos un número de parte.", GlobalClass.NombreApp); return; } var proveedorId = Util.Entero(this.dgvProveedores.CurrentRow.Cells["pro_ProveedorID"].Value); var proveedor = Datos.GetEntity<Proveedor>(p => p.ProveedorID == proveedorId); if (proveedor != null) { var msj = string.Format("{0} {1} {2}", "¿Está seguro de que la información del Pedido es correcta?", "Para el Proveedor:", proveedor.NombreProveedor); var res = Util.MensajePregunta(msj, GlobalClass.NombreApp); if (res == DialogResult.No) return; } else { Util.MensajeError("Proveedor Inválido.", GlobalClass.NombreApp); return; } this.Cursor = Cursors.WaitCursor; SplashScreen.Show(new Splash()); this.btnProcesar.Enabled = false; var pedido = new Pedido() { ProveedorID = proveedorId, ImporteTotal = Util.Decimal(this.txtImporteTotal.Text.SoloNumeric()), PedidoEstatusID = 2 }; Datos.Guardar<Pedido>(pedido); if (pedido.PedidoID <= 0) { this.Cursor = Cursors.Default; SplashScreen.Close(); Util.MensajeError("Ocurrio un error al guardar el Pedido.", GlobalClass.NombreApp); this.btnProcesar.Enabled = true; return; } // DataTable dt = new DataTable(); // BindingSource bs = (BindingSource)this.dgvSugeridos.DataSource; //Validación, debe estar seleccionado y el pedido debe ser mayor a 0 /* if (!string.IsNullOrEmpty(bs.Filter)) { DataView dv = (DataView)bs.List; dt = dv.ToTable().AsEnumerable().Where(x => x.Field<Boolean>("Sel") && x.Field<decimal>("Pedido") > 0).CopyToDataTable(); } */ foreach (DataGridViewRow oFila in this.dgvSugeridos.Rows) { if (!oFila.Visible) continue; int iParteID = Util.Entero(oFila.Cells["sug_ParteID"].Value); // Se verifica si no se debe pedir por existencia en equivalentes var oNoPedir = Datos.GetEntity<ParteCaracteristicaTemporal>(c => c.ParteID == iParteID && c.Caracteristica == Cat.CaracTempPartes.NoPedidosPorEquivalentes); if (Util.Cadena(oFila.Cells["sug_Caracteristica"].Value) == "NP") { if (oNoPedir == null) { oNoPedir = new ParteCaracteristicaTemporal() { ParteID = iParteID, Caracteristica = Cat.CaracTempPartes.NoPedidosPorEquivalentes }; Datos.Guardar<ParteCaracteristicaTemporal>(oNoPedir); } } else { if (oNoPedir != null) Datos.Eliminar<ParteCaracteristicaTemporal>(oNoPedir); } // Se verifica si está marcado o tiene pedidos para procesar, si no, se salta if (!Util.Logico(oFila.Cells["sug_Sel"].Value) || Util.Decimal(oFila.Cells["sug_Pedido"].Value) <= 0) continue; if (Util.Entero(oFila.Cells["sug_ProveedorID"].Value) != proveedorId) { this.Cursor = Cursors.Default; SplashScreen.Close(); var msj = string.Format("{0} {1} {2} {3}", "El número de Parte:", Util.Cadena(oFila.Cells["sug_NumeroDeParte"].Value) , "No está asignado al Proveedor:", proveedor.NombreProveedor); Util.MensajeError(msj, GlobalClass.NombreApp); this.btnProcesar.Enabled = true; return; } // var detallePedido = new PedidoDetalle() { PedidoID = pedido.PedidoID, ParteID = iParteID, CantidadPedido = Util.Decimal(oFila.Cells["sug_Pedido"].Value), CostosUnitario = Util.Decimal(oFila.Cells["sug_CostoConDescuento"].Value), PedidoEstatusID = 2 }; Datos.Guardar<PedidoDetalle>(detallePedido); // Se marca como pedido si es 9500 if (Util.Cadena(oFila.Cells["sug_Caracteristica"].Value) == "9500") { var o9500 = Datos.GetListOf<Cotizacion9500Detalle>(c => c.ParteID == iParteID && !c.Pedido && c.Estatus); foreach (var oReg in o9500) { oReg.Pedido = true; Datos.Guardar<Cotizacion9500Detalle>(oReg); } } // Se marca como pedido en reporte de faltante, si aplica if (Util.Cadena(oFila.Cells["sug_Caracteristica"].Value) == "RF") { var oFaltantes = Datos.GetListOf<ReporteDeFaltante>(c => c.ParteID == iParteID && !c.Pedido && c.Estatus); foreach (var oReg in oFaltantes) { oReg.Pedido = true; Datos.Guardar<ReporteDeFaltante>(oReg); } } } var ped = Datos.GetListOf<PedidosView>(p => p.PedidoID.Equals(pedido.PedidoID)); var detalle = Datos.GetListOf<PedidosDetalleView>(p => p.PedidoID.Equals(pedido.PedidoID)); IEnumerable<PedidosView> pedidoE = ped; IEnumerable<PedidosDetalleView> detalleE = detalle; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePedidos.frx")); report.RegisterData(pedidoE, "Pedido"); report.GetDataSource("Pedido").Enabled = true; report.RegisterData(detalleE, "DetallePedido"); report.GetDataSource("DetallePedido").Enabled = true; report.Show(true); } this.Cursor = Cursors.Default; this.LimpiarFormularioDos(); SplashScreen.Close(); this.btnProcesar.Enabled = true; new Notificacion("Pedido Guardado exitosamente", 2 * 1000).Mostrar(Principal.Instance); } catch (Exception ex) { this.Cursor = Cursors.Default; SplashScreen.Close(); this.btnProcesar.Enabled = true; Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
public static void getReport(string SQL, string AliasName, string FolderName, string FileName) { FastReport.Report report = new FastReport.Report(); try { if (Function.FTPDownload(@"C:\Report/" + FolderName, FolderName, FileName)) { DataTable dt = Services.Database.ExecuteQuery(SQL).Tables[0]; report.RegisterData(dt, AliasName); report.GetDataSource(AliasName).Enabled = true; report.Load(@"C:\Report/" + FolderName + "/" + FileName); report.Show(); } } catch (Exception ex) { MessageBox.Show("Дараахи алдаа гарлаа. " + ex.Message.ToString(), "Алдаа", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { report.Dispose(); } }
private void btnImprimir_Click(object sender, EventArgs e) { try { if (this.dgvDatos.DataSource == null) return; BindingSource bs = (BindingSource)this.dgvDatos.DataSource; DataTable dt = (DataTable)bs.DataSource; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePartesClasificacionAbc.frx")); report.RegisterData(dt, "PartesClasificacionAbc"); report.GetDataSource("PartesClasificacionAbc").Enabled = true; report.Show(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
private void DisplayReporteEntradaCompra() { try { var movimiento = Datos.GetListOf<MovimientoInventarioView>(m => m.MovimientoInventarioID.Equals(oID)); var detalle = Datos.GetListOf<MovimientoInventarioDetalleView>(d => d.MovimientoInventarioID.Equals(oID)); var detalleDescuentosGen = new List<MovimientoInventarioDescuentoView>(); var detalleDescuentosGenerales = Datos.GetListOf<MovimientoInventarioDescuentoView>(m => m.MovimientoInventarioID.Equals(oID) && (m.TipoDescuentoID.Equals(1) || m.TipoDescuentoID.Equals(4) || m.TipoDescuentoID.Equals(2) || m.TipoDescuentoID.Equals(5))); bool uno = false; bool cuatro = false; bool dos = false; bool cinco = false; foreach (var descuentoGen in detalleDescuentosGenerales) { if (descuentoGen.TipoDescuentoID.Equals(1) && uno.Equals(false)) { uno = true; detalleDescuentosGen.Add(descuentoGen); } if (descuentoGen.TipoDescuentoID.Equals(4) && cuatro.Equals(false)) { cuatro = true; detalleDescuentosGen.Add(descuentoGen); } if (descuentoGen.TipoDescuentoID.Equals(2) && dos.Equals(false)) { dos = true; detalleDescuentosGen.Add(descuentoGen); } if (descuentoGen.TipoDescuentoID.Equals(5) && cinco.Equals(false)) { cinco = true; detalleDescuentosGen.Add(descuentoGen); } } var detalleDescuentosInd = Datos.GetListOf<MovimientoInventarioDescuentoView>(m => m.MovimientoInventarioID.Equals(oID) && m.TipoDescuentoID.Equals(3)); foreach (var descuentoGen in detalleDescuentosInd) { detalleDescuentosGen.Add(descuentoGen); } IEnumerable<MovimientoInventarioView> movimientoE = movimiento; IEnumerable<MovimientoInventarioDetalleView> detalleE = detalle; IEnumerable<MovimientoInventarioDescuentoView> descuentosGen = detalleDescuentosGen; //IEnumerable<MovimientoInventarioDescuentoView> descuentosInd = detalleDescuentosInd; using (FastReport.Report report = new FastReport.Report()) { report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEntradaCompra.frx")); report.RegisterData(movimientoE, "movimiento", 3); report.RegisterData(detalleE, "detalle", 3); report.RegisterData(descuentosGen, "descuentosGenerales", 3); //report.RegisterData(descuentosInd, "descuentosIndividuales", 3); report.GetDataSource("movimiento").Enabled = true; report.GetDataSource("detalle").Enabled = true; report.GetDataSource("descuentosGenerales").Enabled = true; //report.GetDataSource("descuentosIndividuales").Enabled = true; report.Show(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }
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 DisplayReporteTraspaso() { try { var movimiento = Datos.GetListOf<MovimientoInventarioView>(m => m.MovimientoInventarioID.Equals(oID)); var detalle = Datos.GetListOf<MovimientoInventarioDetalleView>(d => d.MovimientoInventarioID.Equals(oID)); IEnumerable<MovimientoInventarioView> movimientoE = movimiento; IEnumerable<MovimientoInventarioDetalleView> detalleE = detalle; using (FastReport.Report report = new FastReport.Report()) { if (detalle.Count < 10) report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspaso.frx")); else report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspasosMasDeDiez.frx")); report.RegisterData(movimientoE, "movimiento", 3); report.RegisterData(detalleE, "detalle", 3); report.GetDataSource("movimiento").Enabled = true; report.GetDataSource("detalle").Enabled = true; report.Show(true); } } catch (Exception ex) { Util.MensajeError(ex.Message, GlobalClass.NombreApp); } }