From a5ddd51b4b01ddd2494fcde3cdb63da6819a8766 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Wed, 21 Dec 2022 16:42:07 +0800
Subject: Develop secret api. v55

---
 .../crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs   | 6 ++++++
 docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs  | 4 ++--
 2 files changed, 8 insertions(+), 2 deletions(-)

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

diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
index abae774..eab8567 100644
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
@@ -61,6 +61,12 @@ public class CrudService<TEntity> : IDisposable where TEntity : class
         return result;
     }
 
+    public int GetCount()
+    {
+        var result = _table.SelectCount(_dbConnection);
+        return result;
+    }
+
     public TEntity GetByKey(object key)
     {
         var result = _table.Select<TEntity>(_dbConnection, null, WhereClause.Create().Eq(_table.KeyColumn.ColumnName, key)).SingleOrDefault();
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs
index 62ebc4a..6a88ee1 100644
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs
@@ -436,8 +436,8 @@ CREATE TABLE {tableName}(
     public virtual int SelectCount(IDbConnection dbConnection, IWhereClause? where = null, IOrderByClause? orderBy = null, int? skip = null, int? limit = null)
     {
         var (sql, parameters) = GenerateSelectSql("COUNT(*)", where, orderBy, skip, limit);
-        return dbConnection.QuerySingle<int>(sql, parameters);
-
+        var result = dbConnection.QuerySingle<int>(sql, ConvertParameters(parameters));
+        return result;
     }
 
     public virtual TResult MapDynamicTo<TResult>(dynamic d)
-- 
cgit v1.2.3