public PayReward(string account, PayRewardType rewardType, int rewardId, int readNum, DateTime startTime, DateTime endTime)
{
_account = account;
_rewardType = rewardType;
_rewardId = rewardId;
_read = readNum;
_startTime = startTime;
_endTime = endTime;
}
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();
}
}
