/// <summary>
/// 根据站点、设备类型查询设备
/// </summary>
/// <param name="nStationID"></param>
/// <param name="mDeviceTypeID"></param>
/// <returns></returns>
public ObservableCollection<DeviceOR> GetAllGenerdDevice(string nStationID, string mDeviceTypeID)
{
string sql = string.Format(@"select d.*,dt.DeviceTypeID from t_Device d
inner join t_DeviceType dt on d.DeviceTypeID=dt.DeviceTypeID and d.stationid={0} and dt.DeviceTypeID={1} "
, nStationID, mDeviceTypeID);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<DeviceOR> _List = new ObservableCollection<DeviceOR>();
foreach (DataRow dr in dt.Rows)
{
DeviceOR obj = new DeviceOR(dr);
_List.Add(obj);
}
return _List;
}
/// <summary>
/// 根据机房ID查询已配置的策略
/// </summary>
/// <param name="strStationID"></param>
/// <returns></returns>
public ObservableCollection<DeviceOR> selectDevices(string strStationID)
{
string sql = string.Format(@"select distinct d.* from t_Device d
inner join t_Channel A on a.deviceid=d.deviceid
inner join t_AlarmPolicyManagement B on A.DeviceID=B.DeviceID AND DeviceChannelID=ChannelNo
where d.stationid={0} order by d.deviceid", strStationID);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<DeviceOR> _List = new ObservableCollection<DeviceOR>();
foreach (DataRow dr in dt.Rows)
{
DeviceOR obj = new DeviceOR(dr);
_List.Add(obj);
}
return _List;
}
public ObservableCollection<DeviceOR> selectDevices(string strid)
{
string sql = string.Format("select * from t_Device where StationID={0} order by StationID,DeviceName", strid);
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<DeviceOR> _List = new ObservableCollection<DeviceOR>();
foreach (DataRow dr in dt.Rows)
{
DeviceOR obj = new DeviceOR(dr);
_List.Add(obj);
}
return _List;
}
public void cbStation_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (SelectStationOR == null)
return;
if (DeviceORList != null)
DeviceORList.Clear();
var v = _dev.selectDevices(SelectStationOR.Stationid.ToString());
foreach (DeviceOR obj in v)
{
DeviceORList.Add(obj);
}
DeviceOR objTemp = new DeviceOR() { Deviceid = -1, Devicename = "所有设备" };
DeviceORList.Insert(0, objTemp);
SelectDeviceOR = objTemp;
}
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 void cbStation_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Console.WriteLine("start cbStation_SelectionChanged");
if (SelectStationOR.Stationid == -1)
return;
//SelectDeviceOR = null;
if (DeviceORList != null)
DeviceORList.Clear();
else
DeviceORList = new ObservableCollection<DeviceOR>();
var v = _dev.selectDevices(SelectStationOR.Stationid.ToString());
foreach (DeviceOR obj in v)
{
DeviceORList.Add(obj);
}
DeviceOR objTemp = new DeviceOR() { Deviceid = -1, Devicename = "所有设备" };
DeviceORList.Insert(0, objTemp);
SelectDeviceOR = objTemp;
Console.WriteLine("End cbStation_SelectionChanged");
}
public void Clone(DeviceOR obj)
{
//
Deviceid = obj.Deviceid;
//
Devicename = obj.Devicename;
//
Communicatetype = obj.Communicatetype;
//
Communicateid = obj.Communicateid;
//
Subaddr = obj.Subaddr;
//
Devicetypeid = obj.Devicetypeid;
//
Stationid = obj.Stationid;
//
Stationname = obj.Stationname;
//
Ip = obj.Ip;
//
Userid = obj.Userid;
//
Password = obj.Password;
//
Enable = obj.Enable;
//
Port = obj.Port;
}
