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());
}
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();
}
}
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();
}
public void datosgrid(FRMBuscaOrd f)
{
f.dgvXOrdenes.Rows.Add(627561, 163140, "ROPA CORPORATIVA ..", "SAN SEBASTIAN , SANTA ANA", "OSCAR ARROYO", true);
}
