docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/OrderByClause.cs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

namespace CrupestApi.Commons.Crud;

public class OrderByItem
{
    public OrderByItem(string columnName, bool isAscending)
    {
        ColumnName = columnName;
        IsAscending = isAscending;
    }

    public string ColumnName { get; }
    public bool IsAscending { get; }

    public string GenerateSql()
    {
        return $"{ColumnName} {(IsAscending ? "ASC" : "DESC")}";
    }
}

public class OrderByClause : List<OrderByItem>
{
    public OrderByClause(IEnumerable<OrderByItem> items)
        : base(items)
    {
    }

    public OrderByClause(params OrderByItem[] items)
        : base(items)
    {
    }

    public static OrderByClause Create(params OrderByItem[] items)
    {
        return new OrderByClause(items);
    }

    public string GenerateSql()
    {
        return "ORDER BY " + string.Join(", ", this.Select(i => i.GenerateSql()));
    }
}