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