public static ThuTucCollection SelectAll()
{
ThuTucCollection List = new ThuTucCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblThuTuc_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static ThuTucCollection SearchByLV(string LV_ID, string q)
{
ThuTucCollection List = new ThuTucCollection();
SqlParameter[] obj = new SqlParameter[2];
if (string.IsNullOrEmpty(LV_ID))
{
obj[0] = new SqlParameter("LV_ID", DBNull.Value);
}
else
{
obj[0] = new SqlParameter("LV_ID", LV_ID);
}
obj[1] = new SqlParameter("q", q);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblThuTuc_Select_SearchByLV_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
