using System;
|
using System.Collections.Generic;
|
using System.Configuration;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using SqlSugar;
|
|
namespace IStation.DAL
|
{
|
internal class ConfigHelper
|
{
|
#region 默认连接
|
|
/// <summary>
|
/// 默认连接字符串
|
/// </summary>
|
public static string DefaultConnString
|
{
|
get
|
{
|
return Settings.Run.DataBase.ConnectString;
|
}
|
}
|
|
/// <summary>
|
/// 默认连接配置
|
/// </summary>
|
public static ConnectionConfig DefaultConnectionConfig
|
{
|
get
|
{
|
return new ConnectionConfig()
|
{
|
DbType = SqlSugar.DbType.PostgreSQL,//数据库类型
|
ConnectionString = DefaultConnString,
|
IsAutoCloseConnection = true,//是否自动关闭
|
MoreSettings = new ConnMoreSettings()
|
{
|
//PgSqlIsAutoToLower = false //数据库存在大写字段的 ，需要把这个设为false ，并且实体和字段名称要一样
|
},
|
AopEvents = new AopEvents
|
{
|
OnLogExecuting = (sql, p) =>
|
{
|
// Console.WriteLine(sql);
|
}
|
}
|
};
|
}
|
}
|
|
#endregion
|
|
|
#region 监测记录连接
|
|
/// <summary>
|
/// 监测记录连接字符串
|
/// </summary>
|
public static string MonitorRecordConnString
|
{
|
get
|
{
|
return Settings.Run.DataBase.MonitorRecordConnectString;
|
}
|
}
|
|
/// <summary>
|
/// 监测记录连接配置
|
/// </summary>
|
public static ConnectionConfig MonitorRecordConnectionConfig
|
{
|
get
|
{
|
return new ConnectionConfig()
|
{
|
DbType = SqlSugar.DbType.PostgreSQL,//数据库类型
|
ConnectionString = MonitorRecordConnString,
|
IsAutoCloseConnection = true,//是否自动关闭
|
MoreSettings = new ConnMoreSettings()
|
{
|
//PgSqlIsAutoToLower = false //数据库存在大写字段的 ，需要把这个设为false ，并且实体和字段名称要一样
|
},
|
AopEvents = new AopEvents
|
{
|
OnLogExecuting = (sql, p) =>
|
{
|
// Console.WriteLine(sql);
|
}
|
}
|
};
|
}
|
}
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
}
|
}
|
