cyf
257 lines
9.4 KiB
C#
257 lines
9.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace Lskj.PubTaskPlan.Model
|
|
{
|
|
public class TaskPlanModel
|
|
{
|
|
private FrmAddTaskPlan MainForm;
|
|
public TaskPlanModel(FrmAddTaskPlan frmMain, DataRow dataRow)
|
|
{
|
|
if (frmMain != null)
|
|
{
|
|
MainForm = frmMain;
|
|
ScheduleID = dataRow != null && dataRow.Table.Columns.Contains("ScheduleID") ? Convert.ToInt32(dataRow["ScheduleID"] + "") : 0;
|
|
NextDateTime = dataRow != null && dataRow.Table.Columns.Contains("NextDateTime") ? Convert.ToDateTime(dataRow["NextDateTime"] + "") : new DateTime();
|
|
MoudleId = dataRow != null && dataRow.Table.Columns.Contains("MoudleId") ? dataRow["MoudleId"] + "" : "";
|
|
TaskPlanName = dataRow != null && dataRow.Table.Columns.Contains("TaskPlanName") ? dataRow["TaskPlanName"] + "" : "";
|
|
TaskPlanType = dataRow != null && dataRow.Table.Columns.Contains("TaskPlanType") ? Convert.ToInt32(dataRow["TaskPlanType"] + "") : 0;
|
|
EnableCheckState = dataRow != null && dataRow.Table.Columns.Contains("EnableCheckState") ? Convert.ToBoolean(dataRow["EnableCheckState"] + "") : true;
|
|
OnetimeDate = dataRow != null && dataRow.Table.Columns.Contains("OneTimeDate") ? Convert.ToDateTime(dataRow["OneTimeDate"] + "") : DateTime.Now;
|
|
OnetimeTime = dataRow != null && dataRow.Table.Columns.Contains("OneTimeTime") ? Convert.ToDateTime(dataRow["OneTimeTime"] + "") : DateTime.Now;
|
|
LoopType = dataRow != null && dataRow.Table.Columns.Contains("LoopType") ? Convert.ToInt32(dataRow["LoopType"] + "") : 0;
|
|
LoopDayType = dataRow != null && dataRow.Table.Columns.Contains("LoopDayType") ? Convert.ToInt32(dataRow["LoopDayType"] + "") : 0;
|
|
LoopDayOnetimeTime = dataRow != null && dataRow.Table.Columns.Contains("LoopDayOnetimeTime") ? Convert.ToDateTime(dataRow["LoopDayOnetimeTime"] + "") : new DateTime();
|
|
LoopDayStartTime = dataRow != null && dataRow.Table.Columns.Contains("LoopDayStartTime") ? Convert.ToDateTime(dataRow["LoopDayStartTime"] + "") : new DateTime();
|
|
LoopDayEndTime = dataRow != null && dataRow.Table.Columns.Contains("LoopDayEndTime") ? Convert.ToDateTime(dataRow["LoopDayEndTime"] + "") : new DateTime().AddHours(23).AddMinutes(59).AddSeconds(59);
|
|
LoopDayInterval = dataRow != null && dataRow.Table.Columns.Contains("LoopDayInterval") ? Convert.ToInt32(dataRow["LoopDayInterval"] + "") : 1;
|
|
LoopDayIntervalUnit = dataRow != null && dataRow.Table.Columns.Contains("LoopDayIntervalUnit") ? Convert.ToInt32(dataRow["LoopDayIntervalUnit"] + "") : 0;
|
|
LoopStartDate = dataRow != null && dataRow.Table.Columns.Contains("LoopStartDate") ? Convert.ToDateTime(dataRow["LoopStartDate"] + "") : DateTime.Now;
|
|
LoopEndDate = dataRow != null && dataRow.Table.Columns.Contains("LoopEndDate") ? Convert.ToDateTime(dataRow["LoopEndDate"] + "") : DateTime.Now;
|
|
DateEndCheckState = dataRow != null && dataRow.Table.Columns.Contains("DateEndCheckState") ? Convert.ToBoolean(dataRow["DateEndCheckState"] + "") : true;
|
|
Sql = dataRow != null && dataRow.Table.Columns.Contains("Sql") ? dataRow["Sql"] + "" : "";
|
|
Tips = dataRow != null && dataRow.Table.Columns.Contains("Tips") ? dataRow["Tips"] + "" : "";
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 任务id
|
|
/// </summary>
|
|
private int scheduleID;
|
|
public int ScheduleID
|
|
{
|
|
get
|
|
{
|
|
return scheduleID;
|
|
}
|
|
set
|
|
{
|
|
scheduleID = value;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 任务下次执行时间
|
|
/// </summary>
|
|
private DateTime nextDateTime;
|
|
public DateTime NextDateTime
|
|
{
|
|
get
|
|
{
|
|
return nextDateTime;
|
|
}
|
|
set
|
|
{
|
|
nextDateTime = value;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 模块编号
|
|
/// </summary>
|
|
public string MoudleId
|
|
{
|
|
get;
|
|
set;
|
|
}
|
|
/// <summary>
|
|
/// 计划任务名称
|
|
/// </summary>
|
|
public string TaskPlanName
|
|
{
|
|
get { return MainForm.nameEdit.Text; }
|
|
set { MainForm.nameEdit.Text = value; }
|
|
}
|
|
/// <summary>
|
|
/// 计划任务类型
|
|
/// </summary>
|
|
public int TaskPlanType
|
|
{
|
|
get { return MainForm.comboBox_type.SelectedIndex; }
|
|
set { MainForm.comboBox_type.SelectedIndex = value; }
|
|
}
|
|
/// <summary>
|
|
/// 启用状态
|
|
/// </summary>
|
|
public bool EnableCheckState
|
|
{
|
|
get { return MainForm.enableCheck.Checked; }
|
|
set { MainForm.enableCheck.Checked = value; }
|
|
}
|
|
/// <summary>
|
|
/// 单次执行日期
|
|
/// </summary>
|
|
public DateTime OnetimeDate
|
|
{
|
|
get { return MainForm.oneTime_date.DateTime; }
|
|
set { MainForm.oneTime_date.DateTime = value; }
|
|
}
|
|
/// <summary>
|
|
/// 单次执行时间
|
|
/// </summary>
|
|
public DateTime OnetimeTime
|
|
{
|
|
get { return MainForm.oneTime_time.Time; ; }
|
|
set { MainForm.oneTime_time.Time = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复执行类型
|
|
/// </summary>
|
|
public int LoopType
|
|
{
|
|
get { return MainForm.comboBox_freq.SelectedIndex; }
|
|
set { MainForm.comboBox_freq.SelectedIndex = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复按天执行Model
|
|
/// </summary>
|
|
public DayControlModel LoopDayControlModel
|
|
{
|
|
get;
|
|
set;
|
|
}
|
|
/// <summary>
|
|
/// 重复按周执行Model
|
|
/// </summary>
|
|
public WeekControlModel LoopWeekControlModel
|
|
{
|
|
get;
|
|
set;
|
|
}
|
|
/// <summary>
|
|
/// 重复按月执行Model
|
|
/// </summary>
|
|
public MonthControlModel LoopMonthControlModel
|
|
{
|
|
get;
|
|
set;
|
|
}
|
|
/// <summary>
|
|
/// 重复每天频率类型
|
|
/// </summary>
|
|
public int LoopDayType
|
|
{
|
|
get
|
|
{
|
|
int freqType = 0;
|
|
if (MainForm.radio_interval.Checked)
|
|
{
|
|
freqType = 1;
|
|
}
|
|
return freqType;
|
|
}
|
|
set
|
|
{
|
|
if (value == 0)
|
|
{
|
|
MainForm.radio_oneTime.Checked = true;
|
|
}
|
|
else if (value == 1)
|
|
{
|
|
MainForm.radio_interval.Checked = true;
|
|
}
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 重复每天执行一次时间
|
|
/// </summary>
|
|
public DateTime LoopDayOnetimeTime
|
|
{
|
|
get { return MainForm.time_oneTime.Time; }
|
|
set { MainForm.time_oneTime.Time = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复每天执行间隔开始时间
|
|
/// </summary>
|
|
public DateTime LoopDayStartTime
|
|
{
|
|
get { return MainForm.time_start.Time; }
|
|
set { MainForm.time_start.Time = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复每天执行间隔结束时间
|
|
/// </summary>
|
|
public DateTime LoopDayEndTime
|
|
{
|
|
get { return MainForm.time_end.Time; }
|
|
set { MainForm.time_end.Time = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复每天执行间隔数量
|
|
/// </summary>
|
|
public int LoopDayInterval
|
|
{
|
|
get { return (int)MainForm.spin_interval.Value; }
|
|
set { MainForm.spin_interval.Value = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复每天执行间隔单位
|
|
/// </summary>
|
|
public int LoopDayIntervalUnit
|
|
{
|
|
get { return MainForm.comboBox_unit.SelectedIndex; }
|
|
set { MainForm.comboBox_unit.SelectedIndex = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复执行开始日期
|
|
/// </summary>
|
|
public DateTime LoopStartDate
|
|
{
|
|
get { return MainForm.date_start.DateTime; }
|
|
set { MainForm.date_start.DateTime = value; }
|
|
}
|
|
/// <summary>
|
|
/// 重复执行结束日期
|
|
/// </summary>
|
|
public DateTime LoopEndDate
|
|
{
|
|
get { return MainForm.date_end.DateTime; }
|
|
set { MainForm.date_end.DateTime = value; }
|
|
}
|
|
/// <summary>
|
|
/// 无结束日期复选框状态
|
|
/// </summary>
|
|
public bool DateEndCheckState
|
|
{
|
|
get { return MainForm.dateEndCheck.Checked; }
|
|
set { MainForm.dateEndCheck.Checked = value; }
|
|
}
|
|
/// <summary>
|
|
/// 执行语句
|
|
/// </summary>
|
|
public string Sql
|
|
{
|
|
get { return MainForm.sql_memoEdit.Text; }
|
|
set { MainForm.sql_memoEdit.Text = value; }
|
|
}
|
|
/// <summary>
|
|
/// 摘要
|
|
/// </summary>
|
|
public string Tips
|
|
{
|
|
get { return MainForm.tips_memoEdit.Text; }
|
|
set { MainForm.tips_memoEdit.Text = value; }
|
|
}
|
|
}
|
|
}
|