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 stockMaximoToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
List_Productos de = new List_Productos();
Conexion w = new Conexion();
SqlDataAdapter sda;
String sql;
sql = "SELECT * FROM Productos WHERE CantProd <= SMinProd ;";
sda = new SqlDataAdapter(sql, w.GetCONN());
sda.Fill(dt);
de.regprodtable.DataSource = dt;
de.ShowDialog();
}
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();
}
