public void Set(string columnName, object value, ICellMapper cellMapper = null)
{
if (cellMapper != null)
{
value = cellMapper.Map(new Cell(value)).RawValue;
}
GetDataRow()[columnName] = value;
}
public static void CalcMeteoAvg(List <Row> meteoRows, string meteoColumnName,
TableProcessing.Table calcsHydroTable, string hydroColumnName,
ICellMapper cellMapper, params TableProcessing.Table[] resultTables)
{
var valuesColumnName = meteoColumnName + "_Values";
calcsHydroTable.IterateRows(hydroRow =>
{
var intList = hydroRow["OI_METEO"].ToIntList();
double number = 0;
var realMeteoColumnName = meteoColumnName;
if (meteoColumnName.StartsWith("&"))
{
var hydroPtr = meteoColumnName.Substring(1);
realMeteoColumnName = hydroRow[hydroPtr].StringValue;
}
Etc.NoThrow(() =>
{
var doubleQuery = from meteoRow in meteoRows
where intList.Contains(meteoRow["OI_Meteo"].IntValue) &&
double.TryParse(
meteoRow[realMeteoColumnName].StringValue, out number)
select number;
var enumerable = doubleQuery.ToList();
var strQuery = from dbl in enumerable
select cellMapper.Map(new Cell(dbl)).StringValue;
var res = string.Join(";", strQuery.ToArray());
hydroRow.Set(valuesColumnName, res);
hydroRow.Set(hydroColumnName,
enumerable.Average(), cellMapper);
});
}, valuesColumnName, hydroColumnName);
foreach (var table in resultTables)
{
table.AddColumn(calcsHydroTable.Column(hydroColumnName));
}
}
public void Set(int index, object value, ICellMapper cellMapper)
{
value = cellMapper.Map(new Cell(value)).RawValue;
Table.DataTable.Rows[index][Name] = value;
}