private void btnSubmit_Click(object sender, EventArgs e) { var sqlstr = "UpdatePwd"; var con = new SqlConnection(BaseStructure.WmsCon); var cmd = new SqlCommand(sqlstr, con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@uName", utxtUser.Text); cmd.Parameters.AddWithValue("@uPassword", WmsFunction.GetMd5Hash(utxtPassword.Text)); cmd.Parameters.AddWithValue("@uPwd", WmsFunction.GetMd5Hash(utxtPwd.Text)); try { con.Open(); } catch (Exception ex) { MessageBox.Show(@"发生异常" + ex.Message, @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (cmd.ExecuteNonQuery() < 1) { MessageBox.Show(@"修改失败", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show(@"修改成功", @"Information", MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; } }
/// <summary> /// 判断是否登录成功 /// </summary> /// <returns></returns> public static bool OkLogin(string uName, string uPassword) { using (var con = new SqlConnection(BaseStructure.WmsCon)) { using (var cmd = new SqlCommand { Connection = con }) { cmd.CommandText = "select * from View_BUserRole where (cCode=@cCode or cName=@cCode) and cPwd=@cPwd"; cmd.Parameters.AddWithValue("@cCode", uName); cmd.Parameters.AddWithValue("@cPwd", WmsFunction.GetMd5Hash(uPassword)); con.Open(); using (var dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) //直接登陆 { BaseStructure.LoginId = dr["cCode"].ToString(); //把登陆名和登陆服务器保存到静态变量中 BaseStructure.LoginName = dr["cName"].ToString(); BaseStructure.LoginRoleId = dr["rCode"].ToString(); BaseStructure.LoginRoleName = dr["rName"].ToString(); return(true); } MessageBox.Show(@"用户名或密码错误,请联系管理员!", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } } } }