c#数据库如何排序这个

本文关键字：排序 数据库 何排序 | 更新日期: 2023-09-27 18:18:34

这是我的代码

var result = (from row in InBoundtable.AsEnumerable()
    where campains.Contains(row.Field<string>("Campaign"))
    group row by new
    {
      Date = row.Field<string>("Date"),
      Slice = row.Field<string>("Slice")
    } into grp
    select new
    {
      SL = grp.Sum((r) => Double.Parse(r["Inb.ServiceLevel"].ToString())) / grp.Count(),
      Date = ((DateTime.Parse(grp.Key.Date.ToString() + " " + grp.Key.Slice.ToString().Split('-')[0])) - epoch).TotalMilliseconds
    }).ToList();

如何根据Date列对result进行排序?从过去到现在

例如

c#数据库如何排序这个

如何根据日期列对结果进行排序?从过去到当前

使用OrderBy 

var result = (from row in InBoundtable.AsEnumerable()
              where campains.Contains(row.Field<string>("Campaign"))
              group row by new
              {
                  Date = row.Field<string>("Date"),
                  Slice = row.Field<string>("Slice")
              } into grp
              select new
              {
                  SL = grp.Sum((r) => Double.Parse(r["Inb.ServiceLevel"].ToString())) / grp.Count(),
                  Date = ((DateTime.Parse(grp.Key.Date.ToString() + " " + grp.Key.Slice.ToString().Split('-')[0])) - epoch).TotalMilliseconds
              })
              .OrderBy(r=> r.Date) //HERE
              .ToList();
相关文章：