public string CompilarInitial(CompilerWithFuzzy.Compiler.Syn.ParseTree.Container c)
{
if (c.ContainsKey("campo") && c.ContainsKey("tabela") && c.ContainsKey("condicao"))
{
return string.Format("SELECT {0} FROM {1} {2}",
DicCompileExample[c["campo"].TypeName](c["campo"]),
DicCompileExample[c["tabela"].TypeName](c["tabela"]), c.ContainsKey("condicao") ?
DicCompileExample[c["condicao"].TypeName](c["condicao"]) : string.Empty);
}
else if (c.ContainsKey("tabela") && c.ContainsKey("condicao"))
{
return string.Format("SELECT {0} FROM {1} {2}",
"*",
DicCompileExample[c["tabela"].TypeName](c["tabela"]), c.ContainsKey("condicao") ?
DicCompileExample[c["condicao"].TypeName](c["condicao"]) : string.Empty);
}
else
{
return "SELECT * FROM " + DicCompileExample[c["tabela"].TypeName](c["tabela"]);
}
}
public string Condicao(CompilerWithFuzzy.Compiler.Syn.ParseTree.Container c)
{
return string.Format("WHERE {0} > {1}",
CompilarCampoSemAlias(c["campo"]),
c["numero"].Value);
}
public string CompilarCampoSemAlias(CompilerWithFuzzy.Compiler.Syn.ParseTree.Container c)
{
return c["nomecampo"].Value.ToLower() == "codigo" ? "ID" : c["nomecampo"].Value;
}