public void Create(PersonalExchangeHistory exchangeHistory)
{
var sql = @"insert into personalexchangehistory(userid, date, stockcode, stockname, price, account, tradetype, thoughts)
values(@userid, @date, @stockcode, @stockname, @price, @account, @tradetype, @thoughts);";
var parameters = new IDataParameter[]
{
new MySqlParameter("@userid", exchangeHistory.UserId),
new MySqlParameter("@date", exchangeHistory.Date.ToString(Setting.Date_Format_4y_2M_2d)),
new MySqlParameter("@stockcode", exchangeHistory.StockCode),
new MySqlParameter("@stockname", exchangeHistory.StockName),
new MySqlParameter("@price", exchangeHistory.Price),
new MySqlParameter("@account", exchangeHistory.Account),
new MySqlParameter("@tradetype", (int)exchangeHistory.TradeType),
new MySqlParameter("@thoughts", exchangeHistory.Thoughts),
};
var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, sql, parameters, CommandType.Text);
}
public void Update(PersonalExchangeHistory exchangeHistory)
{
throw new NotImplementedException();
}
