public TimeLinkageEditViewModel(TimeLinkageListViewModel _vm, TimeLinkageEditView _mw) { _TimeLinkageListVM = _vm; _Window = _mw; OperationType = OpType.Add; TimeLinkageObj = new TimeLinkageOR(); Init(); }
public TimeLinkageEditViewModel(TimeLinkageListViewModel _vm, TimeLinkageEditView _mw, TimeLinkageOR _TimeLinkageObj) { _TimeLinkageListVM = _vm; _Window = _mw; _SourceObj = _TimeLinkageObj; OperationType = OpType.Alert; TimeLinkageObj = new TimeLinkageOR(); TimeLinkageObj.Clone(_TimeLinkageObj); Init(); }
/// <summary> /// 插入t_TimeLinkage /// </summary> public virtual bool Insert(TimeLinkageOR timeLinkage) { string sql = @"insert into t_TimeLinkage (LinkageStationID, LinkageDeviceID, LinkageChannelNo, TriggerTime) values (@LinkageStationID, @LinkageDeviceID, @LinkageChannelNo, @TriggerTime)"; SqlParameter[] parameters = new SqlParameter[] { //new SqlParameter("@LinkageID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageID", DataRowVersion.Default, timeLinkage.Linkageid), new SqlParameter("@LinkageStationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageStationID", DataRowVersion.Default, timeLinkage.Linkagestationid), new SqlParameter("@LinkageDeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageDeviceID", DataRowVersion.Default, timeLinkage.Linkagedeviceid), new SqlParameter("@LinkageChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageChannelNo", DataRowVersion.Default, timeLinkage.Linkagechannelno), new SqlParameter("@TriggerTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "TriggerTime", DataRowVersion.Default, timeLinkage.Triggertime) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public ObservableCollection<TimeLinkageOR> selectAllDate() { string sql = @"select tl.*,t.StationName,d.DeviceName,c.ChannelName from t_TimeLinkage tl inner join t_Station t on tl.LinkageStationID=t.StationID inner join t_Device d on tl.LinkageDeviceID=d.DeviceID inner join t_Channel c on tl.LinkageChannelNo=c.ChannelNo and c.DeviceID=d.DeviceID"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<TimeLinkageOR> _List = new ObservableCollection<TimeLinkageOR>(); foreach (DataRow dr in dt.Rows) { TimeLinkageOR obj = new TimeLinkageOR(dr); _List.Add(obj); } return _List; }
/// <summary> /// 更新t_TimeLinkage /// </summary> public virtual bool Update(TimeLinkageOR timeLinkage) { string sql = "update t_TimeLinkage set LinkageStationID = @LinkageStationID, LinkageDeviceID = @LinkageDeviceID, LinkageChannelNo = @LinkageChannelNo, TriggerTime = @TriggerTime where LinkageID = @LinkageID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@LinkageID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageID", DataRowVersion.Default, timeLinkage.Linkageid), new SqlParameter("@LinkageStationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageStationID", DataRowVersion.Default, timeLinkage.Linkagestationid), new SqlParameter("@LinkageDeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageDeviceID", DataRowVersion.Default, timeLinkage.Linkagedeviceid), new SqlParameter("@LinkageChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageChannelNo", DataRowVersion.Default, timeLinkage.Linkagechannelno), new SqlParameter("@TriggerTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "TriggerTime", DataRowVersion.Default, timeLinkage.Triggertime) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public TimeLinkageOR selectARowDate(string m_id) { string sql = string.Format("select * from t_TimeLinkage where Linkageid='{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]; TimeLinkageOR m_Time = new TimeLinkageOR(dr); return m_Time; }
public void Clone(TimeLinkageOR obj) { // Linkageid = obj.Linkageid; //联动机房名称 Linkagestationid = obj.Linkagestationid; //联动设备名称 Linkagedeviceid = obj.Linkagedeviceid; //联动通道名称 Linkagechannelno = obj.Linkagechannelno; //联动时间 Triggertime = obj.Triggertime; StationName = obj.StationName; DeviceName = obj.DeviceName; ChannelName = obj.ChannelName; }
public TimeLinkageEditViewModel(TimeLinkageOR _Sta) { OperationType = OpType.Alert; TimeLinkageObj = _Sta; }
public TimeLinkageEditView(TimeLinkageListViewModel _List, TimeLinkageOR _TimeLinkage) { InitializeComponent(); this.DataContext = new TimeLinkageEditViewModel(_List, this, _TimeLinkage); }