/// <summary> /// 初始化 /// </summary> /// <param name="freSetTime"></param> protected override void Initial(Schedule freSetTime) { base.Initial(freSetTime); EndDate = freSetTime.duration_end.Date; NoEndDate = EndDate == DateTime.MinValue; RepeatCount = freSetTime.repeat_count; }
protected override void Initial(Schedule fst) { base.Initial(fst); DaysOfWeek = fst.week_day.Split(',') .Select(i => int.Parse(i)) .OrderBy(i => i).ToArray(); }
protected override void Initial(Schedule fst) { base.Initial(fst); repeat_count = fst.repeat_count;///初始化 duration_start = fst.duration_start;///排程開始時間 duration_end = fst.duration_end;///排程結束時間 }
public ScheduleRelation() { rowid = 0; schedule_id = 0; relation_table = string.Empty; relation_id = 0; schedule = new Schedule(); }
DateTime end_time { get; set; }//重複小時結束時間//當為特殊排程時,該值為觸發時間時分秒結束部份 protected override void Initial(Schedule fst) { base.Initial(fst); if(repeat_count==0) { repeat_count = 1; } executeDay = fst.execute_days;///暫用描述代替 trigger_time = fst.trigger_time; start_time = DateTime.MinValue; end_time = DateTime.MaxValue; }
public SpecialWork(Schedule fst) { switch (fst.execute_type) { case "2W": work = new SpecialWeekWork(fst); break; default: work = new SpecialWeekWork(fst); break; } }
public MonthWork(Schedule fst) { switch(fst.month_type) { case 1: monthWork=new MonthWorkWithDay(fst); break; case 2: monthWork = new MonthWorkWithWeek(fst); break; default: throw new Exception("unaccpted month_type"); } }
/// <summary> /// 更新 /// </summary> /// <param name="schedule"></param> /// <returns></returns> public int Update(Schedule schedule) { string sqlStr = string.Format(@"update `schedule` set `type`='{0}',`execute_type`='{1}',`day_type`='{2}',`month_type`='{3}',`date_value`='{4}', `repeat_count`='{5}',`repeat_hours`='{6}',`time_type`='{7}',`week_day`='{8}', `start_time`='{9}',`end_time`='{10}',`duration_start`='{11}',`duration_end`={12},schedule_name='{13}', `desc`='{14}',create_user={15},create_date='{16}',trigger_time='{17}',execute_days='{18}' WHERE schedule_id = {19}", schedule.type, schedule.execute_type, schedule.day_type, schedule.month_type, schedule.date_value, schedule.repeat_count, schedule.repeat_hours, schedule.time_type, schedule.week_day, schedule.start_time.ToString("HH:mm:ss"), schedule.end_time.ToString("HH:mm:ss"), schedule.duration_start.ToString("yyyy-MM-dd"), schedule.duration_end == DateTime.MinValue ? "null" : "'" + schedule.duration_end.ToString("yyyy-MM-dd") + "'", schedule.schedule_name, schedule.desc, schedule.create_user, schedule.create_date.ToString("yyyy-MM-dd HH:mm:ss"),schedule.trigger_time,schedule.execute_days,schedule.schedule_id); return _dbAccess.execCommand(sqlStr); }
//add by wwei0216w 2015/2/9 /// <summary> /// 保存Freight排程的執行信息 /// </summary> /// <param name="fst">FreightSetTime對象</param> /// <returns>執行后受影響的行數</returns> public bool Save(Schedule s) { try { IScheduleRelationImplMgr _srMgr = new ScheduleRelationMgr(connectionString); if (s.schedule_id == 0) return _scheduleDao.Save(s) > 0; else { return _scheduleDao.Update(s) > 0; } } catch (Exception ex) { throw new Exception("ScheduleMgr-->Save" + ex.Message, ex); } }
public RepeatWork(Schedule fst) { switch (fst.execute_type) { case "2D": work = new DayWork(fst); break; case "2W": work = new WeekWork(fst); break; case "2M": work = new MonthWork(fst); break; default: throw new Exception("unaccepted date_value"); } }
public Work(Schedule freightSetTime) { switch (freightSetTime.type) { case 1: this.work = new OnlyOneWork(freightSetTime); break; case 2: this.work = new RepeatWork(freightSetTime); break; case 3: this.work = new SpecialWork(freightSetTime); break; default: throw new Exception("unaccepted type"); } }
/// <summary> /// 保存數據 /// </summary> /// <param name="fst"></param> /// <returns></returns> public ActionResult TierSetSave(Schedule fst) { try { _fstMgr = new ScheduleMgr(connectionString); fst.create_user = (Session["caller"] as Caller).user_id; fst.create_date = DateTime.Now; bool result = _fstMgr.Save(fst); return Json(new { success = result }); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return View(); }
//add by wwei0216 2015/2/9 /// <summary> /// 保存Freight排程的執行信息 /// </summary> /// <param name="fst">FreightSetTime對象</param> /// <returns>執行后受影響的行數</returns> public int Save(Schedule s) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@"INSERT INTO `schedule` (schedule_name,`type`,`execute_type`,`day_type`,`month_type`,`date_value`,`repeat_count`, `repeat_hours`,`time_type`,`week_day`,`start_time`,`end_time`,`duration_start`,`duration_end`,`desc`,create_user,create_date,trigger_time,execute_days) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}',{13},'{14}','{15}','{16}','{17}','{18}');", s.schedule_name, s.type, s.execute_type, s.day_type, s.month_type, s.date_value, s.repeat_count, s.repeat_hours, s.time_type, s.week_day, s.start_time.ToString("HH:mm:ss"), s.end_time.ToString("HH:mm:ss"), s.duration_start.ToString("yyyy-MM-dd"), s.duration_end == DateTime.MinValue ? "null" : "'" + s.duration_end.ToString("yyyy-MM-dd") + "'", s.desc, s.create_user, s.create_date.ToString("yyyy-MM-dd HH:mm:ss"),s.trigger_time,s.execute_days); return _dbAccess.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleDao-->Save" + ex.Message, ex); } }
//add by wwei0216w 2015/2/25 /// <summary> /// 根據商品Id刪除排程 /// </summary> /// <param name="Schedule">Schedule</param> /// <returns>受影響的行數</returns> public int Delete(Schedule s) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@"SET sql_safe_updates = 0;DELETE FROM schedule WHERE schedule_id ={0};SET sql_safe_updates = 1;", s.schedule_id); return _dbAccess.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleDao-->Delete" + ex.Message, ex); } }
protected override void Initial(Schedule freSetTime) { base.Initial(freSetTime); Week = freSetTime.date_value; Week_day = freSetTime.week_day == "" ? 0 : Convert.ToInt32(freSetTime.week_day); }
public MonthWorkWithWeek(Schedule fst) { Initial(fst); }
public SpecialWeekWork(Schedule fst) { Initial(fst); }
public DayWork(Schedule fst) { Initial(fst); }
protected virtual void Initial(Schedule freSetTime) { Now = freSetTime.now.Date; StartDate = freSetTime.duration_start.Date; }
public OnlyOneWork(Schedule fst) { Initial(fst); }
public WeekWork(Schedule fst) { Initial(fst); }
protected override void Initial(Schedule freSetTime) { base.Initial(freSetTime); Day = freSetTime.date_value; }