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;
}
}
