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