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 Store
{
    public partial class form1 : Form
    {
        public form1()
        {
            InitializeComponent();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection connection = new SqlConnection("Data Source=localhost;Initial Catalog=銀行儲(chǔ)蓄系統(tǒng);Integrated Security=SSPI");
            if ((textBox1.Text != "") && (textBox2.Text != ""))
            {
                try
                {
                    connection.Open();
                    string strSQL = "select * from 業(yè)務(wù)員信息 where 業(yè)務(wù)員編號(hào)='" + textBox1.Text.ToString() + "'and 密碼='" + textBox2.Text.ToString() + "'";
                    SqlCommand cmd = new SqlCommand(strSQL, connection);
                    SqlDataReader dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        //this.Close();
                        Form3 form = new Form3();
                        form.Show();
                    }
                    else
                    {
                        MessageBox.Show("用戶名或口令有錯(cuò),請(qǐng)重新輸入!");
                    }
                }
                catch (SqlException b)
                {
                    Console.WriteLine(b.Message);
                }
                finally
                {
                    connection.Close();
                }
            }
            else
            {
                MessageBox.Show("請(qǐng)輸入完整的正確信息！");
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
        protected override void OnKeyDown(KeyEventArgs e)
        {
            if (e.KeyCode==Keys.Enter)
            {
                this.button3_Click(button3, new EventArgs());
            }
        }
       
    }
}