From f9aa02ec1a4c24e80a206857d4f68198bb027bb4 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Mon, 11 Nov 2024 01:12:29 +0800
Subject: HALF WORK: 2024.12.19

Re-organize file structure.
---
 .../CrupestApi.Commons/Crud/OrderByClause.cs       | 50 ++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/OrderByClause.cs

(limited to 'dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/OrderByClause.cs')

diff --git a/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/OrderByClause.cs b/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/OrderByClause.cs
new file mode 100644
index 0000000..734d044
--- /dev/null
+++ b/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/OrderByClause.cs
@@ -0,0 +1,50 @@
+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 interface IOrderByClause : IClause
+{
+    List<OrderByItem> Items { get; }
+    // Contains "ORDER BY" keyword!
+    string GenerateSql(string? dbProviderId = null);
+}
+
+public class OrderByClause : IOrderByClause
+{
+    public List<OrderByItem> Items { get; } = new List<OrderByItem>();
+
+    public OrderByClause(params OrderByItem[] items)
+    {
+        Items.AddRange(items);
+    }
+
+    public static OrderByClause Create(params OrderByItem[] items)
+    {
+        return new OrderByClause(items);
+    }
+
+    public List<string> GetRelatedColumns()
+    {
+        return Items.Select(x => x.ColumnName).ToList();
+    }
+
+    public string GenerateSql(string? dbProviderId = null)
+    {
+        return "ORDER BY " + string.Join(", ", Items.Select(i => i.GenerateSql()));
+    }
+}
-- 
cgit v1.2.3