public List <RealEstateNewsInfo> RealEstateNewsInfo_GetByLevel(string Level, int LevelLength) { List <DataAccess.RealEstateNewsInfo> list = new List <DataAccess.RealEstateNewsInfo>(); DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo(); DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateNewsInfo_GetByLevel", Level, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateNewsInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateNewsInfo> RealEstateNewsInfo_GetByAll() { List <DataAccess.RealEstateNewsInfo> list = new List <DataAccess.RealEstateNewsInfo>(); DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo(); DbCommand cmd = db.GetStoredProcCommand("RealEstateNews_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateNewsInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateNewsInfo> RealEstateNewsInfo_Paging(string CurentRealEstateNewsInfo, string RealEstateNewsInfoSize) { List <DataAccess.RealEstateNewsInfo> list = new List <DataAccess.RealEstateNewsInfo>(); DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo(); DbCommand cmd = db.GetStoredProcCommand("RealEstateNews_SelectPage", CurentRealEstateNewsInfo, RealEstateNewsInfoSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateNewsInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }