public rptTicketCopia(ParametrosReporte obj)
{
//
// Required for telerik Reporting designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
this.tbTicketCopia.DataSource = obj.lstDetalleVenta;
}
private void gdvListado_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == this.gdvListado.Columns["Detalle"].Index)
{
int idventa = Convert.ToInt32(gdvListado.SelectedCells[1].Value);
string total = Convert.ToString(gdvListado.SelectedCells[7].Value);
string textoNumero = NumeroATexto(total);
ParametrosReporte reporte = DatVenta.Consultar_Ticket_Parametro(idventa);
reporte.LetraNumero = textoNumero;
if (rbTicket.Checked == true)
{
rptTicket rptTicket = new rptTicket();
rptTicket.tbTicket.DataSource = reporte.lstDetalleVenta;
rptTicket.DataSource = reporte;
reportViewer1.Report = rptTicket;
}
else if (RbtnMod2.Checked)
{
ReportTicket rptTicket = new ReportTicket();
rptTicket.tbTicket.DataSource = reporte.lstDetalleVenta;
rptTicket.DataSource = reporte;
reportViewer1.Report = rptTicket;
}
else
{
rtpRecibo recibo = new rtpRecibo();
recibo.tblVentaProducto.DataSource = reporte.lstDetalleVenta;
recibo.DataSource = reporte;
reportViewer1.Report = recibo;
}
reportViewer1.RefreshReport();
}
}
catch (Exception ex)
{
MessageBox.Show("Error de al intentar obtener el ticket " + ex.Message, "Error de lectura", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ImprimirTicket(Venta venta)
{
#region TICKET
string textoNumero = Convertir_NumeroLetra.NumeroATexto(venta.MontoTotal.ToString());
// DataTable dt = DatDetalleVenta.ObtenerDatos_Ticket(venta.Id, textoNumero);
ParametrosReporte reporte = DatVenta.Consultar_Ticket_Parametro(venta.Id);
reporte.LetraNumero = textoNumero;
//rptTicket rptTicket = new rptTicket();
ReportTicket rptTicket = new ReportTicket();
rptTicket.tbTicket.DataSource = reporte.lstDetalleVenta;
rptTicket.DataSource = reporte;
reportViewer1.Report = rptTicket;
reportViewer1.RefreshReport();
#endregion
try
{
string impresora = DatBox.Obtener_ImpresoraTicket(serialPC, "TICKET");
TICKET = new PrintDocument();
TICKET.PrinterSettings.PrinterName = impresora;
if (TICKET.PrinterSettings.IsValid)
{
PrinterSettings printerSettings = new PrinterSettings();
printerSettings.PrinterName = impresora;
ReportProcessor reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportViewer1.ReportSource, printerSettings);
}
}
catch (Exception ex)
{
MessageBox.Show("Error al imprimir el ticket : " + ex.Message, "Error de impresión", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public static ParametrosReporte Consultar_Ticket_Parametro(int idVenta)
{
using (SqlConnection conn = new SqlConnection(MasterConnection.connection))
{
try
{
ParametrosReporte obj = new ParametrosReporte();
conn.Open();
SqlCommand cmd = new SqlCommand("[sp_ObtenerTicket]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idVentas", idVenta);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
obj.NombreEmpresa = reader.GetString(0);
obj.LogoEmpresa = (byte[])(reader["Logo"]);
obj.Agradecimiento = reader.GetString(2);
obj.Anuncio = reader.GetString(3);
obj.Direccion = reader.GetString(4);
obj.PaginaWeb = reader.GetString(5);
obj.Provincia = reader.GetString(6);
obj.FechaVenta = reader.GetDateTime(7);
obj.MontoTotal = reader.GetDecimal(8);
obj.Cajero = reader.GetString(9);
obj.Cliente = reader.GetString(10);
obj.DireccionCliente = reader.GetString(11);
obj.TotalProducto = reader.GetInt32(12);
obj.Folio = reader.GetString(13);
obj.FormaPago = reader.GetString(14);
obj.Cambio = reader.GetDecimal(15);
obj.Efectivo = reader.GetDecimal(16);
obj.Id = reader.GetInt32(17);
obj.IdDetalleVenta = reader.GetInt32(18);
}
conn.Close();
conn.Open();
SqlCommand cmd2 = new SqlCommand("[sp_ObtenerDetalleVenta]", conn);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@idventa", obj.Id);
SqlDataReader reader2 = cmd2.ExecuteReader();
List <DetalleVenta> lst = new List <DetalleVenta>();
while (reader2.Read())
{
DetalleVenta d = new DetalleVenta();
d.Cantidad = reader2.GetDecimal(0);
d.UnidadMedida = reader2.GetString(1);
d.Descripcion = reader2.GetString(2);
d.Precio = reader2.GetDecimal(3);
d.TotalPago = reader2.GetDecimal(4);
lst.Add(d);
}
conn.Close();
obj.lstDetalleVenta = lst;
return(obj);
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
}
