public DataTable listtonkho()
{
string query = string.Format("select HINHANH, TONKHO.MANHAPHANG , NGAYNHAPHANG, TONKHO.MAVP, TENVP, SOLUONGNHAP,SOLUONGTON from TONKHO,NHAPHANG,VATPHAM " +
"where TONKHO.MANHAPHANG = NHAPHANG.MANHAPHANG and TONKHO.MAVP=VATPHAM.MAVP");
return(conn.executeSelectQuery(query));
}
public DataTable listnhaphang()
{
string query = string.Format("select * from NHAPHANG");
return(conn.executeSelectQuery(query));
}
public DataTable listloai()
{
string query = string.Format("select * from LOAI");
return(conn.executeSelectQuery(query));
}
public DataTable listthanhpho()
{
string query = string.Format("select * from THANHPHO");
return(conn.executeSelectQuery(query));
}
public DataTable listvatpham()
{
string query = string.Format("select * from VATPHAM");
return(conn.executeSelectQuery(query));
}