public ObservableCollection<LinkageSetOR> selectAllDate() { string sql = @"select tl.*,t.StationName,d.DeviceName,c.ChannelName ,tLine.StationName as LineStationName,dLine.DeviceName as LineDeviceName,cLine.ChannelName as LineChannelName from t_LinkageSet tl inner join t_Station t on tl.StationID=t.StationID inner join t_Device d on tl.DeviceID=d.DeviceID inner join t_Channel c on tl.ChannelNo=c.ChannelNo and c.DeviceID=d.DeviceID inner join t_Station tLine on tl.LinkageStationID=tLine.StationID inner join t_Device dLine on tl.LinkageDeviceID=dLine.DeviceID inner join t_Channel cLine on tl.LinkageChannelNo=cLine.ChannelNo and cLine.DeviceID=dLine.DeviceID"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<LinkageSetOR> _List = new ObservableCollection<LinkageSetOR>(); foreach (DataRow dr in dt.Rows) { LinkageSetOR obj = new LinkageSetOR(dr); _List.Add(obj); } return _List; }
public LinkageSetEditViewModel(LinkageSetListViewModel _vm, LinkageSetEditView _mw) { _LinkageSetListVM = _vm; _Window = _mw; OperationType = OpType.Add; LinkageSetObj = new LinkageSetOR(); Init(); }
public LinkageSetEditViewModel(LinkageSetListViewModel _vm, LinkageSetEditView _mw, LinkageSetOR _LinkageSetObj) { _LinkageSetListVM = _vm; _Window = _mw; _SourceObj = _LinkageSetObj; OperationType = OpType.Alert; LinkageSetObj = new LinkageSetOR(); LinkageSetObj.Clone(_LinkageSetObj); Init(); }
/// <summary> /// 插入t_LinkageSet /// </summary> public virtual bool Insert(LinkageSetOR linkageSet) { string sql = @"insert into t_LinkageSet(StationID, DeviceID, ChannelNo, ValueType, TriggerValue, LinkageStationID, LinkageDeviceID, LinkageChannelNo) values (@StationID, @DeviceID, @ChannelNo, @ValueType, @TriggerValue, @LinkageStationID, @LinkageDeviceID, @LinkageChannelNo)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, linkageSet.Stationid), new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, linkageSet.Deviceid), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, linkageSet.Channelno), new SqlParameter("@ValueType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ValueType", DataRowVersion.Default, linkageSet.Valuetype), new SqlParameter("@TriggerValue", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "TriggerValue", DataRowVersion.Default, linkageSet.Triggervalue), new SqlParameter("@LinkageStationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageStationID", DataRowVersion.Default, linkageSet.Linkagestationid), new SqlParameter("@LinkageDeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageDeviceID", DataRowVersion.Default, linkageSet.Linkagedeviceid), new SqlParameter("@LinkageChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageChannelNo", DataRowVersion.Default, linkageSet.Linkagechannelno) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
/// <summary> /// 更新t_LinkageSet /// </summary> public virtual bool Update(LinkageSetOR linkageSet) { string sql = "update t_LinkageSet set StationID = @StationID, DeviceID = @DeviceID, ChannelNo = @ChannelNo, ValueType = @ValueType, TriggerValue = @TriggerValue, LinkageStationID = @LinkageStationID, LinkageDeviceID = @LinkageDeviceID, LinkageChannelNo = @LinkageChannelNo where ID = @ID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, linkageSet.Id), new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, linkageSet.Stationid), new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, linkageSet.Deviceid), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, linkageSet.Channelno), new SqlParameter("@ValueType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ValueType", DataRowVersion.Default, linkageSet.Valuetype), new SqlParameter("@TriggerValue", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "TriggerValue", DataRowVersion.Default, linkageSet.Triggervalue), new SqlParameter("@LinkageStationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageStationID", DataRowVersion.Default, linkageSet.Linkagestationid), new SqlParameter("@LinkageDeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageDeviceID", DataRowVersion.Default, linkageSet.Linkagedeviceid), new SqlParameter("@LinkageChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageChannelNo", DataRowVersion.Default, linkageSet.Linkagechannelno) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public LinkageSetOR selectARowDate(string m_id) { string sql = string.Format("select * from t_LinkageSet where Id='{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]; LinkageSetOR m_Link = new LinkageSetOR(dr); return m_Link; }
public LinkageSetEditView(LinkageSetListViewModel _List, LinkageSetOR _LinkageSet) { InitializeComponent(); this.DataContext = new LinkageSetEditViewModel(_List, this, _LinkageSet); }
public LinkageSetEditViewModel(LinkageSetOR _Sta) { OperationType = OpType.Alert; LinkageSetObj = _Sta; }
public void Clone(LinkageSetOR obj) { // Id = obj.Id; //站点名称 Stationid = obj.Stationid; //设备名称 Deviceid = obj.Deviceid; //通道名 Channelno = obj.Channelno; //值类型 Valuetype = obj.Valuetype; //触动值 Triggervalue = obj.Triggervalue; //联动机房 Linkagestationid = obj.Linkagestationid; //联动设备名称 Linkagedeviceid = obj.Linkagedeviceid; //联动通道 Linkagechannelno = obj.Linkagechannelno; StationName = obj.StationName; DeviceName = obj.DeviceName; ChannelName = obj.ChannelName; LineStationName = obj.LineStationName; LineDeviceName = obj.LineDeviceName; LineChannelName = obj.LineChannelName; }