private void PersonalizarGrilla() { BrowserGridEX.RootTable.Groups.Clear(); if (ArmaGruposUiCheckBox.Checked) { Janus.Windows.GridEX.GridEXGroup grupo1 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[1]); grupo1.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo1); } BrowserGridEX.RootTable.Columns[0].Visible = !ArmaGruposUiCheckBox.Checked; BrowserGridEX.RootTable.Columns[1].Visible = !ArmaGruposUiCheckBox.Checked; }
private void formaEPagesësToolStripMenuItem_Click(object sender, EventArgs e) { if (formaEPagesësToolStripMenuItem.Checked) { Janus.Windows.GridEX.GridEXGroup g = new Janus.Windows.GridEX.GridEXGroup(); g.Column = gridDetaje.RootTable.Columns["FORMA_PAGESA"]; gridDetaje.RootTable.Groups.Add(g); } else { gridDetaje.RootTable.Groups.Remove(gridDetaje.RootTable.Groups["FORMA_PAGESA"]); } }
private void kamarieriToolStripMenuItem_Click(object sender, EventArgs e) { if (kamarieriToolStripMenuItem.Checked) { Janus.Windows.GridEX.GridEXGroup g = new Janus.Windows.GridEX.GridEXGroup(); g.Column = gridDetaje.RootTable.Columns["EMRI_KAMARIERI"]; gridDetaje.RootTable.Groups.Add(g); } else { gridDetaje.RootTable.Groups.Remove(gridDetaje.RootTable.Groups["EMRI_KAMARIERI"]); } }
private void tavolinaToolStripMenuItem_Click(object sender, EventArgs e) { if (tavolinaToolStripMenuItem.Checked) { Janus.Windows.GridEX.GridEXGroup g = new Janus.Windows.GridEX.GridEXGroup(); g.Column = gridDetaje.RootTable.Columns["TAVOLINA"]; gridDetaje.RootTable.Groups.Add(g); } else { gridDetaje.RootTable.Groups.Remove(gridDetaje.RootTable.Groups["TAVOLINA"]); } }
private void PersonalizarGrilla(DataTable Datos) { //Columnas BrowserGridEX.RootTable.Columns.Clear(); BrowserGridEX.RootTable.GroupTotals = Janus.Windows.GridEX.GroupTotals.Always; for (int i = 0; i<Datos.Columns.Count; i++) { string nombre = Datos.Columns[i].ColumnName; BrowserGridEX.RootTable.Columns.Add(nombre, Janus.Windows.GridEX.ColumnType.Text); int elemento = BrowserGridEX.RootTable.Columns.Count - 1; string tipo = Datos.Columns[i].DataType.Name; switch (tipo) { case "String": switch (nombre) { case "Zona": case "Vendedor": BrowserGridEX.RootTable.Columns[elemento].Width = 100; break; case "Articulo": BrowserGridEX.RootTable.Columns[elemento].Width = 250; break; case "Familia": BrowserGridEX.RootTable.Columns[elemento].Width = 150; break; } break; case "Decimal": BrowserGridEX.RootTable.Columns[elemento].FormatMode = Janus.Windows.GridEX.FormatMode.UseIFormattable; BrowserGridEX.RootTable.Columns[elemento].FormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].DefaultGroupFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].TotalFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].TextAlignment = Janus.Windows.GridEX.TextAlignment.Far; if (elemento != Datos.Columns.Count - 1) { BrowserGridEX.RootTable.Columns[elemento].AggregateFunction = Janus.Windows.GridEX.AggregateFunction.Sum; } if (nombre == "Total Plan-" + PeriodoDesdeCalendarCombo.Value.ToString("yyyy") || nombre == "Total Real-" + PeriodoDesdeCalendarCombo.Value.ToString("yyyy") || nombre == "Desvio Plan-" + PeriodoDesdeCalendarCombo.Value.ToString("yyyy")) { BrowserGridEX.RootTable.Columns[elemento].Width = 110; } else { BrowserGridEX.RootTable.Columns[elemento].Width = 75; } break; default: throw new Microsoft.ApplicationBlocks.ExceptionManagement.Validaciones.ElementoInexistente("Tipo de dato " + tipo); } BrowserGridEX.RootTable.Columns[elemento].Caption = Datos.Columns[i].Caption; } //Cortes de control if (ArmaGruposUiCheckBox.Checked) { BrowserGridEX.RootTable.Groups.Clear(); Janus.Windows.GridEX.GridEXGroup grupo0 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[0]); grupo0.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo0); BrowserGridEX.RootTable.Columns[0].Visible = false; Janus.Windows.GridEX.GridEXGroup grupo1 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[1]); grupo1.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo1); BrowserGridEX.RootTable.Columns[1].Visible = false; Janus.Windows.GridEX.GridEXGroup grupo2 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[2]); grupo2.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo2); BrowserGridEX.RootTable.Columns[2].Visible = false; } }
private void PersonalizarGrillaDs(DataSet Datos) { //Columnas BrowserGridEX.RootTable.Columns.Clear(); if (BrowserGridEX.RootTable.ChildTables.Count != 0) { BrowserGridEX.RootTable.ChildTables.Clear(); } BrowserGridEX.Hierarchical = true; BrowserGridEX.RowHeaders = Janus.Windows.GridEX.InheritableBoolean.True; BrowserGridEX.RootTable.GroupTotals = Janus.Windows.GridEX.GroupTotals.Always; for (int t = 0; t < Datos.Tables.Count; t++) { if (t == 1) { Janus.Windows.GridEX.GridEXTable table = new Janus.Windows.GridEX.GridEXTable(); BrowserGridEX.RootTable.ChildTables.Add(table); BrowserGridEX.RootTable.ChildTables[t - 1].Key = "Nivel" + Convert.ToString(t + 1); BrowserGridEX.RootTable.ChildTables[t - 1].Caption = "Nivel" + Convert.ToString(t + 1); } else if (t > 1) { Janus.Windows.GridEX.GridEXTable table = new Janus.Windows.GridEX.GridEXTable(); BrowserGridEX.RootTable.ChildTables[0].ChildTables.Add(table); BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Key = "Nivel" + Convert.ToString(t + 1); BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Caption = "Nivel" + Convert.ToString(t + 1); } for (int i = 0; i < Datos.Tables[t].Columns.Count; i++) { string nombre = Datos.Tables[t].Columns[i].ColumnName; if (t == 1) { BrowserGridEX.RootTable.ChildTables[t - 1].Columns.Add(nombre, Janus.Windows.GridEX.ColumnType.Text); int elemento = BrowserGridEX.RootTable.ChildTables[t - 1].Columns.Count - 1; BrowserGridEX.RootTable.ChildTables[t - 1].Columns[elemento].Caption = Datos.Tables[t].Columns[i].Caption; if (elemento == 2) { BrowserGridEX.RootTable.ChildTables[0].Columns[elemento].Width = 300; } } else if (t > 1) { BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns.Add(nombre, Janus.Windows.GridEX.ColumnType.Text); int elemento = BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns.Count - 1; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].Caption = Datos.Tables[t].Columns[i].Caption; string tipo = Datos.Tables[t].Columns[i].DataType.Name; switch (tipo) { case "String": switch (nombre) { case "Descr": BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].Width = 350; break; } break; case "Double": case "Decimal": BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].FormatMode = Janus.Windows.GridEX.FormatMode.UseIFormattable; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].FormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].DefaultGroupFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].TotalFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].TextAlignment = Janus.Windows.GridEX.TextAlignment.Far; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].AggregateFunction = Janus.Windows.GridEX.AggregateFunction.Sum; switch (nombre) { case "Total Saldo": BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].Width = 95; break; default: BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].Width = 75; break; } break; case "DateTime": BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].FormatMode = Janus.Windows.GridEX.FormatMode.UseIFormattable; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].FormatString = "dd/MM/yyyy"; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].TextAlignment = Janus.Windows.GridEX.TextAlignment.Center; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].Width = 75; BrowserGridEX.RootTable.ChildTables[0].ChildTables[t - 2].Columns[elemento].Visible = true; break; } } else { BrowserGridEX.RootTable.Columns.Add(nombre, Janus.Windows.GridEX.ColumnType.Text); int elemento = BrowserGridEX.RootTable.Columns.Count - 1; BrowserGridEX.RootTable.Key = "Nivel1"; BrowserGridEX.RootTable.Caption = "Nivel1"; BrowserGridEX.RootTable.Columns[elemento].Width = 100; BrowserGridEX.RootTable.Columns[elemento].Caption = Datos.Tables[t].Columns[i].Caption; } } } BrowserGridEX.BindingContext = new BindingContext(); BrowserGridEX.RootTable.ChildTables["Nivel2"].DataMember = "Nivel1_Nivel2"; BrowserGridEX.RootTable.ChildTables["Nivel2"].ChildTables["Nivel3"].DataMember = "Nivel2_Nivel3"; BrowserGridEX.RootTable.ChildTables["Nivel2"].ChildTables["Nivel4"].DataMember = "Nivel2_Nivel4"; BrowserGridEX.RootTable.ChildTables[0].Columns[0].Visible = false; BrowserGridEX.RootTable.Groups.Clear(); Janus.Windows.GridEX.GridEXGroup grupo1 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[4]); grupo1.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[0].Visible = false; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[1].Visible = false; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[3].Visible = false; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[4].Visible = false; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[5].Visible = false; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Groups.Add(grupo1); BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Groups[0].GroupPrefix = ""; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Groups[0].HeaderCaption = ""; Janus.Windows.GridEX.GridEXSortKey s = new Janus.Windows.GridEX.GridEXSortKey(); s.Column = BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[2]; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].SortKeys.Add(s); Janus.Windows.GridEX.GridEXGroup grupo2 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Columns[1]); grupo2.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Groups.Add(grupo2); BrowserGridEX.RootTable.ChildTables[0].ChildTables[0].Groups[1].GroupPrefix = ""; grupo2.SortOrder = Janus.Windows.GridEX.SortOrder.Descending; Janus.Windows.GridEX.GridEXGroup grupo3 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.ChildTables[0].ChildTables[1].Columns[3]); grupo3.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.ChildTables[0].ChildTables[1].Groups.Add(grupo3); BrowserGridEX.RootTable.ChildTables[0].ChildTables[1].Groups[0].GroupPrefix = ""; BrowserGridEX.RootTable.ChildTables[0].ChildTables[1].Columns[0].Visible = false; BrowserGridEX.RootTable.ChildTables[0].ChildTables[1].Columns[3].Visible = false; }
private void PersonalizarGrilla(DataTable Datos) { //Columnas BrowserGridEX.RootTable.Columns.Clear(); BrowserGridEX.RootTable.GroupTotals = Janus.Windows.GridEX.GroupTotals.Always; for (int i = 0; i<Datos.Columns.Count; i++) { string nombre = Datos.Columns[i].ColumnName; BrowserGridEX.RootTable.Columns.Add(nombre, Janus.Windows.GridEX.ColumnType.Text); int elemento = BrowserGridEX.RootTable.Columns.Count - 1; string tipo = Datos.Columns[i].DataType.Name; switch (tipo) { case "String": switch (nombre) { case "Articulo": BrowserGridEX.RootTable.Columns[elemento].Width = 250; break; case "Vendedor": BrowserGridEX.RootTable.Columns[elemento].Width = 170; break; case "Familia": BrowserGridEX.RootTable.Columns[elemento].Width = 120; break; } break; case "Decimal": BrowserGridEX.RootTable.Columns[elemento].FormatMode = Janus.Windows.GridEX.FormatMode.UseIFormattable; BrowserGridEX.RootTable.Columns[elemento].FormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].DefaultGroupFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].TotalFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].TextAlignment = Janus.Windows.GridEX.TextAlignment.Far; BrowserGridEX.RootTable.Columns[elemento].AggregateFunction = Janus.Windows.GridEX.AggregateFunction.Sum; BrowserGridEX.RootTable.Columns[elemento].Width = 75; break; default: throw new Microsoft.ApplicationBlocks.ExceptionManagement.Validaciones.ElementoInexistente("Tipo de dato " + tipo); } BrowserGridEX.RootTable.Columns[elemento].Caption = Datos.Columns[i].Caption; } //Cortes de control if (ArmaGruposUiCheckBox.Checked) { BrowserGridEX.RootTable.Groups.Clear(); Janus.Windows.GridEX.GridEXGroup grupo1 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[0]); grupo1.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo1); BrowserGridEX.RootTable.Columns[0].Visible = false; switch (TipoReporteNicePanel.Tag.ToString()) { case "Artículos-Vendedores": case "Vendedores-Artículos": Janus.Windows.GridEX.GridEXGroup grupo2 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[1]); grupo2.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo2); BrowserGridEX.RootTable.Columns[1].Visible = false; break; case "Sólo Artículos": break; } } }
private void PersonalizarGrilla(DataTable Datos) { //Columnas BrowserGridEX.RootTable.Columns.Clear(); BrowserGridEX.RootTable.GroupTotals = Janus.Windows.GridEX.GroupTotals.Always; for (int i = 0; i<Datos.Columns.Count; i++) { string nombre = Datos.Columns[i].ColumnName; BrowserGridEX.RootTable.Columns.Add(nombre, Janus.Windows.GridEX.ColumnType.Text); int elemento = BrowserGridEX.RootTable.Columns.Count - 1; string tipo = Datos.Columns[i].DataType.Name; switch (tipo) { case "String": switch (nombre) { case "Zona": BrowserGridEX.RootTable.Columns[elemento].Width = 100; break; case "Cliente": BrowserGridEX.RootTable.Columns[elemento].Width = 250; break; case "Descr": BrowserGridEX.RootTable.Columns[elemento].Width = 300; break; } break; case "Double": case "Decimal": BrowserGridEX.RootTable.Columns[elemento].FormatMode = Janus.Windows.GridEX.FormatMode.UseIFormattable; BrowserGridEX.RootTable.Columns[elemento].FormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].DefaultGroupFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].TotalFormatString = "######,##0.00;(-######,##0.00)"; BrowserGridEX.RootTable.Columns[elemento].TextAlignment = Janus.Windows.GridEX.TextAlignment.Far; BrowserGridEX.RootTable.Columns[elemento].AggregateFunction = Janus.Windows.GridEX.AggregateFunction.Sum; switch (nombre) { case "Total Saldo": BrowserGridEX.RootTable.Columns[elemento].Width = 95; break; default: BrowserGridEX.RootTable.Columns[elemento].Width = 75; break; } break; case "DateTime": BrowserGridEX.RootTable.Columns[elemento].FormatMode = Janus.Windows.GridEX.FormatMode.UseIFormattable; BrowserGridEX.RootTable.Columns[elemento].FormatString = "dd/MM/yyyy"; BrowserGridEX.RootTable.Columns[elemento].TextAlignment = Janus.Windows.GridEX.TextAlignment.Center; BrowserGridEX.RootTable.Columns[elemento].Width = 75; BrowserGridEX.RootTable.Columns[elemento].Visible = true; break; default: throw new Microsoft.ApplicationBlocks.ExceptionManagement.Validaciones.ElementoInexistente("Tipo de dato " + tipo); } BrowserGridEX.RootTable.Columns[elemento].Caption = Datos.Columns[i].Caption; } //Resaltar deuda vencida. Janus.Windows.GridEX.GridEXFormatCondition condicional = new Janus.Windows.GridEX.GridEXFormatCondition(); condicional.Column = BrowserGridEX.RootTable.Columns["FecVto"]; Janus.Windows.GridEX.GridEXFilterCondition fc = new Janus.Windows.GridEX.GridEXFilterCondition(); condicional.ConditionOperator = Janus.Windows.GridEX.ConditionOperator.LessThan; condicional.FormatStyle.ForeColor = System.Drawing.Color.Red; condicional.TargetColumn = BrowserGridEX.RootTable.Columns["Descr"]; condicional.Value1 = PeriodoDesdeCalendarCombo.Value; BrowserGridEX.RootTable.FormatConditions.Add(condicional); //Cortes de control if (ArmaGruposUiCheckBox.Checked) { BrowserGridEX.Hierarchical = true; BrowserGridEX.RootTable.Groups.Clear(); Janus.Windows.GridEX.GridEXGroup grupo1 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[0]); grupo1.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo1); BrowserGridEX.RootTable.Columns[0].Visible = false; Janus.Windows.GridEX.GridEXGroup grupo2 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[1]); grupo2.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo2); BrowserGridEX.RootTable.Columns[1].Visible = false; Janus.Windows.GridEX.GridEXGroup grupo3 = new Janus.Windows.GridEX.GridEXGroup(BrowserGridEX.RootTable.Columns[2]); grupo2.GroupInterval = Janus.Windows.GridEX.GroupInterval.Value; BrowserGridEX.RootTable.Groups.Add(grupo3); BrowserGridEX.RootTable.Columns[2].Visible = false; } }