private void apply_Click(object sender, EventArgs e) { if (user.Text != "" && password.Text != "") { AccountList addUser = new AccountList(); string getMD5 = MD5code(password.Text); string level = ""; if (account_admin.Checked == true) { level = "admin"; } else if (account_designer.Checked == true) { level = "design"; } else if (account_viewer.Checked == true) { level = "view"; } addUser.name = user.Text; addUser.pass = getMD5; addUser.level = level; option_account lForm1 = (option_account)this.Owner; lForm1.getUser = addUser; this.Close(); } }
private void cancel_Click(object sender, EventArgs e) { AccountList clearUser = new AccountList(); option_account lForm1 = (option_account)this.Owner; lForm1.getUser = clearUser; this.Close(); }
private void apply_Click(object sender, EventArgs e) { string user = textBox1.Text; string pass = textBox2.Text; string level = ""; string getMD5 = MD5code(pass); string connStr; database SQLstr = (database)memoryData.database[0]; connStr = "server=" + SQLstr.ip + ";port=" + SQLstr.port + ";uid=" + SQLstr.user + ";pwd=" + SQLstr.password + ";database=" + SQLstr.DBname; MySqlConnection conn = new MySqlConnection(connStr); MySqlCommand command = conn.CreateCommand(); try { conn.Open(); //連線MYSQL 取回要比對的資料 command.CommandText = "SELECT * FROM nico_db.user_data where name = '" + user + "' and pass ="******"'" + getMD5 + "'"; MySqlDataReader reader; reader = command.ExecuteReader(); if (reader.HasRows != false) { reader.Read(); level = (String)reader["level"]; if (level == "admin") { option_account le = new option_account(); le.MYSQL_str = connStr; le.Show(); conn.Close(); this.Close(); } else { conn.Close(); MessageBox.Show("need administrator account!"); } } else { conn.Close(); MessageBox.Show("user name or password error!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }