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 void AddChildTable(Table child)
{
this.CHILDREN.Add(child);
//this.RELATEDTABLES.Add(child.TABLE);
FormatScreen.AddControl(linksPainel, child, true, 3, false, false);
//foreach(Table tab in this.CHILDREN)
// tab.popRelatedtables(dataRelatedChild);
}
private void popScreenFromRecursiveTables()
{
panelParams.Controls.Clear();
REPORT.Table.TableVo tabela = new REPORT.Table.TableVo();
new REPORT.Table.TableDao().load(tabela, this.RELATORIO.ID, 0);
DataTable tabelas = new REPORT.Params.ParamsDao().getRecursiveTables(tabela, "userParms_" + sigaSession.LoggedUser.ID, tabela.ID);
if (tabelas.DefaultView.Count == 0)
{
btnExec_Click(null, null); destroy = true;
}
foreach (DataRow row in tabelas.Rows)
{
string tagFormat = "@$TAB$@.$CAMPO$ ?? '@?@'";
string controle = (string)row["formato"];
string strNomeCampo = new SigaObjects
.SXManager(sigaSession.EMPRESAS[0].CODIGO)
.getFields((string)row["tabela"], SigaObjects.SXManager.FieldValueMember
+ " = '"
+ (string)row["campo"]
+ "'"
, null)
.Rows[0][SigaObjects.SXManager.FieldDisplayMember].ToString();
//
// CONTROLE DE
Control cDE = FormatScreen.getObjectFromSigaType(controle);
string lblDE = strNomeCampo + "\t\t Entre \t\t";
cDE.Tag = tagFormat
.Replace("$TAB$", (string)row["tabela"])
.Replace("$CAMPO$", (string)row["campo"])
.Replace("??", ">=");
FormatScreen.AddControl(panelParams, new Label(lblDE), true, 3, false, false);
FormatScreen.AddControl(panelParams, cDE, true, 3, false, false);
//
// CONTROLE ATE
Control cATE = FormatScreen.getObjectFromSigaType(controle);
string lblATE = string.Format("{0,50}", "e");
cATE.Tag = tagFormat
.Replace("$TAB$", (string)row["tabela"])
.Replace("$CAMPO$", (string)row["campo"])
.Replace("??", "<=");
//FormatScreen.AddControl(panelParams, new Label(lblATE),true, 4, false, false);
FormatScreen.AddControl(panelParams, cATE, true, 3, false, false);
}
}
private void menu_Click(object objSource, ToolBarItemEventArgs objArgs)
{
Control inControl = this.Parent;
SxMakeRelatory rel;
REPORT.ReportVo report;
string relname = "";
switch (objArgs.ToolBarButton.Name.ToLower())
{
case "tbbadd":
#region ADD
this.Parent.Controls.Clear();
rel = new SxMakeRelatory();
rel.Dock = DockStyle.Fill;
FormatScreen.AddControl(inControl, rel, true, 1, true, false);
rel.btnAddNew_Click(null, null);
#endregion
break;
case "tbbver":
#region VER
if (dgvReports.SelectedRows.Count > 0)
{
DataRow row = (DataRow)(dgvReports.DataSource as DataView).Table.Rows[dgvReports.SelectedRows[0].Index];
/*
* Report cReport = new Report();
* cReport.LOAD((string)row["nome"], false);
*
* gridWindow grid = new gridWindow(cReport.TABLE.QUERY.ToString(), null);
* grid.SetGridHeader(cReport.TABLE.FIELDS.TOGRID);
* grid.showWindow();
* //*/
ControlsConfig.formShow(new ViewReport(int.Parse(row["id"].ToString())), this.Form, ControlsConfig.showType.Dialog, null, true);
}
#endregion
break;
case "tbbedit":
#region EDIT
if (dgvReports.SelectedRows.Count > 0)
{
this.Parent.Controls.Clear();
DataRow row = (DataRow)(dgvReports.DataSource as DataView).Table.Rows[dgvReports.SelectedRows[0].Index];
rel = new SxMakeRelatory();
rel.Dock = DockStyle.Fill;
FormatScreen.AddControl(inControl, rel, true, 1, true, false);
relname = (string)row["nome"];
rel.btnAbrir_Click(new Label(relname), null);
}
#endregion
break;
case "tbbdel":
#region DEL
if (dgvReports.SelectedRows.Count > 0)
{
DataRow row = (DataRow)(dgvReports.DataSource as DataView).Table.Rows[dgvReports.SelectedRows[0].Index];
report = new REPORT.ReportVo();
report.ID = int.Parse(row["id"].ToString());
report.IDREPORTGROUP = int.Parse(row["idreportgroup"].ToString());
SigaObjects.Reports.Table.TableVo maintable = new SigaObjects.Reports.Table.TableVo();
new SigaObjects.Reports.Table.TableDao().load(maintable, report.ID, 0);
new SigaObjects.Reports.Report.ReportDao().DeleteRecursiveTables(maintable.ID);
new SigaObjects.Reports.Report.ReportDao().delete(report);
}
#endregion
break;
case "tbbexcel":
#region EXCEL
FormatScreen.showNotImplemented();
#endregion
break;
case "tbbpdf":
#region PDF
FormatScreen.showNotImplemented();
#endregion
break;
default:
break;
}
}