private bool UpdateDeviceInfo(ControllerType controllerType, ref LoopModel loop) { bool result = false; switch (controllerType) { case ControllerType.NT8001: break; case ControllerType.NT8007: break; case ControllerType.NT8021: break; case ControllerType.NT8036: break; case ControllerType.FT8000: { List <DeviceInfo8000> lstDeviceInfo = loop.GetDevices <DeviceInfo8000>(); foreach (var device in lstDeviceInfo) { if (device.TypeCode > 36 && device.TypeCode < 66) { device.Feature = 0; } else if (device.TypeCode >= 101 && device.TypeCode <= 129) { device.Feature = 1; device.TypeCode = System.Convert.ToInt16(device.TypeCode - 64); } } } break; case ControllerType.FT8003: { List <DeviceInfo8003> lstDeviceInfo = loop.GetDevices <DeviceInfo8003>(); foreach (var device in lstDeviceInfo) { if (device.TypeCode > 36 && device.TypeCode < 66) { device.Feature = 0; } else if (device.TypeCode >= 101 && device.TypeCode <= 129) { device.Feature = 1; device.TypeCode = System.Convert.ToInt16(device.TypeCode - 64); } } } break; } return(result); }
public bool AddDevice(LoopModel loop) { try { List <DeviceInfo8003> lstDevices = loop.GetDevices <DeviceInfo8003>(); foreach (var device in lstDevices) { device.Loop.ID = loop.ID; device.LoopID = loop.ID; //StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8003("); //sbDeviceInfoSQL.Append("ID,"); //sbDeviceInfoSQL.Append("Code,"); //sbDeviceInfoSQL.Append("Disable,"); //sbDeviceInfoSQL.Append("Feature,"); //sbDeviceInfoSQL.Append("DelayValue,"); //sbDeviceInfoSQL.Append("SensitiveLevel,"); //sbDeviceInfoSQL.Append("LinkageGroup1,"); //sbDeviceInfoSQL.Append("LinkageGroup2,"); //sbDeviceInfoSQL.Append("LinkageGroup3,"); //sbDeviceInfoSQL.Append("sdpKey,"); //sbDeviceInfoSQL.Append("BroadcastZone,"); //sbDeviceInfoSQL.Append("ZoneNo,"); //sbDeviceInfoSQL.Append("Location,"); //sbDeviceInfoSQL.Append("LoopID,"); //sbDeviceInfoSQL.Append("TypeCode)"); //sbDeviceInfoSQL.Append(" VALUES("); //sbDeviceInfoSQL.Append(device.ID + ",'"); //sbDeviceInfoSQL.Append(device.Code + "','"); //sbDeviceInfoSQL.Append(device.Disable + "','"); //sbDeviceInfoSQL.Append(device.Feature + "','"); //sbDeviceInfoSQL.Append(device.DelayValue + "','"); //sbDeviceInfoSQL.Append(device.SensitiveLevel + "','"); //sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','"); //sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','"); //sbDeviceInfoSQL.Append(device.LinkageGroup3 + "','"); //sbDeviceInfoSQL.Append(device.sdpKey + "','"); //sbDeviceInfoSQL.Append(device.BroadcastZone + "','"); //sbDeviceInfoSQL.Append(device.ZoneNo + "','"); //sbDeviceInfoSQL.Append(device.Location + "','"); //sbDeviceInfoSQL.Append(device.LoopID + "','"); //sbDeviceInfoSQL.Append(device.TypeCode + "');"); //_databaseService.ExecuteBySql(sbDeviceInfoSQL); _dbFileVersionService.AddDeviceForControllerType8003(device); } } catch (Exception ex) { return(false); } return(true); }
bool IDeviceDBServiceTest.AddDevice(LoopModel loop) { try { List <DeviceInfo8036> lstDevices = loop.GetDevices <DeviceInfo8036>(); foreach (var device in lstDevices) { device.Loop.ID = loop.ID; device.LoopID = loop.ID; //StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8036"); //sbDeviceInfoSQL.Append("(ID,"); //sbDeviceInfoSQL.Append("Code ,"); //sbDeviceInfoSQL.Append("Disable,"); //sbDeviceInfoSQL.Append("LinkageGroup1,"); //sbDeviceInfoSQL.Append("LinkageGroup2,"); //sbDeviceInfoSQL.Append("AlertValue ,"); //sbDeviceInfoSQL.Append("ForcastValue ,"); //sbDeviceInfoSQL.Append("DelayValue ,"); //sbDeviceInfoSQL.Append("BuildingNo ,"); //sbDeviceInfoSQL.Append("ZoneNo ,"); //sbDeviceInfoSQL.Append("FloorNo ,"); //sbDeviceInfoSQL.Append("RoomNo ,"); //sbDeviceInfoSQL.Append("Location ,"); //sbDeviceInfoSQL.Append("LoopID,"); //sbDeviceInfoSQL.Append("TypeCode"); //sbDeviceInfoSQL.Append(") VALUES("); //sbDeviceInfoSQL.Append(device.ID + ",'"); //sbDeviceInfoSQL.Append(device.Code + "','"); //sbDeviceInfoSQL.Append(device.Disable + "','"); //sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','"); //sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','"); //sbDeviceInfoSQL.Append(device.AlertValue + "','"); //sbDeviceInfoSQL.Append(device.ForcastValue + "','"); //sbDeviceInfoSQL.Append(device.DelayValue + "','"); //sbDeviceInfoSQL.Append(device.BuildingNo + "','"); //sbDeviceInfoSQL.Append(device.ZoneNo + "','"); //sbDeviceInfoSQL.Append(device.FloorNo + "','"); //sbDeviceInfoSQL.Append(device.RoomNo + "','"); //sbDeviceInfoSQL.Append(device.Location + "','"); //sbDeviceInfoSQL.Append(device.LoopID + "','"); //sbDeviceInfoSQL.Append(device.TypeCode + "');"); //_databaseService.ExecuteBySql(sbDeviceInfoSQL); _dbFileVersionService.AddDeviceForControllerType8036(device); } } catch (Exception ex) { return(false); } return(true); }
public bool AddDevice(LoopModel loop) { try { List <DeviceInfo8007> lstDevices = loop.GetDevices <DeviceInfo8007>(); foreach (var device in lstDevices) { device.Loop.ID = loop.ID; device.LoopID = loop.ID; StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8007("); sbDeviceInfoSQL.Append("ID,"); sbDeviceInfoSQL.Append("Code,"); sbDeviceInfoSQL.Append("Disable,"); sbDeviceInfoSQL.Append("Feature,"); sbDeviceInfoSQL.Append("SensitiveLevel,"); sbDeviceInfoSQL.Append("LinkageGroup1,"); sbDeviceInfoSQL.Append("LinkageGroup2,"); sbDeviceInfoSQL.Append("BuildingNo,"); sbDeviceInfoSQL.Append("ZoneNo,"); sbDeviceInfoSQL.Append("FloorNo,"); sbDeviceInfoSQL.Append("RoomNo,"); sbDeviceInfoSQL.Append("Location,"); sbDeviceInfoSQL.Append("LoopID,"); sbDeviceInfoSQL.Append("TypeCode)"); sbDeviceInfoSQL.Append(" VALUES("); sbDeviceInfoSQL.Append(device.ID + ",'"); sbDeviceInfoSQL.Append(device.Code + "','"); sbDeviceInfoSQL.Append(device.Disable + "','"); sbDeviceInfoSQL.Append(device.Feature + "','"); sbDeviceInfoSQL.Append(device.SensitiveLevel + "','"); sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','"); sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','"); sbDeviceInfoSQL.Append(device.BuildingNo + "','"); sbDeviceInfoSQL.Append(device.ZoneNo + "','"); sbDeviceInfoSQL.Append(device.FloorNo + "','"); sbDeviceInfoSQL.Append(device.RoomNo + "','"); sbDeviceInfoSQL.Append(device.Location + "','"); sbDeviceInfoSQL.Append(device.LoopID + "','"); sbDeviceInfoSQL.Append(device.TypeCode + "');"); _databaseService.ExecuteBySql(sbDeviceInfoSQL); } } catch (Exception ex) { return(false); } return(true); }
public bool AddDevice(LoopModel loop) { try { List <DeviceInfo8021> lstDevices = loop.GetDevices <DeviceInfo8021>(); foreach (var device in lstDevices) { device.Loop.ID = loop.ID; device.LoopID = loop.ID; //StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8021("); //sbDeviceInfoSQL.Append("ID,"); //sbDeviceInfoSQL.Append("Code,"); //sbDeviceInfoSQL.Append("Disable,"); //sbDeviceInfoSQL.Append("CurrentThreshold,"); //sbDeviceInfoSQL.Append("TemperatureThreshold,"); //sbDeviceInfoSQL.Append("BuildingNo,"); //sbDeviceInfoSQL.Append("ZoneNo,"); //sbDeviceInfoSQL.Append("FloorNo,"); //sbDeviceInfoSQL.Append("RoomNo,"); //sbDeviceInfoSQL.Append("Location,"); //sbDeviceInfoSQL.Append("LoopID,"); //sbDeviceInfoSQL.Append("TypeCode)"); //sbDeviceInfoSQL.Append(" VALUES("); //sbDeviceInfoSQL.Append(device.ID + ",'"); //sbDeviceInfoSQL.Append(device.Code + "','"); //sbDeviceInfoSQL.Append(device.Disable + "','"); //sbDeviceInfoSQL.Append(device.CurrentThreshold + "','"); //sbDeviceInfoSQL.Append(device.TemperatureThreshold + "','"); //sbDeviceInfoSQL.Append(device.BuildingNo + "','"); //sbDeviceInfoSQL.Append(device.ZoneNo + "','"); //sbDeviceInfoSQL.Append(device.FloorNo + "','"); //sbDeviceInfoSQL.Append(device.RoomNo + "','"); //sbDeviceInfoSQL.Append(device.Location + "','"); //sbDeviceInfoSQL.Append(device.LoopID + "','"); //sbDeviceInfoSQL.Append(device.TypeCode + "');"); //_databaseService.ExecuteBySql(sbDeviceInfoSQL); _dbFileVersionService.AddDeviceForControllerType8021(device); } } catch (Exception ex) { return(false); } return(true); }
private int GetDeviceCodeLength(ControllerType controllerType, LoopModel loop) { int deviceCodeLength = 0; switch (controllerType) { case ControllerType.NT8001: { List <DeviceInfo8001> lstDeviceInfo = loop.GetDevices <DeviceInfo8001>(); if (lstDeviceInfo.Count > 0) { deviceCodeLength = lstDeviceInfo[0].Code.Length; } } break; case ControllerType.NT8007: { List <DeviceInfo8007> lstDeviceInfo = loop.GetDevices <DeviceInfo8007>(); if (lstDeviceInfo.Count > 0) { deviceCodeLength = lstDeviceInfo[0].Code.Length; } } break; case ControllerType.NT8021: { List <DeviceInfo8021> lstDeviceInfo = loop.GetDevices <DeviceInfo8021>(); if (lstDeviceInfo.Count > 0) { deviceCodeLength = lstDeviceInfo[0].Code.Length; } } break; case ControllerType.NT8036: { List <DeviceInfo8036> lstDeviceInfo = loop.GetDevices <DeviceInfo8036>(); if (lstDeviceInfo.Count > 0) { deviceCodeLength = lstDeviceInfo[0].Code.Length; } } break; case ControllerType.FT8000: { List <DeviceInfo8000> lstDeviceInfo = loop.GetDevices <DeviceInfo8000>(); if (lstDeviceInfo.Count > 0) { deviceCodeLength = lstDeviceInfo[0].Code.Length; } } break; case ControllerType.FT8003: { List <DeviceInfo8003> lstDeviceInfo = loop.GetDevices <DeviceInfo8003>(); if (lstDeviceInfo.Count > 0) { deviceCodeLength = lstDeviceInfo[0].Code.Length; } } break; } return(deviceCodeLength); }
protected override void SetDownloadedDeviceInfoTotalAmountInCurrentLoop(LoopModel loopModel) { DownloadedDeviceInfoTotalAmountInCurrentLoop = loopModel.GetDevices <DeviceInfo8036>().Count; //设置当前回路的器件总数2017-04-06 }
private bool GenerateDeviceID(ControllerType controllerType, ref LoopModel loop) { bool resultFlag = false; try { switch (controllerType) { case ControllerType.NT8001: { int maxDeviceID = ProjectManager.GetInstance.MaxDeviceIDInController8001; List <DeviceInfo8001> lstDeviceInfo = loop.GetDevices <DeviceInfo8001>(); for (int i = 0; i < lstDeviceInfo.Count; i++) { maxDeviceID++; DeviceInfo8001 deviceInfo = lstDeviceInfo[i]; deviceInfo.ID = maxDeviceID; lstDeviceInfo[i] = deviceInfo; } ProjectManager.GetInstance.MaxDeviceIDInController8001 = maxDeviceID; } break; case ControllerType.NT8007: { int maxDeviceID = ProjectManager.GetInstance.MaxDeviceIDInController8007; List <DeviceInfo8007> lstDeviceInfo = loop.GetDevices <DeviceInfo8007>(); foreach (var device in lstDeviceInfo) { maxDeviceID++; device.ID = maxDeviceID; } ProjectManager.GetInstance.MaxDeviceIDInController8007 = maxDeviceID; } break; case ControllerType.NT8021: { int maxDeviceID = ProjectManager.GetInstance.MaxDeviceIDInController8021; List <DeviceInfo8021> lstDeviceInfo = loop.GetDevices <DeviceInfo8021>(); for (int i = 0; i < lstDeviceInfo.Count; i++) { maxDeviceID++; DeviceInfo8021 deviceInfo = lstDeviceInfo[i]; deviceInfo.ID = maxDeviceID; lstDeviceInfo[i] = deviceInfo; } ProjectManager.GetInstance.MaxDeviceIDInController8021 = maxDeviceID; } break; case ControllerType.NT8036: { int maxDeviceID = ProjectManager.GetInstance.MaxDeviceIDInController8036; List <DeviceInfo8036> lstDeviceInfo = loop.GetDevices <DeviceInfo8036>(); for (int i = 0; i < lstDeviceInfo.Count; i++) { maxDeviceID++; DeviceInfo8036 deviceInfo = lstDeviceInfo[i]; deviceInfo.ID = maxDeviceID; lstDeviceInfo[i] = deviceInfo; } ProjectManager.GetInstance.MaxDeviceIDInController8036 = maxDeviceID; } break; case ControllerType.FT8000: { int maxDeviceID = ProjectManager.GetInstance.MaxDeviceIDInController8000; List <DeviceInfo8000> lstDeviceInfo = loop.GetDevices <DeviceInfo8000>(); for (int i = 0; i < lstDeviceInfo.Count; i++) { maxDeviceID++; DeviceInfo8000 deviceInfo = lstDeviceInfo[i]; deviceInfo.ID = maxDeviceID; lstDeviceInfo[i] = deviceInfo; } ProjectManager.GetInstance.MaxDeviceIDInController8000 = maxDeviceID; } break; case ControllerType.FT8003: { int maxDeviceID = ProjectManager.GetInstance.MaxDeviceIDInController8003; List <DeviceInfo8003> lstDeviceInfo = loop.GetDevices <DeviceInfo8003>(); for (int i = 0; i < lstDeviceInfo.Count; i++) { maxDeviceID++; DeviceInfo8003 deviceInfo = lstDeviceInfo[i]; deviceInfo.ID = maxDeviceID; lstDeviceInfo[i] = deviceInfo; } ProjectManager.GetInstance.MaxDeviceIDInController8003 = maxDeviceID; } break; } resultFlag = true; } catch { } return(resultFlag); }
public void NavigateToDeviceInfoExecute(object o) { NavigatorItemViewModel item = (SCA.WPF.ViewModelsRoot.ViewModels.Navigator.NavigatorItemViewModel)((SCA.WPF.ViewsRoot.Views.Navigator.NavigatorView)((RoutedEventArgs)o).Source).HierarchyTreeView.SelectedItem; LoopModel loop = (SCA.Model.LoopModel)item.DataItem; ControllerType controllerType = loop.Controller.Type; switch (controllerType) { case ControllerType.NT8036: _deviceInfoViewModel8036.TheLoop = loop; _deviceInfoViewModel8036.DeviceInfoObservableCollection = new EditableDeviceInfo8036Collection(loop, loop.GetDevices <DeviceInfo8036>()); CurrentView = _deviceInfoViewModel8036; break; case ControllerType.NT8001: _deviceInfoViewModel8001.TheLoop = loop; _deviceInfoViewModel8001.DeviceInfoObservableCollection = new EditableDeviceInfo8001Collection(loop, loop.GetDevices <DeviceInfo8001>()); CurrentView = _deviceInfoViewModel8001; break; case ControllerType.NT8007: _deviceInfoViewModel8007.TheLoop = loop; _deviceInfoViewModel8007.DeviceInfoObservableCollection = new EditableDeviceInfo8007Collection(loop, loop.GetDevices <DeviceInfo8007>()); CurrentView = _deviceInfoViewModel8007; break; case ControllerType.FT8000: _deviceInfoViewModel8000.TheLoop = loop; _deviceInfoViewModel8000.DeviceInfoObservableCollection = new EditableDeviceInfo8000Collection(loop, loop.GetDevices <DeviceInfo8000>()); CurrentView = _deviceInfoViewModel8000; break; case ControllerType.FT8003: _deviceInfoViewModel8003.TheLoop = loop; _deviceInfoViewModel8003.DeviceInfoObservableCollection = new EditableDeviceInfo8003Collection(loop, loop.GetDevices <DeviceInfo8003>()); CurrentView = _deviceInfoViewModel8003; break; case ControllerType.NT8021: _deviceInfoViewModel8021.TheLoop = loop; _deviceInfoViewModel8021.DeviceInfoObservableCollection = new EditableDeviceInfo8021Collection(loop, loop.GetDevices <DeviceInfo8021>()); CurrentView = _deviceInfoViewModel8021; break; } }