diff options
author | crupest <crupest@outlook.com> | 2022-12-08 14:52:58 +0800 |
---|---|---|
committer | crupest <crupest@outlook.com> | 2022-12-20 20:32:52 +0800 |
commit | 62c92f97358e2a98271aaf11fdd5626e21cf4689 (patch) | |
tree | 2ac7a1f7f8492876a3b245959ef68f92f8dec0ae /docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs | |
parent | 78396f289ab50ce414bd8f65af8854ffb52fff48 (diff) | |
download | crupest-62c92f97358e2a98271aaf11fdd5626e21cf4689.tar.gz crupest-62c92f97358e2a98271aaf11fdd5626e21cf4689.tar.bz2 crupest-62c92f97358e2a98271aaf11fdd5626e21cf4689.zip |
Develop secret api. v18
Diffstat (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs')
-rw-r--r-- | docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs | 15 |
1 files changed, 11 insertions, 4 deletions
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs index 7cb5edf..b9cafee 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs @@ -15,8 +15,13 @@ public class UpdateItem public object? Value { get; set; } } -// TODO: Continue... -public class UpdateClause +public interface IUpdateClause : IClause +{ + List<UpdateItem> Items { get; } + (string sql, DynamicParameters parameters) GenerateSql(); +} + +public class UpdateClause : IUpdateClause { public List<UpdateItem> Items { get; } = new List<UpdateItem>(); @@ -51,8 +56,10 @@ public class UpdateClause return Items.Select(i => i.ColumnName).ToList(); } - public string GenerateSql(DynamicParameters parameters) + public (string sql, DynamicParameters parameters) GenerateSql() { + var parameters = new DynamicParameters(); + StringBuilder result = new StringBuilder(); foreach (var item in Items) @@ -66,6 +73,6 @@ public class UpdateClause result.Append($"{item.ColumnName} = @{parameterName}"); } - return result.ToString(); + return (result.ToString(), parameters); } } |