public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRreporteslitter rpt = new CRreporteslitter();
rpt.Site = this.Site;
return(rpt);
}
public ReporteProduccionSlitter()
{
InitializeComponent();
string LoteInternoJAG = VerRecibo.LoteInterno;
string Clinete = "";
string NumeroDeParte = "";
string TipoMaterial = "";
string NumeroDeRollo = "";
string LoteDelCliente = "";
int PesoRollo = 0;
float EspesorRollo = 0, EsMas = 0, EsMenos = 0;
int AnchoRollo = 0, IdRecibo = 0;
int diametrointerno = 0, pesomaxcin = 0, pesomincin = 0, espesorbobinamax = 0;
float rebabamax = 0;
//cintas
int numcin1 = 0, numcin2 = 0, numcin3 = 0, numcin4 = 0, numcin5 = 0;
float anchocin1 = 0, anchocin2 = 0, anchocin3 = 0, anchocin4 = 0, anchocin5 = 0;
float numcin1amas = 0, numcin1amenos = 0, numcin2amas = 0, numcin2amenos = 0, numcin3amas = 0, numcin3amenos = 0, numcin4amas = 0, numcin4amenos = 0, numcin5amas = 0, numcin5amenos = 0;
string empaque = "", tarima = "";
SqlConnection OpenCon = new SqlConnection(@"Data Source=WIN-SERVER\JAGUARIRA;Initial Catalog=SistemaProduccion;Persist Security Info=True;User ID=sa;Password=Jaguar1");
try
{
OpenCon.Open();
}
catch (SqlException ex)
{
MessageBox.Show("ERROR FAVOR DE INFORMAR AL DEPARTAMENTO DE SISTEMAS " + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show("ERROR FAVOR DE INFORMAR AL DEPARTAMENTO DE SISTEMAS " + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Consultas
String ConsultaCliente = "Select Cliente From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaNumeroParte = "Select NumeroParte From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaMaterial = "Select Material From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaNumRollo = "Select NumeroRollo From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaLoteCliente = "Select LoteCliente From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaKilogramos = "Select Kgs From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaEspesor = "Select Espesor From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaAnchoRollo = "Select Ancho From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
String ConsultaIdRecibo = "Select IdReciboProduccion From ReciboProduccion Where LoteInterno = '" + LoteInternoJAG + "'";
try
{
//Convetir consulta cliente
SqlCommand com = new SqlCommand(ConsultaCliente, OpenCon);
if (com.ExecuteScalar() != DBNull.Value)
{
Clinete = Convert.ToString(com.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL CLIENTE ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta numero de parte
SqlCommand com2 = new SqlCommand(ConsultaNumeroParte, OpenCon);
if (com2.ExecuteScalar() != DBNull.Value)
{
NumeroDeParte = Convert.ToString(com2.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE PARTE ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta material
SqlCommand com3 = new SqlCommand(ConsultaMaterial, OpenCon);
if (com3.ExecuteScalar() != DBNull.Value)
{
TipoMaterial = Convert.ToString(com3.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL MATERIAL ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta numero de rollo
SqlCommand com4 = new SqlCommand(ConsultaNumRollo, OpenCon);
if (com4.ExecuteScalar() != DBNull.Value)
{
NumeroDeRollo = Convert.ToString(com4.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE ROLLO ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta lote del cliente
SqlCommand com5 = new SqlCommand(ConsultaLoteCliente, OpenCon);
if (com5.ExecuteScalar() != DBNull.Value)
{
LoteDelCliente = Convert.ToString(com5.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL LOTE DEL CLIENTE ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta peso del rollo
SqlCommand com6 = new SqlCommand(ConsultaKilogramos, OpenCon);
if (com6.ExecuteScalar() != DBNull.Value)
{
PesoRollo = Convert.ToInt32(com6.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL PESO DEL ROLLO ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta espesor del rollo
SqlCommand com7 = new SqlCommand(ConsultaEspesor, OpenCon);
if (com7.ExecuteScalar() != DBNull.Value)
{
EspesorRollo = Convert.ToSingle(com7.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ESPESOR ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta ancho rollo
SqlCommand com8 = new SqlCommand(ConsultaAnchoRollo, OpenCon);
if (com8.ExecuteScalar() != DBNull.Value)
{
AnchoRollo = Convert.ToInt32(com8.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DEL ROLLO ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta id recibo produccion
SqlCommand com9 = new SqlCommand(ConsultaIdRecibo, OpenCon);
if (com9.ExecuteScalar() != DBNull.Value)
{
IdRecibo = Convert.ToInt32(com9.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ID DE RECIBO ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (SqlException ex)
{
MessageBox.Show("ERROR FAVOR DE INFORMAR AL DEPARTAMENTO DE SISTEMAS " + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show("ERROR FAVOR DE INFORMAR AL DEPARTAMENTO DE SISTEMAS " + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
String ConsultaEsMas = "Select EspesorMas From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaEsMenos = "Select EspesorMenos From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
/////--------------------
String ConsultaDiametroInterno = "Select DiametroInterno From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaPesoMaximoCin = "Select PesoMaxCin From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaPesoMinimoCin = "Select PesoMinCin From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaEsBobinaMax = "Select RebabaMax From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaRebabaMax = "Select EspesorBobinaMax From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaEmpaque = "Select Empaque From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
String ConsultaTarima = "Select Tarima From NumeroParte Where NumParte = '" + NumeroDeParte + "'";
//Consultas cintas
String ConsultaNumCintas1 = "Select A1NumCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaNumCintas2 = "Select A2NumCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaNumCintas3 = "Select A3NumCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaNumCintas4 = "Select A4NumCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaNumCintas5 = "Select A5NumCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin1 = "Select A1AnchoCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin2 = "Select A2AnchoCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin3 = "Select A3AnchoCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin4 = "Select A4AnchoCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin5 = "Select A5AnchoCin From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin1Mas = "Select A1AnchoCinMas From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin2Mas = "Select A2AnchoCinMas From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin3Mas = "Select A3AnchoCinMas From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin4Mas = "Select A4AnchoCinMas From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin5Mas = "Select A5AnchoCinMas From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin1Menos = "Select A1AnchoCinMenos From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin2Menos = "Select A2AnchoCinMenos From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin3Menos = "Select A3AnchoCinMenos From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin4Menos = "Select A4AnchoCinMenos From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
String ConsultaAnchoCin5Menos = "Select A5AnchoCinMenos From AnchosCintasSlitter Where NumParte = '" + NumeroDeParte + "'";
try
{
//Convetir consulta espesor mas
SqlCommand com2 = new SqlCommand(ConsultaEsMas, OpenCon);
if (com2.ExecuteScalar() != DBNull.Value)
{
EsMas = Convert.ToSingle(com2.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ESPESOR MAS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convetir consulta espesor menos
SqlCommand com3 = new SqlCommand(ConsultaEsMenos, OpenCon);
if (com3.ExecuteScalar() != DBNull.Value)
{
EsMenos = Convert.ToSingle(com3.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ESPESOR MENOS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta numero de cintas 1
SqlCommand com1 = new SqlCommand(ConsultaNumCintas1, OpenCon);
if (com1.ExecuteScalar() != DBNull.Value)
{
numcin1 = Convert.ToInt32(com1.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE CINTAS 1 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta numero de cintas 2
SqlCommand com4 = new SqlCommand(ConsultaNumCintas2, OpenCon);
if (com4.ExecuteScalar() != DBNull.Value)
{
numcin2 = Convert.ToInt32(com4.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE CINTAS 2 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta numero de cintas 3
SqlCommand com5 = new SqlCommand(ConsultaNumCintas3, OpenCon);
if (com5.ExecuteScalar() != DBNull.Value)
{
numcin3 = Convert.ToInt32(com5.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE CINTAS 3 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta numero de cintas 4
SqlCommand com6 = new SqlCommand(ConsultaNumCintas4, OpenCon);
if (com6.ExecuteScalar() != DBNull.Value)
{
numcin4 = Convert.ToInt32(com6.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE CINTAS 4 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta numero de cintas 5
SqlCommand com7 = new SqlCommand(ConsultaNumCintas5, OpenCon);
if (com7.ExecuteScalar() != DBNull.Value)
{
numcin5 = Convert.ToInt32(com7.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL NUMERO DE CINTAS 5 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta 1
SqlCommand com8 = new SqlCommand(ConsultaAnchoCin1, OpenCon);
if (com8.ExecuteScalar() != DBNull.Value)
{
anchocin1 = Convert.ToSingle(com8.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 1 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta 2
SqlCommand com9 = new SqlCommand(ConsultaAnchoCin2, OpenCon);
if (com9.ExecuteScalar() != DBNull.Value)
{
anchocin2 = Convert.ToSingle(com9.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 2 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta 3
SqlCommand com10 = new SqlCommand(ConsultaAnchoCin3, OpenCon);
if (com10.ExecuteScalar() != DBNull.Value)
{
anchocin3 = Convert.ToSingle(com10.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 3 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta 4
SqlCommand com11 = new SqlCommand(ConsultaAnchoCin4, OpenCon);
if (com11.ExecuteScalar() != DBNull.Value)
{
anchocin4 = Convert.ToSingle(com11.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 4 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta 5
SqlCommand com12 = new SqlCommand(ConsultaAnchoCin5, OpenCon);
if (com12.ExecuteScalar() != DBNull.Value)
{
anchocin5 = Convert.ToSingle(com12.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 5 ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta mas 1
SqlCommand com13 = new SqlCommand(ConsultaAnchoCin1Mas, OpenCon);
if (com13.ExecuteScalar() != DBNull.Value)
{
numcin1amas = Convert.ToSingle(com13.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 1 MAS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta mas 2
SqlCommand com14 = new SqlCommand(ConsultaAnchoCin2Mas, OpenCon);
if (com14.ExecuteScalar() != DBNull.Value)
{
numcin2amas = Convert.ToSingle(com14.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 2 MAS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta mas 3
SqlCommand com15 = new SqlCommand(ConsultaAnchoCin3Mas, OpenCon);
if (com15.ExecuteScalar() != DBNull.Value)
{
numcin3amas = Convert.ToSingle(com15.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 3 MAS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta mas 4
SqlCommand com16 = new SqlCommand(ConsultaAnchoCin4Mas, OpenCon);
if (com16.ExecuteScalar() != DBNull.Value)
{
numcin4amas = Convert.ToSingle(com16.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 4 MAS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta mas 5
SqlCommand com17 = new SqlCommand(ConsultaAnchoCin5Mas, OpenCon);
if (com17.ExecuteScalar() != DBNull.Value)
{
numcin5amas = Convert.ToSingle(com17.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 5 MAS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta menos 1
SqlCommand com18 = new SqlCommand(ConsultaAnchoCin1Menos, OpenCon);
if (com18.ExecuteScalar() != DBNull.Value)
{
numcin1amenos = Convert.ToSingle(com18.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 1 MENOS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta menos 2
SqlCommand com19 = new SqlCommand(ConsultaAnchoCin2Menos, OpenCon);
if (com19.ExecuteScalar() != DBNull.Value)
{
numcin2amenos = Convert.ToSingle(com19.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 2 MENOS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta menos 3
SqlCommand com20 = new SqlCommand(ConsultaAnchoCin3Menos, OpenCon);
if (com20.ExecuteScalar() != DBNull.Value)
{
numcin3amenos = Convert.ToSingle(com20.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 3 MENOS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta menos 4
SqlCommand com21 = new SqlCommand(ConsultaAnchoCin4Menos, OpenCon);
if (com21.ExecuteScalar() != DBNull.Value)
{
numcin4amenos = Convert.ToSingle(com21.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 4 MENOS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta ancho cinta menos 5
SqlCommand com22 = new SqlCommand(ConsultaAnchoCin5Menos, OpenCon);
if (com22.ExecuteScalar() != DBNull.Value)
{
numcin5amenos = Convert.ToSingle(com22.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ANCHO DE LA CINTA 5 MENOS ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta diametro interno
SqlCommand com23 = new SqlCommand(ConsultaDiametroInterno, OpenCon);
if (com23.ExecuteScalar() != DBNull.Value)
{
diametrointerno = Convert.ToInt32(com23.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL DIAMETRO INTERNO ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta peso maximo cinta
SqlCommand com24 = new SqlCommand(ConsultaPesoMaximoCin, OpenCon);
if (com24.ExecuteScalar() != DBNull.Value)
{
pesomaxcin = Convert.ToInt32(com24.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL PESO MAXIMO DE LA CINTA ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta peso minimo cinta
SqlCommand com25 = new SqlCommand(ConsultaPesoMinimoCin, OpenCon);
if (com25.ExecuteScalar() != DBNull.Value)
{
pesomincin = Convert.ToInt32(com25.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL PESO MINIMO DE LA CINTA ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta espesor maximo de la bobina
SqlCommand com26 = new SqlCommand(ConsultaEsBobinaMax, OpenCon);
if (com26.ExecuteScalar() != DBNull.Value)
{
espesorbobinamax = Convert.ToInt32(com26.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER EL ESPESOR MAXIMO DE LA BOBINA ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta rebaba max
SqlCommand com27 = new SqlCommand(ConsultaRebabaMax, OpenCon);
if (com27.ExecuteScalar() != DBNull.Value)
{
rebabamax = Convert.ToSingle(com27.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER LA REBABA MAXIMA ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta empaque
SqlCommand com28 = new SqlCommand(ConsultaEmpaque, OpenCon);
if (com28.ExecuteScalar() != DBNull.Value)
{
empaque = Convert.ToString(com28.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER LAS CONDICIONES DEL EMPAQUE ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Convertir consulta tarima
SqlCommand com29 = new SqlCommand(ConsultaTarima, OpenCon);
if (com29.ExecuteScalar() != DBNull.Value)
{
tarima = Convert.ToString(com29.ExecuteScalar());
}
else
{
MessageBox.Show("ERROR AL OBTENER LAS CONDICIONES DE LA TARIMA ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (SqlException ex)
{
MessageBox.Show("ERROR FAVOR DE INFORMAR AL DEPARTAMENTO DE SISTEMAS " + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show("ERROR FAVOR DE INFORMAR AL DEPARTAMENTO DE SISTEMAS " + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
CRreporteslitter crystalreport = new CRreporteslitter();
crystalreport.SetDatabaseLogon("sa", "Jaguar1", "WIN-SERVER\\JAGUARIRA", "SistemaProduccion");
////------------
//TEXTOS
TextObject text = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text159"];
text.Text = LoteInternoJAG;
TextObject text2 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text202"];
text2.Text = Clinete;
TextObject text3 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text203"];
text3.Text = NumeroDeParte;
TextObject text4 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text208"];
text4.Text = TipoMaterial;
TextObject text5 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text209"];
text5.Text = NumeroDeRollo;
TextObject text6 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text210"];
text6.Text = LoteDelCliente;
TextObject text7 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text211"];
text7.Text = PesoRollo.ToString();
TextObject text8 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text212"];
text8.Text = EspesorRollo.ToString();
TextObject text9 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text213"];
text9.Text = AnchoRollo.ToString();
TextObject text26 = (TextObject)crystalreport.ReportDefinition.Sections["Section1"].ReportObjects["Text230"];
text26.Text = IdRecibo.ToString();
TextObject text27 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text231"];
text27.Text = login.VariableSecion.ToString();
TextObject text28 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text93"];
text28.Text = LoteInternoJAG;
TextObject text29 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text94"];
text29.Text = LoteInternoJAG;
TextObject text30 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text97"];
text30.Text = LoteInternoJAG;
TextObject text31 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text107"];
text31.Text = LoteInternoJAG;
TextObject text32 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text108"];
text32.Text = LoteInternoJAG;
TextObject text33 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text109"];
text33.Text = LoteInternoJAG;
TextObject text34 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text110"];
text34.Text = LoteInternoJAG;
TextObject text35 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text111"];
text35.Text = LoteInternoJAG;
TextObject text36 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text112"];
text36.Text = LoteInternoJAG;
TextObject text37 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text113"];
text37.Text = LoteInternoJAG;
TextObject text38 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text114"];
text38.Text = LoteInternoJAG;
TextObject text39 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text131"];
text39.Text = LoteInternoJAG;
TextObject text40 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text132"];
text40.Text = LoteInternoJAG;
TextObject text41 = (TextObject)crystalreport.ReportDefinition.Sections["Section3"].ReportObjects["Text133"];
text41.Text = LoteInternoJAG;
////------------------
EsMas = EspesorRollo + EsMas;
EsMenos = EspesorRollo - EsMenos;
numcin1amas = anchocin1 + numcin1amas;
numcin2amas = anchocin2 + numcin2amas;
numcin3amas = anchocin3 + numcin3amas;
numcin4amas = anchocin4 + numcin4amas;
numcin5amas = anchocin5 + numcin5amas;
numcin1amenos = anchocin1 - numcin1amenos;
numcin2amenos = anchocin2 - numcin2amenos;
numcin3amenos = anchocin3 - numcin3amenos;
numcin4amenos = anchocin4 - numcin4amenos;
numcin5amenos = anchocin5 - numcin5amenos;
////------------------
TextObject text10 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text214"];
text10.Text = EspesorRollo.ToString();
TextObject text14 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text218"];
text14.Text = EsMas.ToString();
TextObject text15 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text219"];
text15.Text = EsMenos.ToString();
TextObject text16 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text215"];
text16.Text = numcin1.ToString();
TextObject text17 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text75"];
text17.Text = numcin2.ToString();
TextObject text18 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text103"];
text18.Text = numcin3.ToString();
TextObject text19 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text119"];
text19.Text = numcin4.ToString();
TextObject text20 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text127"];
text20.Text = numcin5.ToString();
TextObject text21 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text19"];
text21.Text = anchocin1.ToString();
TextObject text22 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text80"];
text22.Text = anchocin2.ToString();
TextObject text23 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text106"];
text23.Text = anchocin3.ToString();
TextObject text24 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text122"];
text24.Text = anchocin4.ToString();
TextObject text25 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text130"];
text25.Text = anchocin5.ToString();
TextObject text42 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text221"];
text42.Text = numcin1amenos.ToString();
TextObject text43 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text36"];
text43.Text = numcin2amenos.ToString();
TextObject text44 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text99"];
text44.Text = numcin3amenos.ToString();
TextObject text45 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text115"];
text45.Text = numcin4amenos.ToString();
TextObject text46 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text123"];
text46.Text = numcin5amenos.ToString();
TextObject text47 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text220"];
text47.Text = numcin1amas.ToString();
TextObject text48 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text78"];
text48.Text = numcin2amas.ToString();
TextObject text49 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text104"];
text49.Text = numcin3amas.ToString();
TextObject text50 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text120"];
text50.Text = numcin4amas.ToString();
TextObject text51 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text128"];
text51.Text = numcin5amas.ToString();
TextObject text52 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text154"];
text52.Text = diametrointerno.ToString();
TextObject text53 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text158"];
text53.Text = pesomaxcin.ToString();
TextObject text54 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text152"];
text54.Text = rebabamax.ToString();
TextObject text55 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text156"];
text55.Text = espesorbobinamax.ToString();
TextObject text56 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text161"];
text56.Text = pesomincin.ToString();
TextObject text57 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text228"];
text57.Text = empaque;
TextObject text58 = (TextObject)crystalreport.ReportDefinition.Sections["Section2"].ReportObjects["Text201"];
text58.Text = tarima;
crystalReportViewer1.ReportSource = crystalreport;
crystalReportViewer1.Refresh();
crystalReportViewer1.RefreshReport();
}
