public static void XoaNhaCungCap(string MaNCC)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "XoaNhaCungCap",
new SqlParameter {
ParameterName = "@ma", Value = MaNCC
});
}
public static void XoaTyGia(string Ma)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "XoaTyGia",
new SqlParameter {
ParameterName = "@ma", Value = Ma
});
}
public static void SuaNhaCungCap(NhaCungCap kq)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaNhaCungCap",
new SqlParameter {
ParameterName = "@ma", Value = kq.MaNCC
},
new SqlParameter {
ParameterName = "@ten", Value = kq.TenNCC
},
new SqlParameter {
ParameterName = "@nguoilienhe", Value = kq.NguoiLienHe
},
new SqlParameter {
ParameterName = "@chucvu", Value = kq.ChucVu
},
new SqlParameter {
ParameterName = "@diachi", Value = kq.DiaChi
},
new SqlParameter {
ParameterName = "@DienThoai", Value = kq.DienThoai
},
new SqlParameter {
ParameterName = "@DiDong", Value = kq.DiDong
},
new SqlParameter {
ParameterName = "@fax", Value = kq.Fax
},
new SqlParameter {
ParameterName = "@conquanly", Value = kq.ConQL
},
new SqlParameter {
ParameterName = "@makhuvuc", Value = kq.MaKhuVuc
});
}
public static void SuaNhanVien(NhanVien kq)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaNhanVien",
new SqlParameter {
ParameterName = "@ma", Value = kq.Ma
},
new SqlParameter {
ParameterName = "@ten", Value = kq.Ten
},
new SqlParameter {
ParameterName = "@diachi", Value = kq.DiaChi
},
new SqlParameter {
ParameterName = "@dienthoai", Value = kq.DienThoai
},
new SqlParameter {
ParameterName = "@DiDong", Value = kq.DiDong
},
new SqlParameter {
ParameterName = "@email", Value = kq.Email
},
new SqlParameter {
ParameterName = "@conquanly", Value = kq.ConQL
},
new SqlParameter {
ParameterName = "@mabophan", Value = kq.MaBoPhan
});
}
public static void XoaKhachHang(string MaKH)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "XoaKhachHang",
new SqlParameter {
ParameterName = "@ma", Value = MaKH
});
}
public static void ThemHangHoa(HangHoa h)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemHangHoa",
new SqlParameter {
ParameterName = "@ma", Value = h.MaHang
},
new SqlParameter {
ParameterName = "@ten", Value = h.TenHang
},
new SqlParameter {
ParameterName = "@giamua", Value = h.GiaMua
},
new SqlParameter {
ParameterName = "@giabansi", Value = h.GiaBanSi
},
new SqlParameter {
ParameterName = "@giabanle", Value = h.GiaBanLe
},
new SqlParameter {
ParameterName = "@tinhchat", Value = h.TinhChat
},
new SqlParameter {
ParameterName = "@conquanli", Value = h.ConQuanLi
},
new SqlParameter {
ParameterName = "@mavach", Value = h.MaVach
},
new SqlParameter {
ParameterName = "@manhomhang", Value = h.MaNhomHang
},
new SqlParameter {
ParameterName = "@makhohang", Value = h.MaKhoHang
},
new SqlParameter {
ParameterName = "@madonvi", Value = h.MaDonViTinh
},
new SqlParameter {
ParameterName = "@soluong", Value = h.SoLuong
},
new SqlParameter {
ParameterName = "@soluongton", Value = h.SoLuongTon
},
new SqlParameter {
ParameterName = "@tonkhotoithieu", Value = h.TonKhoToiThieu
},
new SqlParameter {
ParameterName = "@maNCC", Value = h.MaNCC
});
}
public static void SuaTyGia(TyGia kq)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaTyGia",
new SqlParameter {
ParameterName = "@ma", Value = kq.Ma
},
new SqlParameter {
ParameterName = "@ten", Value = kq.Ten
},
new SqlParameter {
ParameterName = "@tygiaquydoi", Value = kq.TyGiaQuyDoi
},
new SqlParameter {
ParameterName = "@conquanly", Value = kq.ConQL
});
}
public static void ThemNhomHang(NhomHang kq)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemNhomHang",
new SqlParameter {
ParameterName = "@ma", Value = kq.Ma
},
new SqlParameter {
ParameterName = "@ten", Value = kq.Ten
},
new SqlParameter {
ParameterName = "@ghichu", Value = kq.GhiChu
},
new SqlParameter {
ParameterName = "@conquanly", Value = kq.ConQL
});
}
public static void SuaKhuVuc(KhuVuc kv)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaKhuVuc",
new SqlParameter {
ParameterName = "@ma", Value = kv.MaKhuVuc
},
new SqlParameter {
ParameterName = "@ten", Value = kv.TenKhuVuc
},
new SqlParameter {
ParameterName = "@ghichu", Value = kv.GhiChu
},
new SqlParameter {
ParameterName = "@conquanly", Value = kv.ConQuanLi
});
}
public static void SuaBoPhan(BoPhan kq)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaBoPhan",
new SqlParameter {
ParameterName = "@ma", Value = kq.Ma
},
new SqlParameter {
ParameterName = "@ten", Value = kq.Ten
},
new SqlParameter {
ParameterName = "@ghichu", Value = kq.GhiChu
},
new SqlParameter {
ParameterName = "@conquanly", Value = kq.ConQL
});
}
public static void ThemVaiTro(VaiTro vt)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemVaiTro",
new SqlParameter {
ParameterName = "@mavt", Value = vt.MaVaiTro
},
new SqlParameter {
ParameterName = "@tenvt", Value = vt.TenVaiTro
},
new SqlParameter {
ParameterName = "@diengiai", Value = vt.DienGiai
},
new SqlParameter {
ParameterName = "@kichhoat", Value = vt.KichHoat
});
}
public static void SuaKhachHang(KhachHang kh)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaKhachHang",
new SqlParameter {
ParameterName = "@ma", Value = kh.MaKH
},
new SqlParameter {
ParameterName = "@ten", Value = kh.TenKH
},
new SqlParameter {
ParameterName = "@nguoilienhe", Value = kh.NguoiLienHe
},
new SqlParameter {
ParameterName = "@diachi", Value = kh.DiaChi
},
new SqlParameter {
ParameterName = "@dienthoai", Value = kh.DienThoai
},
new SqlParameter {
ParameterName = "@didong", Value = kh.DiDong
},
new SqlParameter {
ParameterName = "@fax", Value = kh.Fax
},
new SqlParameter {
ParameterName = "@email", Value = kh.Email
},
new SqlParameter {
ParameterName = "@website", Value = kh.Website
},
new SqlParameter {
ParameterName = "@masothue", Value = kh.MaSoThue
},
new SqlParameter {
ParameterName = "@nganhang", Value = kh.TenNganHang
},
new SqlParameter {
ParameterName = "@conquanly", Value = kh.ConQuanLi
},
new SqlParameter {
ParameterName = "@makhuvuc", Value = kh.MaKhuVuc
},
new SqlParameter {
ParameterName = "@sotaikhoan", Value = kh.SoTaiKhoan
});
}
public static void ThemNguoiDung(NguoiDung nd)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemNguoiDung",
new SqlParameter {
ParameterName = "@tennd", Value = nd.TenNguoiDung
},
new SqlParameter {
ParameterName = "@tenhienthi", Value = nd.TenHienThi
},
new SqlParameter {
ParameterName = "@matkhau", Value = nd.MatKhau
},
new SqlParameter {
ParameterName = "@kichhoat", Value = nd.KichHoat
},
new SqlParameter {
ParameterName = "@mavaitro", Value = nd.MaVaiTro
});
}
public static void ThemKhoHang(KhoHang kho)
{
XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemKhoHang",
new SqlParameter {
ParameterName = "@makho", Value = kho.MaKho
},
new SqlParameter {
ParameterName = "@tenkho", Value = kho.TenKho
},
new SqlParameter {
ParameterName = "@nguoilienhe", Value = kho.NguoiLienHe
},
new SqlParameter {
ParameterName = "@diachi", Value = kho.DiaChi
},
new SqlParameter {
ParameterName = "@dienthoai", Value = kho.DienThoai
},
new SqlParameter {
ParameterName = "@fax", Value = kho.Fax
},
new SqlParameter {
ParameterName = "@email", Value = kho.Email
},
new SqlParameter {
ParameterName = "@kyhieu", Value = kho.KyHieu
},
new SqlParameter {
ParameterName = "@conquanli", Value = kho.ConQuanLi
},
new SqlParameter {
ParameterName = "@manguoiquanli", Value = kho.MaNguoiQuanLi
},
new SqlParameter {
ParameterName = "@ghichu", Value = kho.GhiChu
});
}