protected override SqlCaluse Select(ParameterExpression exp, SqlCaluse sqlCaluse) { var t = exp.Type; var props = t.GetProperties(); sqlCaluse.SetTableAlias(t); var alia = sqlCaluse.GetTableAlias(t); foreach (PropertyInfo item in props) { if (item.GetAttribute <IgnoreAttribute>() != null) { continue; } var col = item.GetAttribute <ColumnNameAttribute>(); if (col == null) { sqlCaluse.SelectFields.Add($"{alia}{item.Name}"); } else { sqlCaluse.SelectFields.Add($"{alia}{col.Name} {item.Name}"); } } return(sqlCaluse); }
private string CustomHandle(MemberExpression exp, SqlCaluse sqlCaluse, bool aliaRequest = true) { var table = exp.Member.DeclaringType; sqlCaluse.SetTableAlias(table); var alias = sqlCaluse.GetTableAlias(table); var attr = exp.Member.GetAttribute <ColumnNameAttribute>(); if (attr != null) { if (aliaRequest) { return($"{alias}{attr.Name} {exp.Member.Name}"); } else { return($"{alias}{attr.Name}"); } } else { return($"{alias}{exp.Member.Name}"); } }