public void InitData(ChannelManagementOR obj)
{
if (obj == null)
return;
_Window._ManagementList.DataContext =new AlarmPolicyManagementEditViewModel(obj,this);
}
public AlarmPolicyManagementEditViewModel(ChannelManagementOR _mSta,AlarmPolicyManagementListViewModel _List)
{
_Sta = _mSta;
_AlarmPolicyManagementListVM = _List;
Init();
}
public ObservableCollection<ChannelManagementOR> SelectChannelManagements(int strDeviceID, int StationID, int DeviceTypeID)
{
string sql = string.Format(@"select
*,dbo.F_ISExisAlarmPolicy({0},{1},{2},Channelno) as ISHavePolice from t_Channel where DeviceID={2} order by ChannelName",
StationID, DeviceTypeID, strDeviceID);
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<ChannelManagementOR> _List = new ObservableCollection<ChannelManagementOR>();
foreach (DataRow dr in dt.Rows)
{
ChannelManagementOR obj = new ChannelManagementOR(dr);
obj.StationID = StationID;
obj.Deviceid = strDeviceID;
obj.DeviceTypeID = DeviceTypeID;
_List.Add(obj);
}
return _List;
}
public AlarmPolicyManagementEditViewModel()
{
Init();
_Sta = new ChannelManagementOR();
}
