protected void grdPronostico_PivotGridCellExporting(object sender, PivotGridCellExportingArgs e)
{
try
{
PivotGridBaseModelCell modelDataCell = e.PivotGridModelCell as PivotGridBaseModelCell;
if (modelDataCell != null)
{
AddStylesToDataCells(modelDataCell, e);
}
if (modelDataCell.TableCellType == PivotGridTableCellType.RowHeaderCell)
{
AddStylesToRowHeaderCells(modelDataCell, e);
}
if (modelDataCell.TableCellType == PivotGridTableCellType.ColumnHeaderCell)
{
AddStylesToColumnHeaderCells(modelDataCell, e);
}
if (modelDataCell.IsGrandTotalCell)
{
e.ExportedCell.Style.BackColor = Color.FromArgb(128, 128, 128);
e.ExportedCell.Style.Font.Bold = true;
}
if (IsTotalDataCell(modelDataCell))
{
e.ExportedCell.Style.BackColor = Color.FromArgb(150, 150, 150);
e.ExportedCell.Style.Font.Bold = true;
AddBorders(e);
}
if (IsGrandTotalDataCell(modelDataCell))
{
e.ExportedCell.Style.BackColor = Color.FromArgb(128, 128, 128);
e.ExportedCell.Style.Font.Bold = true;
AddBorders(e);
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
private void AddStylesToRowHeaderCells(PivotGridBaseModelCell modelDataCell, PivotGridCellExportingArgs e)
{
if (e.ExportedCell.Table.Columns[e.ExportedCell.ColIndex].Width == 0)
{
e.ExportedCell.Table.Columns[e.ExportedCell.ColIndex].Width = 80D;
}
if (modelDataCell.IsTotalCell)
{
e.ExportedCell.Style.BackColor = Color.FromArgb(150, 150, 150);
e.ExportedCell.Style.Font.Bold = true;
}
else
{
e.ExportedCell.Style.BackColor = Color.FromArgb(192, 192, 192);
}
AddBorders(e);
}
private void AddStylesToDataCells(PivotGridBaseModelCell modelDataCell, PivotGridCellExportingArgs e)
{
if (modelDataCell.Data != null && modelDataCell.Data.GetType() == typeof(decimal))
{
decimal value = Convert.ToDecimal(modelDataCell.Data);
if (value > 100000)
{
e.ExportedCell.Style.BackColor = Color.FromArgb(51, 204, 204);
AddBorders(e);
}
e.ExportedCell.Format = "0.0";
if (modelDataCell.Field.Caption == "VentaPresupuesto")
{
e.ExportedCell.Format = "$0.0";
}
}
}
protected void RadPivotGrid1_PivotGridCellExporting(object sender, PivotGridCellExportingArgs e)
{
//if (!CheckBox3.Checked)
//{
// return;
//}
PivotGridBaseModelCell modelDataCell = e.PivotGridModelCell as PivotGridBaseModelCell;
if (modelDataCell != null)
{
AddStylesToDataCells(modelDataCell, e);
}
if (modelDataCell.TableCellType == PivotGridTableCellType.RowHeaderCell)
{
AddStylesToRowHeaderCells(modelDataCell, e);
}
if (modelDataCell.TableCellType == PivotGridTableCellType.ColumnHeaderCell)
{
AddStylesToColumnHeaderCells(modelDataCell, e);
}
if (modelDataCell.IsGrandTotalCell)
{
e.ExportedCell.Style.BackColor = Color.FromArgb(128, 128, 128);
e.ExportedCell.Style.Font.Bold = true;
}
if (IsTotalDataCell(modelDataCell))
{
e.ExportedCell.Style.BackColor = Color.FromArgb(150, 150, 150);
e.ExportedCell.Style.Font.Bold = true;
AddBorders(e);
}
if (IsGrandTotalDataCell(modelDataCell))
{
e.ExportedCell.Style.BackColor = Color.FromArgb(128, 128, 128);
e.ExportedCell.Style.Font.Bold = true;
AddBorders(e);
}
}
protected void grdIndicadores_OnPivotGridCellExporting(object sender, PivotGridCellExportingArgs e)
{
PivotGridBaseModelCell modelDataCell = e.PivotGridModelCell as PivotGridBaseModelCell;
if (modelDataCell != null)
{
AddStylesToDataCells(modelDataCell, e);
}
if (modelDataCell.TableCellType == PivotGridTableCellType.RowHeaderCell)
{
AddStylesToRowHeaderCells(modelDataCell, e);
}
if (modelDataCell.TableCellType == PivotGridTableCellType.ColumnHeaderCell)
{
AddStylesToColumnHeaderCells(modelDataCell, e);
}
if (modelDataCell.IsGrandTotalCell)
{
e.ExportedCell.Style.BackColor = Color.FromArgb(128, 128, 128);
e.ExportedCell.Style.Font.Bold = true;
}
if (IsTotalDataCell(modelDataCell))
{
e.ExportedCell.Style.BackColor = Color.FromArgb(150, 150, 150);
e.ExportedCell.Style.Font.Bold = true;
AddBorders(e);
}
if (IsGrandTotalDataCell(modelDataCell))
{
e.ExportedCell.Style.BackColor = Color.FromArgb(128, 128, 128);
e.ExportedCell.Style.Font.Bold = true;
AddBorders(e);
}
}
