Esempio n. 1
0
        private void btOFL_Click(object sender, EventArgs e)
        {
            string vOF = "";

            try { vOF = grOFL.Rows[grOFL.CurrentCell.RowIndex].Cells["IdOF"].Value.ToString(); }
            catch { }
            if (vOF != "")
            {
                frmOF frm = new frmOF();
                frm.vOFExt = vOF;
                frm.ShowDialog();
            }
        }
Esempio n. 2
0
        private void grMat_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int    vCol   = e.ColumnIndex;
            int    vFil   = e.RowIndex;
            string vCampo = grMat.Columns[vCol].Name;
            string vProd  = grMat.CurrentRow.Cells["Producto"].Value.ToString();

            if (vCampo == "CanEnOF")
            {
                string vSql = cConstantes.SQL_OFL_Lista_CanPen;
                vSql = vSql.Replace("[?vbCr]", cConstantes.vbCtr.ToString());
                vSql = vSql.Replace("[?vbLf]", cConstantes.vbLF.ToString());
                vSql = vSql.Replace("[?Emp]", cParamXml.Emp.ToString());
                vSql = vSql.Replace("[?Prod]", vProd);


                string vTabla = "GC_OrdenProd";
                string vWhere = " where Empresa = [?Emp] and (Estado = 'Lanzada' or Estado = 'Producción') ";
                vWhere = "";
                string vRes = cUtil.fncLista(vTabla, cParamXml.strConecProduc_Prueb, "IdOF", "", vWhere, vSql, "", false, "", "", "", "SQL");

                if (vRes != "")
                {
                    frmOF frm = new frmOF();
                    frm.vOFExt = vRes;
                    frm.ShowDialog();
                }
            }

            if (vCampo == "NeceTot")
            {
                string vSql = cConstantes.SQL_Prep_Nece;
                vSql = vSql.Replace("[?vbCr]", cConstantes.vbCtr.ToString());
                vSql = vSql.Replace("[?vbLf]", cConstantes.vbLF.ToString());
                vSql = vSql.Replace("[?Emp]", cParamXml.Emp.ToString());
                vSql = vSql.Replace("[?Prod]", vProd);


                string vTabla = "GC_CabPrepEntregas";
                string vWhere = "";
                string vRes   = cUtil.fncLista(vTabla, cParamXml.strConecProduc_Prueb, "IdOF", "", vWhere, vSql, "", false, "", "", "", "SQL");

                if (vRes != "")
                {
                    frmOF frm = new frmOF();
                    frm.vOFExt = vRes;
                    frm.ShowDialog();
                }
            }
        }
Esempio n. 3
0
        private void btOFL_Click(object sender, EventArgs e)
        {
            string vProd = "";

            try { vProd = grMat.CurrentRow.Cells["Producto"].Value.ToString(); }
            catch { return; }
            if (vProd == "")
            {
                return;
            }


            string vMen = "Se creara una OFL para el producto: '" + vProd + "' .Esta seguro?";
            string vTit = "Preparaciones";

            if (MessageBox.Show(vMen, vTit, MessageBoxButtons.YesNo) == DialogResult.No)
            {
                return;
            }


            string vWhere = " Empresa = " + cParamXml.Emp + " and Producto = N'" + vProd + "'";
            string vDes   = cUtil.fncTraeCampo("Descripción", "GC_ProductoAnexos", vWhere, "", cParamXml.strConecProduc_Prueb, "SQL", true);

            if (vDes == "***Inex***")
            {
                vDes = "";
            }

            if (vProd != "")
            {
                frmOF frm = new frmOF();
                frm.vProdNuevo    = vProd;
                frm.vDesProdNuevo = vDes;
                frm.vOFNueva      = true;
                frm.ShowDialog();
            }
        }