public PdObraSocCollection FetchByQuery(Query qry) { PdObraSocCollection coll = new PdObraSocCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public PdObraSocCollection FetchAll() { PdObraSocCollection coll = new PdObraSocCollection(); Query qry = new Query(PdObraSoc.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public PdObraSocCollection FetchAllPaged(int start, int pageLength) { int startIndex; if (start == 0) { startIndex = 1; } else { startIndex = start / pageLength; } PdObraSocCollection coll = new PdObraSocCollection(); Query qry = new Query(PdObraSoc.Schema); qry.PageSize = pageLength; qry.PageIndex = startIndex; coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }