public void Add(SQLParamList pars)
{
foreach (var p in pars.GetParameters())
{
Parameters.Add(p);
}
}
public SQLParamList GetParameterList(string prefix = "@")
{
SQLParamList parlist = new SQLParamList();
foreach (var v in Variables)
{
parlist.Add(v.GetasParam(prefix));
}
return(parlist);
}
public SQLParamList GetParamList()
{
SQLParamList temp = new SQLParamList();
if (WhereFields.Count() > 0)
{
temp.Add(WhereFields.GetParameterList());
}
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 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);
}
public SQLParamList(SQLParamList parameters)
{
Parameters = parameters.GetParameters();
}
