public IList<Equipment> SelectAll(String hostCode, int dACIdx)
{
var returns = new List<Equipment>();
var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TUnitIOM WHERE DACIdx = " + dACIdx);
foreach (DataRow dr in dt.Rows)
{
Equipment g = new Equipment();
g.FromDataRow(dr, hostCode);
returns.Add(g);
}
return returns;
}
public IList<Equipment> SelectAll()
{
var returns = new List<Equipment>();
var dt = SqlDbAccess.GetInstance().GetTable("select * from SZ01_TUnitIOM");
foreach (DataRow dr in dt.Rows)
{
Equipment g = new Equipment();
g.FromDataRow(dr, "SZ01");
returns.Add(g);
}
return returns;
}
public Equipment this[String id]
{
get
{
var entity = DALFacade.GetEquipmentDAL(StorageTypeEnum.MongoDB).Select(id);
if (entity == null)
{
entity = new Equipment();
PageLogger.RecordInfoLog(String.Format("We cann't find equipment {0} in MongoDB", id));
}
return entity;
}
}
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 AddChildOfEquipmentNode(Equipment equipment, TreeNode parentNode)
{
var signalTags = AddSignalNode(equipment, parentNode);
AddEventNode(equipment.Code, signalTags, parentNode);
AddCommandNode(equipment.Code, signalTags, parentNode);
AddCommandDONode(equipment.Code, signalTags, parentNode);
}
private IList<Equipment> TestData()
{
var result = new List<Equipment>();
//测试数据
var user = new Equipment();
user.Id = "1";
user.Name = "设备1";
user.ParentId = "1";
result.Add(user);
user = new Equipment();
user.Id = "2";
user.Name = "设备2";
user.ParentId = "2";
result.Add(user);
user = new Equipment();
user.Id = "3";
user.Name = "设备3";
user.ParentId = "3";
result.Add(user);
user = new Equipment();
user.Id = "4";
user.Name = "设备4";
user.ParentId = "4";
result.Add(user);
user = new Equipment();
user.Id = "5";
user.Name = "设备5";
user.ParentId = "5";
result.Add(user);
user = new Equipment();
user.Id = "6";
user.Name = "设备6";
user.ParentId = "6";
result.Add(user);
return result;
}
private void LoadCommands(Equipment equipment)
{
var signalTags = GetSignalTages(equipment);
}
private List<Int32> GetSignalTages(Equipment equipment)
{
var signalTags = new List<int>();
var signals = DALFacade.GetSignalDAL(StorageTypeEnum.MongoDB).SelectAll(equipment.Code, equipment.Idx);
foreach (var signal in signals)
{
signalTags.Add(signal.Idx);
}
return signalTags;
}
private void AddChildOfEquipmentNode(Equipment equipment, TreeNode parentNode)
{
var result = new List<CommandInfo>();
var signalTags = GetSignalTages(equipment);
result.AddRange(AddCommandNode(equipment.Code, equipment.Address, signalTags));
result.AddRange(AddCommandDONode(equipment.Code, equipment.Address, signalTags));
CurrentDataSource = result;
dgvCommand.DataSource = result;
}
