private void CarregaInstancias()
{
//Para testes descomentar as linhas abaixo e comentar a rotina dentro do foreach
tbo = new TabelasBO();
this.Invoke(new MethodInvoker(delegate()
{
cbxServidor.Text = @"HLPSRV\SQLSERVER14";
btnTestarCon.Enabled = true;
cbxDatabase.Enabled = true;
}));
//foreach (string item in tbo.GetServidores())
//{
// try
// {
// this.Invoke(new MethodInvoker(delegate()
// {
// cbxServidor.Items.Add(item);
// cbxServidor.Text = "HLPSRV";
// btnTestarCon.Enabled = true;
// cbxDatabase.Enabled = true;
// }
// ));
// }
// catch (Exception) { this.Dispose(); }
//}
}
public UIPrincipal(TabelasBO objbo)
{
InitializeComponent();
this.objbo = objbo;
toolStripDropDownButton1.Text = objbo.DataBase;
}
public UIPrincipal(TabelasBO objbo)
{
InitializeComponent();
this.objbo = objbo;
toolStripDropDownButton1.Text = objbo.DataBase;
}
private void CarregaInstancias()
{
//Para testes descomentar as linhas abaixo e comentar a rotina dentro do foreach
tbo = new TabelasBO();
this.Invoke(new MethodInvoker(delegate()
{
cbxServidor.Text = @"HLPSRV\SQLSERVER14";
btnTestarCon.Enabled = true;
cbxDatabase.Enabled = true;
}));
//foreach (string item in tbo.GetServidores())
//{
// try
// {
// this.Invoke(new MethodInvoker(delegate()
// {
// cbxServidor.Items.Add(item);
// cbxServidor.Text = "HLPSRV";
// btnTestarCon.Enabled = true;
// cbxDatabase.Enabled = true;
// }
// ));
// }
// catch (Exception) { this.Dispose(); }
//}
}
private void lbTabelas_SelectedIndexChanged(object sender, EventArgs e)
{
clBoxColunas.Items.Clear();
TabelasBO objTabBo = new TabelasBO();
List <TabelaModel> lColunas = objTabBo.GetColunasByTabela(lbTabelas.SelectedValue.ToString());
foreach (TabelaModel item in lColunas.OrderBy(l => l.NomeColuna))
{
clBoxColunas.Items.Add(item.NomeColuna);
if (objConstbo.ConstrExists("constr" + "_" + lbTabelas.SelectedValue.ToString() +
"_" + item.NomeColuna))
{
clBoxColunas.SetItemChecked(
clBoxColunas.Items.IndexOf(item.NomeColuna), true);
}
}
}
private void mudarAConexãoToolStripMenuItem_Click(object sender, EventArgs e)
{
foreach (Form frm in this.MdiChildren)
{
if (frm is UIGerador)
{
frm.Close();
}
}
UIConexao uic = new UIConexao();
uic.ShowDialog();
objbo = uic.tbo;
toolStripDropDownButton1.Text = objbo.DataBase;
if (objbo.DataBase == null)
{
Application.Exit();
}
}
private void mudarAConexãoToolStripMenuItem_Click(object sender, EventArgs e)
{
foreach (Form frm in this.MdiChildren)
{
if (frm is UIGerador)
{
frm.Close();
}
}
UIConexao uic = new UIConexao();
uic.ShowDialog();
objbo = uic.tbo;
toolStripDropDownButton1.Text = objbo.DataBase;
if (objbo.DataBase == null)
{
Application.Exit();
}
}
public UIGeradorCSharp(TabelasBO objbo)
{
InitializeComponent();
this.objbo = objbo;
}
private void lbTabelas_SelectedIndexChanged(object sender, EventArgs e)
{
clBoxColunas.Items.Clear();
TabelasBO objTabBo = new TabelasBO();
List<TabelaModel> lColunas = objTabBo.GetColunasByTabela(lbTabelas.SelectedValue.ToString());
foreach (TabelaModel item in lColunas.OrderBy(l => l.NomeColuna))
{
clBoxColunas.Items.Add(item.NomeColuna);
if (objConstbo.ConstrExists("constr" + "_" + lbTabelas.SelectedValue.ToString() +
"_" + item.NomeColuna))
{
clBoxColunas.SetItemChecked(
clBoxColunas.Items.IndexOf(item.NomeColuna), true);
}
}
}
public UIListaTabelasFilha(string nmTabPai, TabelasBO objbo)
{
InitializeComponent();
kryptonDataGridView1.DataSource = objbo.GetListaTabFilha(nmTabPai);
}
public UIListaTabelasFilha(string nmTabPai, TabelasBO objbo)
{
InitializeComponent();
kryptonDataGridView1.DataSource = objbo.GetListaTabFilha(nmTabPai);
}
public UIGeradorCSharp(TabelasBO objbo)
{
InitializeComponent();
this.objbo = objbo;
}
