private void LoadExcelData(Spreedsheet sprd, bool planilhaUpdateVisibility = true) { sprd.GetTabelaExcel(); lblPlanilhaNomeArquivo.Text = sprd.Title; slblTpMainEnderecoArquivo.Text = "Arquivo: " + sprd.FileName; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.DataSource = sprd.DataTable; sprd.DataTable.Dispose(); btnPlanilhaUpdate.Visible = planilhaUpdateVisibility; tabMain.SelectedTab = tpPanilha; }
private void OpenDialog(Spreedsheet sprd, Control ctl, string worksheetName = "") { try { if (sprd.OpenFile()) { Spreedsheet = sprd; LoadExcelData(Spreedsheet); ctl.Visible = true; } } catch (Exception e) { ctl.Visible = false; MessageBox.Show(e.Message); } }
private void SetClickSimulate(Spreedsheet sprd, Control ctl1, Control ctl2, SetClickSimulateEventHandler handler) { ctl1.Click += (s, e) => { try { handler?.Invoke(this, new SetClickSimulateEventArgs(sprd, ctl1, ctl2)); ctl2.Visible = true; } catch (Exception exception) { MessageBox.Show(exception.Message, $@"Erro ao gerar {sprd.Title}", MessageBoxButtons.OK); tabMain.SelectedTab = tpLogo; pnlMainInfos.Visible = false; ctl2.Visible = false; } isSimulating = true; }; }
// Todo, passar função de validação private void LoadExcelData(Spreedsheet sprd) { try { if (sprd.OpenFile()) { sprd.GetTabelaExcel(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.DataSource = sprd.DataTable; //lblRegistros.Text = (dgvDados.Rows.Count - 1).ToString(); sprd.DataTable.Dispose(); txtLogo.Visible = false; } else { throw new Exception("Erro a carregar o arquivo"); } } catch (Exception e) { MessageBox.Show(e.Message); } }
public SetClickSimulateEventArgs(Spreedsheet spreedsheet, Control ctl1, Control ctl2) { Spreedsheet = spreedsheet; Ctl1 = ctl1; Ctl2 = ctl2; }
private void SetClickOpenSpreedsheet(Spreedsheet sprd, Control ctl1, Control ctl2) { ctl2.Click += (s, e) => { LoadExcelData(sprd); }; ctl1.Click += (s, e) => { OpenDialog(sprd, ctl2); }; }