コード例 #1
0
        /// <summary>
        /// Загрузка данных перед перехода к UCMain
        /// </summary>
        private void File_CompleteEvent(string path1, string path2)
        {
            this.excelManager = new Manager.ExcelManager(userControls.Options.SavePath, $"Сверка_{DateTime.Now.ToShortDateString()}.xlsx");

            try
            {
                /// Загрузка названий WorkSheets
                excelResponse = new ExcelResponseModel()
                {
                    FirstFile  = excelManager.GetNameWorkSheets(path1),
                    SecondFile = excelManager.GetNameWorkSheets(path2)
                };

                if (File.Exists(formsSerializer.Path))
                {
                    userControls.Main.AddDataRows(formsSerializer.Deserialize(view.ShowMessageError)); /// Получение сериализованных данных
                }
                view.AddControlsToPanel(userControls.Main);

                view.btnMain.Enabled = true;

                view.btnMain.ToChange(ButtonColor.OnClick);
                view.btnFilse.ToChange(ButtonColor.Default);
            }
            catch (Exception ex)
            {
                view.ShowMessageError(ex.Message);
            }
        }
コード例 #2
0
ファイル: UcMain.cs プロジェクト: TheWayToJunior/ExcelHelper
        private void AddNameSheet(int index)
        {
            ExcelResponseModel files = CreatingRows?.Invoke();

            Action <string, IEnumerable <string> > addName = (sName, collection) =>
            {
                foreach (var item in collection)
                {
                    (dgvMain.Rows[index].Cells[sName] as DataGridViewComboBoxCell).Items.Add(item);
                }
            };

            addName("NameTable1", files.FirstFile.WorkSheets);
            addName("NameTable2", files.SecondFile.WorkSheets);
        }