8,494
社区成员




SELECT CONVERT(varchar(10),uDatetime,120), COUNT(*)
FROM Logs
WHERE uType='警告'
GROUP BY CONVERT(varchar(10),uDatetime,120)
HAVING CONVERT(varchar(10),uDatetime,120) BETWEEN '2013-12-21' AND '2013-12-22'
entities.Logs.Where(o => o.uDatetime >= timeStart && o.uDatetime < timeend && o.uType == type).ToList().GroupBy(o => new DateTime(o.uDatetime.Value.Year, o.uDatetime.Value.Month, o.uDatetime.Value.Day)).Select(z => new Propertys { Datetime = new DateTime(z.Key.Year, z.Key.Month, z.Key.Day), Count = z.Count() }).ToList<Propertys>();