private static void DoSubscribeRegister()
{
if (_isRedisInit && _serverTypeChange)
{
Task task1 = redisClient.SubscribeAsync(_PublisAll, SubscribeAsyncCallback);
Task task2 = null;
switch (_serverType)
{
case ServerType.GameServer:
task2 = redisClient.SubscribeAsync(_PublisGS, SubscribeAsyncCallback);
break;
case ServerType.LogonServer:
task2 = redisClient.SubscribeAsync(_PublisLS, SubscribeAsyncCallback);
break;
case ServerType.WebApiServer:
task2 = redisClient.SubscribeAsync(_PublisLS, SubscribeAsyncCallback);
break;
}
Task task3 = redisClient.SubscribeAsync(ServerUuidStr, SubscribeAsyncCallback);
if (task2 == null)
{
Task.WaitAll(task1, task3);
}
else
{
Task.WaitAll(task1, task2, task3);
}
QLSystemErrorProvide.OnQLSystemLogHandle("Redis 服务已重新连接");
ConnectInitCompleted?.Invoke(null, null);
}
}
/// <summary>
///
/// </summary>
/// <param name="sql"></param>
public void RunSql(string sql, out System.Data.DataSet dataSet)
{
try
{
QLDBHelper h = new QLDBHelper(ConnectionStringMain, DBEntityProvide);
h.RunSql(sql, out dataSet);
}
catch (Exception ex)
{
var tex = new Exception("执行SQL “" + sql + "”出现异常！", ex);
QLSystemErrorProvide.OnQLSystemErrorHandleEvent(null, tex);
dataSet = new DataSet();
}
}
/// <summary>
/// 执行存储过程，返回ReturnValue
/// </summary>
/// <param name="storedProcName"></param>
/// <param name="parameters"></param>
/// <param name="dataSet"></param>
/// <returns></returns>
public object RunProcedure(string storedProcName, IDataParameter[] parameters, out DataSet dataSet)
{
try
{
QLDBHelper h = new QLDBHelper(ConnectionStringMain, DBEntityProvide);
return(h.RunProcedure(storedProcName, parameters, out dataSet));
}
catch (Exception ex)
{
var tex = new Exception("调用存储过程“" + storedProcName + "”出现异常！", ex);
QLSystemErrorProvide.OnQLSystemErrorHandleEvent(null, tex);
dataSet = new DataSet();
return(-10000);
}
}
