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