private void bt_pwdOK_Click(object sender, EventArgs e) { MdPubFunc funcs = new MdPubFunc(); string pass = funcs.EnCrypt(tb_pwdOld.Text); string query = "select * from sUser where sUserCode = '" + tb_pwdId.Text + "' and sUserPass = '******'"; if (funcs.ExcScalar(query, MdDefine.strcon) == null) { lbl_mess.Text = "Mật khẩu không đúng !!!"; } else { if (tb_pwdNew.Text != tb_pwdNewR.Text) { lbl_mess.Text = "Mật khẩu mới ko giống nhau !!!"; } else { pass = funcs.EnCrypt(tb_pwdNew.Text.ToString()); query = "Update sUser Set sUserPass= '******' Where sUserCode='" + tb_pwdId.Text + "'"; if (funcs.ExecuteQuery(query, MdDefine.strcon) > 0) { MessageBox.Show("Bạn đã thay đổi thành công !!!"); } else { MessageBox.Show("Có lỗi trong quá trình thay đổi!!!"); } } } }
private void bt_inq_Click(object sender, EventArgs e) { //string query = "select * from sUser"; string query = "exec USP_GetAllUser"; MdPubFunc funcs = new MdPubFunc(); DataSet ds = new DataSet(); ds = funcs.getDataSet(query, MdDefine.strcon); gridview_user.DataSource = ds.Tables[0]; }
public MainSys(string name) : this() { this.name = name; string qry = "select * from susermod where usercode ='" + this.name + "'"; MdPubFunc funcs = new MdPubFunc(); DataSet ds = new DataSet(); ds = funcs.getDataSet(qry, MdDefine.strcon); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ToolStripMenuItem AmenuItem = new ToolStripMenuItem(); AmenuItem.Name = ds.Tables[0].Rows[i][1].ToString(); AmenuItem.Text = ds.Tables[0].Rows[i][1].ToString(); MenuStrip.Items.Add(AmenuItem); addSubMenu(ds.Tables[0].Rows[i][1].ToString(), AmenuItem); } // Language Menu ToolStripMenuItem LangpmenuItem = new ToolStripMenuItem(); LangpmenuItem.Name = "Language"; LangpmenuItem.Text = "Language"; MenuStrip.Items.Add(LangpmenuItem); string qry1 = "select sLangName from sLang"; ds = funcs.getDataSet(qry1, MdDefine.strcon); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ToolStripMenuItem AmenuItem = new ToolStripMenuItem(); AmenuItem.Name = ds.Tables[0].Rows[i][0].ToString(); AmenuItem.Text = ds.Tables[0].Rows[i][0].ToString(); AmenuItem.Click += ShowSubForm; LangpmenuItem.DropDownItems.Add(AmenuItem); } // Help Menu ToolStripMenuItem HelpmenuItem = new ToolStripMenuItem(); HelpmenuItem.Name = "Help"; HelpmenuItem.Text = "Help"; MenuStrip.Items.Add(HelpmenuItem); ToolStripMenuItem childpmenuItem = new ToolStripMenuItem(); // string FilePath = @"Images\infor.bmp"; childpmenuItem.Name = "About"; childpmenuItem.Text = "About"; childpmenuItem.ShortcutKeys = Keys.Control | Keys.I; // childpmenuItem.Image = Image.FromFile(FilePath); childpmenuItem.Click += ShowSubForm; HelpmenuItem.DropDownItems.Add(childpmenuItem); }
private void bt_register_Click(object sender, EventArgs e) { // string name = tb_NameRe.Text.ToString(); string hasPass = ""; int status = ckb_status.Checked ? 1 : 0; MdPubFunc funcs = new MdPubFunc(); hasPass = funcs.EnCrypt(tb_PassRe.Text.ToString()); string qry = "Insert into suser(susercode,suserpass,suserfullname,susercom_code,suserrole_code,suserdept_code,suserposi_code,suseremail,suserphone_extend,suserstatus) Values( '" + tb_id.Text + "','" + hasPass + "','" + tb_NameRe.Text + "','" + tb_company.Text + "','" + tb_role.Text + "','" + tb_dept.Text + "','" + tb_posi.Text + "','" + tb_email.Text + "','" + tb_phone.Text + "','" + status + "')"; if (funcs.ExecuteQuery(qry, MdDefine.strcon) > 0) { MessageBox.Show("Bạn đã đăng kí thành công !!!"); } else { MessageBox.Show("Có lỗi trong quá trình đăng kí !!!"); } }
private void addSubMenu(string modname, ToolStripMenuItem PMenu) { string qry = "select CONCAT_WS (' ',sFormId ,sFormName) as info from sForm where sFormsModuleId = '" + modname + "'"; //string qry = "select * from sform where moduleid = '" + modname + "'"; MdPubFunc funcs = new MdPubFunc(); //MySqlDataReader reader; DataSet ds = new DataSet(); ds = funcs.getDataSet(qry, MdDefine.strcon); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ToolStripMenuItem AmenuItem = new ToolStripMenuItem(); AmenuItem.Name = ds.Tables[0].Rows[i][0].ToString(); AmenuItem.Text = ds.Tables[0].Rows[i][0].ToString(); AmenuItem.Click += ShowSubForm; PMenu.DropDownItems.Add(AmenuItem); } //if (reader.HasRows) //{ // try // { // while (reader.Read()) // { // ToolStripMenuItem AmenuItem = new ToolStripMenuItem(); // AmenuItem.Name = reader["formid"].ToString(); // AmenuItem.Text = reader["formid"].ToString(); // AmenuItem.Click += ShowSubForm; // PMenu.DropDownItems.Add(AmenuItem); // } // } // catch (Exception ex) // { // MessageBox.Show(ex.ToString()); // Close(); // } // finally // { // reader.Close(); // } //} }
private void bt_login_Click(object sender, EventArgs e) { string name = txtb_name.Text.ToString(); string hasPass = ""; MdPubFunc funcs = new MdPubFunc(); hasPass = funcs.EnCrypt(txtb_pass.Text.ToString()); string qry = "select * from sUser where susercode='" + name + "' and suserpass='******'"; object result = funcs.ExcScalar(qry, MdDefine.strcon); if (result != null) { MainSys main = new MainSys(txtb_name.Text); main.ShowDialog(); this.Close(); } else { lbl_message.Text = "Username or Password incorrect"; txtb_name.Text = ""; txtb_pass.Text = ""; txtb_name.Focus(); } }
public void ShowSubForm(object sender, EventArgs e) { string AFormName = Microsoft.VisualBasic.Strings.Left(sender.ToString(), 5).Trim(); MdPubFunc funcs = new MdPubFunc(); System.Reflection.Assembly tempAssembly = System.Reflection.Assembly.GetExecutingAssembly(); string str = tempAssembly.GetName().Name + "." + AFormName; Form frm; try { frm = (Form)tempAssembly.CreateInstance(str); } catch (Exception) { throw; } switch (AFormName) { case "DCM01": if (funcs.CheckAuth(AFormName, name) != null) { FoodOrder_Frm DCM01_form = new FoodOrder_Frm(); DCM01_form.MdiParent = this; DCM01_form.WindowState = FormWindowState.Maximized; DCM01_form.Show(); // obVal = FindObject(frm, "Panelsys") //If Not obVal Is Nothing Then // obVal.Parent = SysPage.SelectedTab '本程序顯示在主窗体的mainpage中 2008-10-01 (Panelsys是在最上面Fill)hyt // iCurIndex = SysPage.SelectedIndex // LangDeal(AFormName, SysPage.TabPages.Item(iCurIndex)) //End If } else { MessageBox.Show("Bạn không có quyền đề vào chương trình !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); } break; case "USR01": if (funcs.CheckAuth(AFormName, name) != null) { QuanliUser ql_form = new QuanliUser(name); ql_form.MdiParent = this; ql_form.WindowState = FormWindowState.Maximized; ql_form.Show(); } else { MessageBox.Show("Bạn không có quyền đề vào chương trình !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); } break; case "USR03": if (funcs.CheckAuth(AFormName, name) != null) { RegisterFrm re = new RegisterFrm(); // re.MdiParent = this; // re.WindowState = FormWindowState.Maximized; re.Show(); } else { MessageBox.Show("Bạn không có quyền đề vào chương trình !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); } break; case "FGP01": if (funcs.CheckAuth(AFormName, name) != null) { FingerPrint.FingerPrint fg = new FingerPrint.FingerPrint(); fg.ShowDialog(); } else { MessageBox.Show("Bạn không có quyền đề vào chương trình !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); } break; case "About": About about = new About(); about.Show(); break; default: MessageBox.Show("Chưa định nghĩa chương trình !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); break; } }