public static DataTable DuLieuSPTheoMaSP(string maSP)
{
string sql = string.Format("Select sp.MaSP,sp.TenSP,sp.XuatXu,sp.MaDonViTinh,sp.GiaLucNhap,sp.HinhAnh " +
"From SANPHAM sp Where sp.MaSP = N'{0}' ", maSP);
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
public static DataTable DuLieuTonKho()
{
string sql = "select sp.MaSP,sp.TenSP,dv.TenDonViTinh,sp.XuatXu,sp.SoLuongTon,k.TenKho,nh.TenNhomHang" +
" From SANPHAM sp,KHO k, NHOMHANG nh,DONVITINH dv " +
"Where sp.MaDonViTinh = dv.MaDonViTinh and sp.MaKho = k.MaKho and sp.MaNhomHang = nh.MaNhomHang";
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
//lay du lieu bang vai tro
public static DataTable LayThongTinVaiTro(string MaVaiTro)
{
string sql = string.Format("Select * from VAITRO Where MaVaiTro='{0}'", MaVaiTro);
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
public static DataTable DuLieuSanPhamTheoSP(string masp)
{
string sql = string.Format("Select MaKho From SANPHAM Where MaSP='{0}'", masp);
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
public static DataTable DuLieuSanPham()
{
string sql = string.Format("Select DISTINCT(MaSP),TenSP,MaDonViTinh,XuatXu,GiaLucNhap,HinhAnh From SANPHAM");
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
//lay du lieu bang VAITROCHUCNANG
public static DataTable LayThongTinVaiTroChucNang(string MaVaiTro)
{
string sql = string.Format("Select vt.*,cn.TenTrongHeThong from VAITROCHUCNANG vt, CHUCNANG cn Where MaVaiTro='{0}' and vt.MaChucNang=cn.id", MaVaiTro);
return DL_LayDuLieu.LayDuLieuSQL(sql);
}
//lay thong tin tai khoan
public static DataTable LayThongTinTaiKhoan(string tk)
{
string sql = string.Format("Select * from TAIKHOAN Where TenTaiKhoan = '{0}'", tk);
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
