查询两个时段中的交集数据

--查询两个时段中的交集数据

DateTime startDate = DateTime.Now.AddDays(-2);

DateTime endDate = DateTime.Now.AddDays(1);

List<T> list = ORM.Get<T>((it => it.Where(o => (o.StartDate >= startDate && o.StartDate <= endDate)

|| (o.StartDate <= startDate && o.EndDate >= endDate)

|| (o.EndDate >= startDate && o.EndDate <= endDate))));