public List <Models.User> GetName(Models.Search P_NAME) { List <Models.User> ret = new List <Models.User>(); BdUtil bdUtil = new BdUtil(); System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS where upper(name) like '%" + P_NAME.Name.ToUpperInvariant() + "%' order by NAME", null); while (rs.Read()) { ret.Add(new Models.User { Id = rs.GetInt32(0), Name = rs.GetString(1), Age = rs.GetInt32(2), Address = rs.GetString(3) }); } return(ret); }
public List <Models.User> GetAll() { List <Models.User> ret = new List <Models.User>(); BdUtil bdUtil = new BdUtil(); System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS order by NAME", null); while (rs.Read()) { ret.Add(new Models.User { Id = rs.GetInt32(0), Name = rs.GetString(1), Age = rs.GetInt32(2), Address = rs.GetString(3) }); } return(ret); }
public Models.User GetId(int P_ID) { Models.User ret = new Models.User(); BdUtil bdUtil = new BdUtil(); System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS where ID = " + P_ID, null); while (rs.Read()) { ret.Id = rs.GetInt32(0); ret.Name = rs.GetString(1); ret.Age = rs.GetInt32(2); ret.Address = rs.GetString(3); } return(ret); }