public static VanBanDiCollection SelectTTSo()
{
VanBanDiCollection List = new VanBanDiCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_Select_TTSo_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static VanBanDiCollection GetVanBanChuaPhatHanh(string sort, int numRow, string UserName)
{
VanBanDiCollection List = new VanBanDiCollection();
SqlParameter[] obj = new SqlParameter[3];
obj[0] = new SqlParameter("Sort", sort);
obj[1] = new SqlParameter("Top", numRow);
obj[2] = new SqlParameter("Username", UserName);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_Select_Desktop_hungpm", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}