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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public InternalInvoiceTableCollection FetchByID(object InvoiceNumber)
        {
            InternalInvoiceTableCollection coll = new InternalInvoiceTableCollection().Where("InvoiceNumber", InvoiceNumber).Load();

            return(coll);
        }