void load_nguyen_lieu()
{
DAONguyenLieu nl = new DAONguyenLieu();
dtg_nguyenlieu_theongay.DataSource = nl.getNguyenLieutheongay();
dtg_nguyenlieu_theongay.AllowUserToAddRows = false;
dtg_nguyenlieu_theongay.ReadOnly = false;
txt_tongtien.text = nl.gettonggia().ToString();
}
private void btn_luugia_Click(object sender, EventArgs e)
{
try
{
DAONguyenLieu nl = new DAONguyenLieu();
DataTable ct = new DataTable();
ct.Columns.Add(new DataColumn("manl", typeof(int)));
ct.Columns.Add(new DataColumn("gia", typeof(float)));
foreach (DataGridViewRow row in dtg_nguyenlieu_theongay.Rows)
{
ct.Rows.Add((int)row.Cells[0].Value, float.Parse(row.Cells[2].Value.ToString()));
}
nl.updategia_nguyenlieu(ct);
load_nguyen_lieu();
}
catch (Exception ex) { MessageBox.Show(ex + ""); }
}
void loadnguyenlieu()
{
DAONguyenLieu nl = new DAONguyenLieu();
DataTable tb1 = new DataTable();
tb1 = nl.getNguyenLieu();
tb1.Columns.Add("check", typeof(bool));
foreach (DataRow row in tb1.Rows)
{
row["check"] = false;
}
tb1.Columns.Add("soluong", typeof(float));
foreach (DataRow row in tb1.Rows)
{
row["soluong"] = 0;
}
dataGridView2.DataSource = tb1;
dataGridView2.AllowUserToAddRows = false;
}
