private void btnGenerar_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
try
{
if (c1cboCia.SelectedIndex != -1 & CboSede.SelectedIndex != -1 & DtpFechaIni.Value != null & DtpFechaFin.Value != null & CboCajero.SelectedIndex != -1)
{
EmpresaID = c1cboCia.SelectedValue.ToString();
SedeID = CboSede.SelectedValue.ToString();
DS = ObjCL_Venta.GetDetalleVentasComprobante(DtpFechaIni.Value, DtpFechaFin.Value.AddDays(1), Convert.ToInt32(CboCajero.SelectedValue), EmpresaID, SedeID);
Halley.Presentacion.Ventas.CrystalReports.CrVentasComprobante ObjCrpVentasComprobante = new Halley.Presentacion.Ventas.CrystalReports.CrVentasComprobante();
ObjCrpVentasComprobante.SetDataSource(DS);
CrvResumenVentas.ReportSource = ObjCrpVentasComprobante;
//pasar datos directo al crystal reports
TextObject txt;
txt = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["TxtReporte"];
txt.Text = "CUADRE DE CAJA DE " + DtpFechaIni.Value.Date.ToShortDateString().ToString() + " A " + DtpFechaFin.Value.Date.ToShortDateString().ToString();
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.InnerException.Message);
MessageBox.Show(ex.Message);
}
Cursor = Cursors.Default;
}
private void btnGenerar_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
try
{
if (c1cboCia.SelectedIndex != -1 & CboSede.SelectedIndex != -1 & DtpFechaIni.Value != null & DtpFechaFin.Value != null & CboCajero.SelectedIndex != -1)
{
//reiniciar variables
totb = 0; totf = 0; tott = 0; tottf = 0; toti = 0; tote = 0; DineroEntregado = 0; Entrega12 = 0; totbe = 0; totfe = 0;
Empresa = c1cboCia.Columns["NomEmpresa"].Value.ToString();
Sede = CboSede.Columns["NomSede"].Value.ToString();
EmpresaID = c1cboCia.SelectedValue.ToString();
SedeID = CboSede.SelectedValue.ToString();
Cajero = CboCajero.Columns["Usuario"].Value.ToString();
CajeroID = Convert.ToInt32(CboCajero.SelectedValue);
FechaIni = DtpFechaIni.Value;
FechaFin = DtpFechaFin.Value.AddDays(1);
DS = ObjCL_Venta.GetDetalleVentasComprobante(FechaIni, FechaFin, CajeroID, EmpresaID, SedeID);
Halley.Presentacion.Ventas.CrystalReports.CrVentasComprobante ObjCrpVentasComprobante = new Halley.Presentacion.Ventas.CrystalReports.CrVentasComprobante();
//tabla empresa
DataTable Dt = new DataTable("Logo");
Dt.Columns.Add("Logo", typeof(byte[]));
Dt.Columns.Add("NomEmpresa", typeof(string));
Dt.Columns.Add("RUC", typeof(string));
Dt.Columns.Add("DomicilioFiscal", typeof(string));
DataRow Dr = Dt.NewRow();
// El campo productImage primero se almacena en un buffer
DataRow[] customerRow = UTI_Datatables.DtEmpresas.Select("EmpresaID = '" + c1cboCia.SelectedValue.ToString() + "'");
if (customerRow[0]["Logo"] != DBNull.Value)
{
Dr["Logo"] = customerRow[0]["Logo"];
}
else
{
Dr["Logo"] = DBNull.Value;
}
Dr["NomEmpresa"] = customerRow[0]["NomEmpresa"];
Dr["RUC"] = customerRow[0]["RUC"];
Dr["DomicilioFiscal"] = customerRow[0]["DomicilioFiscal"];
Dt.Rows.Add(Dr);
DS.Tables.Add(Dt.Copy());
ObjCrpVentasComprobante.SetDataSource(DS);
CrvResumenVentas.ReportSource = ObjCrpVentasComprobante;
//pasar datos directo al crystal reports
TextObject txt;
txt = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["TxtReporte"];
fechainicio = DtpFechaIni.Value.Date.ToShortDateString().ToString();
fechafin = DtpFechaFin.Value.Date.ToShortDateString().ToString();
txt.Text = "CUADRE DE CAJA DE " + fechainicio + " A " + fechafin;
DataView dv = new DataView(DS.Tables["Comprobante"]);
dv.RowFilter = "NomTipoComprobante='BOLETA' and FlgEst='True'";
if (dv.Count > 0)
{
totb = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='BOLETA' and FlgEst='True'"));
}
dv.RowFilter = "NomTipoComprobante='FACTURA' and FlgEst='True'";
if (dv.Count > 0)
{
totf = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='FACTURA' and FlgEst='True'"));
}
dv.RowFilter = "NomTipoComprobante='BOLETA ELECTRONICA' and FlgEst='True'";
if (dv.Count > 0)
{
totbe = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='BOLETA ELECTRONICA' and FlgEst='True'"));
}
dv.RowFilter = "NomTipoComprobante='FACTURA ELECTRONICA' and FlgEst='True'";
if (dv.Count > 0)
{
totfe = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='FACTURA ELECTRONICA' and FlgEst='True'"));
}
dv.RowFilter = "NomTipoComprobante='TICKET' and FlgEst='True'";
if (dv.Count > 0)
{
tott = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='TICKET' and FlgEst='True'"));
}
dv.RowFilter = "NomTipoComprobante='TICKET FACTURA' and FlgEst='True'";
if (dv.Count > 0)
{
tottf = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='TICKET FACTURA' and FlgEst='True'"));
}
dv.RowFilter = "(NomTipoComprobante='*SALDO INICIAL' or NomTipoComprobante='*INGRESO') and FlgEst='True'";
if (dv.Count > 0)
{
toti = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "(NomTipoComprobante='*SALDO INICIAL' or NomTipoComprobante='*INGRESO') and FlgEst='True'"));
}
dv.RowFilter = "NomTipoComprobante='*EGRESO' and FlgEst='True'";
if (dv.Count > 0)
{
tote = Convert.ToDecimal(DS.Tables["Comprobante"].Compute("Sum(Pagado)", "NomTipoComprobante='*EGRESO' and FlgEst='True'"));
}
TextObject txtb;
txtb = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txtb"];
txtb.Text = totb.ToString("C");
TextObject txtf;
txtf = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txtf"];
txtf.Text = totf.ToString("C");
TextObject txtbe;
txtbe = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txtbe"];
txtbe.Text = totbe.ToString("C");
TextObject txtfe;
txtfe = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txtfe"];
txtfe.Text = totfe.ToString("C");
TextObject txtt;
txtt = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txtt"];
txtt.Text = tott.ToString("C");
TextObject txttf;
txttf = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txttf"];
txttf.Text = tottf.ToString("C");
TextObject txti;
txti = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txti"];
txti.Text = toti.ToString("C");
TextObject txte;
txte = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txte"];
txte.Text = tote.ToString("C");
TextObject txts;
txts = (TextObject)ObjCrpVentasComprobante.ReportDefinition.ReportObjects["txts"];
txts.Text = (tott + tottf + totb + totf + toti - tote + totbe + totfe).ToString("C");
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.InnerException.Message);
MessageBox.Show(ex.Message);
}
Cursor = Cursors.Default;
}
