c# – 检查表是否包含重叠的时间跨度
发布时间:2020-12-15 07:40:16 所属栏目:百科 来源:网络整理
导读:我有一个带有两列FromDate和ToDate的数据表,它们是字符串格式. 我想检查一下我的table.i.e中是否有任何重复的记录 From Date To Date---------------------- 9/01/2012 9/16/2012 8/23/2012 8/24/2012 8/25/2012 8/25/2012 8/5/2012 8/6/2012 8/26/2012 8/27
我有一个带有两列FromDate和ToDate的数据表,它们是字符串格式.
我想检查一下我的table.i.e中是否有任何重复的记录 From Date To Date ---------------------- 9/01/2012 9/16/2012 8/23/2012 8/24/2012 8/25/2012 8/25/2012 8/5/2012 8/6/2012 8/26/2012 8/27/2012 9/15/2012 9/23/2012 该表包含重复记录,因为它们的日期范围是映射的 From Date To Date ---------------------- 9/01/2012 9/16/2012 9/15/2012 9/23/2012 它应该返回false. 解决方法var query = from row in dt.AsEnumerable() from row1 in dt.AsEnumerable() where ( ( DateTime.Parse(row1.Field<string>("fromDate")) >= DateTime.Parse(row.Field<string>("fromDate")) && DateTime.Parse(row1.Field<string>("fromDate")) <= DateTime.Parse(row.Field<string>("toDate")) ) || ( DateTime.Parse(row1.Field<string>("toDate")) >= DateTime.Parse(row.Field<string>("fromDate")) && DateTime.Parse(row1.Field<string>("toDate")) <= DateTime.Parse(row.Field<string>("toDate")) ) ) select new { fromDate = DateTime.Parse(row1.Field<string>("fromDate")),toDate = DateTime.Parse(row1.Field<string>("toDate")) }; //This lst contains the dates which are overlapping var lst = query.Distinct().ToList(); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |