public List <DocGia> getAll(string Top, string Where, string Order) { List <DocGia> lst = new List <DocGia>(); string selectQuery = "select "; if (Top.Length != 0) { selectQuery += "Top " + Top; } selectQuery += "* "; selectQuery += "from tb_DocGia "; if (Where.Length != 0) { selectQuery += "Where " + Where; } if (Order.Length != 0) { selectQuery += "Order by " + Order; } using (SqlCommand cmd = new SqlCommand(selectQuery, openConnection())) { SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { DocGia obj = new DocGia(); obj.DocGiaIDataReader(dr); lst.Add(obj); } dr.Close(); } return(lst); }