Ejemplo n.º 1
0
        private void btSearch_Click(object sender, EventArgs e)
        {
            bsStudent.Clear();
            DBControl     ADB = new DBControl();
            SqlDataReader sr  = ADB.linkQuery("select * from Student where Name like '%" + tbS.Text + "%';");

            if (sr.HasRows)
            {
                bsStudent.DataSource                = sr;
                dataGridView1.DataSource            = bsStudent;
                dataGridView1.Columns[0].HeaderText = "学号";
                dataGridView1.Columns[1].HeaderText = "姓名";
                dataGridView1.Columns[2].HeaderText = "性别";
                dataGridView1.Columns[3].HeaderText = "学院";
                dataGridView1.Columns[4].HeaderText = "班级";
                dataGridView1.Columns[5].HeaderText = "专业";
                dataGridView1.Columns[6].HeaderText = "登陆密码";
            }
            else
            {
                MessageBox.Show("没有数据!");
            }
            dataGridView1.Refresh();
            sr.Close();
            ADB.Close();
        }
Ejemplo n.º 2
0
        //查询教学计划页面的操作
        private void btTShowAll_Click(object sender, EventArgs e)
        {
            bsTeaching.Clear();
            DBControl     ADB = new DBControl();
            SqlDataReader sr  = ADB.linkQuery("select Student.Name,Course.Name,Teacher.Name,Teaching.Achievement,Course.Credit,Teaching.Classroom,Teaching.TeachTime,Teaching.Remarks from Student,Teaching,Course,Teacher where Teaching.StuID=Student.ID and Teaching.CourseID=Course.ID and Teaching.TeachID=Teacher.ID;");

            if (sr.HasRows)
            {
                bsTeaching.DataSource               = sr;
                dataGridView2.DataSource            = bsTeaching;
                dataGridView2.Columns[0].HeaderText = "学生姓名";
                dataGridView2.Columns[1].HeaderText = "课程名";
                dataGridView2.Columns[2].HeaderText = "教师姓名";
                dataGridView2.Columns[3].HeaderText = "成绩";
                dataGridView2.Columns[4].HeaderText = "学分";
                dataGridView2.Columns[5].HeaderText = "上课地点";
                dataGridView2.Columns[6].HeaderText = "上课时间";
                dataGridView2.Columns[7].HeaderText = "备注";
            }
            else
            {
                MessageBox.Show("没有数据!");
            }
            dataGridView2.Refresh();
            sr.Close();
            ADB.Close();
        }
Ejemplo n.º 3
0
        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            ArrayList al = new ArrayList();

            String[]  temp = listBox1.SelectedItem.ToString().Split('*');
            DBControl SDB  = new DBControl();

            //SqlDataReader getCourseInfo = SDB.linkQuery("select * from Course where ID=" + al[1].ToString() + ";");
            //getCourseInfo.Read();
            //al.Add(getCourseInfo.GetValue(0).ToString());

            SqlDataReader getTeachingInfo = SDB.linkQuery("select * from Teaching where StuID=" + id + " and CourseID=" + temp[1] + ";");

            getTeachingInfo.Read();
            for (int j = 0; j < 7; j++)
            {
                al.Add(getTeachingInfo.GetValue(j).ToString());
            }
            getTeachingInfo.Close();
            SqlDataReader getTeacherName = SDB.linkQuery("select Name from Teacher where ID=" + al[1].ToString() + ";");

            getTeacherName.Read();
            al.Add(getTeacherName.GetValue(0).ToString());
            getTeacherName.Close();
            SDB.Close();
            MessageBox.Show("课程名:" + temp[0] + "\n" + "授课教师:" + al[7].ToString() + "\n成绩:" + al[3].ToString() + "\n授课教室" + al[4].ToString() + "\n授课时间:" + al[5].ToString() + "\n备注:" + al[6].ToString());
        }
Ejemplo n.º 4
0
        private void initialCB()
        {
            cbSID.Items.Clear();
            cbTID.Items.Clear();
            cbCID.Items.Clear();
            DBControl     ADB  = new DBControl();
            SqlDataReader ssdr = ADB.linkQuery("select * from Student;");

            while (ssdr.Read())
            {
                cbSID.Items.Add(ssdr.GetValue(1).ToString());
            }
            ssdr.Close();
            SqlDataReader tsdr = ADB.linkQuery("select * from Teacher;");

            while (tsdr.Read())
            {
                cbTID.Items.Add(tsdr.GetString(1));
            }
            tsdr.Close();
            SqlDataReader csdr = ADB.linkQuery("select * from Course;");

            while (csdr.Read())
            {
                cbCID.Items.Add(csdr.GetString(1));
            }
            csdr.Close();
            ADB.Close();
        }
Ejemplo n.º 5
0
        private void btTSearch_Click(object sender, EventArgs e)
        {
            bsTeacher.Clear();
            DBControl     ADB = new DBControl();
            SqlDataReader sr  = ADB.linkQuery("select * from Teacher where Name like '%" + tbT.Text + "%';");

            if (sr.HasRows)
            {
                bsTeacher.DataSource                      = sr;
                dataGridViewTeacher.DataSource            = bsTeacher;
                dataGridViewTeacher.Columns[0].HeaderText = "工号";
                dataGridViewTeacher.Columns[1].HeaderText = "姓名";
                dataGridViewTeacher.Columns[2].HeaderText = "学院";

                dataGridViewTeacher.Columns[3].HeaderText = "登陆密码";
            }
            else
            {
                MessageBox.Show("没有数据!");
            }

            dataGridViewTeacher.Refresh();
            sr.Close();
            ADB.Close();
        }
Ejemplo n.º 6
0
        private void listBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            // String[] temp = listBox2.SelectedItem.ToString().Split('*');
            DBControl     SDB            = new DBControl();
            SqlDataReader getTeacherInfo = SDB.linkQuery("select College from Teacher where Name='" + listBox2.SelectedItem.ToString() + "' ;");

            getTeacherInfo.Read();
            MessageBox.Show("教师姓名:" + listBox2.SelectedItem.ToString() + "\n所属学院:" + getTeacherInfo.GetValue(0).ToString());
            getTeacherInfo.Close();
            SDB.Close();
        }
Ejemplo n.º 7
0
 //添加教师表
 private void btAddTeacher_Click(object sender, EventArgs e)
 {
     if (tbTCollege.Text != null && tbTID.Text != null && tbTName.Text != null)
     {
         DBControl ADB = new DBControl();
         ADB.linkUpdate("insert into Teacher(ID,Name,College,Password) values(" + tbTID.Text + ",'" + tbTName.Text + "','" + tbTCollege.Text + "'," + tbTID.Text + ");");
         MessageBox.Show("更新成功!");
         ADB.Close();
         tbTCollege.Clear();
         tbTID.Clear();
         tbTName.Clear();
     }
     else
     {
         MessageBox.Show("您的数据输入不完整,请检查您的数据!");
     }
 }
Ejemplo n.º 8
0
 //添加数据至课程表
 private void btAddCourse_Click(object sender, EventArgs e)
 {
     if (tbCID.Text != null && tbCName.Text != null && tbCCredit.Text != null)
     {
         DBControl ADB = new DBControl();
         ADB.linkUpdate("insert into Course(ID,Name,Credit,Remarks) values(" + tbCID.Text + ",'" + tbCName.Text + "'," + tbCCredit.Text + ",'" + tbCRemarks.Text + "');");
         MessageBox.Show("更新成功!");
         ADB.Close();
         tbCID.Clear();
         tbCName.Clear();
         tbCCredit.Clear();
         tbCRemarks.Clear();
     }
     else
     {
         MessageBox.Show("您的数据输入不完整,请检查您的数据!");
     }
 }
Ejemplo n.º 9
0
 //更新学生表
 private void btAddStudent_Click(object sender, EventArgs e)
 {
     if (tbSID.Text != null && tbSMajor.Text != null && tbSClass.Text != null && tbSCollege.Text != null && tbSName.Text != null && cbSSex.SelectedItem != null)
     {
         DBControl ADB = new DBControl();
         ADB.linkUpdate("insert into Student(ID,Name,Sex,College,Class,Major,Password) values(" + tbSID.Text + ",'" + tbSName.Text + "','" + cbSSex.SelectedItem.ToString() + "','" + tbSCollege.Text + "','" + tbSClass.Text + "','" + tbSMajor.Text + "'," + tbSID.Text + ");");
         MessageBox.Show("更新成功!");
         ADB.Close();
         tbSID.Clear();
         tbSMajor.Clear();
         tbSClass.Clear();
         tbSCollege.Clear();;
         tbSName.Clear();
     }
     else
     {
         MessageBox.Show("您的数据输入不完整,请检查您的数据!");
     }
 }
Ejemplo n.º 10
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (comboBox1.SelectedItem != null)
     {
         setSQL();
         DBControl     ldb        = new DBControl();
         SqlDataReader checkAdmin = ldb.linkQuery(s);
         if (checkAdmin.Read())
         {
             this.Hide();
             MessageBox.Show("欢迎使用学生管理系统!");
             if (m == 1)
             {
                 setIDInfo(checkAdmin.GetValue(0).ToString());
                 Administrator oa = new Administrator();
                 oa.Show();
             }
             else if (m == 2)
             {
                 setIDInfo(checkAdmin.GetValue(0).ToString());
                 Student os = new Student();
                 os.Show();
             }
             else if (m == 3)
             {
                 setIDInfo(checkAdmin.GetValue(0).ToString());
                 Teacher ot = new Teacher();
                 ot.Show();
             }
         }
         else
         {
             MessageBox.Show("登陆失败,请检查您的数据");
         }
         ldb.Close();
     }
     else
     {
         MessageBox.Show("您必须选择登陆角色!");
     }
 }
Ejemplo n.º 11
0
        private void btTTDelete_Click(object sender, EventArgs e)
        {
            if (dataGridView2.RowCount <= 0)
            {
                MessageBox.Show("请选择记录!");
                return;
            }
            if (MessageBox.Show(this, "是否删除此记录", "请确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                for (int i = this.dataGridView2.SelectedRows.Count; i > 0; i--)
                {
                    int ID = Convert.ToInt32(dataGridView2.SelectedRows[i - 1].Cells[0].Value);
                    dataGridView2.Rows.RemoveAt(dataGridView2.SelectedRows[i - 1].Index);
                    //使用获得的ID删除数据库的数据

                    string    sql2 = "delete from Teaching where StuID=" + ID.ToString() + ";";
                    DBControl ADB  = new DBControl();
                    ADB.linkUpdate(sql2);
                    ADB.Close();
                }
            }
        }
Ejemplo n.º 12
0
        //添加教学计划

        private void btAddTeaching_Click(object sender, EventArgs e)
        {
            if (tbTeachTime.Text != null && tbClassroom.Text != null && cbSID.SelectedItem != null && cbTID.SelectedItem != null && cbCID.SelectedItem != null)
            {
                int           sid  = 0;
                int           tid  = 0;
                int           cid  = 0;
                DBControl     ADB  = new DBControl();
                SqlDataReader gSID = ADB.linkQuery("select ID from Student where Name='" + cbSID.SelectedItem.ToString() + "';");
                if (gSID.Read())
                {
                    sid = gSID.GetInt32(0);
                }
                gSID.Close();
                SqlDataReader gTID = ADB.linkQuery("select ID from Teacher where Name='" + cbTID.SelectedItem.ToString() + "';");
                if (gTID.Read())
                {
                    tid = gTID.GetInt32(0);
                }
                gTID.Close();
                SqlDataReader gCID = ADB.linkQuery("select ID from Course where Name='" + cbCID.SelectedItem.ToString() + "';");
                if (gCID.Read())
                {
                    cid = gCID.GetInt32(0);
                }
                gCID.Close();
                //MessageBox.Show(sid.ToString()+"**"+tid.ToString()+"$$"+cid.ToString());
                ADB.linkUpdate("insert into Teaching(StuID,TeachID,CourseID,Classroom,TeachTime,Remarks) values(" + sid.ToString() + "," + tid.ToString() + "," + cid.ToString() + ",'" + tbClassroom.Text + "','" + tbTeachTime.Text + "','" + tbRemarks.Text + "')");
                MessageBox.Show("更新成功");
                ADB.Close();
                tbTeachTime.Clear();
                tbClassroom.Clear();
                tbRemarks.Clear();
            }
            else
            {
                MessageBox.Show("您的数据输入不完整,请检查您的数据!");
            }
        }
Ejemplo n.º 13
0
        private void getThisInformation()
        {
            ArrayList     al    = new ArrayList();
            DBControl     SDB   = new DBControl();
            SqlDataReader getID = SDB.linkQuery("select * from Student where ID=" + id + ";");

            getID.Read();
            for (int j = 0; j < 7; j++)
            {
                al.Add(getID.GetValue(j).ToString());
            }
            getID.Close();
            SDB.Close();
            listBox3.Items.Clear();
            listBox3.Items.Add("学号:" + al[0].ToString());
            listBox3.Items.Add("姓名:" + al[1].ToString());
            listBox3.Items.Add("性别:" + al[2].ToString());
            listBox3.Items.Add("学院:" + al[3].ToString());
            listBox3.Items.Add("班级:" + al[4].ToString());
            listBox3.Items.Add("专业:" + al[5].ToString());
            listBox3.Items.Add("密码:" + al[6].ToString());
        }
Ejemplo n.º 14
0
        private void getAllClass()
        {
            ArrayList     al           = new ArrayList();
            DBControl     SDB          = new DBControl();
            SqlDataReader gAchievement = SDB.linkQuery("select CourseID from Teaching where StuID=" + id + ";");

            while (gAchievement.Read())
            {
                //listBox1.Items.Add(gAchievement.GetInt32(0));
                al.Add(gAchievement.GetInt32(0));
            }
            gAchievement.Close();
            listBox1.Items.Clear();
            for (int i = 0; i < al.Count; i++)
            {
                SqlDataReader getName = SDB.linkQuery("select Name from Course where ID=" + al[i].ToString() + ";");
                getName.Read();
                listBox1.Items.Add(getName.GetString(0) + "*" + al[i]);
                getName.Close();
            }
            SDB.Close();
        }
Ejemplo n.º 15
0
        //更改密码

        private void btUpdatePWD_Click(object sender, EventArgs e)
        {
            if (tbThisPWD.Text != null && tbForePWD.Text != null && tbCheckPWD.Text != null)
            {
                DBControl     ADB      = new DBControl();
                SqlDataReader gForePWD = ADB.linkQuery("select Password from Admin  where [ID]=" + id + ";");
                gForePWD.Read();
                String forePWD = gForePWD.GetString(0);
                gForePWD.Close();
                //MessageBox.Show(gForePWD.GetString(0));
                if (tbThisPWD.Text.Equals(tbCheckPWD.Text))
                {
                    if (tbThisPWD.Text.Equals(forePWD))
                    {
                        MessageBox.Show("不能与原密码相同!");
                    }
                    else
                    {
                        ADB.linkUpdate("update Admin set [Password]='" + tbThisPWD.Text + "' where [ID]=" + id + ";");
                        MessageBox.Show("更改成功!");
                    }
                }
                else
                {
                    MessageBox.Show("密码确认框输入不一致!");
                }

                ADB.Close();
            }
            else
            {
                MessageBox.Show("您的数据输入不完整,请检查您的数据!");
            }
            tbForePWD.Clear();
            tbThisPWD.Clear();
            tbCheckPWD.Clear();
        }
Ejemplo n.º 16
0
        private void btSUpdatePWD_Click(object sender, EventArgs e)
        {
            DBControl     ADB      = new DBControl();
            SqlDataReader gForePWD = ADB.linkQuery("select Password from Student where [ID]=" + id + ";");

            gForePWD.Read();
            String forePWD = gForePWD.GetString(0);

            gForePWD.Close();
            //MessageBox.Show(forePWD + "\n" + tbForePWD.Text);

            if (tbNewPWD.Text.Equals(tbCheckPWD.Text))
            {
                if (tbForePWD.Text.Trim().Equals(forePWD))
                {
                    if (tbNewPWD.Text.Equals(tbForePWD.Text))
                    {
                        MessageBox.Show("不能与原密码相同!");
                    }
                    else
                    {
                        ADB.linkUpdate("update Student set [Password]='" + tbNewPWD.Text + "' where [ID]=" + id + ";");
                        MessageBox.Show("更改成功!");
                    }
                }
                else
                {
                    MessageBox.Show("请正确输入原密码!");
                }
            }
            else
            {
                MessageBox.Show("密码确认框输入不一致!");
            }

            ADB.Close();
        }