public static linhLayoutCollection SelectAll()
{
linhLayoutCollection List = new linhLayoutCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tbllinhLayout_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return List;
}
public static linhLayoutCollection SelectByUsername(string Username)
{
linhLayoutCollection List = new linhLayoutCollection();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("Username", Username);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tbllinhLayout_Select_byUsername_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return List;
}