public DataTable showbill(DTO_TONGHOP th)
{
string sql = "SELECT HD.MAHD, TENNHAHANG, TENKH,HOTEN, TIMEIN, NGAY,THANG,NAM,TONGTIEN, DIACHI.DIACHI, GIAMGIA, TENMON, SL, DONGIA FROM CTHD, HD, KHACHHANG, NHANVIEN, DIACHI, MENU WHERE HD.MAHD = CTHD.MAHD AND HD.MAHD = '" + th.Mahd + "' AND CTHD.MAMON = MENU.MAMON AND HD.MADC = DIACHI.MADC AND HD.MAKH = KHACHHANG.MAHANG AND HD.MANV = NHANVIEN.MANV";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable hienThiBill(DTO_TONGHOP th)
{
return(dao.showbill(th));
}
