/// <summary> /// 添加用户信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtStaffNumber.Text) && VirafiryNumber(txtStaffNumber.Text)) { MessageBox.Show("请输入账号", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrEmpty(txtStaffName.Text)) { MessageBox.Show("请输入名称", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrEmpty(txtStaffPassword.Text)) { MessageBox.Show("请输入密码", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } User user = new User(); user.Id = Convert.ToInt32(txtStaffNumber.Text); user.Name = txtStaffName.Text; user.Password = MD5Unit.ToByte(txtStaffPassword.Text); user.Access = (cmbAccess.SelectedItem == "管理员权限" ? 1 : 2); user.Remark = txtRemark.Text; if (acount.CreatAcount(user) == 1) { this.gridControlMessage.DataSource = acount.LoadUserAcount(); MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); txtStaffNumber.Clear(); txtStaffName.Clear(); txtStaffPassword.Clear(); txtRemark.Clear(); } }
public User Login(string userName, string userPassword) { string strSQL = CommandFormate("SELECT * FROM [Table_User] WHERE Id = {0}id AND Password = {0}password"); List <User> userInfo = ExcuteSelect <User>(strSQL, parmater => { parmater.Add(parmater.CreateParameter("id", userName)); parmater.Add(parmater.CreateParameter("password", MD5Unit.ToByte(userPassword))); }); if (userInfo.Count > 0) { return(userInfo[0]); } return(null); }
/// <summary> /// 修改用户信息保存修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnResize_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtPassword_Resize.Text)) { MessageBox.Show("请输入密码", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } User user = new User(); user.Id = Convert.ToInt32(cmbStaffNumber.SelectedItem); user.Name = txtName_Resize.Text; user.Password = MD5Unit.ToByte(txtPassword_Resize.Text); user.Access = (cmbAccessOperation.SelectedItem == "管理员权限" ? 1 : 2); user.Remark = txtRemark_Resize.Text; if (acount.ResizeAcount(user) == 1) { this.gridControlMessage.DataSource = acount.LoadUserAcount(); MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); txtName_Resize.Clear(); txtPassword_Resize.Clear(); txtRemark_Resize.Clear(); } }