private void button2_Click(object sender, EventArgs e) { //RegForm regForm = new RegForm(); //regForm.Show(); RegForm regForm = new RegForm(); // 注册事件 regForm.TransfEvent += regForm_TransfEvent; regForm.ShowDialog(); }
public void MakeNewUser(Dictionary <string, string> data, RegForm form) { string openKey = Convert.ToBase64String(Guid.NewGuid().ToByteArray()); string privateKey = Convert.ToBase64String(Guid.NewGuid().ToByteArray()); string insertionCommand = "INSERT into `users` (`fName`, `mName`, `lName`," + " `Score1`, `Score2`, `Score3`, `account`," + " `openKey`, `privateKey`)" + " VALUES (@f, @m, @l, @s1, @s2, @s3, @a, @o, @p)"; DB db = new DB(); MySqlCommand command = new MySqlCommand(insertionCommand, db.getConnection()); command.Parameters.Add("@f", MySqlDbType.VarChar).Value = data["firstName"]; command.Parameters.Add("@m", MySqlDbType.VarChar).Value = data["middleName"]; command.Parameters.Add("@l", MySqlDbType.VarChar).Value = data["lName"]; command.Parameters.Add("@s1", MySqlDbType.Int16).Value = data["score1"]; command.Parameters.Add("@s2", MySqlDbType.Int16).Value = data["score2"]; command.Parameters.Add("@s3", MySqlDbType.Int16).Value = data["score3"]; command.Parameters.Add("@a", MySqlDbType.VarChar).Value = "user"; command.Parameters.Add("@o", MySqlDbType.VarChar).Value = openKey; command.Parameters.Add("@p", MySqlDbType.VarChar).Value = privateKey; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Ok"); form.OpenKeyBox.Text = openKey; form.privateKeyBox.Text = privateKey; } else { MessageBox.Show("Не получилось создать."); } db.closeConnection(); return; }