public List <CTPM> getAll(string Top, string Where, string Order) { List <CTPM> lst = new List <CTPM>(); string selectQuery = "select "; if (Top.Length != 0) { selectQuery += "Top " + Top; } selectQuery += "* "; selectQuery += "from tb_CTPM "; 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()) { CTPM obj = new CTPM(); obj.CTPMIDataReader(dr); lst.Add(obj); } dr.Close(); } return(lst); }
public List <CTPM> getCTPM(String maKH) { List <CTPM> lst = new List <CTPM>(); String sql = String.Format("select tb_CTPM.* from tb_CTPM,tb_PhieuMuon where tb_PhieuMuon.maPM = tb_CTPM.maPM and maDocGia = '{0}'", maKH); using (SqlCommand cmd = new SqlCommand(sql, openConnection())) { SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { CTPM obj = new CTPM(); obj.CTPMIDataReader(dr); lst.Add(obj); } dr.Close(); } return(lst); }