private void button1_Click(object sender, EventArgs e)
{
if (this.listBox1.Items.Count != 0)
{
int iD = JawelList[JawelList.Count - 1].a_index + 1;
JawelStruct temp = new JawelStruct();
temp.a_index = iD;
JawelList.Add(temp);
this.listBox1.Items.Clear();
int num = JawelList.Count <JawelStruct>();
for (int i = 0; i < num; i++)
{
int iD2 = JawelList[i].a_index;
this.listBox1.Items.Add(iD2);
}
if (this.checkBox1.Checked)
{
//Mysql Insert
MySqlConnection mySqlConnection = new MySqlConnection("datasource=" + Host + ";port=3306;username="******";password="******";database=" + Database);
mySqlConnection.Open();
MySqlCommand mySqlCommand3 = new MySqlCommand(string.Concat(new object[]
{
"INSERT INTO t_jewel_data (a_index)VALUES('",
iD,
//"','1",
"');"
}), mySqlConnection);
mySqlCommand3.ExecuteNonQuery();
mySqlConnection.Close();
}
}
}
private void LoadListBox()
{
MySqlConnection mysqlCon = new MySqlConnection("datasource=" + Host + ";port=3306;username="******";password="******";database=" + Database);
mysqlCon.Open();
MySqlCommand Command = new MySqlCommand("SELECT * FROM t_jewel_data ORDER BY a_index ASC;", mysqlCon);
Command.ExecuteNonQuery();
MySqlDataReader Reader = Command.ExecuteReader();
while (Reader.Read())
{
JawelStruct temp = new JawelStruct();
temp.a_index = (int)Reader["a_index"];
temp.a_normal_compose_neednas = (long)Reader["a_normal_compose_neednas"];
temp.a_chaos_compose_neednas = (long)Reader["a_chaos_compose_neednas"];
temp.a_normal_compose_prob = (int)Reader["a_normal_compose_prob"];
temp.a_chaos_compose_prob = (int)Reader["a_chaos_compose_prob"];
temp.a_compose_normalToChaos_prob = (int)Reader["a_compose_normalToChaos_prob"];
temp.a_normal_plus2_prob = (int)Reader["a_normal_plus2_prob"];
temp.a_normal_plus3_prob = (int)Reader["a_normal_plus3_prob"];
temp.a_chaos_plus2_prob = (int)Reader["a_chaos_plus2_prob"];
temp.a_chaos_plus3_prob = (int)Reader["a_chaos_plus3_prob"];
temp.a_normal_minus1_prob = (int)Reader["a_normal_minus1_prob"];
temp.a_normal_minus2_prob = (int)Reader["a_normal_minus2_prob"];
temp.a_normal_minus3_prob = (int)Reader["a_normal_minus3_prob"];
temp.a_chaos_minus1_prob = (int)Reader["a_chaos_minus1_prob"];
temp.a_chaos_minus2_prob = (int)Reader["a_chaos_minus2_prob"];
temp.a_chaos_minus3_prob = (int)Reader["a_chaos_minus3_prob"];
JawelList.Add(temp);
}
listBox1.Items.Clear();
int sk = JawelList.Count();
for (int i = 0; i < sk; i++)
{
int ID = JawelList[i].a_index;
listBox1.Items.Add(ID);
}
mysqlCon.Close();
}