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