From 74ca5a83f24c53c48ad7e6f5b7739649fb411546 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期四, 17 七月 2025 17:19:53 +0800
Subject: [PATCH] 优化部分日志和未使用代码
---
util/SqlHelper.cs | 17 ++++++++++-------
1 files changed, 10 insertions(+), 7 deletions(-)
diff --git a/util/SqlHelper.cs b/util/SqlHelper.cs
index f0f6028..f8327ed 100644
--- a/util/SqlHelper.cs
+++ b/util/SqlHelper.cs
@@ -6,20 +6,19 @@
namespace HH.WCS.Mobox3.DSZSH.util {
//https://www.donet5.com/Home/Doc
public class SqlHelper<T> where T : class, new() {
+ // NOTE锛氬鏋滅敤Oracle鏁版嵁搴擄紝闇�鍖匫racle.ManagedDataAccess/21.15.0锛岀幆澧僴etframework 4.6.2锛堝お鏂颁簡4.8鏈夌殑鏈嶅姟鍣ㄥ畨瑁呬笉涓婂幓锛�
- /// <summary>
- /// 濡傛灉鐢∣racle鏁版嵁闇�鍖匫racle.ManagedDataAccess/21.15.0锛岀幆澧僴etframework 4.62锛屽お鏂颁簡4.8鏈夌殑鏈嶅姟鍣ㄥ畨瑁呬笉涓婂幓
- /// </summary>
- /// <param name="url"></param>
- /// <returns></returns>
public SqlSugarClient GetInstance(string url = "") {
//鍒涘缓鏁版嵁搴撳璞� SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() {
ConnectionString = string.IsNullOrEmpty(url) ? Settings.SqlServer : url,
+
//ConnectionString = @"Data Source=192.168.1.198\sql2008;Initial Catalog=OIMobox;User ID=sa;Password=sa@2015",
DbType = DbType.SqlServer,
+
//ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OIMobox)));User Id=system;Password=Am123123;",
//DbType = DbType.Oracle,
+
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute//浠庣壒鎬ц鍙栦富閿嚜澧炰俊鎭� });
@@ -39,6 +38,12 @@
//鐩稿綋浜嶦F鐨�PrintToMiniProfiler
};
+ // 閰嶇疆AOP鏃ュ織
+ //db.Aop.OnLogExecuting = (sql, pars) =>
+ //{
+ // Console.WriteLine(sql); // 杈撳嚭绾疭QL璇彞
+ //};
+
//姣忔璁剧疆鏁板�鏃堕兘鍘婚櫎鍓嶅鍚庡绌烘牸
db.Aop.DataExecuted = (value, entity) => {
entity.EntityColumnInfos.ToList().ForEach(a => {
@@ -57,7 +62,5 @@
return db;
}
-
}
-
}
--
Gitblit v1.9.1