public SQLParamList GetParamList()
{
SQLParamList temp = new SQLParamList();
if (WhereFields.Count() > 0)
{
temp.Add(WhereFields.GetParameterList("@W"));
}
if (HavingFields.Count() > 0)
{
temp.Add(HavingFields.GetParameterList("@H"));
}
return(temp);
}
public SQLParamList GetParamList()
{
SQLParamList temp = new SQLParamList();
if (WhereFields.Count() > 0)
{
temp.Add(WhereFields.GetParameterList("@W"));
}
if (Variables.Count() > 0)
{
temp.Add(Variables.GetParameterList("@U"));
}
return(temp);
}
public SQLParamList GetParameterList(string prefix = "@")
{
SQLParamList parlist = new SQLParamList();
foreach (var v in Variables)
{
parlist.Add(v.GetasParam(prefix));
}
return(parlist);
}
public List <SQLParamList> GetParams()
{
List <SQLParamList> temp = new List <SQLParamList>();
string[] fields = Fields.GetFieldNames().Split(',');
for (int index = 0; index < Values.Count; index++)
{
SQLParamList var = new SQLParamList();
for (int index2 = 0; index2 < fields.Length; index2++)
{
var.Add($"@{fields[index2].Trim()}", Values[index].GetFieldValues(index2).GetRawValue());
}
temp.Add(var);
}
return(temp);
}