public IList<Site> SelectAll() { IList<Site> returns = new List<Site>(); DataTable dt = SqlDbAccess.GetInstance().GetTable("select * from SZ01_TUnitDAC"); foreach (DataRow dr in dt.Rows) { Site g = new Site(); g.FromDataRow(dr, "SZ01"); returns.Add(g); } return returns; }
public IList<Site> SelectAll(String hostCode) { var returns = new List<Site>(); var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TUnitDAC"); foreach (DataRow dr in dt.Rows) { var g = new Site(); g.FromDataRow(dr, hostCode); 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 IList<Site> TestData() { var result = new List<Site>(); //测试数据 var user = new Site(); user.Id = "1"; user.Name = "小区1"; user.ParentId = "1"; result.Add(user); user = new Site(); user.Id = "2"; user.Name = "小区2"; user.ParentId = "2"; result.Add(user); user = new Site(); user.Id = "3"; user.Name = "小区3"; user.ParentId = "3"; result.Add(user); user = new Site(); user.Id = "4"; user.Name = "小区4"; user.ParentId = "4"; result.Add(user); user = new Site(); user.Id = "5"; user.Name = "小区5"; user.ParentId = "5"; result.Add(user); user = new Site(); user.Id = "6"; user.Name = "小区6"; user.ParentId = "6"; result.Add(user); return result; }
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); }
private void AddEquipmentNode(Site site, TreeNode parentNode) { var equipments = DALFacade.GetEquipmentDAL(StorageTypeEnum.MongoDB).SelectAll(site.Code, site.Idx); foreach (var equipment in equipments) { CreateNode(equipment, parentNode); } }
private void AddChildOfSiteNode(Site site, TreeNode parentNode) { var result = new List<CommandInfo>(); var signalTags = new List<int>(); var signals = DALFacade.GetSignalDAL(StorageTypeEnum.MongoDB).SelectAll(site.Code, site.Idx.ToString()); foreach (var signal in signals) { signalTags.Add(signal.Idx); } result.AddRange(AddCommandNode(site.Code, site.Address, signalTags)); result.AddRange(AddCommandDONode(site.Code, site.Address, signalTags)); CurrentDataSource = result; dgvCommand.DataSource = result; }
private List<TreeNode> AddEquipmentNode(Site site, TreeNode parentNode) { var nodes = new List<TreeNode>(); var equipments = DALFacade.GetEquipmentDAL(StorageTypeEnum.MongoDB).SelectAll(site.Code, site.Idx); foreach (var equipment in equipments) { nodes.Add(CreateNode(equipment, parentNode)); } return nodes; }