public bool AddBuyMinerRecord(MinersBuyRecord record, CustomerMySqlTransaction trans)
        {
            MySqlCommand mycmd = null;

            try
            {
                mycmd = trans.CreateCommand();

                string cmdTextA = "insert into minersbuyrecord " +
                                  "(`UserID`, `SpendGoldCoin`, `GainMinersCount`, `Time`) values " +
                                  " (@UserID, @SpendGoldCoin, @GainMinersCount, @Time); ";

                mycmd.CommandText = cmdTextA;
                mycmd.Parameters.AddWithValue("@UserID", record.UserID);
                mycmd.Parameters.AddWithValue("@SpendGoldCoin", record.SpendGoldCoin);
                mycmd.Parameters.AddWithValue("@GainMinersCount", record.GainMinersCount);
                mycmd.Parameters.AddWithValue("@Time", record.Time);

                mycmd.ExecuteNonQuery();
                return(true);
            }
            finally
            {
                mycmd.Dispose();
            }
        }
Exemplo n.º 2
0
 public MinersBuyRecordUIModel(MinersBuyRecord parent)
 {
     ParentObject = parent;
 }