public ActionResult Create(string questions, int userId, string title)
        {
            List<QuestionModel> qmodels = JsonConvert.DeserializeObject<List<QuestionModel>>(questions);
            Questionnaire Questionnaire = new Questionnaire { Title = title, UserID = userId, Time = DateTime.Now };
            db.Questionnaires.Add(Questionnaire);
            int result = 0;
            foreach (var model in qmodels)
            {
                Question question = new Question { QuestionnaireID = Questionnaire.ID, Title = model.Title, Time = DateTime.Now, IsBlank = false, IsMulSelect = false };
                db.Questions.Add(question);

                SysAnswer sysAnswer1 = new SysAnswer();
                sysAnswer1.Content = model.Q1;
                sysAnswer1.QuestionID = question.ID;

                SysAnswer sysAnswer2 = new SysAnswer();
                sysAnswer2.Content = model.Q2;
                sysAnswer2.QuestionID = question.ID;

                SysAnswer sysAnswer3 = new SysAnswer();
                sysAnswer3.Content = model.Q3;
                sysAnswer3.QuestionID = question.ID;

                SysAnswer sysAnswer4 = new SysAnswer();
                sysAnswer4.Content = model.Q4;
                sysAnswer4.QuestionID = question.ID;

                db.SysAnswers.Add(sysAnswer1);
                db.SysAnswers.Add(sysAnswer2);
                db.SysAnswers.Add(sysAnswer3);
                db.SysAnswers.Add(sysAnswer4);

                result= db.SaveChanges();
            }

            if (result > 0)
            {
                var context = GlobalHost.ConnectionManager.GetHubContext<QuestionnarieHub>();//得到Signalr context
                context.Clients.All.GetNew(Questionnaire);  //将新上传的资源广播到全部客户端
                return Content("ok");
            }
            else
            {
                return Content("fail");
            }
        }
        /// <summary>
        /// 根据问卷的ID生成问卷
        /// </summary>
        /// <param name="qid"></param>
        /// <returns></returns>
        public ActionResult GetQuestionnarie(int qid)
        {
            Questionnaire Questionnaire = new Questionnaire();
            Questionnaire = db.Questionnaires.Find(qid);
            if (Questionnaire != null)
            {
                List<Question> questions = new List<Question>();
                List<QuestionReturnModel> questonModels = new List<QuestionReturnModel>();
                questions = db.Questions.Where(q => q.QuestionnaireID == qid).ToList();
                foreach (var model in questions)
                {
                    List<SysAnswer> answers = new List<SysAnswer>();
                    QuestionReturnModel questionModel = new QuestionReturnModel();
                    answers = db.SysAnswers.Where(sa => sa.QuestionID == model.ID).ToList();

                    questionModel.Title = model.Title;
                    questionModel.ID = model.ID;
                    questionModel.Q1 = answers[0].Content;
                    questionModel.Q2 = answers[1].Content;
                    questionModel.Q3 = answers[2].Content;
                    questionModel.Q4 = answers[3].Content;
                    questonModels.Add(questionModel);
                }
                QuestionnarieReturnModel Qrm = new QuestionnarieReturnModel();
                Qrm.ID = Questionnaire.ID;
                Qrm.UserID = Questionnaire.UserID;
                Qrm.Time = Questionnaire.Time.ToString();
                Qrm.Title = Questionnaire.Title;
                Qrm.Questions = questonModels;
                return Json(Qrm);
            }
            else
            {
                return Content("noexist");
            }
        }
 public ActionResult TongJi(int qid)
 {
     List<TjQuestion> questions = new List<TjQuestion>();
     List<TJSubmitQuestion> tjquestions = new List<TJSubmitQuestion>();
     Questionnaire questionnarie = new Questionnaire();
     questionnarie = db.Questionnaires.Find(qid);
     var uas = db.UserAnswers.Where(ua => ua.QuestionnaireID == qid).ToList();
     foreach (var ua in uas)
     {
         tjquestions = JsonConvert.DeserializeObject<List<TJSubmitQuestion>>(ua.Content);
         foreach (var tq in tjquestions)
         {
             var question = questions.Where(q => q.Id == tq.Id).FirstOrDefault();
             if (question == null)
             {
                 TjQuestion _question = new TjQuestion();
                 _question.Id = tq.Id;
                 _question.Title = db.Questions.Where(q => q.QuestionnaireID == qid).ToList()[tq.Id - 1].Title;
                 if (tq.Answer == 1)
                 {
                     _question.A1++;
                 }
                 if (tq.Answer == 2)
                 {
                     _question.A2++;
                 }
                 if (tq.Answer == 3)
                 {
                     _question.A3++;
                 }
                 if (tq.Answer == 4)
                 {
                     _question.A4++;
                 }
                 questions.Add(_question);
             }
             else
             {
                 if (tq.Answer == 1)
                 {
                     question.A1++;
                 }
                 if (tq.Answer == 2)
                 {
                     question.A2++;
                 }
                 if (tq.Answer == 3)
                 {
                     question.A3++;
                 }
                 if (tq.Answer == 4)
                 {
                     question.A4++;
                 }
             }
         }
     }
     TjQuestionnarie TjQuestionnarie = new TjQuestionnarie();
     TjQuestionnarie.ID = qid;
     TjQuestionnarie.Title = questionnarie.Title;
     TjQuestionnarie.Questions = questions;
     return Json(TjQuestionnarie);
 }