protected void Application_Start()
{
//autofac配置
AutofacConfig.Init();
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AutoMapperConfig.InitMapping();
//扫描异常信息 改用Quartz定时扫描
// MyException.ProcessException();
//执行计划任务
QuartzConfig.InitJob();
QuartzConfig.StartJob();
//EF Pre-Generated Mapping Views（预生成映射视图）
using (var dbcontext = new NFineBaseEntities())
{
var objectContext = ((IObjectContextAdapter)dbcontext).ObjectContext;
var mappingCollection = (StorageMappingItemCollection)objectContext.MetadataWorkspace.GetItemCollection(DataSpace.CSSpace);
mappingCollection.GenerateViews(new List <EdmSchemaError>());
}
}
public static DbContext GetDbContext()
{
DbContext context = CallContext.GetData("dbContext") as NFineBaseEntities;
if (context == null)
{
context = new NFineBaseEntities();
CallContext.SetData("dbContext", context);
}
return(context);
}
//
// GET: /Home/
public ActionResult Index()
{
NFineBaseEntities db = new NFineBaseEntities();
List <UserEntity> userList = new List <UserEntity>();
foreach (var item in db.Sys_User)
{
UserEntity entity = new UserEntity();
entity.F_RealName = item.F_RealName;
userList.Add(entity);
}
return(View(userList));
}
/// <summary>
/// 初始化任务
/// </summary>
public static void InitJob()
{
sched = DependencyResolver.Current.GetService <IScheduler>();
#region 查询楼栋设备Job
using (var dbcontext = new NFineBaseEntities())
{
//查询教室总数
int count = dbcontext.Z_Room.Where(u => u.F_RoomType == "ClassRoom").ToList().Count;
//创建一个任务
IJobDetail job1 = JobBuilder.Create <SearchBuildingAllRoomEquipmentJob>().Build();
//触发时间 教室总数乘以1分钟
ISimpleTrigger trigger = (ISimpleTrigger)TriggerBuilder.Create()//.WithCronSchedule("0 0 ")
.WithSimpleSchedule(o => o.WithIntervalInMinutes(count).WithRepeatCount(int.MaxValue))
.Build();
//添加到任务管理者
sched.ScheduleJob(job1, trigger);
}
#endregion
#region 处理异常信息Job
IJobDetail exceptionJob = JobBuilder.Create <ProcessExceptionJob>().Build();
//每10s处理一次
ISimpleTrigger triggerExceptionJob = (ISimpleTrigger)TriggerBuilder.Create().WithSimpleSchedule(o => o.WithIntervalInSeconds(10).WithRepeatCount(int.MaxValue)).Build();
sched.ScheduleJob(exceptionJob, triggerExceptionJob);
#endregion
#region 步电子钟Job
IJobDetail electronicClockJob = JobBuilder.Create <SynchronizeElectronicClockTimeJob>().Build();
//每周日早上8点同步一次
ICronTrigger clockTrigger = (ICronTrigger)TriggerBuilder.Create().WithCronSchedule("0 0 8 ? * 7 *").StartNow().Build();
//ISimpleTrigger t = (ISimpleTrigger)TriggerBuilder.Create().WithSimpleSchedule(o => o.WithIntervalInSeconds(20)).StartNow().Build();
sched.ScheduleJob(electronicClockJob, clockTrigger);
#endregion
#region 处理每日课程
IJobDetail CourseJob = JobBuilder.Create <TimingProcessDailyCoursesJob>().Build();
//每周一到周五早上6点触发一次
ICronTrigger CourseTrigger = (ICronTrigger)TriggerBuilder.Create().WithCronSchedule("0 0 6 ? * 2,3,4,5,6 *").StartNow().Build();
//ISimpleTrigger CourseTrigger = (ISimpleTrigger)TriggerBuilder.Create().WithSimpleSchedule(o => o.WithIntervalInHours(1)).StartNow().Build();
sched.ScheduleJob(CourseJob, CourseTrigger);
#endregion
}
public void Ef()
{
NFineBaseEntities db = new NFineBaseEntities();
var obj = db.Sys_Area.ToList();
}
