private void button_Register_Click(object sender, EventArgs e) { // 邮箱格式正则表达式 string email = textBox_UserEmail.Text; string emailStr = @"([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,5})+"; if (textBox_UserName.Text == "") { MessageBox.Show("用户名不能为空"); } else if (textBox_UserPass.Text == "") { MessageBox.Show("请输入密码"); } else if (textBox_UserPassCheck.Text == "") { MessageBox.Show("请确认密码"); } else if (comboBox_UserType.Text == "") { MessageBox.Show("请选择新用户类型"); } else if (textBox_UserPass.Text != textBox_UserPassCheck.Text) { MessageBox.Show("密码有误!"); } else if (email != "" && !(System.Text.RegularExpressions.Regex.IsMatch(email, emailStr))) { MessageBox.Show("邮箱格式不正确", "提示"); } else if ((CurrentUserInfo.Type != "admin") && (comboBox_UserType.Text == "系统管理员")) { MessageBox.Show("您是普通用户,无权限注册系统管理员用户", "提示"); } else { // 用户类型字符串 string userType = "user"; if (comboBox_UserType.Text == "系统管理员") { userType = "admin"; } try { // SQL string sql = "insert into user_info (user_name, user_pass, user_type, reg_date, user_email) values('" + textBox_UserName.Text + "','" + textBox_UserPass.Text + "','" + userType + "','" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','" + textBox_UserEmail.Text + "')"; string sql_check = "select * from user_info where user_name = '" + textBox_UserName.Text + "'"; // DataRead Process MySqlConnection conn = new MySqlConnection(MySqlHelper.getConn()); MySqlConnection conn_check = new MySqlConnection(MySqlHelper.getConn()); conn.Open(); conn_check.Open(); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlCommand cmd_check = new MySqlCommand(sql_check, conn_check); // 检查该用户名是否存在 MySqlDataReader sdr = cmd_check.ExecuteReader(); if (!sdr.Read()) // 数据库中无此用户名 { int i = 0; i = cmd.ExecuteNonQuery(); if (i > 0) { // Log LogHelper.generateLog("[新用户注册] " + comboBox_UserType.Text + " " + textBox_UserName.Text + " 注册成功"); MessageBox.Show("用户 " + textBox_UserName.Text + " 注册成功!"); this.Hide(); } else { MessageBox.Show("添加失败!"); } } else { MessageBox.Show("该用户已存在!"); } conn.Close(); } catch { MessageBox.Show("Error !"); } } }
private void button_Login_Click(object sender, EventArgs e) { //用户类型 string user_type = "user"; if (comboBox_UserType.Text == "用户") { user_type = "user"; } else if (comboBox_UserType.Text == "系统管理员") { user_type = "admin"; } // SQL string sql = "select * from user_info where user_name = '" + textBox_UserName.Text + "' and user_pass = '******' and user_type = '" + user_type + "'"; // DataRead Process MySqlConnection conn = new MySqlConnection(MySqlHelper.getConn()); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; MySqlDataReader sdr = cmd.ExecuteReader(); if (textBox_UserName.Text == "" || textBox_UserPass.Text == "") { MessageBox.Show("用户名或密码不能为空!"); } else if (comboBox_UserType.Text == "") { MessageBox.Show("请选择用户类型"); } else if (sdr.Read()) { CurrentUserInfo.Name = sdr.GetString(sdr.GetOrdinal("user_name")).Replace(" ", ""); CurrentUserInfo.Type = user_type; CurrentUserInfo.Id = Convert.ToInt32(sdr.GetString(sdr.GetOrdinal("user_id"))); conn.Close(); MessageBox.Show("欢迎您," + CurrentUserInfo.Name + "!", "登录成功!"); Application.OpenForms["Main"].Hide(); this.Hide(); // 登录身份 Main_Admin main_admin = new Main_Admin(); Main_User main_user = new Main_User(); if (CurrentUserInfo.Type == "admin") { main_admin.Show(); } else if (CurrentUserInfo.Type == "user") { main_user.Show(); } // Log LogHelper.generateLog(CurrentUserInfo.Name + " 登录"); } else { MessageBox.Show("对不起,你输入的账号或者密码错误!"); } }