private List <JoinKeyword> JoinsFromNode(NodeEntity arg)
{
List <JoinKeyword> ret = new List <JoinKeyword>();
string tableName = arg.Find(@"Select").Find(@"Columns", @"attr", @"Main").Find(@"Table").GetNodeValue();
string tableAlias = arg.Find(@"Select").Find(@"Columns", @"attr", @"Main").Find(@"Alias").GetNodeValue();
NodeEntity joins = arg.Find(@"Join");
joins.GetChildren().ForEach(item => {
JoinKeyword add = new JoinKeyword();
add.SetTable(tableName);
add.SetTableAlias(tableAlias);
add.SetJoinTable(item.Find(@"Name").GetNodeValue());
add.SetJoinTableAlias(item.Find(@"Alias").GetNodeValue());
add.SetInnerJoin(item.Find(@"Inner").GetNodeValue() == @"True" ? true : false);
add.SetLeftOuterJoin(item.Find(@"Left").GetNodeValue() == @"True" ? true : false);
add.SetRightOuterJoin(item.Find(@"Right").GetNodeValue() == @"True" ? true : false);
add.SetCrossJoin(item.Find(@"Cross").GetNodeValue() == @"True" ? true : false);
item.Find(@"Conditions").GetChildren().ForEach(c => {
add.AddCondition(
c.Find(@"Equal").GetNodeValue() == @"True" ? true : false
, c.Find(@"GreaterThanEqual").GetNodeValue() == @"True" ? true : false
, c.Find(@"JoinTableAsLarger").GetNodeValue() == @"True" ? true : false
, c.Find(@"JoinTableColumn").GetNodeValue()
, c.Find(@"TableColumn").GetNodeValue());
});
ret.Add(add);
});
return(ret);
}
public TagMasterCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"TagMaster");
TagInput = page.Find(@"TagInput").NodeValue;
SearchButton = page.Find(@"SearchButton").NodeValue;
}
public TagCardCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"TagCard");
TagInput = page.Find(@"TagInput").NodeValue;
RegisterButton = page.Find(@"RegisterButton").NodeValue;
}
public TableListCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"TableList");
ReloadButton = page.Find(@"ReloadButton").NodeValue;
TableNameColumn = page.Find(@"TableNameColumn").NodeValue;
}
public BinaryStorageCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"BinaryStorage");
KeyInput = page.Find(@"KeyInput").NodeValue;
TagInput = page.Find(@"TagInput").NodeValue;
SearchButton = page.Find(@"SearchButton").NodeValue;
}
public CloneCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"Clone");
PasswordInput = page.Find(@"PasswordInput").NodeValue;
SelectFileButton = page.Find(@"SelectFileButton").NodeValue;
RunButton = page.Find(@"RunButton").NodeValue;
FilePathOutput = page.Find(@"FilePathOutput").NodeValue;
}
public StringCardCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"StringCard");
Key = page.Find(@"Key").NodeValue;
Value = page.Find(@"Value").NodeValue;
TagInputList = page.Find(@"TagInputList").NodeValue;
RegisterButton = page.Find(@"RegisterButton").NodeValue;
}
public QueryStringInputCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"QueryStringInput");
ExecuteButton = page.Find(@"ExecuteButton").NodeValue;
BeginButton = page.Find(@"BeginButton").NodeValue;
CommitButton = page.Find(@"CommitButton").NodeValue;
RollbackButton = page.Find(@"RollbackButton").NodeValue;
}
public FileBrowseCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"FileBrowse");
PasswordInput = page.Find(@"PasswordInput").NodeValue;
BrowseButton = page.Find(@"BrowseButton").NodeValue;
NewFileButton = page.Find(@"NewFileButton").NodeValue;
FilePathOutput = page.Find(@"FilePathOutput").NodeValue;
}
public BinaryCardCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"BinaryCard");
Key = page.Find(@"Key").NodeValue;
FileNameOutput = page.Find(@"FileNameOutput").NodeValue;
TagInputList = page.Find(@"TagInputList").NodeValue;
RetrieveFileButton = page.Find(@"RetrieveFileButton").NodeValue;
SelectFileButton = page.Find(@"SelectFileButton").NodeValue;
RegisterButton = page.Find(@"RegisterButton").NodeValue;
}
public MainWindowCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"PageName");
TabFileBrowse = page.Find(@"FileBrowse").NodeValue;
TabTableList = page.Find(@"TableList").NodeValue;
TabQueryStringInput = page.Find(@"QueryStringInput").NodeValue;
TabQueryResultViewList = page.Find(@"QueryResultViewList").NodeValue;
TabStringStorage = page.Find(@"StringStorage").NodeValue;
TabBinaryStorage = page.Find(@"BinaryStorage").NodeValue;
TabTagMaster = page.Find(@"TagMaster").NodeValue;
TabClone = page.Find(@"Clone").NodeValue;
TabRunningInformation = page.Find(@"RunningInformations").NodeValue;
}
private void AddBinding(NodeEntity arg)
{
if (@"Binding".Equals(arg.GetNodeName()))
{
Keys addKey = StringToKey(arg.Find(@"BindFrom").Find(@"Key").GetNodeValue());
bool isUp = bool.Parse(arg.Find(@"BindFrom").Find(@"IsUp").GetNodeValue());
Binding add = new Binding(addKey, isUp);
arg.Find(@"BindTo").GetChildren().ForEach(item => {
Keys childKey = StringToKey(item.Find(@"Key").GetNodeValue());
bool childIsUp = bool.Parse(item.Find(@"IsUp").GetNodeValue());
add.Add(childKey, childIsUp);
});
b.Add(add);
}
}
public OFWindowCaptions(NodeEntity n)
{
var lang = n.Find(@"SettingDef").Find(@"Language").NodeValue;
var page = n.Find(@"SettingDef").Find(@"Localization").Find(lang).Find(@"OFWindow");
OpenDatabaseTitle = page.Find(@"OpenDatabaseTitle").NodeValue;
NewDatabaseTitle = page.Find(@"NewDatabaseTitle").NodeValue;
OpenDatabaseButton = page.Find(@"OpenDatabaseButton").NodeValue;
NewDatabaseButton = page.Find(@"NewDatabaseButton").NodeValue;
FileNameColumn = page.Find(@"FileNameColumn").NodeValue;
CloneDatabaseTitle = page.Find(@"CloneDatabaseTitle").NodeValue;
OverwriteDialogTitle = page.Find(@"OverwriteDialogTitle").NodeValue;
OverwriteMessage = page.Find(@"OverwriteMessage").NodeValue;
SelectFileTitle = page.Find(@"SelectFileTitle").NodeValue;
RetrieveFileTitle = page.Find(@"RetrieveFileTitle").NodeValue;
SelectPathButton = page.Find(@"SelectPathButton").NodeValue;
SaveFileButton = page.Find(@"SaveFileButton").NodeValue;
}
private SelectStatement SelectFromNode(NodeEntity arg)
{
SelectStatement ret = new SelectStatement();
NodeEntity columns = arg.Find(@"Select");
for (int i = 0; i < columns.GetChildren().Count; i++)
{
NodeEntity child = columns.GetChildren()[i];
if (i == 0)
{
ret.SetTable(child.Find(@"Table").GetNodeValue());
ret.SetTableAlias(child.Find(@"Alias").GetNodeValue());
}
child.Find(@"Column").GetChildren().ForEach(item => {
ret.AddColumn(item.GetNodeValue(), child.Find(@"Alias").GetNodeValue());
});
}
return(ret);
}
private WhereKeyword WhereFromNode(NodeEntity arg)
{
WhereKeyword ret = new WhereKeyword();
NodeEntity where = arg.Find(@"Where");
where.GetChildren().ForEach(item => {
ret.AddCondition(
item.Find(@"Equal").GetNodeValue() == @"True" ? true : false
, item.Find(@"GreaterThanEqual").GetNodeValue() == @"True" ? true : false
, item.Find(@"RightSideAsLarger").GetNodeValue() == @"True" ? true : false
, item.Find(@"Alias").GetNodeValue()
, item.Find(@"Name").GetNodeValue()
, item.Find(@"Value").GetNodeValue());
});
return(ret);
}
