var iQuery = (from r in dtDatatable.AsEnumerable()
select r.Field<Int64>("item_ID")).Distinct().ToList();
foreach (long item in iQuery)
{
var sumval = from r in dtDatatable.AsEnumerable()
where r.Field<Int64>("item_ID") == item
group r by new
{
item = r.Field<Int64>("item_ID")
} into g
select new
{
sumQuantity = g.Sum( x => x.Field<Decimal>("quantity")),
avgCost = g.Average(x => x.Field<Decimal>("cost"))
};
Decimal _quantity = sumval.Select(x => x.sumQuantity).First();
Decimal _cost = sumval.Select(x => x.avgCost).First();
Dictionary<string, object> d = new Dictionary<string, object>()
{
{"quantity", _quantity },
{"cost", _cost }
};
..... fn_otros(d);
}
No hay comentarios.:
Publicar un comentario