示例#1
0
        private void buttonX1_Click(object sender, EventArgs e)
        {
            quitar();
            FRMBuscaOrd nuevo = new FRMBuscaOrd(this);

            nuevo.TopLevel      = false;
            nuevo.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
            nuevo.Parent        = PnlPrincipal;
            nuevo.Show();
            nuevo.BringToFront();
            //AddFormInPanel(new FRMBuscaOrd());
        }
示例#2
0
 private void btnXAdd_Click(object sender, EventArgs e)
 {
     if (!esPendiente)
     {
         foreach (Form frm in Application.OpenForms)
         {
             if (frm.GetType() == typeof(FRMBuscaOrd)) // busca si esta abierto el FRMPacking
             {
                 frm.BringToFront();
                 frm.Visible = true;
             }
         }
     }
     else
     {
         FRMBuscaOrd frm = new FRMBuscaOrd(esPendiente, this, ID_packing);
         frm.Show();
     }
 }
示例#3
0
        public void Ordenes(FRMBuscaOrd f, string orden)
        {
            string consulta = "select v.ID, v.MovID AS Orden, c.Cliente + '  '+ c.Nombre AS Nombre, c.Direccion + ' '+ c.Poblacion as Direccion,ISNULL(a.nombre,'N/A') as Agente from Venta v with(nolock) LEFT JOIN Cte c WITH(NOLOCK) ON c.Cliente = v.Cliente LEFT JOIN Agente a WITH(NOLOCK) ON a.Agente = v.Agente where Mov = 'Orden Surtido'  and v.MovID = '" + orden + "'";

            con = new SqlConnection(cadena());
            SqlCommand com = new SqlCommand(consulta, con);

            con.Open();
            com.CommandType = System.Data.CommandType.Text;
            SqlDataReader dr;

            dr = com.ExecuteReader();
            while (dr.Read())
            {
                if (!f.dgvXOrdenes.Rows.Cast <DataGridViewRow>().Any(row => Convert.ToString(row.Cells["OrdSurt"].Value) == orden))
                {
                    f.dgvXOrdenes.Rows.Add(dr["ID"].ToString(), dr["Orden"].ToString(), dr["Nombre"].ToString(), dr["Direccion"].ToString(), dr["Agente"].ToString(), true);
                }
            }
            con.Close();
        }
示例#4
0
 public void datosgrid(FRMBuscaOrd f)
 {
     f.dgvXOrdenes.Rows.Add(627561, 163140, "ROPA CORPORATIVA ..", "SAN SEBASTIAN , SANTA ANA", "OSCAR ARROYO", true);
 }