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;
}
