public List <SingleScoreInfo> GetSingleScoreList(Guid ClassIDNum, Guid PaperIDNum)
{
List <SingleScoreInfo> SingleScoreInfoList = new List <SingleScoreInfo>();
List <CEDTS_User> userlist = _user.SelectUserByClassID(ClassIDNum);
CEDTS_Paper paper = _paper.GetPaperByID(PaperIDNum);
double totalscore = paper.Score.Value;
foreach (var user in userlist)
{
SingleScoreInfo eachsinglescore = new SingleScoreInfo();
eachsinglescore.UserID = user.UserID;
eachsinglescore.StudNum = user.StudentNumber;
eachsinglescore.StudName = user.UserNickname;
eachsinglescore.TotalScore = totalscore;
CEDTS_Test test = _paper.GetTestByPaperID(SinglePaperID, user.UserID);
if (test == null || test.IsFinished == false)
{
eachsinglescore.Done = false;
eachsinglescore.Score = 0;
eachsinglescore.Percent = 0;
}
else
{
eachsinglescore.Done = true;
eachsinglescore.Score = test.TotalScore.Value;
eachsinglescore.Percent = test.TotalScore.Value / totalscore * 100;
}
SingleScoreInfoList.Add(eachsinglescore);
}
return(SingleScoreInfoList);
}
void ICedts_TestRepository.UpdateTest(CEDTS_Test test)
{
var oldtest = db.CEDTS_Test.Where(p => p.TestID == test.TestID).FirstOrDefault();
db.ApplyCurrentValues <CEDTS_Test>(oldtest.EntityKey.EntitySetName, test);
db.SaveChanges();
}
public ActionResult Remark(FormCollection form)
{
this.ValidateRequest = false;
Guid testID = Guid.Parse(form["testid"]);
string content = form["myEditor"];
content = content.Substring(3, content.LastIndexOf('p') - 5);
CEDTS_Test test = _test.GetTest(testID);
test.Remark = content;
test.IsChecked = 1;
_test.UpdateTest(test);
return(RedirectToAction("Index"));
}
public ActionResult Suggestions(int UserID, Guid PaperID)
{
CEDTS_Test test = _paper.GetTestByPaperID(PaperID, UserID);
string Content = String.Empty;
if (test == null || test.IsFinished == false)
{
Content = "该生暂未练习。";
}
else
{
double score = test.TotalScore.Value;
double paperscore = _paper.GetPaperByID(PaperID).Score.Value;
string face = string.Empty;
double ScoreRate = score / paperscore;
if (ScoreRate >= 0.9)
{
face = "优秀<img src='../../../../Images/1.1.gif'></img>";
}
if (ScoreRate < 0.9 && ScoreRate >= 0.8)
{
face = "良好<img src='../../../../Images/1.2.gif'></img>";
}
if (ScoreRate < 0.8 && ScoreRate >= 0.7)
{
face = "一般<img src='../../../../Images/1.3.gif'></img>";
}
if (ScoreRate < 0.7 && ScoreRate >= 0.6)
{
face = "及格<img src='../../../../Images/1.4.gif'></img>";
}
if (ScoreRate < 0.6 && ScoreRate >= 0.5)
{
face = "不及格<img src='../../../../Images/1.5.gif'></img>";
}
if (ScoreRate < 0.5)
{
face = "很差<img src='../../../../Images/1.6.gif'></img>";
}
Content = "<b>试卷总分：</b>" + paperscore + "分, <b>实际得分：</b>" + score + "分," + face + "。";
}
return(Json(Content));
}
public ActionResult AssignedExercise(int?id)
{
List <ScoreInfo> scorelist = new List <ScoreInfo>();
int UserID = _user.SelectUserByAccout(User.Identity.Name).UserID;
List <Guid?> paclist = _paper.SelectPaperByPeriod(BeginTime, EndTime, UserID, ClassID);
List <CEDTS_User> userlist = _user.SelectUserByClassID(ClassID);
foreach (var user in userlist)
{
ScoreInfo eachscore = new ScoreInfo();
eachscore.UserID = user.UserID;
eachscore.StudNum = user.StudentNumber;
eachscore.StudName = user.UserNickname;
eachscore.TestNames = new List <string>();
eachscore.TestScore = new List <double>();
List <CEDTS_Test> usertest = _paper.SelectTestByPeriod(BeginTime, EndTime, user.UserID);
foreach (var pac in paclist)
{
CEDTS_Paper paper = _paper.GetPaperByID(Guid.Parse(pac.ToString()));
eachscore.TestNames.Add(paper.Title);
CEDTS_Test test = _paper.GetTestByPaperID(Guid.Parse(pac.ToString()), user.UserID);
if (test != null && test.IsFinished == true)
{
eachscore.TestScore.Add(double.Parse(test.TotalScore.ToString()) / double.Parse(paper.Score.ToString()) * 100);
}
else
{
eachscore.TestScore.Add(0);
}
}
double totalscore = 0.0;
foreach (var score in eachscore.TestScore)
{
totalscore += score;
}
eachscore.AveScore = totalscore / eachscore.TestScore.Count;
scorelist.Add(eachscore);
}
ViewData["StartDate"] = BeginTime;
ViewData["EndDate"] = EndTime;
ViewData["ClassName"] = ClassName;
return(View(_paper.ScoreInfoPaged(id, scorelist)));
}
public ActionResult SingleTest(int id)
{
CEDTS_Paper paper = _paper.GetPaperByID(SinglePaperID);
ViewData["UserID"] = id;
ViewData["PaperID"] = SinglePaperID;
ViewData["PaperName"] = paper.Title;
ViewData["PaperState"] = paper.State;
CEDTS_Test test = _paper.GetTestByPaperID(SinglePaperID, id);
if (test == null || test.IsFinished == false)
{
ViewData["TestID"] = "";
}
else
{
ViewData["TestID"] = test.TestID;
}
return(View());
}
public ActionResult AllExercise(int?id)
{
List <ScoreInfo> scorelist = new List <ScoreInfo>();
int UserID = _user.SelectUserByAccout(User.Identity.Name).UserID;
List <Guid?> paclist = _paper.SelectPaperByPeriod(BeginTime, EndTime, UserID, ClassID);
List <CEDTS_User> userlist = _user.SelectUserByClassID(ClassID);
foreach (var user in userlist)
{
ScoreInfo eachscore = new ScoreInfo();
eachscore.UserID = user.UserID;
eachscore.StudNum = user.StudentNumber;
eachscore.StudName = user.UserNickname;
eachscore.TestNames = new List <string>();
eachscore.TestScore = new List <double>();
List <CEDTS_Test> usertest = _paper.SelectTestByPeriod(BeginTime, EndTime, user.UserID);
foreach (var pac in paclist)
{
CEDTS_Paper paper = _paper.GetPaperByID(Guid.Parse(pac.ToString()));
eachscore.TestNames.Add(paper.Title);
CEDTS_Test test = _paper.GetTestByPaperID(Guid.Parse(pac.ToString()), user.UserID);
if (test != null && test.IsFinished == true)
{
eachscore.TestScore.Add(double.Parse(test.TotalScore.ToString()) / double.Parse(paper.Score.ToString()) * 100);
}
else
{
eachscore.TestScore.Add(0);
}
}
int donenum = 0;
double userscore = 0.0;
double totalscore = 0.0;
foreach (var test in usertest)
{
if (!paclist.Contains(test.PaperID))
{
List <CEDTS_PaperAssessment> assessment = _paper.SelectPaperAssessmentItem(test.PaperID);
foreach (var ass in assessment)
{
donenum += _paper.SelectQNByAssessmentID(Guid.Parse(ass.AssessmentItemID.ToString()));
}
userscore += double.Parse(test.TotalScore.ToString());
totalscore += double.Parse(_paper.SelectPaper(test.PaperID).Score.ToString());
}
}
eachscore.DoneNum = donenum;
if (totalscore == 0)
{
eachscore.DoneScore = 0.0;
}
else
{
eachscore.DoneScore = userscore / totalscore * 100;
}
double avescore = 0.0;
foreach (var score in eachscore.TestScore)
{
avescore += score;
}
eachscore.AveScore = (avescore + eachscore.DoneScore) / (eachscore.TestScore.Count + 1);
scorelist.Add(eachscore);
}
ViewData["StartDate"] = BeginTime;
ViewData["EndDate"] = EndTime;
ViewData["ClassName"] = ClassName;
return(View(_paper.ScoreInfoPaged(id, scorelist)));
}
