public string ToString(string name)
{
NodeEntity root = setting.GetNode().Find(@"SqlFactory").Find(name);
SelectStatement s = SelectFromNode(root);
List <JoinKeyword> j = JoinsFromNode(root);
WhereKeyword w = WhereFromNode(root);
j.ForEach(item => { s.AddJoin(item); });
s.SetWhere(w);
return(s.ToString());
}
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);
}
