From 0ed390381862dea0c7fd0210d16017eb09f12da4 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期三, 30 七月 2025 17:27:27 +0800
Subject: [PATCH] 封装插入容器表等业务代码, 修复部分底层旧框架方法问题
---
util/SqlHelper.cs | 41 +++++++++++++++++------------------------
1 files changed, 17 insertions(+), 24 deletions(-)
diff --git a/util/SqlHelper.cs b/util/SqlHelper.cs
index e59332d..ebe702b 100644
--- a/util/SqlHelper.cs
+++ b/util/SqlHelper.cs
@@ -1,28 +1,22 @@
锘縰sing System;
+using System.Collections.Generic;
using System.Linq;
-
+using System.Linq.Expressions;
using SqlSugar;
namespace HH.WCS.Mobox3.DSZSH.util {
- //https://www.donet5.com/Home/Doc
+ //DOC:https://www.donet5.com/Home/Doc
+ //NOTE:濡傛灉鐢∣racle鏁版嵁搴�闇�鍖匫racle.ManagedDataAccess/21.15.0,鐜netframework/4.6.2(澶柊浜�.8,鏈夌殑鏈嶅姟鍣ㄥ畨瑁呬笉涓婂幓)
+ //NOTE:SqlHelper甯鐨勫師鍥�鏄棫妗嗘灦缂栧啓浜哷Update(T model, string[] cols)`绛変唬鐮�鍙傝�HH-0014_NongFu_QingXi 鍐滃か闈掓邯)
public class SqlHelper<T> where T : class, new() {
- // NOTE:濡傛灉鐢∣racle鏁版嵁搴�闇�鍖匫racle.ManagedDataAccess/21.15.0,鐜netframework 4.6.2 (澶柊浜�.8鏈夌殑鏈嶅姟鍣ㄥ畨瑁呬笉涓婂幓)
-
- public SqlSugarClient GetInstance(string url = "") {
+ public SqlSugarClient GetInstance() {
//鍒涘缓鏁版嵁搴撳璞� 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,
-
+ ConnectionString = Settings.DbConn,
+ DbType = Settings.DbType,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute//浠庣壒鎬ц鍙栦富閿嚜澧炰俊鎭� });
-
//鐩戞帶鎵�湁瓒呰繃1绉掔殑Sql
db.Aop.OnLogExecuted = (sql, p) => {
//鎵ц鏃堕棿瓒呰繃1绉�@@ -37,13 +31,11 @@
}
//鐩稿綋浜嶦F鐨�PrintToMiniProfiler
};
-
- // 閰嶇疆AOP鏃ュ織
+ //閰嶇疆AOP鏃ュ織
//db.Aop.OnLogExecuting = (sql, pars) =>
//{
- // Console.WriteLine(sql); // 杈撳嚭绾疭QL璇彞
+ // Console.WriteLine(sql);//杈撳嚭绾疭QL璇彞
//};
-
//姣忔璁剧疆鏁板�鏃堕兘鍘婚櫎鍓嶅鍚庡绌烘牸
db.Aop.DataExecuted = (value, entity) => {
entity.EntityColumnInfos.ToList().ForEach(a => {
@@ -53,13 +45,14 @@
}
});
};
-
- //鎹浆鎹�(ExecuteCommand鎵嶄細鎷︽埅,鏌ヨ涓嶈)
- //db.Aop.DataExecuting = (value, entity) => {
- // //var val=entity.EntityColumnInfo
- // Console.WriteLine(entity.EntityName);
+ //璁剧疆AOP涓殑浜嬩欢澶勭悊绋嬪簭
+ //db.Aop.OnExecutingChangeSql = (sql, p) => {
+ // // 绀轰緥锛氳嚜鍔ㄨ繃婊よ蒋鍒犻櫎鏁版嵁
+ // if (sql.StartsWith("SELECT")) {
+ // sql += " WHERE IsDeleted = 0";
+ // }
+ // return new KeyValuePair<string, SugarParameter[]>(sql, p);
//};
-
return db;
}
}
--
Gitblit v1.9.1