private void btn_accountcheck_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd = new SqlCommand(SqlSelect.UserCheckmethod(), con); cmd.Parameters.AddWithValue("@username", tb_account.Text); con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); DataSet ds = new DataSet(); con.Close(); if (dataReader.Read()) { if (dataReader[0].ToString() == "0") { MessageBox.Show("帳號可以使用"); return; } else { MessageBox.Show("帳號已被使用"); return; } } }
private void frm_grant_sa_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd = new SqlCommand(SqlSelect.GrantLoadlocalusermethod(), con); cmd.Parameters.AddWithValue("@username", Account); con.Open(); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapt.Fill(ds); con.Close(); dgv_grant_sa_localuser.DataSource = ds.Tables[0]; SqlConnection con1 = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd1 = new SqlCommand(SqlSelect.GrantLoadAllusermethod(), con1); con1.Open(); SqlDataAdapter adapt1 = new SqlDataAdapter(cmd1); DataSet ds1 = new DataSet(); adapt1.Fill(ds1); con.Close(); dgv_grant_sa_alluser.DataSource = ds1.Tables[0]; }
private void btn_accept_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd = new SqlCommand(SqlInsert.Addusermethod(), con); cmd.Parameters.AddWithValue("@username", tb_account.Text); cmd.Parameters.AddWithValue("@password", tb_password.Text); cmd.Parameters.AddWithValue("@grant", cb_group.Text); cmd.Parameters.AddWithValue("@email", tb_email.Text); con.Open(); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapt.Fill(ds); con.Close(); MessageBox.Show("新增成功"); this.Close(); }
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } if (dgv_grant_sa_alluser.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "SendEmail") { frm_grant_changepassword changepassword = new frm_grant_changepassword(Account, Accountpassword); changepassword.ShowDialog(); } if (dgv_grant_sa_alluser.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Delete") { DialogResult dr = MessageBox.Show("刪除帳號", "確定刪除嗎?", MessageBoxButtons.OKCancel); switch (dr) { case DialogResult.OK: SqlConnection con = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd = new SqlCommand(SqlDelete.AlluserDeletemethod(), con); cmd.Parameters.AddWithValue("@username", dgv_grant_sa_alluser.Rows[e.RowIndex].Cells[e.ColumnIndex + 1].Value); con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("刪除成功"); dgv_grant_sa_alluser.DataSource = null; SqlConnection con1 = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd1 = new SqlCommand(SqlSelect.GrantLoadAllusermethod(), con1); con1.Open(); SqlDataAdapter adapt1 = new SqlDataAdapter(cmd1); DataSet ds1 = new DataSet(); adapt1.Fill(ds1); con.Close(); dgv_grant_sa_alluser.DataSource = ds1.Tables[0]; break; case DialogResult.Cancel: break; } } }
private void btn_changepassword_Click(object sender, EventArgs e) { try { if (pb_oldpassword_correct.Visible == true && pb_newpassword_correct.Visible == true && pb_newpasswordcheck_correct.Visible == true) { SqlConnection con = new SqlConnection(SqlLink.linkmethod()); SqlCommand cmd = new SqlCommand(SqlUpdate.ChangePasswordmethod(), con); cmd.Parameters.AddWithValue("@username", Account); cmd.Parameters.AddWithValue("@password", tb_newpassword.Text); con.Open(); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapt.Fill(ds); con.Close(); MessageBox.Show("修改成功。"); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }