From 7d5866a7658598466e33691f442f422e59577a34 Mon Sep 17 00:00:00 2001 From: crupest Date: Mon, 19 Dec 2022 12:39:37 +0800 Subject: Develop secret api. v44 --- .../CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs') diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs index 3147e99..a20963c 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs @@ -1,4 +1,5 @@ using System.Data; +using System.Diagnostics; using System.Reflection; using System.Text; using Dapper; @@ -438,6 +439,18 @@ CREATE TABLE {tableName}( return queryResult.Select(MapDynamicTo).ToList(); } + public IInsertClause ConvertEntityToInsertClause(object entity) + { + Debug.Assert(EntityType.IsInstanceOfType(entity)); + var result = new InsertClause(); + foreach (var column in PropertyColumns) + { + var value = column.PropertyInfo!.GetValue(entity); + result.Add(column.ColumnName, value); + } + return result; + } + /// /// Insert a entity and call hooks. /// @@ -504,6 +517,14 @@ CREATE TABLE {tableName}( return key ?? throw new Exception("No key???"); } + public object Insert(IDbConnection dbConnection, object entity) + { + Debug.Assert(EntityType.IsInstanceOfType(entity)); + var insert = ConvertEntityToInsertClause(entity); + return Insert(dbConnection, insert); + } + + /// /// Upgrade a entity and call hooks. /// -- cgit v1.2.3