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 string GetJsonTime(string exId) { if (string.IsNullOrEmpty(exId)) { return("error"); } long id = Convert.ToInt64(exId); List <Experiment> exs = new Experiments().Search(j => j.experiment_id == id); StringBuilder sb = new StringBuilder(); string s = "{\"total\":" + exs.Count + ",\"rows\":["; sb.Append(s); int index = 0; foreach (Experiment e in exs) { string timeID = e.experiment_week; long count = new ChooseOperation().SearchCount(k => k.choose_ownExperimentId == id); s = "{\"id\":\"" + e.experiment_id + "\",\"week\":\"" + e.experiment_week + "\",\"num\":\"" + count + "\",\"max\":\"" + e.experiment_peopleNum + "\",\"timebtn\":\"<button name=" + (index++) + " class='timebtn' value='" + e.experiment_id + "'>选择 </button>\"},"; sb.Append(s); } if (exs.Count != 0) { s = sb.ToString(); s = s.Substring(0, (s.Length - 1)); } return(s + "]}"); }
public string AddChooseStu(string id, string exid) { try { List <Student> stus = Search(u => u.student_number == id && u.student_isDel == false); if (stus.Count == 0) { return("没有此学号的学生"); } else if (stus.Count > 1) { return("学号重复,添加失败"); } ChooseOperation co = new ChooseOperation(); long stuid = stus[0].student_id; long experId = Convert.ToInt64(exid); long count = co.SearchCount(u => u.choose_ownStudentId == stuid && u.choose_isDel == false && u.choose_ownExperimentId == experId); if (count > 0) { return("此同学已经存在,请勿重新添加"); } Choos c = new Choos(); c.choose_isDel = false; c.choose_ownExperimentId = Convert.ToInt64(exid); c.choose_ownStudentId = stus[0].student_id; co.Add(c); } catch { return("未知错误"); } return("ok"); }
public string GetStudentJson(string id, bool isExtime, string time) { long exid = Convert.ToInt64(id); List <Choos> chos = new List <Choos>(); if (time == "全部") { chos = new ChooseOperation().Search(i => i.choose_ownExperimentId == exid && i.choose_isDel == false); } else { chos = new ChooseOperation().Search(i => i.choose_ownExperimentId == exid && i.choose_isDel == false && i.choose_ExperimenTimet == time); } StringBuilder sb = new StringBuilder(); sb.Append("{\"total\":" + chos.Count + ",\"rows\":["); foreach (Choos c in chos) { sb.Append("{\"id\":\"" + c.Student.student_number + "\",\"name\":\"" + c.Student.student_name + "\",\"pro\":\"" + c.Student.student_professional + "\",\"grade\":\"" + c.Student.student_grade + "\",\"dir\":\"" + c.Student.Professional.professional_name + "\",\"time\":\"" + c.choose_ExperimenTimet + "\"},"); } string s = sb.ToString(); if (chos.Count != 0) { s = s.Substring(0, s.Length - 1); } return(s + "]}"); }
private string GetStudentOperatioon(int people_number, Student s, int choosePeopleNumber, long experimentId, string[] allowGrade, bool isLimit) { bool isChoose = new ChooseOperation().SearchCount(d => d.choose_ownExperimentId == experimentId && d.choose_isDel == false && d.choose_ownStudentId == s.student_id) >= 1; bool isHave = isLimit ? new ChooseOperation().SearchCount(d => d.choose_isDel == false && d.choose_ownStudentId == s.student_id && d.Experiment.experiment_class == (int)ExpermentType.Graduate) >= 1 : false; return(isLimit ? (s == null ? "---" : (isChoose ? "已选择" : (allowGrade.Contains(s.student_grade.ToString()) ? choosePeopleNumber >= people_number ? "人数已满" : (isHave ? "---" : "<button class='choose' value='" + experimentId + "'>选择</button>") : "---"))) : (s == null ? "---" : (isChoose ? "已选择" : (allowGrade.Contains(s.student_grade.ToString()) ? (choosePeopleNumber >= people_number ? "人数已满" : "<button class='choose' value='" + experimentId + "'>选择</button>") : "---")))); }
public string DelChoose(string id, string exid) { List <Student> stus = Search(u => u.student_number == id && u.student_isDel == false); if (stus.Count == 0) { return("没有此学号的学生"); } long sid = stus[0].student_id; long experimentid = Convert.ToInt64(exid); List <Choos> cs = new ChooseOperation().Search(u => u.choose_ownStudentId == sid && u.choose_isDel == false && u.choose_ownExperimentId == experimentid); cs[0].choose_isDel = true; new ChooseOperation().Modify(cs[0], "choose_isDel"); return("ok"); }
private string ExListToJson(List <Experiment> experiments, long totalCount, int type) { StringBuilder sb = new StringBuilder(); string s = "{\"total\":" + totalCount + ",\"rows\":["; sb.Append(s); foreach (Experiment e in experiments) { long id = e.experiment_id; long count = new ChooseOperation().SearchCount(u => u.choose_ownExperimentId == id && u.choose_isDel == false); s = "{\"id\":\"" + e.experiment_id + "\",\"name\":\"" + e.experiment_title + "\",\"week\":\"" + e.experiment_week + "\",\"allGrade\":\"" + e.experiment_allowGrades + "\",\"number\":\"" + count + "\",\"max\":\"" + e.experiment_peopleNum + "\"},"; sb.Append(s); } if (experiments.Count != 0) { s = sb.ToString(); s = s.Substring(0, s.Length - 1); } return(s + "]}"); }