public IList<Signal> SelectAll(String hostCode, String siteIdx) { var returns = new List<Signal>(); var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TUnitIOC WHERE DACIdx = " + siteIdx); foreach (DataRow dr in dt.Rows) { var g = new Signal(); g.FromDataRow(dr, hostCode); returns.Add(g); } return returns; }
public IList<Signal> SelectAll() { var returns = new List<Signal>(); var dt = SqlDbAccess.GetInstance().GetTable("select * from SZ01_TUnitIOC "); foreach (DataRow dr in dt.Rows) { var g = new Signal(); g.FromDataRow(dr, "SZ01"); returns.Add(g); } return returns; }
private void CreateInputTree() { var user = new UserInfo(); user.Id = "InputUserName1"; user.Name = MultilingualUtility.GetString("User"); CreateNode(user, null); var host = new TDBHost(); host.Name = MultilingualUtility.GetString("Host"); host.Id = "InputHost1"; CreateNode(host, null); var group = new Group(); group.Id = "InputGroup1"; group.Name = MultilingualUtility.GetString("Region"); CreateNode(group, null); var site = new Site(); site.Id = "InputSite1"; site.Name = MultilingualUtility.GetString("Site"); CreateNode(site, null); var equip = new Equipment(); equip.Id = "InputEquipment1"; equip.Name = MultilingualUtility.GetString("Equipment"); CreateNode(equip, null); var signal = new Signal(); signal.Id = "InputSignal1"; signal.Name = MultilingualUtility.GetString("Signal"); CreateNode(signal, null); var com = new Command(); com.Id = "InputCommand1"; com.Name = MultilingualUtility.GetString("Command"); CreateNode(com, null); var comdo = new CommandDO(); comdo.Id = "InputCommandDO1"; comdo.Name = MultilingualUtility.GetString("CommandDO"); CreateNode(comdo, null); var affair = new Affair(); affair.Id = "InputAffair1"; affair.Name = MultilingualUtility.GetString("Event"); CreateNode(affair, null); var node = new Node(); node.Id = "InputNode1"; node.Name = MultilingualUtility.GetString("Node"); CreateNode(node, null); }
private List<Int32> AddSignalNode(Equipment equipment, TreeNode parentNode) { var signalTags = new List<int>(); var signals = DALFacade.GetSignalDAL(StorageTypeEnum.MongoDB).SelectAll(equipment.Code, equipment.Idx); var tempSignal = new Signal(); tempSignal.Id = SPECIAL; tempSignal.Name = MultilingualUtility.GetString("Signal"); var tempNode = CreateNode(tempSignal, parentNode); foreach (var signal in signals) { CreateNode(signal, tempNode); signalTags.Add(signal.Idx); } return signalTags; }
private void AddSignalNodeBySite(Site site, TreeNode parentNode) { var signalTags = new List<int>(); var signals = DALFacade.GetSignalDAL(StorageTypeEnum.MongoDB).SelectAll(site.Code, site.Idx.ToString()); var tempSignal = new Signal(); tempSignal.Id = SPECIAL; tempSignal.Name = MultilingualUtility.GetString("Signal"); var tempNode = CreateNode(tempSignal, parentNode); foreach (var signal in signals) { CreateNode(signal, tempNode); signalTags.Add(signal.Idx); } AddEventNode(site.Code, signalTags, parentNode); AddCommandNode(site.Code, signalTags, parentNode); AddCommandDONode(site.Code, signalTags, parentNode); }
public Signal Select(String hostCode, int idx) { var returns = new Signal(); var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TUnitIOC WHERE Idx = " + idx); foreach (DataRow dr in dt.Rows) { returns.FromDataRow(dr, hostCode); } return returns; }
public void Save(Signal signal) { DALFacade.GetSignalDAL(StorageTypeEnum.MongoDB).SaveAll(new List<Signal>() { signal }); }