public string GerarBody()
{
var classe = new StringBuilder();
classe.Append("namespace Model" + N);
classe.Append("{" + N);
classe.Append($" public class {NomeTabela}" + N);
classe.Append(" {" + N + N);
var atributos = new SQLTables().ListarAtributos(NomeTabela);
foreach (var item in atributos)
{
classe.Append(" /// <summary>" + N);
classe.Append($" /// {item.COMMENTS}" + N);
classe.Append(" /// </summary>" + N);
classe.Append(
$" public {CSharpTypesSQL.GetTypeAtribute(item.DATA_TYPE, item.IS_NULLABLE)} {item.COLUMN_NAME} {{ get; set; }}" +
N);
classe.Append(N);
}
classe.Append(" }" + N);
classe.Append("}" + N);
return(GerarUsing() + classe.ToString());
}
public string GerarBody()
{
var atributos = new SQLTables().ListarAtributos(NomeTabela);
var classe = new StringBuilder();
classe.Append($"package model;{N}{N}");
classe.Append(Imports());
classe.Append("@XmlRootElement" + N);
classe.Append($"public class {NomeTabela.ToFirstCharToUpper()} {{{N}");
classe.Append(AtributosHeader(atributos));
classe.Append(AtributosBody(atributos));
classe.Append("}" + Environment.NewLine);
return(classe.ToString());
}
private void db2Schema_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
System.Data.DataSet dat_set = this.Data.Database2.getTables();
foreach (System.Data.DataRow dRow in dat_set.Tables[0].Rows)
{
if (db1Schema.CancellationPending)
{
e.Cancel = true;
break;
}
SQLTables table = new SQLTables()
{
TableName = dRow["TableName"].ToString(),
Fields = this.Data.Database2.getFields(dRow["TableName"].ToString())
};
this.Data.DB2Tables.Add(table);
}
}
private void _SQLTables(SqlInstances sqlInstances)
{
if (0 == databases.Count)
{
sD = new SQLDatabase(credentials);
sD.SetComputerName(sqlInstances.Server);
sD.SetInstance(sqlInstances.ServerInstance);
if (nodefaults)
{
sD.EnableNoDefaultsFilter();
}
if (hasAccess)
{
sD.EnableHasAccessFilter();
}
if (sysadmin)
{
sD.EnableSysAdminFilter();
}
sD.Query();
databases = sD.GetResults();
}
SQLTables sT = new SQLTables(credentials);
sT.SetComputerName(sqlInstances.Server);
sT.SetInstance(sqlInstances.ServerInstance);
var results = new List <SQLTables.Table>();
foreach (var d in databases)
{
sT.SetDatabase(d.DatabaseName);
sT.Query();
results.AddRange(sT.GetResults());
}
_PrintOutput(results);
}
