Exemple #1
0
        private void OK_Click( object sender, EventArgs e )
        {
            try
            {
                OracleConnection conn = ConnectionOracle.creaConnection();
                conn.Open();
                OracleCommand cmd = new OracleCommand();
                cmd.CommandText = "select count(*) from admins where id='"+tno.Text+"' and psw='"+Psw.Text+"'";
                OracleDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    if (reader[0].ToString ().Equals ( "1" ))
                    {
                        this.Hide();
                        View_illstudent stu = new View_illstudent();
                        stu.Show();
                        return;
                    }
                }
                MessageBox.Show("用户没有找到");
            //                cmd.ExecuteScalar() + "";
                //               int raw = cmd.ExecuteOracleScalar();
            }
            catch (Exception e1)
            {
                MessageBox.Show(e1.Message);

                throw;
            }
        }
Exemple #2
0
        private void treeView1_AfterSelect( object sender, TreeViewEventArgs e )
        {
            //            MessageBox.Show(treeView1.SelectedNode.ToString());
            if (treeView1.SelectedNode.ToString().EndsWith("查看违章学生记录"))
            {
                this.Hide();
                View_illstudent stu = new View_illstudent();
                stu.Show();
            }
            else if (treeView1.SelectedNode.ToString().EndsWith("更新数据"))
            {
                this.Hide();
                Update update = new Update();
                update.Show();
            }
            else if (treeView1.SelectedNode.ToString().EndsWith("学生借书"))
            {
                this.Hide();
                Borrow borrow = new Borrow();
                borrow.Show();
            }
            else if (treeView1.SelectedNode.ToString ().EndsWith ( "查看个人信息" ))
            {
                this.Hide ();
                myinformation myinfo = new myinformation();
                myinfo.Show();
            }
            else if (treeView1.SelectedNode.ToString ().EndsWith ( "查看当前借阅" ))
            {
                this.Hide ();
                myborrow mybo = new myborrow();
                mybo.Show();
            }
            else if (treeView1.SelectedNode.ToString ().EndsWith ( "申请续借" ))
            {
                this.Hide ();
                myborrow ba = new myborrow();
                ba.Show();
            }
            else if (treeView1.SelectedNode.ToString ().EndsWith ( "图书查询" ))
            {
                this.Hide ();
                Query query = new Query();
                query.Show();
            }

            //                MessageBox.Show("nicuole");
        }