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