public Select AddColumn(string table, string fieldName, string alias)
{
var f = new SelectListColumn(table, fieldName, alias);
AddColumn(f);
return(this);
}
public Select AddColumn(string fieldName)
{
var f = new SelectListColumn(fieldName);
AddColumn(f);
return(this);
}
public SelectListColumn(string column)
{
var f = SelectListColumn.Parse(column);
Table = f.Table;
Column = f.Column;
Alias = f.Alias;
}
public static SelectListColumn Parse(string sqlStatement)
{
var field = new SelectListColumn();
sqlStatement = sqlStatement?.ClearString() ?? throw new ArgumentNullException(nameof(sqlStatement));
if (sqlStatement.EndsWith(" AS", StringComparison.OrdinalIgnoreCase))
{
sqlStatement = sqlStatement.Substring(0, sqlStatement.Length - 3);
}
var indexOfAs = sqlStatement.ToUpper().IndexOf(" AS ", StringComparison.OrdinalIgnoreCase);
if (indexOfAs > 0)
{
field.Alias = sqlStatement.Substring(indexOfAs + 4).ClearString();
sqlStatement = sqlStatement.Substring(0, indexOfAs).ClearString();
}
if (sqlStatement.Contains("."))
{
var arr = sqlStatement.Split('.');
field.Table = arr[0].ClearString();
sqlStatement = arr[1].ClearString();
}
if (sqlStatement == "*")
{
field.Alias = null;
}
if (sqlStatement.Contains("::"))
{
var indexOfType = sqlStatement.IndexOf("::", StringComparison.OrdinalIgnoreCase);
field.Column = sqlStatement.Substring(0, indexOfType).ClearString();
}
else
{
field.Column = sqlStatement;
}
return(field);
}
public SelectList AddColumn(Column pgSqlColumn)
{
SelectListColumn col;
if (String.IsNullOrWhiteSpace(pgSqlColumn.DbName))
{
col = new SelectListColumn(pgSqlColumn.ClrName);
}
else
{
col = new SelectListColumn(pgSqlColumn.DbName, pgSqlColumn.ClrName);
}
col.DotnetType = pgSqlColumn.DotNetType;
AddColumn(col);
return(this);
}
public Select AddColumn(SelectListColumn field)
{
_selectList.AddColumn(field);
return(this);
}
public SelectList AddColumn(SelectListColumn field)
{
_selectListItems.Add(field);
return(this);
}
