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); }
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); }