Ejemplo n.º 1
0
        private void UpdateSchedule(DutyCheckPackageTimePlan model, AllInOneContext.AllInOneContext db, DutyCheckPackageTimePlan oldPlan)
        {
            if (model.Schedule == null)
            {
                return;
            }
            Guid scheduleId = oldPlan.ScheduleId;

            if (oldPlan.ScheduleId != model.ScheduleId)
            {
                scheduleId = model.ScheduleId;
            }

            //转换一般数据
            Schedule shedule = db.Schedule
                               .Include(t => t.ScheduleType)
                               .Include(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods)
                               .Include(t => t.ScheduleCycle).ThenInclude(t => t.CycleType)
                               .FirstOrDefault(p => p.ScheduleId.Equals(scheduleId));

            if (shedule == null)
            {
                return;
            }

            shedule.EffectiveTime  = model.Schedule.EffectiveTime;
            shedule.ExpirationTime = model.Schedule.ExpirationTime;
            shedule.ScheduleTypeId = model.Schedule.ScheduleTypeId;
            shedule.ScheduleName   = model.Schedule.ScheduleName;
            //
            ScheduleCycle scheduleCycle = db.Set <ScheduleCycle>()
                                          .Include(t => t.DayPeriods)
                                          .FirstOrDefault(p => p.ScheduleCycleId.Equals(shedule.ScheduleCycle.ScheduleCycleId));

            //转换ScheduleCycle
            scheduleCycle.CycleTypeId = model.Schedule.ScheduleCycle.CycleTypeId;
            scheduleCycle.Days        = model.Schedule.ScheduleCycle.Days;
            scheduleCycle.DaysJson    = model.Schedule.ScheduleCycle.DaysJson;
            scheduleCycle.LastExecute = model.Schedule.ScheduleCycle.LastExecute;
            scheduleCycle.Months      = model.Schedule.ScheduleCycle.Months;
            scheduleCycle.MonthsJson  = model.Schedule.ScheduleCycle.MonthsJson;
            scheduleCycle.NextExecute = model.Schedule.ScheduleCycle.NextExecute;
            scheduleCycle.WeekDayJson = model.Schedule.ScheduleCycle.WeekDayJson;
            scheduleCycle.WeekDays    = model.Schedule.ScheduleCycle.WeekDays;
            //
            UpdateTimePeriod(db, shedule, model);
            //
            //scheduleCycle.DayPeriods = model.Schedule.ScheduleCycle.DayPeriods;
            shedule.ScheduleCycle = scheduleCycle;
            db.Schedule.Update(shedule);
            db.SaveChanges();
        }
Ejemplo n.º 2
0
        public IActionResult Delete(Guid id)
        {
            try
            {
                using (var db = new AllInOneContext.AllInOneContext())
                {
                    using (var tran = db.Database.BeginTransaction())
                    {
                        Schedule data = db.Schedule
                                        .Include(t => t.ScheduleType)
                                        .Include(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods)
                                        .Include(t => t.ScheduleCycle).ThenInclude(t => t.CycleType)
                                        .FirstOrDefault(p => p.ScheduleId.Equals(id));

                        if (data == null)
                        {
                            return(NoContent());
                        }
                        //移除LIST
                        RemoveList(db, data);
                        //移除ScheduleCycle
                        ScheduleCycle scheduleCycle = db.Set <ScheduleCycle>()
                                                      .FirstOrDefault(p => p.ScheduleCycleId.Equals(data.ScheduleCycle.ScheduleCycleId));
                        if (scheduleCycle != null)
                        {
                            db.Set <ScheduleCycle>().Remove(scheduleCycle);
                        }
                        db.Schedule.Remove(data);
                        db.SaveChanges();
                        tran.Commit();
                        return(new NoContentResult());
                    }
                }
            }
            catch (DbUpdateException dbEx)
            {
                _logger.LogError("Delete:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace);

                return(BadRequest(new ApplicationException {
                    ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message
                }));
            }
            catch (System.Exception ex)
            {
                _logger.LogError("Delete:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace);
                return(BadRequest(new ApplicationException {
                    ErrorCode = "Unknown", ErrorMessage = ex.Message
                }));
            }
        }
Ejemplo n.º 3
0
        public IActionResult Update([FromBody] Schedule model)
        {
            try
            {
                if (model == null)
                {
                    return(BadRequest());
                }
                using (var db = new AllInOneContext.AllInOneContext())
                {
                    using (var tran = db.Database.BeginTransaction())
                    {
                        if (model.ScheduleCycle != null)
                        {
                            //补全数据
                            SystemOption cycletype = db.Set <SystemOption>()
                                                     .FirstOrDefault(p => p.SystemOptionId.Equals(model.ScheduleCycle.CycleTypeId));
                            Schedule Schedule = model;
                            if (cycletype != null)
                            {
                                Schedule.ScheduleCycle.CycleType = cycletype;
                            }
                            DateTime?executeTime = ScheduleUtility.GetExecuteTime(Schedule, DateTime.Now);
                            model.ScheduleCycle.NextExecute = executeTime;
                        }
                        //转换一般数据
                        Schedule shedule = db.Schedule
                                           .Include(t => t.ScheduleType)
                                           .Include(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods)
                                           .Include(t => t.ScheduleCycle).ThenInclude(t => t.CycleType)
                                           .FirstOrDefault(p => p.ScheduleId.Equals(model.ScheduleId));

                        if (shedule == null)
                        {
                            return(BadRequest());
                        }

                        shedule.EffectiveTime  = model.EffectiveTime;
                        shedule.ExpirationTime = model.ExpirationTime;
                        shedule.ScheduleTypeId = model.ScheduleTypeId;
                        shedule.ScheduleName   = model.ScheduleName;
                        //
                        ScheduleCycle scheduleCycle = db.Set <ScheduleCycle>()
                                                      .Include(t => t.DayPeriods)
                                                      .FirstOrDefault(p => p.ScheduleCycleId.Equals(shedule.ScheduleCycle.ScheduleCycleId));
                        //转换ScheduleCycle
                        scheduleCycle.CycleTypeId = model.ScheduleCycle.CycleTypeId;
                        scheduleCycle.Days        = model.ScheduleCycle.Days;
                        scheduleCycle.DaysJson    = model.ScheduleCycle.DaysJson;
                        scheduleCycle.LastExecute = model.ScheduleCycle.LastExecute;
                        scheduleCycle.Months      = model.ScheduleCycle.Months;
                        scheduleCycle.MonthsJson  = model.ScheduleCycle.MonthsJson;
                        scheduleCycle.NextExecute = model.ScheduleCycle.NextExecute;
                        scheduleCycle.WeekDayJson = model.ScheduleCycle.WeekDayJson;
                        scheduleCycle.WeekDays    = model.ScheduleCycle.WeekDays;
                        //
                        RemoveList(db, shedule);
                        //
                        scheduleCycle.DayPeriods = model.ScheduleCycle.DayPeriods;
                        shedule.ScheduleCycle    = scheduleCycle;
                        db.Schedule.Update(shedule);
                        db.SaveChanges();
                        //
                        tran.Commit();
                        return(new NoContentResult());
                    }
                }
            }
            catch (DbUpdateException dbEx)
            {
                _logger.LogError("Update:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace);

                return(BadRequest(new ApplicationException {
                    ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message
                }));
            }
            catch (System.Exception ex)
            {
                _logger.LogError("Update:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace);
                return(BadRequest(new ApplicationException {
                    ErrorCode = "Unknown", ErrorMessage = ex.Message
                }));
            }
        }