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); }