public List <TableName> ListaTodasTabelas()
{
string query = "select table_name from INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE'";
var result = new List <TableName>();
ExecCommands b = new ExecCommands();
var dr = b.ReturnDadosNew(query, null);
if (dr != null)
{
if (dr.HasRows)
{
while (dr.Read())
{
var linha = new TableName
{
Nome = dr["table_name"].ToString(),
};
result.Add(linha);
}
;
dr.Close();
b.oConnection.Close();
}
}
return(result);
}
public BuildTransitionExecRunner(IProjectMonitor monitor, ExecCommands configuration)
{
this.monitor = monitor;
this.configuration = configuration;
monitor.Polled += Monitor_Polled;
}
public List <Table> CarregaColunas()
{
string query = "SELECT column_name, data_type, character_maximum_length, '' as column_key FROM information_schema.columns WHERE table_name = '" + table + "'";
var result = new List <Table>();
ExecCommands b = new ExecCommands();
var dr = b.ReturnDadosNew(query, null);
if (dr != null)
{
if (dr.HasRows)
{
while (dr.Read())
{
var linha = new Table
{
Key = dr["column_key"].ToString(),
Coluna = dr["column_name"].ToString(),
Tipo = dr["data_type"].ToString(),
Tamanho = dr["character_maximum_length"].ToString()
};
result.Add(linha);
}
;
dr.Close();
b.oConnection.Close();
}
}
return(result);
}
internal override void initializeRound(ExecCommands commands, RobotStatus status)
{
updateStatus(commands, status);
eventManager.Reset();
var start = new StatusEvent(status);
eventManager.Add(start);
setSetCallCount(0);
setGetCallCount(0);
}
public void BindExecControls(ICCTrayMultiConfiguration configuration)
{
ExecCommands config = configuration.Execs;
txtExecSuccess.Text = config.SuccessCommand;
txtExecBroken.Text = config.BrokenCommand;
txtExecBrokenAndBuilding.Text = config.BrokenAndBuildingCommand;
txtExecBuilding.Text = config.BuildingCommand;
txtExecNotConnected.Text = config.NotConnectedCommand;
}
public void ExecutaProc(string query)
{
try
{
ExecCommands b = new ExecCommands();
var res = b.ExecutaComandoSemTransaction(query, null);
}
catch (Exception ex)
{
var teste = ex;
}
}
public override void cleanup()
{
base.cleanup();
// Cleanup and remove current wait condition
waitCondition = null;
// Cleanup and remove the event manager
if (eventManager != null)
{
eventManager.Cleanup();
eventManager = null;
}
graphicsProxy = null;
execResults = null;
status = null;
commands = null;
}
internal override void initializeRound(ExecCommands commands, RobotStatus status)
{
base.initializeRound(commands, status);
isStopped = true;
}
private void updateStatus(ExecCommands commands, RobotStatus status)
{
this.status = status;
this.commands = commands;
}
// -----------
// battle driven methods
// -----------
internal abstract void initializeRound(ExecCommands commands, RobotStatus status);