private void ResultToTable(SqlCollection result)
{
if (result.Rows.Count == 0)
{
return;
}
foreach (SqlType field in result.Rows[0].Fields)
{
OutputTable.Add(new OutputColumn(field.Name));
}
for (int i = 0; i < result.Count; i++)
{
SqlObject obj = result.Rows[i];
for (int j = 0; j < obj.Fields.Count; j++)
{
if (obj.Fields[j].Type == typeof(bool) && obj.Fields[j].Name == "IsBusinessAccount")
{
OutputTable[j].Add((bool)obj.Fields[j].Value ? "Business" : "Normal");
}
else
{
OutputTable[j].Add(obj.Fields[j].FormatValue());
}
}
}
}
