Example #1
0
        //学生提交试卷
        public static object finishExam(string token, object json)
        {
            int user_id = JwtManager.DecodeToken(token);

            NBackendContext ctx  = new NBackendContext();
            User            user = UserBiz.getUserById(ctx, user_id);

            //var body = Helper.JsonConverter.Decode(json);


            try
            {
                var body      = JsonConvert.DeserializeObject <Dictionary <string, object> >(json.ToString());
                var exam_id   = (int)(long)body["exam_id"];
                var questions = (JArray)body["questions"];

                //var _body = JsonConvert.DeserializeObject<List<object>>(questions);

                List <object> ques_ans = new List <object>();

                int total_score = 0;
                foreach (var qu in questions)
                {
                    IDictionary <string, JToken> rates = (JObject)qu;
                    // Explicit typing just for "proof" here
                    Dictionary <string, object> __body =
                        rates.ToDictionary(pair => pair.Key,
                                           pair => (object)pair.Value);

                    int question_id = ((JValue)__body["question_id"]).Value <int>();

                    string answer = ((JValue)__body["answer"]).Value <string>();

                    Question question = getQuestionById(ctx, question_id);
                    if (question.answer.Equals(answer))
                    {
                        int single_score = getScoreById(ctx, question_id, exam_id);
                        total_score += single_score;
                    }
                }

                ctx.TakesExams.Add(new TakesExam
                {
                    StudentId = user_id,
                    ExamId    = (int)exam_id,
                    score     = total_score
                });
                ctx.SaveChanges();

                return(Helper.JsonConverter.BuildResult(null));
            }
            catch (Exception e)
            {
                //throw e;
                return(Helper.JsonConverter.Error(400, "提交失败"));
            }
        }
Example #2
0
        public static object postTwi(string token, object json)
        {
            Dictionary <string, string> body = JsonConverter.Decode(json);
            NBackendContext             ctx  = new NBackendContext();
            int user_id = JwtManager.DecodeToken(token);

            //var user_id = int.Parse(body["user_id"]);
            if (UserBiz.getUserById(ctx, user_id) == null)
            {
                return(Helper.JsonConverter.Error(400, "你这个人是谁哦"));
            }

            var content = body["content"];
            var time    = body["time"];
            var image   = body["image"];

            Twitter twi = new Twitter
            {
                //TwitterId = 1,
                userId  = user_id,
                content = content,
                time    = time,
                image   = image
            };


            ctx.Twitters.Add(twi);
            try
            {
                ctx.SaveChanges();
            }
            catch (System.Data.Entity.Validation.DbEntityValidationException e)
            {
                foreach (var eve in e.EntityValidationErrors)
                {
                    Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
                                      eve.Entry.Entity.GetType().Name, eve.Entry.State);
                    foreach (var ve in eve.ValidationErrors)
                    {
                        Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
                                          ve.PropertyName, ve.ErrorMessage);
                    }
                }
                throw;
            }

            var data = new
            {
                twitter_id = twi.TwitterId,
                user_id    = twi.userId,
                image      = twi.image,
                time       = twi.time,
                content    = twi.content,
            };

            return(JsonConverter.BuildResult(data));
        }
Example #3
0
        //获取用户所有班级的所有考试
        public static List <Broadcast> _getAllExamsOfAllClass(NBackendContext ctx, string token)
        {
            int user_id = Helper.JwtManager.DecodeToken(token);

            User user = UserBiz.getUserById(ctx, user_id);

            //var isec = null;
            List <Broadcast> q1;

            if (user.role.Equals("student"))
            {
                //获取用户的所有班级
                var q = ctx.Takes.Where(take => take.StudentId == user_id).ToList().Select(take => new { take.secId, take.courseId, take.semester, take.year }).ToList();
                q1 = ctx.Broadcasts.ToList().Join(q, take => new { take.secId, take.courseId, take.semester, take.year }, sec => sec,
                                                  (bro, sec) => bro
                                                  ).Where(bro => bro.scope == SCOPE_CLASS).ToList();
            }
            else
            {
                var q = ctx.Teaches.Where(take => take.TeacherId == user_id).ToList().Select(take => new { take.SecId, take.courseId, take.semester, take.year }).ToList();
                q1 = ctx.Broadcasts.ToList().Join(q, take => new { take.courseId, take.semester, take.year }, sec => new { sec.courseId, sec.semester, sec.year },
                                                  (bro, sec) => new { bro, sec.SecId }
                                                  ).Where(bro => bro.bro.scope == SCOPE_CLASS && bro.SecId == bro.bro.secId).Select(bro => bro.bro).ToList();
            }


            //if (q.Any())
            //{
            //    var sec = q.Single();
            //}

            //var secs = q.ToList();
            //var q1 = ctx.Broadcasts.ToList().Join(q, take=> new { take.secId, take.courseId, take.semester, take.year }, sec => sec,
            //    (bro, sec) => bro
            //    ).Where(bro => bro.scope == SCOPE_CLASS).ToList();

            //.Join(ctx.Courses, bro=>bro.Course, course=>course,
            //    (bro, course) => new {bro, course.}

            List <Broadcast> all_sec_exams = new List <Broadcast>();

            foreach (var bro in q1)
            {
                all_sec_exams.Add(bro);
            }

            return(all_sec_exams);
        }
Example #4
0
        //获取班级的所有试卷基本信息
        public static object getExamsOfClass(string token, object json)
        {
            try
            {
                var body = Helper.JsonConverter.Decode(json);

                int    sec_id    = int.Parse(body["sec_id"]);
                int    course_id = int.Parse(body["course_id"]);
                string semester  = body["semester"];
                int    year      = int.Parse(body["year"]);

                NBackendContext ctx     = new NBackendContext();
                int             user_id = JwtManager.DecodeToken(token);

                User user = UserBiz.getUserById(ctx, user_id);
                if (user == null)
                {
                    return(Helper.JsonConverter.Error(400, "查无此人"));
                }

                //需要验证该学生、老师是否属于某个班级???不用,查出来的只有这个班级

                var q = ctx.Exams.Where(exam => exam.secId == sec_id &&
                                        exam.courseId == course_id && exam.semester == semester &&
                                        exam.year == year
                                        );

                var data = ListToObj(ctx, q.ToList(), user);

                if (data == null)
                {
                    return(Helper.JsonConverter.Error(400, "你好像没权限(^U^)ノ~YO"));
                }
                else
                {
                    return(Helper.JsonConverter.BuildResult(data));
                }
            }
            catch (Exception e)
            {
                return(Helper.JsonConverter.Error(400, "获取班级信息时出错"));
            }
        }
Example #5
0
        private static List <Twitter> getAllTwis(NBackendContext ctx, int user_id)
        {
            var  list = getSelfTwis(ctx, user_id);
            User user = UserBiz.getUserById(ctx, user_id);

            var q = ctx.Twitters.ToList().Join(user.following,
                                               twi => twi.userId,
                                               follow => follow.Id,
                                               (twi, follow) => twi
                                               );

            var list1 = q.ToList();

            foreach (var twi in list1)
            {
                list.Add(twi);
            }

            return(list);
        }
Example #6
0
        private static List <object> ListToObj(NBackendContext ctx, List <Twitter> list)
        {
            List <object> ret = new List <object>();

            foreach (Twitter twi in list)
            {
                User user = UserBiz.getUserById(ctx, twi.userId);
                ret.Add(new
                {
                    twitter_id = twi.TwitterId,
                    user_id    = twi.userId,
                    user_name  = user.user_name,
                    avatar     = user.avatar,
                    image      = twi.image,
                    time       = twi.time,
                    content    = twi.content,
                });
            }

            return(ret);
        }
Example #7
0
        //创建广播
        public static object postBroadcast(string token, object json)
        {
            try
            {
                var             body = JsonConverter.Decode(json);
                NBackendContext ctx  = new NBackendContext();

                int  teacher_id = JwtManager.DecodeToken(token);
                User user       = UserBiz.getUserById(ctx, teacher_id);
                if (user == null)
                {
                    return(Helper.JsonConverter.Error(400, "你还没登录?"));
                }

                int type  = int.Parse(body["type"]);
                int scope = int.Parse(body["scope"]);

                string start_time     = body["start_time"];
                string end_time       = body["end_time"];
                string published_time = body["published_time"];
                string content        = body["content"];

                //k
                int    sec_id, course_id, year;
                string semester;

                if (scope == SCOPE_CLASS)
                {
                    if (!user.role.Equals("teacher_edu"))
                    {
                        return(Helper.JsonConverter.Error(400, "你没有权限呢"));
                    }
                    sec_id    = int.Parse(body["sec_id"]);
                    course_id = int.Parse(body["course_id"]);
                    year      = int.Parse(body["year"]);
                    semester  = body["semester"];
                }
                else
                {
                    if (!user.role.Equals("teacher_manage"))
                    {
                        return(Helper.JsonConverter.Error(400, "你没有权限呢"));
                    }
                    //默认班级
                    sec_id    = 100003;
                    course_id = 2;
                    year      = 0;
                    semester  = "Spring";
                }
                Broadcast broadcast = new Broadcast
                {
                    secId    = sec_id,
                    courseId = course_id,
                    year     = year,
                    semester = semester,

                    scope        = scope,
                    type         = type,
                    start_time   = start_time,
                    publish_time = published_time,
                    end_time     = end_time,
                    content      = content
                };

                ctx.TeacherBroadcasts.Add(new TeacherBroadcast
                {
                    teacherId   = teacher_id,
                    broadcastId = broadcast.BroadcastId
                });

                ctx.Broadcasts.Add(broadcast);
                ValidationHelper.safeSaveChanges(ctx);

                var data = new
                {
                    broadcast_id = broadcast.BroadcastId
                };
                return(JsonConverter.BuildResult(data));
            }
            catch (Exception e)
            {
                return(JsonConverter.Error(400, "创建广播失败"));
            }
        }
Example #8
0
        //教师查看某场考试结果
        public static object getExamResult(string token, object json)
        {
            try
            {
                int             user_id = Helper.JwtManager.DecodeToken(token);
                NBackendContext ctx     = new NBackendContext();

                User user = UserBiz.getUserById(ctx, user_id);
                if (!user.role.Equals("teacher_edu"))
                {
                    return(Helper.JsonConverter.Error(400, "你没有权限(^U^)ノ~YO"));
                }

                var body    = Helper.JsonConverter.Decode(json);
                int exam_id = int.Parse(body["exam_id"]);

                //ToList()及时求值定位错误快点。。。
                //通过exam取出班级,再取出班级的所有人
                //真糖!
                var qstus = ctx.Exams.Join(ctx.Takes, ex => new { ex.year, ex.courseId },//最多两个键?Section又不行。。。
                                           take => new { take.Section.year, take.Section.courseId },
                                           (ex, take) => new { exam_id, take, ex.semester, ex.secId }
                                           ).Where(_ => _.take.Section.semester == _.semester && _.take.Section.SecId == _.secId && _.exam_id == exam_id).Select(_ => new { _.take.Student, _.exam_id }).ToList();
                //获得参加本场考试的学生的信息和分数
                var qstus_taken = qstus.Join(ctx.TakesExams, stu => stu.Student, te => te.Student,
                                             (stu, te) => new { stu, te.score, te.ExamId }
                                             ).Where(stu => stu.stu.exam_id == exam_id && stu.ExamId == exam_id).Select(stu_score => new { stu_score.stu.Student, stu_score.score }).ToList();

                //拿到所有学生
                var qstus_only      = qstus.Select(stu => stu.Student);
                var qstus_not_taken = qstus_only.Except(qstus_taken.Select(stu_score => stu_score.Student)).ToList();

                List <object> all_stu_score = new List <object>();
                //User student = getUserById()

                var _ex = getExamById(ctx, exam_id);
                if (_ex == null)
                {
                    return(Helper.JsonConverter.Error(404, "考试不存在"));
                }

                //判断考试是否结束
                bool exam_ended = isExamFinished(_ex);

                try
                {
                    int total_score = getTotalScore(ctx, exam_id);

                    foreach (var stu in qstus_taken)
                    {
                        int  grade = (int)(5.0 * stu.score / total_score);
                        User _user = UserBiz.getUserById(ctx, stu.Student.StudentId);
                        all_stu_score.Add(new
                        {
                            student_id   = stu.Student.StudentId,
                            student_name = _user.user_name,
                            exam_ended,
                            score = stu.score,
                            grade,
                            //total_score,
                        });
                    }


                    foreach (var stu in qstus_not_taken)
                    {
                        User _user = UserBiz.getUserById(ctx, stu.StudentId);

                        all_stu_score.Add(new
                        {
                            student_id   = stu.StudentId,
                            student_name = _user.user_name,
                            exam_ended,
                            score = 0,
                            grade = 1,
                            //total_score,
                        });
                    }
                    var data = new { scores = all_stu_score, total_score };
                    return(Helper.JsonConverter.BuildResult(data));
                }
                catch (Exception e)
                {
                    //int i;
                    return(Helper.JsonConverter.Error(400, "获取结果出错!"));
                }
            }
            catch (Exception e)
            {
                return(Helper.JsonConverter.Error(400, "查看考试结果出错,请检查提交信息"));
            }
        }
Example #9
0
        //删除、修改、提交题目全靠它
        private static object questionHelper(string token, object json, int option)
        {
            int user_id = JwtManager.DecodeToken(token);

            NBackendContext ctx  = new NBackendContext();
            User            user = UserBiz.getUserById(ctx, user_id);

            if (user == null || !user.role.Equals("teacher_edu"))
            {
                //可以再判断这个老师是不是教这个的
                return(Helper.JsonConverter.Error(400, "您未登录或者没有权限"));
            }

            var body = Helper.JsonConverter.Decode(json);

            try
            {
                //删除、修改、提交题目分发逻辑
                switch (option)
                {
                default:
                {
                    int    course_id = int.Parse(body["course_id"]);
                    string chapter   = body["chapter"];
                    string content   = body["content"];
                    string options   = body["options"];
                    string answer    = body["answer"];

                    if (option == POST)
                    {
                        var newq = new Question
                        {
                            courseId = course_id,
                            chapter  = chapter,
                            content  = content,
                            options  = options,
                            answer   = answer,
                        };
                        ctx.Questions.Add(newq);
                        ctx.SaveChanges();
                        object data = new
                        {
                            question_id = newq.QuestionId
                        };
                        return(Helper.JsonConverter.BuildResult(data));
                    }
                    else if (option == PUT)
                    {
                        int question_id = int.Parse(body["question_id"]);
                        var q           = ctx.Questions.Where(qu => qu.QuestionId == question_id);
                        if (!q.Any())
                        {
                            return(Helper.JsonConverter.Error(400, "没有这道题"));
                        }
                        else
                        {
                            Question question = q.Single();
                            question.answer  = answer;
                            question.chapter = chapter;
                            question.options = options;
                            question.content = content;
                            ctx.SaveChanges();
                        }
                    }
                    return(Helper.JsonConverter.BuildResult(null));
                }

                case DELETE:
                {
                    int question_id = int.Parse(body["question_id"]);
                    var q           = ctx.Questions.Where(qu => qu.QuestionId == question_id);
                    if (!q.Any())
                    {
                        return(Helper.JsonConverter.Error(400, "没有这道题"));
                    }
                    else
                    {
                        var qu = q.Single();
                        ctx.Questions.Remove(qu);
                        ctx.SaveChanges();
                    }

                    return(Helper.JsonConverter.BuildResult(null));
                    //break;
                }
                }
            }
            catch (Exception e)
            {
                return(Helper.JsonConverter.Error(400, "请检查您的提交信息"));
            }
        }
Example #10
0
        //获取某张试卷所有的题目,包括学生考试前后和老师查看
        public static object getQuestionsOfExam(string token, object json)
        {
            try
            {
                var body    = Helper.JsonConverter.Decode(json);
                int user_id = JwtManager.DecodeToken(token);

                int exam_id = int.Parse(body["exam_id"]);

                NBackendContext ctx = new NBackendContext();

                //连接考试表和试题表
                var q = ctx.Exams.Join(ctx.ExamQuestions,
                                       _exam => _exam.ExamId,
                                       eq => eq.examId,
                                       (_exam, eq) => eq
                                       ).Join(ctx.Questions,
                                              eq => eq.questionId,
                                              ques => ques.QuestionId,
                                              (eq, ques) => ques
                                              );

                //该试卷的所有题目
                var  quess = q.ToList();
                User user  = UserBiz.getUserById(ctx, user_id);

                if (!quess.Any())
                {
                    return(Helper.JsonConverter.Error(400, "不是考试没了就是题库崩了?"));
                }

                Exam exam = getExamById(ctx, exam_id);

                string title      = exam.title;
                string start_time = exam.start_time;
                string end_time   = exam.end_time;

                var q1 = ctx.ExamQuestions.Where(e => e.examId == exam.ExamId).Join(ctx.Questions,
                                                                                    ex => ex.questionId,
                                                                                    qu => qu.QuestionId,
                                                                                    (ex, qu) => qu
                                                                                    );
                var questions = q1.ToList();

                object        data  = null;
                List <object> qdata = new List <object>();

                if (user.role.Equals("teacher_edu"))
                {
                    foreach (var qu in questions)
                    {
                        int index = getQuestionIndex(ctx, exam_id, qu.QuestionId);
                        int score = getScoreById(ctx, qu.QuestionId, exam_id);
                        qdata.Add(new
                        {
                            question_id = qu.QuestionId,
                            course_id   = qu.courseId,
                            chapter     = qu.chapter,
                            content     = qu.content,
                            options     = qu.options,
                            answer      = qu.answer,
                            index,
                            score
                        });
                        data = new
                        {
                            questions = qdata,
                            title     = title,
                        };
                    }
                }
                else if (user.role.Equals("student"))
                {
                    var q2 = ctx.TakesExams.Where(te => te.StudentId == user_id &&
                                                  te.ExamId == exam_id
                                                  );
                    //if (!q2.Any())
                    //{
                    //    return Helper.JsonConverter.Error(400, "无效用户或考试");
                    //}

                    //var ex = q2.Single().Exam;
                    var ex = getExamById(ctx, exam_id);
                    if (ex == null)
                    {
                        return(Helper.JsonConverter.Error(400, "考试没了!"));
                    }

                    bool exam_ended = isExamFinished(ex);

                    //没参加过这场考试并且没超时
                    if (!q2.Any() && !exam_ended)
                    {
                        foreach (var qu in questions)
                        {
                            int index = getQuestionIndex(ctx, exam_id, qu.QuestionId);
                            int score = getScoreById(ctx, qu.QuestionId, exam_id);

                            qdata.Add(new
                            {
                                question_id = qu.QuestionId,
                                course_id   = qu.courseId,
                                chapter     = qu.chapter,
                                content     = qu.content,
                                options     = qu.options,
                                index,
                                score,
                            });
                        }
                        data = new
                        {
                            questions   = qdata,
                            title       = title,
                            start_time  = start_time,
                            end_time    = end_time,
                            exam_status = false,
                        };
                    }
                    else
                    {
                        foreach (var qu in questions)
                        {
                            int index = getQuestionIndex(ctx, exam_id, qu.QuestionId);
                            int score = getScoreById(ctx, qu.QuestionId, exam_id);

                            qdata.Add(new
                            {
                                question_id = qu.QuestionId,
                                course_id   = qu.courseId,
                                chapter     = qu.chapter,
                                content     = qu.content,
                                options     = qu.options,
                                answer      = qu.answer,
                                index,
                                score
                            });
                        }
                        data = new
                        {
                            questions   = qdata,
                            title       = title,
                            start_time  = start_time,
                            end_time    = end_time,
                            exam_status = true,
                            total_score = q2.Single().score
                        };
                    }
                }
                else
                {
                    return(Helper.JsonConverter.Error(400, "您没有权限(^U^)ノ~YO"));
                }

                return(Helper.JsonConverter.BuildResult(data));
            }
            catch (Exception e)
            {
                return(Helper.JsonConverter.Error(400, "题目信息获取出错,请检查对应字段"));
            }
        }
Example #11
0
        public static object examSumup(string token)
        {
            try
            {
                int user_id = JwtManager.DecodeToken(token);

                NBackendContext ctx = new NBackendContext();

                User user = UserBiz.getUserById(ctx, user_id);

                //参加的考试
                var qexam_taken = ctx.TakesExams.Where(te => te.Student.StudentId == user_id).ToList();

                //参加的课程的所有考试
                var qexam_all = ctx.Takes.Where(take => take.StudentId == user_id).Join(ctx.Exams, take => new { take.Section.SecId, take.Section.courseId },
                                                                                        exam => new { exam.Section.SecId, exam.Section.courseId }
                                                                                        , (take, exam) => new { exam, take.Section }
                                                                                        ).Where(exam_sec => exam_sec.exam.Section.year == exam_sec.Section.year && exam_sec.exam.Section.semester == exam_sec.Section.semester).ToList()
                                .Select(te => te.exam).ToList();

                //没参加的考试成绩为0
                var qexam_not_taken = qexam_all.Except(qexam_taken.Select(qt => qt.Exam)).ToList();

                int           exam_num = qexam_all.Count();
                List <object> exams    = new List <object>();

                foreach (var et in qexam_taken)
                {
                    int    grade  = 1;//等级
                    Course course = et.Exam.Course;
                    int    score  = getTotalScore(ctx, et.ExamId);
                    if (score == 0)
                    {
                        return(Helper.JsonConverter.Error(404, "找不到这张试卷"));
                    }

                    grade = (int)((float)et.score * 5 / score);

                    exams.Add(new
                    {
                        exam_id = et.ExamId,
                        course.course_name,
                        et.Exam.title,
                        grade
                    });
                }

                foreach (var ent in qexam_not_taken)
                {
                    Course course = ent.Course;
                    exams.Add(new
                    {
                        exam_id = ent.ExamId,
                        course.course_name,
                        ent.title,
                        grade = 1
                    });
                }

                var data = new
                {
                    exam_num,
                    exams
                };

                return(Helper.JsonConverter.BuildResult(data));
            }
            catch (Exception e)
            {
                return(Helper.JsonConverter.Error(400, "查看总结出错,请检查请求字段"));
            }
        }
Example #12
0
        //创建考试
        public static object postExam(string token, object json)
        {
            try
            {
                int             user_id = JwtManager.DecodeToken(token);
                NBackendContext ctx     = new NBackendContext();
                //验证该用户是否是教学的老师
                User user = UserBiz.getUserById(ctx, user_id);
                if (user == null || user.role != "teacher_edu")
                {
                    return(Helper.JsonConverter.Error(400, "该用户没有权限创建试卷"));
                }

                //var body = Helper.JsonConverter.Decode(json);
                var body = JsonConvert.DeserializeObject <Dictionary <string, object> >(json.ToString());

                int    sec_id    = (int)(long)body["sec_id"];
                int    course_id = (int)(long)body["course_id"];
                string semester  = (string)body["semester"];
                int    year      = (int)(long)body["year"];

                string scope = (string)body["scope"];
                string type  = (string)body["type"];

                string start_time = (string)body["start_time"];
                string end_time   = (string)body["end_time"];
                string title      = (string)body["title"];

                //NBackendContext ctx = new NBackendContext();
                //创建考试第一步
                Exam exam = new Exam
                {
                    secId      = sec_id,
                    courseId   = course_id,
                    semester   = semester,
                    year       = year,
                    scope      = scope,
                    type       = type2Id(type),
                    start_time = start_time,
                    end_time   = end_time,
                    title      = title,
                };

                ctx.Exams.Add(exam);

                var questions = (JArray)body["questions"];


                foreach (var qu in questions)
                {
                    IDictionary <string, JToken> rates = (JObject)qu;
                    // Explicit typing just for "proof" here
                    Dictionary <string, object> __body =
                        rates.ToDictionary(pair => pair.Key,
                                           pair => (object)pair.Value);

                    int question_id = ((JValue)__body["question_id"]).Value <int>();


                    int single_score = ((JValue)__body["score"]).Value <int>();
                    int index        = ((JValue)__body["index"]).Value <int>();

                    //if (questions.Select(_qu=>_qu.).Contains(question_id))
                    //{
                    ctx.ExamQuestions.Add(new ExamQuestion
                    {
                        examId     = exam.ExamId,
                        questionId = question_id,
                        score      = single_score,
                        index      = index,
                    });
                    //}
                    //else
                    //{
                    //    //有一道题找不到?
                    //}
                }

                //创建考试第二步
                //int exam_id = exam.ExamId;
                //string _quess = body["questions"];

                //var quess = JsonConvert.DeserializeObject<List<object>>(_quess);

                //var questions = ctx.Questions.Select(qu => qu.QuestionId).ToList();
                //foreach (object obj in quess)
                //{
                //    var _body = Helper.JsonConverter.Decode(obj);
                //    int question_id = int.Parse(_body["question_id"]);
                //    int single_score = int.Parse(_body["score"]);
                //    int index = int.Parse(_body["index"]);

                //    if (questions.Contains(question_id))
                //    {
                //        ctx.ExamQuestions.Add(new ExamQuestion
                //        {
                //            examId = exam_id,
                //            questionId = question_id,
                //            score = single_score,
                //            index = index,
                //        });
                //    }
                //    else
                //    {
                //        //有一道题找不到?
                //    }
                //}


                ctx.SaveChanges();

                var data = new
                {
                    //exam_id
                };
                return(Helper.JsonConverter.BuildResult(data));
            }
            catch (Exception e)
            {
                return(Helper.JsonConverter.Error(400, "创建考试时出错"));
            }
        }