/// <summary>
/// OrderBy
/// </summary>
/// <param name="expression">表达式树</param>
/// <param name="sqlWrapper">sql打包对象</param>
/// <param name="orders">排序方式</param>
/// <returns>SqlWrapper</returns>
public override SqlWrapper OrderBy(ConstantExpression expression, SqlWrapper sqlWrapper, params OrderType[] orders)
{
var tableName = sqlWrapper.GetTableName(sqlWrapper.DefaultType);
var tableAlias = sqlWrapper.GetTableAlias(tableName);
if (!tableAlias.IsNullOrEmpty())
{
tableAlias += ".";
}
var field = expression.Value.ToString();
if (!field.ToUpper().Contains(" ASC") && !field.ToUpper().Contains(" DESC"))
{
field = sqlWrapper.GetColumnName(field);
}
sqlWrapper += tableAlias + field;
if (orders?.Length > 0)
{
sqlWrapper += $" { (orders[0] == OrderType.Descending ? "DESC" : "ASC")}";
}
return(sqlWrapper);
}
/// <summary>
/// GroupBy
/// </summary>
/// <param name="expression">表达式树</param>
/// <param name="sqlWrapper">sql打包对象</param>
/// <returns>SqlWrapper</returns>
public override SqlWrapper GroupBy(ConstantExpression expression, SqlWrapper sqlWrapper)
{
var tableName = sqlWrapper.GetTableName(sqlWrapper.DefaultType);
var tableAlias = sqlWrapper.GetTableAlias(tableName);
if (!tableAlias.IsNullOrEmpty())
{
tableAlias += ".";
}
sqlWrapper += tableAlias + sqlWrapper.GetColumnName(expression.Value.ToString()) + ",";
return(sqlWrapper);
}
/// <summary>
/// Select
/// </summary>
/// <param name="expression">表达式树</param>
/// <param name="sqlWrapper">sql包装器</param>
/// <returns>SqlWrapper</returns>
public override SqlWrapper Select(MemberInitExpression expression, SqlWrapper sqlWrapper)
{
if (expression.Bindings?.Count > 0)
{
foreach (MemberAssignment memberAssignment in expression.Bindings)
{
if (memberAssignment.Expression is MemberExpression memberExpr && memberExpr.Expression is ParameterExpression parameterExpr)
{
var type = parameterExpr.Type;
var tableName = sqlWrapper.GetTableName(type);
var tableAlias = sqlWrapper.GetTableAlias(tableName, parameterExpr.Name);
if (tableAlias.IsNotNullOrEmpty())
{
tableAlias += ".";
}
var fieldName = tableAlias + sqlWrapper.GetColumnInfo(type, memberExpr.Member).ColumnName;
sqlWrapper.AddField(fieldName);
}
else
{
var fieldName = memberAssignment.Expression.ToObject().ToString();
sqlWrapper.AddField(fieldName);
}
var aliasName = sqlWrapper.GetColumnName(memberAssignment.Member.Name);
var field = sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1];
if (field.IsNotNullOrEmpty() && field.Contains(".") && !field.Contains("(", ")"))
{
field = field.Split('.').LastOrDefault();
}
if (!field.Equals(!sqlWrapper.IsEnableFormat, aliasName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {aliasName}";
}
}
/// <summary>
/// Select
/// </summary>
/// <param name="expression">表达式树</param>
/// <param name="sqlWrapper">sql包装器</param>
/// <returns>SqlWrapper</returns>
public override SqlWrapper Select(NewExpression expression, SqlWrapper sqlWrapper)
{
if (expression.Members != null)
{
for (var i = 0; i < expression.Members.Count; i++)
{
var argument = expression.Arguments[i];
SqlExpressionProvider.Select(argument, sqlWrapper);
var fieldName = sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1];
if (fieldName.IsNotNullOrEmpty() && fieldName.Contains(".") && !fieldName.Contains("(", ")"))
{
fieldName = fieldName.Split('.').LastOrDefault();
}
var memberName = sqlWrapper.GetColumnName(expression.Members[i].Name);
//添加字段别名
if (argument is MemberExpression memberExpression)
{
var agrumentName = sqlWrapper.GetColumnName(memberExpression.Member.Name);
if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, memberName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {memberName}";
}
else if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, fieldName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {agrumentName}";
}
}
else if (argument is ConstantExpression constantExpression)
{
var agrumentName = sqlWrapper.GetColumnName(constantExpression.Value?.ToString());
if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, memberName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {memberName}";
}
else if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, fieldName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {agrumentName}";
}
}
else if (argument is MethodCallExpression methodCallExpression)
{
var agrumentName = methodCallExpression.ToObject <string>(out var res);
if (!res)
{
agrumentName = sqlWrapper.SelectFields.LastOrDefault();
}
agrumentName = sqlWrapper.GetColumnName(agrumentName);
if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, memberName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {memberName}";
}
else if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, fieldName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {agrumentName}";
}
}
else if (argument is BinaryExpression binaryExpression)
{
var agrumentName = sqlWrapper.GetColumnName(binaryExpression.ToObject()?.ToString());
if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, memberName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {memberName}";
}
else if (!agrumentName.Equals(!sqlWrapper.IsEnableFormat, fieldName))
{
sqlWrapper.SelectFields[sqlWrapper.FieldCount - 1] += $" AS {agrumentName}";
}
}
}
}
else
{
sqlWrapper.AddField("*");
}
return(sqlWrapper);
}
