private void btnImprimirLote_Click(object sender, EventArgs e)
{
try
{
DataSet dsRenovacion = new DataSet();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
{
SqlCommand cmd1 = new SqlCommand("Rpt_Renovacion", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Opcion", 1);
cmd1.Parameters.AddWithValue("@IdRenovacion", txtIdRenovacion.Text.Trim());
SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
daCab.Fill(dsRenovacion, "Renovacion");
SqlCommand cmd2 = new SqlCommand("Rpt_Renovacion", con);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@Opcion", 2);
cmd2.Parameters.AddWithValue("@IdRenovacion", txtIdRenovacion.Text.Trim());
SqlDataAdapter daCab2 = new SqlDataAdapter(cmd2);
daCab2.Fill(dsRenovacion, "RenovacionDet1");
SqlCommand cmd3 = new SqlCommand("Rpt_Renovacion", con);
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.AddWithValue("@Opcion", 3);
cmd3.Parameters.AddWithValue("@IdRenovacion", txtIdRenovacion.Text.Trim());
SqlDataAdapter daCab3 = new SqlDataAdapter(cmd3);
daCab3.Fill(dsRenovacion, "RenovacionDet2");
con.Close();
}
Crystal.crRptRenovacion ocrRptRenovacion = new Crystal.crRptRenovacion();
Reportes.frmVisorLoteLiquidacion ofrmVisorLoteLiquidacion = new Reportes.frmVisorLoteLiquidacion();
ofrmVisorLoteLiquidacion.crvVisorLoteLiq.ReportSource = ocrRptRenovacion;
ocrRptRenovacion.SetDataSource(dsRenovacion);
ocrRptRenovacion.SetParameterValue("usuario", General.General.GetUsuario);
ofrmVisorLoteLiquidacion.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Imprimir()
{
try
{
if (gvRenovacion.CurrentRow.Cells["IdEstado_tt"].Value.ToString() == "00113") //Anulada
{
return;
}
DataSet dsRenovacion = new DataSet();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
{
SqlCommand cmd1 = new SqlCommand("Rpt_Renovacion", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Opcion", 1);
cmd1.Parameters.AddWithValue("@IdRenovacion", gvRenovacion.CurrentRow.Cells["IdRenovacion"].Value.ToString());
SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
daCab.Fill(dsRenovacion, "Renovacion");
SqlCommand cmd2 = new SqlCommand("Rpt_Renovacion", con);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@Opcion", 2);
cmd2.Parameters.AddWithValue("@IdRenovacion", gvRenovacion.CurrentRow.Cells["IdRenovacion"].Value.ToString());
SqlDataAdapter daCab2 = new SqlDataAdapter(cmd2);
daCab2.Fill(dsRenovacion, "RenovacionDet1");
SqlCommand cmd3 = new SqlCommand("Rpt_Renovacion", con);
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.AddWithValue("@Opcion", 3);
cmd3.Parameters.AddWithValue("@IdRenovacion", gvRenovacion.CurrentRow.Cells["IdRenovacion"].Value.ToString());
SqlDataAdapter daCab3 = new SqlDataAdapter(cmd3);
daCab3.Fill(dsRenovacion, "RenovacionDet2");
con.Close();
SqlCommand cmd4 = new SqlCommand("Rpt_Renovacion", con);
cmd4.CommandType = CommandType.StoredProcedure;
cmd4.Parameters.AddWithValue("@Opcion", 4);
cmd4.Parameters.AddWithValue("@IdRenovacion", gvRenovacion.CurrentRow.Cells["IdRenovacion"].Value.ToString());
SqlDataAdapter daCab4 = new SqlDataAdapter(cmd4);
daCab4.Fill(dsRenovacion, "RenovacionPago");
con.Close();
}
Crystal.crRptRenovacion ocrRptRenovacion = new Crystal.crRptRenovacion();
Reportes.frmVisorLoteLiquidacion ofrmVisorLoteLiquidacion = new Reportes.frmVisorLoteLiquidacion();
ofrmVisorLoteLiquidacion.crvVisorLoteLiq.ReportSource = ocrRptRenovacion;
ocrRptRenovacion.SetDataSource(dsRenovacion);
ocrRptRenovacion.SetParameterValue("usuario", General.General.GetUsuario);
ofrmVisorLoteLiquidacion.Show();
//Fondo Garantía
DataSet dsRenovacionFG = new DataSet();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
{
SqlCommand cmd1 = new SqlCommand("Rpt_Renovacion", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Opcion", 1);
cmd1.Parameters.AddWithValue("@IdRenovacion", gvRenovacion.CurrentRow.Cells["IdRenovacion"].Value.ToString());
SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
daCab.Fill(dsRenovacionFG, "Renovacion");
SqlCommand cmd4 = new SqlCommand("Rpt_Renovacion", con);
cmd4.CommandType = CommandType.StoredProcedure;
cmd4.Parameters.AddWithValue("@Opcion", 5);
cmd4.Parameters.AddWithValue("@IdRenovacion", gvRenovacion.CurrentRow.Cells["IdRenovacion"].Value.ToString());
SqlDataAdapter daCab4 = new SqlDataAdapter(cmd4);
daCab4.Fill(dsRenovacionFG, "RenovacionFG");
con.Close();
}
if (dsRenovacionFG.Tables["RenovacionFG"].Rows.Count > 0)
{
Crystal.crRptRenovacionFG ocrRptRenovacionFG = new Crystal.crRptRenovacionFG();
Reportes.frmVisorLoteLiquidacion ofrm = new Reportes.frmVisorLoteLiquidacion();
ofrm.crvVisorLoteLiq.ReportSource = ocrRptRenovacionFG;
ocrRptRenovacionFG.SetDataSource(dsRenovacionFG);
ocrRptRenovacionFG.SetParameterValue("Usuario", General.General.GetUsuario);
ofrm.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}