private void Button1_Click(object sender, EventArgs e)
        {
            Database db  = new Database();
            string   sql = "insert 账户余额表(用户名,预算,当前预算) values(N'" + username + "'," + numericUpDown1.Value.ToString() + "," + numericUpDown1.Value.ToString() + ") ";

            db.RunSql(sql);
            MessageBox.Show("设置成功!");
            this.Close();
            主界面 f = new 主界面(username, mima);

            f.Show();
            当前余额 form = new 当前余额();

            form.Show();
            MessageBox.Show("请设置你的账户金额!");
        }
예제 #2
0
        private void Button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Trim( ).Length == 0)
            {
                MessageBox.Show("请输入用户名!");
                textBox1.Focus( );
                return;
            }
            if (textBox2.Text.Trim( ).Length == 0)
            {
                MessageBox.Show("请输入密码!");
                textBox2.Focus( );
                return;
            }
            Common   com = new Common( );
            Database db  = new Database( );
            int      t   = 0;
            string   sql = "select count(*) from 用户信息表 where 用户名=N'" + textBox1.Text.Trim( ) + "'and 密码='" + com.Md5(textBox2.Text.Trim( )) + "'";

            t = db.RunSqlint(sql);
            if (t > 0)
            {
                MessageBox.Show(textBox1.Text.Trim( ) + "欢迎你");
                username = textBox1.Text.Trim( );
                this.Hide( );
                Database db2    = new Database();
                double   budget = 0;
                string   sql2   = "select 预算 from 账户余额表 where 用户名=N'" + username + "'";
                budget = db2.RunSqlDouble(sql2);
                if (budget == 0)
                {
                    预算设置 from = new 预算设置(username, textBox2.Text.Trim());
                    from.Show();
                    this.Hide();
                }
                else
                {
                    主界面 form = new 主界面(username, textBox2.Text.Trim());
                    form.Show();
                }
            }
            else
            {
                MessageBox.Show("用户名或密码错误!");
            }
        }