public DataTable getallinfo() { string query = string.Format("SELECT * FROM ban"); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return con.executeSelectQuery(query); }
public DataTable getfilterinfo(String _Condition) { string query = string.Format("SELECT * FROM ban WHERE "+_Condition); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return con.executeSelectQuery(query); }
public DataTable getallinfo() { string query = string.Format("SELECT * FROM ban"); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeSelectQuery(query)); }
public DataTable getallthucdon() { string query = string.Format("SELECT thucdon.mamon, thucdon.tenmon, thucdon.gia, loaithucdon.tenloai, thucdon.donvi, thucdon.tinhtrang, thucdon.mota FROM thucdon INNER JOIN loaithucdon ON thucdon.maloai = loaithucdon.maloai"); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return con.executeSelectQuery(query); }
public DataTable getallinfo(string a, string b) { string query = string.Format("select hoadon.mahoadon,thucdon.tenmon,chitiethoadon.soluong,chitiethoadon.thanhtien, hoadon.ngaylap FROM hoadon inner join chitiethoadon ON hoadon.mahoadon = chitiethoadon.mahoadon inner join thucdon ON chitiethoadon.mamon = thucdon.mamon WHERE hoadon.maban = " + a + " and hoadon.tinhtrang = " + b); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeSelectQuery(query)); }
public DataTable getallthucdon() { string query = string.Format("SELECT thucdon.mamon, thucdon.tenmon, thucdon.gia, loaithucdon.tenloai, thucdon.donvi, thucdon.tinhtrang, thucdon.mota FROM thucdon INNER JOIN loaithucdon ON thucdon.maloai = loaithucdon.maloai"); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeSelectQuery(query)); }
public DataTable getfilterinfo(String _Condition) { string query = string.Format("SELECT * FROM ban WHERE " + _Condition); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeSelectQuery(query)); }