/// <summary> /// 根据玩家Id获取玩家拥有的符文 /// </summary> /// <param name="playerid"></param> /// <returns></returns> public List <PlayerInscriptionMessage> GetPlayerInscriptionListById(int playerid) { List <PlayerInscriptionMessage> inscriptionList = new List <PlayerInscriptionMessage>(); string get_sql = "select * from tb_playerinscriptionmessage where playerid=" + playerid.ToString() + " and inscriptionnumber > 0"; MySqlCommand mySqlCommand = new MySqlCommand(get_sql, mySqlConnection); MySqlDataReader reader = null; try { mySqlConnection.Open(); reader = mySqlCommand.ExecuteReader(); while (reader.Read()) { PlayerInscriptionMessage item = new PlayerInscriptionMessage(); item.PlayerId = int.Parse(reader[1].ToString()); item.InscriptionId = int.Parse(reader[2].ToString()); item.InscriptionNumber = int.Parse(reader[3].ToString()); item.InscriptionUserNumber = int.Parse(reader[3].ToString()); inscriptionList.Add(item); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { mySqlCommand.Dispose(); reader.Close(); mySqlConnection.Close(); } return(inscriptionList); }
/// <summary> /// 向数据库中插入数据 /// </summary> /// <param name="playerid"></param> /// <param name="playerInscriptionMessage"></param> public void InserPlayerInscription(int playerid, PlayerInscriptionMessage playerInscriptionMessage) { string get_sql = "insert into tb_playerinscriptionmessage(playerid,inscriptionid,inscriptionnumber,inscriptionusenumber) values" + "(" + playerid + "," + playerInscriptionMessage.InscriptionId + "," + playerInscriptionMessage.InscriptionNumber + ",0)"; MySqlCommand mySqlCommand = new MySqlCommand(get_sql, mySqlConnection); MySqlDataReader reader = null; bool flag = false; mySqlConnection.Open(); try { reader = mySqlCommand.ExecuteReader(); if (reader == null) { flag = false; } else { flag = true; } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { reader.Close(); } if (flag) { UpdatePlayerInscriptionNumber(playerid, playerInscriptionMessage.InscriptionId, playerInscriptionMessage.InscriptionNumber); } else { string insert_sql = "insert into tb_playerinscriptionmessage(playerid,inscriptionid,inscriptionnumber, inscriptionusenumber) values(" + playerid + "," + playerInscriptionMessage.InscriptionId + "," + playerInscriptionMessage.InscriptionNumber + ",0)"; MySqlCommand cmd = new MySqlCommand(insert_sql, mySqlConnection); try { mySqlConnection.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { mySqlConnection.Close(); cmd.Dispose(); } } }
public void UpdatePlayerInscription(int playerid, int inscriptionid, int inscriptionNumber) { if (FindPlayerInscription(playerid, inscriptionid)) { UpdatePlayerInscriptionNumber(playerid, inscriptionid, inscriptionNumber); } else { PlayerInscriptionMessage playerInscriptionMessage = new PlayerInscriptionMessage(); playerInscriptionMessage.PlayerId = playerid; playerInscriptionMessage.InscriptionId = inscriptionid; playerInscriptionMessage.InscriptionNumber = inscriptionNumber; playerInscriptionMessage.InscriptionUserNumber = 0; InserPlayerInscription(playerid, playerInscriptionMessage); } }