public StationEditViewModel(StationListViewModel _vm,StationEdit _mw) { _StationListVM = _vm; _Window = _mw; OperationType = OpType.Add; StationObj = new StationOR(); UpdatetxtSource(_Window.gridContent); }
public StationEditViewModel(StationListViewModel _vm, StationEdit _mw, StationOR _StationObj) { _StationListVM = _vm; _Window = _mw; _SourceObj = _StationObj; OperationType = OpType.Alert; StationObj = new StationOR(); StationObj.Clone(_StationObj); }
/// <summary> /// 插入t_Station /// </summary> public virtual bool Insert(StationOR station) { string sql = "insert into t_Station ( StationName, IP, Port, HistoryPort) values ( @StationName, @IP, @Port, @HistoryPort)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, station.Stationname), new SqlParameter("@IP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "IP", DataRowVersion.Default, station.Ip), new SqlParameter("@Port", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Port", DataRowVersion.Default, station.Port), new SqlParameter("@HistoryPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HistoryPort", DataRowVersion.Default, station.Historyport) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public void Init() { StartDate = DateTime.Now.AddDays(-7); // Convert.ToDateTime("2011-10-01"); StartTime = "00:00:00"; EndDate = DateTime.Now; // Convert.ToDateTime("2011-10-15"); EndTime = "23:59:59"; AlarmLogS = new ObservableCollection<AlarmLogOR>(); StationDA _staDA = new StationDA(); StationORList = _staDA.selectAllStation(); StationOR tempOR = new StationOR(); tempOR.Stationid = -1; tempOR.Stationname = "所有站点"; StationORList.Insert(0,tempOR); SelectStationOR = tempOR; EventLists = new ObservableCollection<StatusOR>() { new StatusOR(){ ID=1, Name="1"}, new StatusOR(){ ID=2, Name="2"}, new StatusOR(){ ID=3, Name="3"}, new StatusOR(){ ID=4, Name="4"}, new StatusOR(){ ID=5, Name="5"}, new StatusOR(){ ID=6, Name="6"} }; StatusOR temp = new StatusOR() { ID = -1, Name = "所有事件级别" }; EventLists.Insert(0, temp); SelectEventOR = temp; //所有事件 EventsNames = new ObservableCollection<string>(); EventsNames = _dev.GetAllEventsName(); EventsNames.Insert(0,"所有事件名称"); SelectEventName = "所有事件名称"; DeviceORList = new ObservableCollection<DeviceOR>(); //DeviceOR objTemp = new DeviceOR() { Deviceid = -1, Devicename = "所有设备" }; DeviceOR objTemp = new DeviceOR() { Deviceid = -1, Devicename = "所有设备" }; DeviceORList.Insert(0, objTemp); SelectDeviceOR = objTemp; }
public StationOR selectARowDate(int m_id) { string sql = string.Format("select * from t_Station where Stationid='{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]; StationOR m_Stat = new StationOR(dr); return m_Stat; }
public ObservableCollection<StationOR> selectAllStation() { string sql = "select * from t_Station"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<StationOR> _stationList = new ObservableCollection<StationOR>(); foreach (DataRow dr in dt.Rows) { StationOR obj = new StationOR(dr); _stationList.Add(obj); } return _stationList; }
/// <summary> /// 更新t_Station /// </summary> public virtual bool Update(StationOR station) { string sql = "update t_Station set StationName = @StationName, IP = @IP, Port = @Port, HistoryPort = @HistoryPort where StationID = @StationID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, station.Stationid), new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, station.Stationname), new SqlParameter("@IP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "IP", DataRowVersion.Default, station.Ip), new SqlParameter("@Port", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Port", DataRowVersion.Default, station.Port), new SqlParameter("@HistoryPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HistoryPort", DataRowVersion.Default, station.Historyport) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public StationEditViewModel(StationOR _Sta) { OperationType = OpType.Alert; StationObj = _Sta; }
public StationEdit(StationListViewModel _List,StationOR _Station) { InitializeComponent(); this.DataContext = new StationEditViewModel(_List,this,_Station); }
public void Clone(StationOR obj) { Stationid = obj.Stationid; // 装点名称 Stationname = obj.Stationname; // IP Ip = obj.Ip; // 端口 Port = obj.Port; // 历史端口 Historyport = obj.Historyport; }