//sua nha cung cap public static bool NhaCungCapSua(string ma, string ten, string diachi, string dienthoai, string makhuvuc) { string sql = string.Format("Update NHACUNGCAP set TenNhaCungCap='{0}',DiaChi='{1}',DienThoai='{2}',MaKhuVuc='{3}' where MaNhaCungCap='{4}' ", ten, diachi, dienthoai, makhuvuc, ma); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua khu vuc public static bool KhuVucSua(string maKhuVuc, string tenKhuVuc) { string sql = string.Format("Update KHUVUC set TenKhuVuc='{0}' where MaKhuVuc='{1}'", tenKhuVuc, maKhuVuc); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua public static bool NhanVienSua(string ma, string ten, string phai, string ngaysinh, string dienthoai, string mabophan) { string sql = string.Format("Update NHANVIEN set HoTen='{0}',GioiTinh='{1}',NgaySinh='{2}',DienThoai='{3}',MaBP='{4}' Where MaNV='{5}'", ten, phai, ngaysinh, dienthoai, mabophan, ma); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua public static bool TyGiaSua(string ma, string ten, string quydoi) { string sql = string.Format("Update TYGIA set TenTyGia='{0}',QuyDoiTienViet='{1}' Where MaTyGia='{2}'", ten, quydoi, ma); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua nhom hang public static bool NhomHangSua(string ma, string ten) { string sql = string.Format("Update NHOMHANG set TenNhomHang='{0}' where MaNhomHang='{1}'", ten, ma); return(DL_LayDuLieu.UpdateSQL(sql)); }
//capnhat sp public static bool SanPhamCapNhat(string makho, string MaSP, int SoLuongMua) { string sql = string.Format("Update SANPHAM set SoLuongTon=SoLuongTon+{0} Where MaSP='{1}' and MaKho='{2}'", SoLuongMua, MaSP, makho); return(DL_LayDuLieu.UpdateSQL(sql)); }
//doi mat khau public static bool MatKhauMoi(string tk, string mk) { string sql = string.Format("Update TAIKHOAN set MatKhau='{0}' where TenTaiKhoan='{1}'", mk, tk); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua public static bool DonViTinhSua(string ma, string ten) { string sql = string.Format("Update DONVITINH set TenDonViTinh='{0}' Where MaDonViTinh='{1}'", ten, ma); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua kho hang public static bool KhoHangSua(string ma, string ten, string makhuvuc) { string sql = string.Format("Update KHO Set TenKho='{0}',MaKhuVuc='{1}' Where MaKho='{2}'", ten, makhuvuc, ma); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua public static bool BoPhanSua(string maBoPhan, string TenBoPhan) { string sql = string.Format("Update BOPHAN set TenBP='{0}' where MaBP='{1}'", TenBoPhan, maBoPhan); return(DL_LayDuLieu.UpdateSQL(sql)); }
//sua khach hang public static bool KhachHangSua(string makhachhang, string ten, string diachi, string dienthoai, string makhuvuc) { string sql = string.Format("Update KHACHHANG set TenKhachHang='{0}',DiaChi='{1}',DienThoai'{2}',MaKhuVuc='{3}' where MaKhachHang='{4}'", ten, diachi, dienthoai, makhuvuc, makhachhang); return(DL_LayDuLieu.UpdateSQL(sql)); }