public PdIoseCollection FetchByQuery(Query qry)
{
PdIoseCollection coll = new PdIoseCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PdIoseCollection FetchAll()
{
PdIoseCollection coll = new PdIoseCollection();
Query qry = new Query(PdIose.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PdIoseCollection FetchAllPaged(int start, int pageLength)
{
int startIndex;
if (start == 0)
{
startIndex = 1;
}
else
{
startIndex = start / pageLength;
}
PdIoseCollection coll = new PdIoseCollection();
Query qry = new Query(PdIose.Schema);
qry.PageSize = pageLength;
qry.PageIndex = startIndex;
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PdIoseCollection FetchByID(object Id)
{
PdIoseCollection coll = new PdIoseCollection().Where("id", Id).Load();
return(coll);
}