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