From 1afe548ac40cc7f975917ef9bf2e156595cf81f3 Mon Sep 17 00:00:00 2001
From: alielie <alielie@git.com>
Date: 星期四, 16 四月 2026 08:58:04 +0800
Subject: [PATCH] 优化；
---
HMI.Core/Util/Sqlite3Helper.cs | 40 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 40 insertions(+), 0 deletions(-)
diff --git a/HMI.Core/Util/Sqlite3Helper.cs b/HMI.Core/Util/Sqlite3Helper.cs
index bc979d4..57fe091 100644
--- a/HMI.Core/Util/Sqlite3Helper.cs
+++ b/HMI.Core/Util/Sqlite3Helper.cs
@@ -52,6 +52,46 @@
}
}
+ public long InsertWithId(string Sql)
+ {
+ try
+ {
+ if (Sql.EndsWith(";"))
+ {
+ Sql += "SELECT last_insert_rowid();";
+ }
+ else
+ {
+ Sql += ";SELECT last_insert_rowid();";
+ }
+ using (var cmd = new SQLiteCommand(Sql, conn))
+ {
+ return (long)cmd.ExecuteScalar();
+ }
+ }
+ catch (Exception ex)
+ {
+ string message = "ExecuteSql Error:" + ex.Message;
+ throw new Exception(message);
+ }
+ }
+
+ public object SelectOne(string Sql)
+ {
+ try
+ {
+ using (var cmd = new SQLiteCommand(Sql, conn))
+ {
+ return cmd.ExecuteScalar();
+ }
+ }
+ catch (Exception ex)
+ {
+ string message = "ExecuteSql Error:" + ex.Message;
+ throw new Exception(message);
+ }
+ }
+
public int ExecuteBatch(IEnumerable<string> sqls)
{
SQLiteTransaction tr = null;
--
Gitblit v1.9.1