public override string GetFullSelectSql(string select = null)
{
if (select == null)
{
select = SelectHelper.CreateSelectHeader(_headers, GetTypes());
}
if (select.TrimStart().StartsWith("SELECT ", StringComparison.OrdinalIgnoreCase) == false)
{
select = "SELECT " + select;
}
StringBuilder sb = new StringBuilder();
sb.Append(select);
sb.Append(" ");
sb.Append(GetFromAndJoinOn());
//sb.Append(_joinOnString);
if (_where.Length > 0)
{
sb.Append(" WHERE ");
sb.Append(_where);
}
return(sb.ToString());
}
private static string getSelect <T>(WhereHelperBase t, string selectSql)
{
if (string.IsNullOrEmpty(selectSql) == false)
{
if (selectSql.StartsWith("Select", StringComparison.CurrentCultureIgnoreCase))
{
return(selectSql);
}
return("SELECT " + selectSql);
}
return(SelectHelper.CreateSelectHeader(typeof(T), t._headers, t.GetTypes()));
}