public bool AddAgentAwardRecord(AgentAwardRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "insert into agentawardrecord " +
" (`AgentID`, `AgentUserName`, `PlayerID`, `PlayerUserName`, `PlayerInchargeRMB`, `AgentAwardRMB`, `PlayerInchargeContent`, `Time`) " +
" values (@AgentID, @AgentUserName, @PlayerID, @PlayerUserName, @PlayerInchargeRMB, @AgentAwardRMB, @PlayerInchargeContent, @Time)";
mycmd = myTrans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@AgentID", record.AgentID);
mycmd.Parameters.AddWithValue("@AgentUserName", DESEncrypt.EncryptDES(record.AgentUserName));
mycmd.Parameters.AddWithValue("@PlayerID", record.PlayerID);
mycmd.Parameters.AddWithValue("@PlayerUserName", DESEncrypt.EncryptDES(record.PlayerUserName));
mycmd.Parameters.AddWithValue("@PlayerInchargeRMB", record.PlayerInchargeRMB);
mycmd.Parameters.AddWithValue("@AgentAwardRMB", record.AgentAwardRMB);
mycmd.Parameters.AddWithValue("@PlayerInchargeContent", record.PlayerInchargeContent);
mycmd.Parameters.AddWithValue("@Time", record.Time.ToDateTime());
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool PlayerRechargeRMB(PlayerInfo player, AgentAwardType awardType, decimal playerInchargeRMB, CustomerMySqlTransaction trans)
{
if (player.SimpleInfo.IsAgentReferred || player.FortuneInfo.Exp < 50 ||
player.SimpleInfo.AgentUserID == 0 ||
player.SimpleInfo.AgentReferredLevel == 0 || player.SimpleInfo.AgentReferredLevel > 2)
{
return(false);
}
var agent = GetReferredAgent(player);
if (agent == null)
{
return(false);
}
AgentAwardRecord record = new AgentAwardRecord();
record.AgentID = agent.ID;
record.AgentUserName = agent.Player.SimpleInfo.UserName;
record.PlayerID = player.SimpleInfo.UserID;
record.PlayerUserName = player.SimpleInfo.UserName;
record.Time = MyDateTime.FromDateTime(DateTime.Now);
switch (awardType)
{
case AgentAwardType.PlayerAgentExp:
record.PlayerInchargeRMB = 0;
record.AgentAwardRMB = 30 * GlobalConfig.GameConfig.Yuan_RMB;
record.PlayerInchargeContent = "玩家贡献值达到50奖励";
break;
case AgentAwardType.PlayerInchargeGoldCoin:
record.PlayerInchargeRMB = playerInchargeRMB;
if (player.SimpleInfo.AgentReferredLevel == 1)
{
record.AgentAwardRMB = 0.1m * playerInchargeRMB;
}
else if (player.SimpleInfo.AgentReferredLevel == 2)
{
record.AgentAwardRMB = 0.05m * playerInchargeRMB;
}
record.PlayerInchargeContent = "玩家用充值金币奖励";
break;
case AgentAwardType.PlayerInchargeMine:
record.PlayerInchargeRMB = playerInchargeRMB;
if (player.SimpleInfo.AgentReferredLevel == 1)
{
record.AgentAwardRMB = 0.1m * playerInchargeRMB;
}
else if (player.SimpleInfo.AgentReferredLevel == 2)
{
record.AgentAwardRMB = 0.05m * playerInchargeRMB;
}
record.PlayerInchargeContent = "玩家购买矿山奖励";
break;
default:
break;
}
if (record.AgentAwardRMB > 1)
{
DBProvider.AgentAwardRecordDBProvider.AddAgentAwardRecord(record, trans);
}
return(true);
}
