private void button1_Click(object sender, EventArgs e)
{
string proceso = nproceso_box.Text;
try
{
ConexionDB conector = new ConexionDB();
comando = new SqlCommand("SELECT TOP 1 SFruticola_SPSI.dba.variedades.vari_nombre, SFruticola_SPSI.dba.clientes.cli_nombre, SFruticola_SPSI.dba.productores.prod_nombre, convert(nvarchar(6),SFruticola_SPSI.dba.TRA.nlote) AS Lote, SFruticola_SPSI.dba.TRA.proceso FROM SFruticola_SPSI.dba.TRA, SFruticola_SPSI.dba.variedades, SFruticola_SPSI.dba.clientes, SFruticola_SPSI.dba.productores WHERE SFruticola_SPSI.dba.variedades.vari_codigo = SFruticola_SPSI.dba.TRA.vari_codigo AND SFruticola_SPSI.dba.clientes.cli_codigo = SFruticola_SPSI.dba.TRA.cli_codigo AND SFruticola_SPSI.dba.productores.prod_codigo = SFruticola_SPSI.dba.TRA.prod_codigo AND SFruticola_SPSI.dba.TRA.proceso = '" + proceso + "' ORDER BY SFruticola_SPSI.dba.TRA.FechaDigi DESC", ConexionDB.cn2);
SqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
VariedadBox.Text = reader.GetString(0);
ExportadorBox.Text = reader.GetString(1);
ProductorBox.Text = reader.GetString(2);
loteBox.Text = reader.GetString(3);
nproceso_box.Text = reader.GetString(4);
}
conector.Cerrar();
}
catch (Exception ex)
{
///
}
}
private void Print_PrintPage(object sender, PrintPageEventArgs e)
{
//campos necesarios armado de etiqueta
string especie;
string variedad = "";
string calibre = "";
string embalaje = "";
string productor = ProductorBox.Text;
string comuna = "";
ConexionDB conee = new ConexionDB();
string provincia = conee.ObtenerProvincia(productor);
conee.Cerrar();
string region = "";
//string ggn = "00000000000";
string lote_huerto = loteBox.Text;
string proceso_n = nproceso_box.Text;
int turno = 1;
//ConexionDB cone2 = new ConexionDB();
//string fda = cone2.ObtenerFDA(productor);
//cone2.Cerrar();
//string tipo_frio = "AR";
especie = "APPLES";
//if (saposalida.Equals("C1"))
//{
embalaje = EmbalajeBox.Text;
turno = 1;
variedad = VariedadBox.Text;
calibre = CalibreBox.Text;
//}
//FUENTES A USAR
Font prFont = new Font("Arial", 5, FontStyle.Bold);
Font prFont2 = new Font("Arial", 4, FontStyle.Bold);
Font desFont = new Font("Arial", 8, FontStyle.Bold);
Font desFont2 = new Font("Arial", 6, FontStyle.Bold);
////genero numero codigo
//numcode = "20201" + (ultimocodigo + 1).ToString();
//StreamWriter escrito = File.CreateText("ultimaetiq.txt");
//escrito.Write((ultimocodigo + 1).ToString());
//escrito.Flush();
//////Cerramos
//escrito.Close();
//ultimocodigo = ultimocodigo + 1;
//Random Generator = new Random();
//int numerorand, minimo, maximo;
//int anioean = DateTime.Now.Year;
//numcode = anioean + "00000000";
////GENERO DIGITO VERIFICADOR ean13
//int v1;
//int v2;
//int verificador;
//v1 = Convert.ToInt32(Convert.ToString(numcode).Substring(1, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(3, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(5, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(7, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(9, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(11, 1));
//v1 = v1 * 3;
//v2 = Convert.ToInt32(Convert.ToString(numcode).Substring(0, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(2, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(4, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(6, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(8, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(10, 1));
//double redondea;
//double aux;
//redondea = (v1 + v2) / 10;
//aux = redondea;
//redondea = Math.Round(redondea, 0);
//if (redondea > aux)
//{
// redondea -= 1;
//}
//redondea = redondea + 1;
//redondea = redondea * 10;
//verificador = Convert.ToInt32(redondea) - (v1 + v2);
//if (verificador.Equals(10))
//{
// verificador = 0;
//}
//numcode = numcode + Convert.ToString(verificador);
//ConexionDB versiexite = new ConexionDB();
//while (versiexite.Existe_codigo(numcode))
//{
// minimo = 10000000;
// maximo = 99999999;
// numerorand = Generator.Next(minimo, maximo + 1);
// numcode = anioean + Convert.ToString(numerorand);
// //GENERO DIGITO VERIFICADOR ean13
// v1 = Convert.ToInt32(Convert.ToString(numcode).Substring(1, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(3, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(5, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(7, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(9, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(11, 1));
// v1 = v1 * 3;
// v2 = Convert.ToInt32(Convert.ToString(numcode).Substring(0, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(2, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(4, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(6, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(8, 1)) + Convert.ToInt32(Convert.ToString(numcode).Substring(10, 1));
// redondea = (v1 + v2) / 10;
// aux = redondea;
// redondea = Math.Round(redondea, 0);
// if (redondea > aux)
// {
// redondea -= 1;
// }
// redondea = redondea + 1;
// redondea = redondea * 10;
// verificador = Convert.ToInt32(redondea) - (v1 + v2);
// if (verificador.Equals(10))
// {
// verificador = 0;
// }
// numcode = numcode + Convert.ToString(verificador);
//}
//versiexite.Cerrar();
//Barcode128 bcode = new Barcode128
//{
// BarHeight = 60,
// Code = numcode,
// GenerateChecksum = true,
// CodeType = Barcode.CODE128
//};
//Barcode128 bcode2 = new Barcode128
//{
// BarHeight = 35,
// Code = numcode,
// GenerateChecksum = true,
// CodeType = Barcode.CODE128
//};
try
{
//Image img;
//img = bcode2.CreateDrawingImage(Color.Black, Color.White);
//img.RotateFlip(RotateFlipType.Rotate90FlipNone);
//Image img2;
//img2 = bcode.CreateDrawingImage(Color.Black, Color.White);
int yPos = 6;
Image logo;
logo = Image.FromFile("etiq_santacatalina.jpg");
//e.Graphics.DrawImage(logo, 265, yPos + 135, 106, 44);
e.Graphics.DrawImage(logo, 0, yPos + 120, 106, 44);
variedad = "red sensation";
e.Graphics.DrawString(especie.ToUpper() + "-" + variedad.ToUpper(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 40, yPos + 0);
//e.Graphics.DrawString("AR", desFont2, Brushes.Black, 196, yPos + 0);
Font prFont3 = new Font("Arial", 8, FontStyle.Bold);
e.Graphics.DrawString("CSG:", desFont, Brushes.Black, 20, yPos + 24);
e.Graphics.DrawString("GROWER / PRODUCTOR", new Font("Arial", 3, FontStyle.Bold), Brushes.Black, 11, yPos + 38);
e.Graphics.DrawString("TOWNSHIP:", prFont3, Brushes.Black, 80, yPos + 26);
e.Graphics.DrawString("PROVINCE:", prFont3, Brushes.Black, 80, yPos + 40);
//e.Graphics.DrawString("GGN:", prFont, Brushes.Black, 0, yPos + 60);
//ConexionDB cone = new ConexionDB();
ConexionDB obtcsg = new ConexionDB();
e.Graphics.DrawString(obtcsg.ObtenerCSG(productor), new Font("Arial", 15, FontStyle.Bold), Brushes.Black, 0, yPos + 42);
obtcsg.Cerrar();
//cone.Cerrar();
//e.Graphics.DrawString(productor.ToUpper(), prFont, Brushes.Black, 70, yPos + 40);
ConexionDB cone3 = new ConexionDB();
comuna = cone3.ObtenerComuna(productor);
e.Graphics.DrawString(comuna.ToUpper(), prFont3, Brushes.Black, 145, yPos + 26);
cone3.Cerrar();
ConexionDB conex3 = new ConexionDB();
provincia = conex3.ObtenerProvincia(productor);
e.Graphics.DrawString(provincia.ToUpper(), prFont3, Brushes.Black, 145, yPos + 40);
conex3.Cerrar();
//e.Graphics.DrawString("110987", desFont, Brushes.Black, 70, yPos + 26); //provisorio
//e.Graphics.DrawString("SOCIEDAD PACKING SERVICE INGENIERIA LTDA.", prFont, Brushes.Black, 70, yPos + 40); //provisorio
//e.Graphics.DrawString("TENO - CURICO", prFont, Brushes.Black, 70, yPos + 50); //provisorio
//e.Graphics.DrawString(ggn, prFont, Brushes.Black, 70, yPos + 60);
ConexionDB cone5 = new ConexionDB();
e.Graphics.DrawString("REGION: ", prFont3, Brushes.Black, 80, yPos + 54);
region = cone5.ObtenerRegion(productor);
e.Graphics.DrawString(region, prFont3, Brushes.Black, 145, yPos + 54);
cone5.Cerrar();
e.Graphics.DrawString("NET WEIGHT W.P.", prFont, Brushes.Black, 300, yPos + 5);
string kilos = "5,0";
if (embalaje.Contains("25K"))
{
kilos = "2,5";
}
if (embalaje.Contains("9K"))
{
kilos = "9";
}
if (embalaje.Contains("10K"))
{
kilos = "10";
}
if (embalaje.Contains("18K"))
{
kilos = "18";
}
if (embalaje.Contains("19K"))
{
kilos = "19";
}
e.Graphics.DrawString(embalaje.TrimEnd().TrimStart() + " - " + kilos + " Kg.", prFont, Brushes.Black, 300, yPos + 12);
int diasemana;
System.Globalization.CultureInfo norwCulture = System.Globalization.CultureInfo.CreateSpecificCulture("es");
System.Globalization.Calendar cal = norwCulture.Calendar;
diasemana = cal.GetWeekOfYear(DateTime.Now, norwCulture.DateTimeFormat.CalendarWeekRule, norwCulture.DateTimeFormat.FirstDayOfWeek);
e.Graphics.DrawString("SEM: ", prFont, Brushes.Black, 300, yPos + 23);
e.Graphics.DrawString(diasemana.ToString(), prFont, Brushes.Black, 333, yPos + 23);
//e.Graphics.DrawString("TIME: ", prFont, Brushes.Black, 300, yPos + 30);
//e.Graphics.DrawString(DateTime.Now.ToString("HH:mm:ss"), prFont, Brushes.Black, 333, yPos + 30);
e.Graphics.DrawString("N° PROCESO:", new Font("Arial", 7, FontStyle.Bold), Brushes.Black, 298, yPos + 40);
if (proceso_n.Length.Equals(1))
{
e.Graphics.DrawString(proceso_n, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, 328, yPos + 53);
}
if (proceso_n.Length.Equals(2))
{
e.Graphics.DrawString(proceso_n, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, 323, yPos + 53);
}
if (proceso_n.Length.Equals(3))
{
e.Graphics.DrawString(proceso_n, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, 318, yPos + 53);
}
if (proceso_n.Length.Equals(4))
{
e.Graphics.DrawString(proceso_n, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, 315, yPos + 53);
}
//=================
//if (calibre.Contains("D")) { e.Graphics.DrawString("DARK", new Font("Arial Black", 14, FontStyle.Bold), Brushes.Black, 200, yPos + 56); }
//else
//{
// //if (calibre.Contains("TC")) { e.Graphics.DrawString(" ", new Font("Arial Black", 12, FontStyle.Bold), Brushes.Black, 200, yPos + 56); }
// e.Graphics.DrawString("LIGHT", new Font("Arial Black", 13, FontStyle.Bold), Brushes.Black, 200, yPos + 56);
//}
e.Graphics.DrawString("DATE: ", new Font("Arial", 8, FontStyle.Bold), Brushes.Black, 160, yPos + 130);
//e.Graphics.DrawString("LOTE: ", prFont, Brushes.Black, 222, yPos + 57);
//e.Graphics.DrawString("PROC N°: ", prFont, Brushes.Black, 222, yPos + 57);
e.Graphics.DrawString(FechaBox.Value.ToString("dd-MM-yyyy"), new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 135, yPos + 142);
//e.Graphics.DrawString(vaciado_lote, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, 255, yPos + 51);
//e.Graphics.DrawString(proceso_n, prFont, Brushes.Black, 255, yPos + 57);
Font desFont3 = new Font("Verdana", 22, FontStyle.Bold);
Font desFont4 = new Font("Verdana", 14, FontStyle.Bold);
//int exis = 150;
//OBTENGO SIGLA CALIBRE
//Cargar_siglaymm(calidad);
//////////Sigla_clasificacion = "LL";
//////////Calibre_mm = "< 23,9 mm";
//if (Sigla_clasificacion.Length.Equals(2))
//{
// e.Graphics.DrawString(Sigla_clasificacion, desFont3, Brushes.Black, exis + 2, yPos + 17);
//}
//else if (Sigla_clasificacion.Length.Equals(3))
//{
// e.Graphics.DrawString(Sigla_clasificacion, desFont4, Brushes.Black, exis + 6, yPos + 17);
//}
//else if (Sigla_clasificacion.Length.Equals(4))
//{
// e.Graphics.DrawString(Sigla_clasificacion, desFont3, Brushes.Black, exis - 4, yPos + 17);
//}
//else if (Sigla_clasificacion.Length.Equals(1))
//{
// e.Graphics.DrawString(Sigla_clasificacion, desFont3, Brushes.Black, exis + 12, yPos + 17);
//}
//if (calibre.Replace("D", "").Length.Equals(4))
//{
// e.Graphics.DrawString(calibre.Replace("D", ""), new Font("Arial Black", 24, FontStyle.Bold), Brushes.Black, exis + 24, yPos + 5);
//}
//if (calibre.Replace("D", "").Length.Equals(2))
//{
// e.Graphics.DrawString(calibre.Replace("D", ""), new Font("Arial Black", 35, FontStyle.Bold), Brushes.Black, exis + 43, yPos - 3);
//}
//else if (calibre.Replace("D", "").Length.Equals(3))
//{
// e.Graphics.DrawString(calibre.Replace("D", ""), desFont4, Brushes.Black, exis + 8, yPos - 3);
//}
//else if (calibre.Replace("D", "").Length.Equals(4))
//{
// e.Graphics.DrawString(calibre.Replace("D", ""), desFont3, Brushes.Black, exis - 4, yPos - 3);
//}
//else if (calibre.Replace("D", "").Length.Equals(1))
//{
// e.Graphics.DrawString(calibre.Replace("D", ""), new Font("Arial Black", 35, FontStyle.Bold), Brushes.Black, exis + 60, yPos - 3);
//}
e.Graphics.DrawString("CSP:", desFont, Brushes.Black, 20, yPos + 72);
e.Graphics.DrawString("PACKING BY / EMPACADORA", new Font("Arial", 3, FontStyle.Bold), Brushes.Black, 7, yPos + 86);
e.Graphics.DrawString("176227", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, 0, yPos + 90);
e.Graphics.DrawString("TOWNSHIP:", prFont3, Brushes.Black, 80, yPos + 74);
//e.Graphics.DrawString("SOCIEDAD PACKING SERVICE INGENIERIA", prFont, Brushes.Black, 70, yPos + 86);
e.Graphics.DrawString("PROVINCE:", prFont3, Brushes.Black, 80, yPos + 88);
e.Graphics.DrawString("REGION: ", prFont3, Brushes.Black, 80, yPos + 102);
e.Graphics.DrawString("CURICO", prFont3, Brushes.Black, 145, yPos + 74);
e.Graphics.DrawString("CURICO", prFont3, Brushes.Black, 145, yPos + 88);
e.Graphics.DrawString("VII", prFont3, Brushes.Black, 145, yPos + 102);
//e.Graphics.DrawString(provincia.ToUpper()+" - "+comuna.ToUpper(), prFont, Brushes.Black, 70, yPos + 96);
//e.Graphics.DrawString("FDA:", prFont, Brushes.Black, 0, yPos + 106);
//e.Graphics.DrawString(fda, prFont, Brushes.Black, 70, yPos + 106);
//e.Graphics.DrawString("CAT-1", new Font("Arial", 19, FontStyle.Bold), Brushes.Black, 15, yPos + 135);
e.Graphics.DrawString("CLASS 1 PRODUCE OF CHILE", prFont, Brushes.Black, 5, yPos + 170);
//e.Graphics.DrawString("EXPORTED BY: ______", prFont2, Brushes.Black, 182, yPos + 136);
//e.Graphics.DrawString("RUT: xx.xxx.xxx-x CSE: xxxxx", prFont2, Brushes.Black, 212, yPos + 145);
//e.Graphics.DrawString("FUNDO xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", prFont2, Brushes.Black, 180, yPos + 154);
//
//if (calibre.Equals("TC")) { e.Graphics.DrawString("COMERCIAL", new Font("Arial", 9, FontStyle.Bold), Brushes.Black, 220, yPos + 85); }
//else { e.Graphics.DrawString("CAT-1", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 235, yPos + 85); }
e.Graphics.DrawString("EXPORTED BY:", new Font("Arial", 8, FontStyle.Bold), Brushes.Black, 245, yPos + 120);
ConexionDB getexp = new ConexionDB();
string exp_abreviada = ExportadorBox.Text;
exp_abreviada = exp_abreviada.Replace("EXPORTADORA", "EXP.");
exp_abreviada = exp_abreviada.Replace("EXPORTADOR", "EXP.");
exp_abreviada = exp_abreviada.Replace("COMERCIAL", "COM.");
exp_abreviada = exp_abreviada.Replace("COMERCIALIZADORA", "COM.");
exp_abreviada = exp_abreviada.Replace("PRODUCTOR", "PROD.");
e.Graphics.DrawString(exp_abreviada, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, 245, yPos + 140);
getexp.Cerrar();
e.Graphics.DrawString("CSE:", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 245, yPos + 160);
ConexionDB obtCSE = new ConexionDB();
e.Graphics.DrawString(obtCSE.ObtenerNumeroCSE(ExportadorBox.Text), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 285, yPos + 160);
obtCSE.Cerrar();
//e.Graphics.DrawString("TURNO:", prFont2, Brushes.Black, 302, yPos + 74);
//e.Graphics.DrawString(turno.ToString(), prFont2, Brushes.Black, 332, yPos + 74);
//e.Graphics.DrawString("LINEA:", prFont2, Brushes.Black, 303, yPos + 85);
//e.Graphics.DrawString("1", prFont2, Brushes.Black, 332, yPos + 85);
e.Graphics.DrawString("SALIDA", new Font("Arial", 5, FontStyle.Bold), Brushes.Black, 317, yPos + 74);
Random rnd2 = new Random();
int salida = rnd2.Next(1, 28);
int impre = 1;
if (salida.Equals(1) || salida.Equals(2))
{
impre = 1;
}
if (salida.Equals(3) || salida.Equals(4))
{
impre = 2;
}
if (salida.Equals(5) || salida.Equals(6))
{
impre = 3;
}
if (salida.Equals(7) || salida.Equals(8))
{
impre = 4;
}
if (salida.Equals(9) || salida.Equals(10))
{
impre = 5;
}
if (salida.Equals(11) || salida.Equals(12))
{
impre = 6;
}
if (salida.Equals(13) || salida.Equals(14))
{
impre = 7;
}
if (salida.Equals(15) || salida.Equals(16))
{
impre = 8;
}
if (salida.Equals(17) || salida.Equals(18))
{
impre = 9;
}
if (salida.Equals(19) || salida.Equals(20))
{
impre = 10;
}
if (salida.Equals(21) || salida.Equals(22))
{
impre = 11;
}
if (salida.Equals(23) || salida.Equals(24))
{
impre = 12;
}
if (salida.Equals(25) || salida.Equals(26))
{
impre = 13;
}
if (salida.Equals(27) || salida.Equals(28))
{
impre = 14;
}
if (salida > 9)
{
e.Graphics.DrawString(salida.ToString(), new Font("Arial", 6, FontStyle.Bold), Brushes.Black, 325, yPos + 82);
}
else
{
e.Graphics.DrawString(salida.ToString(), new Font("Arial", 6, FontStyle.Bold), Brushes.Black, 327, yPos + 82);
}
e.Graphics.DrawString("IMPRESORA", new Font("Arial", 5, FontStyle.Bold), Brushes.Black, 310, yPos + 96);
if (impre > 9)
{
e.Graphics.DrawString(impre.ToString(), new Font("Arial", 6, FontStyle.Bold), Brushes.Black, 325, yPos + 104);
}
else
{
e.Graphics.DrawString(impre.ToString(), new Font("Arial", 6, FontStyle.Bold), Brushes.Black, 329, yPos + 104);
}
//e.Graphics.DrawString("SALIDA:", prFont2, Brushes.Black, 302, yPos + 96);
//e.Graphics.DrawString(saposalida, prFont2, Brushes.Black, 332, yPos + 96);
//e.Graphics.DrawString("IMP:", prFont2, Brushes.Black, 302, yPos + 107);
//if(impresora.Length > 10) { e.Graphics.DrawString(impresora.Substring(9, 2), prFont2, Brushes.Black, 332, yPos + 107); }
//else { e.Graphics.DrawString(impresora.Substring(9, 1), prFont2, Brushes.Black, 332, yPos + 107); }
//'codigo vertical CODE-128
//e.Graphics.DrawImage(img, 343, yPos + 15);
//'codigo horizontal EAN13
//e.Graphics.DrawImage(img2, 115, yPos + 118);
Font prFontx = new Font("Arial", 6, FontStyle.Bold);
//SolidBrush myBrush = new System.Drawing.SolidBrush(System.Drawing.Color.White);
//e.Graphics.FillRectangle(myBrush, new Rectangle(153, yPos + 172, 54, 10));
//e.Graphics.DrawString(numcode, prFont, Brushes.Black, 153, yPos + 173);
//'GUARDO LA ETIQUETA EN LA BASE DE DATOS
string cla = "";
//if (calibre.Equals("TC"))
//{
// cla = "COM";
//}
//else
//{
// if (calibre.Contains("D")) { cla = "DARK"; }
// else { cla = "LIGHT"; }
//}
//if (calibre.Equals("L")) { cla = "LIGHT"; }
//if (calibre.Equals("LD")) { cla = "DARK"; }
//if (calibre.Equals("XL")) { cla = "LIGHT"; }
//if (calibre.Equals("XLD")) { cla = "DARK"; }
//if (calibre.Equals("J")) { cla = "LIGHT"; }
//if (calibre.Equals("JD")) { cla = "DARK"; }
//if (calibre.Equals("SJ")) { cla = "LIGHT"; }
//if (calibre.Equals("SJD")) { cla = "DARK"; }
//if (calibre.Equals("P")) { cla = "LIGHT"; }
//if (calibre.Equals("PD")) { cla = "DARK"; }
//if (calibre.Equals("SP")) { cla = "LIGHT"; }
//if (calibre.Equals("SPD")) { cla = "DARK"; }
//if (calibre.Equals("SG")) { cla = "LIGHT"; }
//if (calibre.Equals("SGD")) { cla = "DARK"; }
//sql_masivo += "INSERT INTO etiquetado_system.dbo.etiqueta(codigo_interno, codigo_ean13, especie, variedad, clasificacion, calibre, embalaje, productor, categoria, lote_huerto, proceso_n, cuartel, salida, tipo_frio, turno, fecha, fda, ggn, paso1, codigo_tarja, cuadrilla) "
// + "VALUES('" + numcode + "', '" + numcode + "', 'APPLES', '" + variedad.ToUpper() + "', '" + cla + "', '" + calibre.Replace("D", "").ToUpper() + "', '" + embalaje.ToUpper() + "', '" + productor + "', 'CAT-1', '" + lote_huerto + "', '" + proceso_n + "', NULL, 'Salida " + salida + "', 'AR', 1, '" + FechaBox.Value.ToString("yyyy-MM-dd") + "', '00', '00', 0, NULL, NULL);";
//ConexionDB getiq = new ConexionDB();
//getiq.GuardarEtiqueta(numcode, "CHERRIES", variedad.ToUpper(), cla, calibre.Replace("D", "").ToUpper(), embalaje.ToUpper(), productor, "CAT-1", lote_huerto, proceso_n, "Salida " + salidaa, "AR", turno, FechaBox.Value.ToString("yyyy-MM-dd"), "00", "00");
//getiq.Cerrar();
//'IMPRIMO LINEAS DEL DISEÑO
Pen blackPen1 = new Pen(Color.Black, 1);
Pen blackPen2 = new Pen(Color.Black, 2);
//'horizontales
e.Graphics.DrawLine(blackPen2, new Point(295, yPos + 22), new Point(370, yPos + 22));
e.Graphics.DrawLine(blackPen2, new Point(295, yPos + 70), new Point(370, yPos + 70));
e.Graphics.DrawLine(blackPen2, new Point(0, yPos + 70), new Point(295, yPos + 70));
e.Graphics.DrawLine(blackPen2, new Point(0, yPos + 115), new Point(370, yPos + 115));
//'verticales
//e.Graphics.DrawLine(blackPen2, new Point(160, yPos + 116), new Point(160, yPos + 22));
e.Graphics.DrawLine(blackPen2, new Point(295, yPos + 116), new Point(295, yPos + 0));
e.Graphics.DrawLine(blackPen2, new Point(370, yPos + 116), new Point(370, yPos + 0));
}
catch (Exception ex)
{
MetroFramework.MetroMessageBox.Show(this, "Hubo un error en generar el codigo de barra. " + ex.ToString(), "INFO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//' indicamos que ya no hay nada más que imprimir
//' (el valor predeterminado de esta propiedad es False)
e.HasMorePages = false;
}
