frmmain.cs

大二做的课程设计。一个学生信息管理系统

                sItems[6] = row["Remark"].ToString();

                ListViewItem item = new ListViewItem(sItems, 1);

                lstStudent.Items.Add(item);
            }
            
            students.Dispose();
        }

        //获取分数信息
        private void GetScore()
        {
            Scores scores = new Scores();
            
            DataSet dataset = new DataSet();
            int iClassId = -1;
            int iCourseId = -1;
            int iStudentId = -1;
            try
            {
                iClassId = Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].Text);
            }
            catch
            {}
            try
            {
                iCourseId = Convert.ToInt32(lstCourse.SelectedItems[0].SubItems[1].Text);

            }
            catch { }
            try
            {
                iStudentId = Convert.ToInt32(lstStudent.SelectedItems[0].SubItems[1].Text);
            }
            catch { }

            try
            {

                dataset = scores.SelectScore(
                    iStudentId, //如果iStudentId = -1,则表示不对iStudentId进行限定，别的参数与此类似
                    iCourseId,
                    iClassId);
            }
            catch (SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }
            dataGrid1.DataSource = dataset.Tables[0].DefaultView;
           
        }

        //获取课程信息

        private void GetCourse()
        {
            Courses course=new Courses();
            int iClassId = -1;
            DataSet dataset=new DataSet();
            try
            {
                iClassId = Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].ToString());
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            try
            {
                dataset = course.SelectCourse(-1, iClassId, -1);
            }
            catch(SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            for(int i=0;i<dataset.Tables[0].Rows.Count;i++)
            {
                DataRow row=dataset.Tables[0].Rows[i];
                string [] slive=new string[2];
                slive[0]=row["SubjectName"].ToString();
                
                slive[1]=row["CourseId"].ToString();
                ListViewItem lvl=new ListViewItem(slive,2);
               lstCourse.Items.Add(lvl);

            }

        }
        private void lstClass_SelectedIndexChanged(object sender, EventArgs e)
        {
            GetStudent();
            GetScore();
            //GetCourse();
            
        }

        private void lstClass_DoubleClick(object sender, EventArgs e)
        {
            //frmUpdateClass objUpdateClass = new frmUpdateClass(Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].ToString()));
            //objUpdateClass.ShowDialog();
            //GetClass();

        }


        private void 新建班级ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmNewClass objnc = new frmNewClass();
            objnc.ShowDialog();

        }

        private void 更新班级ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmUpdateClass objud = new frmUpdateClass();
            objud.ShowDialog();
        }

        

        private void 添加学生ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmNewStudent objNS = new frmNewStudent();
            objNS.ShowDialog();
        }

        private void 更新学生ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmUpdateStudent objUS = new frmUpdateStudent();
            objUS.ShowDialog();
        }

        private void 添加科目ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmNewCourse objNC = new frmNewCourse();
            objNC.ShowDialog();
        }

        private void 更新科目ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //frmUpdateCourse objUC = new frmUpdateCourse();
            //objUC.ShowDialog();
        }

        private void 退出ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void lstStudent_SelectedIndexChanged(object sender, EventArgs e)
        {
            GetScore();
        }

        private void lstStudent_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            int iStudentId = Convert.ToInt32(lstStudent.SelectedItems[0].SubItems[1].Text);
            frmUpdateStudent updateStudent = new frmUpdateStudent(iStudentId);
            updateStudent.ShowDialog();
            GetStudent();
            GetScore();
        }

        private void dataGrid1_CurrentCellChanged(object sender, EventArgs e)
        {
            DataGridCell newCell = dataGrid1.CurrentCell;
            if (iCurrentRow != -1 && dataGrid1.CurrentRowIndex != iCurrentRow)
            {
                ChangeScore(iCurrentRow);
            }
            iCurrentRow = dataGrid1.CurrentRowIndex;
            try
            {
                fCurrentScore = Convert.ToSingle(dataGrid1[iCurrentRow, 6]);
            }
            catch { }
            dataGrid1.CurrentCell = newCell;
        }


        private void ChangeScore(int iCurrentRow)
        {
            try
            {

                if (dataGrid1[iCurrentRow, 6].ToString() == fCurrentScore.ToString() || dataGrid1[iCurrentRow, 6].ToString() == "")
                {
                    return;
                }
                if (dataGrid1[iCurrentRow, 2].ToString() == "")
                {
                    this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
                    this.statusBar1.Text = "正在插入数据...";
                    Scores scores = new Scores();
                    scores.InsertScore(
                        Convert.ToInt32(dataGrid1[iCurrentRow, 1]),
                        Convert.ToInt32(dataGrid1[iCurrentRow, 0]),
                        Convert.ToSingle(dataGrid1[iCurrentRow, 6]));
                    scores.Dispose();
                    GetScore();
                    this.Cursor = System.Windows.Forms.Cursors.Default;
                    this.statusBar1.Text = "";
                }
                else
                {
                    this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
                    this.statusBar1.Text = "正在更新数据...";

                    Scores scores = new Scores();
                    scores.UpdateScore(
                        Convert.ToInt32(dataGrid1[iCurrentRow, 2]),
                        Convert.ToSingle(dataGrid1[iCurrentRow, 6]));
                    GetScore();
                    this.Cursor = System.Windows.Forms.Cursors.Default;
                    this.statusBar1.Text = "";
                }
            }
            catch { }

        }

        private void 关于ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            
        }

        private void 查询学生ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmSearchStudent objfrSS = new frmSearchStudent();
            objfrSS.ShowDialog();
        }

        private void 成绩查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmSearchScore objSS = new frmSearchScore();
            objSS.ShowDialog();
        }
		

       

        

        
    }
}