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

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

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

            return(coll);
        }