/// <summary>
/// 查看玩家消费记录
/// </summary>
/// <returns></returns>
public Message UserConsume_QuerySum()
{
string serverIP = null;
string account = null;
DateTime beginDate;
DateTime endDate;
int moneyType = -1;
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);
TLV_Structure tlvStrut = new TLV_Structure(TagName.SDO_BeginTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_BeginTime).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.SDO_EndTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_EndTime).m_bValueBuffer);
endDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.SDO_MoneyType, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_MoneyType).m_bValueBuffer);
moneyType = (int)tlvStrut.toInteger();
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_SDOItemShopAPI_ConsumeRecord + "!");
ds = ItemShopInfo.userConsume_QuerySum(serverIP, account, moneyType, beginDate, endDate);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(Message.COMMON_MES_RESP(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]), Msg_Category.SDO_ADMIN, ServiceKey.SDO_CONSUME_QUERY_RESP, TagName.SDO_ChargeSum, TagFormat.TLV_INTEGER));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOItemShopAPI_NoChargeRecord, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERCONSUMESUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOItemShopAPI_NoChargeRecord, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERCONSUMESUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 玩家的充值明细合计
/// </summary>
/// <returns></returns>
public Message userChargeSum_Query()
{
System.Data.DataSet result = null;
string serverIP = null;
string account = null;
DateTime beginDate;
DateTime endDate;
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);
TLV_Structure tlvStrut = new TLV_Structure(TagName.SDO_BeginTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_BeginTime).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.SDO_EndTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_EndTime).m_bValueBuffer);
endDate = tlvStrut.toDate();
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_SDOItemLogInfoAPI_FillDetail + lg.SDOAPI_SDOItemLogInfoAPI_Sum + "!");
result = ItemLogInfo.userChargeSum_Query(serverIP, account, beginDate, endDate);
if (result != null && result.Tables[0].Rows.Count > 0)
{
return(Message.COMMON_MES_RESP(Convert.ToInt32(result.Tables[0].Rows[0].ItemArray[1]), Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERCHARAGESUM_QUERY_RESP, TagName.SDO_ChargeSum, TagFormat.TLV_INTEGER));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOItemLogInfoAPI_NoTotalValue, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERCHARAGESUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOItemLogInfoAPI_NoTotalValue, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERCHARAGESUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 插入一个新的GM帐号
/// </summary>
public Message GM_InsertUserInfo()
{
int result = -1;
int operateUserID = 0;
int departID = 0;
string userName = null;
string passWd = null;
string realName = null;
DateTime limit = DateTime.Now;
int status= 0;
try
{
//操作员ID
TLV_Structure strut = new TLV_Structure(TagName.UserByID,4,msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
operateUserID = (int)strut.toInteger();
//部门ID
strut = new TLV_Structure(TagName.DepartID,4,msg.m_packet.m_Body.getTLVByTag(TagName.DepartID).m_bValueBuffer);
departID = (int)strut.toInteger();
//用户名
userName = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.UserName).m_bValueBuffer);
//密码
passWd =Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.PassWord).m_bValueBuffer);
//中文名
realName =Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RealName).m_bValueBuffer);
//状态值
TLV_Structure tlvStruct = new TLV_Structure(TagName.User_Status,4,msg.m_packet.m_Body.getTLVByTag(TagName.User_Status).m_bValueBuffer);
status =(int)tlvStruct.toInteger();
//使用时限
tlvStruct = new TLV_Structure(TagName.Limit,3,msg.m_packet.m_Body.getTLVByTag(TagName.Limit).m_bValueBuffer);
limit =tlvStruct.toDate();
//是否管理员
tlvStruct = new TLV_Structure(TagName.SysAdmin,4,msg.m_packet.m_Body.getTLVByTag(TagName.SysAdmin).m_bValueBuffer);
int sysAdmin =(int)tlvStruct.toInteger();
result = GMUserInfo.insertRow(operateUserID,departID,userName,passWd,realName,limit,status,sysAdmin);
if(result==1)
{
logAPI.writeTitle(LanguageAPI.API_Add + LanguageAPI.API_UserInfoAPI_AccountInfo,LanguageAPI.API_Add + LanguageAPI.API_UserInfoAPI_AccountInfo + LanguageAPI.API_Success + "!");
logAPI.writeContent(LanguageAPI.Logic_UserValidate_User,LanguageAPI.API_UserInfoAPI_Password,LanguageAPI.API_UserInfoAPI_LimitDay);
logAPI.writeData(userName,passWd,limit.ToString());
Console.WriteLine(logAPI.Buffer.ToString());
return Message.Common_USER_CREATE_RESP("SUCESS");
}
else
{
logAPI.writeTitle(LanguageAPI.API_Add + LanguageAPI.API_UserInfoAPI_AccountInfo,LanguageAPI.API_Add + LanguageAPI.API_UserInfoAPI_AccountInfo + LanguageAPI.API_Failure + "!");
logAPI.writeContent(LanguageAPI.Logic_UserValidate_User,LanguageAPI.API_UserInfoAPI_Password,LanguageAPI.API_UserInfoAPI_LimitDay);
logAPI.writeData(userName,passWd,limit.ToString());
Console.WriteLine(logAPI.Buffer.ToString());
return Message.Common_USER_CREATE_RESP("FAILURE");
}
}
catch(Common.Logic.Exception ex)
{
Console.WriteLine(ex.Message);
return Message.Common_USER_CREATE_RESP(ex.Message);
}
}
/// <summary>
/// 修改用户信息
/// </summary>
public Message GM_UpdateUserInfo()
{
int result = -1;
int deptID = 0;
int userID = 0;
int userByID = 0;
string realName = null;
int status = 0;
int onlineActive = 0;
int sysAdmin = 0;
DateTime limitTime;
try
{
TLV_Structure tlv = new TLV_Structure(TagName.User_ID,4,msg.m_packet.m_Body.getTLVByTag(TagName.User_ID).m_bValueBuffer);
userID =(int)tlv.toInteger();
tlv = new TLV_Structure(TagName.UserByID,4,msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
userByID =(int)tlv.toInteger();
tlv = new TLV_Structure(TagName.DepartID,4,msg.m_packet.m_Body.getTLVByTag(TagName.DepartID).m_bValueBuffer);
deptID =(int)tlv.toInteger();
realName = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RealName).m_bValueBuffer);
tlv = new TLV_Structure(TagName.Limit,3,msg.m_packet.m_Body.getTLVByTag(TagName.Limit).m_bValueBuffer);
limitTime =tlv.toDate();
tlv = new TLV_Structure(TagName.User_Status,4,msg.m_packet.m_Body.getTLVByTag(TagName.User_Status).m_bValueBuffer);
status =(int)tlv.toInteger();
tlv = new TLV_Structure(TagName.OnlineActive, 4, msg.m_packet.m_Body.getTLVByTag(TagName.OnlineActive).m_bValueBuffer);
onlineActive = (int)tlv.toInteger();
tlv = new TLV_Structure(TagName.SysAdmin, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SysAdmin).m_bValueBuffer);
sysAdmin = (int)tlv.toInteger();
result = GMUserInfo.UpdateRow(userByID, deptID, userID, realName, limitTime, status, onlineActive,sysAdmin);
if(result==1)
{
logAPI.writeTitle(LanguageAPI.API_Update + LanguageAPI.API_UserInfoAPI_AccountInfo,LanguageAPI.API_Update + LanguageAPI.API_UserInfoAPI_AccountInfo + LanguageAPI.API_Success + "!");
logAPI.writeContent(LanguageAPI.API_DepartmentAPI_OperatorID,LanguageAPI.API_UserInfoAPI_UserID,LanguageAPI.API_UserInfoAPI_LimitDay);
logAPI.writeData(Convert.ToString(userByID),Convert.ToString(userID),Convert.ToString(limitTime));
Console.WriteLine(logAPI.Buffer.ToString());
return Message.Common_USER_UPDATE_RESP("SUCESS");
}
else
{
logAPI.writeTitle(LanguageAPI.API_Update + LanguageAPI.API_UserInfoAPI_AccountInfo,LanguageAPI.API_Update + LanguageAPI.API_UserInfoAPI_AccountInfo + LanguageAPI.API_Failure + "!");
logAPI.writeContent(LanguageAPI.API_DepartmentAPI_OperatorID,LanguageAPI.API_UserInfoAPI_UserID,LanguageAPI.API_UserInfoAPI_LimitDay);
logAPI.writeData(Convert.ToString(userByID),Convert.ToString(userID),Convert.ToString(limitTime));
Console.WriteLine(logAPI.Buffer.ToString());
return Message.Common_USER_UPDATE_RESP("FAILURE");
}
}
catch(SqlException ex)
{
Console.WriteLine(ex.Message);
return Message.Common_USER_UPDATE_RESP(ex.Message);
}
}
/// <summary>
/// 添加玩家礼物盒上的道具
/// </summary>
/// <returns></returns>
public Message AvatarList_Insert()
{
int operateUserID = 0;
string serverIP = null;
int sendSN = 0;
string sendNick = null;
int itemCode = 0;
int recvSN = 0;
string recvNick = null;
string demo = null;
DateTime sendDate;
int result = -1;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
operateUserID = (int)strut.toInteger();
strut = new TLV_Structure(TagName.AU_ItemID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.AU_ItemID).m_bValueBuffer);
itemCode = (int)strut.toInteger();
strut = new TLV_Structure(TagName.AU_SendSN, 4, msg.m_packet.m_Body.getTLVByTag(TagName.AU_SendSN).m_bValueBuffer);
sendSN = (int)strut.toInteger();
sendNick = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_SendNick).m_bValueBuffer);
strut = new TLV_Structure(TagName.AU_RecvSN, 4, msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvSN).m_bValueBuffer);
recvSN = (int)strut.toInteger();
recvNick = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvNick).m_bValueBuffer);
strut = new TLV_Structure(TagName.AU_RecvDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvDate).m_bValueBuffer);
sendDate = strut.toDate();
demo = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_Demo).m_bValueBuffer);
result = AUAvatarListInfo.AvatarList_Insert(operateUserID, serverIP, sendSN, sendNick, itemCode, recvSN, recvNick, sendDate, demo);
if (result == 1)
{
SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + sendSN + "的道具" + itemCode + "添加成功!");
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + sendSN + "礼物盒的道具" + itemCode + "添加成功!");
return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_CREATE_RESP));
}
else
{
SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + sendSN + "的道具" + itemCode + "添加失败!");
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + sendSN + "的道具" + itemCode + "添加失败!");
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_CREATE_RESP));
}
}
catch (Common.Logic.Exception ex)
{
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_CREATE_RESP));
}
}
/// <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>
/// 添加玩家礼物盒上的道具
/// </summary>
/// <returns></returns>
public Message GiftBox_MessageItem_Add()
{
int operateUserID = 0;
int userIndexID = 0;
string serverIP = null;
int itemCode = 0;
string title = null;
string context = null;
int timesLimit = 0;
DateTime dateLimit;
int result = -1;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);
TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
operateUserID = (int)strut.toInteger();
strut = new TLV_Structure(TagName.SDO_ItemCode, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ItemCode).m_bValueBuffer);
itemCode = (int)strut.toInteger();
strut = new TLV_Structure(TagName.SDO_UserIndexID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_UserIndexID).m_bValueBuffer);
userIndexID = (int)strut.toInteger();
strut = new TLV_Structure(TagName.SDO_TimesLimit, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_TimesLimit).m_bValueBuffer);
timesLimit = (int)strut.toInteger();
strut = new TLV_Structure(TagName.SDO_DateLimit, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_DateLimit).m_bValueBuffer);
dateLimit = strut.toDate();
title = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Title).m_bValueBuffer);
context = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Context).m_bValueBuffer);
result = ItemShopInfo.giftBox_Insert(operateUserID, serverIP, userIndexID, itemCode, title, context, timesLimit, dateLimit);
if (result == 1)
{
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.API_Add + lg.SDOAPI_SDOItemLogInfoAPI_Account + userIndexID + lg.SDOAPI_SDOItemShopAPI_GiftItem + itemCode + lg.API_Success + "!");
return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.SDO_ADMIN, ServiceKey.SDO_GIFTBOX_CREATE_RESP));
}
else
{
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.API_Add + lg.SDOAPI_SDOItemLogInfoAPI_Account + userIndexID + lg.SDOAPI_SDOItemShopAPI_GiftItem + itemCode + lg.API_Failure + "!");
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.SDO_ADMIN, ServiceKey.SDO_GIFTBOX_CREATE_RESP));
}
}
catch (Common.Logic.Exception ex)
{
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GIFTBOX_CREATE_RESP));
}
}
/// <summary>
/// 查看玩家M币购买记录合计
/// </summary>
/// <returns></returns>
public Message UserMCashPurchase_QuerySum()
{
string serverIP = null;
string buyMan = null;
string presentMan = null;
DateTime beginDate;
DateTime endDate;
string sex = null;
int cateGory = 0;
string isPresent = null;
string isGift = null;
System.Data.DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
buyMan = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_username).m_bValueBuffer);
presentMan = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_getusername).m_bValueBuffer);
TLV_Structure tlvStrut = new TLV_Structure(TagName.AuShop_BeginDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_BeginDate).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.AuShop_EndDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_EndDate).m_bValueBuffer);
endDate = tlvStrut.toDate();
sex = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_psex).m_bValueBuffer);
isPresent = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_ispresent).m_bValueBuffer);
isGift = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_islover).m_bValueBuffer);
tlvStrut = new TLV_Structure(TagName.AuShop_pcategory, 4, msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_pcategory).m_bValueBuffer);
cateGory = (int)tlvStrut.toInteger();
SqlHelper.log.WriteLog(lg.API_Display + lg.NineYou + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.CardDetail_Account + buyMan + lg.UserCashPurchase_SumMCash);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.NineYou + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.CardDetail_Account + buyMan + lg.UserCashPurchase_SumMCash);
ds = UserCashPurchase.UserMCashPurchaseSum_Query(serverIP, buyMan, presentMan, beginDate, endDate, sex, cateGory, isGift, isPresent);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(Message.COMMON_MES_RESP(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]), Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERMPURCHASE_SUM_QUERY_RESP, TagName.AuShop_MCashSum, TagFormat.TLV_INTEGER));
}
else
{
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoSumMCash, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERMPURCHASE_SUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoSumMCash, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERMPURCHASE_SUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看玩家交易记录合计
/// </summary>
/// <returns></returns>
public Message UserTrade_QuerySum()
{
string serverIP = null;
string senderUserID = "";
string receiveserID = "";
string sendUserNick = "";
string recvUserNick = "";
DateTime beginDate;
DateTime endDate;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
senderUserID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_SendUserID).m_bValueBuffer);
receiveserID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvUserID).m_bValueBuffer);
if (senderUserID.Length < 0)
{
senderUserID = receiveserID;
}
sendUserNick = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_SendNick).m_bValueBuffer);
recvUserNick = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvNick).m_bValueBuffer);
TLV_Structure tlvStrut = new TLV_Structure(TagName.AU_BeginTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AU_BeginTime).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.AU_EndTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AU_EndTime).m_bValueBuffer);
endDate = tlvStrut.toDate();
SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + senderUserID + lg.AU_AUAvatarListAPI_SumTradeRecord);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + senderUserID + lg.AU_AUAvatarListAPI_SumTradeRecord);
ds = AUAvatarListInfo.userTradeSum_Query(serverIP, senderUserID, receiveserID, sendUserNick, recvUserNick, beginDate, endDate);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(Message.COMMON_MES_RESP(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]), Msg_Category.AU_ADMIN, ServiceKey.AU_USERCHARAGESUM_QUERY_RESP, TagName.AU_Cash, TagFormat.TLV_INTEGER));
}
else
{
return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoSumTradeRecord, Msg_Category.AU_ADMIN, ServiceKey.AU_USERCHARAGESUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoSumTradeRecord, Msg_Category.AU_ADMIN, ServiceKey.AU_USERCHARAGESUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 对NOTE邮件的处理
/// </summary>
/// <returns>邮件处理响应消息</returns>
public Message Notes_LetterProcess_Resp()
{
int result = -1;
int userByID = 0;
int letterID = 0;
int processMan = 0;
DateTime processDate;
int isProcess = 0;
int transmitMan = 0;
string reason = null;
try
{
TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
userByID = (int)strut.toInteger();
strut = new TLV_Structure(TagName.Letter_ID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Letter_ID).m_bValueBuffer);
letterID = (int)strut.toInteger();
strut = new TLV_Structure(TagName.Process_Man, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Process_Man).m_bValueBuffer);
processMan = (int)strut.toInteger();
strut = new TLV_Structure(TagName.Process_Date, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Process_Date).m_bValueBuffer);
processDate = strut.toDate();
strut = new TLV_Structure(TagName.Transmit_Man, 4, msg.m_packet.m_Body.getTLVByTag(TagName.Transmit_Man).m_bValueBuffer);
transmitMan = (int)strut.toInteger();
reason = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Process_Reason).m_bValueBuffer);
isProcess = 1;
result = GMNotesInfo.updateRow(userByID, letterID, processMan, processDate, transmitMan, isProcess, reason);
if (result == 1)
{
return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.NOTES_ADMIN, ServiceKey.NOTES_LETTER_PROCESS_RESP, TagName.Status, TagFormat.TLV_STRING));
}
else
{
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.NOTES_ADMIN, ServiceKey.NOTES_LETTER_PROCESS_RESP, TagName.Status, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_NotesInfoAPI_DealWithEmailFailure, Msg_Category.NOTES_ADMIN, ServiceKey.NOTES_LETTER_PROCESS_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 插入一个新的用户与模块关系数据
/// </summary>
public void GM_InsertUserModuleInfo()
{
int userID = 0;
int moduleID = 0;
try
{
TLV_Structure tlv1 = new TLV_Structure(TagName.User_ID, 3, msg.m_packet.m_Body.getTLVByTag(TagName.User_ID).m_bValueBuffer);
userID = (int)tlv1.toInteger();
TLV_Structure tlv2 = new TLV_Structure(TagName.Module_ID, 3, msg.m_packet.m_Body.getTLVByTag(TagName.Module_ID).m_bValueBuffer);
moduleID = (int)tlv2.toInteger();
TLV_Structure tlv = new TLV_Structure(TagName.Limit, 3, msg.m_packet.m_Body.getTLVByTag(TagName.Limit).m_bValueBuffer);
DateTime limit = tlv.toDate();
//GMUserInfo.insertRow(userName,passWd,mac,limit);
}
catch (Common.Logic.Exception ex)
{
Console.WriteLine(ex.Message);
}
}
/// <summary>
/// 查看玩家消费记录
/// </summary>
/// <returns></returns>
public Message UserConsume_Query(int index, int pageSize)
{
string serverIP = null;
string account = null;
DateTime beginDate;
DateTime endDate;
int kind = 0;
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_ConsumeRecord);
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_ConsumeRecord);
ds = ItemShopInfo.userConsume_Query(serverIP, account, kind, buyType, beginDate, endDate);
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, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.o2jam_UserID, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.o2jam_ITEM_INDEX_ID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.o2jam_ITEM_NAME, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.o2jam_GEM, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.o2jam_MCASH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[5]);
strut.AddTagKey(TagName.o2jam_REG_DATE, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[6]);
strut.AddTagKey(TagName.o2jam_ReceiverID, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[7]);
strut.AddTagKey(TagName.o2jam_ReceiverNickName, 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.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_QUERY_RESP, 9));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM_ItemShopInfoAPI_NoConsumeRecord, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception)
{
return(Message.COMMON_MES_RESP(lg.O2JAM_ItemShopInfoAPI_NoConsumeRecord, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 玩家的充值明细查询
/// </summary>
/// <returns></returns>
public Message userChargeDetail_Query(int index, int pageSize)
{
string serverIP = null;
string account = null;
DateTime beginDate;
DateTime endDate;
System.Data.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);
TLV_Structure tlvStrut = new TLV_Structure(TagName.SDO_BeginTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_BeginTime).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.SDO_EndTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_EndTime).m_bValueBuffer);
endDate = tlvStrut.toDate();
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_SDOItemLogInfoAPI_FillDetail + "!");
//请求玩家身上的道具
ds = ItemLogInfo.userChargeDetail_Query(serverIP, account, beginDate, endDate);
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 = 0; i < index + pageSize; i++)
{
Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1);
//用户ID
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_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.SDO_ShopTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
//充值金额
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.SDO_MCash, 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.SDO_ADMIN, ServiceKey.SDO_USERMCASH_QUERY_RESP, 3));
}
else
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOItemLogInfoAPI_NoChargeRecord, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERMCASH_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (Common.Logic.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOItemLogInfoAPI_NoChargeRecord, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERMCASH_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看玩家消费记录
/// </summary>
/// <returns></returns>
public Message UserConsume_Query(int index, int pageSize)
{
string serverIP = null;
string account = null;
DateTime beginDate;
DateTime endDate;
int moneyType = -1;
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);
TLV_Structure tlvStrut = new TLV_Structure(TagName.O2JAM2_BeginDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_BeginDate).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.O2JAM2_ENDDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ENDDate).m_bValueBuffer);
endDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.O2JAM2_ComsumeType, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ComsumeType).m_bValueBuffer);
moneyType = (int)tlvStrut.toInteger();
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_ConsumeRecord);
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_ConsumeRecord);
ds = ItemShopInfo.userConsume_Query(serverIP, account, moneyType, beginDate, endDate);
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_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.O2JAM2_ComsumeCode, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]);
strut.AddTagKey(TagName.O2JAM2_MoneyType, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.O2JAM2_MCash, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.O2JAM2_BeginDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
//使用期限
int daylimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4]);
if (daylimits == -1)
{
daylimits = 0;
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, daylimits);
strut.AddTagKey(TagName.O2JAM2_DayLimit, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
//使用次数
int timeslimits = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[5]);
if (timeslimits == -1)
{
timeslimits = 0;
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, timeslimits);
strut.AddTagKey(TagName.O2JAM2_Timeslimt, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[6]);
strut.AddTagKey(TagName.O2JAM2_ItemName, 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.O2JAM2_ADMIN, ServiceKey.O2JAM2_CONUMSE_QUERY_RESP, 8));
}
else
{
return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoConsumeRecord, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_CONUMSE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.O2JAM2_ADMIN, ServiceKey.O2JAM2_CONUMSE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看玩家交易记录
/// </summary>
/// <returns></returns>
public Message UserTrade_Query(int index, int pageSize)
{
string serverIP = null;
string senderUserID = "";
string receiveserID = "";
string sendUserNick = "";
string recvUserNick = "";
DateTime beginDate;
DateTime endDate;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer);
senderUserID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_SendUserID).m_bValueBuffer);
receiveserID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvUserID).m_bValueBuffer);
if (senderUserID.Length < 0)
{
senderUserID = receiveserID;
}
sendUserNick = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_SendNick).m_bValueBuffer);
recvUserNick = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_RecvNick).m_bValueBuffer);
TLV_Structure tlvStrut = new TLV_Structure(TagName.AU_BeginTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AU_BeginTime).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.AU_EndTime, 3, msg.m_packet.m_Body.getTLVByTag(TagName.AU_EndTime).m_bValueBuffer);
endDate = tlvStrut.toDate();
SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + senderUserID + lg.AU_AUAvatarListAPI_TradeRecord);
Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_Account + senderUserID + lg.AU_AUAvatarListAPI_TradeRecord);
ds = AUAvatarListInfo.userTrade_Query(serverIP, senderUserID, receiveserID, sendUserNick, recvUserNick, beginDate, endDate);
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_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]));
strut.AddTagKey(TagName.AU_SendSN, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[1]));
strut.AddTagKey(TagName.AU_RecvSN, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.AU_SendNick, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.AU_RecvNick, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[4]));
strut.AddTagKey(TagName.AU_SendDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[5]);
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[6]));
strut.AddTagKey(TagName.AU_Cash, 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.AU_ADMIN, ServiceKey.AU_ITEMSHOP_TRADE_QUERY_RESP, 8));
}
else
{
return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoTradeRecord, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_TRADE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoTradeRecord, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_TRADE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary->
/// 道具回收兑换记录
/// </summary>
/// <returns></returns>
public Message UserAvatarItemRev_Query(int index, int pageSize)
{
string serverIP = null;
string account = null;
DateTime begDate;
DateTime endDate;
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);
TLV_Structure tlvStrut = new TLV_Structure(TagName.AuShop_BeginDate, 4, msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_BeginDate).m_bValueBuffer);
begDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.AuShop_EndDate, 4, msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_EndDate).m_bValueBuffer);
endDate = tlvStrut.toDate();
SqlHelper.log.WriteLog(lg.API_Display + lg.NineYou + lg.CardDetail_Account + account + lg.UserCashPurchase_ItemChange);
Console.WriteLine(DateTime.Now + " -" + lg.API_Display + lg.NineYou + lg.CardDetail_Account + account + lg.UserCashPurchase_ItemChange);
ds = UserCashPurchase.UserAvatarItemRev_Query(serverIP, account, begDate, endDate);
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, 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_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[1]));
strut.AddTagKey(TagName.AuShop_pinttime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]);
strut.AddTagKey(TagName.AuShop_buyip, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]);
strut.AddTagKey(TagName.AuShop_pmark3, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4]));
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[5]));
strut.AddTagKey(TagName.AuShop_price, 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.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERMPURCHASE_QUERY_RESP, 7));
}
else
{
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoItemChange, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERMPURCHASE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoItemChange, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERMPURCHASE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查看工具操作记录
/// </summary>
/// <returns>工具操作记录消息集</returns>
public Message UserOperateLog_Query(int index, int pageSize)
{
int userID = 0;
DateTime beginDate;
DateTime endDate;
DataSet ds = null;
try
{
TLV_Structure tlvStrut = new TLV_Structure(TagName.User_ID, 4, message.m_packet.m_Body.getTLVByTag(TagName.User_ID).m_bValueBuffer);
userID = (int)tlvStrut.toInteger();
tlvStrut = new TLV_Structure(TagName.SDO_BeginTime, 3, message.m_packet.m_Body.getTLVByTag(TagName.BeginTime).m_bValueBuffer);
beginDate = tlvStrut.toDate();
tlvStrut = new TLV_Structure(TagName.SDO_EndTime, 3, message.m_packet.m_Body.getTLVByTag(TagName.EndTime).m_bValueBuffer);
endDate = tlvStrut.toDate();
ds = CommonInfo.OperateLog_Query(userID, beginDate, endDate);
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, ds.Tables[0].Rows[i].ItemArray[0]);
strut.AddTagKey(TagName.RealName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
string gameName;
if (ds.Tables[0].Rows[i].IsNull(1) == false)
{
gameName = ds.Tables[0].Rows[i].ItemArray[1].ToString();
}
else
{
gameName = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, gameName);
strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
string City;
if (ds.Tables[0].Rows[i].IsNull(2) == false)
{
City = ds.Tables[0].Rows[i].ItemArray[2].ToString();
}
else
{
City = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, City);
strut.AddTagKey(TagName.SDO_City, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
string RealAct;
if (ds.Tables[0].Rows[i].IsNull(3) == false)
{
RealAct = ds.Tables[0].Rows[i].ItemArray[3].ToString();
}
else
{
RealAct = "";
}
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, RealAct);
strut.AddTagKey(TagName.Real_ACT, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[4]);
strut.AddTagKey(TagName.ACT_Time, 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.COMMON, ServiceKey.GMTOOLS_OperateLog_Query_RESP, 6));
}
else
{
return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_NoLog, Msg_Category.COMMON, ServiceKey.GMTOOLS_OperateLog_Query_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (Common.Logic.Exception ex)
{
return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.COMMON, ServiceKey.GMTOOLS_OperateLog_Query_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}