public DeliverySubTableCollection FetchByQuery(Query qry)
        {
            DeliverySubTableCollection coll = new DeliverySubTableCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public DeliverySubTableCollection FetchAll()
        {
            DeliverySubTableCollection coll = new DeliverySubTableCollection();
            Query qry = new Query(DeliverySubTable.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public DeliverySubTableCollection FetchByOrderNumber(object OrderNumber)
        {
            DeliverySubTableCollection coll = new DeliverySubTableCollection().Where("OrderNumber", OrderNumber).Load();

            return(coll);
        }
        public DeliverySubTableCollection FetchByID(object DeliveryID)
        {
            DeliverySubTableCollection coll = new DeliverySubTableCollection().Where("DeliveryID", DeliveryID).Load();

            return(coll);
        }