private void initializer(REPORT.Report.ReportVo report, Table main, string table)
{
InitializeComponent();
this.MAINREPORT = report;
//if(this.MAINREPORT!=null)
// this.REPORTID = this.MAINREPORT.ID;
this.main = main;
this.TABLE = table;
/// LIMPANDO AS ABAS
this.tpFieldsReturn.Controls.Clear();
this.linksPainel.Controls.Clear();
this.tpGourp.Controls.Clear();
this.tpFilter.Controls.Clear();
this.tpOrder.Controls.Clear();
this.tpParms.Controls.Clear();
/// INICIALIZANDO OBJETOS
//this.CHILDREN = new List<Table>();
this.FIELDS = new Fields(this);
this.FILTERS = new Filters(this);
this.ORDERBY = new OrderBy(this);
this.PARAMS = new Params(this);
/// ADCIONANDO OBJETOS NAS ABAS
FormatScreen.AddControl(tpFieldsReturn, this.FIELDS);
//FormatScreen.AddControl(tpGourp , this.GROUPBY);
FormatScreen.AddControl(tpFilter, this.FILTERS);
FormatScreen.AddControl(tpOrder, this.ORDERBY);
FormatScreen.AddControl(tpParms, this.PARAMS);
DataTable dtRelType = new DataTable();
string typeDisplay = "display";
string typeValue = "value";
cbRelatedType.DisplayMember = typeDisplay;
cbRelatedType.ValueMember = typeValue;
dtRelType.Columns.Add(typeDisplay);
dtRelType.Columns.Add(typeValue);
dtRelType.Rows.Add("AMBAS AS TABELAS ", " INNER JOIN ");
dtRelType.Rows.Add("SOMENTE NA RELACIONADA", " LEFT JOIN ");
dtRelType.Rows.Add("SOMENTE NESTA ", " RIGHT JOIN ");
cbRelatedType.DataSource = dtRelType.DefaultView;
/*
* cbRelatedTable.DisplayMember = SXManager.TableDisplayMember;
* cbRelatedTable.ValueMember = SXManager.TableValueMember;
* //*/
// -------------------------------
dataRelatedTable = new DataTable();
dataRelatedTable.Columns.Add("display");
dataRelatedTable.Columns.Add("value");
cbRelatedTable.DisplayMember = "display";
cbRelatedTable.ValueMember = "value";
cbRelatedTable.DataSource = dataRelatedTable.DefaultView;
}
public ViewReport(string reportname)
{
REPORT.Report.ReportVo relatorio = new REPORT.Report.ReportVo();
new REPORT.Report.ReportDao().load(relatorio, 0, "nome = '" + reportname + "'");
this.RELATORIO = relatorio;
initializer();
}
public ViewReport(int reportId)
{
REPORT.Report.ReportVo relatorio = new REPORT.Report.ReportVo();
new REPORT.Report.ReportDao().load(relatorio, 0, "id = " + reportId);
this.RELATORIO = relatorio;
initializer();
}
public ViewReport(REPORT.Report.ReportVo report)
{
this.RELATORIO = report;
initializer();
}
public Table(REPORT.Report.ReportVo report, Table main, string table)
{
this.initializer(report, main, table);
}
public Table(REPORT.Report.ReportVo report, Table main)
{
this.initializer(report, main, null);
}
public Table(REPORT.Report.ReportVo report, string table)
{
this.initializer(report, null, table);
}
public Table(REPORT.Report.ReportVo report)
{
this.initializer(report, null, null);
}
