private bool isTimeRange(DvrDayTimeRange d)
{
//获取当前系统时间并判断是否为服务时间
TimeSpan nowDt = DateTime.Now.TimeOfDay;
TimeSpan workStartDT = DateTime.Parse(d.StartTime.ToString("HH:mm:ss")).AddMinutes(-1).TimeOfDay;
TimeSpan workEndDT = DateTime.Parse(d.EndTime.ToString("HH:mm:ss")).AddMinutes(1).TimeOfDay;
if (nowDt >= workStartDT && nowDt < workEndDT)
{
return(true);
}
return(false);
}
/// <summary>
/// 检查时间范围
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
private bool isTimeRange(DvrDayTimeRange d)
{
TimeSpan nowDt = DateTime.Now.TimeOfDay;
string start = d.StartTime.ToString("HH:mm:ss");
string end = d.EndTime.ToString("HH:mm:ss");
TimeSpan workStartDt = DateTime.Parse(start).TimeOfDay;
TimeSpan workEndDt = DateTime.Parse(end).TimeOfDay;
if (nowDt > workStartDt && nowDt < workEndDt)
{
return(true);
}
return(false);
}
static void Main(string[] args)
{
DBManager.fsql.Delete <StreamDvrPlan>().Where("1=1").ExecuteAffrows();
DBManager.fsql.Delete <DvrDayTimeRange>().Where("1=1").ExecuteAffrows();
var a = new StreamDvrPlan();
a.App = "live";
a.Enable = true;
a.Stream = "stream";
a.DeviceId = "device_id123";
a.LimitDays = 10;
a.LimitSpace = 99999999;
a.VhostDomain = "vhost";
a.OverStepPlan = OverStepPlan.DeleteFile;
a.TimeRangeList = new List <DvrDayTimeRange>();
DvrDayTimeRange b = new DvrDayTimeRange();
b.EndTime = DateTime.Now.AddDays(10);
b.StartTime = DateTime.Now;
b.WeekDay = DateTime.Now.DayOfWeek;
a.TimeRangeList.Add(b);
DvrDayTimeRange c = new DvrDayTimeRange();
c.EndTime = DateTime.Now.AddDays(15);
c.StartTime = DateTime.Now.AddDays(-5);
c.WeekDay = DayOfWeek.Monday;
a.TimeRangeList.Add(c);
/*联同子类一起插入*/
var repo = DBManager.fsql.GetRepository <StreamDvrPlan>();
repo.DbContextOptions.EnableAddOrUpdateNavigateList = true; //需要手工开启
repo.Insert(a);
/*联同子类一起插入*/
/*联同子类一起查出*/
var ret = DBManager.fsql.Select <StreamDvrPlan>().IncludeMany(a => a.TimeRangeList)
.ToList();
/*联同子类一起查出*/
Console.WriteLine("Hello World!");
}
