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);
}
