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