MYSQL ,表字段,id,type,START_TIME,END_TIME
数据,1,1,09:00:00,09:00:00
2,1,19:00:00,09:00:00
等于布满了一天,我要插入的时候判断下时间是否重叠,重叠的话不让添加
List<tbl_a> list= EF.tbl_a.Where(s => s.type == 2).ToList();
foreach (tbl_a item in list)
{
DateTime t1 = Convert.ToDateTime(model.START_TIME.ToString());
DateTime t2 = Convert.ToDateTime(model.END_TIME.ToString());
DateTime t3 = Convert.ToDateTime(item.START_TIME.ToString());
DateTime t4 = Convert.ToDateTime(item.END_TIME.ToString());
}
if (DateTime.Compare(t2, t3) < 0 || DateTime.Compare(t2, t4) > 0)
{
//没有重叠
}
else
{
//有重叠
}
这样写好像不行