//Inicializa o dataset com as consultas que pertencem ao relatorio
private DataSet initDsConsultas()
{
try
{
using (var ctx = new ReportContext())
{
this.dsConsultasReport = new DataSet("dsReport");
ConnectionFactoryIts conn = new ConnectionFactoryIts(ctx.NameOrConnectionString, 90);
foreach (var item in sourceReport)
{
var myTable = new DataTable();
myTable = conn.ExecuteQueryDataTable(item.Consulta.CorpoQuery);
myTable.TableName = "table_" + item.Consulta.CodigoQuery;
dsConsultasReport.Tables.Add(myTable);
}
return(dsConsultasReport);
}
}
catch (Exception ex)
{
XMessageIts.ExceptionMessage(ex);
return(null);
}
}
private void boundXGridTabDestino()
{
try
{
ConnectionFactoryIts conn = new ConnectionFactoryIts(AppConfigManager.Configuration.AppConfig.ConnectionString);
DataTable dtTabelas = new DataTable("Tabelas");
dtTabelas = conn.ExecuteQueryDataTable("SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
gridControlTabDestino.DataSource = dtTabelas;
}
catch (SqlException ex)
{
LoggerUtilIts.ShowExceptionLogs(ex);
}
}
private void indexColumnsCbColDestino(string tableName)
{
try
{
var dtColumns = new DataTable("ColumnsDestino");
ConnectionFactoryIts cnn = new ConnectionFactoryIts(AppConfigManager.Configuration.AppConfig.ConnectionString);
dtColumns = cnn.ExecuteQueryDataTable(String.Format("SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = {0}", "\'" + tableName + "\'"));
foreach (var col in dtColumns.AsEnumerable())
{
var colDest = new ColunaDestino(col[0].ToString(), col[1].ToString(), col[2].ToString(), col[3].ToString(), col[4].ToString());
repComboDestino.Items.Add(colDest);
}
}
catch (SqlException ex)
{
LoggerUtilIts.ShowExceptionLogs(ex);
}
}