public void OrderBy(string tableName, string fieldName, bool desc = false) { var order = Adapter.Field(tableName, fieldName); if (desc) { order += " DESC"; } OrderByList.Add(order); }
internal OrderByList ProcessOrderBy() { var list = new OrderByList(); if (!string.IsNullOrWhiteSpace(orderByClause)) { var orderByItems = orderByClause.Split(new [] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in orderByItems) { var parts = item.Split(new [] { " " }, StringSplitOptions.RemoveEmptyEntries); if (parts.Length == 1) list.Add(new OrderByNode(parts[0], Direction.Asc)); if (parts.Length == 2) { var direction = string.Equals(parts[1], "desc", StringComparison.OrdinalIgnoreCase) ? Direction.Desc : Direction.Asc; list.Add(new OrderByNode(parts[0], direction)); } } } return list; }