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