日期和时间范围搜索
本文关键字：搜索 范围 时间 日期 | 更新日期: 2023-09-27 18:03:30
我需要知道查找数据范围内每天的时间范围内的所有数据库条目的最有效方法。意思是如果数据范围是7/20/2015 - 7/24/2015，时间范围是下午1点-下午6点。我需要在下午1点到下午6点之间查看日期范围内的每一天
试试这样:
List<DayOfWeek> dayOfWeek = new List<DayOfWeek> { DayOfWeek.Monday, DayOfWeek.Tuesday, DayOfWeek.Wednesday, DayOfWeek.Thursday, DayOfWeek.Friday};
int hourStart = 13;
int hourEnd = 18;
var a = new List<DateTime>();
a.Add(DateTime.Now.AddDays(-1));
a.Add(DateTime.Now.AddDays(-2));
a.Add(DateTime.Now.AddDays(-3));
a.Add(DateTime.Now.AddDays(-4));
a.Add(DateTime.Now.AddDays(-5));
a.Add(DateTime.Now.AddDays(-5).AddHours(5));
var result = a.Where(f => dayOfWeek.Contains(f.DayOfWeek) == true && (f.Hour >= hourStart && f.Hour <= hourEnd)).ToList();
希望有帮助。
List<DayOfWeek> dayOfWeek = new List<DayOfWeek> { DayOfWeek.Monday, DayOfWeek.Tuesday, DayOfWeek.Wednesday, DayOfWeek.Thursday, DayOfWeek.Friday};
int hourStart = 13;
int hourEnd = 18;
var result = Records.Where(f => dayOfWeek.Contains(f.DayOfWeek) == true && (f.Hour >= hourStart && f.Hour <= hourEnd)).ToList();