/// <summary>
/// Método que carrega o combo de data type
/// </summary>
private void CarregaComboDataTypes()
{
Util.CL_Files.WriteOnTheLog("UC_CadastroCampos.CarregaComboDataTypes()", Util.Global.TipoLog.DETALHADO);
string sentenca = new DAO.MD_TipoCampo().table.CreateCommandSQLTable();
DataTable table = new DataTable();
table.Load(DataBase.Connection.Select(sentenca));
this.cmb_datatype.DataSource = table.DefaultView;
this.cmb_datatype.DisplayMember = "NOME";
this.cmb_datatype.ValueMember = "CODIGO";
this.cmb_datatype.SelectedIndex = 0;
}
/// <summary>
/// Método que inclui os tipops principais de data types
/// </summary>
private void IncluirPrincipais()
{
Util.CL_Files.WriteOnTheLog("MD_TipoCampo.IncluirPrincipais()", Util.Global.TipoLog.DETALHADO);
List <DAO.MD_TipoCampo> tipos = new List <DAO.MD_TipoCampo>();
DAO.MD_TipoCampo sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "CHAR";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "VARCHAR";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "TEXT";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "BINARY";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "IMAGE";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "SMALLINT";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "INT";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "BIGINT";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "DECIMAL";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "NUMERIC";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "MONEY";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "FLOAT";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "REAL";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "DATETIME";
tipos.Add(sample);
sample = new DAO.MD_TipoCampo(DataBase.Connection.GetIncrement(this.DAO.table.Table_Name));
sample.Nome = "TIMESTAMP";
tipos.Add(sample);
foreach (DAO.MD_TipoCampo campo in tipos)
{
campo.Insert();
}
}
/// <summary>
/// Constutor princiapl da classe
/// </summary>
/// <param name="codigo"></param>
public MD_TipoCampo(int codigo)
{
Util.CL_Files.WriteOnTheLog("MD_Tabela()", Util.Global.TipoLog.DETALHADO);
this.DAO = new DAO.MD_TipoCampo(codigo);
}
