private void regboton_Click(object sender, EventArgs e) { List_Productos rp = new List_Productos(); rp.ShowDialog(); citext.Text = ""; citext.ForeColor = SystemColors.WindowText; citext.Font = new Font(citext.Font, FontStyle.Regular); citext.Text = rp.codUser.ToString(); }
private void listProd_Click(object sender, EventArgs e) { List_Productos le = new List_Productos(); le.ShowDialog(); buscarprod.Text = ""; buscarprod.ForeColor = SystemColors.WindowText; buscarprod.Font = new Font(buscarprod.Font, FontStyle.Regular); buscarprod.Text = le.codUser.ToString(); }
private void productosSuspendidosToolStripMenuItem_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); List_Productos de = new List_Productos(); Conexion r = new Conexion(); SqlDataAdapter sda; String sql; sql = "SELECT * FROM Productos WHERE EstadoProd = 'Suspendido' ;"; sda = new SqlDataAdapter(sql, r.GetCONN()); sda.Fill(dt); de.regprodtable.DataSource = dt; }
private void puntoDePedidoToolStripMenuItem_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); List_Productos de = new List_Productos(); Conexion t = new Conexion(); SqlDataAdapter sda; String sql; sql = "SELECT * FROM Productos WHERE CantProd <= SMinProd OR CantProd <= SMinProd+10 ;"; sda = new SqlDataAdapter(sql, t.GetCONN()); sda.Fill(dt); de.regprodtable.DataSource = dt; }
private void stockMáximoToolStripMenuItem_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); List_Productos de = new List_Productos(); Conexion r = new Conexion(); SqlDataAdapter sda; String sql; sql = "SELECT * FROM Productos WHERE CantProd >= SMaxProd ;"; sda = new SqlDataAdapter(sql, r.GetCONN()); sda.Fill(dt); de.regprodtable.DataSource = dt; }
private void toolStripMenuItem9_Click(object sender, EventArgs e) { List_Productos lbd = new List_Productos(); DataTable dt = new DataTable(); Conexion r = new Conexion(); SqlDataAdapter sda; String sql; sql = "SELECT * FROM Productos WHERE fnProd <= GETDATE() ;"; sda = new SqlDataAdapter(sql, r.GetCONN()); sda.Fill(dt); lbd.regprodtable.DataSource = dt; lbd.ShowDialog(); }