Example #1
0
        public bool SavePlayer(Player player)
        {
            string       id           = player.id;
            PlayersubCmd playersubCmd = player.subCmd;
            IFormatter   formatter    = new BinaryFormatter();
            MemoryStream stream       = new MemoryStream();

            try
            {
                formatter.Serialize(stream, playersubCmd);
            }
            catch (SerializationException e)
            {
                Console.WriteLine("[subCmdMgr] SavePlayer 序列化:" + e.Message);
                return(false);
            }
            byte[]       byteArray = stream.ToArray();
            string       cmdStr    = string.Format("update player set subCmd=@subCmd where id='{0}';", id);
            MySqlCommand sqlCom    = new MySqlCommand(cmdStr, sqlCon);

            sqlCom.Parameters.Add("@subCmd", MySqlDbType.Blob);
            sqlCom.Parameters[0].Value = byteArray;
            try
            {
                sqlCom.ExecuteNonQuery();
                return(true);
            }
            catch (Exception e)
            {
                Console.WriteLine("[subCmdMgr] SavePlayer:" + e.Message);
                return(false);
            }
        }
Example #2
0
        public PlayersubCmd GetPlayersubCmd(string id)
        {
            PlayersubCmd playersubCmd = new PlayersubCmd();
            string       cmdStr       = string.Format("select * from player where id='{0}';", id);
            MySqlCommand sqlCom       = new MySqlCommand(cmdStr, sqlCon);

            byte[] buffer = new byte[1];
            try
            {
                MySqlDataReader subCmdReader = sqlCom.ExecuteReader();
                if (!subCmdReader.HasRows)
                {
                    subCmdReader.Close();
                    return(playersubCmd);
                }
                subCmdReader.Read();
                long len = subCmdReader.GetBytes(1, 0, null, 0, 0);
                buffer = new byte[len];
                subCmdReader.GetBytes(1, 0, buffer, 0, (int)len);
                subCmdReader.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine("[subCmdMgr] GetPlayersubCmd:" + e.Message);
                return(playersubCmd);
            }
            MemoryStream stream = new MemoryStream(buffer);

            try
            {
                BinaryFormatter formatter = new BinaryFormatter();
                playersubCmd = (PlayersubCmd)formatter.Deserialize(stream);
                return(playersubCmd);
            }
            catch (SerializationException e)
            {
                Console.WriteLine("[subCmdMgr] GetPlayersubCmd 反序列化:" + e.Message);
                return(playersubCmd);
            }
        }
Example #3
0
 public Player()
 {
     this.subCmd = new PlayersubCmd();
 }