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

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

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

            return(coll);
        }