public static SqlSugarClient GetInstance()
{
var db = new SqlSugarClient(
new ConnectionConfig()
{
ConnectionString = Config.GetConfig().SqlString2, // "Data Source=47.107.186.141;Initial Catalog=db;User ID=sa;Password=jiangxinji.123",
DbType = DbType.MySql, //设置数据库类型
IsAutoCloseConnection = true, //自动释放数据务，如果存在事务，在事务结束后释放
InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息
});
var mq = new RabbitMQDomain();
db.Aop.OnLogExecuted = (sql, pars) => //SQL执行完事件
{
foreach (var p in pars)
{
string s = "";
if (p.DbType == System.Data.DbType.String)
{
s = $"\'{p.Value}\'";
}
else if (p.DbType == System.Data.DbType.DateTime || p.DbType == System.Data.DbType.Date || p.DbType == System.Data.DbType.DateTime2)
{
if (string.IsNullOrEmpty(Convert.ToString(p.Value)))
{
s = $"\'{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}\'";
}
else
{
var dt = Convert.ToDateTime(p.Value);
s = $"\'{dt.ToString("yyyy-MM-dd HH:mm:ss")}\'";
}
}
else
{
s = Convert.ToString(p.Value);
}
if (string.IsNullOrEmpty(s))
{
s = "\'\'";
}
sql = sql.Replace(p.ParameterName, s);
}
mq.Producter(sql);
};
try
{
db.Open();
}
catch
{
db = GetInstance2();
}
return(db);
}
public static SqlSugarClient GetInstance()
{
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = ConnectionString,
DbType = DbType.MySql,
IsAutoCloseConnection = false,
InitKeyType = InitKeyType.Attribute
});
db.Open();
return(db);
}
/// <summary>
/// 连接状态
/// </summary>
public static bool OnlineState()
{
try
{
sqlSugarClient.Open();
sqlSugarClient.Close();
return(true);
}
catch (Exception ex)
{
_logger.Error("连接数据库失败", ex);
return(false);
}
}
public OleExec(string strConn)
{
_connStr = strConn;
//_conn = new OleDbConnection(_connStr);
//_conn.Open();
//_comm = new OleDbCommand();
//_adp = new OleDbDataAdapter(_comm);
db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = _connStr,
DbType = SqlSugar.DbType.Oracle,
IsAutoCloseConnection = false,
InitKeyType = InitKeyType.Attribute
});
db.Open();
}
/**
* 建立連線
*/
public bool Connect()
{
bool ret = false;
try
{
// 建立連線
sql.Open();
ret = true;
SaveLog($"[Info] Connect Data Base Success");
}
catch (Exception ex)
{
SaveLog($"[Error] DataBaseConnect::Connect, Connect Data Base Fail, Catch Msg: {ex.Message}");
}
return(ret);
}
/**
* 建立連線
*/
public bool Connect()
{
bool bReturn = false;
try
{
// 建立連線
sql.Open();
bReturn = true;
log.SaveLog("Connect SQL Success");
}
catch (Exception ex)
{
log.SaveLog("[Error] DataBaseConnect::Connect SQL Connect Fail, Error Msg:" + ex.Message);
}
return bReturn;
}
private static void SqlSugarClient()
{
//Create db
Console.WriteLine("#### SqlSugarClient Start ####");
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
DbType = DbType.Kdbndp,
ConnectionString = Config.ConnectionString,
InitKeyType = InitKeyType.Attribute,
IsAutoCloseConnection = true,
AopEvents = new AopEvents
{
OnLogExecuting = (sql, p) =>
{
Console.WriteLine(sql);
Console.WriteLine(string.Join(",", p?.Select(it => it.ParameterName + ":" + it.Value)));
}
}
});
db.Open();
//If no exist create datebase
db.DbMaintenance.CreateDatabase();
//Use db query
var dt = db.Ado.GetDataTable("select 1");
//Create tables
db.CodeFirst.InitTables(typeof(OrderItem), typeof(Order));
var id = db.Insertable(new Order()
{
Name = "order1", CustomId = 1, Price = 0, CreateTime = DateTime.Now
}).ExecuteReturnIdentity();
//Insert data
db.Insertable(new OrderItem()
{
OrderId = id, Price = 0, CreateTime = DateTime.Now
}).ExecuteCommand();
Console.WriteLine("#### SqlSugarClient End ####");
}
public override bool ValidConnection()
{
string dbConnStr = $"Data Source={this.server}/{this.dataBase};User ID={this.userName};Password={this.password};";
try
{
SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = dbConnStr,
DbType = DbType.Oracle,
IsAutoCloseConnection = true,
//设为true，表示相同线程是同一个SqlSugarClient
IsShardSameThread = true
});
Db.Open();
return(true);
}
catch (Exception ex)
{
throw new BusinessException((int)EnumSystemStatusCode.DME_ERROR, "数据库验证失败，详情：" + ex.Message);
}
}
