Esempio n. 1
0
        public VAQUERY.QueryResultList <string> QueryFormulas(IList <IVisio.Shape> target_shapes, IList <ShapeSheet.SRC> srcs)
        {
            this.Client.Application.AssertApplicationAvailable();
            this.Client.Document.AssertDocumentAvailable();

            var shapes   = this.GetTargetShapes(target_shapes);
            var shapeids = shapes.Select(s => s.ID).ToList();

            var surface = this.Client.ShapeSheet.GetShapeSheetSurface();

            var query = new VAQUERY.CellQuery();

            int ci = 0;

            foreach (var src in srcs)
            {
                string colname = $"Col{ci}";
                query.AddCell(src, colname);
                ci++;
            }

            var formulas = query.GetFormulas(surface, shapeids);

            return(formulas);
        }
Esempio n. 2
0
        public VAQUERY.QueryResultList <string> QueryFormulas(IList <IVisio.Shape> target_shapes, IVisio.VisSectionIndices section, IList <IVisio.VisCellIndices> cells)
        {
            this.Client.Application.AssertApplicationAvailable();
            this.Client.Document.AssertDocumentAvailable();

            var shapes   = this.GetTargetShapes(target_shapes);
            var shapeids = shapes.Select(s => s.ID).ToList();

            var surface = this.Client.ShapeSheet.GetShapeSheetSurface();

            var query = new VAQUERY.CellQuery();
            var sec   = query.AddSection(section);

            int ci = 0;

            foreach (var cell in cells)
            {
                string name = $"Cell{ci}";
                sec.AddCell((short)cell, name);
                ci++;
            }

            var formulas = query.GetFormulas(surface, shapeids);

            return(formulas);
        }
        private static void check_query(VAQUERY.CellQuery query)
        {
            if (query.CellColumns.Count != 0)
            {
                throw new AutomationException("Query should not contain any Columns");
            }

            if (query.SectionColumns.Count != 1)
            {
                throw new AutomationException("Query should not contain contain exaxtly 1 section");
            }
        }
        public static IList <T> _GetCells <T, RT>(
            IVisio.Shape shape,
            VAQUERY.CellQuery query,
            RowToObject <T, RT> row_to_object)
        {
            CellGroupMultiRow.check_query(query);

            var data_for_shape = query.GetCellData <RT>(shape);
            var sec            = data_for_shape.Sections[0];
            var sec_objects    = CellGroupMultiRow.SectionToObjectList(sec, row_to_object);

            return(sec_objects);
        }
Esempio n. 5
0
        public static IList <T> _GetCells <T, RT>(
            IVisio.Shape shape,
            VA.ShapeSheet.Query.CellQuery query,
            RowToObject <T, RT> row_to_object)
        {
            check_query(query);

            var data_for_shape = query.GetFormulasAndResults <RT>(shape);
            var sec            = data_for_shape.SectionCells[0];
            var sec_objects    = SectionToObjectList(sec, row_to_object);

            return(sec_objects);
        }
Esempio n. 6
0
        public static IList <List <T> > _GetCells <T, RT>(
            IVisio.Page page,
            IList <int> shapeids,
            VA.ShapeSheet.Query.CellQuery query,
            RowToObject <T, RT> row_to_object)
        {
            check_query(query);

            var list            = new List <List <T> >(shapeids.Count);
            var data_for_shapes = query.GetFormulasAndResults <RT>(new VA.Drawing.DrawingSurface(page), shapeids);

            foreach (var data_for_shape in data_for_shapes)
            {
                var sec         = data_for_shape.SectionCells[0];
                var sec_objects = SectionToObjectList(sec, row_to_object);
                list.Add(sec_objects);
            }

            return(list);
        }
        public static IList <List <T> > _GetCells <T, RT>(
            IVisio.Page page,
            IList <int> shapeids,
            VAQUERY.CellQuery query,
            RowToObject <T, RT> row_to_object)
        {
            CellGroupMultiRow.check_query(query);

            var list            = new List <List <T> >(shapeids.Count);
            var surface         = new ShapeSheetSurface(page);
            var data_for_shapes = query.GetCellData <RT>(surface, shapeids);

            foreach (var data_for_shape in data_for_shapes)
            {
                var sec         = data_for_shape.Sections[0];
                var sec_objects = CellGroupMultiRow.SectionToObjectList(sec, row_to_object);
                list.Add(sec_objects);
            }

            return(list);
        }
Esempio n. 8
0
        public VAQUERY.QueryResultList <T> QueryResults <T>(IList <IVisio.Shape> target_shapes, IList <ShapeSheet.SRC> srcs)
        {
            this._client.Application.AssertApplicationAvailable();
            this._client.Document.AssertDocumentAvailable();

            var shapes   = this.GetTargetShapes(target_shapes);
            var surface  = this._client.ShapeSheet.GetShapeSheetSurface();
            var shapeids = shapes.Select(s => s.ID).ToList();

            var query = new VAQUERY.CellQuery();

            int ci = 0;

            foreach (var src in srcs)
            {
                string colname = String.Format("Col{0}", ci);
                query.AddCell(src, colname);
                ci++;
            }

            var results = query.GetResults <T>(surface, shapeids);

            return(results);
        }