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