#pragma warning restore CS1591 // Missing XML comment for publicly visible type or member 'BomDataCell.Column'
#pragma warning disable CS1591 // Missing XML comment for publicly visible type or member 'BomDataCell.BomDataCell(BomDataRowHolder, BomDataColumn, object)'
public BomDataCell(BomDataRowHolder row, BomDataColumn column, object value)
{
#pragma warning restore CS1591 // Missing XML comment for publicly visible type or member 'BomDataCell.BomDataCell(BomDataRowHolder, BomDataColumn, object)'
Column = column;
Row = row;
Value = value;
}
public BomOutput(Excel.Application excelInstance, BomInput bomInput, ConfigurationElementBom bomElement, IFormatterConfiguration formatterConfiguration)
{
_excelAppInstance = excelInstance;
_formatterConfiguration = formatterConfiguration;
_bomInput = bomInput;
_bomConfig = bomElement;
foreach (ConfigurationElementColumn column in bomElement.ColumnCollection)
{
_bomDataTable.AddColumn(new BomDataColumn(column));
}
TemplateRow = new BomDataRowHolder(_bomDataTable);
}
private void LoadInput()
{
foreach (DataRow row in _input.InputData.Rows)
{
BomDataRowHolder newRow = LoadRow(row);
if (_outputType == BomOutputType.INDIVIDUAL)
{
_output.BomDataTable.AddRowCollection(newRow.ExpandRow());
}
else
{
_output.BomDataTable.AddRow(newRow);
}
}
}
private BomDataRowHolder LoadRow(DataRow row)
{
BomDataRowHolder newRow = new BomDataRowHolder(_output.TemplateRow);
foreach (DataColumn column in row.Table.Columns)
{
ConfigurationElementColumn columnConfig = GetConfigColumn(column);
if (columnConfig != null)
{
//bool valueSet = false;
foreach (BomDataCell cell in newRow)
{
if (cell.Column.Position == columnConfig.Order /*&& cell.Column.ColumnName.Equals(columnConfig.Name)*/)
{
object rowValue = row.ItemArray[DataColumnIndex(column)];
rowValue = rowValue.Equals(DBNull.Value) ? null : rowValue;
if ((columnConfig.Override && rowValue != null) || cell.Value == null)
{
cell.Value = rowValue;
}
//valueSet = true;
}
}
//if (!valueSet)
// newRow.Add(new BomDataCell(
// newRow,
// _output.BomDataTable.GetColumn(columnConfig.Name),
// row.ItemArray[DataColumnIndex(column)]));
//newRow.Add(new BomDataCell(
// newRow,
// _output.BomDataTable.GetColumn(columnConfig.Name),
// row.ItemArray[DataColumnIndex(column)]));
}
else if (columnConfig != null && columnConfig.Enabled && columnConfig.Required)
{
throw new ConfigurationElementColumnException("Required column " + columnConfig.Header + " not found.");
}
}
return(newRow);
}
