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

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

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

            return(coll);
        }