public static LinhVucCollection SelectAll()
{
LinhVucCollection List = new LinhVucCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLinhVuc_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static LinhVucCollection SelectTree(string q)
{
LinhVucCollection List = new LinhVucCollection();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("q", q);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLinhVuc_Select_SelectTree_hungpm", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}