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

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

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

            return(coll);
        }