/// <summary>
/// 服务逻辑更新
/// </summary>
public void Update()
{
try
{
#region 协议处理
ClientProtocolDealManager.Instance.TransferRecvClientData(ref m_protocolList);
if (m_protocolList.Count > 0)
{
for (int i = 0; i < m_protocolList.Count; i++)
{
try
{
//ServerProtocolDealManager.Instance.ServerSend2ClientData(clientSessionID, protocolData);
}
catch (Exception ex)
{
SvLogger.Fatal(ex, string.Format("Param Proto Exception : {0}\r\nStackTrace : \r\n{1}", ex.Message, ex.StackTrace));
}
}
m_protocolList.Clear();
}
#endregion
#region 数据库回调处理
List <DbAccessPoolVistor> dapvistorlist = DbAccessPool.GetVistorList();
for (int i = 0; i < dapvistorlist.Count; i++)
{
DbAccessPoolVistor dapvistor = dapvistorlist[i];
int callbackNum = dapvistor.GetCallbackNum();
int doBackNum = 0;
int vStartTick = Environment.TickCount;
int doStartTick;
DateTime doStartTime;
while (doBackNum < callbackNum)
{
doStartTick = Environment.TickCount;
doStartTime = HTBaseFunc.GetTime(0);
DbAccessItem dbi = dapvistor.PopupCallback();
if (dbi != null)
{
dbi.OnFinish(dbi);
}
++doBackNum;
int doEndTick = Environment.TickCount;
int doSpendTicks = (doEndTick >= doStartTick ? doEndTick - doStartTick : (int.MaxValue + doEndTick) + (int.MaxValue - doStartTick));
if (doSpendTicks >= 1000)
{
SvLogger.Warn("Update TimeOut : DbAccessPoolCallback {0}, SpendMs = {1}, SpName = {2}, StartTime = {3}.", dapvistor.Flag, doSpendTicks, ((dbi != null) ? dbi.SpName : ""), doStartTime.ToString("yyyy-MM-dd HH:mm:ss.fff"));
}
int vSpendTicks = (doEndTick >= vStartTick ? doEndTick - vStartTick : doEndTick + (int.MaxValue - vStartTick));
if (vSpendTicks >= SvrCommCfg.Instance.DbAccessPoolCallbackDealInterval)
{
break;
}
}
}
#endregion
#region 定时打印服务器监控信息
m_svrCheckEndTicket = Environment.TickCount;
m_svrCheckSpendTicket = (m_svrCheckEndTicket >= m_svrCheckStartTicket ? m_svrCheckEndTicket - m_svrCheckStartTicket : (int.MaxValue + m_svrCheckEndTicket) + (int.MaxValue - m_svrCheckStartTicket));
if (m_svrCheckSpendTicket >= 60000)
{
m_svrCheckStartTicket = m_svrCheckEndTicket;
ServerCommon.DbAccess.Instance.ShowDBAccCountInPool();
}
#endregion
#region 内存回收
if (m_lastMemoryCheck.AddSeconds(30) < HTBaseFunc.GetTime(0))
{
if (m_lastGcTime.AddSeconds(30) < HTBaseFunc.GetTime(0) && System.Diagnostics.Process.GetCurrentProcess().WorkingSet64 > 128 * 1024 * 1024)
{
GC.Collect();
m_lastGcTime = HTBaseFunc.GetTime(0);
}
m_lastMemoryCheck = HTBaseFunc.GetTime(0);
}
#endregion
}
catch (Exception ex)
{
SvLogger.Fatal(ex, string.Format("Main Logic Exception : {0}\r\nStackTrace : \r\n{1}", ex.Message, ex.StackTrace));
}
}
/// <summary>
/// 初始化数据库连接
/// </summary>
/// <param name="dbConnFlag">连接名</param>
/// <param name="serverType">数据库类型</param>
/// <param name="serverIp">数据库服务器名</param>
/// <param name="serverPort">数据库端口</param>
/// <param name="databaseName">数据库名</param>
/// <param name="userName">数据库用户名</param>
/// <param name="userPass">数据库用户密码</param>
/// <param name="childConnCount">子连接个数</param>
/// <returns>返回错误信息</returns>
public int InitilizeDbConn(eDbConnFlag dbConnFlag, string serverType, string serverIp, string serverPort, string databaseName, string userName, string userPass, int childConnCount)
{
int errCode = 0;
//最终Connect Flag生成
m_connFlagMakeLines[dbConnFlag] += 1;
int lineIndex = Convert.ToInt32(m_connFlagMakeLines[dbConnFlag]);
int connFlag = Convert.ToInt32(dbConnFlag) | lineIndex;
DbAccessPool dapool = DbAccessPool.GetPool(connFlag);
if (dapool != null)
{
errCode = 1111;
SvLogger.Error("Had Same DB Connections : ConnectType={0}, ConnectFlag={1}.", dbConnFlag, connFlag);
return(errCode);
}
//获取SQL日志记录池
DbAccessPool sqlogdapool = null;
//if (dbConnFlag != eDbConnFlag.SqlLog)
// sqlogdapool = DbAccessPool.GetPool(EnumDbConnName.SqlLog.ToString());
//建立数据库连接
DbAccessPoolVistor vistor = new DbAccessPoolVistor(connFlag);
dapool = new DbAccessPool(connFlag, SvLogger.GetLogger(), vistor, sqlogdapool);
try
{
dapool.Start(serverType, serverIp, serverPort, databaseName, userName, userPass);
}
catch (Exception ex)
{
SvLogger.Fatal(ex, "{0}\n{1}.", ex.Message, ex.StackTrace);
errCode = 1111;
return(errCode);
}
int mainFlag = dapool.Flag;
if (dbConnFlag == eDbConnFlag.Game)
{
m_gameDBMainConnFlagList.Add(dapool.Flag);
}
else if (dbConnFlag == eDbConnFlag.Log)
{
m_logDbAccPool = dapool;
}
else if (dbConnFlag == eDbConnFlag.Secd)
{
m_secdDbAccPool = dapool;
}
else if (dbConnFlag == eDbConnFlag.GM)
{
m_gmDBAccPool = dapool;
}
else if (dbConnFlag == eDbConnFlag.Platform)
{
m_platformDBAccPool = dapool;
}
else if (dbConnFlag == eDbConnFlag.Moniteor)
{
m_moniteorDBAccPool = dapool;
}
else if (dbConnFlag == eDbConnFlag.Entry)
{
m_entryDBAccPool = dapool;
}
else if (dbConnFlag == eDbConnFlag.GiftCode)
{
m_giftCodeDBAccPool = dapool;
}
//加入池
DbAccessPool.AddPool(dapool);
//Game数据库子连接建立
if (dbConnFlag == eDbConnFlag.Game)
{
for (int i = 0; i < childConnCount; ++i)
{
//最终Connect Flag生成
m_connFlagMakeLines[dbConnFlag] += 1;
lineIndex = Convert.ToInt32(m_connFlagMakeLines[dbConnFlag]);
connFlag = Convert.ToInt32(dbConnFlag) | lineIndex;
dapool = DbAccessPool.GetPool(connFlag);
if (dapool != null)
{
errCode = 1111;
SvLogger.Error("Had Same DB Connections : ConnectType={0}, ConnectFlag={1}.", dbConnFlag, connFlag);
return(errCode);
}
//获取SQL日志记录池
sqlogdapool = null;
//if (dbConnFlag != eDbConnFlag.SqlLog)
// sqlogdapool = DbAccessPool.GetPool(EnumDbConnName.SqlLog.ToString());
//建立数据库连接
vistor = new DbAccessPoolVistor(connFlag);
dapool = new DbAccessPool(connFlag, SvLogger.GetLogger(), vistor, sqlogdapool);
try
{
dapool.Start(serverType, serverIp, serverPort, databaseName, userName, userPass);
}
catch (Exception ex)
{
SvLogger.Fatal(ex, "{0}\n{1}.", ex.Message, ex.StackTrace);
errCode = 1111;
return(errCode);
}
List <int> childList;
if (m_gameDBChildConnFlagDic.TryGetValue(mainFlag, out childList) == false)
{
childList = new List <int>();
m_gameDBChildConnFlagDic.Add(mainFlag, childList);
}
childList.Add(dapool.Flag);
//加入池
DbAccessPool.AddPool(dapool);
}
}
return(errCode);
}
