private void Reload(object sender, EventArgs e) { string filePath = excelFileSelect.FileName; try { if (ExcelDataReader_StackBuilder.LoadFile(filePath, ref _listTypes)) { } } catch (System.Security.SecurityException ex) { MessageBox.Show(ex.Message); return; } catch (Exception ex) { MessageBox.Show(ex.Message); return; } if (null != _listTypes && _listTypes.Count > 0) { tabControlLibrary.Show(); // is tabcontrol already initialized if (tabControlLibrary.TabPages.Count == 0) { if (HasType(typeof(DataCase))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_CASES); _classes.Add(typeof(DataCase)); } if (HasType(typeof(DataBox))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_BOXES); _classes.Add(typeof(DataBox)); } if (HasType(typeof(DataCylinder))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_CYLINDERS); _classes.Add(typeof(DataCylinder)); } if (HasType(typeof(DataPallet))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_PALLETS); _classes.Add(typeof(DataPallet)); } if (HasType(typeof(DataInterlayer))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_INTERLAYERS); _classes.Add(typeof(DataInterlayer)); } if (HasType(typeof(DataPalletCap))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_PALLETCAPS); _classes.Add(typeof(DataPalletCap)); } if (HasType(typeof(DataPalletFilm))) { tabControlLibrary.TabPages.Add(Properties.Resources.ID_PALLETFILMS); _classes.Add(typeof(DataPalletFilm)); } } tabControlLibrary.SelectedIndex = 0; OnTabPageSelected(this, null); } else { tabControlLibrary.Hide(); } }
private void OnFileNameChanged(object sender, EventArgs e) { string filePath = excelFileSelect.FileName; bool fileExist = File.Exists(filePath); // enable disable import button bnImport.Enabled = fileExist; UpdateStatus(fileExist ? string.Empty : Properties.Resources.ID_DEFINEVALIDFILEPATH); if (fileExist) { // load file try { if (ExcelDataReader_StackBuilder.LoadFile(filePath, ref _listTypes)) { } } catch (System.Security.SecurityException ex) { MessageBox.Show(ex.Message); return; } catch (Exception ex) { MessageBox.Show(ex.Message); return; } bnImport.Enabled = _listTypes.Count > 0; progressBar.Maximum = _listTypes.Count > 0 ? _listTypes.Count - 1 : 0; UpdateStatus(string.Format("{0} items found", _listTypes.Count)); } }