private static void SaveTableGlobalData(bool isValid, int dataVersion, byte[] data)
{
object _msg;
if(DbDataSerializer.Decode(data, typeof(TableGlobalData), out _msg)){
TableGlobalData msg = _msg as TableGlobalData;
try {
using (MySqlCommand cmd = new MySqlCommand()) {
cmd.Connection = DBConn.MySqlConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SaveTableGlobalData";
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("@_Key", MySqlDbType.VarChar);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = msg.Key;
inputParam.Size = 32;
cmd.Parameters.Add(inputParam);
inputParam = new MySqlParameter("@_IntValue", MySqlDbType.Int32);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = msg.IntValue;
cmd.Parameters.Add(inputParam);
inputParam = new MySqlParameter("@_FloatValue", MySqlDbType.Float);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = msg.FloatValue;
cmd.Parameters.Add(inputParam);
inputParam = new MySqlParameter("@_StrValue", MySqlDbType.VarChar);
inputParam.Direction = ParameterDirection.Input;
inputParam.Value = msg.StrValue;
inputParam.Size = 1024;
cmd.Parameters.Add(inputParam);
cmd.ExecuteNonQuery();
}
} catch (Exception ex) {
DBConn.Close();
throw ex;
}
}
}