public void AddUsuallyScore <T>(LastclassScore lastclassScore, int courseScore) where T : BaseCourse, new()
{
_MsSqlContext.Set <T>().Add(new T()
{
Id = lastclassScore.id,
Score = courseScore,
Name = lastclassScore.StudentName,
StudentInfoId = lastclassScore.StudentsInfoId,
ClassInfoId = lastclassScore.ClassInfoId,
DateTime = _encryption.Time()
});
}
public int AddUsuallyScoreToDB(LastclassScore lastclassScore)
{
var result = -1;
if (lastclassScore.Chinese != 0)
{
AddUsuallyScore <ChineseScore>(lastclassScore, lastclassScore.Chinese);
}
if (lastclassScore.Math != 0)
{
AddUsuallyScore <MathScore>(lastclassScore, lastclassScore.Math);
}
if (lastclassScore.English != 0)
{
AddUsuallyScore <EnglishScore>(lastclassScore, lastclassScore.English);
}
if (lastclassScore.Politics != 0)
{
AddUsuallyScore <PoliticsScore>(lastclassScore, lastclassScore.Politics);
}
if (lastclassScore.History != 0)
{
AddUsuallyScore <HistoryScore>(lastclassScore, lastclassScore.History);
}
if (lastclassScore.Geography != 0)
{
AddUsuallyScore <GeographyScore>(lastclassScore, lastclassScore.Geography);
}
if (lastclassScore.Physics != 0)
{
AddUsuallyScore <PhysicsScore>(lastclassScore, lastclassScore.Physics);
}
if (lastclassScore.Chemistry != 0)
{
AddUsuallyScore <ChemistryScore>(lastclassScore, lastclassScore.Chemistry);
}
if (lastclassScore.Biology != 0)
{
AddUsuallyScore <BiologyScore>(lastclassScore, lastclassScore.Biology);
}
try
{
result = _MsSqlContext.SaveChanges();
}
catch (Exception e)
{
_loggerHelper.WriteInfoLog(e);
throw;
}
return(result);
}
/// <summary>
/// 添加单科成绩
/// </summary>
/// <param name="lastclassScore"></param>
/// <returns></returns>
public int AddUsuallyScore(LastclassScore lastclassScore)
{
return(_create.AddUsuallyScoreToDB(lastclassScore));
}
