public IList<Affair> SelectAll(String hostCode, List<Int32> affairTags)
{
var returns = new List<Affair>();
var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TPointAlarm where TagID in (" + String.Join(",", affairTags) + ")");
foreach (DataRow dr in dt.Rows)
{
var g = new Affair();
g.FromDataRow(dr, hostCode);
returns.Add(g);
}
return returns;
}
public IList<Affair> SelectAll(String hostCode)
{
var returns = new List<Affair>();
var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TPointAlarm ");
foreach (DataRow dr in dt.Rows)
{
var g = new Affair();
g.FromDataRow(dr, hostCode);
returns.Add(g);
}
return returns;
}
public Affair this[String id]
{
get
{
var entity = DALFacade.GetAffairDAL(StorageTypeEnum.MongoDB).Select(id);
if (entity == null)
{
entity = new Affair();
PageLogger.RecordInfoLog(String.Format("We cann't find affair {0} in MongoDB", id));
}
return entity;
}
}
public void Save(Affair affair)
{
DALFacade.GetAffairDAL(StorageTypeEnum.MongoDB).SaveAll(new List<Affair>() { affair });
}
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 void AddEventNode(String code, List<Int32> signalTags, TreeNode parentNode)
{
var affairs = DALFacade.GetAffairDAL(StorageTypeEnum.MongoDB).SelectAll(code, signalTags);
var tempAffair = new Affair();
tempAffair.Id = SPECIAL;
tempAffair.Name = MultilingualUtility.GetString("Event");
var tempNode = CreateNode(tempAffair, parentNode);
foreach (var affair in affairs)
{
CreateNode(affair, tempNode);
}
}
