From f357eefb805b0078588d97c72d3d8b047025b842 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Mon, 5 Dec 2022 20:28:58 +0800
Subject: Develop secret api. v10

---
 .../CrupestApi/CrupestApi.Commons/Crud/CrudService.cs            | 9 +++++++++
 1 file changed, 9 insertions(+)

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

diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
index acb05f8..f6bbb12 100644
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
@@ -53,4 +53,13 @@ public class CrudService<TEntity>
         }
         return connection;
     }
+
+
+    public virtual async Task<IEnumerable<TEntity>> QueryAsync(WhereClause? where = null, OrderByClause? orderBy = null, int? skip = null, int? limit = null)
+    {
+        var connection = await EnsureDatabase();
+        DynamicParameters parameters;
+        var sql = _table.GenerateSelectSql(where, orderBy, skip, limit, out parameters);
+        return await connection.QueryAsync<TEntity>(sql, parameters);
+    }
 }
-- 
cgit v1.2.3