private void ButReject_Click(object sender, EventArgs e) { try { if (RegistName.Text.Trim().Equals("")) { MessageBox.Show("用户名不能为空!", "提示"); RegistName.Focus(); } else if (PassWord.Text.Trim().Equals("")) { MessageBox.Show("密码不能为空!", "提示"); PassWord.Focus(); } else if (UserName(RegistName.Text.Trim())) { MessageBox.Show("用户名已经存在!", "提示"); ClearAll(); } else { string sqlStr = "insert user_info (userName, userPwd, roles) values('" + RegistName.Text.Trim() + "','" + PassWord.Text.Trim() + "','" + RolesBox.Text.Trim() + "')"; if (DBconn.PDData(sqlStr)) { MessageBox.Show("用户" + RegistName.Text.Trim() + "注册成功!"); } this.Close(); } }catch (Exception ex) { DBconn.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); } }
// 修改按钮 private void userGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { // 验证选择行 if (userGridView.Columns[e.ColumnIndex].Name == "Modify" && e.ColumnIndex >= 0) { // 获取需要修改的用户信息 string userId = userGridView.CurrentRow.Cells[0].Value.ToString().Trim(); string userName = userGridView.CurrentRow.Cells[1].Value.ToString().Trim(); string userPwd = userGridView.CurrentRow.Cells[2].Value.ToString().Trim(); string userRoles = userGridView[3, e.RowIndex].EditedFormattedValue.ToString(); if (userName.Equals("")) { MessageBox.Show("用户名不能为空!"); return; } else if (userPwd.Equals("")) { MessageBox.Show("用户密码不能为空!"); return; } else if (userRoles.Equals("")) { MessageBox.Show("用户角色不能为空!"); return; } else { // 在数据库中修改 string sql = "update user_info set userName = '******', userPwd = '" + userPwd + "', roles = '" + userRoles + "' where userId = '" + int.Parse(userId) + "'"; //DataSet dataSet = DBconn.upData(sql); if (DBconn.PDData(sql)) { MessageBox.Show("用户:" + userName + " 修改成功"); } } } }catch (Exception ex) { MessageBox.Show("修改失败:" + ex.Message); } finally { // 关闭数据库连接 DBconn.conn.Close(); } }