Ejemplo n.º 1
0
        public ImportDesignTimeViewModel()
        {
            var columnHeaderList = new List<ColumnHeaderValue>
            {
                new ColumnHeaderValue {Caption = "TEST COLUMN HEADER"},
                new ColumnHeaderValue {Caption = "TEST COLUMN HEADER 2"}
            };

            var sheet1 = new SheetInfo
            {
                RelatedClients = new ObservableCollection<RelatedClientInfo>
                {
                    new RelatedClientInfo
                    {
                        Client = new Client { Id = 17, ParentId = null, InnerId = 240, Name = "Траст", FullName = "ПАО НБ \"Траст\"", Image = "240-bank-trast.png" },
                    },
                    new RelatedClientInfo
                    {
                        Client = new Client { Id = 25, ParentId = null, InnerId = 251, Name = "Сбербанк", FullName = "ПАО «Сбербанк России»", Image = "251-sber-bank.png"}
                    }
                },
                ColumnHeaderList = columnHeaderList,
                SelectedColumnHeaderValue = columnHeaderList[0]
            };
            WorkSheetsInBook = new ObservableCollection<SheetInfo> {sheet1, new SheetInfo()};
        }
Ejemplo n.º 2
0
        public ImportDesignTimeViewModel()
        {
            var columnHeaderList = new List <ColumnHeaderValue>
            {
                new ColumnHeaderValue {
                    Caption = "TEST COLUMN HEADER"
                },
                new ColumnHeaderValue {
                    Caption = "TEST COLUMN HEADER 2"
                }
            };

            var sheet1 = new SheetInfo
            {
                RelatedClients = new ObservableCollection <RelatedClientInfo>
                {
                    new RelatedClientInfo
                    {
                        Client = new Client {
                            Id = 17, ParentId = null, InnerId = 240, Name = "Траст", FullName = "ПАО НБ \"Траст\"", Image = "240-bank-trast.png"
                        },
                    },
                    new RelatedClientInfo
                    {
                        Client = new Client {
                            Id = 25, ParentId = null, InnerId = 251, Name = "Сбербанк", FullName = "ПАО «Сбербанк России»", Image = "251-sber-bank.png"
                        }
                    }
                },
                ColumnHeaderList          = columnHeaderList,
                SelectedColumnHeaderValue = columnHeaderList[0]
            };

            WorkSheetsInBook = new ObservableCollection <SheetInfo> {
                sheet1, new SheetInfo()
            };
        }
Ejemplo n.º 3
0
        public void DocumentLoaded(object spreadSheet)
        {
            if (!(spreadSheet is SpreadsheetControl))
            {
                return;
            }
            var workBook = ((SpreadsheetControl)spreadSheet).Document;

            foreach (var itemWorkSheet in workBook.Worksheets)
            {
                var sheetInfo = new SheetInfo {
                    WorkSheet = itemWorkSheet, GoodColumns = GoodColumns
                };

                sheetInfo.ParseWorkSheet();

                var columnHeaders = new List <string>();

                sheetInfo.ColumnHeaderList.ForEach(ch => columnHeaders.Add(ch.Caption));

                WorkSheetsInBook.Add(sheetInfo);
                ImportService.AddColumnHeadersAsync(columnHeaders.ToArray(), sheetInfo);
            }
        }
Ejemplo n.º 4
0
        public void DocumentLoaded(object spreadSheet)
        {
            if (!(spreadSheet is SpreadsheetControl))
                return;
            var workBook = ((SpreadsheetControl) spreadSheet).Document;
            foreach (var itemWorkSheet in workBook.Worksheets)
            {
                var sheetInfo = new SheetInfo { WorkSheet = itemWorkSheet, GoodColumns = GoodColumns };

                sheetInfo.ParseWorkSheet();

                var columnHeaders = new List<string>();

                sheetInfo.ColumnHeaderList.ForEach(ch => columnHeaders.Add(ch.Caption));

                WorkSheetsInBook.Add(sheetInfo);
                ImportService.AddColumnHeadersAsync(columnHeaders.ToArray(), sheetInfo);
               }
        }