private void pbImprimir_Click(object sender, EventArgs e) { if (valExistencias() > 0) { Close(); return; } DialogResult dr = DialogResult.OK; if (validaExisMerc(2)) { FrmSurtir4 frmConf = new FrmSurtir4(); frmConf.lblCom.Text = "El Pedido ya tiene impreso las etiquetas."; frmConf.label1.Text = "¿DESEAS IMPRIMIRLO DE NUEVO?"; dr = frmConf.ShowDialog(); frmConf.Close(); } if (dr == DialogResult.OK) { var query2 = "UPDATE DETALLEPEDIDOMERC SET CANCELADO = 1 WHERE LTRIM(CVE_DOC) = '" + ped.cve_doc.Trim() + "' AND ISNULL(TIPOPAQUETE,'') <> '' AND ISNULL(TotArt,0) = 0 AND ISNULL(CANCELADO,0) = 0"; Program.GetExecute(query2, 51); ActualizaPedido(); cargaPaquetes("CONSEC_EMPAQUE"); cargaDetalleMerc(); // Printer IP Address and communication port string ipAddress = Program.ipImpEti(); int port = 9100; // ZPL Command(s) string ZPLString = GeneraEtiqueta(); try { // Open connection TcpClient client = new TcpClient(); client.Connect(ipAddress, port); // Write ZPL String to connection StreamWriter writer = new StreamWriter(client.GetStream()); writer.Write(ZPLString); writer.Flush(); // Close Connection writer.Close(); client.Close(); } catch (Exception ex) { MessageBox.Show("Impresora no disponible, favor de validar", "SWYRA", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); return; } try { var query = "UPDATE DETALLEPEDIDOMERC SET ULTIMO = 1 WHERE (LTRIM(CVE_DOC) = '" + ped.cve_doc.Trim() + "') AND (CODIGO_BARRA <> '') " + "AND (ISNULL(CANCELADO, 0) = 0) AND (ISNULL(TIPOPAQUETE,'') NOT IN ('', 'ATADOS', 'TARIMA')) AND (ISNULL(ULTIMO,0) = 0) "; Program.GetExecute(query, 8); MessageBox.Show("Impresion Exitosa", "SWYRA", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); pbConcluir.Visible = validaExisMerc(2); } catch (Exception ex) { MessageBox.Show(ex.Message, "SWYRA", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); } } else { pbConcluir.Visible = validaExisMerc(2); } }
private void pbIncompleto_Click(object sender, EventArgs e) { if (ValidaCambios()) { MessageBox.Show("Existen cambios en el PEDIDO, por lo que el último movimiento no se registro, se regresara al menú anterior", "SWYRA", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); this.Close(); return; } if (art != null) { FrmSurtir4 frmConf = new FrmSurtir4(); frmConf.lblCom.Text = "El artículo (" + art.cve_art + ") " + art.descr + " lo consideras INCOMPLETO, con " + art.cantdiferencia + " piezas restantes."; var dr = frmConf.ShowDialog(); frmConf.Close(); if (dr == DialogResult.OK) { var query = "IF EXISTS(SELECT * FROM DETALLEPEDIDOMERC WHERE CVE_DOC = '" + art.cve_doc + "' AND CVE_ART = '" + art.cve_art + "' AND ISNULL(CANCELADO,0) = 0 ) " + "BEGIN DECLARE @MAXCONSEC INT SELECT @MAXCONSEC = CONSEC FROM DETALLEPEDIDOMERC " + "WHERE CVE_DOC = '" + art.cve_doc + "' AND CVE_ART = '" + art.cve_art + "' AND ISNULL(CANCELADO,0) = 0 " + "UPDATE DETALLEPEDIDOMERC SET PEND = " + art.cantdiferencia + " WHERE CVE_DOC = '" + art.cve_doc + "' AND CVE_ART = '" + art.cve_art + "' AND CONSEC = @MAXCONSEC " + "END ELSE BEGIN DECLARE @consec INT SELECT @consec = (ISNULL(MAX(CONSEC),-1) + 1) FROM DETALLEPEDIDOMERC " + "WHERE CVE_DOC = '" + art.cve_doc + "' " + "INSERT DETALLEPEDIDOMERC (CVE_DOC, CONSEC, NUM_PAR, CVE_ART, CODIGO_BARRA, CANT, PEND) " + "VALUES ('" + art.cve_doc + "', @consec, " + art.num_par + ", '" + art.cve_art + "', '', 0, " + art.cantdiferencia + ") END"; Program.GetExecute(query, 100); var df = art.cantdiferencia; if (art.cantsurtido < art.cant) { art.cantdiferencia = art.cant - art.cantsurtido; } else { art.cantdiferencia = 0; } art.cantpendiente = art.cantpendiente + art.cantdiferencia; art.con = (art.sel > 0) ? (int)((art.cant - (int)(art.cantsurtido + art.cantpendiente) - 1) / art.sel) : 0; art.cantdiferencia = art.cant - (art.sel * art.con) - (art.cantsurtido + art.cantpendiente); art.surtido = (art.cant == (art.cantsurtido + art.cantpendiente)); art.ubicacion = art.ubicacion = ((art.sw) ? ((art.masters_ubi == "") ? art.ctrl_alm : art.masters_ubi) : (art.sel == 0 && art.con == 0) ? art.ctrl_alm : ((art.con > 0) ? art.ctrl_alm : ((art.masters_ubi == "") ? art.ctrl_alm : art.masters_ubi))); var orb = orbi.Find(o => o.cve_ubi == art.ubicacion); art.orden = (orb == null) ? 0 : orb.orden; query = "UPDATE DETALLEPEDIDO SET SURTIDO = " + ((art.surtido) ? "1" : "0") + ", CANTPENDIENTE = ISNULL(CANTPENDIENTE,0) + " + df + " WHERE CVE_DOC = '" + art.cve_doc + "' AND NUM_PAR = " + art.num_par.ToString() + " " + "update PEDIDO set PORC_SURTIDO = r.porc from PEDIDO p join ( " + "select CVE_DOC, (sum(CAST(ISNULL(SURTIDO,0) AS float)) / CAST(count(SURTIDO) as float)) * 100.0 porc from DETALLEPEDIDO " + "where CVE_DOC = '" + art.cve_doc + "' group by CVE_DOC) as r ON p.CVE_DOC = r.CVE_DOC "; Program.GetExecute(query, 3); Lote = ""; mostrardet = det.Where(o => o.surtido == false).ToList(); art = mostrardet.FirstOrDefault(); artFirst = art; artLast = mostrardet.LastOrDefault(); lblPendientes.Text = mostrardet.Count.ToString(); cargaDatos(); } } }