From 21e28b068c8d0763a6d4ab613388a77a0db157fb Mon Sep 17 00:00:00 2001
From: alielie <alielie@git.com>
Date: 星期一, 03 三月 2025 19:01:30 +0800
Subject: [PATCH] 优化结构；
---
HMI.MenuManage/Model/UserManageModel.cs | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/HMI.MenuManage/Model/UserManageModel.cs b/HMI.MenuManage/Model/UserManageModel.cs
index a2ede62..42fafc2 100644
--- a/HMI.MenuManage/Model/UserManageModel.cs
+++ b/HMI.MenuManage/Model/UserManageModel.cs
@@ -94,5 +94,24 @@
{
UserRoleRelHelper.SaveUserRoleRel(sqliteHelper, Roles, SelectedUser, null, null);
}
+
+ public void DeleteUserByUsername(string username)
+ {
+ sqliteHelper.ExecuteBatchSql(new List<string> {
+ $"DELETE FROM user WHERE username = '{username}';",
+ $"DELETE FROM user_role_rel WHERE username = '{username}';"
+ });
+ }
+
+ public void DeleteUserByUsernames(IEnumerable<string> usernames)
+ {
+ List<string> sqls = new List<string>();
+ foreach (string username in usernames)
+ {
+ sqls.Add($"DELETE FROM user WHERE username = '{username}';");
+ sqls.Add($"DELETE FROM user_role_rel WHERE username = '{username}';");
+ }
+ sqliteHelper.ExecuteBatchSql(sqls);
+ }
}
}
--
Gitblit v1.9.1