public int GetReadPrice(PayReward reward) { MySqlConnection connection = DAO.GetConnection(); int result = 0; try { connection.Open(); string cmdText = "SELECT read_num FROM pay_rewards WHERE account_name = ?account_name And reward_id=?reward_id And start_time=?start_time And end_time=?end_time"; MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection); mySqlCommand.Parameters.AddWithValue("?account_name", reward.AccountName); mySqlCommand.Parameters.AddWithValue("?reward_id", reward.RewardId); mySqlCommand.Parameters.AddWithValue("?start_time", reward.StartTime); mySqlCommand.Parameters.AddWithValue("?end_time", reward.EndTime); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); if (mySqlDataReader.Read()) { result = mySqlDataReader.GetInt32("read_num"); return(result); } return(result); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; log.Error((object)ex2.ToString()); ProjectData.ClearProjectError(); return(result); } finally { connection.Close(); } }
public void UpdataPayReward(PayReward reward, int price) { MySqlConnection connection = DAO.GetConnection(); try { connection.Open(); string cmdText = "UPDATE pay_rewards SET read_num=?read_num WHERE account_name = ?account_name And reward_id=?reward_id And start_time=?start_time And end_time=?end_time"; MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection); mySqlCommand.Parameters.AddWithValue("?read_num", price); mySqlCommand.Parameters.AddWithValue("?account_name", reward.AccountName); mySqlCommand.Parameters.AddWithValue("?reward_id", reward.RewardId); mySqlCommand.Parameters.AddWithValue("?start_time", reward.StartTime); mySqlCommand.Parameters.AddWithValue("?end_time", reward.EndTime); mySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; log.Error((object)ex2.ToString()); ProjectData.ClearProjectError(); } finally { connection.Close(); } }
public void InsertPayReward(PayReward pay) { MySqlConnection connection = DAO.GetConnection(); try { connection.Open(); string cmdText = "INSERT INTO pay_rewards(account_name, reward_type, pay_num, reward_id, read_num, start_time, end_time) VALUES (?account_name, ?reward_type, ?pay_num, ?reward_id, ?read_num, ?start_time, ?end_time) ON DUPLICATE KEY UPDATE pay_num=pay_num+?pay_num"; MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection); mySqlCommand.Parameters.AddWithValue("?account_name", pay.AccountName); mySqlCommand.Parameters.AddWithValue("?reward_type", pay.RewardType.ToString()); mySqlCommand.Parameters.AddWithValue("?pay_num", pay.PayNum); mySqlCommand.Parameters.AddWithValue("?reward_id", pay.RewardId); mySqlCommand.Parameters.AddWithValue("?read_num", pay.ReadNum); mySqlCommand.Parameters.AddWithValue("?start_time", pay.StartTime); mySqlCommand.Parameters.AddWithValue("?end_time", pay.EndTime); mySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; log.Error((object)ex2.ToString()); ProjectData.ClearProjectError(); } finally { connection.Close(); } }
internal void TaotalConsumHandle(GameConnection gs, int id, string accountName, string playerName, int cost) { PayRewardTemplate payRewardTemplate = _payRewards[id]; if (!Information.IsNothing(payRewardTemplate) && payRewardTemplate.IsActive() && payRewardTemplate.type == PayRewardType.TOTAL_CONSUM) { PayReward payReward = new PayReward(accountName, payRewardTemplate.type, id, 0, DateTime.Parse(payRewardTemplate.start_time), DateTime.Parse(payRewardTemplate.end_time)); payReward.PayNum = cost; DAOManager.PayRewardDAO.InsertPayReward(payReward); } }
private void InitializeReward() { List <PayInfo> list = DAOManager.PayInfoDAO.LoadPayInfo(); foreach (PayInfo item in list) { foreach (PayRewardTemplate item2 in ActiveRewards()) { if (item2.type != PayRewardType.TOTAL_CONSUM) { PayReward payReward = new PayReward(item.AccountName, item2.type, item2.id, 0, DateTime.Parse(item2.start_time), DateTime.Parse(item2.end_time)); payReward.PayNum = item.PayNum; DAOManager.PayRewardDAO.InsertPayReward(payReward); break; } } DAOManager.PayInfoDAO.DeletePay(item.AccountName); } }
public List <PayReward> LoadPayReward(string account) { List <PayReward> list = new List <PayReward>(); MySqlConnection connection = DAO.GetConnection(); try { connection.Open(); string cmdText = "SELECT * FROM pay_rewards WHERE account_name = ?account_name"; MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection); mySqlCommand.Parameters.AddWithValue("?account_name", account); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { PayRewardType rewardType = (PayRewardType)Conversions.ToInteger(Enum.Parse(typeof(PayRewardType), mySqlDataReader.GetString("reward_type"))); int @int = mySqlDataReader.GetInt32("pay_num"); int int2 = mySqlDataReader.GetInt32("reward_id"); int int3 = mySqlDataReader.GetInt32("read_num"); DateTime dateTime = mySqlDataReader.GetDateTime("start_time"); DateTime dateTime2 = mySqlDataReader.GetDateTime("end_time"); PayReward payReward = new PayReward(account, rewardType, int2, int3, dateTime, dateTime2); payReward.PayNum = @int; list.Add(payReward); } mySqlDataReader.Close(); return(list); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; log.Error((object)ex2.ToString()); ProjectData.ClearProjectError(); return(list); } finally { connection.Close(); } }
internal void SendRequest(GameConnection gs, string account, string playerName, PayReward pay, PayRewardGroup rd, string payName) { try { Interlocked.Increment(ref requestId); PayRequest payRequest = new PayRequest(requestId, account, playerName, pay, rd); activeRequest.Add(requestId, payRequest); gs.SendPacket(new SM_GS_SEND_PAYREWARD(payName, payRequest)); log.InfoFormat("发送: 角色名:{0} 充值或消费 {1} 商城币奖励 操作ID:{2}", (object)playerName, (object)rd.price, (object)payRequest.RequestId); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; log.Error((object)ex2.ToString()); ProjectData.ClearProjectError(); } }