public void ThemNSX(string tennsx) { string sqlQuery = string.Format("Insert into NHASANXUAT values ('',N'{0}')", tennsx); db.ExecuteNonQuery(sqlQuery); }
public void XoaKhachHang(string makh) { string sqlQuery = "Delete from KHACHHANG where makh = '" + makh + "'"; db.ExecuteNonQuery(sqlQuery); }
public void XoaSanPham(String masanpham) { string sqlQuery = "Delete from SanPham where masanpham = '" + masanpham + "'"; db.ExecuteNonQuery(sqlQuery); }
public void XoaNhanVien(string manv) { string sqlQuery = "Delete from Nhanvien where manv = '" + manv + "'"; db.ExecuteNonQuery(sqlQuery); }
public void ThemHoaDon(string manv, string makh, string ngayban) { string sqlQuery = string.Format("insert into HOADON values('','{0}','{1}','{2}','')", manv, makh, ngayban); db.ExecuteNonQuery(sqlQuery); }
public void XoaSanPham_HoaDon(string masp) { string sqlQuery = "delete from CHITIETHOADON where masanpham = '" + masp + "'"; db.ExecuteNonQuery(sqlQuery); }