예제 #1
0
        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);
        }
예제 #2
0
        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);
        }
예제 #3
0
        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);
        }