private void HoaDon_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = BUS_HOADON.showListHoaDon(); dgHD.DataSource = dt; dgHD2.DataSource = dt; DataTable sp = new DataTable(); sp = BUS_SANPHAM.LoadListSP(); cmbSP1.DataSource = sp; cmbSP1.DisplayMember = "tenSP"; cmbSP1.ValueMember = "maSP"; cmbSP2.DataSource = sp; cmbSP2.DisplayMember = "tenSP"; cmbSP2.ValueMember = "maSP"; DataTable kh = new DataTable(); kh = BUS_KHACHHANG.showListKhachHang(); cmbKH1.DataSource = kh; cmbKH1.DisplayMember = "tenKH"; cmbKH1.ValueMember = "maKH"; cmbKH2.DataSource = kh; cmbKH2.DisplayMember = "tenKH"; cmbKH2.ValueMember = "maKH"; }
private void BtnSearch_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = BUS_KHACHHANG.SearchKH(txtSearch.Text); dgKH.DataSource = dt; }
private void BtnSua_Click(object sender, EventArgs e) { KhachHang kh = new KhachHang(txtMa.Text, txtTen.Text, txtSDT.Text, txtEmail.Text, txtDiaChi.Text); BUS_KHACHHANG.UpdateKH(txtMa.Text, kh); QuanLyKhachHang_Load(sender, e); }
private void QuanLyKhachHang_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = BUS_KHACHHANG.showListKhachHang(); dgKH.DataSource = dt; }
private void BtnXoa_Click(object sender, EventArgs e) { DialogResult dlr = MessageBox.Show("Bạn có chắc chắn muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo); if (dlr == DialogResult.Yes) { BUS_KHACHHANG.DeleteKH(txtMa.Text); QuanLyKhachHang_Load(sender, e); } }
private void btnXoaKH_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { BUS_KHACHHANG.Xoa_KhachHang(txtMaKH.Text); DialogResult dr = MessageBox.Show("Xoa thành công"); if (dr == DialogResult.OK) { loaddata(); } } catch (Exception ex) { MessageBox.Show("Lỗi" + ex.ToString()); } }
private void btnSuaKH_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { KhachHangInfo kh = new KhachHangInfo(txtMaKH.Text, txtHoTen.Text, txtDiaChi.Text, txtDienThoai.Text); BUS_KHACHHANG.Sua_KhachHang(kh); DialogResult dr = MessageBox.Show("Sua thành công"); if (dr == DialogResult.OK) { loaddata(); } } catch (Exception ex) { MessageBox.Show("Lỗi" + ex.ToString()); } }
public void loaddata() { dt = BUS_KHACHHANG.HienThi_KhachHang_All(); grcKhachHang.DataSource = dt; }