protected internal void whereNotIn(LambdaExpression field, ICollection args) { if (jump()) { return; } var column = SqlExpression.GetColumnName(field); if (_where.Length > 0) { _where.Append(" AND "); } if (args.Count == 0) { _where.Append("1=1"); return; } _where.Append(column); if (args.Count == 1) { _where.Append(" <> "); _where.Append(_paramPrefix); _where.Append(_args.Count.ToString()); return; } else { _where.Append(" NOT IN ("); for (int i = 0; i < args.Count; i++) { if (i > 0) { _where.Append(","); } _where.Append(_paramPrefix); _where.Append((_args.Count + i).ToString()); } _where.Append(")"); } foreach (var item in args) { _args.Add(item); } }
protected internal void groupBy(LambdaExpression group) { if (jump()) { return; } var column = SqlExpression.GetColumnName(group); this.groupBy(column); }
protected internal void orderBy(LambdaExpression order, OrderType type) { if (jump()) { return; } var column = SqlExpression.GetColumnName(order); if (type == OrderType.Asc) { orderBySql(column + " ASC"); } else { orderBySql(column + " DESC"); } }