8,497
社区成员
发帖
与我相关
我的任务
分享
public class News
{
public int NId { get; set; }
public string NContent { get; set; }
public DateTime CDate { get; set; }
public News(int nid, int userId, string nContent,DateTime date)
{
NId = nid;
NContent = nContent;
CDate = date;
}
}
List<News> list = new List<News>();
list.Add(new News(1, "aa", Convert.ToDateTime("2007-01-01")));
list.Add(new News(1, "bb", Convert.ToDateTime("2007-01-02")));
list.Add(new News(1, "cc", Convert.ToDateTime("2007-01-01")));
list.Add(new News(1, "dd", Convert.ToDateTime("2007-01-02")));
list.Add(new News(1, "ee", Convert.ToDateTime("2007-01-02")));
list.Add(new News(1, "ff", Convert.ToDateTime("2007-01-03")));
var q = from l in list
group l by l.CDate into g
select new
{
Date=g.Key,
Count=g.Count()
};
(from s in company select s.id,s.name,s.datetime).OrderBy(s => s.datetime);