//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));
}