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

                        
--查询两个时段中的交集数据
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))));