private static bool ColumnIsNumericOrPercent(ColumnVm cell)
{
return
String.Equals(cell.Type, Literals.Attribute.ColCellType.Numeric,
StringComparison.CurrentCultureIgnoreCase) ||
String.Equals(cell.Type, Literals.Attribute.ColCellType.Percent,
StringComparison.CurrentCultureIgnoreCase);
}
private static void RunRowCalcRecursive(CalcExpressionVm calcToRun, List<CalcExpressionVm> allRowCalcs, ColumnVm col)
{
var expandedRowCalc = ExpandRowCalcForCol(calcToRun, col);
var targetCell = col.Cells.FirstOrDefault(c => c.GridCode == expandedRowCalc.TargetGridCode && c.RowCode == expandedRowCalc.TargetRowCode && c.ColCode == expandedRowCalc.TargetColCode);
if (targetCell == null) return;
EvaluateExpressionAndAssign(expandedRowCalc, targetCell);
if (!UpdateContextIsCellValue(calcToRun.UpdateContext)) return;
var cascadedRowCalcs = allRowCalcs.Where(c => c.Operands.Any(o => o.GridCode == targetCell.GridCode && o.RowCode == targetCell.RowCode)).ToList();
if (cascadedRowCalcs.Any())
{
cascadedRowCalcs.ForEach(cc =>
{
RunRowCalcRecursive(cc, allRowCalcs, col);
});
}
}
private static int GetCellSpan(GridVm grid, RowVm row, ColumnVm col, int? cellSpanAttrib)
{
if (row.Type != Literals.Attribute.RowType.Header && row.Type != Literals.Attribute.RowType.Blank) return cellSpanAttrib ?? col.ColSpan;
if (col.ColCode != Literals.UniversalColCode.RowText) return 0;
var span = grid.Columns.Count(c => c.Level == 0 && !c.IsHidden);
span += (grid.HasSelectCol ? 1 : 0) + (grid.HasCollapseCol ? 1 : 0) + (grid.HasAddCol ? 1 : 0) + (grid.HasDeleteCol ? 1 : 0);
return span;
}
private static CalcExpressionVm ExpandRowCalcForCol(CalcExpressionVm rowCalc, ColumnVm col)
{
var calc = new CalcExpressionVm()
{
TargetGridCode = rowCalc.TargetGridCode,
TargetColCode = col.ColCode,
TargetRowCode = rowCalc.TargetRowCode,
Expression = rowCalc.Expression.Split('.').Aggregate((c, n) => n == "" ? c + "." + col.ColCode + n : c + "." + n),
UpdateContext = rowCalc.UpdateContext,
Operands = rowCalc.Operands.Select(o => new CalcOperandVm()
{
GridCode = o.GridCode,
ColCode = col.ColCode,
RowCode = o.RowCode
}).ToList()
};
foreach (var operand in calc.Operands)
{
var cell = col.Cells.FirstOrDefault(c => c.GridCode == operand.GridCode && c.RowCode == operand.RowCode && c.ColCode == operand.ColCode);
var cellValue = GetCellValue(cell);
var operandToken = GetCellToken(operand.GridCode, operand.RowCode, operand.ColCode);
calc.Expression = calc.Expression.Replace(operandToken, cellValue.ToString());
}
return calc;
}
private static CellVm BuildCellVmFromAttributes(GridVm grid, RowVm row, ColumnVm col, Attributes cellAttrib)
{
var overrideColSettings = cellAttrib.OverrideColSettings ?? false;
var cellType = overrideColSettings ? cellAttrib.Type : col.Type;
var decimals = overrideColSettings ? cellAttrib.DecimalPlaces : col.DecimalPlaces;
var maxChars = overrideColSettings ? cellAttrib.MaxChars : col.MaxChars;
var cellVal = cellAttrib.Value;
var textColor = "";
if (row.Type != Literals.Attribute.RowType.Blank && (IsNumericOrPercentType(cellType)))
{
double parsedNum;
var parsed = double.TryParse(cellAttrib.Value, out parsedNum);
if (parsed)
{
cellVal = String.Format("{0:n" + decimals + "}", parsedNum);
//if (parsedNum < 0) textColor = "red";
}
}
if (!string.IsNullOrEmpty(cellAttrib.HoverBase)) textColor = "green";
if (!string.IsNullOrEmpty(cellAttrib.HoverAddition))
{
double parsedHoverAddition;
var parsed = double.TryParse(cellAttrib.HoverAddition, out parsedHoverAddition);
if (parsed && parsedHoverAddition != 0)
{
textColor = "red";
}
}
//var valParsed = double.TryParse(cellVal, out numval);
var span = cellAttrib.ColSpan ?? col.ColSpan;
return new CellVm()
{
GridCode = grid.GridCode,
RowCode = row.RowCode,
ColCode = col.ColCode,
Type = cellType,
MaxChars = maxChars,
DecimalPlaces = decimals,
ColSpan = GetCellSpan(grid, row, col, cellAttrib.ColSpan),
ColumnHeader = col.DisplayText,
Indent = cellAttrib.Indent ?? 0,
IsEditable = (cellAttrib.IsEditable ?? false) && row.IsEditable && col.IsEditable && grid.IsEditable,
//IsHidden = cellAttrib.IsHidden ?? false, //todo: DisplayInCycle
IsHidden = cellAttrib.DisplayInCycle == "None",
Value = cellVal,
//NumValue = valParsed ? numval : 0,
Width = (span == 1 ? col.Width : "100%"),
Alignment = cellAttrib.Alignment ?? "right",
HoverBase = cellAttrib.HoverBase,
HoverAddition = cellAttrib.HoverAddition,
TextColor = textColor,
Calcs = null
};
}
