public string Exjson(string pageIndex, string pageSize, int type) { if (string.IsNullOrEmpty(pageIndex) || string.IsNullOrEmpty(pageSize)) { pageIndex = "1"; pageSize = "60"; } int ipageIndex = Convert.ToInt32(pageIndex); int ipageSize = Convert.ToInt32(pageSize); ExperimentOperation eo = new ExperimentOperation(); long count = eo.SearchCount(u => u.experiment_isDel == false && u.experiment_class == type); List <Experiment> experiments = eo.Search(u => u.experiment_isDel == false && u.experiment_class == type, i => i.experiment_title, ipageIndex, ipageSize); StringBuilder sb = new StringBuilder(); string s = "{\"total\":" + count + ",\"rows\":["; sb.Append(s); foreach (Experiment e in experiments) { long id = e.experiment_id; long chooseSNum = new ChooseOperation().SearchCount(u => u.choose_id == id && u.choose_isDel == false); s = "{\"id\":\"" + e.experiment_id + "\",\"title\":\"" + e.experiment_title + "\",\"num\":\"" + chooseSNum + "\",\"max\":\"" + e.experiment_peopleNum + "\",\"btn\":\" <button class='btn' value='" + e.experiment_id + "' type='button'>选择</button>\"},"; sb.Append(s); } s = sb.ToString(); if (count > 0) { s = s.Substring(0, s.Length - 1); } return(s + "]}"); }
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); }