public string getStudentInfo() { string res = ""; StudentDao studentDao = new StudentDao(); MajorDao majorDao = new MajorDao(); ProfessorDao professorDao = new ProfessorDao(); List <Student> students = studentDao.listAllStudent(); List <AdminStudent> adminStudents = new List <AdminStudent>(); List <Major> majors = majorDao.listAllMajor(); if (students == null) { return(res); } else { foreach (Student s in students) { AdminStudent Astudent = new AdminStudent(); Astudent.id = s.id; Astudent.StuName = s.name; Astudent.major = majorDao.getMajorById(s.majorId).name; //专业方向? Astudent.infoCommited = s.infoChecked; if (s.firstWill != null && s.secondWill != null) { Astudent.twoWillCommited = true; } else { Astudent.twoWillCommited = false; } if (s.firstWillState == 1) { Astudent.FinalTutor = professorDao.getProfessorById(s.firstWill).name; } else if (s.secondWillState == 1) { Astudent.FinalTutor = professorDao.getProfessorById(s.secondWill).name; } else if (s.dispensedWill == null || s.dispensedWill == "") { Astudent.FinalTutor = null; } else { Astudent.FinalTutor = professorDao.getProfessorById(s.dispensedWill).name; } adminStudents.Add(Astudent); } JavaScriptSerializer serializer = new JavaScriptSerializer(); var json = serializer.Serialize(adminStudents); res = json.ToString(); serializer = null; } return(res); }
public string getStudents(int p) { HttpCookie accountCookie = Request.Cookies["Account"]; int usertype = int.Parse(accountCookie["type"]); int userId = int.Parse(accountCookie["userId"]); string rel = ""; List <Student> ps = null; int order = 1; AdminStudent ap = null; List <AdminStudent> list = new List <AdminStudent>(); if (p == 0) { ps = dbhelper.findAllStudents(); } else if (p == 1) { ps = dbhelper.findNoInfoStudents(); } else if (p == 2) { ps = dbhelper.findNoWillStudents(); } else if (p == 3) { ps = dbhelper.findNoFinalWillStudents(); } else { return(rel); } if (ps == null) { return(rel); } else { foreach (Student t in ps) { ap = new AdminStudent(); ap.Order = order++; ap.UserId = t.UserID; if (t.StuFinalWill == 0) { ap.StuFinalWill = "无"; } else { List <Professor> temlist = dbhelper.getProfessorByProId(t.StuFinalWill); ap.StuFinalWill = temlist[0].ProName; } ap.StuID = t.StuID; if (t.StuInfoChecked) { ap.StuInfoChecked = "是"; } else { ap.StuInfoChecked = "否"; } ap.StuName = t.StuName; if (t.StuWillChecked) { ap.StuWillChecked = "是"; } else { ap.StuWillChecked = "否"; } if (usertype == 1) { List <JiaoWu> jlist = dbhelper.getJiaoWuByJId(userId); JiaoWu j = jlist[0]; if (j.JiaoWuMajorID == t.StuMajorID) { list.Add(ap); } } else { list.Add(ap); } } JavaScriptSerializer serializer = new JavaScriptSerializer(); var json = serializer.Serialize(list); rel = json.ToString(); serializer = null; } return(rel); }
public string searchStudents(string name, int p) { string rel = ""; List <Student> ps = null; int order = 1; AdminStudent ap = null; List <AdminStudent> list = new List <AdminStudent>(); if (p == 0) { ps = dbhelper.findAllStudents(); } else if (p == 1) { ps = dbhelper.findNoInfoStudents(); } else if (p == 2) { ps = dbhelper.findNoWillStudents(); } else if (p == 3) { ps = dbhelper.findNoFinalWillStudents(); } else { return(rel); } if (ps == null) { return(rel); } else { foreach (Student t in ps) { ap = new AdminStudent(); ap.Order = order++; ap.UserId = t.UserID; if (t.StuFinalWill == 0) { ap.StuFinalWill = "无"; } else { List <Professor> temlist = dbhelper.getProfessorByProId(t.StuFinalWill); ap.StuFinalWill = temlist[0].ProName; } ap.StuID = t.StuID; if (t.StuInfoChecked) { ap.StuInfoChecked = "是"; } else { ap.StuInfoChecked = "否"; } ap.StuName = t.StuName; if (t.StuWillChecked) { ap.StuWillChecked = "是"; } else { ap.StuWillChecked = "否"; } list.Add(ap); } } if (name == "") { JavaScriptSerializer serializer = new JavaScriptSerializer(); var json = serializer.Serialize(list); rel = json.ToString(); serializer = null; } else { foreach (AdminStudent s in list) { if (s.StuName.Equals(name)) { List <AdminStudent> tem = new List <AdminStudent>(); tem.Add(s); JavaScriptSerializer serializer = new JavaScriptSerializer(); var json = serializer.Serialize(tem); rel = json.ToString(); serializer = null; } } } return(rel); }