Пример #1
0
        public ActionResult Index(string user,string singal)
        {
            DataTable dt = new DataTable();
            GetScore gs = new GetScore();
            PsaEncyrpt psa = new PsaEncyrpt();
            long Singal = Convert.ToInt64(singal);
            string studentID = user;                    //从前端获取学号

            DateTime time = DateTime.Now;
            time = time.AddMinutes(-5);                 //当前时间前推5min

            Icebreaker.Models.IcebreakerEntities1 db = new IcebreakerEntities1();
            List<Icebreaker.Models.ScoreView> List = db.ScoreViews.Where(p => p.Singal == Singal ).ToList();
            string data = null;
            foreach (var a in List)
            {
                data = a.Text;
            }
            string Data = data;
            dt = gs.GetScoreTable(Data);

            int Count = dt.Rows.Count;                  //获取成绩报表总行数

            ScoreTools tool = new ScoreTools();
            int PassClassOfBottmScoreCount = 0;
            int NotPassClassCount = 0;
            double GPA = 0;

            PassClassOfBottmScoreCount = tool.GetPassClassOfBottmScoreCount(Count, dt); //获取低分飘过科目的总数
            NotPassClassCount= tool.GetNotPassClassCount(Count, dt);//获取未及格科目的数量
            GPA = tool.GetTopGPACount(Count, dt);//获取GPA大于等于4.7的数量

            return View();
        }
Пример #2
0
        public ActionResult Index(string user,string singal)
        {
            DataTable dt = new DataTable();
            GetScore gs = new GetScore();
            PsaEncyrpt psa = new PsaEncyrpt();
            long Singal = Convert.ToInt64(singal);
            string studentID = user;                    //从前端获取学号

            DateTime time = DateTime.Now;
            time = time.AddMinutes(-5);                 //当前时间前推5min

            Icebreaker.Models.IcebreakerEntities1 db = new IcebreakerEntities1();
            List<Icebreaker.Models.ScoreView> List = db.ScoreViews.Where(p => p.Singal == Singal ).ToList();
            string data = null;
            foreach (var a in List)
            {
                data = a.Text;
            }
            string Data = data;
            dt = gs.GetScoreTable(Data);
            //DataTable列名更改
            //各科成绩
            dt.Columns[0].ColumnName = "Year";
            dt.Columns[1].ColumnName = "Semester";
            dt.Columns[2].ColumnName = "Course";
            dt.Columns[3].ColumnName = "Obligatory";
            dt.Columns[4].ColumnName = "ObligatoryClass";
            dt.Columns[5].ColumnName = "Credit";
            dt.Columns[6].ColumnName = "GreadPoint";
            dt.Columns[7].ColumnName = "Score";
            dt.Columns[8].ColumnName = "LastScore";
            dt.Columns[9].ColumnName = "CollageName";

            int Count = dt.Rows.Count;                  //获取成绩报表总行数

            ScoreTools tool = new ScoreTools();
            int PassClassOfBottmScoreCount = 0;
            int NotPassClassCount = 0;
            int GPA = 0;
            string BottmScore = null;
            string TopScore = null;
            string AverageScore = null;

            PassClassOfBottmScoreCount = tool.GetPassClassOfBottmScoreCount(Count, dt); //获取低分飘过科目的总数
            NotPassClassCount= tool.GetNotPassClassCount(Count, dt);//获取未及格科目的数量
            GPA = tool.GetTopGPACount(Count, dt);//获取GPA大于等于4.7的数量
            BottmScore = tool.GetBottmScore(Count, dt);//获取最低成绩科目
            TopScore = tool.GetTopScore(Count, dt);//获取最高成绩科目
            AverageScore = tool.GetAverageScore(Count, dt);//获取个学期平均成绩

            ViewBag.AverageScore = AverageScore;

            return View();
        }