public static QuangCaoCollection SelectAll() { QuangCaoCollection List = new QuangCaoCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblQuangCao_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static QuangCaoCollection SelectByDanhMuc(SqlConnection con, string DM_Ma, int Top) { QuangCaoCollection List = new QuangCaoCollection(); SqlParameter[] obj = new SqlParameter[2]; obj[0] = new SqlParameter("DM_Ma", DM_Ma); obj[1] = new SqlParameter("Top", Top); using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblQuangCao_Select_SelectByDanhMuc_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }