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