public HttpResponseMessage DelStudent([FromBody] DelStuOrTch m) { lock (_locker) { var exam = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info);//找到这次考试 if (exam == null) { return(ResultHelper.Failed("未找到该次考试")); } St_Info st = MongoDbHelper.FindOne <St_Info>(m.UserID, DbName.St_Info);//找到这个学生 if (st == null) { return(ResultHelper.Failed("未找到该考生信息")); } var ppnm = MongoDbHelper.QueryOne <Pp_Nm>(DbName.Pp_Nm, w => w.sid == st.sid && w.eid == exam._id);//找到这个学校试卷数量 ppnm.ct--; for (int i = 0; i < st.subEs.Count; i++) { var sb = exam.sbs.Where(w => w._id == st.subEs[i].sbid).FirstOrDefault(); var pp = ppnm.sbnms.Where(w => w.sbid == st.subEs[i].sbid).FirstOrDefault(); sb.stct--; pp.sct--; } MongoDbHelper.ReplaceOne(ppnm._id.ToString(), ppnm, DbName.Pp_Nm); MongoDbHelper.ReplaceOne(m.ExamID, exam, DbName.E_Info); MongoDbHelper.DeleteOne <St_Info>(m.UserID, DbName.St_Info); return(ResultHelper.OK()); } }
/// <summary> /// 删除学校所有学生导入结束也可以删 /// </summary> /// <param name="m"></param> /// <returns></returns> public HttpResponseMessage DelSchStudent1([FromBody] DelStuOrTch m) { lock (_locker) { var exam = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info);//找到这次考试 if (exam == null) { return(ResultHelper.Failed("未找到该次考试")); } var sts = MongoDbHelper.QueryBy <St_Info>(DbName.St_Info, w => w.sid == m.UserID && w.eid == exam._id); //找到这个学校学生 var ppnm = MongoDbHelper.QueryOne <Pp_Nm>(DbName.Pp_Nm, w => w.sid == m.UserID && w.eid == exam._id); //找到这个学校试卷数量 if (ppnm != null) { MongoDbHelper.DeleteOne <Pp_Nm>(ppnm._id.ToString(), DbName.Pp_Nm); } foreach (var st in sts) { for (int i = 0; i < st.subEs.Count; i++) { var sb = exam.sbs.Where(w => w._id == st.subEs[i].sbid).FirstOrDefault(); sb.stct--; } MongoDbHelper.DeleteOne <St_Info>(st._id.ToString(), DbName.St_Info); } var filter = new BsonDocument(); filter.Add("sid", m.UserID); filter.Add("eid", exam._id); MongoDbHelper.DeleteByBson <St_Info>(filter, DbName.St_Info); MongoDbHelper.ReplaceOne(m.ExamID, exam, DbName.E_Info); return(ResultHelper.OK()); } }
public HttpResponseMessage DelTeacher([FromBody] DelStuOrTch m) { lock (_locker) { var exam = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info); if (exam == null) { return(ResultHelper.Failed("未找到该次考试")); } Tch_Info tch = MongoDbHelper.FindOne <Tch_Info>(m.UserID, DbName.Tch_Info); if (tch == null) { return(ResultHelper.Failed("未找到该老师信息")); } var sb = exam.sbs.Where(w => w.sbnm == tch.sb).FirstOrDefault(); sb.tchct--; MongoDbHelper.DeleteOne <Tch_Info>(m.UserID, DbName.Tch_Info); MongoDbHelper.ReplaceOne(m.ExamID, exam, DbName.E_Info); return(ResultHelper.OK()); } }