private void btImprimir_Click(object sender, EventArgs e) { //System.Drawing.Image objImage = System.Drawing.Image.FromFile(pic1.ImageLocation); DataRow drCli; string vWhere = " Empresa = " + cParamXml.Emp + " and codcli = '" + txCodCli.Text + "' "; drCli = cUtil.fncTraeCampos("GC_ClienteProducto", vWhere, cParamXml.strConec, "SQL"); string vEtiCli = ""; string vEt = ""; if (drCli != null) { vEt = drCli["EtiCli"].ToString(); if (vEt == "1") { vEtiCli = drCli["EtiDes"].ToString(); if (vEtiCli == "") { vEtiCli = txNomCli.Text; } } } string vLogoCaja = cProducto.Articulo.fncTraeC("LogoCaja", txProd.Text); bool vConLogo = true; if (vLogoCaja == "0") { vConLogo = false; } dtsEtiCaja dts = new dtsEtiCaja(); DataTable dt = new DataTable(); dt = dts.Tables["dtEtiCaja"].Clone(); DataRow dr = dt.NewRow(); dr.BeginEdit(); dr["Producto"] = txProd.Text; dr["Cliente"] = txNomCli.Text; dr["Pieza"] = txProdCli.Text; dr["DesProd"] = txNomProd.Text; dr["Lote"] = txLote.Text; if (txPiezasCaja.Text == "") { txPiezasCaja.Text = "0"; } dr["PiezasCaja"] = Convert.ToInt32(txPiezasCaja.Text); dr["Fecha"] = dateFecha.Value; dr["Operario"] = txOper.Text; if (txCaja.Text == "") { txCaja.Text = "0"; } dr["Caja"] = txCaja.Text; dr["Imagen"] = cUtil.imageToByteArray(pic1.Image); dr["EtiCliente"] = vEtiCli; dr.EndEdit(); dt.Rows.Add(dr); int vAncho = 1; int vAlto = 1; if (pic1.Image != null) { vAncho = pic1.Image.Width; vAlto = pic1.Image.Height; } //if (vAncho >= vAlto) //{ // vAlto = vAlto * 720 / vAncho; // vAncho = 720; //} //else //{ // vAncho = vAncho * 840 / vAlto; // vAlto = 840; //} cInformes.Imp = (cParamXml.Imp == "True") ? true : false; cInformes.sbrEtiCaja(dt, vAlto, vAncho, vEt, vConLogo); }
private void btPrinEti_Click(object sender, EventArgs e) { if (grProduc.Rows.Count == 0) { MessageBox.Show("No hay Cajas/Bolsas para imprimir"); return; } if (grProduc.SelectedRows.Count == 0) { MessageBox.Show("No se selecionado ninguna fila para imprimir"); return; } string vNomCli = lbNomCli.Text; string vProd = txProd.Text; string vNomProd = lbNomProd.Text; string vNOF = txOF.Text; string vProdCli = txProdCli.Text; DataRow drCli; string vWhere = " Empresa = " + cParamXml.Emp + " and codcli = '" + txCodCli.Text + "' "; drCli = cUtil.fncTraeCampos("GC_ClienteProducto", vWhere, cParamXml.strConec, "SQL"); string vLogoCaja = cProducto.Articulo.fncTraeC("LogoCaja", vProd); bool vConLogo = true; if (vLogoCaja == "0") { vConLogo = false; } string vEtiCli = ""; string vEt = ""; if (drCli != null) { vEt = drCli["EtiCli"].ToString(); if (vEt == "1") { vEtiCli = drCli["EtiDes"].ToString(); if (vEtiCli == "") { vEtiCli = vNomCli; } } } foreach (DataGridViewRow dr in grProduc.SelectedRows) { string vFecha = Convert.ToDateTime(dr.Cells["Fecha"].Value.ToString()).ToShortDateString(); string vOper = cUtil.Piece(dr.Cells["IdOper"].Value.ToString(), "-", 1); string vCaja = dr.Cells["NumCajaBolsa"].Value.ToString(); string vPiezasCaja = dr.Cells["CanProd"].Value.ToString(); string vTipo = dr.Cells["Tipo"].Value.ToString(); string vCodigo = dr.Cells["codigo"].Value.ToString(); string vsNumCajaBolsa = ""; if (vTipo != "B") { vsNumCajaBolsa = vCaja.ToString(); } else { vsNumCajaBolsa = vCodigo; } dtsEtiCaja dts = new dtsEtiCaja(); DataTable dt = new DataTable(); dt = dts.Tables["dtEtiCaja"].Clone(); DataRow dr2 = dt.NewRow(); dr2.BeginEdit(); dr2["Producto"] = vProd; dr2["Cliente"] = vNomCli; dr2["Pieza"] = vProdCli; dr2["DesProd"] = vNomProd; dr2["Lote"] = vNOF; if (vPiezasCaja == "") { vPiezasCaja = "0"; } dr2["PiezasCaja"] = Convert.ToInt32(vPiezasCaja); dr2["Fecha"] = Convert.ToDateTime(dr.Cells["Fecha"].Value.ToString()); dr2["Operario"] = vOper; if (vsNumCajaBolsa == "") { vsNumCajaBolsa = "0"; } dr2["Caja"] = vsNumCajaBolsa; dr2["Imagen"] = cUtil.imageToByteArray(picFoto.Image); dr2["EtiCliente"] = vEtiCli; dr2.EndEdit(); dt.Rows.Add(dr2); int vAncho = 1; int vAlto = 1; if (picFoto.Image != null) { vAncho = picFoto.Image.Width; vAlto = picFoto.Image.Height; } cInformes.Imp = (cParamXml.Imp == "True") ? true : false; cInformes.sbrEtiCaja(dt, vAlto, vAncho, vEt, vConLogo); //cInformes.sbrEtiCaja(vNomCli, vProd, vNomProd, vNOF, vPiezasCaja, vFecha, vOper, vCaja,vProdCli); } }