public ActionResult TestLibrary(CLoadTest cl) { ViewBag.Grade = string.IsNullOrEmpty(cl.Grade) ? "全部" : cl.Grade; ViewBag.Subject = string.IsNullOrEmpty(cl.Subject) ? "全部" : cl.Subject; ViewBag.Topic = string.IsNullOrEmpty(cl.Topic) ? "全部" : cl.Topic; return(View()); }
public ActionResult SetVolumeOnline(CLoadTest cl) { ViewBag.Period = string.IsNullOrEmpty(cl.Period) ? "小学试题" : cl.Period; ViewBag.Grade = string.IsNullOrEmpty(cl.Grade)?"一年级":cl.Grade; ViewBag.Grade_Son = string.IsNullOrEmpty(cl.Grade_Son)?"全部":cl.Grade_Son; ViewBag.Grade_Grandson = string.IsNullOrEmpty(cl.Grade_Grandson)?"全部":cl.Grade_Grandson; ViewBag.Subject = string.IsNullOrEmpty(cl.Subject)?"语文":cl.Subject; ViewBag.Topic = string.IsNullOrEmpty(cl.Topic)?"全部":cl.Topic; return(View()); }
public ActionResult LoadTest_SetVolume(CLoadTest cl) { EODB eodb = new EODB(); List <QuestionInfo> questioninfo = new List <QuestionInfo>(); questioninfo = (from i in eodb.questioninfo where (i.Question_Grade == ((cl.Grade == "全部") ? i.Question_Grade : cl.Grade)) && (i.Question_Grade_Son == ((cl.Grade_Son == "全部")?i.Question_Grade_Son:cl.Grade_Son)) && (i.Question_Grade_Grandson == ((cl.Grade_Grandson == "全部")?i.Question_Grade_Grandson:cl.Grade_Grandson)) && (i.Question_Subject == ((cl.Subject == "全部") ? i.Question_Subject : cl.Subject)) && (i.Question_Topic == ((cl.Topic == "全部") ? i.Question_Topic : cl.Topic)) select i).ToList <QuestionInfo>(); return(Json(questioninfo)); }
public ActionResult LoadTest(CLoadTest cl) { int level = 0; if (!string.IsNullOrEmpty(cl.Grade_Son)) { level++; } if (!string.IsNullOrEmpty(cl.Grade_Grandson)) { level++; } EODB eodb = new EODB(); List <QuestionInfo> t = new List <QuestionInfo>();; if (cl.Topic != "全部") { switch (level) { case 0: t = (from i in eodb.questioninfo where (i.Question_Subject == cl.Subject) && (i.Question_Topic == cl.Topic) && (i.Question_Grade == cl.Grade) && (i.Question_State == true) select i).ToList <QuestionInfo>(); break; case 1: t = (from i in eodb.questioninfo where (i.Question_Subject == cl.Subject) && (i.Question_Topic == cl.Topic) && (i.Question_Grade == cl.Grade) && (i.Question_Grade_Son == cl.Grade_Son) && (i.Question_State == true) select i).ToList <QuestionInfo>(); break; case 2: t = (from i in eodb.questioninfo where (i.Question_Subject == cl.Subject) && (i.Question_Topic == cl.Topic) && (i.Question_Grade == cl.Grade) && (i.Question_Grade_Son == cl.Grade_Son) && (i.Question_Grade_Grandson == cl.Grade_Grandson) && (i.Question_State == true) select i).ToList <QuestionInfo>(); break; } } else { switch (level) { case 0: t = (from i in eodb.questioninfo where (i.Question_Subject == cl.Subject) && (i.Question_Grade == cl.Grade) && (i.Question_State == true) select i).ToList <QuestionInfo>(); break; case 1: t = (from i in eodb.questioninfo where (i.Question_Subject == cl.Subject) && (i.Question_Grade == cl.Grade) && (i.Question_Grade_Son == cl.Grade_Son) && (i.Question_State == true) select i).ToList <QuestionInfo>(); break; case 2: t = (from i in eodb.questioninfo where (i.Question_Subject == cl.Subject) && (i.Question_Grade == cl.Grade) && (i.Question_Grade_Son == cl.Grade_Son) && (i.Question_Grade_Grandson == cl.Grade_Grandson) && (i.Question_State == true) select i).ToList <QuestionInfo>(); break; } } return(Json(t)); }