public AlramBindTimeEditViewModel(AlramBindTimeListViewModel _vm, AlramBindTimeEditView _mw) { _AlramBindTimeListVM = _vm; _Window = _mw; OperationType = OpType.Add; AlramBindTimeObj = new AlramBindTimeOR(); Init(); }
public AlramBindTimeEditViewModel(AlramBindTimeListViewModel _vm, AlramBindTimeEditView _mw, AlramBindTimeOR _AlramBindTimeObj) { _AlramBindTimeListVM = _vm; _Window = _mw; _SourceObj = _AlramBindTimeObj; OperationType = OpType.Alert; AlramBindTimeObj = new AlramBindTimeOR(); AlramBindTimeObj.Clone(_AlramBindTimeObj); Init(); }
/// <summary> /// 插入t_AlramBindTime /// </summary> public virtual bool Insert(AlramBindTimeOR alramBindTime) { string sql = "insert into t_AlramBindTime (StationID, DeviceID, ChannelNo, IntervalTime) values(@StationID, @DeviceID, @ChannelNo, @IntervalTime)"; SqlParameter[] parameters = new SqlParameter[] { //new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alramBindTime.Id), new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, alramBindTime.Stationid), new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, alramBindTime.Deviceid), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, alramBindTime.Channelno), new SqlParameter("@IntervalTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IntervalTime", DataRowVersion.Default, alramBindTime.Intervaltime) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public ObservableCollection<AlramBindTimeOR> selectAllDate() { string sql = @"select tl.*,t.StationName,d.DeviceName,c.ChannelName from t_AlramBindTime 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"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<AlramBindTimeOR> _List = new ObservableCollection<AlramBindTimeOR>(); foreach (DataRow dr in dt.Rows) { AlramBindTimeOR obj = new AlramBindTimeOR(dr); _List.Add(obj); } return _List; }
public AlramBindTimeEditViewModel(AlramBindTimeOR _Sta) { OperationType = OpType.Alert; AlramBindTimeObj = _Sta; }
public AlramBindTimeEditView(AlramBindTimeListViewModel _List, AlramBindTimeOR _AlramBindTime) { InitializeComponent(); this.DataContext = new AlramBindTimeEditViewModel(_List, this, _AlramBindTime); }
public AlramBindTimeOR selectARowDate(string m_id) { string sql = string.Format("select * from t_AlramBindTime 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]; AlramBindTimeOR m_Alra = new AlramBindTimeOR(dr); return m_Alra; }
/// <summary> /// 更新t_AlramBindTime /// </summary> public virtual bool Update(AlramBindTimeOR alramBindTime) { string sql = "update t_AlramBindTime set StationID = @StationID, DeviceID = @DeviceID, ChannelNo = @ChannelNo, IntervalTime = @IntervalTime where ID = @ID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alramBindTime.Id), new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, alramBindTime.Stationid), new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, alramBindTime.Deviceid), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, alramBindTime.Channelno), new SqlParameter("@IntervalTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IntervalTime", DataRowVersion.Default, alramBindTime.Intervaltime) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public void Clone(AlramBindTimeOR obj) { // Id = obj.Id; //站点 Stationid = obj.Stationid; //设备 Deviceid = obj.Deviceid; //通道名 Channelno = obj.Channelno; //间隔时间 Intervaltime = obj.Intervaltime; StationName = obj.StationName; DeviceName = obj.DeviceName; ChannelName = obj.ChannelName; }