public DateTime LastRecordDateTime(long hotelIdentity, RunningTimeType type) { using (var repo = Repo <RunningTimeRepository>()) { var lastRecord = repo.GetModels(obj => obj.ProjectIdentity == hotelIdentity && obj.Type == type) .OrderByDescending(item => item.UpdateTime).FirstOrDefault(); return(lastRecord?.UpdateTime ?? DateTime.MinValue); } }
private long GetRunTimeTicks(IQueryable <RunningTime> queryable, DateTime dueDateTime, ReportType reportType, RunningTimeType runTimeType) { var startDate = ReportStartDate(dueDateTime, reportType); var runningTime = queryable.Where(obj => obj.UpdateTime >= startDate && obj.UpdateTime < dueDateTime && obj.Type == runTimeType); if (runningTime.Count() != 0) { return(runningTime.Sum(item => item.RunningTimeTicks)); } return(0); }