public string parse_query(string key, string[,] flds)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
for (int i = 0; i < flds.GetLength(0); i++)
{
dict.Add(flds[i, 0], flds[i, 1]);
}
config.query q = _config.get_query(key);
return(parse(q.text, dict, conds: q.conds));
}
public bool check_exists(config.query qry, core cr, Dictionary <string, object> flds = null)
{
if (qry.queries.Count > 1)
{
for (int n = 0; n < qry.queries.Count - 1; n++)
{
exec(qry.queries[n]);
}
}
DataTable dt = dt_table(cr.parse(qry.queries[qry.queries.Count() - 1], flds));
return(dt != null && dt.Rows.Count > 0);
}
public string exec_qry(config.query qry, core cr, Dictionary <string, object> flds = null, bool getidentity = false)
{
string res = null;
if (qry.tp == config.query.tp_query.do_while)
{
foreach (DataRow dr in dt_table(qry.text_do).Rows)
{
res = exec(cr.parse(qry.text_while, flds, dr), getidentity);
}
}
else
{
foreach (string txt in qry.queries)
{
res = exec(cr.parse(txt, flds), getidentity);
}
}
return(res);
}
public DataTable dt_qry(config.query qry, core cr, Dictionary <string, object> flds = null)
{
return(dt_table(cr.parse(qry.text, flds)));
}
public string parse_query(string key, Dictionary <string, object> flds)
{
config.query q = _config.get_query(key);
return(parse(q.text, flds, conds: q.conds));
}
