public JsonStatus RemoveProfessional(long id)
{
JsonStatus js = new JsonStatus();
List <Professional> professionals = base.Search(d => d.professional_isDel == false && d.professionalDir_id == id);
if (professionals.Count >= 1)
{
List <Student> students = professionals[0].Students.Where(d => d.student_isDel == false).Select(d => d).ToList();
StudentOperation so = new StudentOperation();
foreach (Student s in students)
{
s.student_proDirectionId = null;
so.Modify(s, "student_proDirectionId");
}
professionals[0].professional_isDel = true;
base.Modify(professionals[0], "professional_isDel");
js.status = "1";
js.msg = "删除成功！";
}
else
{
js.status = "0";
js.msg = "删除失败！数据异常！";
}
return(js);
}
public string GetProfessionaLEmphasis(long id)
{
List <Student> students = new StudentOperation().Search(d => d.student_isDel == false && d.student_id == id);
Student s = students.Count >= 1 ? students[0] : new Student();
string json = "[";
List <Professional> professionals = base.Search(d => d.professional_isDel == false);
foreach (Professional professional in professionals)
{
json = json + "{\"id\":\"" + professional.professionalDir_id + "\",\"name\":\"" + professional.professional_name + "\",\"choose\":\"" + this.GetStudentOperation(professional.professional_name, s, professional.professionalDir_id) + "\"},";
}
json = json.Substring(0, json.Length - 1) + "]";
return(json);
}
public string GetInnovationAndEnterpriseList(long id, int pageIndex, int pageSize)
{
StringBuilder json = new StringBuilder();
List <Student> students = new StudentOperation().Search(d => d.student_id == id && d.student_isDel == false);
Student s = students.Count >= 1 ? students[0] : new Student();
List <Experiment> experiments = base.Search(d => d.experiment_isDel == false && d.experiment_class == (int)ExpermentType.Creativity, d => d.experiment_id, pageIndex, pageSize);
json.Append("{\"total\":\"" + experiments.Count + "\",\"rows\":[");
foreach (Experiment experiment in experiments)
{
json.Append("{\"id\":\"" + experiment.experiment_id + "\",\"title\":\"" + experiment.experiment_title + "\",\"grade\":\"" + experiment.experiment_allowGrades + "\",\"chooseNum\":\"" + experiment.Chooses.Count(d => d.choose_ownExperimentId == experiment.experiment_id) + "\",\"totalNum\":\"" + experiment.experiment_peopleNum + "\",\"oper\":\"" + GetStudentOperatioon(experiment.experiment_peopleNum, s, experiment.Chooses.Count(d => d.choose_isDel == false), experiment.experiment_id, experiment.experiment_allowGrades.Split(','), false) + "\"},");
}
string res = json.ToString();
res = res.Length >= 2 ? res.Substring(0, res.Length - 1) + "]}" : res;
return(res);
}
public string GetSeniorProjectList(long id, int pageIndex, int pageSize)
{
StringBuilder json = new StringBuilder();
List <Student> students = new StudentOperation().Search(d => d.student_id == id && d.student_isDel == false);
Student s = students.Count >= 1 ? students[0] : new Student();
List <Experiment> experiments = base.Search(d => d.experiment_isDel == false && d.experiment_class == (int)ExpermentType.Graduate, d => d.experiment_id, pageIndex, pageSize);
json.Append("{\"total\":\"" + experiments.Count + "\",\"rows\":[");
foreach (Experiment experiment in experiments)
{
json.Append("{\"id\":\"" + experiment.experiment_id + "\",\"title\":\"" + experiment.experiment_title + "\",\"grade\":\"" + experiment.experiment_allowGrades + "\",\"chooseNum\":\"" + experiment.Chooses.Count(d => d.choose_ownExperimentId == experiment.experiment_id && d.choose_isDel == false) + "\",\"totalNum\":\"" + experiment.experiment_peopleNum + "\",\"oper\":\"" + GetStudentOperatioon(experiment.experiment_peopleNum, s, experiment.Chooses.Count(d => d.choose_isDel == false), experiment.experiment_id, experiment.experiment_allowGrades.Split(','), true) + "\",\"stuName\":\"" + (experiment.Chooses.Where(d => d.choose_isDel == false).Count() >= 1 ? experiment.Chooses.Where(d => d.choose_isDel == false).First().Student.student_name : "") + "\",\"type\":\"" + experiment.experiment_type + "\",\"src\":\"" + experiment.experiment_src + "\",\"teacher\":\"" + experiment.experiment_teacher + "\"},");
}
string res = json.ToString();
res = res.Length >= 2 ? res.Substring(0, res.Length - 1) + "]}" : res;
return(res);
}
public bool CheckGrade(string id, long sid)
{
Student stu = new StudentOperation().Search(u => u.student_id == sid)[0];
int grade = stu.student_grade;
if (string.IsNullOrEmpty(id))
{
return(false);
}
long exid = Convert.ToInt64(id);
List <Experiment> es = Search(u => u.experiment_id == exid);
if (es.Count == 1)
{
string[] s = es[0].experiment_allowGrades.Split(',');
if (s.Contains(grade.ToString()))
{
return(true);
}
}
return(false);
}
public JsonStatus ModifyStudentFromProject(string mark, string student_num, long projectId)
{
JsonStatus js = new JsonStatus();
List <Student> students = new StudentOperation().Search(d => d.student_number == student_num && d.student_isDel == false);
List <Experiment> experiments = new ExperimentOperation().Search(d => d.experiment_isDel == false && d.experiment_id == projectId);
if (experiments.Count >= 1)
{
if (students.Count >= 1)
{
switch (mark)
{
case "add":
{
if (base.SearchCount(d => d.Student.student_number == student_num && d.choose_isDel == false && d.Student.student_isDel == false) <= 0)
{
Choos c = new Choos()
{
choose_id = 1,
choose_isDel = false,
choose_ownExperimentId = projectId,
choose_ownStudentId = students[0].student_id
};
base.Add(c);
js.status = "1";
js.msg = "添加成功！";
}
else
{
js.status = "0";
js.msg = "添加失败！该学生已选择另一课题如要添加请先在另一表中删除！";
}
break;
}
case "remove":
{
List <Choos> chooses = base.Search(d => d.choose_isDel == false && d.Student.student_number == student_num && d.choose_ownExperimentId == projectId && d.choose_isDel == false);
if (chooses.Count >= 1)
{
chooses[0].choose_isDel = true;
base.Modify(chooses[0], "choose_isDel");
js.status = "1";
js.msg = "删除成功！";
}
else
{
js.status = "0";
js.msg = "删除失败！数据异常！";
}
break;
}
}
}
else
{
js.status = "0";
js.msg = mark == "add" ? "输入的学号不存在！请检查输入是否正确！" : "数据异常！";
}
}
else
{
js.status = "0";
js.msg = "操作失败！数据异常！";
}
return(js);
}
public JsonStatus ExpermentProjectChoose(string expirmentId, long studentId)
{
JsonStatus js = new JsonStatus();
List <Student> students = new StudentOperation().Search(m => m.student_id == studentId && m.student_isDel == false);
long pId = 0;
try
{
pId = Convert.ToInt64(expirmentId);
List <Experiment> experiments = new ExperimentOperation().Search(d => d.experiment_isDel == false && d.experiment_id == pId);
List <Choos> chooses = base.Search(d => d.choose_ownStudentId == studentId && d.choose_isDel == false && d.choose_ownExperimentId == pId);
if (students.Count >= 1 && experiments.Count >= 1)
{
if (experiments[0].experiment_allowGrades.Split(',').Contains(students[0].student_grade.ToString()))
{
if (experiments[0].experiment_peopleNum > base.SearchCount(d => d.choose_isDel == false && d.choose_ownExperimentId == pId))
{
if (chooses.Count == 0 && ((experiments[0].experiment_class == (int)ExpermentType.Graduate && base.SearchCount(d => d.choose_ownStudentId == studentId && d.choose_isDel == false && d.Experiment.experiment_class == (int)ExpermentType.Graduate) == 0) || experiments[0].experiment_class != (int)ExpermentType.Graduate))
{
try
{
Choos c = new Choos()
{
choose_id = 1,
choose_isDel = false,
choose_ownExperimentId = pId,
choose_ownStudentId = studentId,
};
base.Add(c);
js.status = "1";
js.msg = "选择成功！";
}
catch
{
js.status = "0";
js.msg = "选择失败！未知错误.....";
}
}
else
{
js.status = "0";
js.msg = "你已选择！不能再次选择！如要修改请联系管理员.....";
}
}
else
{
js.status = "0";
js.msg = "选择失败！人数已满.....";
}
}
else
{
js.status = "0";
js.msg = "选择失败！你现在无权选择.....";
}
}
else
{
js.status = "0";
js.msg = "选择失败！数据错误.....";
}
}
catch
{
js.status = "0";
js.msg = "选择失败！数据错误.....";
}
return(js);
}
