C#实例学生管理系统133168

学生管理系统，包括：成绩管理1成绩分析2成绩统计；查询统计1学生成绩查询2学生选课情况；打印报表

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace Couse_Score
{
    class Class
    {
        private string classid;

        public Class（string id）
        {
            ClassID = id;
        }

        public string ClassID
        {
            get
            { return classid; }
            set
            { classid = value; }
        }

        public int AllCount
        {
            get { return （int）Database.ExecuteScaler（“select count（1） from student where classid=‘“+classid +“‘“）; }
        }

        public int A_Count
        {
            get { return （int）Database.ExecuteScaler（“select count（1） from elective where classid=‘“ + classid + “‘ and couseid like ‘A%‘“）; }
        }

        public int B_Count
        {
            get { return （int）Database.ExecuteScaler（“select count（1） from elective where classid=‘“ + classid + “‘ and couseid like ‘B%‘“）; }
        }

        public int C_Count
        {
            get { return （int）Database.ExecuteScaler（“select count（1） from elective where classid=‘“ + classid + “‘ and couseid like ‘C%‘“）; }
        }

       public int[] CreditCounts
       {
           get 
           {
               DataTable dt = Database.SelectDataTable（“ select creditcount（1） as stucnt from“ + 
                                                            “ （select studentidcount（1） as credit from elective“+
                                                            “ where classid=‘“+classid +“‘ and score>=60“+
                                                            “ group by studentid）“+
                                                       “ group by credit order by credit“
                                                        ）;
               int[] rst = new int[4] { 0000};
               foreach （DataRow drw in dt.Rows）
               {
                   int i = int.Parse （ drw[“credit“].ToString（））;
                   rst[i] = int.Parse （drw[“stucnt“].ToString（））;
               }
               rst[0] = AllCount - rst[3] - rst[2] - rst[1];
               return rst;
           }
       }

    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        922  2010-06-30 12:57  Couse_Score\Couse_Score.sln

    ..A..H.     29696  2010-08-26 14:27  Couse_Score\Couse_Score.suo

     文件       2210  2010-07-04 14:32  Couse_Score\Couse_Score\Class.cs

     文件       4610  2010-07-02 13:58  Couse_Score\Couse_Score\Couse.cs

     文件       4971  2010-07-04 10:34  Couse_Score\Couse_Score\Couse_Score.csproj

     文件        558  2010-06-30 18:12  Couse_Score\Couse_Score\Couse_Score.csproj.user

     文件       4125  2010-08-17 12:06  Couse_Score\Couse_Score\Database.cs

     文件       1733  2010-07-04 14:19  Couse_Score\Couse_Score\FrmClassStatic.cs

     文件      15054  2010-07-04 10:40  Couse_Score\Couse_Score\FrmClassStatic.Designer.cs

     文件       7010  2010-07-04 10:40  Couse_Score\Couse_Score\FrmClassStatic.resx

     文件        920  2010-06-30 22:23  Couse_Score\Couse_Score\FrmMain.cs

     文件       5613  2010-06-30 22:23  Couse_Score\Couse_Score\FrmMain.Designer.cs

     文件       6010  2010-06-30 22:23  Couse_Score\Couse_Score\FrmMain.resx

     文件       3089  2010-07-04 11:09  Couse_Score\Couse_Score\FrmScoreAnalysis.cs

     文件      25228  2010-07-02 14:23  Couse_Score\Couse_Score\FrmScoreAnalysis.Designer.cs

     文件       7270  2010-07-02 14:23  Couse_Score\Couse_Score\FrmScoreAnalysis.resx

     文件       4722  2010-08-17 12:06  Couse_Score\Couse_Score\FrmScoreInput.cs

     文件      14550  2010-08-17 12:06  Couse_Score\Couse_Score\FrmScoreInput.Designer.cs

     文件      11254  2010-08-17 12:06  Couse_Score\Couse_Score\FrmScoreInput.resx

     文件       1472  2010-07-04 11:10  Couse_Score\Couse_Score\FrmStudentQuery.cs

     文件       8861  2010-07-04 11:10  Couse_Score\Couse_Score\FrmStudentQuery.Designer.cs

     文件       7693  2010-07-04 11:10  Couse_Score\Couse_Score\FrmStudentQuery.resx

     文件        472  2010-06-30 12:58  Couse_Score\Couse_Score\Program.cs

     文件       1546  2010-07-01 14:48  Couse_Score\Couse_Score\Student.cs

     文件      57344  2010-08-17 12:06  Couse_Score\Couse_Score\bin\Debug\Couse_Score.exe

     文件     103936  2010-08-17 12:06  Couse_Score\Couse_Score\bin\Debug\Couse_Score.pdb

     文件       5632  2005-12-08 14:51  Couse_Score\Couse_Score\bin\Debug\Couse_Score.vshost.exe

     文件     356352  2010-08-17 12:02  Couse_Score\Couse_Score\bin\Debug\XKDB.mdb

     文件        492  2010-08-26 14:27  Couse_Score\Couse_Score\obj\Couse_Score.csproj.FileList.txt

     文件       1114  2010-08-17 12:06  Couse_Score\Couse_Score\obj\Debug\Couse_Score.csproj.GenerateResource.Cache

............此处省略117个文件信息