/* * @param 0 表示全部老师 * @param 1 表示名额未满老师 * */ public string getProfessors(int p) { string rel = ""; List <Professor> ps = null; int order = 1; AdminProfessor ap = null; List <AdminProfessor> list = new List <AdminProfessor>(); if (p == 0) { ps = dbhelper.findAllProfessors(); } else if (p == 1) { ps = dbhelper.findNotFullProfessors(); } else { return(rel); } if (ps == null) { return(rel); } else { foreach (Professor t in ps) { ap = new AdminProfessor(); ap.Order = order++; ap.UserId = t.UserID; ap.ProMaxNum = t.ProMaxNum; ap.ProName = t.ProName; ap.ProNum = t.ProNum; ap.ProInfoUrl = t.ProInfoUrl; if (t.ProTitle == 0) { ap.ProTitle = "讲师"; } else if (t.ProTitle == 1) { ap.ProTitle = "副教授"; } else { ap.ProTitle = "教授"; } list.Add(ap); } JavaScriptSerializer serializer = new JavaScriptSerializer(); var json = serializer.Serialize(list); rel = json.ToString(); serializer = null; } return(rel); }
public string searchProfessors(string professorName, int p) { string rel = ""; List <Professor> ps = null; int order = 1; AdminProfessor ap = null; List <AdminProfessor> list = new List <AdminProfessor>(); if (p == 0) { ps = dbhelper.findAllProfessors(); } else if (p == 1) { ps = dbhelper.findNotFullProfessors(); } else { return(rel); } if (ps == null) { return(rel); } else { foreach (Professor t in ps) { ap = new AdminProfessor(); ap.Order = order++; ap.UserId = t.UserID; ap.ProMaxNum = t.ProMaxNum; ap.ProName = t.ProName; ap.ProNum = t.ProNum; if (t.ProTitle == 0) { ap.ProTitle = "讲师"; } else if (t.ProTitle == 1) { ap.ProTitle = "副教授"; } else { ap.ProTitle = "教授"; } list.Add(ap); } JavaScriptSerializer serializer = new JavaScriptSerializer(); if (professorName == "") { var json = serializer.Serialize(list); rel = json.ToString(); serializer = null; } else { List <AdminProfessor> tempList = new List <AdminProfessor>(); AdminProfessor temp = null; foreach (AdminProfessor t in list) { if (professorName == t.ProName) { temp = t; break; } } tempList.Add(temp); var json = serializer.Serialize(tempList); rel = json.ToString(); serializer = null; } } return(rel); }
public string getProfessors() { try { ProfessorDao professorDao = new ProfessorDao(); StudentDao studentDao = new StudentDao(); string res = ""; List <Professor> psList = null; AdminProfessor ap = null; List <AdminProfessor> apsList = new List <AdminProfessor>(); psList = professorDao.listAllProfessor(); if (psList == null) { return(res); } else { foreach (Professor p in psList) { ap = new AdminProfessor(); ap.proId = p.id; ap.proName = p.name; ap.proTitle = p.title; ap.proQuota = (professorDao.getProfessorById(p.id)).quota; ap.ProInfoUrl = (professorDao.getProfessorById(p.id)).infoURL; int ProFirstNum = 0, ProSecondNum = 0, ProAssignNum = 0; List <Student> stlist = studentDao.listAllStudent(); if (stlist != null && stlist.Count > 0) { foreach (Student s in stlist) { if (s.firstWill == p.id && s.firstWillState == 1) { ProFirstNum++; } else if (s.secondWill == p.id && s.secondWillState == 1) { ProSecondNum++; } else if (s.dispensedWill == p.id) { ProAssignNum++; } } } ap.ProFirstNum = ProFirstNum; ap.ProSecondNum = ProSecondNum; ap.ProAssignNum = ProAssignNum; ap.ProRestNum = ap.proQuota - ProFirstNum - ProSecondNum - ProAssignNum; apsList.Add(ap); } JavaScriptSerializer serializer = new JavaScriptSerializer(); var json = serializer.Serialize(apsList); res = json.ToString(); serializer = null; } return(res); } catch (Exception e) { LogUtil.writeLogToFile(e, Request); return("平台出现异常,请联系管理员:XXX"); } }