public static DataTable GetTTHoaDon(string mahd)
{
GetData data = new GetData();
string select = "SELECT dbo.HoaDonBan.MAHDB, dbo.HoaDonBan.NGAYBAN, dbo.CTHDB.SOLUONG, dbo.CTHDB.DONGIA, dbo.CTHDB.THANHTIEN, dbo.HoaDonBan.TONGTIEN, dbo.SanPham.TENSP, dbo.KhachHang.TENKH, dbo.NhanVien.TENNV, dbo.SanPham.DONVITINH, dbo.KhachHang.DIENTHOAI, dbo.KhachHang.EMAIL, dbo.KhachHang.DIACHI FROM dbo.CTHDB INNER JOIN dbo.HoaDonBan ON dbo.CTHDB.MAHDB = dbo.HoaDonBan.MAHDB INNER JOIN dbo.SanPham ON dbo.CTHDB.MASP = dbo.SanPham.MASP INNER JOIN dbo.KhachHang ON dbo.HoaDonBan.MAKH = dbo.KhachHang.MAKH INNER JOIN dbo.NhanVien ON dbo.HoaDonBan.MANV = dbo.NhanVien.MANV";
select += " where dbo.HoaDonBan.MaHDB='" + mahd + "'";
try
{
return(GetData.LayDataTable(select, conn));
}
catch
{
return(null);
}
}
public static DataTable GetMaBH(string mabh)
{
GetData data = new GetData();
string select = "SELECT dbo.BaoHanh.MABH, dbo.KhachHang.TENKH, dbo.SanPham.TENSP, dbo.BaoHanh.IMEI, dbo.BaoHanh.NGAYBD, dbo.BaoHanh.NGAYKT, dbo.BaoHanh.LOI, dbo.BaoHanh.GHICHU, dbo.BaoHanh.MASP,dbo.BaoHanh.MAKH FROM dbo.BaoHanh INNER JOIN dbo.SanPham ON dbo.BaoHanh.MASP = dbo.SanPham.MASP INNER JOIN dbo.KhachHang ON dbo.BaoHanh.MAKH = dbo.KhachHang.MAKH";
select += " where dbo.BaoHanh.MABH = N'" + mabh + "'";
try
{
return(GetData.LayDataTable(select, conn));
}
catch
{
return(null);
}
}
public static DataTable GetTTHoaDon(string mahd)
{
GetData data = new GetData();
string select = "SELECT dbo.HoaDonNhap.MAHDN, dbo.HoaDonNhap.NGAYNHAP, dbo.CTHDN.MASP, dbo.CTHDN.SOLUONG, dbo.CTHDN.DONGIA, dbo.CTHDN.THANHTIEN, dbo.SanPham.TENSP, dbo.NhanVien.TENNV, dbo.NhaCungCap.TENNCC FROM dbo.CTHDN INNER JOIN dbo.SanPham ON dbo.CTHDN.MASP = dbo.SanPham.MASP INNER JOIN dbo.HoaDonNhap ON dbo.CTHDN.MAHDN = dbo.HoaDonNhap.MAHDN INNER JOIN dbo.NhaCungCap ON dbo.HoaDonNhap.MANCC = dbo.NhaCungCap.MANCC INNER JOIN dbo.NhanVien ON dbo.HoaDonNhap.MANV = dbo.NhanVien.MANV";
select += " where dbo.HoaDonNhap.MaHDN='" + mahd + "'";
try
{
return(GetData.LayDataTable(select, conn));
}
catch
{
return(null);
}
}
public static DataTable GetDoanhThu(string manv)
{
GetData data = new GetData();
string select = "SELECT NhanVien.MANV, NhanVien.TENNV, HoaDonBan.MAHDB, HoaDonBan.TONGTIEN, HoaDonBan.NGAYBAN FROM NhanVien INNER JOIN HoaDonBan ON NhanVien.MANV = HoaDonBan.MANV";
select += " where dbo.NhanVien.MaNV='" + manv + "'";
try
{
return(GetData.LayDataTable(select, conn));
}
catch
{
return(null);
}
}
