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