Ejemplo n.º 1
0
        public static AdvCollection SelectAll()
        {
            AdvCollection List = new AdvCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssAdv_Select_SelectAll_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Ejemplo n.º 2
0
        public static AdvCollection SelectByViTri(string MaViTri, int Top)
        {
            AdvCollection List = new AdvCollection();

            SqlParameter[] obj = new SqlParameter[2];
            obj[0] = new SqlParameter("MaViTri", MaViTri);
            obj[1] = new SqlParameter("Top", Top);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssAdv_Select_SelectByViTri_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }