private void btXoaDH_Click(object sender, EventArgs e)
{
if (dgvdsDonHang.SelectedRows.Count > 0)
{
DataRow dh = ((DataRowView)dgvdsDonHang.SelectedRows[0].DataBoundItem).Row;
dh.Delete();
XuLyDuLieu.ghiBang("ThongTinHoaDon", dsDonHang);
}
}
private void Form1_Load(object sender, EventArgs e)
{
dsDonHang = XuLyDuLieu.docBang("Select * from ThongTinHoaDon");
dsDonHangView = new DataView(dsDonHang);
dgvdsDonHang.DataSource = dsDonHangView;
dsMonAn = XuLyDuLieu.docBang("Select * from dsMon");
dsMonAnView = new DataView(dsMonAn);
dgvdsMonAn.DataSource = dsMonAnView;
dsChiNhanh = XuLyDuLieu.docBang("Select * from dsChiNhanh");
dsChiNhanhView = new DataView(dsChiNhanh);
dgvdsChiNhanh.DataSource = dsChiNhanhView;
}
private void btThemDH_Click(object sender, EventArgs e)
{
DataRow dh = dsDonHang.NewRow();
dh["MA_CN"] = tbMaCN.Text;
dh["Ma_HD"] = tbMaDH.Text;
dh["GIATIEN"] = tbGia.Text;
dsDonHang.Rows.Add(dh);
XuLyDuLieu.ghiBang("ThongTinHoaDon", dsDonHang);
}
private void btSuaDH_Click(object sender, EventArgs e)
{
if (dgvdsDonHang.SelectedRows.Count > 0)
{
DataRow dh = ((DataRowView)dgvdsDonHang.SelectedRows[0].DataBoundItem).Row;
dh["MA_CN"] = tbMaCN.Text;
dh["Ma_HD"] = tbMaDH.Text;
dh["GIATIEN"] = tbGia.Text;
XuLyDuLieu.ghiBang("ThongTinHoaDon", dsDonHang);
}
else
{
MessageBox.Show("Chua Chon Don Hang", "Thong Bao", MessageBoxButtons.OK);
}
}
