public DataTable GetDataTable()
{
DataTable dt = new DataTable();
string sql = "SELECT id, nome, tipo FROM usuario;";
dt = My.GetDataTable(sql);
My.FechaConexao();
return(dt);
}
public DataTable GetDataTable()
{
DataTable dt = new DataTable();
string sql = "SELECT * FROM MILITAR;";
dt = My.GetDataTable(sql);
My.FechaConexao();
return(dt);
}
public DataTable GetTable(int id = 0)
{
DataTable dt = new DataTable();
string sql = $@"SELECT g.id AS id
, CONCAT(m.graduacao, ' ', m.nome) AS nome
, g.motivo AS motivo
, g.saida AS saida
, g.retorno AS retorno
FROM gerenciamento AS g
INNER JOIN militar AS m
ON g.id_militar = m.id";
if (id != 0)
{
sql += $" WHERE m.id = {id};";
}
dt = My.GetDataTable(sql);
My.FechaConexao();
return(dt);
}
