public void AddChildTable(REPORT.Table.TableVo childvo)
{
Table child = new Table(this.MAINREPORT, this);
child.LOAD(childvo);
this.AddChildTable(child);
}
/// <summary>
/// NEW LOAD METHOD
/// </summary>
/// <param name="tablevo"></param>
public void LOAD(REPORT.Table.TableVo tablevo)
{
//if(this.MAIN!=null)
// this.MAIN.CHILDREN.Add(tablevo);
this.THISTABLE = tablevo;
this.TABLE = tablevo.TABELA;
//*
new REPORT.Fields.FieldsDao().load(this.THISTABLE.FIELDS, this.ID);
//new REPORT.GroupBy.GroupByDao().load(this.THISTABLE.GROUPBY, this.ID);
//new REPORT.Filters.FiltersDao().Load(this.THISTABLE.FILTERS, this.ID);
//new REPORT.OrderBy.OrderByDao().load(this.THISTABLE.ORDERBY, this.ID);
//new REPORT.Params.ParamsDao().Load( this.THISTABLE.PARAMS , this.ID);
//*/
//*
this.FIELDS.LOAD(this.THISTABLE.FIELDS);
//this.GROUPBY.LOAD();
//this.FILTERS.LOAD();
//this.ORDERBY.LOAD();
//this.PARAMS.LOAD( );
//*/
if (this.ID != 0)
{
this.TABLE = this.THISTABLE.TABELA;
//this.RELATEDTABLES.Clear();
//this.RELATEDTABLES.Add(this.TABLE);
#region TABELAS FILHO
//*
//List<REPORT.Table.TableVo> childrenTable = new List<REPORT.Table.TableVo>();
new REPORT.Table.TableDao().load(this.THISTABLE.CHILDREN, this.REPORTID, this.ID);
//*/
this.AddChildrenTable(this.THISTABLE.CHILDREN);
#endregion
}
this.TOTALIZAR.Visible = this.MAIN != null;
//this.ReloadRelatedTables();
if (this.CHILDREN != null &&
this.THISTABLE != null &&
this.THISTABLE.CHILDREN != null)
{
for (int idx = 0; idx < this.THISTABLE.CHILDREN.Count; idx++)
{
this.CHILDREN[idx].LOAD(this.THISTABLE.CHILDREN[idx]);
}
}
//this.RELOAD();
}
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);
}
}
protected void strTable_TextChanged(object sender, EventArgs e)
{
//Table child = new Table(this.THISTABLE);
//child.REPORTID = this.REPORTID;
REPORT.Table.TableVo cTable = new REPORT.Table.TableVo();
new REPORT.Table.TableDao().load(cTable, this.REPORTID, this.ID);
cTable.MAINID = this.THISTABLE.ID;
cTable.IDREPORT = this.REPORTID;
cTable.TABELA = (sender as Control).Text;
// child.LOAD(cTable);
this.AddChildTable(cTable);
}
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;
}
}
