Example #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string userName = textBox1.Text.ToString().Trim();
            string userPwd  = textBox2.Text.ToString().Trim();

            if (userName != "")
            {
                if (userPwd != "")
                {
                    //string sql = " select * from Userright where uname=@uname and upwd=@upwd ";
                    SqlParameter[] param =
                    {
                        new SqlParameter("@uname", userName),
                        new SqlParameter("@wpwd",  userPwd),
                    };
                    DataSet users = DBHelpSql.RunProcedureGetDS("pro_selUser", param);


                    //object nnn = DBHelpSql.GetSingle("select * from Userright ");
                    if (users.Tables[0].Rows.Count > 0)
                    {
                        cz.User = new Userright(
                            (int)users.Tables[0].Rows[0]["uid"],
                            users.Tables[0].Rows[0]["uguid"].ToString(),
                            users.Tables[0].Rows[0]["uname"].ToString(),
                            users.Tables[0].Rows[0]["upwd"].ToString(),
                            users.Tables[0].Rows[0]["upower"].ToString(),
                            users.Tables[0].Rows[0]["ustatic"].ToString()
                            );
                        Main form = new Main();
                        form.Show();
                        this.Hide();
                    }
                    else
                    {
                        MessageBox.Show("用户名或密码不正确");
                    }
                }
                else
                {
                    MessageBox.Show("密码不能为空");
                }
            }
            else
            {
                MessageBox.Show("用户名不能为空");
            }
        }