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