//----------------------------------------------------------修改密码界面------------------------------------------------------------------------------------- /// <summary> /// 修改密码界面验证 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnModifyPwd_Click(object sender, EventArgs e) { if (txtAccount.Text == "") { MessageBox.Show("原账号不能为空!"); return; } if (txtOldPwd.Text == "") { MessageBox.Show("原密码不能为空!"); return; } if (txtNewPwd.Text == "") { MessageBox.Show("新密码不能为空!"); return; } if (txtReNewPwd.Text == "") { MessageBox.Show("确认密码不能为空!"); return; } fae_analyzer analyzer = new fae_analyzer(); analyzer.ITcode = txtNewPwd.Text; analyzer.employee_id = txtAccount.Text; if (txtOldPwd.Text != ITcode) { MessageBox.Show("原密码输入错误,请重新输入!"); return; } if (txtOldPwd.Text.Trim() == txtNewPwd.Text.Trim()) { MessageBox.Show("新密码不能与原密码相同!请重设密码!"); return; } if (txtReNewPwd.Text != txtNewPwd.Text) { MessageBox.Show("确认密码与新密码不一致,请重新输入!"); return; } string sql = string.Format("update fae_analyzer set ITcode='{0}' where employee_id='{1}'" , analyzer.ITcode, analyzer.employee_id); if (SqlHelper.modify(sql)) { MessageBox.Show("修改密码成功,请重新登录!"); FormLogin fl = new FormLogin(); fl.Show(); this.Visible = false; } else { MessageBox.Show("修改密码失败!"); return; } }
private void btnLogin_Click(object sender, EventArgs e) { if (txtEmployee_id.Text.Trim().Equals(string.Empty)) { MessageBox.Show("工号为空,请重新输入!"); return; } if (txtTcode.Text.Trim().Equals(string.Empty)) { MessageBox.Show("密码为空,请重新输入密码!"); return; } if (rdo_FAE.Checked.Equals(true)) { fae_analyzer analyzer = new fae_analyzer() { employee_id = txtEmployee_id.Text, ITcode = txtTcode.Text.Trim() }; string sql = "select*from fae_analyzer where employee_id=@employee_id and binary ITcode=@ITcode"; MySqlParameter[] ps = { new MySqlParameter("@employee_id", analyzer.employee_id), new MySqlParameter("@ITcode", analyzer.ITcode) }; if (analyzer.employee_id == "0") { DataTable dt = SqlHelper.GetList(sql, ps); if (dt.Rows.Count > 0) { FormMain fm = new FormMain(); fm.employee_id = txtEmployee_id.Text; fm.ITcode = txtTcode.Text; fm.Show(); this.Visible = false; } else { MessageBox.Show("账号,密码或用户类型错误,请重新登录!!"); return; } } else { MessageBox.Show("账号,密码或用户类型错误,请重新登录!!"); return; } } //------------------------------------------------------------------------------------- else if (rdo_staff.Checked.Equals(true)) { fae_analyzer analyzer = new fae_analyzer() { employee_id = txtEmployee_id.Text, ITcode = txtTcode.Text.Trim() }; string sql = "select*from fae_analyzer where employee_id=@employee_id and binary ITcode=@ITcode"; MySqlParameter[] ps = { new MySqlParameter("@employee_id", analyzer.employee_id), new MySqlParameter("@ITcode", analyzer.ITcode) }; if (analyzer.employee_id != "0") { DataTable dt = SqlHelper.GetList(sql, ps); if (dt.Rows.Count > 0) { FormStaff fs = new FormStaff(); fs.employee_id = txtEmployee_id.Text; fs.ITcode = txtTcode.Text; fs.Show(); this.Visible = false; } else { MessageBox.Show("账号,密码或用户类型错误,请重新登录!!"); return; } } else { MessageBox.Show("账号,密码或用户类型错误,请重新登录!"); return; } } }