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