usersaveform.cs

aTm机 daima认真阅读您的文件包然后写出其具体功能(至少要20个字)。尽量不要让站长把时间都花费在为您修正说明上。压缩包解压时不能有密码。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Bank
{
    public partial class UserSaveform : Form
    {
        string id = "";
        int money = 0;
        public UserSaveform()
        {
            InitializeComponent();
        }

        private void UserbtnSaveEnter_Click(object sender, EventArgs e)
        {
            //判断输入是否正确
            string str = String.Empty;//string  int 对比验证
            str = UsertxtSave.Text;
            int result;


            MaintxtSaveID.Text = HelperSend.LoginID;
            int moneyadd = int.Parse(UsertxtSave.Text);
            if (moneyadd<= int.Parse(HelperSend.LoginMoney))
            {
                    int money = int.Parse(HelperSend.LoginMoney) + moneyadd;
                    string id = MaintxtSaveID.Text.Trim();
                    int add = 0;
                    string sql = string.Format("update users set money = {0} where id = {1}", money, id);

                    Console.WriteLine(sql);
                    if (int.TryParse(str, out result))//判断是否输入字符
                    {
                        try
                        {
                            SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                            DBHelper.connection.Close();
                            DBHelper.connection.Open();

                            add = (int)command.ExecuteNonQuery();
                            



                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show("数据库出错了！\n\n" + ex, "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        finally
                        {
                            DBHelper.connection.Close();
                        }
                        NewLook();
                        MessageBox.Show("您存入的金额是:\n" + UsertxtSave.Text + "元");

                    }
                    else
                    {
                        MessageBox.Show("对不起，请正确输入存款数!");
                    }
                    //对数据库进行操作
            }
            else
            {
                MessageBox.Show("对不起，您没有那么多钱！请重新输入");
                this.UsertxtSave.Focus();
            }

            
           
        }

        private void UserbtnSaveExit_Click(object sender, EventArgs e)
        {
                this.Close();
        }

        private void UserSaveform_Load(object sender, EventArgs e)
        {

            
        }

        private void NewLook()
        {
            string sql = "select * from users";
            try
            {
                SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                DBHelper.connection.Close();
                DBHelper.connection.Open();
                SqlDataReader dataReader = command.ExecuteReader();
                Mainform mainform = new Mainform();
                /*
                 验证部分
                */
                if (!dataReader.HasRows)
                {
                    MessageBox.Show("对不起，没有任何用户，请先创建用户", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
                }
                while (dataReader.Read())
                {
                    id = (string)dataReader["id"];
                    if (HelperSend.LoginID == id)
                    {
                        money = (int)dataReader["money"];
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据库出错了！\n\n" + ex, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
            }
            finally
            {
                DBHelper.connection.Close();
            }
        }
    }
}