private static void SaveTableNicknameInfo(bool isValid, int dataVersion, byte[] data)
{
object _msg;
if(DbDataSerializer.Decode(data, typeof(TableNicknameInfo), out _msg)){
TableNicknameInfo msg = _msg as TableNicknameInfo;
try {
using (MySqlCommand cmd = new MySqlCommand()) {
cmd.Connection = DBConn.MySqlConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SaveTableNicknameInfo";
MySqlParameter inputParam;
inputParam = new MySqlParameter("@_IsValid", MySqlDbType.Bit);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = isValid;
cmd.Parameters.Add(inputParam);
inputParam = new MySqlParameter("@_DataVersion", MySqlDbType.Int32);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = dataVersion;
cmd.Parameters.Add(inputParam);
inputParam = new MySqlParameter("@_Nickname", MySqlDbType.VarChar);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = msg.Nickname;
inputParam.Size = 32;
cmd.Parameters.Add(inputParam);
inputParam = new MySqlParameter("@_UserGuid", MySqlDbType.UInt64);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = msg.UserGuid;
cmd.Parameters.Add(inputParam);
cmd.ExecuteNonQuery();
}
} catch (Exception ex) {
DBConn.Close();
throw ex;
}
}
}