public List <RealEstateOwnersInfo> RealEstateOwnersInfo_GetByLevel(string Level, int LevelLength) { List <DataAccess.RealEstateOwnersInfo> list = new List <DataAccess.RealEstateOwnersInfo>(); DataAccess.RealEstateOwnersInfo obj = new DataAccess.RealEstateOwnersInfo(); DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateOwnersInfo_GetByLevel", Level, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateOwnersInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateOwnersInfo> RealEstateOwnersInfo_GetByAll() { List <DataAccess.RealEstateOwnersInfo> list = new List <DataAccess.RealEstateOwnersInfo>(); DataAccess.RealEstateOwnersInfo obj = new DataAccess.RealEstateOwnersInfo(); DbCommand cmd = db.GetStoredProcCommand("RealEstateOwners_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateOwnersInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateOwnersInfo> RealEstateOwnersInfo_Paging(string CurentRealEstateOwnersInfo, string RealEstateOwnersInfoSize) { List <DataAccess.RealEstateOwnersInfo> list = new List <DataAccess.RealEstateOwnersInfo>(); DataAccess.RealEstateOwnersInfo obj = new DataAccess.RealEstateOwnersInfo(); DbCommand cmd = db.GetStoredProcCommand("RealEstateOwners_SelectPage", CurentRealEstateOwnersInfo, RealEstateOwnersInfoSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateOwnersInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }