/// <summary>
/// Sets the specified style by rows indexes. The row index is interpreted by index in source table (not reporting version of the table -- i.e. heading rows are not counted, only data)
/// </summary>
/// <param name="style">The style.</param>
/// <param name="rowIndexes">The row indexes.</param>
/// <returns>Rule that was created</returns>
public dataRowIndexDynamicStyle <DataRowInReportTypeEnum> SetStyleForRows(DataRowInReportTypeEnum style, IEnumerable <Int32> rowIndexes)
{
var indexC = new dataRowIndexDynamicStyle <DataRowInReportTypeEnum>(style, rowIndexes);
indexC.indexFromSourceTable = true;
units.Add(indexC);
return(indexC);
}
/// <summary>
/// Sets the specified style by rows indexes. The row index is interpreted by index in source table (not reporting version of the table -- i.e. heading rows are not counted, only data)
/// </summary>
/// <param name="style">The style.</param>
/// <param name="rowIndex">Index of the row.</param>
/// <returns>
/// Rule that was created
/// </returns>
public dataRowIndexDynamicStyle <DataRowInReportTypeEnum> SetStyleForRows(DataRowInReportTypeEnum style, Int32 rowIndex)
{
var indexC = new dataRowIndexDynamicStyle <DataRowInReportTypeEnum>(style, new Int32[] { rowIndex });
indexC.indexFromSourceTable = true;
units.Add(indexC);
return(indexC);
}
public void DeployStyle(Object enumType)
{
key = enumType;
if (enumType is DataRowInReportTypeEnum)
{
DataRowInReportTypeEnum enumType_DataRowInReportTypeEnum = (DataRowInReportTypeEnum)enumType;
DeployDefault(enumType_DataRowInReportTypeEnum);
}
}
/// <summary>
/// Sets the style for rows with value.
/// </summary>
/// <typeparam name="TValueType">The type of the value type.</typeparam>
/// <param name="style">The style.</param>
/// <param name="columnName">Name of the column.</param>
/// <param name="valuesToMatch">The row indexes.</param>
/// <returns></returns>
public dataValueMatchCriterionDynamicStyle <TValueType, DataRowInReportTypeEnum> SetStyleForRowsWithValue <TValueType>(DataRowInReportTypeEnum style, String columnName, IEnumerable <TValueType> valuesToMatch) where TValueType : IComparable
{
var indexC = new dataValueMatchCriterionDynamicStyle <TValueType, DataRowInReportTypeEnum>(valuesToMatch, style, columnName);
units.Add(indexC);
return(indexC);
}
public DataRowMetaDefinition(DataRow instance, DataRowInReportTypeEnum type)
{
rowType = type;
rowInstance = instance;
}
public DataRowMetaDefinition(DataRowInReportTypeEnum type)
{
rowType = type;
}
public DataRowMetaDefinition(DataRowInReportTypeEnum __rowType, templateFieldDataTable __cellDataSource)
{
rowType = __rowType;
cellDataSource = __cellDataSource;
}
public DataRowMetaDefinition(DataRowInReportTypeEnum __rowType, dataPointAggregationType __aggregation)
{
rowType = __rowType;
aggregation = __aggregation;
}
public static ExcelNamedStyleXml MakeStyle(this ExcelStyles styles, dataTableStyleSet styleSet, DataRowInReportTypeEnum data)
{
var output = styles.CreateNamedStyle(data.ToString());
output.Style.SetStyle(styleSet.rowStyles[data]);
return(output);
}
/// <summary>
/// Deploys the style to row.
/// </summary>
/// <param name="ex_row">The ex row.</param>
/// <param name="in_row">The in row.</param>
/// <param name="ws">The ws.</param>
/// <param name="metaSet">The meta set.</param>
public void DeployStyleToRow(ExcelRow ex_row, DataRow in_row, ExcelWorksheet ws, tableStyleRowSetter metaSet = null)
{
DataRowInReportTypeEnum style = DataRowInReportTypeEnum.data;
if (extraRowStyles.ContainsKey(in_row))
{
style = extraRowStyles[in_row];
}
bool isEven = ((in_row.Table.Rows.IndexOf(in_row) % 2) > 0);
Boolean isLegend = in_row.Table.TableName == LEGENDTABLE_NAME;
var baseStyle = styleSet.rowStyles[style];
var rowsMetaSet = this.GetRowMetaSet();
if (metaSet != null)
{
rowsMetaSet = metaSet;
}
var response = rowsMetaSet.evaluate(in_row, this, baseStyle);
if (response != null)
{
if (response.style != null)
{
baseStyle = response.style;
}
}
if (baseStyle == null)
{
baseStyle = styleSet.rowStyles[style];
}
foreach (string s in response.notes)
{
Console.WriteLine(s);
}
ex_row.SetStyle(baseStyle, isEven);
switch (style)
{
case DataRowInReportTypeEnum.columnCaption:
if (!isLegend)
{
foreach (var cpair in categories)
{
foreach (selectZone zone in categories.categoryZones[cpair.Key])
{
var sl = ws.getExcelRange(ex_row, zone);
sl.Style.Fill.PatternType = ExcelFillStyle.Solid;
var col = categories.categoryColors[cpair.Key]; //.First().DefaultBackground(System.Drawing.Color.Gray);
sl.Style.Fill.BackgroundColor.SetColor(col);
sl.Style.Fill.BackgroundColor.Tint = new decimal(0.2);
}
}
}
break;
case DataRowInReportTypeEnum.mergedHeaderTitle:
ws.Cells[ex_row.Row, 1, ex_row.Row, in_row.Table.Columns.Count].Merge = true;
break;
case DataRowInReportTypeEnum.mergedHeaderInfo:
ws.Cells[ex_row.Row, 1, ex_row.Row, in_row.Table.Columns.Count].Merge = true;
break;
case DataRowInReportTypeEnum.mergedFooterInfo:
ws.Cells[ex_row.Row, 1, ex_row.Row, in_row.Table.Columns.Count].Merge = true;
break;
case DataRowInReportTypeEnum.mergedHorizontally:
selectZone z = new selectZone(0, 0, Columns.Count - 1, 0);
var s2l = ws.getExcelRange(ex_row, z);
s2l.Merge = true;
break;
case DataRowInReportTypeEnum.mergedCategoryHeader:
double tn = 0.2;
int hlip = -1;
foreach (var cpair in categories)
{
if (hlip == -1)
{
tn = 0.3;
}
else
{
tn = 0.6;
}
foreach (selectZone zone in categories.categoryZones[cpair.Key])
{
var sl = ws.getExcelRange(ex_row, zone);
sl.Merge = true;
sl.Value = cpair.Key.ToUpper();
sl.Style.Fill.PatternType = ExcelFillStyle.Solid;
var col = categories.categoryColors[cpair.Key]; //.First().DefaultBackground(System.Drawing.Color.Gray);
sl.Style.Fill.BackgroundColor.SetColor(col);
sl.Style.Fill.BackgroundColor.Tint = new decimal(tn);
}
hlip = -hlip;
}
isEven = !isEven;
break;
case DataRowInReportTypeEnum.data:
//ex_row.Style.Font.Size = 9;
foreach (DataColumn dc in in_row.Table.Columns)
{
string format = dc.GetFormatForExcel();
var aligment = dc.GetAligment();
ws.Cells[ex_row.Row, dc.Ordinal + 1].Style.HorizontalAlignment = aligment.GetHorizontalAlignment();
if (!format.isNullOrEmpty())
{
ws.Cells[ex_row.Row, dc.Ordinal + 1].Style.Numberformat.Format = format;
}
//if (dc.GetValueType().isNumber())
//{
// ws.Cells[ex_row.Row, dc.Ordinal + 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
//}
//else if (dc.GetValueType().IsEnum)
//{
// ws.Cells[ex_row.Row, dc.Ordinal + 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
//}
//else if (dc.GetValueType().isBoolean())
//{
// ws.Cells[ex_row.Row, dc.Ordinal + 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
//}
//else
//{
// ws.Cells[ex_row.Row, dc.Ordinal + 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
//}
}
break;
}
if (!isLegend)
{
if (ex_row.Row == (RowStart + RowsWithMaxAggregation))
{
ex_row.Style.Border.Bottom.Style = ExcelBorderStyle.Dotted;
ex_row.Style.Border.Bottom.Color.SetColor(System.Drawing.Color.Red);
}
}
}
public void DeployDefault(DataRowInReportTypeEnum enumType)
{
key = enumType;
Background.FillType = reporting.style.enums.styleFillType.Solid;
Text.FontName = reporting.style.enums.aceFont.Calibri;
Cell.aligment = reporting.zone.textCursorZoneCorner.Left;
Text.FontSize = 10;
Cell.doWrapText = true;
BackgroundAlt.Color = Background.Color;
switch (enumType)
{
case DataRowInReportTypeEnum.columnCaption:
Background.Color = System.Drawing.Color.DarkGray;
Background.Tint = 0.6;
BackgroundAlt.Color = System.Drawing.Color.DarkGray;
BackgroundAlt.Tint = 0.7;
Text.Style = reporting.style.enums.styleTextTypeEnum.bold;
Cell.aligment = reporting.zone.textCursorZoneCorner.center;
Cell.minSize.height = 30;
break;
case DataRowInReportTypeEnum.dataHighlightA:
Text.Style = reporting.style.enums.styleTextTypeEnum.bold;
Cell.sizeAndBorder.setup(3, 0, Color.OrangeRed, 1, reporting.style.enums.styleBorderType.Dotted, styleSideDirection.top, styleSideDirection.bottom);
Background.Color = Color.OrangeRed;
Background.Tint = 0.5;
BackgroundAlt.Color = Color.Orange;
BackgroundAlt.Tint = 0.5;
break;
case DataRowInReportTypeEnum.dataHighlightB:
Text.Style = reporting.style.enums.styleTextTypeEnum.bold;
Cell.sizeAndBorder.setup(3, 0, Color.CadetBlue, 1, reporting.style.enums.styleBorderType.Dotted, styleSideDirection.top, styleSideDirection.bottom);
Background.Color = Color.CadetBlue;
Background.Tint = 0.5;
BackgroundAlt.Color = Color.DarkSeaGreen;
BackgroundAlt.Tint = 0.5;
break;
case DataRowInReportTypeEnum.dataHighlightC:
Text.Style = reporting.style.enums.styleTextTypeEnum.bold;
Cell.sizeAndBorder.setup(3, 0, Color.SteelBlue, 1, reporting.style.enums.styleBorderType.Dotted, styleSideDirection.top, styleSideDirection.bottom);
Background.Color = Color.SteelBlue;
Background.Tint = 0.5;
BackgroundAlt.Color = Color.SteelBlue;
BackgroundAlt.Tint = 0.3;
break;
case DataRowInReportTypeEnum.removedLight:
Text.Style = reporting.style.enums.styleTextTypeEnum.regular | styleTextTypeEnum.striketrough;
//Cell.sizeAndBorder.setup(0, 0, Color.Gray, 0, reporting.style.enums.styleBorderType.None);
Text.Color = Color.LightGray;
Background.Color = Color.WhiteSmoke;
BackgroundAlt.Color = Color.Snow;
Background.Tint = 0.8;
BackgroundAlt.Tint = 0.8;
break;
case DataRowInReportTypeEnum.removedStrong:
Text.Style = reporting.style.enums.styleTextTypeEnum.regular | styleTextTypeEnum.striketrough;
//Cell.sizeAndBorder.setup(0, 0, Color.Gray, 0, reporting.style.enums.styleBorderType.None);
Text.Color = Color.OrangeRed;
Background.Color = Color.WhiteSmoke;
BackgroundAlt.Color = Color.Snow;
Background.Tint = 0.8;
BackgroundAlt.Tint = 0.8;
break;
case DataRowInReportTypeEnum.columnDescription:
Background.Color = Color.LightSteelBlue;
BackgroundAlt.Color = Color.LightSteelBlue;
Cell.aligment = reporting.zone.textCursorZoneCorner.center;
Background.Tint = 0.4;
BackgroundAlt.Tint = 0.5;
Text.FontSize = 9;
Cell.minSize.height = 18;
break;
case DataRowInReportTypeEnum.columnFooterInfo:
Cell.minSize.height = 28;
break;
case DataRowInReportTypeEnum.columnInformation:
Background.Color = Color.LightSlateGray;
BackgroundAlt.Color = Color.SlateGray;
Background.Tint = 0.9;
BackgroundAlt.Tint = 0.8;
Text.FontSize = 9;
Cell.minSize.height = 28;
Cell.aligment = reporting.zone.textCursorZoneCorner.center;
break;
case DataRowInReportTypeEnum.data:
Background.Color = Color.WhiteSmoke;
BackgroundAlt.Color = Color.Snow;
Background.Tint = 0.2;
BackgroundAlt.Tint = 0.2;
Text.FontSize = 9;
Cell.minSize.height = 15;
break;
case DataRowInReportTypeEnum.dataAggregate:
break;
case DataRowInReportTypeEnum.info:
break;
case DataRowInReportTypeEnum.mergedCategoryHeader:
Background.Color = Color.Gray;
Background.Tint = 0.7;
BackgroundAlt.Color = Color.Gray;
BackgroundAlt.Tint = 0.9;
Cell.minSize.height = 25;
Cell.aligment = reporting.zone.textCursorZoneCorner.center;
break;
case DataRowInReportTypeEnum.mergedFooterInfo:
Background.Color = Color.LightSlateGray;
BackgroundAlt.Color = Color.SlateGray;
Background.Tint = 0.8;
BackgroundAlt.Tint = 0.7;
Text.FontSize = 9;
Cell.minSize.height = 25;
break;
case DataRowInReportTypeEnum.mergedHeaderInfo:
Background.Color = Color.LightSlateGray;
BackgroundAlt.Color = Color.SlateGray;
Background.Tint = 0.2;
BackgroundAlt.Tint = 0.2;
Text.FontSize = 9;
Cell.minSize.height = 24;
break;
case DataRowInReportTypeEnum.mergedHeaderTitle:
Background.Color = Color.LightBlue;
Background.Tint = 0.2;
BackgroundAlt.Color = Color.LightBlue;
BackgroundAlt.Tint = 0.3;
Text.Style = reporting.style.enums.styleTextTypeEnum.bold;
Text.FontSize = 9;
Cell.minSize.height = 30;
break;
case DataRowInReportTypeEnum.mergedHorizontally:
Cell.minSize.height = 12;
Text.FontSize = 8;
Background.Color = Color.LightGray;
BackgroundAlt.Color = Color.LightGray;
Background.Tint = 0.9;
BackgroundAlt.Tint = 0.8;
Cell.aligment = reporting.zone.textCursorZoneCorner.Left;
break;
case DataRowInReportTypeEnum.none:
break;
default:
Text.Style = reporting.style.enums.styleTextTypeEnum.regular;
//Cell.sizeAndBorder.setup(0, 0, Color.Gray, 0, reporting.style.enums.styleBorderType.None);
// Text.Color = Color.OrangeRed;
Background.Color = Color.WhiteSmoke;
BackgroundAlt.Color = Color.Snow;
Background.Tint = 0.4;
BackgroundAlt.Tint = 0.2;
break;
}
switch (enumType)
{
case DataRowInReportTypeEnum.group01:
Background.Color = Color.LightBlue;
BackgroundAlt.Color = Color.LightBlue;
break;
case DataRowInReportTypeEnum.group02:
Background.Color = Color.Bisque;
BackgroundAlt.Color = Color.Bisque;
break;
case DataRowInReportTypeEnum.group03:
Background.Color = Color.LightCyan;
BackgroundAlt.Color = Color.LightCyan;
break;
case DataRowInReportTypeEnum.group04:
Background.Color = Color.LightGoldenrodYellow;
BackgroundAlt.Color = Color.LightGoldenrodYellow;
break;
case DataRowInReportTypeEnum.group05:
Background.Color = Color.LightPink;
BackgroundAlt.Color = Color.LightPink;
break;
}
}
