private void frmAbout_KeyDown(object sender, KeyEventArgs e) { string user = ttb.user; if (e.KeyCode == Keys.F12) { if (!ttb.bMahoamatkhau) { foreach (DataRow r in ttb.get_data("select * from " + user + ".d_dlogin").Tables[0].Rows) { try { ttb.execute_data("update " + user + ".d_dlogin set password_='" + ttb.encode(r["password_"].ToString()) + "' where id=" + decimal.Parse(r["id"].ToString())); } catch { } } ttb.upd_thongso(i_nhom, -13, "", "1"); MessageBox.Show("Đã mã hóa mật khẩu !", ttb.Msg); } else { MessageBox.Show("Mật khẩu đã mã hóa !", ttb.Msg); } } else if (e.KeyCode == Keys.F11) { if (ttb.bMahoamatkhau) { foreach (DataRow r in ttb.get_data("select * from " + user + ".d_dlogin").Tables[0].Rows) { try { ttb.execute_data("update " + user + ".d_dlogin set password_='" + ttb.decode(r["password_"].ToString()) + "' where id=" + decimal.Parse(r["id"].ToString())); } catch { } } ttb.execute_data("delete from " + user + ".d_thongso where id=-13"); MessageBox.Show("Đã giải hóa mật khẩu !", ttb.Msg); } else { MessageBox.Show("Mật khẩu chưa mã hóa !", ttb.Msg); } } else if (e.KeyCode == Keys.L && e.Control && e.Alt && e.Shift) { frmRight_BV f = new frmRight_BV(ttb, tree, i_nhom); f.Show(); } }
private void frmUser_Load(object sender, System.EventArgs e) { user = ttb.user; bMahoa = ttb.bMahoamatkhau; //nhomkho.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnhomkho order by stt").Tables[0]; //nhomkho.DisplayMember = "TEN"; //nhomkho.ValueMember = "ID"; //nhomkho.SelectedValue=i_nhomkho.ToString(); //nhomkho.Enabled=s_userid==LibTTB.AccessData.links_userid+LibTTB.AccessData.links_pass; manhom.DisplayMember = "TEN"; manhom.ValueMember = "ID"; loaint.DisplayMember = "TEN"; loaint.ValueMember = "ID"; loaikhac.DisplayMember = "TEN"; loaikhac.ValueMember = "ID"; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; load_dmkho(); if (m_id != 0) { this.Text = "Sửa Password"; foreach (DataRow r in ttb.get_data("select * from " + user + ".ttb_dlogin where id=" + m_id).Tables[0].Rows) { hoten.Text = r["hoten"].ToString(); s_makho = r["makho"].ToString(); s_makp = r["makp"].ToString(); s_manhom = r["manhom"].ToString(); s_loaint = r["loaint"].ToString(); s_loaikhac = r["loaikhac"].ToString(); tao.Checked = int.Parse(r["tao"].ToString()) == 1; admin.Checked = int.Parse(r["admin"].ToString()) == 1; break; } if (hoten.Text == "") { hoten.Text = d_user; } userid.Text = d_user; password.Text = ttb.decode(d_psw); userid.Enabled = false; s_makho = "," + s_makho; for (int i = 0; i < dtdmkho.Rows.Count; i++) { if (s_makho.IndexOf("," + dtdmkho.Rows[i]["id"].ToString().Trim() + ",") != -1) { makho.SetItemCheckState(i, CheckState.Checked); } else { makho.SetItemCheckState(i, CheckState.Unchecked); } } s_makp = "," + s_makp; for (int i = 0; i < dtmakp.Rows.Count; i++) { if (s_makp.IndexOf("," + dtmakp.Rows[i]["id"].ToString().Trim() + ",") != -1) { makp.SetItemCheckState(i, CheckState.Checked); } else { makp.SetItemCheckState(i, CheckState.Unchecked); } } s_manhom = "," + s_manhom; for (int i = 0; i < dtdmnhom.Rows.Count; i++) { if (s_manhom.IndexOf("," + dtdmnhom.Rows[i]["id"].ToString().Trim() + ",") != -1) { manhom.SetItemCheckState(i, CheckState.Checked); } else { manhom.SetItemCheckState(i, CheckState.Unchecked); } } s_loaint = "," + s_loaint; for (int i = 0; i < dtnt.Rows.Count; i++) { if (s_loaint.IndexOf("," + dtnt.Rows[i]["id"].ToString().Trim() + ",") != -1) { loaint.SetItemCheckState(i, CheckState.Checked); } else { loaint.SetItemCheckState(i, CheckState.Unchecked); } } s_loaikhac = "," + s_loaikhac; for (int i = 0; i < dtkhac.Rows.Count; i++) { if (s_loaikhac.IndexOf("," + dtkhac.Rows[i]["id"].ToString().Trim() + ",") != -1) { loaikhac.SetItemCheckState(i, CheckState.Checked); } else { loaikhac.SetItemCheckState(i, CheckState.Unchecked); } } } else { m_id = ttb.get_id_dlogin; } }