예제 #1
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            登录界面 dl = new 登录界面();

            this.Hide();
            dl.ShowDialog();
            this.Dispose();
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (txtPassword.Text != txtPasswordAgain.Text)
            {
                MessageBox.Show("您好,您两次密码输入的不一样哦,请重新输入呀");
            }
            else
            {
                using (SqlConnection SQLConn = new SqlConnection(ConnStr))
                {
                    string SQLStr = $"select * from accNum where accNumber = '{txtName.Text}'";
                    using (SqlCommand SQLCmd = new SqlCommand(SQLStr, SQLConn))
                    {
                        SQLConn.Open();
                        int Resultcount = Convert.ToInt32(SQLCmd.ExecuteScalar());
                        if (Resultcount > 0)
                        {
                            MessageBox.Show("对不起,已经有同名账号了");
                        }
                        else
                        {
                            using (SqlConnection SQLConn1 = new SqlConnection(ConnStr))
                            {
                                string         InsertStr = $"insert into accNum values(@accNumber,@password)";
                                SqlParameter[] pars      =
                                {
                                    new SqlParameter("@accNumber", txtName.Text),
                                    new SqlParameter("@password",  txtPassword.Text),
                                };

                                int x = SQLHelper.SQLExcuteNoQuery(InsertStr, pars);
                                if (x > 0)
                                {
                                    MessageBox.Show("成功啦");
                                    MessageBox.Show("马上跳转至登录界面");
                                    登录界面 dl = new 登录界面();
                                    this.Hide();
                                    dl.ShowDialog();
                                    this.Dispose();
                                }
                                else
                                {
                                    MessageBox.Show("no");
                                }
                            }
                        }
                    }
                }
            }
        }