/// <summary>
/// 请求游戏服务器IP列表
/// </summary>
/// <returns></returns>
public Message packServerInfoResp()
{
int gameID = 0;
int gameDbID = 0;
TLV_Structure tlvStrut = new TLV_Structure(TagName.ServerInfo_GameID, 4, message.m_packet.m_Body.getTLVByTag(TagName.ServerInfo_GameID).m_bValueBuffer);
gameID = (int)tlvStrut.toInteger();
tlvStrut = new TLV_Structure(TagName.ServerInfo_GameDBID, 4, message.m_packet.m_Body.getTLVByTag(TagName.ServerInfo_GameDBID).m_bValueBuffer);
gameDbID = (int)tlvStrut.toInteger();
DataSet ds = CommonInfo.serverIP_Query(gameID, gameDbID);
if (ds != null && ds.Tables[0].Rows.Count <= 0)
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_GameListEmpty, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
else
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.ServerInfo_IP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.ServerInfo_City, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.ServerInfo_GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, 3));
}
}
/// <summary>
/// 得到所有游戏信息
/// </summary>
/// <returns>游戏数据集</returns>
public Message GM_QueryAll()
{
GMLogAPI logAPI = new GMLogAPI();
DataSet ds = null;
try
{
ds = GMGameInfo.SelectAll();
logAPI.writeTitle(LanguageAPI.API_Display + LanguageAPI.API_GameInfoAPI_GameList, LanguageAPI.API_Display + LanguageAPI.API_GameInfoAPI_GameList);
logAPI.writeContent(LanguageAPI.API_GameInfoAPI_GameID, LanguageAPI.API_GameInfoAPI_GameTitle, LanguageAPI.API_GameInfoAPI_GameDesp);
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.GameID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.GameContent, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
logAPI.writeData(ds.Tables[0].Rows[i].ItemArray[0].ToString(), ds.Tables[0].Rows[i].ItemArray[1].ToString(), ds.Tables[0].Rows[i].ItemArray[2].ToString());
}
Console.Write(logAPI.Buffer.ToString());
return(Message.COMMON_MES_RESP(structList, Msg_Category.GAME_ADMIN, ServiceKey.GAME_QUERY_RESP, 3));
}
catch (Common.Logic.Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
/// <summary>
/// 得到GM帐号信息类
/// </summary>
/// <param name="userID">用户ID</param>
/// <returns>GM帐号类</returns>
public Message GM_QuerySysAdminInfo(int userID)
{
//int sysAdmin = -1;
System.Data.DataSet ds = null;
try
{
//将GM帐号信息存入DATASET
ds = GMUserInfo.getUserInfo(userID);
Query_Structure[] structList = new Query_Structure[1];
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[0].ItemArray.Length);
strut.AddTagKey(TagName.SysAdmin,TagFormat.TLV_INTEGER,4,TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER,ds.Tables[0].Rows[0].ItemArray[9]));
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER,ds.Tables[0].Rows[0].ItemArray[5]);
strut.AddTagKey(TagName.DepartID,TagFormat.TLV_INTEGER,(uint)bytes.Length,bytes);
structList[0] = strut;
return Message.COMMON_MES_RESP(structList,Msg_Category.USER_ADMIN,ServiceKey.USER_SYSADMIN_QUERY_RESP,2);
}
else
{
return Message.COMMON_MES_RESP(LanguageAPI.API_UserInfoAPI_NoAdmin,Msg_Category.USER_ADMIN,ServiceKey.USER_SYSADMIN_QUERY_RESP,TagName.ERROR_Msg,TagFormat.TLV_STRING);
}
}
catch(System.Exception ex)
{
return Message.COMMON_MES_RESP(LanguageAPI.API_UserInfoAPI_NoAdmin,Msg_Category.USER_ADMIN,ServiceKey.USER_SYSADMIN_QUERY_RESP,TagName.ERROR_Msg,TagFormat.TLV_STRING);
}
}
/// <summary>
/// 查询频道列表
/// </summary>
/// <param name="account"></param>
/// <param name="serverIP"></param>
/// <returns></returns>
public Message CR_Channel_QueryAll()
{
System.Data.DataSet ds = null;
string serverIP = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_ChannelList);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_ChannelList);
ds = CRCallBoardInfo.Channel_QueryAll(serverIP);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]));
strut.AddTagKey(TagName.CR_ChannelID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.CR_ChannelName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.CR_ADMIN, ServiceKey.CR_CHANNEL_QUERY_RESP, 2));
}
else
{
return(Message.COMMON_MES_RESP(lg.CR_CallBoardAPI_NoChannelList, Msg_Category.CR_ADMIN, ServiceKey.CR_CHANNEL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.CR_CallBoardAPI_NoChannelList, Msg_Category.CR_ADMIN, ServiceKey.CR_CHANNEL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 得到模块信息类
/// </summary>
/// <param name="moduleID">模块ID</param>
/// <returns>模块类</returns>
public GMModuleInfo GM_QueryModuleInfo(int moduleID)
{
System.Data.DataSet ds = null;
GMModuleInfo ModuleInfo = null;
try
{
//将模块信息存入DATASET
ds = GMModuleInfo.QueryModuleInfo(moduleID);
//构造一个模块信息类
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
strut.AddTagKey(TagName.Module_ID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]));
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.ModuleName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.ModuleClass, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.ModuleContent, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
}
return(ModuleInfo);
}
/// <summary>
/// 查询停封玩家信息
/// </summary>
/// <param name="index">第几页</param>
/// <param name="pageSize">每页记录数</param>
/// <returns></returns>
public Message Soccer_AccountState_Query(int index, int pageSize)
{
System.Data.DataSet ds = null;
string serverIP = null;
string str_type = "";
string str_string = "";
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_ServerIP).m_bValueBuffer);
str_type = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_Type).m_bValueBuffer);
str_string = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_String).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + str_string + lg.Soccer_CharacterInfoAPI_BanInfo);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + str_string + lg.Soccer_CharacterInfoAPI_BanInfo);
ds = SOCCERCharacterInfo.Soccer_AccountState_Query(serverIP, str_type, str_string);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//总页数
int pageCount = 0;
pageCount = ds.Tables[0].Rows.Count % pageSize;
if (pageCount > 0)
{
pageCount = ds.Tables[0].Rows.Count / pageSize + 1;
}
else
{
pageCount = ds.Tables[0].Rows.Count / pageSize;
}
if (index + pageSize > ds.Tables[0].Rows.Count)
{
pageSize = ds.Tables[0].Rows.Count - index;
}
Query_Structure[] structList = new Query_Structure[pageSize];
for (int i = index; i < index + pageSize; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[0]));
strut.AddTagKey(TagName.Soccer_loginId, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[1]));
strut.AddTagKey(TagName.Soccer_regDate, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]));
strut.AddTagKey(TagName.Soccer_m_id, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount));
structList[i - index] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP(lg.Soccer_CharacterInfoAPI_NoBan, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 玩家活动卡查询
/// </summary>
/// <returns></returns>
public Message RcUserActiveCard_Query()
{
string activeCode = null;
string strDesc = null;
int atype = 0;
System.Collections.ArrayList ds = new System.Collections.ArrayList();
try
{
activeCode = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_activename).m_bValueBuffer);
TLV_Structure strut1 = new TLV_Structure(TagName.RayCity_ActionType, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ActionType).m_bValueBuffer);
atype = (int)strut1.toInteger();
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Account + activeCode + lg.RayCityAPI_ActiveCard_Query);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Account + activeCode + lg.RayCityAPI_ActiveCard_Query);
if (atype == 1)
{
ds = CharacterInfo.ActiveCard_Query(activeCode, 1, ref strDesc);
}
else if (atype == 2)
{
ds = CharacterInfo.ActiveCard_Query(activeCode, 2, ref strDesc);
}
if (ds != null && ds.Count > 0)
{
Query_Structure[] structList = new Query_Structure[1];
Query_Structure strut = new Query_Structure((uint)ds.Count);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[0]);
strut.AddTagKey(TagName.RayCity_rccdkey, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[1]);
strut.AddTagKey(TagName.RayCity_getuser, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[2]);
strut.AddTagKey(TagName.RayCity_gettime, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[3]);
strut.AddTagKey(TagName.RayCity_use_state, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[4]);
strut.AddTagKey(TagName.RayCity_activename, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[0] = strut;
return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ActiveCard_Query_Resp, 5));
}
else
{
return(Message.COMMON_MES_RESP(strDesc, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ActiveCard_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception)
{
return(Message.COMMON_MES_RESP(strDesc, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ActiveCard_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
//频道列表请求
public Message ChannelList_Query()
{
System.Data.DataSet ds = null;
string serverIP = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
//发送登陆请求消息
connect_Req(serverIP);
NoticeDataInfo.TruncateTable_Req();
while (listCnt <= 7)
{
//接受消息
if (receiveMsg() > 0)
{
//解析消息
parseMsg();
}
//Thread.Sleep(1000);
}
client.Close();
SqlHelper.log.WriteLog(lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDONoticeInfoAPI_ChannelList);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDONoticeInfoAPI_ChannelList);
//从数据库里面将频道列表读出来
ds = NoticeDataInfo.ChannelList_Req();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure(5);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.SDO_wPlanetID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.SDO_wChannelID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.SDO_iLimitUser, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.SDO_iCurrentUser, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.SDO_ipaddr, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_CHANNELLIST_QUERY_RESP, 5));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDONoticeInfoAPI_NoChannelInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDONoticeInfoAPI_NoChannelInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看本地被封停的帐号
/// </summary>
/// <returns></returns>
public Message O2JAMBanishmentLocal_Query()
{
DataSet ds = null;
string serverIP = null;
string account = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_BanInfo);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_BanInfo);
ds = MemberInfo.SDO_BanishmentLocal_Query(serverIP, account);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
object context;
if (ds.Tables[0].Rows[i].IsNull(0) == false)
{
context = ds.Tables[0].Rows[i].ItemArray[0];
}
else
{
context = "";
}
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, context);
strut.AddTagKey(TagName.SDO_Context, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.SDO_StopTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
object reason;
if (ds.Tables[0].Rows[i].IsNull(2) == false)
{
reason = ds.Tables[0].Rows[i].ItemArray[2];
}
else
{
reason = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, reason);
strut.AddTagKey(TagName.SDO_REASON, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERLOCAL_BANISHMENT_RESP, 3));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoAccountBanInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERLOCAL_BANISHMENT_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoAccountBanInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERLOCAL_BANISHMENT_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看游戏里面所有道具
/// </summary>
/// <returns></returns>
public Message AvatarList_QueryALL()
{
string serverIP = null;
string item_Name = null;
int sex = 0;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
//道具名
item_Name = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ItemName).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_AllGameItem);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_AllGameItem);
//请求所有分类道具列表
ds = AUAvatarListInfo.AvatarList_QueryAll(serverIP, item_Name);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
//道具编号
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]));
strut.AddTagKey(TagName.AU_ItemID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
//道具名
object itemName;
if (ds.Tables[0].Rows[i].IsNull(1) == false)
{
itemName = ds.Tables[0].Rows[i].ItemArray[1];
}
else
{
itemName = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, itemName);
strut.AddTagKey(TagName.AU_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]));
strut.AddTagKey(TagName.AU_SexIndex, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]));
strut.AddTagKey(TagName.AU_Cash, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoGameItem, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoGameItem, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
public Message UpdateList_Query()
{
DataSet ds = null;
try
{
SqlHelper.log.WriteLog(LanguageAPI.API_CommonAPI_UpdateInfo);
Console.WriteLine(DateTime.Now + " -" + LanguageAPI.API_CommonAPI_UpdateInfo);
ds = CommonInfo.UpdateList_Query();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]));
strut.AddTagKey(TagName.Update_ID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
string updateModule;
if (ds.Tables[0].Rows[i].IsNull(1) == false)
{
updateModule = ds.Tables[0].Rows[i].ItemArray[1].ToString();
}
else
{
updateModule = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, updateModule);
strut.AddTagKey(TagName.Update_Module, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
string updateContext;
if (ds.Tables[0].Rows[i].IsNull(2) == false)
{
updateContext = ds.Tables[0].Rows[i].ItemArray[2].ToString();
}
else
{
updateContext = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, updateContext);
strut.AddTagKey(TagName.Update_Context, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[3]));
strut.AddTagKey(TagName.Update_Date, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.COMMON, ServiceKey.GMTOOLS_UPDATELIST_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_NoUpdateInfo, Msg_Category.COMMON, ServiceKey.GMTOOLS_UPDATELIST_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.COMMON, ServiceKey.GMTOOLS_UPDATELIST_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看服务器所有停封帐号
/// </summary>
/// <returns></returns>
public Message O2JAMMember_banishment_QueryAll(int index, int pageSize)
{
string serverIP = null;
DataSet ds = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_MemberInfoAPI_AllBanAccount);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_MemberInfoAPI_AllBanAccount);
ds = MemberInfo.SDO_Banishment_QueryAll(serverIP);
if (null != ds && ds.Tables[0].Rows.Count > 0)
{
//总页数
int pageCount = 0;
pageCount = ds.Tables[0].Rows.Count % pageSize;
if (pageCount > 0)
{
pageCount = ds.Tables[0].Rows.Count / pageSize + 1;
}
else
{
pageCount = ds.Tables[0].Rows.Count / pageSize;
}
if (index + pageSize > ds.Tables[0].Rows.Count)
{
pageSize = ds.Tables[0].Rows.Count - index;
}
Query_Structure[] structList = new Query_Structure[pageSize];
for (int i = index; i < index + pageSize; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.SDO_UserIndexID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.SDO_Account, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.SDO_StopTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
//总页数
strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount));
structList[i - index] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERBANISHMENT_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoBanAccount, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERBANISHMENT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception e)
{
return(Message.COMMON_MES_RESP(e.Message, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERBANISHMENT_QUERY_RESP));
}
}
/// <summary>
/// 网关查询
/// </summary>
/// <returns></returns>
public Message SDO_GateWay_Query(int index, int pageSize)
{
string serverIP = null;
string gatewayIP = null;
System.Data.DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
gatewayIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Address).m_bValueBuffer);
SqlHelper.log.WriteLog(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDOCharacterInfoAPI_GateWay);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDOCharacterInfoAPI_GateWay);
//查询GATEWAY IP
ds = CharacterInfo.ServerGateWay_Query(serverIP, gatewayIP);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//总页数
int pageCount = 0;
pageCount = ds.Tables[0].Rows.Count % pageSize;
if (pageCount > 0)
{
pageCount = ds.Tables[0].Rows.Count / pageSize + 1;
}
else
{
pageCount = ds.Tables[0].Rows.Count / pageSize;
}
if (index + pageSize > ds.Tables[0].Rows.Count)
{
pageSize = ds.Tables[0].Rows.Count - index;
}
Query_Structure[] structList = new Query_Structure[pageSize];
for (int i = index; i < index + pageSize; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1);
//ADDR IP
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.SDO_Address, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
//总页数
strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount));
structList[i - index] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GATEWAY_QUERY_RESP, 2));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NotOnline, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GATEWAY_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NotOnline, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GATEWAY_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看本地被封停的帐号
/// </summary>
/// <returns></returns>
public Message Audition_BanishmentLocal_Query()
{
System.Data.DataSet ds = null;
string serverIP = null;
string account = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ACCOUNT).m_bValueBuffer);
//account = AUMemberInfo.Audition_Identity9you_Query(serverIP,account);
SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.AU_AUAvatarListAPI_Account + account + lg.AU_AUMemberInfoAPI_BanInfo);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.AU_AUAvatarListAPI_Account + account + lg.AU_AUMemberInfoAPI_BanInfo);
ds = AUMemberInfo.Audition_BanishmentLocal_Query(serverIP, account);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.AU_ACCOUNT, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.AU_UserNick, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.AU_ServerIP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
object reason;
if (ds.Tables[0].Rows[i].IsNull(3) == false)
{
reason = ds.Tables[0].Rows[i].ItemArray[3];
}
else
{
reason = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, reason);
strut.AddTagKey(TagName.AU_Reason, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.AU_BanDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.AU_ADMIN, ServiceKey.AU_ACCOUNTLOCAL_QUERY_RESP, 5));
}
else
{
return(Message.COMMON_MES_RESP(lg.AU_AUMemberInfoAPI_NoAccountBanInfo, Msg_Category.AU_ADMIN, ServiceKey.AU_ACCOUNTLOCAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.AU_AUMemberInfoAPI_NoAccountBanInfo, Msg_Category.AU_ADMIN, ServiceKey.AU_ACCOUNTLOCAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查询玩家宠物信息
/// </summary>
/// <returns></returns>
public Message SDO_PetInfo_Query()
{
string serverIP = null;
int userIndexID = 0;
System.Data.DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
TLV_Structure strut = new TLV_Structure(TagName.SDO_UserIndexID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_UserIndexID).m_bValueBuffer);
userIndexID = (int)strut.toInteger();
SqlHelper.log.WriteLog("流覽超級舞者+>" + CommonInfo.serverIP_Query(serverIP) + "玩家" + userIndexID + "寵物資訊!");
Console.WriteLine(DateTime.Now + " - 流覽超級舞者+>" + CommonInfo.serverIP_Query(serverIP) + "玩家" + userIndexID + "寵物資訊!");
ds = ItemShopInfo.SDOPetInfo_Query(serverIP, userIndexID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut1.AddTagKey(TagName.SDO_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut1.AddTagKey(TagName.SDO_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[2]);
strut1.AddTagKey(TagName.SDO_DateLimit, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]);
strut1.AddTagKey(TagName.SDO_State, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[4]);
strut1.AddTagKey(TagName.SDO_Level, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[5]);
strut1.AddTagKey(TagName.SDO_Exp, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[6]);
strut1.AddTagKey(TagName.SDO_Food, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[7]);
strut1.AddTagKey(TagName.SDO_mood, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[i] = strut1;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_PetInfo_Query_RESP, 8));
}
else
{
return(Message.COMMON_MES_RESP("沒有相關寵物資訊", Msg_Category.SDO_ADMIN, ServiceKey.SDO_PetInfo_Query_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP("沒有相關寵物資訊", Msg_Category.SDO_ADMIN, ServiceKey.SDO_PetInfo_Query_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 修改用户令牌
/// </summary>
/// <returns></returns>
public Message Modify_User_Token()
{
string userName = null;
string esn = null;
string code = null;
string description = null;
string service = null;
try
{
esn = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.TOKEN_esn).m_bValueBuffer);
userName = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.TOKEN_username).m_bValueBuffer);
service = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.TOKEN_service).m_bValueBuffer);
SqlHelper.log.WriteLog("修改用户" + userName + "的当前状态!");
Console.WriteLine(DateTime.Now + " - 修改用户" + userName + "的当前状态!");
ArrayList ds = UserauthenticInfo.Modify_User_Token("asas", service, userName, esn);
if (ds != null && ds.Count > 0)
{
for (int i = 0; i < ds.Count; i++)
{
ArrayList para = (ArrayList)ds[i];
if (para[0].ToString() == "code")
{
code = ConfigurationSettings.AppSettings[para[1].ToString()];
}
if (para[0].ToString() == "description")
{
description = para[1].ToString();
}
}
Query_Structure[] structList = new Query_Structure[1];
Query_Structure strut = new Query_Structure(2);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, code);
strut.AddTagKey(TagName.TOKEN_code, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, description);
strut.AddTagKey(TagName.TOKEN_description, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[0] = strut;
return(Message.COMMON_MES_RESP(structList, Msg_Category.CARD_ADMIN, ServiceKey.TOKEN_MODIFYUSER_QUERY_RESP, 2));
}
else
{
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.CARD_ADMIN, ServiceKey.TOKEN_MODIFYUSER_QUERY_RESP));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.CARD_ADMIN, ServiceKey.TOKEN_MODIFYUSER_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看玩家服务器激活状态
/// </summary>
/// <returns></returns>
public Message O2JAMMemberInfo_Query()
{
string serverIP = null;
string account = null;
DataSet ds = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_ActiveState);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_ActiveState);
ds = MemberInfo.memberInfo_Query(serverIP, account);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.SDO_Account, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.SDO_9YouAccount, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.SDO_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_BOOLEAN, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.SDO_SEX, TagFormat.TLV_BOOLEAN, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_DATE, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.SDO_RegistDate, TagFormat.TLV_DATE, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_DATE, ds.Tables[0].Rows[i].ItemArray[5]);
strut.AddTagKey(TagName.SDO_FirstLogintime, TagFormat.TLV_DATE, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_DATE, ds.Tables[0].Rows[i].ItemArray[6]);
strut.AddTagKey(TagName.SDO_LastLogintime, TagFormat.TLV_DATE, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[7]);
strut.AddTagKey(TagName.SDO_Ispad, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, 1);
strut.AddTagKey(TagName.SDO_ActiveStatus, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, 9));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoActived, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception e)
{
Console.WriteLine(e.Message);
return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoActived, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
public Message UserNick_Query()
{
string account = "";
string nickName = "";
System.Data.DataSet ds = null;
try
{
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.UserName).m_bValueBuffer);
ds = CardDetailInfo.UserName_Query(account, nickName);
Query_Structure[] structList = new Query_Structure[1];
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure strut = new Query_Structure(1);
nickName = ds.Tables[0].Rows[0].ItemArray[1].ToString();
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, nickName);
strut.AddTagKey(TagName.CARD_nickname, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[0] = strut;
return(Message.COMMON_MES_RESP(structList, Msg_Category.CARD_ADMIN, ServiceKey.CARD_USERNICK_QUERY_RESP, 1));
}
else
{
return(Message.COMMON_MES_RESP(lg.CardDetail_NoRegisterInfo, Msg_Category.CARD_ADMIN, ServiceKey.CARD_USERNICK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.CardDetail_NoRegisterInfo, Msg_Category.CARD_ADMIN, ServiceKey.CARD_USERNICK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 玩家人物资料信息
/// </summary>
/// <returns></returns>
public Message friendsnick_Query()
{
string serverIP = null;
string account = null;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + " " + account + lg.SDOAPI_SDOCharacterInfoAPI_FriendList + "!");
ds = CharacterInfo.friendsnick_Query(serverIP, account);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.SDO_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_FRIENDS_QUERY_RESP, 1));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NoFriendList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_FRIENDS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NoFriendList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_FRIENDS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看玩家消费记录
/// </summary>
/// <returns></returns>
public Message UserConsume_QuerySum()
{
string serverIP = null;
string account = null;
DateTime beginDate;
DateTime endDate;
int kind = -1;
int buyType = -1;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_ServerIP).m_bValueBuffer);
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_UserID).m_bValueBuffer);
TLV_Structure tlvStrut = new TLV_Structure(TagName.o2jam_KIND, 4, msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_KIND).m_bValueBuffer);
kind = (int)tlvStrut.toInteger();
tlvStrut = new TLV_Structure(TagName.O2JAM_BuyType, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM_BuyType).m_bValueBuffer);
buyType = (int)tlvStrut.toInteger();
tlvStrut = new TLV_Structure(TagName.o2jam_BeginDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_BeginDate).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.o2jam_EndDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_EndDate).m_bValueBuffer);
endDate = tlvStrut.toDate();
SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_ItemShopInfoAPI_SumConsumeRecord);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_ItemShopInfoAPI_SumConsumeRecord);
ds = ItemShopInfo.userConsume_QuerySum(serverIP, account, kind, buyType, beginDate, endDate);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[1];
Query_Structure strut = new Query_Structure(2);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[0].ItemArray[0]);
strut.AddTagKey(TagName.o2jam_GEM, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[0].ItemArray[1]);
strut.AddTagKey(TagName.o2jam_MCASH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[0] = strut;
return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_SUM_QUERY_RESP, 2));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM_ItemShopInfoAPI_NoSumConsumeRecord, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_SUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception)
{
return(Message.COMMON_MES_RESP(lg.O2JAM_ItemShopInfoAPI_NoSumConsumeRecord, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_SUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 请求所有游戏服务器IP列表
/// </summary>
/// <returns></returns>
public Message packServerInfoALLResp()
{
DataSet ds = CommonInfo.serverIP_QueryAll();
if (ds != null && ds.Tables[0].Rows.Count <= 0)
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_GameListEmpty, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
else
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.ServerInfo_Idx, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.ServerInfo_IP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.ServerInfo_City, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.ServerInfo_GameID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.ServerInfo_GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[5]);
strut.AddTagKey(TagName.ServerInfo_GameDBID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[6]);
strut.AddTagKey(TagName.ServerInfo_GameFlag, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, 7));
}
}
/// <summary>
/// 得到所有模块信息
/// </summary>
/// <returns>模块数据集</returns>
public Message GM_QueryAll(int index, int pageSize)
{
GMLogAPI logAPI = new GMLogAPI();
DataSet ds = null;
try
{
logAPI.writeTitle(LanguageAPI.API_Display + LanguageAPI.API_ModuleInfoAPI_ModuleList, LanguageAPI.API_Display + LanguageAPI.API_ModuleInfoAPI_ModuleList);
logAPI.writeContent(LanguageAPI.API_GameInfoAPI_ModuleID, LanguageAPI.API_GameInfoAPI_ModuleTitle, LanguageAPI.API_GameInfoAPI_ModuleClass, LanguageAPI.API_GameInfoAPI_ModuleDesp);
ds = GMModuleInfo.SelectAll();
if (ds.Tables[0].Rows.Count <= 0)
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_ModuleInfoAPI_NoModuleList, Msg_Category.MODULE_ADMIN, ServiceKey.MODULE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
else
{
//总页数
int pageCount = 0;
pageCount = ds.Tables[0].Rows.Count % pageSize;
if (pageCount > 0)
{
pageCount = ds.Tables[0].Rows.Count / pageSize + 1;
}
else
{
pageCount = ds.Tables[0].Rows.Count / pageSize;
}
if (index + pageSize > ds.Tables[0].Rows.Count)
{
pageSize = ds.Tables[0].Rows.Count - index;
}
Query_Structure[] structList = new Query_Structure[pageSize];
for (int i = index; i < index + pageSize; i++)
{
Query_Structure strut = new Query_Structure(7);
strut.AddTagKey(TagName.GameID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]));
strut.AddTagKey(TagName.Module_ID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]));
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.ModuleName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.ModuleClass, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[5]);
strut.AddTagKey(TagName.ModuleContent, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
//总页数
strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount));
structList[i - index] = strut;
logAPI.writeData(ds.Tables[0].Rows[i].ItemArray[1].ToString(), ds.Tables[0].Rows[i].ItemArray[2].ToString(), ds.Tables[0].Rows[i].ItemArray[3].ToString(), ds.Tables[0].Rows[i].ItemArray[4].ToString());
}
Console.Write(logAPI.Buffer.ToString());
return(Message.COMMON_MES_RESP(structList, Msg_Category.MODULE_ADMIN, ServiceKey.MODULE_QUERY_RESP, 7));
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.MODULE_ADMIN, ServiceKey.MODULE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary->
/// 玩家积分查询
/// </summary>
/// <returns></returns>
public Message UserIntegral_Query()
{
string serverIP = null;
string account = null;
System.Data.DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_userid).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.NineYou + lg.CardDetail_Account + account + lg.UserCashPurchase_Integral);
Console.WriteLine(DateTime.Now + " -" + lg.API_Display + lg.NineYou + lg.CardDetail_Account + account + lg.UserCashPurchase_Integral);
ds = UserCashPurchase.UserIntegral_Query(serverIP, account);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.AuShop_username, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[1]));
strut.AddTagKey(TagName.AuShop_aup, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]));
strut.AddTagKey(TagName.AuShop_usefeesum, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]));
strut.AddTagKey(TagName.AuShop_useaupsum, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4]));
strut.AddTagKey(TagName.AuShop_buyitemsum, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERINTERGRAL_QUERY_RESP, 5));
}
else
{
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoIntegral, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERINTERGRAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoIntegral, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERINTERGRAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary->
/// 道具回收兑换详细记录
/// </summary>
/// <returns></returns>
public Message UserAvatarItemRevDetail_Query()
{
string serverIP = null;
string orderID = null;
System.Data.DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
orderID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_orderid).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.NineYou + lg.CardDetail_Account + orderID + lg.UserCashPurchase_ItemChangeDetails);
Console.WriteLine(DateTime.Now + " -" + lg.API_Display + lg.NineYou + lg.CardDetail_Account + orderID + lg.UserCashPurchase_ItemChangeDetails);
ds = UserCashPurchase.UserAvatarItemRevDetail_Query(serverIP, orderID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[0].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.AuShop_pname, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.AuShop_username, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.AuShop_getusername, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[3]));
strut.AddTagKey(TagName.AuShop_buytime2, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.AuShop_zone, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_AVATARECOVER_DETAIL_QUERY_RESP, 5));
}
else
{
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoItemChangeDetails, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_AVATARECOVER_DETAIL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoItemChangeDetails, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_AVATARECOVER_DETAIL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// lg.SDAPI_SDItemLogInfoAPI_Account+lg.SDAPI_SDItemShopAPI_ConsumeRecord
/// </summary>
/// <returns>Messagebody</returns>
public Message SD_Card_Info_Query()
{
string activeCode = null;
string userName = null;
string typeName = null;
string strDesc = null;
int type = -1;
System.Collections.ArrayList ds = new System.Collections.ArrayList();
try
{
activeCode = Encoding.Unicode.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SD_ActiceCode).m_bValueBuffer);
//用户名
userName = Encoding.Unicode.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SD_UserName).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemShopAPI_ConsumeRecord + activeCode + lg.Logic_Exception_ExpectedValue + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!");
Console.WriteLine(DateTime.Now + lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemShopAPI_ConsumeRecord + activeCode + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!");
ds = SDAccountInfo.Card_Info_Query(userName, activeCode, ref strDesc);
if (ds != null && ds.Count > 0)
{
Query_Structure[] structList = new Query_Structure[1];
Query_Structure strut = new Query_Structure((uint)ds.Count);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[0]);
strut.AddTagKey(TagName.SD_ActiceCode, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[1]);
strut.AddTagKey(TagName.SD_passWd, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[2]);
strut.AddTagKey(TagName.SD_UserName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[3]);
strut.AddTagKey(TagName.SD_ServerName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds[4]));
strut.AddTagKey(TagName.SD_Time, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds[5]));
strut.AddTagKey(TagName.SD_ServerIP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
if (ds[6].ToString() == "1")
{
typeName = "新手卡";
}
else
{
typeName = "鑽石卡";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, typeName);
strut.AddTagKey(TagName.Magic_TypeName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[0] = strut;
return(Message.COMMON_MES_RESP(structList, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, 7));
}
else
{
return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception)
{
return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看玩家上下线状态
/// </summary>
/// <returns></returns>
public Message UserOnline_Query()
{
string serverIP = null;
string account = null;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer);
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + account + lg.O2JAM2API_ItemShopAPI_OnlineStatus);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + account + lg.O2JAM2API_ItemShopAPI_OnlineStatus);
ds = ItemShopInfo.userOnline_Query(serverIP, account);
if (ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.O2JAM2_UserIndexID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.O2JAM2_UserID, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.SDO_LoginTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.SDO_LogoutTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM2_ADMIN, ServiceKey.SDO_USERONLINE_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoOnlineStatus, Msg_Category.O2JAM2_ADMIN, ServiceKey.SDO_USERONLINE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoOnlineStatus, Msg_Category.O2JAM2_ADMIN, ServiceKey.SDO_USERONLINE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 即时查看玩家当前状态(服务器/房间/在线状态)
/// </summary>
/// <returns></returns>
public Message SDO_login_Query()
{
string serverIP = null;
string account = null;
DataSet ds = null;
try
{
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDOItemLogInfoAPI_Account + account + lg.SDOAPI_SDOMemberInfoAPI_CurrentState + "!");
ds = MemberInfo.T_o2jam_login_Query(serverIP, account);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]);
strut1.AddTagKey(TagName.SDO_Account, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]);
strut1.AddTagKey(TagName.SDO_MAINCH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]);
strut1.AddTagKey(TagName.SDO_SUBCH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]);
strut1.AddTagKey(TagName.SDO_ipaddr, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut1;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERLOGIN_STATUS_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOMemberInfoAPI_NoCurrentInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERLOGIN_STATUS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception e)
{
Console.WriteLine(e.Message);
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOMemberInfoAPI_NoCurrentInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERLOGIN_STATUS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查询所有的技能道具
/// </summary>
/// <returns></returns>
public Message Soccer_Item_Skill_Blur_Query()
{
System.Data.DataSet ds = null;
int item_type = 1;
string Content = null;
try
{
SqlHelper.log.WriteLog("劲爆足球+>" + "查询所有道具!");
Console.WriteLine(DateTime.Now + " - 劲爆足球+>服务器地址" + "查询所有道具!");
Content = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_content).m_bValueBuffer);
ds = SOCCERItemShopInfo.Soccer_Item_Skill_Blur_Query(item_type, Content);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]));
strut1.AddTagKey(TagName.Soccer_idx, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[1]));
strut1.AddTagKey(TagName.Soccer_i_name, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[2]));
strut1.AddTagKey(TagName.Soccer_body_part, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]));
strut1.AddTagKey(TagName.Soccer_item_type, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
structList[i] = strut1;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ITEM_SKILL_BLUR_QUERY_RESP, 4));
}
else
{
return(Message.COMMON_MES_RESP("没有道具列表!", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ITEM_SKILL_BLUR_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP("没有道具列表!", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ITEM_SKILL_BLUR_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 得到该用户所在部门的所拥有的游戏
/// </summary>
/// <returns></returns>
public Message GM_QueryDepartRelateGameInfo()
{
int userID = 0;
System.Data.DataSet ds = null;
GMLogAPI logAPI = new GMLogAPI();
try
{
TLV_Structure tlvStrut = new TLV_Structure(TagName.User_ID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.User_ID).m_bValueBuffer);
userID = (int)tlvStrut.toInteger();
SqlHelper.log.WriteLog(LanguageAPI.API_DepartmentAPI_HoldGame);
Console.WriteLine(DateTime.Now + " - " + LanguageAPI.API_DepartmentAPI_HoldGame);
ds = GMDepartmentInfo.getDepartRelateGameInfo(userID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length);
strut.AddTagKey(TagName.GameID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]));
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
Console.Write(logAPI.Buffer.ToString());
return(Message.COMMON_MES_RESP(structList, Msg_Category.USER_ADMIN, ServiceKey.DEPART_RELATE_GAME_QUERY_RESP, 2));
}
else
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_DepartmentAPI_NoDepInfo, Msg_Category.USER_ADMIN, ServiceKey.DEPART_RELATE_GAME_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(LanguageAPI.API_DepartmentAPI_NoDepInfo, Msg_Category.USER_ADMIN, ServiceKey.DEPART_RELATE_GAME_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// lg.SDAPI_SDItemLogInfoAPI_Account+lg.SDAPI_SDItemLogInfoAPI_Sumlg.SDAPI_SDItemShopAPI_Integral+
/// </summary>
/// <returns>Messagebody</returns>
public Message SDUserActiveCode_Query()
{
string activeCode = null;
string strDesc = null;
System.Collections.ArrayList ds = new System.Collections.ArrayList();
try
{
activeCode = Encoding.Unicode.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SD_ActiceCode).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemLogInfoAPI_Sum + activeCode + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!");
Console.WriteLine(DateTime.Now + lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemLogInfoAPI_Sum + activeCode + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!");
ds = SDAccountInfo.ActiveCode_Query(activeCode, 1, ref strDesc);
if (ds != null && ds.Count > 0)
{
Query_Structure[] structList = new Query_Structure[1];
Query_Structure strut = new Query_Structure((uint)ds.Count);
byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[0]);
strut.AddTagKey(TagName.SD_ActiceCode, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[1]);
strut.AddTagKey(TagName.SD_GoldAccount, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[2]);
strut.AddTagKey(TagName.SD_IsUsed, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[3]);
strut.AddTagKey(TagName.SD_UserName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds[4]));
strut.AddTagKey(TagName.SD_UseDate, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[0] = strut;
return(Message.COMMON_MES_RESP(structList, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, 5));
}
else
{
return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception)
{
return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}