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個文件信息