Example #1
0
 protected override object GetMetaValue(string key)
 {
     if (!columns.ContainsKey(key.ToLower()))
     {
         columns.Add(key.ToLower(), LinqDLRColumn.New <TLinqDLRColumn>($"{(BelongToTable==""?"":BelongToTable+".")}{key}", this));
     }
     return(columns[key.ToLower()]);
 }
Example #2
0
        public CustomTable Select(Func <dynamic, object> q)
        {
            var c = q.Invoke(this);

            if (c is CustomTable)
            {
                SelectString = $"{AliasName}.*";
            }
            else if (c is LinqDLRColumn)
            {
                SelectString = $"{AliasName}.{((LinqDLRColumn)c).Name}";
            }
            else if (c is string)
            {
                SelectString = ComFunc.nvl(c);
            }
            else
            {
                var fields = c.GetType().GetTypeInfo().GetFields(BindingFlags.CreateInstance | BindingFlags.Public);
                if (fields.Length <= 0)
                {
                    SelectString = $"{AliasName}.*";
                }
                else
                {
                    foreach (var f in fields)
                    {
                        if (f.FieldType == typeof(LinqDLRColumn))
                        {
                            LinqDLRColumn s = (LinqDLRColumn)f.GetValue(c);
                            SelectString += $",{s.ToString()} AS {f.Name}";
                        }
                        else
                        {
                            SelectString += $",{f.Name}";
                        }
                    }
                    SelectString = SelectString.Substring(1);
                }
            }

            SQL = $"SELECT {SelectString} FROM {TableName}";
            if (AliasName != TableName)
            {
                SQL += $" {AliasName}";
            }
            if (!string.IsNullOrEmpty(Conditions))
            {
                SQL += $" WHERE {Conditions}";
            }
            if (!string.IsNullOrEmpty(OrderByString))
            {
                SQL += $" ORDER BY {OrderByString}";
            }
            return(this);
        }