コード例 #1
0
ファイル: Login.cs プロジェクト: xxxhycl2010/RBAC-1
        //登录
        private void btn_enter_Click(object sender,  System.EventArgs e)
        {
            bool isLogin = false;

            if (SubjectRegister.IsUserNameUsed(userCombox.Text) == false)
            {
                MessageBox.Show(this, "数据库中找不到这样的账号", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            if (userCombox.Text.Length == 0 || pwd.Text.Length == 0)
            {
                MessageBox.Show(this, "账户名称及密码不能为空", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            OleDbConnection oleDB = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=dac.accdb");
            oleDB.Open();
            OleDbCommand conn = new OleDbCommand();
            conn.Connection = oleDB;
            conn.CommandText = "select *  from  [主体信息表] where 主体名称=" + "'" + userCombox.Text.ToLower() + "'";
            OleDbDataReader dr = conn.ExecuteReader();
            if (dr.HasRows == true)
            {
                while (dr.Read())
                {
                    if (dr[1].ToString().CompareTo(pwd.Text.GetHashCode().ToString()) == 0)//找到相应的记录,置登录标志为真
                    {
                        isLogin = true;
                    }
                }
            }
            dr.Close();
            oleDB.Close();
            if (isLogin == false)
            {
                MessageBox.Show(this, "密码错误"+pwd.Text.GetHashCode().ToString(), "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            else
            {
                MessageBox.Show(this, "登录成功,按确定进入", "登录成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            this.Visible = false;

            switch (this.userCombox.Text.ToLower())//选择不同的窗口
            {
                case "admin":
                    {
                        Admin a = new Admin();
                        a.ShowDialog();
                        break;
                    }
                case "security_officer":
                    {
                        Security_Officer s= new Security_Officer();
                        s.ShowDialog();
                        break;
                    }
                default:
                    {
                        CommonUser c = new CommonUser();
                        c.GetUserName = this.userCombox.Text.ToLower();
                        c.ShowDialog();
                        break;
                    }
            }
            this.Visible = true;
        }
コード例 #2
0
ファイル: Login.cs プロジェクト: xxxhycl2010/RBAC-1
        //登录
        private void btn_enter_Click(object sender, System.EventArgs e)
        {
            bool isLogin = false;

            if (SubjectRegister.IsUserNameUsed(userCombox.Text) == false)
            {
                MessageBox.Show(this, "数据库中找不到这样的账号", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            if (userCombox.Text.Length == 0 || pwd.Text.Length == 0)
            {
                MessageBox.Show(this, "账户名称及密码不能为空", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            OleDbConnection oleDB = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=dac.accdb");

            oleDB.Open();
            OleDbCommand conn = new OleDbCommand();

            conn.Connection  = oleDB;
            conn.CommandText = "select *  from  [主体信息表] where 主体名称=" + "'" + userCombox.Text.ToLower() + "'";
            OleDbDataReader dr = conn.ExecuteReader();

            if (dr.HasRows == true)
            {
                while (dr.Read())
                {
                    if (dr[1].ToString().CompareTo(pwd.Text.GetHashCode().ToString()) == 0)//找到相应的记录,置登录标志为真
                    {
                        isLogin = true;
                    }
                }
            }
            dr.Close();
            oleDB.Close();
            if (isLogin == false)
            {
                MessageBox.Show(this, "密码错误" + pwd.Text.GetHashCode().ToString(), "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            else
            {
                MessageBox.Show(this, "登录成功,按确定进入", "登录成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            this.Visible = false;

            switch (this.userCombox.Text.ToLower())//选择不同的窗口
            {
            case "admin":
            {
                Admin a = new Admin();
                a.ShowDialog();
                break;
            }

            case "security_officer":
            {
                Security_Officer s = new Security_Officer();
                s.ShowDialog();
                break;
            }

            default:
            {
                CommonUser c = new CommonUser();
                c.GetUserName = this.userCombox.Text.ToLower();
                c.ShowDialog();
                break;
            }
            }
            this.Visible = true;
        }