public List <RealEstateOwnersTypeInfo> RealEstateOwnersTypeInfo_GetByLevel(string Level, int LevelLength) { List <DataAccess.RealEstateOwnersTypeInfo> list = new List <DataAccess.RealEstateOwnersTypeInfo>(); DataAccess.RealEstateOwnersTypeInfo obj = new DataAccess.RealEstateOwnersTypeInfo(); DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateOwnersTypeInfo_GetByLevel", Level, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateOwnersTypeInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateOwnersTypeInfo> RealEstateOwnersTypeInfo_GetByAll() { List <DataAccess.RealEstateOwnersTypeInfo> list = new List <DataAccess.RealEstateOwnersTypeInfo>(); DataAccess.RealEstateOwnersTypeInfo obj = new DataAccess.RealEstateOwnersTypeInfo(); DbCommand cmd = db.GetStoredProcCommand("Group_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateOwnersTypeInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateOwnersTypeInfo> RealEstateOwnersTypeInfo_Paging(string CurentRealEstateOwnersTypeInfo, string RealEstateOwnersTypeInfoSize) { List <DataAccess.RealEstateOwnersTypeInfo> list = new List <DataAccess.RealEstateOwnersTypeInfo>(); DataAccess.RealEstateOwnersTypeInfo obj = new DataAccess.RealEstateOwnersTypeInfo(); DbCommand cmd = db.GetStoredProcCommand("Group_SelectPage", CurentRealEstateOwnersTypeInfo, RealEstateOwnersTypeInfoSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateOwnersTypeInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }