//注册
public void Test_registerUser()
{
JObj_SignRet obj = new JObj_SignRet();
obj.Result = true;
JLocalDataHelper.addData(JPacketType.npt_signin_ret, obj);
}
// Use this for initialization
void Start()
{
CreatePlayerUtil.RoleModels.Add(1, GameObject.Find("gs"));
CreatePlayerUtil.RoleModels.Add(2, GameObject.Find("ms"));
CreatePlayerUtil.RoleModels.Add(3, GameObject.Find("fs"));
CreatePlayerUtil.RoleModels.Add(4, GameObject.Find("zs1"));
CreatePlayerUtil.RoleModels.Add(5, GameObject.Find("zs2"));
CreatePlayerUtil.RoleModels.Add(6, GameObject.Find("zs3"));
IStreamObj obj = JLogicUserData.getLocalData().getData(JObjectType.sign_in_ret);
if (null == obj)
{
return;
}
JObj_SignRet retObj = obj as JObj_SignRet;
if (null == retObj)
{
return;
}
foreach (var role in retObj.RolesInfo)
{
initial(role);
}
}
public void run(IDataSet dataSet)
{
IStreamObj obj = dataSet.getData(JObjectType.sign_in);
JObj_SignIn signInObj = obj as JObj_SignIn;
if (signInObj == null)
{
return;
}
string account = signInObj._strAccount;
string code = signInObj._strCode;
JLog.Info("receive npt_signin_req packet from client: account:" + account + " code:" + code, JGame.Log.JLogCategory.Network);
JObj_SignRet resultObj = new JObj_SignRet();
//ToDo:if account and code is in database then
if (account == "test" && code == "123")
{
resultObj.Result = true;
}
else
{
resultObj.Result = false;
}
try {
JNetworkDataOperator.SendData(JPacketType.npt_signin_ret, resultObj);
JLog.Info("send npt_signin_ret packet to client", JGame.Log.JLogCategory.Network);
return;
} catch (Exception e) {
JLog.Debug("发送数据失败");
JLog.Error(e.Message);
return;
}
}
public void run(IDataSet dataSet)
{
IStreamObj obj = dataSet.getData(JObjectType.sign_in);
JObj_SignIn signInObj = obj as JObj_SignIn;
if (signInObj == null)
{
return;
}
string account = signInObj._strAccount;
string code = signInObj._strCode;
JLog.Info("JProcesserSignInServer.run receive npt_signin_req packet from client: account:" + account + " code:" + code, JGame.Log.JLogCategory.Network);
JObj_SignRet resultObj = new JObj_SignRet();
JMySqlAccess sqlite = new JMySqlAccess("mysql", "127.0.0.1", "root", "684268");
if (!sqlite.Open())
{
return;
}
if (!sqlite.Connected)
{
return;
}
DataSet data = sqlite.Select(string.Format(
@"Select * from user_info t where t.user_account = '{0}' and t.user_code = '{1}'",
signInObj._strAccount,
signInObj._strCode));
bool bSuccess = false;
do
{
if (null == data || null == data.Tables)
{
break;
}
if (data.Tables.Count <= 0)
{
break;
}
if (null == data.Tables[0].Rows || data.Tables[0].Rows.Count <= 0)
{
break;
}
if (data.Tables[0].Rows.Count > 0)
{
bSuccess = true;
}
}while(false);
resultObj.Result = bSuccess;
string[] items = new string[] { "role_name", "role_type", "role_level", "x", "y", "z", "x_rotation", "y_rotation", "z_rotation", "user_account" };
string[] where_cols = new string[] { "user_account" };
string[] operation = new string[] { "=" };
string[] values = new string[] { signInObj._strAccount };
string strAccount = null;
DataSet roleInfo = sqlite.Select("role_info", items, where_cols, operation, values);
do
{
if (null == roleInfo || null == roleInfo.Tables)
{
break;
}
if (roleInfo.Tables.Count <= 0)
{
break;
}
if (null == roleInfo.Tables[0].Rows || roleInfo.Tables[0].Rows.Count <= 0)
{
break;
}
try
{
if (roleInfo.Tables [0].Rows.Count > 0)
{
resultObj.RolesInfo = new System.Collections.Generic.List <JObjRoleInfo> ();
foreach (DataRow dataRow in roleInfo.Tables[0].Rows)
{
JObjRoleInfo role = new JObjRoleInfo();
role.roleName = dataRow [0].ToString();
role.roleType = int.Parse(dataRow [1].ToString());
role.roleLevel = int.Parse(dataRow [2].ToString());
double coord;
if (double.TryParse(dataRow [3].ToString(), out coord))
{
role.x = coord;
}
if (double.TryParse(dataRow [4].ToString(), out coord))
{
role.y = coord;
}
if (double.TryParse(dataRow [5].ToString(), out coord))
{
role.z = coord;
}
if (double.TryParse(dataRow [6].ToString(), out coord))
{
role.rotatex = coord;
}
if (double.TryParse(dataRow [7].ToString(), out coord))
{
role.rotatey = coord;
}
if (double.TryParse(dataRow [8].ToString(), out coord))
{
role.rotatez = coord;
}
resultObj.RolesInfo.Add(role);
strAccount = dataRow[9].ToString();
}
}
}
catch (Exception e)
{
JLog.Error("JProcesserSignInServer.run " + e.Message);
}
}while(false);
if (null != strAccount)
{
//记录当前新增的登录信息到对应的dataSet
IStreamObj clientobj = dataSet.getData(JObjectType.sign_in_info);
if (null != clientobj)
{
JSignInClientInfoObject clientInfo = clientobj as JSignInClientInfoObject;
clientInfo.Info.Account = strAccount;
}
else
{
JSignInClientInfoObject clientInfo = new JSignInClientInfoObject();
clientInfo.Info.Account = strAccount;
clientobj = clientInfo;
}
JLog.Info("JProcesserSignInServer.run add connected client info dataset, account:" + strAccount, JGame.Log.JLogCategory.Network);
dataSet.setData(clientobj);
}
try {
JNetworkDataOperator.SendData(JPacketType.npt_signin_ret, resultObj, dataSet.EndPoint);
JLog.Info("JProcesserSignInServer.run send npt_signin_ret packet to client", JGame.Log.JLogCategory.Network);
return;
} catch (Exception e) {
JLog.Debug("发送数据失败");
JLog.Error(e.Message);
return;
}
}
