/// <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;
}
