using?System;
using?System.Web.UI.WebControls;
using?System.Globalization;
using?System.Data;

public?partial?class?StudentAdmin_FinalGradeLook?:?System.Web.UI.Page
{
????public?DataTable?DTYeMian;?
????public?DataTable?DTYeMian2;
????public?DataTable?DTYeMian3;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????string?sql;
????????sql?=?string.Format（“select?*?from?txClass?where?class_majorid?in?（select?tmajor_majorid?from?tjTMajor?where?tmajor_userid?=‘{0}‘）??ORDER?BY??class_name?ASC“?Session[“StudentUserName“]）;
????????DTYeMian?=?DB.GetRows（sql）;
????????string?sql2;
????????sql2?=?string.Format（“select?distinct?Course_idCourse_name?from?txuser?left?outer?join?txclass?on?user_classid=class_id??left?outer?join?txmajor?on?class_majorid=major_id?left?outer?join?tjMajorCourse?on?major_id=mc_majorid?left?outer?join?txcourse?on?mc_courseid=course_id?where?user_id=‘{0}‘??ORDER?BY??course_name?ASC“?Session[“StudentUserName“]）;
????????DTYeMian2?=?DB.GetRows（sql2）;
????????string?sql3;
????????sql3?=?“select?*?from?txyear?where?year_isuse=1“;
????????DTYeMian3?=?DB.GetRows（sql3）;
????????Con（）;
????}
????#region??分頁顯示
????public?void?Con（）
????{
????????String?Sql?=?string.Format（@“select??*case?when??score?=0?then?‘未錄‘??when??score?<60?then?‘不合格‘?else?‘合格‘?end?as?bz?from?（?select?*psfs*0.2+isnull（grade_test0）*0.3+isnull（grade_final0）*0.5?as?score??from?（??select?ROW_NUMBER（）?over（order?by?user_id）?as?xh*isnull（nGrade_check0）*0.3+isnull（nGrade_midterm0）*0.3+isnull（nGrade_homework0）*0.4?as?psfs?from?txUser?left?outer?join?txClass??on?User_classid=Class_id?
?????????????????????left?outer?join?tjGrade?on?user_id=Grade_userid?left?outer?join?txCourse?on?Grade_courseid=course_id??left?outer?join?tjngrade?on?grade_year=ngrade_year?and?grade_userid=ngrade_userid?and?grade_courseid=ngrade_courseid）?aa?）aaa
????????????????????????where??User_type=2????and?ngrade_userid=‘{0}‘“?Session[“StudentUserName“]）;;
????????int?year?=?0;
????????if?（Session[“df_year“]?!=?null）
????????????year?=?Convert.ToInt32（Session[“df_year“].ToString（））;
????????if?（year?!=?0）
????????????Sql?+=?string.Format（“?and??grade_year={0}“?year）;
????????PagedDataSource?Pds?=?new?PagedDataSource（）;
????????Pds.DataSource?=?DB.GetRows（Sql）.DefaultView;
????????Pds.AllowPaging?=?true;//允許分頁
????????Pds.PageSize?=?10;//單頁顯示項數
????????int?CurPage;

????????if?（Request.QueryString[“Page“]?!=?null）
????????????CurPage?=?Convert.ToInt32（Request.QueryString[“Page“]）;
????????else
????????????CurPage?=?1;

????????Pds.CurrentPageIndex?=?CurPage?-?1;
????????int?Count?=?Pds.PageCount;

????????lblCurrentPage.Text?=?“當前頁：“?+?CurPage.ToString（）?+?“頁“?+?“/“?+?Count.ToString（）?+?“頁“;

????????this.last.NavigateUrl?=?Request.CurrentExecutionFilePath?+?“?Page=“?+?Convert.ToString（Count）;

????????if?（!Pds.IsFirstPage）
????????{
????????????this.first.NavigateUrl?=?Request.CurrentExecutionFilePath?+?“?Page=1“;
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????16662??2018-09-17?16:40??學生信息錄入系統V4.0\1.jpg

?????文件??????11878??2018-09-17?16:42??學生信息錄入系統V4.0\2.jpg

?????文件??????65831??2018-09-17?16:42??學生信息錄入系統V4.0\3.jpg

?????文件??????85883??2018-09-12?17:06??學生信息錄入系統V4.0\StudentXinXi\.vs\config\applicationhost.config

????..A..H.????114176??2018-09-17?14:09??學生信息錄入系統V4.0\StudentXinXi\.vs\StudentXinXi\v14\.suo

?????文件??????63981??2013-10-09?15:04??學生信息錄入系統V4.0\StudentXinXi\404\css\dandelion.css

?????文件????????111??2012-06-06?16:42??學生信息錄入系統V4.0\StudentXinXi\404\images\blueprint.png

?????文件????????131??2012-06-06?12:38??學生信息錄入系統V4.0\StudentXinXi\404\images\carbon.png

?????文件??????61532??2012-06-06?12:38??學生信息錄入系統V4.0\StudentXinXi\404\images\error-hanger.png

?????文件???????2160??2012-06-06?12:38??學生信息錄入系統V4.0\StudentXinXi\404\images\error-pin.png

????..A.SH.??????8704??2015-07-17?09:49??學生信息錄入系統V4.0\StudentXinXi\404\images\Thumbs.db

?????文件???????1511??2018-03-02?10:42??學生信息錄入系統V4.0\StudentXinXi\404\index.html

?????文件?????????27??2016-07-19?17:16??學生信息錄入系統V4.0\StudentXinXi\404\說明.txt

?????文件???????5806??2019-03-06?12:41??學生信息錄入系統V4.0\StudentXinXi\App_Code\DBaccess.cs

?????文件???????6845??2019-03-16?15:28??學生信息錄入系統V4.0\StudentXinXi\App_Code\ExImport.cs

?????文件???????1035??2018-09-17?10:56??學生信息錄入系統V4.0\StudentXinXi\App_Data\PublishProfiles\123.pubxml

?????文件?????352256??2018-09-17?11:00??學生信息錄入系統V4.0\StudentXinXi\App_Data\Student.mdb

?????文件??????10953??2018-02-05?22:31??學生信息錄入系統V4.0\StudentXinXi\App_Data\數據庫表.xlsx

?????文件??????13363??2009-05-14?20:18??學生信息錄入系統V4.0\StudentXinXi\attached\1.jpg

?????文件??????10240??2018-09-17?10:32??學生信息錄入系統V4.0\StudentXinXi\attached\SXX.xls

?????文件??????14336??2018-09-17?10:33??學生信息錄入系統V4.0\StudentXinXi\attached\SZH.xls

?????文件??????49664??2013-11-23?15:48??學生信息錄入系統V4.0\StudentXinXi\Bin\LitJSON.dll

?????文件??????26132??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap-theme.css

?????文件??????47706??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap-theme.css.map

?????文件??????23409??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap-theme.min.css

?????文件??????25648??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap-theme.min.css.map

?????文件?????146010??2018-09-14?11:27??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap.css

?????文件?????389287??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap.css.map

?????文件?????121200??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap.min.css

?????文件?????542194??2016-07-25?15:53??學生信息錄入系統V4.0\StudentXinXi\bootstrap-3.3.7\css\bootstrap.min.css.map

............此處省略577個文件信息