상속: System.Windows.Forms.Form
예제 #1
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            string strName = txtName.Text;
            string strPasw = txtPassword.Text;
            string sql =
                "select id " +
                "from reader " +
                "where name = @strName and password = @strPasw";
            SqlCommand cmd = new SqlCommand(sql, Library.Connection.Instance());
            cmd.Parameters.AddWithValue("@strName", strName);
            cmd.Parameters.AddWithValue("@strPasw", strPasw);
            SqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read())
            {
                int id = reader.GetInt32(0);
                frmMain main = new frmMain();
                this.Hide();
                readerId = id;

                reader.Close();

                main.ShowDialog();
            }
            else
            {
                MessageBox.Show("你的账号或密码错误。");
                reader.Close();
            }
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            DateTime nowtime = System.DateTime.Now;

            int readerId = frmLogin.readerId;
            string sql3 =
                "INSERT INTO reserve(reader_id, book_isbn, reserve_time, available) " +
                "VALUES	(@readerId, @ISBN, @nowtime, 1)";

            SqlCommand cmd = new SqlCommand(sql3, Library.Connection.Instance());
            cmd = new SqlCommand(sql3, Library.Connection.Instance());
            cmd.Parameters.AddWithValue("@readerid", readerId);
            cmd.Parameters.AddWithValue("@ISBN", isbn);
            cmd.Parameters.AddWithValue("@nowtime", nowtime);
            //cmd.Parameters.AddWithValue("@1", 1);
            cmd.ExecuteNonQuery();
            frmMain frm = new frmMain();
            this.Hide();
            frm.ShowDialog();
            this.Show();
        }