public SchedulingEditViewModel(SchedulingListViewModel _vm, SchedulingEditView _mw)
{
_SchedulingListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
SchedulingObj = new SchedulingOR();
//UpdatetxtSource(_Window.gridContent);
}
public SchedulingEditViewModel(SchedulingListViewModel _vm, SchedulingEditView _mw, SchedulingOR _SchedulingObj)
{
_SchedulingListVM = _vm;
_Window = _mw;
_SourceObj = _SchedulingObj;
OperationType = OpType.Alert;
SchedulingObj = new SchedulingOR();
SchedulingObj.Clone(_SchedulingObj);
}
/// <summary>
/// 插入t_Scheduling
/// </summary>
public virtual bool Insert(SchedulingOR scheduling)
{
string sql = "insert into t_Scheduling ( FrequencyName, StartTime, EndTime) values (@FrequencyName, @StartTime, @EndTime)";
SqlParameter [] parameters = new SqlParameter[]
{
//new SqlParameter("@Frequency", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Frequency", DataRowVersion.Default, scheduling.Frequency),
new SqlParameter("@FrequencyName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "FrequencyName", DataRowVersion.Default, scheduling.Frequencyname),
new SqlParameter("@StartTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StartTime", DataRowVersion.Default, scheduling.Starttime),
new SqlParameter("@EndTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "EndTime", DataRowVersion.Default, scheduling.Endtime)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public ObservableCollection<SchedulingOR> selectAllDate()
{
string sql = "select * from t_Scheduling";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<SchedulingOR> _List = new ObservableCollection<SchedulingOR>();
foreach (DataRow dr in dt.Rows)
{
SchedulingOR obj = new SchedulingOR(dr);
_List.Add(obj);
}
return _List;
}
public SchedulingEditViewModel(SchedulingOR _Sta)
{
OperationType = OpType.Alert;
SchedulingObj = _Sta;
}
public SchedulingOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_Scheduling where Frequency='{0}'",m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
SchedulingOR m_Sche=new SchedulingOR(dr);
return m_Sche;
}
/// <summary>
/// 更新t_Scheduling
/// </summary>
public virtual bool Update(SchedulingOR scheduling)
{
string sql = "update t_Scheduling set FrequencyName = @FrequencyName, StartTime = @StartTime, EndTime = @EndTime where Frequency = @Frequency";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@Frequency", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Frequency", DataRowVersion.Default, scheduling.Frequency),
new SqlParameter("@FrequencyName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "FrequencyName", DataRowVersion.Default, scheduling.Frequencyname),
new SqlParameter("@StartTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StartTime", DataRowVersion.Default, scheduling.Starttime),
new SqlParameter("@EndTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "EndTime", DataRowVersion.Default, scheduling.Endtime)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public void Clone(SchedulingOR obj)
{
//
Frequency = obj.Frequency;
//班次名称
Frequencyname = obj.Frequencyname;
//开始时间
Starttime = obj.Starttime;
//结束时间
Endtime = obj.Endtime;
}
public SchedulingEditView(SchedulingListViewModel _List, SchedulingOR _Scheduling)
{
InitializeComponent();
this.DataContext = new SchedulingEditViewModel(_List, this, _Scheduling);
}
