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