| | |
| | | namespace HH.WCS.Mobox3.DSZSH.util { |
| | | //https://www.donet5.com/Home/Doc |
| | | public class SqlHelper<T> where T : class, new() { |
| | | // NOTE:如果用Oracle数据库,需要包Oracle.ManagedDataAccess/21.15.0,环境netframework 4.6.2(太新了4.8有的服务器安装不上去) |
| | | |
| | | /// <summary> |
| | | /// 如果用Oracle数据需要包Oracle.ManagedDataAccess/21.15.0,环境netframework 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//从特性读取主键自增信息 |
| | | }); |
| | |
| | | |
| | | return db; |
| | | } |
| | | |
| | | } |
| | | |
| | | } |