public bool AddExpChangeRecord(ExpChangeRecord record, CustomerMySqlTransaction myTrans) { MySqlCommand mycmd = null; try { mycmd = myTrans.CreateCommand(); string cmdTextA = "insert into expchangerecord " + "(`UserID`, `AddExp`, `NewExp`, `Time`, `OperContent` ) " + " values " + "(@UserID, @AddExp, @NewExp, @Time, @OperContent); "; mycmd.CommandText = cmdTextA; mycmd.Parameters.AddWithValue("@UserID", record.UserID); mycmd.Parameters.AddWithValue("@AddExp", record.AddExp); mycmd.Parameters.AddWithValue("@NewExp", record.NewExp); mycmd.Parameters.AddWithValue("@Time", record.Time.ToDateTime()); mycmd.Parameters.AddWithValue("@OperContent", record.OperContent); mycmd.ExecuteNonQuery(); return(true); } finally { mycmd.Dispose(); } }
public ExpChangeRecordUIModel(ExpChangeRecord parent) { this.ParentObject = parent; }