From 8243498d2a201616239c6f4c48fa68737175978c Mon Sep 17 00:00:00 2001 From: crupest Date: Sun, 11 Dec 2022 11:12:29 +0800 Subject: Develop secret api. v27 --- .../crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs') diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs index 7f248cf..7645b09 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs @@ -1,10 +1,12 @@ using System.Text; -using Dapper; namespace CrupestApi.Commons.Crud; public class InsertItem { + /// + /// Null means use default value. Use . + /// public InsertItem(string columnName, object? value) { ColumnName = columnName; @@ -54,7 +56,7 @@ public class InsertClause : IInsertClause public string GenerateColumnListSql(string? dbProviderId = null) { - return string.Join(", ", Items.Select(i => i.ColumnName)); + return string.Join(", ", Items.Where(i => i.Value is not null).Select(i => i.ColumnName)); } public (string sql, ParamList parameters) GenerateValueListSql(string? dbProviderId = null) @@ -64,6 +66,7 @@ public class InsertClause : IInsertClause for (var i = 0; i < Items.Count; i++) { var item = Items[i]; + if (item.Value is null) continue; var parameterName = parameters.AddRandomNameParameter(item.Value, item.ColumnName); sb.Append($"@{parameterName}"); if (i != Items.Count - 1) -- cgit v1.2.3