public StuScores OrderByScores(StudentInformation.StudentScores items)
{
StuScores stuscores = new StuScores();
switch (items.KCMC)
{
case "语文":
stuscores.stuscore = items;
stuscores.KCIndex = 1;
break;
case "数学":
stuscores.stuscore = items;
stuscores.KCIndex = 2;
break;
case "英语":
stuscores.stuscore = items;
stuscores.KCIndex = 3;
break;
case "物理":
stuscores.stuscore = items;
stuscores.KCIndex = 4;
break;
case "化学":
stuscores.stuscore = items;
stuscores.KCIndex = 5;
break;
case "生物":
stuscores.stuscore = items;
stuscores.KCIndex = 6;
break;
case "历史":
stuscores.stuscore = items;
stuscores.KCIndex = 7;
break;
case "政治":
stuscores.stuscore = items;
stuscores.KCIndex = 8;
break;
case "地理":
stuscores.stuscore = items;
stuscores.KCIndex = 9;
break;
default:
stuscores.stuscore = items;
stuscores.KCIndex = 10;
break;
}
return(stuscores);
}
public IList <StudentInformation.StudentScores> GetStudentScore(Guid userId, Guid schoolId, string year, string term, string ExamType, string ExamName)
{
StudentEntities db = new StudentEntities();
Func <View_Exam_ExamScore, bool> predicate;
Func <View_Exam_ExamScore, bool> func2;
Func <View_Exam_ExamScore, bool> func3;
Func <View_Exam_ExamScore, bool> func4;
string sql =
"select * from View_Exam_ExamScore where studentid='" + userId + "' and SchoolId = '" + schoolId + "'";
List <View_Exam_ExamScore> source = db.ExecuteStoreQuery <View_Exam_ExamScore>(sql).ToList();
//List<View_Exam_ExamScore> source =
// db.View_Exam_ExamScore.Where(x => x.StudentId == userId && x.SchoolId == schoolId).ToList();
if (!string.IsNullOrEmpty(year))
{
predicate = x => x.SchYear == year;
source = source.Where(predicate).ToList();
}
if (!string.IsNullOrEmpty(term))
{
func2 = x => x.SchTerm == term;
source = source.Where(func2).ToList();
}
if (!string.IsNullOrEmpty(ExamType))
{
func3 = delegate(View_Exam_ExamScore x)
{
int?examType = x.ExamType;
int num = Convert.ToInt32(ExamType);
return((examType.GetValueOrDefault() == num) && examType.HasValue);
};
source = source.Where(func3).ToList();
}
if (!string.IsNullOrEmpty(ExamName))
{
func4 = x => x.ExamName == ExamName;
source = source.Where(func4).ToList();
}
IList <StudentInformation.StudentScores> list2 = new List <StudentInformation.StudentScores>();
foreach (View_Exam_ExamScore score in source)
{
StudentInformation.StudentScores item = new StudentInformation.StudentScores
{
SCID = score.ScoreId.ToString(),
ClassId = score.ClassId.ToString(),
ClassName = score.ClassName,
ExamID = score.ExamId,
Score = score.Score,
SchYear = score.SchYear,
SchTerm = score.SchTerm,
ExamName = score.ExamName,
Examlevel = score.ExamLevel.ToString(),
ExamTypeCode = score.ExamType,
ExamStartTime = score.StartDate,
ExamEndTime = score.EndDate
};
if (item.SchTerm.Equals("1"))
{
item.SchTermName = "第一学期";
item.SchYearTerm = string.Concat(new object[] { Convert.ToInt32(score.SchYear) - 1, "-", score.SchYear, "学年第一学期" });
}
else
{
item.SchTermName = "第二学期";
item.SchYearTerm = string.Concat(new object[] { Convert.ToInt32(score.SchYear) - 1, "-", score.SchYear, "学年第二学期" });
}
string str = item.ExamTypeCode.ToString();
if (!string.IsNullOrEmpty(str))
{
string str2 = str;
if (str2 != "0")
{
if (str2 == "1")
{
goto Label_0403;
}
if (str2 == "2")
{
goto Label_040C;
}
if (str2 == "9")
{
goto Label_0415;
}
}
else
{
str = "平时测试";
}
}
goto Label_041F;
Label_0403:
str = "期中考试";
goto Label_041F;
Label_040C:
str = "期末考试";
goto Label_041F;
Label_0415:
str = "其他考试";
Label_041F:
item.ExamType = str;
item.KCMC = score.KCMC;
list2.Add(item);
}
//if (list2.Count == 0)
//{
// list2.Add(new StudentInformation.StudentScores());
//}
return(list2);
}