public ItemTableCollection FetchByQuery(Query qry)
{
ItemTableCollection coll = new ItemTableCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public ItemTableCollection FetchAll()
{
ItemTableCollection coll = new ItemTableCollection();
Query qry = new Query(ItemTable.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public ItemTableCollection FetchByOrderNumber(object OrderNumber)
{
ItemTableCollection coll = new ItemTableCollection().Where("OrderNumber", OrderNumber).Load();
return(coll);
}
public ItemTableCollection FetchByID(object TitleID)
{
ItemTableCollection coll = new ItemTableCollection().Where("TitleID", TitleID).Load();
return(coll);
}
