private void btnReporte_Click(object sender, EventArgs e)
{
string ruta = Application.StartupPath + "\\CobrarVentas.rpt";
ReportDocument rpt = new ReportDocument();
dsVentas dsVentaCobrar = new dsVentas();
dsVentaCobrar.EnforceConstraints = false;
dsVentasTableAdapters.ClientesTableAdapter clienteTableAdap = new dsVentasTableAdapters.ClientesTableAdapter();
dsVentasTableAdapters.CondPagoTableAdapter condPagoTableAdap = new dsVentasTableAdapters.CondPagoTableAdapter();
dsVentasTableAdapters.DetalleVentaTableAdapter detVentaTableAdap = new dsVentasTableAdapters.DetalleVentaTableAdapter();
dsVentasTableAdapters.AbonarVentaTableAdapter abonarVentaTableAdap = new dsVentasTableAdapters.AbonarVentaTableAdapter();
dsVentasTableAdapters.VendedoresTableAdapter vendedorTableAdap = new dsVentasTableAdapters.VendedoresTableAdapter();
dsVentasTableAdapters.VentasTableAdapter ventaTableAdap = new dsVentasTableAdapters.VentasTableAdapter();
dsVentasTableAdapters.ArticulosTableAdapter articuloTableAdap = new dsVentasTableAdapters.ArticulosTableAdapter();
dsVentasTableAdapters.MarcasTableAdapter marcasTableAdap = new dsVentasTableAdapters.MarcasTableAdapter();
// llenos los tabla adapter
clienteTableAdap.Fill(dsVentaCobrar.Clientes);
condPagoTableAdap.Fill(dsVentaCobrar.CondPago);
abonarVentaTableAdap.Fill(dsVentaCobrar.AbonarVenta);
vendedorTableAdap.Fill(dsVentaCobrar.Vendedores);
detVentaTableAdap.Fill(dsVentaCobrar.DetalleVenta);
articuloTableAdap.Fill(dsVentaCobrar.Articulos);
marcasTableAdap.Fill(dsVentaCobrar.Marcas);
foreach (Entidades.E_Venta venta in this._listVenta)
{
dsVentas.VentasRow rowVenta = dsVentaCobrar.Ventas.NewVentasRow();
rowVenta.codVenta = venta.codVenta;
rowVenta.CUIT = venta.cuit;
rowVenta.descuento = venta.descuento;
rowVenta.idCliente = venta.cliente.idCliente;
rowVenta.idVendedor = venta.vendedor.idVendedor;
rowVenta.idCondPago = venta.condPago.idCondPago;
rowVenta.precioTotal = venta.precioTotal;
rowVenta.observacion = venta.observacion;
rowVenta.recargo = venta.recargo;
rowVenta.fecVenta = (DateTime)venta.fecha;
dsVentaCobrar.Ventas.AddVentasRow(rowVenta);
}
ventaTableAdap.Fill(dsVentaCobrar.Ventas);
rpt.Load(ruta);
rpt.SetDataSource(dsVentaCobrar);
frmRptVisor frmVerRpt = new frmRptVisor(rpt);
frmVerRpt.Show();
}
//Metodos
private void generarRemito(Int64 codVenta)
{
try
{
string ruta = Application.StartupPath + "\\crRemitoVenta.rpt";
ReportDocument rpt = new ReportDocument();
dsVentas dsPintureriaVenta = new dsVentas();
dsPintureriaVenta.EnforceConstraints = false;
dsVentasTableAdapters.ClientesTableAdapter clienteTableAdap = new dsVentasTableAdapters.ClientesTableAdapter();
dsVentasTableAdapters.CondPagoTableAdapter condPagoTableAdap = new dsVentasTableAdapters.CondPagoTableAdapter();
dsVentasTableAdapters.DetalleVentaTableAdapter detVentaTableAdap = new dsVentasTableAdapters.DetalleVentaTableAdapter();
dsVentasTableAdapters.AbonarVentaTableAdapter abonarVentaTableAdap = new dsVentasTableAdapters.AbonarVentaTableAdapter();
dsVentasTableAdapters.VendedoresTableAdapter vendedorTableAdap = new dsVentasTableAdapters.VendedoresTableAdapter();
dsVentasTableAdapters.VentasTableAdapter ventaTableAdap = new dsVentasTableAdapters.VentasTableAdapter();
dsVentasTableAdapters.ArticulosTableAdapter articuloTableAdap = new dsVentasTableAdapters.ArticulosTableAdapter();
dsVentasTableAdapters.MarcasTableAdapter marcasTableAdap = new dsVentasTableAdapters.MarcasTableAdapter();
// llenos los tabla adapter
clienteTableAdap.Fill(dsPintureriaVenta.Clientes);
condPagoTableAdap.Fill(dsPintureriaVenta.CondPago);
abonarVentaTableAdap.Fill(dsPintureriaVenta.AbonarVenta);
vendedorTableAdap.Fill(dsPintureriaVenta.Vendedores);
detVentaTableAdap.Fill(dsPintureriaVenta.DetalleVenta);
articuloTableAdap.Fill(dsPintureriaVenta.Articulos);
marcasTableAdap.Fill(dsPintureriaVenta.Marcas);
ventaTableAdap.FillByGetOneVenta(dsPintureriaVenta.Ventas, codVenta);
rpt.Load(ruta);
rpt.SetDataSource(dsPintureriaVenta);
frmRptVisor frmVerRpt = new frmRptVisor(rpt);
frmVerRpt.Show();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}