Ejemplo n.º 1
0
        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()));
 }