private void btnOKKH_Click(object sender, EventArgs e) { if (txtMaKH.Text != "" || txtSDTKH.Text != "" || txtDCKH.Text != "" || txtTenKH.Text != "") { tb_KhachHangDBO obj = new tb_KhachHangDBO(); obj.MaKhachHang = txtMaKH.Text; obj.TenKhachHang = txtTenKH.Text; obj.SDT = txtSDTKH.Text; obj.DiaChi = txtDCKH.Text; if (flag == "them") { if (tb_KhachHangBLL.kiemTraTonTai(obj.MaKhachHang) == 1) { MessageBox.Show("Thông Báo Đã tồn tại!"); } else { tb_KhachHangBLL.them(obj); MessageBox.Show("Thêm thành công!"); this.Dispose(); } } else if (flag == "sua") { tb_KhachHangBLL.sua(obj); MessageBox.Show("Sửa thành công!"); this.Dispose(); } } }
public static void sua(tb_KhachHangDBO obj) { tb_KhachHangDAL.sua(obj); }
public static void sua(tb_KhachHangDBO obj) { Unility.ExcuteSQL(string.Format("UPDATE tb_KhachHang SET TenKhachHang = N'{1}' ,DiaChi = N'{2}',SDT = N'{3}' WHERE MaKhachHang = N'{0}'", obj.MaKhachHang, obj.TenKhachHang, obj.DiaChi, obj.SDT)); }
public static void them(tb_KhachHangDBO obj) { tb_KhachHangDAL.them(obj); }
public static void them(tb_KhachHangDBO obj) { Unility.ExcuteSQL(string.Format("INSERT INTO tb_KhachHang (MaKhachHang ,TenKhachHang ,DiaChi ,SDT) VALUES (N'{0}',N'{1}',N'{2}',N'{3}')", obj.MaKhachHang, obj.TenKhachHang, obj.DiaChi, obj.SDT)); }