根据某个分数来计算排名

 

linq:OrderByDescending 按指定表达式对集合倒序排序;延迟

第一步:查询出学生成绩表中的数据

using (var db = new SMSPModel.SMSPEntities())
            {
                db.CommandTimeout = 0;
                var tb = (from p in db.tbExamMark
                          where p.tbExamCourse.ID == this.DrplstExamCourse1.ExamCourseId
                          && p.RecordStatus == decimal.One
                          && p.tbExamCourse.RecordStatus == decimal.One
                          && p.tbExamCourse.tbExamBasis.ID == this.DrplstExam1.ExamId
                          && p.tbExamCourse.tbCourseBasis.RecordStatus == decimal.One
                          && p.tbExamCourse.tbCourseBasis.tbSubjectBasis.RecordStatus == decimal.One
                          && p.tbExamCourse.tbCourseBasis.tbSubjectBasis.tbAreaBasis.RecordStatus == decimal.One
                          && p.tbStudentBasis.RecordStatus == decimal.One
                          && p.tbStudentBasis.StudentStatus == decimal.One
                          orderby p.tbStudentBasis.StudentCode
                          select new ExamMark
                                 {
                                     StudentId = p.tbStudentBasis.ID,
                                     StudentCode = p.tbStudentBasis.StudentCode,
                                     StudentName = p.tbStudentBasis.StudentName,
                                     ClassName = (from p0 in db.tbClassStudent
                                                  where p0.RecordStatus == decimal.One &&
                                                        p0.tbStudentBasis.ID == p.tbStudentBasis.ID &&
                                                        p0.tbClassBasis.tbYear.FromDate <= p.tbExamCourse.tbExamBasis.tbYear.FromDate &&
                                                        p0.tbClassBasis.tbYear.ToDate >= p.tbExamCourse.tbExamBasis.tbYear.ToDate &&
                                                        p0.tbClassBasis.tbYear.tbYearGroup.GroupNo == decimal.One
                                                  select p0.tbClassBasis.ClassName).FirstOrDefault(),
                                     AppraiseMark = p.AppraiseMark == decimal.MinusOne ? null : (decimal?)p.AppraiseMark,
                                     Mark1 = p.Mark1 == decimal.MinusOne ? null : (decimal?)p.Mark1,
                                     Mark2 = p.Mark2 == decimal.MinusOne ? null : (decimal?)p.Mark2,
                                     TotalMark = p.TotalMark == decimal.MinusOne ? null : (decimal?)p.TotalMark,
                                     TotalGradeRank = p.TotalGradeRank == decimal.MinusOne ? null : (decimal?)p.TotalGradeRank,
                                     SegmentMark = p.SegmentMark == decimal.MinusOne ? null : (decimal?)p.SegmentMark,
                                     SegmentGradeRank = p.SegmentGradeRank == decimal.MinusOne ? null : (decimal?)p.SegmentGradeRank,
                                     LevelName = p.tbExamLevel.LevelName,
                                     GetPoint = p.tbExamLevel.LevelValue > decimal.Zero ? p.tbExamCourse.tbCourseBasis.CoursePoint : decimal.Zero,
                                     StudyPoint = p.tbExamCourse.tbCourseBasis.CoursePoint * (p.tbExamLevel.LevelName == "---" ? decimal.Zero : p.tbExamLevel.LevelValue)
                                 }).Distinct().OrderByDescending(c => c.SegmentMark).ToList();

第二步,根据SegmentMark  综合分 进行排名

 //重新排名(综合分排名)
                var studentScoresRankList = (from p in tb
                                             select new ExamMark
                                             {
                                                 StudentId = p.StudentId,
                                                 StudentCode = p.StudentCode,
                                                 StudentName = p.StudentName,
                                                 ClassName = p.ClassName,
                                                 AppraiseMark = p.AppraiseMark,
                                                 Mark1 = p.Mark1,
                                                 Mark2 = p.Mark2,
                                                 TotalMark = p.TotalMark,
                                                 TotalGradeRank = p.TotalGradeRank,
                                                 SegmentMark = p.SegmentMark,
                                                 LevelName = p.LevelName,
                                                 GetPoint = p.GetPoint,
                                                 StudyPoint = p.StudyPoint,
                                                 SegmentGradeRank = tb.Select(c => c.SegmentMark).ToList().IndexOf(p.SegmentMark) + 1,
                                             }).OrderBy(c => c.TotalGradeRank).ToList();


                return studentScoresRankList;

  然后排名就出来了,然后重新绑定就可以了。

 

转载于:https://www.cnblogs.com/kksguijiao/p/4705197.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值