c#-LINQ查询,将检查开始时间和结束时间是否可用
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了c#-LINQ查询,将检查开始时间和结束时间是否可用,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4380字,纯文字阅读大概需要7分钟。
内容图文
![c#-LINQ查询,将检查开始时间和结束时间是否可用](/upload/InfoBanner/zyjiaocheng/683/d5a741fb74f54cd2ab55a81f187e9ca3.jpg)
因此,基本上,用户将在特定日期保留时间.例如2016年3月21日10:00 AM至2016年3月21日1 PM.如果要进行其他保留,则系统不应接受2016年3月21日上午10点至下午1点之间的时间,因为它已被保留给其他用户.请帮助我不知所措,并有点新的编程.我对此查询感到困惑
public Boolean CheckExistingTime(string reason, string coursegrade, string section, DateTime start, DateTime end)
{
try
{
using (IHSEntities model = new IHSEntities())
{
var list = from sched in model.Schedules
where sched.Reason == reason && sched.CourseGrade == coursegrade && sched.Section == section
select new ScheduleList
{
scheduleid = sched.ScheduleID,
};
if (list.ToList().Count > 0)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
这是时间表的设计
I am using Entity Framework, so here is the complete Schedule Class
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Data;
namespace Business
{
public class Schedule
{
public class ScheduleList
{
public int scheduleid { get; set; }
public string coursegrade { get; set; }
public string section { get; set; }
public string reason { get; set; }
public string date { get; set; }
public string level { get; set; }
public string adviser { get; set; }
public string starttime { get; set; }
public string endtime { get; set; }
public string inputtedby { get; set; }
}
public List<ScheduleList> GetAllSchedule(DateTime date)
{
try
{
using (IHSEntities model = new IHSEntities())
{
var list = from schedule in model.Schedules
where schedule.Date >= date
select new ScheduleList
{
scheduleid = schedule.ScheduleID,
coursegrade = schedule.CourseGrade,
section = schedule.Section,
reason = schedule.Reason,
level = schedule.Levels,
date = schedule.Date.ToString(),
inputtedby = schedule.InputedBy,
};
return list.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List<ScheduleList> GetAllToday(DateTime date)
{
try
{
using (IHSEntities model = new IHSEntities())
{
var list = from schedule in model.Schedules
where schedule.Date == date orderby schedule.starttime
select new ScheduleList
{
scheduleid = schedule.ScheduleID,
coursegrade = schedule.CourseGrade,
section = schedule.Section,
reason = schedule.Reason,
level = schedule.Levels,
starttime = schedule.starttime.ToString(),
endtime = schedule.endtime.ToString(),
date = schedule.Date.ToString(),
inputtedby = schedule.InputedBy,
};
return list.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean CheckExistingTime(string reason, string coursegrade, string section, DateTime start, DateTime end)
{
try
{
using (IHSEntities model = new IHSEntities())
{
var list = from sched in model.Schedules
where sched.Reason == reason && sched.CourseGrade == coursegrade && sched.Section == section && sched.starttime <= start && sched.endtime >= end
select new ScheduleList
{
scheduleid = sched.ScheduleID,
};
if (list.ToList().Count > 0)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ScheduleList GetSchedule(int id)
{
try
{
using (IHSEntities model = new IHSEntities())
{
var list = (from schedule in model.Schedules
where schedule.ScheduleID == id
select new ScheduleList
{
coursegrade = schedule.CourseGrade,
section = schedule.Section,
reason = schedule.Reason,
date = schedule.Date.ToString(),
level = schedule.Levels,
adviser = schedule.Senttoadviser,
inputtedby = schedule.InputedBy,
}).First();
return list;
}
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Delete(int id)
{
try
{
using (IHSEntities model = new IHSEntities())
{
foreach (Data.Schedule sched in model.Schedules.Where(x => x.ScheduleID == id))
model.Schedules.Remove(sched);
model.SaveChanges();
return true;
}
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Update(int id, DateTime newdate)
{
try
{
using (IHSEntities model = new IHSEntities())
{
var list = (from sched in model.Schedules
where sched.ScheduleID == id
select sched).First();
list.Date = newdate;
model.SaveChanges();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
}
}
解决方法:
这应该可以解决问题:
using (var model = new IHSEntities())
{
bool result =
model.Schedules.Where(s => s.Section == section && s.CourseGrade == coursegrade
&& s.Reason == reason)
.Any(s => (s.starttime >= start && s.starttime <= end) ||
(s.endtime <= end && s.endtime >= start));
return result;
}
如果有任何记录,其中开始时间介于开始和开始之间.停止或结束时间介于开始和结束之间停止此操作将返回true.
编辑:仅当您没有保存截断日期部分的结束时间和开始时间时,这才起作用,否则,您将需要对日期进行额外的检查. (但是请不要从中删除日期部分,因此甚至不需要您的日期字段)
内容总结
以上是互联网集市为您收集整理的c#-LINQ查询,将检查开始时间和结束时间是否可用全部内容,希望文章能够帮你解决c#-LINQ查询,将检查开始时间和结束时间是否可用所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。