/// <summary> /// GroupBy /// </summary> /// <param name="expression">表达式树</param> /// <param name="sqlPack">sql打包对象</param> /// <returns>SqlPack</returns> public override SqlPack GroupBy(NewArrayExpression expression, SqlPack sqlPack) { for (var i = 0; i < expression.Expressions.Count; i++) { SqlBuilderProvider.GroupBy(expression.Expressions[i], sqlPack); } sqlPack.Sql.Remove(sqlPack.Length - 1, 1); return(sqlPack); }
/// <summary> /// GroupBy /// </summary> /// <param name="expression">表达式树</param> /// <param name="sqlPack">sql打包对象</param> /// <returns>SqlPack</returns> public override SqlPack GroupBy(NewExpression expression, SqlPack sqlPack) { foreach (Expression item in expression.Arguments) { SqlBuilderProvider.GroupBy(item, sqlPack); } sqlPack.Sql.Remove(sqlPack.Length - 1, 1); return(sqlPack); }
/// <summary> /// GroupBy /// </summary> /// <param name="expression">表达式树</param> /// <param name="sqlPack">sql打包对象</param> /// <returns>SqlPack</returns> public override SqlPack GroupBy(MemberExpression expression, SqlPack sqlPack) { string tableName = string.Empty; if (expression.Expression.NodeType == ExpressionType.Parameter) { var type = expression.Expression.Type != expression.Member.DeclaringType ? expression.Expression.Type : expression.Member.DeclaringType; tableName = sqlPack.GetTableName(type); } if (expression.Expression.NodeType == ExpressionType.Constant) { tableName = sqlPack.GetTableName(sqlPack.DefaultType); } sqlPack.SetTableAlias(tableName); var tableAlias = sqlPack.GetTableAlias(tableName); if (!tableAlias.IsNullOrEmpty()) { tableAlias += "."; } if (expression.Expression.NodeType == ExpressionType.Parameter) { sqlPack += tableAlias + sqlPack.GetColumnInfo(expression.Member.DeclaringType, expression.Member).columnName; } if (expression.Expression.NodeType == ExpressionType.Constant) { var obj = expression.ToObject(); if (obj != null) { var type = obj.GetType().Name; if (type == "String[]" && obj is string[] array) { foreach (var item in array) { SqlBuilderProvider.GroupBy(Expression.Constant(item, item.GetType()), sqlPack); } sqlPack.Sql.Remove(sqlPack.Length - 1, 1); } if (type == "List`1" && obj is List <string> list) { foreach (var item in list) { SqlBuilderProvider.GroupBy(Expression.Constant(item, item.GetType()), sqlPack); } sqlPack.Sql.Remove(sqlPack.Length - 1, 1); } if (type == "String" && obj is string str) { SqlBuilderProvider.GroupBy(Expression.Constant(str, str.GetType()), sqlPack); sqlPack.Sql.Remove(sqlPack.Length - 1, 1); } } } return(sqlPack); }
/// <summary> /// GroupBy /// </summary> /// <param name="expression">表达式树</param> /// <param name="sqlPack">sql打包对象</param> /// <returns>SqlPack</returns> public override SqlPack GroupBy(ListInitExpression expression, SqlPack sqlPack) { var array = (expression.ToObject() as IEnumerable <object>)?.ToList(); if (array != null) { for (var i = 0; i < array.Count; i++) { SqlBuilderProvider.GroupBy(Expression.Constant(array[i], array[i].GetType()), sqlPack); } sqlPack.Sql.Remove(sqlPack.Length - 1, 1); } return(sqlPack); }
/// <summary> /// GroupBy /// </summary> /// <param name="expression">表达式树</param> /// <param name="sqlPack">sql打包对象</param> /// <returns>SqlPack</returns> public override SqlPack GroupBy(UnaryExpression expression, SqlPack sqlPack) { SqlBuilderProvider.GroupBy(expression.Operand, sqlPack); return(sqlPack); }
/// <summary> /// GroupBy /// </summary> /// <param name="expression">表达式树</param> /// <returns>SqlBuilderCore</returns> public SqlBuilderCore <T> GroupBy(Expression <Func <T, object> > expression) { this._sqlPack += " GROUP BY "; SqlBuilderProvider.GroupBy(expression.Body, this._sqlPack); return(this); }