/// <summary>
/// 获取指定活动ID和用户名的用户信息
/// </summary>
/// <param name="playId">活动ID</param>
/// <param name="userName">用户名</param>
/// <returns></returns>
public RemotingInterface.UserInfo GetUserInfo(int playId, string userName)
{
RemotingInterface.UserInfo userInfo = new RemotingInterface.UserInfo();
userInfo.Clear();
try
{
if (playId <= 0 || userName == string.Empty)
return userInfo;
Dictionary<int, Dictionary<string, RemotingInterface.UserInfo>> mapTempUser = null;
lock (mapUser)
{
mapTempUser = new Dictionary<int, Dictionary<string, RemotingInterface.UserInfo>>(mapUser);
}
if (mapTempUser == null)
return userInfo;
foreach (KeyValuePair<int, Dictionary<string, RemotingInterface.UserInfo>> amap in mapTempUser)
{
foreach (KeyValuePair<string, RemotingInterface.UserInfo> umap in amap.Value)
{
if (playId == umap.Value.PlayId && userName == umap.Value.UserPassPortId) //找到与指定PlayId和UserName对应的用户，直接返回
return umap.Value;
}
}
return userInfo;
}
catch (Exception err)
{
Loger.Debug("GetUserInfo error :" + err.ToString());
return userInfo;
}
}
public bool RequestNewUser(string strRemoteKey, RemotingInterface.UserInfo userInfo)
{
try
{
if (BaseConfig.bAllowReg == false)
{
return(false);
}
if (userInfo.AreaId <= 0 || userInfo.UserPassPortId.Length <= 0)
{
Loger.Debug("userInfo areaId or UserPassPortId error ");
return(false);
}
if (IsExistUser(userInfo.PlayId, userInfo.UserPassPortId))
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": 用户 [ " + userInfo.UserPassPortId + " ] 已经存在");
return(false);
}
bool bRet = Common.DBSync.AddNewUser(userInfo);
return(bRet);
}
catch
{
return(false);
}
}
public bool RemoveUserInfo(RemotingInterface.UserInfo userInfo)
{
try
{
if (userInfo.AreaId <= 0)
{
return(false);
}
if (string.IsNullOrEmpty(userInfo.UserPassPortId))
{
return(false);
}
lock (mapUser)
{
if (mapUser.ContainsKey(userInfo.AreaId))
{
if (mapUser[userInfo.AreaId].ContainsKey(userInfo.UserPassPortId))
{
mapUser[userInfo.AreaId].Remove(userInfo.UserPassPortId);
Loger.Debug(" remove cache success , userName = "******"remove user error : userName = "******" error : " + err.ToString());
return(false);
}
}
/// <summary>
/// 从数据库中移除用户
/// </summary>
/// <param name="userId"></param>
private void RemoveDBFailUser(RemotingInterface.UserInfo userInfo)
{
SqlConnection DelConn = new SqlConnection(BaseConfig.ConnStr);
try
{
if (DelConn.State == ConnectionState.Closed)
{
DelConn.Open();
}
SqlCommand sqlCmdDel = new SqlCommand("DELETE FROM [UserList" + BaseConfig.PlayId + "] WHERE UserId = @UserId", sqlConn);
sqlCmdDel.Parameters.Add("@UserId", SqlDbType.Int);
sqlCmdDel.Parameters["@UserId"].Value = userInfo.UserId;
sqlCmdDel.ExecuteNonQuery();
Loger.Debug(" Remove userId = :" + userInfo.UserId);
Common.userBuffer.RemoveUserInfo(userInfo);
}
catch (Exception err)
{
Loger.Debug("RemoveDBFailUser :userId =" + userInfo.UserId + "\t" + err.ToString());
}
finally
{
if (DelConn.State != ConnectionState.Closed)
{
DelConn.Close();
}
}
}
public bool ChangeNickName(RemotingInterface.UserInfo userInfo)
{
try
{
if (userInfo.AreaId <= 0)
{
return(false);
}
if (string.IsNullOrEmpty(userInfo.UserPassPortId))
{
return(false);
}
lock (mapUser)
{
if (!mapUser.ContainsKey(userInfo.AreaId))
{
return(false);
}
if (!mapUser[userInfo.AreaId].ContainsKey(userInfo.UserPassPortId))
{
return(false);
}
mapUser[userInfo.AreaId][userInfo.UserPassPortId] = userInfo;
return(true);
}
}
catch (Exception err)
{
Loger.Debug("NickName change error : " + err.ToString());
return(false);
}
}
/// <summary>
/// 检测用户是否存在，如果存在则返回该用户信息
/// </summary>
/// <param name="playId">活动ID</param>
/// <param name="userName">用户名</param>
/// <param name="userInfo">用户信息</param>
/// <returns></returns>
public bool IsExistUser(int playId, string userName, out RemotingInterface.UserInfo userInfo)
{
userInfo = new RemotingInterface.UserInfo();
userInfo.Clear();
try
{
Dictionary <int, Dictionary <string, RemotingInterface.UserInfo> > mapTempUser = null;
mapTempUser = new Dictionary <int, Dictionary <string, RemotingInterface.UserInfo> >(mapUser);
if (mapTempUser == null)
{
return(false);
}
foreach (KeyValuePair <int, Dictionary <string, RemotingInterface.UserInfo> > amap in mapTempUser)
{
foreach (KeyValuePair <string, RemotingInterface.UserInfo> umap in amap.Value)
{
if (playId == umap.Value.PlayId && userName == umap.Value.UserPassPortId)
{
userInfo = umap.Value;
return(true);
}
}
}
return(false);
}
catch (Exception err)
{
Loger.Debug("IsExistUser(int playId, string userName,out RemotingInterface.UserInfo userInfo) error :" + err.ToString());
return(false);
}
}
public bool ChangeNickName(RemotingInterface.UserInfo userInfo)
{
if (!IsExistUser(userInfo.PlayId, userInfo.UserPassPortId))
{
Loger.Debug("ChangeNickName user [" + userInfo.UserPassPortId + "] dose not in the buffer !");
return(false);
}
bool bRet = Common.DBSync.ChangeNickName(userInfo);
return(bRet);
}
protected void btnUserReg(object sender, EventArgs e)
{
try
{
string userName = "";
int playId = 0;
int gameId = 0;
int areaId = 0;
userName = txtUserName.Text;
playId = Convert.ToInt32(txtPlayId.Text);
gameId = Convert.ToInt32(txtGameId.Text);
areaId = Convert.ToInt32(txtAreaId.Text);
if (BaseConfig.remoteUserRegObj.IsExistUser(playId, userName))
{
Response.Write("<script>alert('存在该用户！');</script>");
}
else
{
RemotingInterface.UserInfo userInfo = new RemotingInterface.UserInfo();
userInfo.UserPassPortId = userName;
userInfo.UserNickName = "testNickName";
userInfo.AreaId = areaId;
userInfo.PlayId = playId;
userInfo.Rtime = DateTime.Now;
userInfo.RIP = "127.0.0.1";
if (BaseConfig.remoteUserRegObj.RequestNewUser(BaseConfig.strRegUserRemoteKey,userInfo))
Response.Write("添加成功");
else
Response.Write("添加失败");
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
static void Main(string[] args)
{
int playId = 1;
int gameId = 1;
string userName = "";
int nNum = 100;
for (int i = 0; i < nNum; i++)
{
Random rd = new Random();
int areaId = rd.Next(1, 8);
userName = GenerateRandom(new Random().Next(6, 12));
RemotingInterface.UserInfo user = new RemotingInterface.UserInfo();
user.PlayId = playId;
user.GameId = gameId;
user.AreaId = areaId;
user.UserName = userName;
user.Rtime = System.DateTime.Now;
user.RIP = "127.0.0.1";
if (!remoteobj.IsExistUser(playId, userName))
{
if (!remoteobj.RequestNewUser("", user))
{
Console.WriteLine("i = " + i + "\tuserName = "******"添加失败");
}
else
{
Console.WriteLine("i = " + i + "\tuserName = "******"添加成功");
}
}
else
{
Console.WriteLine("i = " + i + "\tuserName = "******"用户已存在");
}
System.Threading.Thread.Sleep(100);
}
Console.ReadKey();
}
/// <summary>
/// 获取指定活动ID和用户名的用户信息
/// </summary>
/// <param name="playId">活动ID</param>
/// <param name="userName">用户名</param>
/// <returns></returns>
public RemotingInterface.UserInfo GetUserInfo(int playId, string userName)
{
RemotingInterface.UserInfo userInfo = new RemotingInterface.UserInfo();
userInfo.Clear();
try
{
if (playId <= 0 || userName == string.Empty)
{
return(userInfo);
}
Dictionary <int, Dictionary <string, RemotingInterface.UserInfo> > mapTempUser = null;
lock (mapUser)
{
mapTempUser = new Dictionary <int, Dictionary <string, RemotingInterface.UserInfo> >(mapUser);
}
if (mapTempUser == null)
{
return(userInfo);
}
foreach (KeyValuePair <int, Dictionary <string, RemotingInterface.UserInfo> > amap in mapTempUser)
{
foreach (KeyValuePair <string, RemotingInterface.UserInfo> umap in amap.Value)
{
if (playId == umap.Value.PlayId && userName == umap.Value.UserPassPortId) //找到与指定PlayId和UserName对应的用户，直接返回
{
return(umap.Value);
}
}
}
return(userInfo);
}
catch (Exception err)
{
Loger.Debug("GetUserInfo error :" + err.ToString());
return(userInfo);
}
}
/// <summary>
/// 用户信息加入用户缓存表
/// </summary>
/// <param name="userName"></param>
/// <param name="userInfo"></param>
/// <returns></returns>
public bool SetUserInfo(RemotingInterface.UserInfo userInfo)
{
try
{
if (userInfo.AreaId <= 0)
{
return(false);
}
if (string.IsNullOrEmpty(userInfo.UserPassPortId))
{
return(false);
}
lock (mapUser)
{
if (!mapUser.ContainsKey(userInfo.AreaId))
{
Dictionary <string, RemotingInterface.UserInfo> mapTempUser = new Dictionary <string, RemotingInterface.UserInfo>();
mapTempUser[userInfo.UserPassPortId] = userInfo;
mapUser.Add(userInfo.AreaId, mapTempUser);
}
else
{
if (!mapUser[userInfo.AreaId].ContainsKey(userInfo.UserPassPortId))
{
mapUser[userInfo.AreaId].Add(userInfo.UserPassPortId, userInfo);
}
}
return(true);
}
}
catch (Exception err)
{
Loger.Debug("SetUserInfo error : " + err.ToString());
return(false);
}
}
/// <summary>
/// 初始化，从数据库加载数据到用户缓存表
/// </summary>
/// <param name="mapUser"></param>
/// <returns></returns>
public bool Initialize(ref Dictionary<int, Dictionary<string, RemotingInterface.UserInfo>> mapUser)
{
try
{
if (mapUser == null)
mapUser = new Dictionary<int, Dictionary<string, RemotingInterface.UserInfo>>();
else
mapUser.Clear();
if (sqlConn.State == ConnectionState.Closed)
sqlConn.Open();
//获取所有正在进行的活动中已报名的用户信息
sqlCmd = new SqlCommand(@" select p.playId,p.playName,g.gameId,g.gameName,g.gameState,a.areaId,a.areaName,u.*
from userlist"+BaseConfig.PlayId+@" u,play p,game g,area a
where u.areaId=a.areaId
and a.gameId=g.gameId
and g.playId=p.playId
and g.gameState = 1", sqlConn);
sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
RemotingInterface.UserInfo userInfo = new RemotingInterface.UserInfo();
userInfo.Clear();
userInfo.UserId = Convert.ToInt32(sqlReader["UserId"]);
userInfo.UserPassPortId = sqlReader["UserName"].ToString();
userInfo.UserNickName = sqlReader["NickName"].ToString();
userInfo.PlayId = Convert.ToInt32(sqlReader["PlayId"]);
userInfo.GameId = Convert.ToInt32(sqlReader["GameId"]);
userInfo.AreaId = Convert.ToInt32(sqlReader["AreaId"]);
userInfo.UserDataBase = sqlReader["UserDataBase"].ToString();
//加入RegisterSystem中的mapUser
if (!mapUser.ContainsKey(userInfo.AreaId))
{
Dictionary<string, RemotingInterface.UserInfo> mapTempUser = new Dictionary<string, RemotingInterface.UserInfo>();
mapTempUser[userInfo.UserPassPortId] = userInfo;
mapUser.Add(userInfo.AreaId, mapTempUser);
}
else
{
if (!mapUser[userInfo.AreaId].ContainsKey(userInfo.UserPassPortId))
{
mapUser[userInfo.AreaId].Add(userInfo.UserPassPortId, userInfo);
}
}
//加入用户缓存表
if (Common.userBuffer != null)
{
Common.userBuffer.SetUserInfo(userInfo);
}
else
{
Loger.Debug("userBuffer is null!");
}
}
sqlReader.Close();
return true;
}
catch (Exception err)
{
Loger.Debug(err.ToString());
return false;
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
sqlConn.Close();
}
}
public bool ChangeNickName(RemotingInterface.UserInfo User)
{
try
{
if (BaseConfig.bAllowReg == false)
return false;
if (User.UserPassPortId == "" || User.PlayId <= 0 || User.AreaId <= 0)
return false;
if (sqlConn.State == ConnectionState.Closed)
sqlConn.Open();
//先在数据库中查找指定的用户信息
sqlCmd = new SqlCommand("SELECT AreaId,UserName,UserDataBase FROM [UserList" + BaseConfig.PlayId + "] WHERE AreaId = @AreaId AND UserName = @UserName AND Validity = 1 ", sqlConn);
sqlCmd.Parameters.Add("@AreaId", SqlDbType.Int); sqlCmd.Parameters["@AreaId"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.Read())
{
sqlReader.Close();
//加入数据库
sqlCmd = new SqlCommand("UPDATE [UserList" + BaseConfig.PlayId + "] SET NickName = @NickName WHERE AreaId = @AreaId AND UserName = @UserName AND Validity = 1 ", sqlConn);
sqlCmd.Parameters.Add("@AreaID", SqlDbType.Int); sqlCmd.Parameters["@AreaID"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlCmd.Parameters.Add("@NickName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@NickName"].Value = User.UserNickName;
sqlCmd.ExecuteNonQuery();
RemotingInterface.UserInfo urkUser = new RemotingInterface.UserInfo();
urkUser.Clear();
urkUser.PlayId = User.PlayId;
urkUser.GameId = User.GameId;
urkUser.AreaId = User.AreaId;
urkUser.UserPassPortId = User.UserPassPortId;
urkUser.UserNickName = User.UserNickName;
urkUser.UserDataBase = BaseConfig.mapNotifySrv[urkUser.PlayId][BaseConfig.CurrentRmtServerKey].DataBaseChar;
#region 注册通知
try
{
//加入用户缓存
if (Common.userBuffer != null)
{
Common.userBuffer.ChangeNickName(urkUser);
Loger.Debug("NickName Changed. userId " + "\t userName = "******"注册失败 userName = " + User.UserPassPortId);
Loger.Debug(err.ToString());
if (!sqlReader.IsClosed)
sqlReader.Close();
return false;
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
sqlConn.Close();
}
}
/// <summary>
/// 将用户信息加入用户内存，并将新用户加入新用户队列
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public bool AddNewUser(RemotingInterface.UserInfo User)
{
try
{
if (BaseConfig.bAllowReg == false)
return false;
if (User.UserPassPortId == "" || User.PlayId <= 0 || User.AreaId <= 0)
return false;
if (sqlConn.State == ConnectionState.Closed)
sqlConn.Open();
//先在数据库中查找指定的用户信息
sqlCmd = new SqlCommand("SELECT AreaId,UserName,UserDataBase FROM [UserList" + BaseConfig.PlayId + "] WHERE AreaId = @AreaId AND UserName = @UserName AND Validity = 1 ", sqlConn);
sqlCmd.Parameters.Add("@AreaId", SqlDbType.Int); sqlCmd.Parameters["@AreaId"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.Read())
{
sqlReader.Close();
return false;
}
else //未找到则添加
{
sqlReader.Close();
//为用户分配撮合交易服务器
#if DEBUG
#region 轮循
if (!Regex.IsMatch(BaseConfig.CurrentRmtServerKey, "[A-K]"))
{
BaseConfig.CurrentRmtServerKey = "K";
}
char chrBaseChar = char.Parse(BaseConfig.CurrentRmtServerKey);
int nBaseChar = (int)'A';
int nOffSet = (int)chrBaseChar - nBaseChar;
int nNextOffSet = (nOffSet + 1) % BaseConfig.RmtNumber;
char chrCurr = (char)(nBaseChar + nNextOffSet);
BaseConfig.CurrentRmtServerKey = chrCurr.ToString();
#endregion
#else
#region 随机
Random rd = new Random();
int nDataBaseChar = rd.Next(0, BaseConfig.RmtNumber);
int nBaseChar = (int)'A';
BaseConfig.CurrentRmtServerKey = ((char)(nDataBaseChar + nBaseChar)).ToString();
#endregion
#endif
//加入数据库
sqlCmd = new SqlCommand("INSERT INTO [UserList" + BaseConfig.PlayId + "] (AreaID, UserName, NickName, UserDataBase,Rtime,RIP) VALUES (@AreaID, @UserName, @NickName, @UserDataBase,@Rtime,@RIP) SELECT @@IDENTITY", sqlConn);
sqlCmd.Parameters.Add("@AreaID", SqlDbType.Int); sqlCmd.Parameters["@AreaID"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlCmd.Parameters.Add("@NickName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@NickName"].Value = User.UserNickName;
sqlCmd.Parameters.Add("@UserDataBase", SqlDbType.VarChar, 16); sqlCmd.Parameters["@UserDataBase"].Value = BaseConfig.mapNotifySrv[User.PlayId][BaseConfig.CurrentRmtServerKey].DataBaseChar;
sqlCmd.Parameters.Add("@Rtime", SqlDbType.DateTime); sqlCmd.Parameters["@Rtime"].Value = User.Rtime;
sqlCmd.Parameters.Add("@RIP", SqlDbType.VarChar, 16); sqlCmd.Parameters["@RIP"].Value = User.RIP;
int cRet = Convert.ToInt32(sqlCmd.ExecuteScalar());
RemotingInterface.UserInfo urkUser = new RemotingInterface.UserInfo();
urkUser.Clear();
urkUser.UserId = cRet;
urkUser.PlayId = User.PlayId;
urkUser.GameId = User.GameId;
urkUser.AreaId = User.AreaId;
urkUser.UserPassPortId = User.UserPassPortId;
urkUser.UserNickName = User.UserNickName;
urkUser.UserDataBase = BaseConfig.mapNotifySrv[urkUser.PlayId][BaseConfig.CurrentRmtServerKey].DataBaseChar;
#region 注册通知
try
{
//撮合系统接口
zns.Result flag = Common.znRmtIobj[User.PlayId][BaseConfig.CurrentRmtServerKey].PostUserData(cRet);
if (flag ==zns.Result.Existent_User)
{
Loger.Debug("撮合系统中存在该用户 userId = " + User.UserPassPortId + " status = " + flag);
}
else if (flag!=zns.Result.Success)
{
Loger.Debug("用户加入撮合系统失败 userId = " + User.UserId + " status = " + flag);
RemoveDBFailUser(urkUser);
return false;
}
//加入用户缓存
if (Common.userBuffer != null)
{
Common.userBuffer.SetUserInfo(urkUser);
Loger.Debug("完成注册 userId = " + cRet.ToString() + "\t userName = "******"\t DataBase =" + urkUser.UserDataBase);
}
}
catch (Exception ex)
{
Loger.Debug("通知失败");
RemoveDBFailUser(urkUser);
Loger.Debug(ex.ToString());
}
#endregion
}
return true;
}
catch (Exception err)
{
Loger.Debug("注册失败 userName = " + User.UserPassPortId);
Loger.Debug(err.ToString());
if (!sqlReader.IsClosed)
sqlReader.Close();
return false;
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
sqlConn.Close();
}
}
/// <summary>
/// 初始化，从数据库加载数据到用户缓存表
/// </summary>
/// <param name="mapUser"></param>
/// <returns></returns>
public bool Initialize(ref Dictionary <int, Dictionary <string, RemotingInterface.UserInfo> > mapUser)
{
try
{
if (mapUser == null)
{
mapUser = new Dictionary <int, Dictionary <string, RemotingInterface.UserInfo> >();
}
else
{
mapUser.Clear();
}
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
//获取所有正在进行的活动中已报名的用户信息
sqlCmd = new SqlCommand(@" select p.playId,p.playName,g.gameId,g.gameName,g.gameState,a.areaId,a.areaName,u.*
from userlist" + BaseConfig.PlayId + @" u,play p,game g,area a
where u.areaId=a.areaId
and a.gameId=g.gameId
and g.playId=p.playId
and g.gameState = 1", sqlConn);
sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
RemotingInterface.UserInfo userInfo = new RemotingInterface.UserInfo();
userInfo.Clear();
userInfo.UserId = Convert.ToInt32(sqlReader["UserId"]);
userInfo.UserPassPortId = sqlReader["UserName"].ToString();
userInfo.UserNickName = sqlReader["NickName"].ToString();
userInfo.PlayId = Convert.ToInt32(sqlReader["PlayId"]);
userInfo.GameId = Convert.ToInt32(sqlReader["GameId"]);
userInfo.AreaId = Convert.ToInt32(sqlReader["AreaId"]);
userInfo.UserDataBase = sqlReader["UserDataBase"].ToString();
//加入RegisterSystem中的mapUser
if (!mapUser.ContainsKey(userInfo.AreaId))
{
Dictionary <string, RemotingInterface.UserInfo> mapTempUser = new Dictionary <string, RemotingInterface.UserInfo>();
mapTempUser[userInfo.UserPassPortId] = userInfo;
mapUser.Add(userInfo.AreaId, mapTempUser);
}
else
{
if (!mapUser[userInfo.AreaId].ContainsKey(userInfo.UserPassPortId))
{
mapUser[userInfo.AreaId].Add(userInfo.UserPassPortId, userInfo);
}
}
//加入用户缓存表
if (Common.userBuffer != null)
{
Common.userBuffer.SetUserInfo(userInfo);
}
else
{
Loger.Debug("userBuffer is null!");
}
}
sqlReader.Close();
return(true);
}
catch (Exception err)
{
Loger.Debug(err.ToString());
return(false);
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
{
sqlConn.Close();
}
}
}
public bool ChangeNickName(RemotingInterface.UserInfo User)
{
try
{
if (BaseConfig.bAllowReg == false)
{
return(false);
}
if (User.UserPassPortId == "" || User.PlayId <= 0 || User.AreaId <= 0)
{
return(false);
}
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
//先在数据库中查找指定的用户信息
sqlCmd = new SqlCommand("SELECT AreaId,UserName,UserDataBase FROM [UserList" + BaseConfig.PlayId + "] WHERE AreaId = @AreaId AND UserName = @UserName AND Validity = 1 ", sqlConn);
sqlCmd.Parameters.Add("@AreaId", SqlDbType.Int); sqlCmd.Parameters["@AreaId"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.Read())
{
sqlReader.Close();
//加入数据库
sqlCmd = new SqlCommand("UPDATE [UserList" + BaseConfig.PlayId + "] SET NickName = @NickName WHERE AreaId = @AreaId AND UserName = @UserName AND Validity = 1 ", sqlConn);
sqlCmd.Parameters.Add("@AreaID", SqlDbType.Int); sqlCmd.Parameters["@AreaID"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlCmd.Parameters.Add("@NickName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@NickName"].Value = User.UserNickName;
sqlCmd.ExecuteNonQuery();
RemotingInterface.UserInfo urkUser = new RemotingInterface.UserInfo();
urkUser.Clear();
urkUser.PlayId = User.PlayId;
urkUser.GameId = User.GameId;
urkUser.AreaId = User.AreaId;
urkUser.UserPassPortId = User.UserPassPortId;
urkUser.UserNickName = User.UserNickName;
urkUser.UserDataBase = BaseConfig.mapNotifySrv[urkUser.PlayId][BaseConfig.CurrentRmtServerKey].DataBaseChar;
#region 注册通知
try
{
//加入用户缓存
if (Common.userBuffer != null)
{
Common.userBuffer.ChangeNickName(urkUser);
Loger.Debug("NickName Changed. userId " + "\t userName = "******"注册失败 userName = " + User.UserPassPortId);
Loger.Debug(err.ToString());
if (!sqlReader.IsClosed)
{
sqlReader.Close();
}
return(false);
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
{
sqlConn.Close();
}
}
}
/// <summary>
/// 将用户信息加入用户内存，并将新用户加入新用户队列
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public bool AddNewUser(RemotingInterface.UserInfo User)
{
try
{
if (BaseConfig.bAllowReg == false)
{
return(false);
}
if (User.UserPassPortId == "" || User.PlayId <= 0 || User.AreaId <= 0)
{
return(false);
}
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
//先在数据库中查找指定的用户信息
sqlCmd = new SqlCommand("SELECT AreaId,UserName,UserDataBase FROM [UserList" + BaseConfig.PlayId + "] WHERE AreaId = @AreaId AND UserName = @UserName AND Validity = 1 ", sqlConn);
sqlCmd.Parameters.Add("@AreaId", SqlDbType.Int); sqlCmd.Parameters["@AreaId"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.Read())
{
sqlReader.Close();
return(false);
}
else //未找到则添加
{
sqlReader.Close();
//为用户分配撮合交易服务器
#if DEBUG
#region 轮循
if (!Regex.IsMatch(BaseConfig.CurrentRmtServerKey, "[A-K]"))
{
BaseConfig.CurrentRmtServerKey = "K";
}
char chrBaseChar = char.Parse(BaseConfig.CurrentRmtServerKey);
int nBaseChar = (int)'A';
int nOffSet = (int)chrBaseChar - nBaseChar;
int nNextOffSet = (nOffSet + 1) % BaseConfig.RmtNumber;
char chrCurr = (char)(nBaseChar + nNextOffSet);
BaseConfig.CurrentRmtServerKey = chrCurr.ToString();
#endregion
#else
#region 随机
Random rd = new Random();
int nDataBaseChar = rd.Next(0, BaseConfig.RmtNumber);
int nBaseChar = (int)'A';
BaseConfig.CurrentRmtServerKey = ((char)(nDataBaseChar + nBaseChar)).ToString();
#endregion
#endif
//加入数据库
sqlCmd = new SqlCommand("INSERT INTO [UserList" + BaseConfig.PlayId + "] (AreaID, UserName, NickName, UserDataBase,Rtime,RIP) VALUES (@AreaID, @UserName, @NickName, @UserDataBase,@Rtime,@RIP) SELECT @@IDENTITY", sqlConn);
sqlCmd.Parameters.Add("@AreaID", SqlDbType.Int); sqlCmd.Parameters["@AreaID"].Value = User.AreaId;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@UserName"].Value = User.UserPassPortId;
sqlCmd.Parameters.Add("@NickName", SqlDbType.VarChar, 32); sqlCmd.Parameters["@NickName"].Value = User.UserNickName;
sqlCmd.Parameters.Add("@UserDataBase", SqlDbType.VarChar, 16); sqlCmd.Parameters["@UserDataBase"].Value = BaseConfig.mapNotifySrv[User.PlayId][BaseConfig.CurrentRmtServerKey].DataBaseChar;
sqlCmd.Parameters.Add("@Rtime", SqlDbType.DateTime); sqlCmd.Parameters["@Rtime"].Value = User.Rtime;
sqlCmd.Parameters.Add("@RIP", SqlDbType.VarChar, 16); sqlCmd.Parameters["@RIP"].Value = User.RIP;
int cRet = Convert.ToInt32(sqlCmd.ExecuteScalar());
RemotingInterface.UserInfo urkUser = new RemotingInterface.UserInfo();
urkUser.Clear();
urkUser.UserId = cRet;
urkUser.PlayId = User.PlayId;
urkUser.GameId = User.GameId;
urkUser.AreaId = User.AreaId;
urkUser.UserPassPortId = User.UserPassPortId;
urkUser.UserNickName = User.UserNickName;
urkUser.UserDataBase = BaseConfig.mapNotifySrv[urkUser.PlayId][BaseConfig.CurrentRmtServerKey].DataBaseChar;
#region 注册通知
try
{
//撮合系统接口
zns.Result flag = Common.znRmtIobj[User.PlayId][BaseConfig.CurrentRmtServerKey].PostUserData(cRet);
if (flag == zns.Result.Existent_User)
{
Loger.Debug("撮合系统中存在该用户 userId = " + User.UserPassPortId + " status = " + flag);
}
else if (flag != zns.Result.Success)
{
Loger.Debug("用户加入撮合系统失败 userId = " + User.UserId + " status = " + flag);
RemoveDBFailUser(urkUser);
return(false);
}
//加入用户缓存
if (Common.userBuffer != null)
{
Common.userBuffer.SetUserInfo(urkUser);
Loger.Debug("完成注册 userId = " + cRet.ToString() + "\t userName = "******"\t DataBase =" + urkUser.UserDataBase);
}
}
catch (Exception ex)
{
Loger.Debug("通知失败");
RemoveDBFailUser(urkUser);
Loger.Debug(ex.ToString());
}
#endregion
}
return(true);
}
catch (Exception err)
{
Loger.Debug("注册失败 userName = " + User.UserPassPortId);
Loger.Debug(err.ToString());
if (!sqlReader.IsClosed)
{
sqlReader.Close();
}
return(false);
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
{
sqlConn.Close();
}
}
}
/// <summary>
/// 检测用户是否存在，如果存在则返回该用户信息
/// </summary>
/// <param name="playId">活动ID</param>
/// <param name="userName">用户名</param>
/// <param name="userInfo">用户信息</param>
/// <returns></returns>
public bool IsExistUser(int playId, string userName, out RemotingInterface.UserInfo userInfo)
{
userInfo = new RemotingInterface.UserInfo();
userInfo.Clear();
try
{
Dictionary<int, Dictionary<string, RemotingInterface.UserInfo>> mapTempUser = null;
mapTempUser = new Dictionary<int, Dictionary<string, RemotingInterface.UserInfo>>(mapUser);
if (mapTempUser == null)
return false;
foreach (KeyValuePair<int, Dictionary<string, RemotingInterface.UserInfo>> amap in mapTempUser)
{
foreach (KeyValuePair<string, RemotingInterface.UserInfo> umap in amap.Value)
{
if (playId == umap.Value.PlayId && userName == umap.Value.UserPassPortId)
{
userInfo = umap.Value;
return true;
}
}
}
return false;
}
catch (Exception err)
{
Loger.Debug("IsExistUser(int playId, string userName,out RemotingInterface.UserInfo userInfo) error :" + err.ToString());
return false;
}
}